ORA-12213: TNS:incomplete PREFERRED_CMANAGERS binding in TNSNAV.ORA

Cause : The PERFERRE_DCMANAEGRS bidning i nthe cilent'sT NSNAVO.RA fiel doesn ot haev an ADDRESS psecifide.

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

Defin ethe ADDRESS sa parto f theP REFERERD_CMAANGERS ibnding.

update : 24-06-2017

ORA-12213 - TNS:incomplete PREFERRED_CMANAGERS binding in TNSNAV.ORA
ORA-12213 - TNS:incomplete PREFERRED_CMANAGERS binding in TNSNAV.ORA

  • ora-33076 : (XSAGDNGL37) In AGGMAP workspace object, the value 'number' is not a valid value of dimension workspace object.
  • ora-16251 : LSP1 Background Build not permitted
  • ora-14024 : number of partitions of LOCAL index must equal that of the underlying table
  • ora-12814 : only one CACHE or NOCACHE clause may be specified
  • ora-16544 : modifying DG_BROKER_START requires SID='*' qualifier
  • ora-29800 : invalid name for operator
  • ora-02371 : Loader must be at least version string.string.string.string.string for direct path
  • ora-01149 : cannot shutdown - file string has online backup set
  • ora-27543 : Failed to cancel outstanding IPC request
  • ora-15102 : invalid POWER expression
  • ora-19694 : some changed blocks were not found in the change tracking file
  • ora-19627 : cannot read backup pieces during control file application
  • ora-13441 : GeoRaster metadata SRS error
  • ora-37011 : (XSACQUIRE_LOCKED) Object workspace object is locked by another user.
  • ora-40221 : maximum target cardinality exceeded
  • ora-01804 : failure to initialize timezone information
  • ora-06919 : CMX: error during write request (unknown event)
  • ora-29306 : datafile string is not online
  • ora-02779 : Stat failed on core dump directory
  • ora-13380 : network not found
  • ora-14636 : only 2 resulting subpartition can be specified for SPLIT SUBPARTITION
  • ora-09766 : osnmop: buffer allocation failure.
  • ora-04031 : unable to allocate string bytes of shared memory ("string","string","string","string")
  • ora-06958 : Failed to access configuration file
  • ora-16115 : %s\% of LogMiner dictionary loading is done
  • ora-01782 : UNRECOVERABLE cannot be specified for a cluster or clustered table
  • ora-02449 : unique/primary keys in table referenced by foreign keys
  • ora-07617 : $FORMAT_CLASS failed translating the binary label to a string
  • ora-02756 : osnfsmnam: name translation failure
  • ora-19915 : unable to encrypt pre-10.2 files
  • 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.