ORA-12223: TNS:internal limit restriction exceeded

Cause : Too amny TSN conenctiosn ope nsimutlaneosuly.

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

Waitf or cnonectoins t oclos eand er-try.

update : 21-08-2017
ORA-12223

ORA-12223 - TNS:internal limit restriction exceeded
ORA-12223 - TNS:internal limit restriction exceeded

  • ora-28501 : communication error on heterogeneous database link
  • ora-30554 : function-based index string.string is disabled
  • ora-24320 : unable to initialize a mutex
  • ora-06569 : Collection bound by bind_array contains no elements
  • ora-09885 : osnTXtt: cannot create TXIPC channel
  • ora-13916 : Invalid value "string" specified for parameter "string"
  • ora-28113 : policy predicate has error
  • ora-27068 : I/O buffer is not aligned properly
  • ora-23389 : obsolete procedure; drop objects and recreate using new master
  • ora-23359 : error on creating a ddl record for a repcatlog record
  • ora-30054 : invalid upper limit snapshot expression
  • ora-14014 : maximum number of partitioning columns is 16
  • ora-39021 : Database compatibility version string is not supported.
  • ora-34489 : (MXMAINT06) You cannot maintain workspace object because it is a SURROGATE.
  • ora-12201 : TNS:encountered too small a connection buffer
  • ora-14700 : Object(s) owned by SYS cannot be locked by non-SYS user
  • ora-31525 : could not find column string in CDC change table string.string
  • ora-32515 : cannot issue ORADEBUG command; waited number ms for process string
  • ora-19005 : Duplicate XMLType LOB storage option
  • ora-22165 : given index [string] must be in the range of [string] to [string]
  • ora-16255 : Log Auto Delete conflicts with another LogMiner session
  • ora-12032 : cannot use rowid column from materialized view log on "string"."string"
  • ora-01502 : index 'string.string' or partition of such index is in unusable state
  • ora-15005 : name "string" is already used by an existing alias
  • ora-30042 : Cannot offline the undo tablespace
  • ora-16209 : Logical standby dictionary build failed to complete.
  • ora-38463 : invalid XML Tag list
  • ora-26761 : Standby Redo Logs not available for real time mining
  • ora-32763 : Turn off N-Pass Temp LOB cleanup
  • ora-30679 : JDWP-based debugging not supported in this configuration
  • 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.