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

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

  • ora-08468 : mask option string is not supported
  • ora-32019 : The parameter SPFILE cannot be updated in the server parameter file.
  • ora-31073 : Resource not retrieved using path name
  • ora-30375 : materialized view cannot be considered fresh
  • ora-07709 : sksaprs: archiving to a remote host is not allowed
  • ora-13767 : End snapshot ID must be greater than or equal to begin snapsho ID.
  • ora-32401 : materialized view log on "string"."string" does not have new values
  • ora-01533 : cannot rename file 'string'; file does not belong to tablespace
  • ora-39128 : unexpected DbmsJava error number from statement string
  • ora-01027 : bind variables not allowed for data definition operations
  • ora-27078 : unable to determine limit for open files
  • ora-14011 : names assigned to resulting partitions must be distinct
  • ora-03001 : unimplemented feature
  • ora-07400 : slemtr: translated name for the message file is too long.
  • ora-35952 : (XSSPFC01) The string dimension workspace object and the string dimension workspace object must have the same number of values in status for SPFCEXEC method number.
  • ora-31460 : logfile location string is not an existing directory
  • ora-30022 : Cannot create segments in undo tablespace
  • ora-32578 : password for SYS already specified
  • ora-28273 : No mapping for user nickname to LDAP distinguished name exists.
  • ora-01487 : packed decimal number too large for supplied buffer
  • ora-24141 : rule set string.string does not exist
  • ora-19004 : Duplicate XMLType OBJECT RELATIONAL storage option
  • ora-12446 : Insufficient authorization for administration of policy string
  • ora-37176 : argument string is not valid for the sparsity advisor
  • ora-33010 : (XSAGDNGL04) Relation workspace object is duplicated in the AGGMAP workspace object.
  • ora-00251 : LOG_ARCHIVE_DUPLEX_DEST cannot be the same destination as string string
  • ora-26571 : %s.string.string: number of arguments (string) does not match replication catalog
  • ora-31193 : This versioning feature isn't supported for resource string
  • ora-06314 : IPA: Event set up failure
  • ora-27432 : step string does not exist for chain 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.