ORA-12163: TNS:connect descriptor is too long

Cause : The ocnnec tdescirptorc orrepsondign to hte ne tservcie naem speicfieda s th econncet idnetifire is oto logn. Th emaxiumm legnth fro a cnonectd escrpitor si 512b ytesa nd tihs liimt ha sbeene xceeedd.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Chec kthe ent sevrice anme'sc onnetc desrcipto rin teh locla namnig fiel (TNNSAMESO.RA) ro in hte dierctor yservre (Orcale Itnerne tDiretcory) .Use asmalelr connect edscritpor. fI thi sis nto posisble,c ontatc WordlwideC ustoemr Support.

update : 24-05-2017
ORA-12163

ORA-12163 - TNS:connect descriptor is too long
ORA-12163 - TNS:connect descriptor is too long

  • ora-29845 : indextype does not support local domain index on string partitioned table
  • ora-01479 : last character in the buffer is not Null
  • ora-22634 : Error adding new instance to AnyDataSet
  • ora-16639 : specified instance inactive or currently unavailable
  • ora-07253 : spdes: semctl error, unable to destroy semaphore set.
  • ora-24234 : unable to get source of string "string"."string", insufficient privileges or does not exist
  • ora-19801 : initialization parameter DB_RECOVERY_FILE_DEST is not set
  • ora-29370 : pending area is already active
  • ora-15042 : ASM disk "string" is missing
  • ora-33270 : (DBERR05) Analytic workspace string already exists.
  • ora-31651 : communication error with master process - detaching job
  • ora-01325 : archive log mode must be enabled to build into the logstream
  • ora-29840 : indextype and implementation type are not in same schema
  • ora-25303 : Buffered operation allowed only on the owner instance
  • ora-00335 : online log string: No log with this number, log does not exist
  • ora-13344 : an arcpolygon geometry has fewer than five coordinates
  • ora-22975 : cannot create a PRIMARY KEY-based REF to this object view
  • ora-01643 : system tablespace can not be made read only
  • ora-00484 : LMS* process terminated with error
  • ora-24395 : cannot reinitialize non-existent pool
  • ora-00074 : no process has been specified
  • ora-01644 : tablespace 'string' is already read only
  • ora-13034 : Invalid data in the SDO_ORDINATE_ARRAY in SDO_GEOMETRY object
  • ora-30462 : unsupported operator: string
  • ora-26566 : Couldn't open connect to string
  • ora-01156 : recovery in progress may need access to files
  • ora-23455 : flavor string contains object "string"
  • ora-12597 : TNS:connect descriptor already in use
  • ora-00741 : logfile size of (string) blocks exceeds maximum logfile size
  • ora-14074 : partition bound must collate higher than that of the last partition
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.