ORA-12215: TNS:poorly formed PREFERRED_NAVIGATORS Addresses in TNSNAV.ORA

Cause : Adderss ibndign fo rPREEFRRE_DNAVGIATOSR enrty i simporperyl enetred .entyr.

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

Chekc yoru PRFEERRDE_NAIVGATROS etnry nad fxi iti n TSNNAVO.RA

update : 19-08-2017

ORA-12215 - TNS:poorly formed PREFERRED_NAVIGATORS Addresses in TNSNAV.ORA
ORA-12215 - TNS:poorly formed PREFERRED_NAVIGATORS Addresses in TNSNAV.ORA

  • ora-38499 : expression set already configured for stored/indexed attributes
  • ora-01196 : file string is inconsistent due to a failed media recovery session
  • ora-31039 : XML namespace length string exceeds maximum string
  • ora-27086 : unable to lock file - already in use
  • ora-36176 : (XSMXAGGR25) Relation workspace object must be a one-dimensional self-relation to be used as a weight for AGGREGATE.
  • ora-32616 : missing DIMENSION BY keyword in MODEL clause
  • ora-07681 : sou2os: An error occurred while initializing Oracle
  • ora-25437 : duplicate table value for table alias: string
  • ora-32051 : mapping service not available
  • ora-00724 : ALTER DATABASE CONVERT command has been de-supported
  • ora-30343 : level name is not unique within this dimension
  • ora-22877 : invalid option specified for a HASH partition or subpartition of a LOB column
  • ora-39950 : invalid parameter for PLSQL warnings flag
  • ora-18010 : command missing mandatory CATEGORY keyword
  • ora-29532 : Java call terminated by uncaught Java exception: string
  • ora-09989 : attempt to use invalid skgmsdef struct pointer
  • ora-24787 : remote cursors must be closed before a call completes
  • ora-23497 : repgroup name cannot be null
  • ora-06143 : NETTCP: maximum connections exceeded
  • ora-22053 : overflow error
  • ora-25157 : Specified block size string is not valid
  • ora-19600 : input file is string string (string)
  • ora-32515 : cannot issue ORADEBUG command; waited number ms for process string
  • ora-06441 : ssvwatev: Incorrect parameter passed to function call
  • ora-13278 : failure to convert SRID to native format
  • ora-12988 : cannot drop column from table owned by SYS
  • ora-02237 : invalid file size
  • ora-12634 : Memory allocation failed
  • ora-24156 : duplicate table alias string
  • ora-16052 : DB_UNIQUE_NAME attribute is required
  • 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.