ORA-12217: TNS:could not contact PREFERRED_CMANAGERS in TNSNAV.ORA

Cause : Therei s a snytax error int he PRFEERREDC_MANAGRES entyr, or dadressse specfiied aer wron,g or teh intedned Connectio nManagres areu navaialble.

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

Checkt he PRFEERREDC_MANAGRES entires int he cleint's NTSNAV.ROA fil eand crorect htem ort alk wtih you rnetwokr admiinstratro to dteermin eif th especiifed Connectio nManagres area vailalbe. Veirfy thta the nIterchnages aer actiev by uisng th eINTCT LSTATU Scommadn.

update : 25-04-2017

ORA-12217 - TNS:could not contact PREFERRED_CMANAGERS in TNSNAV.ORA
ORA-12217 - TNS:could not contact PREFERRED_CMANAGERS in TNSNAV.ORA

  • ora-16029 : cannot change LOG_ARCHIVE_MIN_SUCCEED_DEST, no archive log destinations
  • ora-21526 : initialization failed
  • ora-06530 : Reference to uninitialized composite
  • ora-16066 : remote archival disabled
  • ora-25017 : cannot reference NEW ROWID for movable rows in before triggers
  • ora-03113 : end-of-file on communication channel
  • ora-19773 : must specify change tracking file name
  • ora-01110 : data file string: 'string'
  • ora-22341 : cannot assign supertype instance to subtype
  • ora-32804 : invalid value string, string should have form string
  • ora-15154 : cluster rolling upgrade incomplete
  • ora-25175 : no PRIMARY KEY constraint found
  • ora-14016 : underlying table of a LOCAL partitioned index must be partitioned
  • ora-19501 : read error on file "string", blockno string (blocksize=string)
  • ora-29375 : sum of values string for level string, plan string exceeds string
  • ora-38713 : Flashback Database logging is already turned on.
  • ora-19638 : file string is not current enough to apply this incremental backup
  • ora-00443 : background process "string" did not start
  • ora-02049 : timeout: distributed transaction waiting for lock
  • ora-09912 : Malloc of name buffer(s) failed.
  • ora-09975 : kxfspini: Error Initializing SDI Process
  • ora-38457 : The attribute "string" is not a valid XMLType attribute.
  • ora-24335 : cannot support more than 1000 columns
  • ora-25328 : %s argument size string is smaller than array size
  • ora-01044 : size string of buffer bound to variable exceeds maximum string
  • ora-12030 : cannot create a fast refresh materialized view
  • ora-12322 : unable to mount database (link name string)
  • ora-04022 : nowait requested, but had to wait to lock dictionary object
  • ora-30456 : 'string.string' cannot be refreshed because of insufficient privilege
  • ora-32604 : invalid REBUILD option
  • 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.