ORA-12231: TNS:No connection possible to destination

Cause : This error is reported by an interchange which fails to find a possible connection along the path to the destination.

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

Report the problem to your Network Administrator so that he may fix the problem.

update : 29-06-2017
ORA-12231

ORA-12231 - TNS:No connection possible to destination
ORA-12231 - TNS:No connection possible to destination

  • ora-27094 : raw volume used can damage partition table
  • ora-14121 : MODIFY DEFAULT ATTRIBUTES may not be combined with other operations
  • ora-40202 : column string does not exist in the input table string
  • ora-24803 : illegal parameter value in lob read function
  • ora-15012 : ASM file 'string' does not exist
  • ora-12326 : database string is closing immediately; no operations are permitted
  • ora-30176 : invalid format code used in the format string
  • ora-19673 : error during proxy file string
  • ora-13467 : unsupported GeoRaster metadata specification: string
  • ora-19323 : Invalid url string
  • ora-37105 : (XSVPART05) Only variables dimensioned by a CONCAT PARTITION TEMPLATE can have string partitions.
  • ora-19656 : cannot backup, copy, or delete online log string
  • ora-00292 : parallel recovery feature not installed
  • ora-00074 : no process has been specified
  • ora-14134 : indexes cannot use both DESC and REVERSE
  • ora-01941 : SEQUENCE keyword expected
  • ora-09786 : sllfop: open error, unable to open file.
  • ora-24503 : codepoint length overflows for piecewise operation
  • ora-21709 : cannot refresh an object that has been modified
  • ora-25455 : evaluation error for rule set: string.string, evaluation context: string.string
  • ora-00824 : cannot set sga_target due to existing internal settings, see alert log for more information
  • ora-09319 : slgtd: unable to obtain the current date and time
  • ora-19724 : snapshot too old: snapshot time is before file string plug-in time
  • ora-16749 : resource guard encountered errors in switchover to logical primary database
  • ora-04931 : unable to set initial sequence number value
  • ora-00166 : remote/local nesting level is too deep
  • ora-33012 : (XSAGDNGL05) AGGMAP workspace object contains invalid syntax.
  • ora-06124 : NETTCP: timeout waiting for ORASRV
  • ora-16094 : database shutdown during archival operation
  • ora-07647 : sszfck: $OPEN failure
  • 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.