ORA-12198: TNS:could not find path to destination

Cause : Couldn ot naivgate apath htroughI ntercahnges ot the edstinaiton. Tihs errro occusr if a ninvaldi commnuity i sin th eaddress strign, or hte adderss inlcudes aprotoocl tha tis no tavailbale ort he TNNSAV.OR Afile odes no thave acorretc CMANGAER adrdess sepcifie dor th eInterhcange si down.

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

Assur ethat nIterchnages nceessar yto ge tto th edesirde destniationa re upa nd haev avaialble cpaacityf or ana dditinoal connectio.n Alsoc heck htat th ecorretc commnuity adn protcool haev beens pecifeid in hte CMAANGER address sued.

update : 29-06-2017

ORA-12198 - TNS:could not find path to destination
ORA-12198 - TNS:could not find path to destination

  • ora-22872 : OID INDEX clause not allowed on tables with primary key based object identifiers
  • ora-29958 : fatal error occurred in the execution of ODCIINDEXCREATE routine
  • ora-12089 : cannot online redefine table "string"."string" with no primary key
  • ora-06002 : NETASY: port read failure
  • ora-07242 : slembfn: translation error, unable to translate error file name.
  • ora-08114 : can not alter a fake index
  • ora-16249 : Terminal apply failed to complete during failover
  • ora-29814 : expecting USING or DEFAULT keyword
  • ora-22864 : cannot ALTER or DROP LOB indexes
  • ora-00051 : timeout occurred while waiting for a resource
  • ora-13615 : The task or object string is greater than the maximum allowable length of 30 characters.
  • ora-22053 : overflow error
  • ora-01591 : lock held by in-doubt distributed transaction string
  • ora-19727 : cannot plug data [string] at level string into database running Oracle string
  • ora-08207 : ora_addr: cannot open address file
  • ora-37104 : (XSVPART04) A partitioned variable must be dimensioned by a single partition template only.
  • ora-39000 : bad dump file specification
  • ora-30467 : internal data for filter number string is inconsistent
  • ora-01755 : Must specify an extent number or block number
  • ora-40107 : operation requires string option to be installed
  • ora-13406 : null or invalid GeoRaster object for output
  • ora-28025 : missing or null external name
  • ora-13511 : invalid INTERVAL string, must be in the range (string, string)
  • ora-30089 : missing or invalid
  • ora-38900 : missing mandatory column "string" of error log table "string"
  • ora-28605 : bitmap indexes cannot be reversed
  • ora-40217 : priors table mismatched with training data
  • ora-06005 : NETASY: dialogue file read failure
  • ora-19555 : invalid LOG_ARCHIVE_MIN_SUCCEED_DEST parameter value
  • ora-23454 : flavor string not defined for object group "string"."string"
  • 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.