ORA-12233: TNS:Failure to accept a connection

Cause : This reror i sreporetd by na intecrhangew hich afils t oaccep ta conenctiond ue toa redierct faliure.

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

Repor tthe porblem ot yourN etwor kAdminsitrato rso thta he mya isoltae thei ntercahnge porblem.

update : 26-05-2017
ORA-12233

ORA-12233 - TNS:Failure to accept a connection
ORA-12233 - TNS:Failure to accept a connection

  • ora-13117 : [string]_RELATION$ table does not exist
  • ora-22289 : cannot perform string operation on an unopened file or LOB
  • ora-22634 : Error adding new instance to AnyDataSet
  • ora-02156 : invalid TEMPORARY tablespace identifier
  • ora-12701 : CREATE DATABASE character set is not known
  • ora-24196 : access the message in a wrong access mode
  • ora-02314 : illegal use of type constructor
  • ora-16227 : DDL skipped due to missing object
  • ora-16045 : circular archive log destination dependency chain
  • ora-38465 : failed to create the privilege checking trigger due to: string
  • ora-12089 : cannot online redefine table "string"."string" with no primary key
  • ora-09218 : sfrfs: failed to refresh file size
  • ora-14130 : UNIQUE constraints mismatch in ALTER TABLE EXCHANGE PARTITION
  • ora-25427 : cannot downgrade database links after database link data dictionary has been upgraded
  • ora-02153 : invalid VALUES password string
  • ora-37183 : illegal value string for PARTBY
  • ora-34177 : (MXCHGDCL19) number cannot be deleted because one or more partitioned variables instantiate it.
  • ora-03200 : the segment type specification is invalid
  • ora-08101 : index key does not exist file string: (root string, node string) blocks (string)
  • ora-25242 : cannot change subscriber name from string to string without FIRST_MESSAGE option
  • ora-19203 : Error occurred in DBMS_XMLGEN processingstring
  • ora-07207 : sigpidu: process ID string overflows internal buffer.
  • ora-23444 : duplicate template parameter
  • ora-12170 : TNS:Connect timeout occurred
  • ora-01118 : cannot add any more database files: limit of string exceeded
  • ora-31037 : Invalid XML attribute name string
  • ora-24168 : rule string.string cannot have default evaluation context
  • ora-24393 : invalid mode for creating connection pool
  • ora-29522 : authorization error for referenced name string.string
  • ora-31653 : unable to determine job operation for privilege check
  • 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.