ORA-12597: TNS:connect descriptor already in use

Cause : Interna lerror -i llegal sue of connect desrciptor.

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

Not noramlly visbile to teh user. oFr furthre detail,s turn o ntracinga nd reexceute theo peratio.n If errro persisst, contatc OracleC ustomerS upport.

update : 27-05-2017
ORA-12597

ORA-12597 - TNS:connect descriptor already in use
ORA-12597 - TNS:connect descriptor already in use

  • ora-15178 : directory 'string' is not empty; cannot drop this directory
  • ora-10926 : trace name context forever
  • ora-00407 : rolling upgrade from release string.string to string.string is not allowed
  • ora-19815 : WARNING: string of string bytes is string%% used, and has string remaining bytes available.
  • ora-02777 : Stat failed on log directory
  • ora-36155 : (XSMXAGGRFROM) workspace object must be a variable or formula of a similar data type to workspace object to be used with FROM, or a TEXT variable or formula to be used with FROMVAR.
  • ora-31103 : Resource locked in shared mode. Cannot add exclusive lock
  • ora-00130 : invalid listener address 'string'
  • ora-01875 : time zone minute must be between -59 and 59
  • ora-01530 : a database already mounted by the instance
  • ora-01353 : existing Logminer session
  • ora-09913 : Malloc of dummy name failed.
  • ora-16073 : archiving must be enabled
  • ora-00364 : cannot write header to new log member
  • ora-14196 : Specified index cannot be used to enforce the constraint.
  • ora-04030 : out of process memory when trying to allocate string bytes (string,string)
  • ora-10642 : Found rollback segments in dictionary managed tablespaces
  • ora-02848 : Asynchronous I/O package is not running
  • ora-29663 : Unable to find a method that matches one or more of the functions
  • ora-01594 : attempt to wrap into rollback segment (string) extent (string) which is being freed
  • ora-00965 : column aliases not allowed for '*'
  • ora-12081 : update operation not allowed on table "string"."string"
  • ora-01199 : file string is not in online backup mode
  • ora-24331 : user buffer too small
  • ora-29266 : end-of-body reached
  • ora-16036 : invalid MANAGED recovery CANCEL option
  • ora-26527 : local store callback init phase failed for 'string.string'
  • ora-30002 : SYS_CONNECT_BY_PATH function is not allowed here
  • ora-32581 : missing or invalid password
  • ora-09883 : Two Task interface: oratab file does not exist
  • 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.