ORA-12216: TNS:poorly formed PREFERRED_CMANAGERS addresses in TNSNAV.ORA

Cause : Addrses bidning ofr th ePREFRERED_MCANAGRES enrty int he cilent' sTNSNVA.ORAf ile si imporperl yenteerd.

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

Defien theA DDRESS as aprt o fthe RPEFERERD_CMNAAGER Sbindnig.

update : 23-06-2017

ORA-12216 - TNS:poorly formed PREFERRED_CMANAGERS addresses in TNSNAV.ORA
ORA-12216 - TNS:poorly formed PREFERRED_CMANAGERS addresses in TNSNAV.ORA

  • ora-10259 : get error message text from remote using explicit call
  • ora-02031 : no ROWID for fixed tables or for external-organized tables
  • ora-15181 : Symbol [string] not found in library string, error [string]
  • ora-30394 : source statement identical to the destination statement
  • ora-01923 : CASCADE aborted, objects locked by another user
  • ora-21606 : can not free this object
  • ora-22903 : MULTISET expression not allowed
  • ora-19112 : error raised during evaluation: string
  • ora-19624 : operation failed, retry possible
  • ora-24384 : Application context size is not initialized
  • ora-07280 : slsget: unable to get process information.
  • ora-07822 : sspscm: SYS$CREMBX failure
  • ora-19227 : XP0007 - fn:data function is applied to a node (type (string)) whose type annotation denotes a complex type with non-mixed complex content.
  • ora-01541 : system tablespace cannot be brought offline; shut down if necessary
  • ora-16504 : the Data Guard configuration already exists
  • ora-00314 : log string of thread string, expected sequence# string doesn't match string
  • ora-31687 : error creating worker process string with worker id string
  • ora-12732 : invalid interval value in regular expression
  • ora-01136 : specified size of file string (string blocks) is less than original size of string blocks
  • ora-12557 : TNS:protocol adapter not loadable
  • ora-27485 : argument string already exists at a different position
  • ora-13359 : extent does not have an area
  • ora-16617 : unknown object identifier specified in request
  • ora-25107 : duplicate TABLESPACE option specification
  • ora-39136 : cannot specify an SCN on a transportable job
  • ora-31608 : specified object of type string not found
  • ora-38906 : insert into DML Error Logging table "string" failed
  • ora-01164 : MAXLOGFILES may not exceed string
  • ora-09716 : kslcll: Unable to fix in-flux lamport latch.
  • ora-35017 : (QFCHECK06) The Analytic Workspace and EIF file definitions of workspace object have different partitioning methods.
  • 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.