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 : 27-04-2017
ORA-12198

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

  • ora-26712 : remote object is "string"."string"@"string"
  • ora-13863 : Statistics aggregation for service(module/action) string is not enabled
  • ora-30685 : package version is not compatible with Oracle version
  • ora-24385 : Application context size or index is not valid
  • ora-13127 : failed to generate target partition
  • ora-30369 : maximum number of columns is 32
  • ora-28002 : the password will expire within string days
  • ora-13504 : No SYSAUX datafile clause specified
  • ora-30184 : argument type not compatible with a format code
  • ora-09788 : sllfrb: unable to read file.
  • ora-02300 : invalid value for OIDGENERATORS
  • ora-24329 : invalid character set identifier
  • ora-29345 : cannot plug a tablespace into a database using an incompatible character set
  • ora-03200 : the segment type specification is invalid
  • ora-16635 : NetSlave connection was broken in the middle of a transmission session
  • ora-29870 : specified options are only valid for altering a domain index
  • ora-00256 : cannot translate archive destination string string
  • ora-06143 : NETTCP: maximum connections exceeded
  • ora-06979 : X.25 Driver: server cannot start oracle
  • ora-24039 : Queue string not created in queue table for multiple consumers
  • ora-01190 : control file or data file string is from before the last RESETLOGS
  • ora-00257 : archiver error. Connect internal only, until freed.
  • ora-24046 : protocol attribute reserved for future use
  • ora-13711 : Some snapshots in the range [string, string] are missing key statistics.
  • ora-13232 : failed to allocate memory during R-tree creation
  • ora-26527 : local store callback init phase failed for 'string.string'
  • ora-06403 : Unable to allocate memory.
  • ora-06808 : TLI Driver: could not link IPX and ethernet streams
  • ora-28262 : global_context_pool_size has invalid value.
  • ora-07456 : cannot set RESOURCE_MANAGER_PLAN when database is closed
  • 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.