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 : 17-08-2017
ORA-12231

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

  • ora-23421 : job number string is not a job in the job queue
  • ora-31508 : invalid parameter value for synchronous change set
  • ora-24399 : invalid number of connections specified
  • ora-16162 : Cannot add new standby databases to protected configuration
  • ora-08343 : srclose: failed to close a redo server connection
  • ora-24851 : failed to connect to shared subsystem
  • ora-24786 : separated transaction has been completed
  • ora-28105 : cannot create security relevant column policy in an object view
  • ora-24431 : Statement does not exist in the cache
  • ora-25306 : Cannot connect to buffered queue's owner instance
  • ora-24170 : %s.string is created by AQ, cannot be dropped directly
  • ora-29760 : instance_number parameter not specified
  • ora-12690 : Server Authentication failed, login cancelled
  • ora-34487 : (MXMAINT08) You cannot string values of non-unique concat dimension workspace object.
  • ora-23602 : Invalid streams process type string
  • ora-15152 : cluster in rolling upgrade
  • ora-01037 : maximum cursor memory exceeded
  • ora-08465 : input mask contains more than 32 characters
  • ora-24412 : Cannot reinitialize non-existent pool
  • ora-25235 : fetched all messages in current transaction
  • ora-27417 : BYWEEKNO clause is only supported when FREQ=YEARLY
  • ora-01198 : must specify size for log file if RESETLOGS
  • ora-01858 : a non-numeric character was found where a numeric was expected
  • ora-30014 : operation only supported in Automatic Undo Management mode
  • ora-01060 : array binds or executes not allowed
  • ora-09889 : osnTXtt: access error on oracle executable
  • ora-25293 : Lob attributes must be null for buffered operations
  • ora-02347 : cannot grant privileges on columns of an object table
  • ora-23443 : missing template parameter
  • ora-39064 : unable to write to the log file
  • 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.