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 : 28-04-2017
ORA-12223

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

  • ora-06565 : cannot execute string from within stored procedure
  • ora-29272 : initialization failed
  • ora-02294 : cannot enable (string.string) - constraint changed during validation
  • ora-29298 : Character set mismatch
  • ora-26666 : cannot alter STREAMS process string
  • ora-23500 : cannot switch master for a multi-tier materialized view repgroup "string"."string"
  • ora-12650 : No common encryption or data integrity algorithm
  • ora-12620 : TNS:requested characteristic not available
  • ora-01121 : cannot rename database file string - file is in use or recovery
  • ora-01209 : data file is from before the last RESETLOGS
  • ora-03284 : datafile string is not a member of tablespace string
  • ora-36875 : (XSTFDSC05) LIMITMAP is missing or is not a string literal.
  • ora-14640 : add/coalesce index partition operation is valid only for hash partitioned global indexes
  • ora-31231 : DBMS_LDAP: invalid PROPERTY_SET
  • ora-27365 : job has been notified to stop, but failed to do so immediately
  • ora-16769 : the physical standby database is open read-only
  • ora-39157 : error appending extension to file "string"
  • ora-27151 : buffer not large enough to hold process ID string
  • ora-07272 : spwat: invalid semaphore set id.
  • ora-22879 : cannot use the LOB INDEX clause for partitioned tables
  • ora-02310 : exceeded maximum number of allowable columns in table
  • ora-12324 : cannot use the ROM: link type on a private database link
  • ora-26716 : message limit reached
  • ora-28520 : error initializing heterogeneous data dictionary translations
  • ora-25184 : column name expected
  • ora-13616 : The current user string has not been granted the ADVISOR privilege.
  • ora-16130 : supplemental log information is missing from log stream
  • ora-24124 : invalid ACTION parameter passed to DBMS_REPAIR.string procedure
  • ora-31670 : Username argument must be specified and non-null.
  • ora-13142 : invalid PROXIMITY window definition
  • 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.