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

Cause : The PREFERRED_CMANAGERS binding in the client's TNSNAV.ORA file does not have a CMANAGER_NAME specified.

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

Define the CMANAGER_NAME as part of the PREFERRED_CMANAGERS binding. Use of the Oracle Network Manager should eliminate this error.

update : 23-06-2017

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

  • ora-12077 : temporary updatable materialized view log does not exist
  • ora-07550 : sftopn: $CONNECT failure
  • ora-38402 : invalid name: empty string or spaces in the name
  • ora-23409 : could not find an unused refresh group number
  • ora-31478 : could not detach LogMiner session after change set advance
  • ora-23357 : the propagator does not exist
  • ora-12620 : TNS:requested characteristic not available
  • ora-31445 : invalid lock handle while acquiring lock on string
  • ora-00152 : current session does not match requested session
  • ora-29336 : Internal error [string] [string] from DBMS_PLUGTS
  • ora-07273 : sppst: invalid semaphore id.
  • ora-39950 : invalid parameter for PLSQL warnings flag
  • ora-06145 : NETTCP: unable to start ORASRV: images not installed
  • ora-17502 : ksfdcre:string Failed to create file string
  • ora-13340 : a point geometry has more than one coordinate
  • ora-19591 : backup aborted because job time exceeded duration time
  • ora-09961 : Unable to restore termination signal handler
  • ora-39176 : Encryption password is incorrect.
  • ora-06549 : PL/SQL: failed to dynamically open shared object (DLL): string
  • ora-30195 : reserved for future use
  • ora-06320 : IPA: Remote maximum number of connections exceeded
  • ora-06005 : NETASY: dialogue file read failure
  • ora-16746 : resource guard encountered errors during database mount
  • ora-13143 : invalid POLYGON window definition
  • ora-27454 : argument name and position cannot be NULL
  • ora-02204 : ALTER, INDEX and EXECUTE not allowed for views
  • ora-01763 : update or delete involves outer joined table
  • ora-09275 : CONNECT INTERNAL is not a valid DBA connection
  • ora-13600 : error encountered in Advisor string
  • ora-13704 : Invalid value "string" specified for parameter "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.