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 : 24-06-2017
ORA-12215

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

  • ora-22901 : cannot compare nested table or VARRAY or LOB attributes of an object type
  • ora-16796 : one or more properties could not be imported from the database
  • ora-13210 : error inserting data into the index table
  • ora-29266 : end-of-body reached
  • ora-31488 : cannot support change set string in this configuration
  • ora-22324 : altered type has compilation errors
  • ora-27302 : failure occurred at: string
  • ora-34276 : (MXDCL33) (Precision, Scale) arguments can only be used with a NUMBER variable or dimension.
  • ora-08208 : ora_addr: cannot read from address file
  • ora-09710 : soarcv: buffer overflow.
  • ora-12921 : database is not in force logging mode
  • ora-09830 : snyAddPort: failed to perform a remote procedure call.
  • ora-16569 : Data Guard configuration is not enabled
  • ora-26101 : tablespace # in file header is string rather than string for file string
  • ora-07280 : slsget: unable to get process information.
  • ora-08275 : Environment variable unset
  • ora-14136 : ALTER TABLE EXCHANGE restricted by fine-grained security
  • ora-15005 : name "string" is already used by an existing alias
  • ora-07270 : spalck: setitimer error, unable to set interval timer.
  • ora-30031 : the suspended (resumable) statement has been aborted
  • ora-01784 : RECOVERABLE cannot be specified with database media recovery disabled
  • ora-06556 : the pipe is empty, cannot fulfill the unpack_message request
  • ora-25008 : no implicit conversion to LOB datatype in instead-of trigger
  • ora-06140 : NETTCP: no such user
  • ora-16800 : redo transport service for a standby database incorrectly set to ALTERNATE
  • ora-25295 : Subscriber is not allowed to dequeue buffered messages
  • ora-02791 : Unable to open file for use with asynchronous I/O
  • ora-16548 : object not enabled
  • ora-32311 : materialized view definition query selects an unsupported user-defined type
  • ora-13333 : invalid LRS measure
  • 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.