ORA-12232: TNS:No path available to destination

Cause : This error is reported by an interchange which fails to find a possible 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 : 27-06-2017
ORA-12232

ORA-12232 - TNS:No path available to destination
ORA-12232 - TNS:No path available to destination

  • ora-13530 : invalid TOPNSQL string, must be in the range (string, string)
  • ora-07259 : spdcr: exec error, detached process failed in startup.
  • ora-13422 : invalid model coordinate parameter
  • ora-00113 : protocol name string is too long
  • ora-13786 : missing SQL text of statement object "string" for tuning task "string"
  • ora-12005 : may not schedule automatic refresh for times in the past
  • ora-01685 : max # extents (string) reached in index string.string partition string
  • ora-38787 : Creating the first guaranteed restore point requires mount mode when flashback database is off.
  • ora-01854 : julian date must be between 1 and 5373484
  • ora-10640 : Operation not permitted during SYSTEM tablespace migration
  • ora-29876 : failed in the execution of the ODCIINDEXDELETE routine
  • ora-14403 : cursor invalidation detected after getting DML partition lock
  • ora-02224 : EXECUTE privilege not allowed for tables
  • ora-02845 : Invalid value for the timing wanted flag
  • ora-30754 : column or table string stores objects of only one type
  • ora-29285 : file write error
  • ora-38716 : Must supply an integer for the TYPE option.
  • ora-38609 : FI Not enough memory for tree counting, requires at least stringKB
  • ora-29819 : cannot associate default values with columns
  • ora-25210 : invalid value for RELATIVE_MSGID, no message in queue with that msgid
  • ora-37039 : (XSMLTDCL05) You cannot maintain triggers in analytic workspace string because it is attached in MULTI mode.
  • ora-27480 : window "string" is currently open
  • ora-14307 : partition contains too many list values
  • ora-03236 : max # extents (string) reached in index string.string subpartition string
  • ora-07206 : slgtd: gettimeofday error, unable to obtain time.
  • ora-02467 : Column referenced in expression not found in cluster definition
  • ora-13917 : Posting system alert with reason_id string failed with code [string] [string]
  • ora-19229 : XP0009 - schema import not supported
  • ora-31100 : XDB Locking Internal Error
  • ora-06446 : ssvpstevrg: Failed with unexpected error number.
  • 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.