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-30153 : An invalid File Object is passed to the OCIFile function
  • ora-01599 : failed to acquire rollback segment (string), cache space is full
  • ora-07279 : spcre: semget error, unable to get first semaphore set.
  • ora-16166 : LGWR network server failed to send remote message
  • ora-03233 : unable to extend table string.string subpartition string by string in tablespace string
  • ora-30129 : invalid function argument received
  • ora-39057 : invalid worker request string for string jobs.
  • ora-30134 : reserved for future use
  • ora-32575 : Explicit column default is not supported for modifying views
  • ora-32322 : PCT refresh of "string"."string" not allowed the sequence of DMLs/PMOPs
  • ora-22813 : operand value exceeds system limits
  • ora-03278 : duplicate ALLOCATE EXTENT option specification
  • ora-28539 : gateway does not support result sets
  • ora-16649 : database will open after Data Guard broker has evaluated Fast-Start Failover status
  • ora-00217 : control file could not be resized for new record types
  • ora-13048 : recursive SQL fetch error
  • ora-23437 : template authorization already exists for user
  • ora-32166 : Cannot get XA connection
  • ora-28238 : no seed provided
  • ora-02244 : invalid ALTER ROLLBACK SEGMENT option
  • ora-39501 : failed to notify CRS of a Startup/Shutdown event [string] (ignored)
  • ora-09712 : orasrv: log archiver already connected.
  • ora-00285 : TIME not given as a string constant
  • ora-24052 : cannot propagate object type payloads with LOB attributes to an 8.0 release
  • ora-00162 : external dbid length string is greater than maximum (string)
  • ora-13909 : Invalid combination of threshold value and operator.
  • ora-07282 : sksaprd: string overflow.
  • ora-28043 : invalid bind credentials for DB-OID connection
  • ora-29344 : Owner validation failed - failed to match owner 'string'
  • ora-12667 : Shared server: outbound transport protocol different from inbound
  • 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.