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 : 25-04-2017
ORA-12233

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

  • ora-13196 : failed to compute supercell for element string.string.string
  • ora-13193 : failed to allocate space for geometry
  • ora-09793 : szguns: length of user name is greater than buffer.
  • ora-38860 : cannot FLASHBACK DATABASE during instantiation of a logical standby
  • ora-02430 : cannot enable constraint (string) - no such constraint
  • ora-00567 : Requested processor group string is too large (maximum string)
  • ora-28048 : database is a member of multiple enterprise domains in OID
  • ora-32811 : subscriber string already exists
  • ora-13190 : recursive SQL fetch failed
  • ora-01627 : rollback segment number 'string' is not online
  • ora-13600 : error encountered in Advisor string
  • ora-08454 : more than one S symbol specified in picture mask
  • ora-01147 : SYSTEM tablespace file string is offline
  • ora-19593 : datafile number string already included as string
  • ora-07427 : spstp: cannot change directory to dbs.
  • ora-00026 : missing or invalid session ID
  • ora-30189 : reserved for future use
  • ora-01159 : file is not from same database as previous files - wrong database id
  • ora-23300 : %s
  • ora-00822 : MMAN process terminated with error
  • ora-32012 : failure in processing system parameters from restored SPFILE
  • ora-13610 : The directive string does not exist for task string.
  • ora-01113 : file string needs media recovery
  • ora-27010 : skgfwrt: write to file failed
  • ora-28528 : Heterogeneous Services datatype conversion error
  • ora-07760 : slemtr: $open failure
  • ora-12856 : cannot run parallel query on a loopback connection
  • ora-38503 : index already defined using the parameters
  • ora-22926 : specified trim length is greater than current LOB value's length
  • ora-25221 : enqueue failed, signature specified queue not supporting non-repudiation
  • 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.