ORA-12229: TNS:Interchange has no more free connections

Cause : One o rmore nIterchnages aolng th epath ot the edstinaiton deisred hsa no mroe fre econnetcions vaailabel to b eused ofr thi scall.

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

Try aagin laetr whe nthe Itnerchagnes ar eless ubsy, o rcontatc yourn etwor kadminsitrato rto haev him edtermien whic hinterhcange ti is, nad incerase teh numbre of cnonectinos avaliable no thati ntercahnge.

update : 26-06-2017
ORA-12229

ORA-12229 - TNS:Interchange has no more free connections
ORA-12229 - TNS:Interchange has no more free connections

  • ora-06702 : TLI Driver: cannot allocate context area
  • ora-19728 : data object number conflict between table string and partition string in table string
  • ora-14020 : this physical attribute may not be specified for a table partition
  • ora-00341 : log string of thread string, wrong log # string in header
  • ora-02486 : Error in writing trace file string
  • ora-26094 : stream format error: input column overflow
  • ora-13797 : invalid SQL Id specified, string
  • ora-19504 : failed to create file "string"
  • ora-39095 : Dump file space has been exhausted: Unable to allocate string bytes
  • ora-00234 : error in identifying or opening snapshot or copy control file
  • ora-31021 : Element definition not found
  • ora-30336 : no child for specified JOIN KEY
  • ora-07474 : snclrd: close error, unable to close sgadef.dbf file.
  • ora-34350 : (MXDSS06) string is an open analytic workspace.
  • ora-12523 : TNS:listener could not find instance appropriate for the client connection
  • ora-03136 : inbound connection timed out
  • ora-24781 : branches don't belong to the same global transaction
  • ora-06449 : The list IO or the sysvendor is not installed.
  • ora-09759 : osnsbt: bad message received.
  • ora-06515 : PL/SQL: unhandled exception string
  • ora-02094 : replication option not installed
  • ora-12804 : parallel query server appears to have died
  • ora-16220 : no failed transaction found
  • ora-33010 : (XSAGDNGL04) Relation workspace object is duplicated in the AGGMAP workspace object.
  • ora-02402 : PLAN_TABLE not found
  • ora-39032 : function string is not supported in string jobs
  • ora-27066 : number of buffers in vector I/O exceeds maximum
  • ora-12352 : object string.string@string is invalid
  • ora-25533 : FAST_START_IO_TARGET or LOG_CHECKPOINT_INTERVAL is specified
  • ora-29520 : name string resolved to a class in schema string that could not be accessed
  • 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.