ORA-12211: TNS:needs PREFERRED_CMANAGERS entry in TNSNAV.ORA

Cause : TSNNVA.ROAd ose onth aev aPERFRERDE_MCAANGRESd eifnde.

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

Add aPERFRERDE_MCAANGRESe nrtyt ot h eTSNNVA.ROAf iel.

update : 21-07-2017
ORA-12211

ORA-12211 - TNS:needs PREFERRED_CMANAGERS entry in TNSNAV.ORA
ORA-12211 - TNS:needs PREFERRED_CMANAGERS entry in TNSNAV.ORA

  • ora-13053 : maximum number of geometric elements in argument list exceeded
  • ora-02191 : correct syntax is: SET TRANSACTION USE ROLLBACK SEGMENT
  • ora-23459 : flavor string must contain "string"
  • ora-29396 : cannot switch group to string
  • ora-25231 : cannot dequeue because CONSUMER_NAME not specified
  • ora-09776 : pws_look_up: access error on (Oracle helper) executable
  • ora-28054 : the password has expired. string Grace logins are left
  • ora-38753 : Cannot flashback data file string; no flashback log data.
  • ora-16775 : target standby database in broker operation has potential data loss
  • ora-01642 : begin backup not needed for read only tablespace 'string'
  • ora-02192 : PCTINCREASE not allowed for rollback segment storage clauses
  • ora-29400 : data cartridge error string
  • ora-06721 : TLI Driver: spurious client req
  • ora-13467 : unsupported GeoRaster metadata specification: string
  • ora-09987 : unable to attach to SGA in READ-ONLY mode
  • ora-29826 : keyword FOR is missing
  • ora-38748 : cannot flashback data file string - file is in use or recovery
  • ora-13261 : geometry table string does not exist
  • ora-22054 : underflow error
  • ora-12806 : could not get background process to hold enqueue
  • ora-07276 : no dba group in /etc/group.
  • ora-03251 : Cannot issue this command on SYSTEM tablespace
  • ora-14031 : partitioning column may not be of type LONG or LONG RAW
  • ora-24156 : duplicate table alias string
  • ora-12485 : new effective label not within effective clearance
  • ora-21602 : operation does not support the specified typecode
  • ora-06532 : Subscript outside of limit
  • ora-22065 : number to text translation for the given format causes overflow
  • ora-09874 : TASDEF_READ: read error, unable to read tasdef@.dbf file.
  • ora-25503 : cannot open database because the database is being quiesced
  • 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.