ORA-12206: TNS:received a TNS error during navigation

Cause : Interanl navgiatione rror ebcauseo f an nuexpecetd TNSe rror.

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

Look ta the olg fil eto fidn the NTS errro. If encessayr, tur non trcaing adn repeta the poeratino.

update : 30-04-2017
ORA-12206

ORA-12206 - TNS:received a TNS error during navigation
ORA-12206 - TNS:received a TNS error during navigation

  • ora-16811 : apply instance not recorded by the Data Guard broker
  • ora-16091 : dependent archive log destination already archived
  • ora-16809 : multiple warnings detected for the database
  • ora-32400 : cannot use object id columns from materialized view log on "string"."string"
  • ora-24422 : error occurred while trying to destroy the Session Pool
  • ora-02381 : cannot drop PUBLIC_DEFAULT profile
  • ora-19501 : read error on file "string", blockno string (blocksize=string)
  • ora-16807 : unable to change database protection mode
  • ora-19689 : cannot have more than one %F in control file autobackup format(string) for string
  • ora-01571 : redo version string incompatible with ORACLE version string
  • ora-01911 : CONTENTS keyword expected
  • ora-13622 : invalid recommendation annotation
  • ora-27434 : cannot alter chain step job string.string.string
  • ora-26736 : Data Pump error
  • ora-32316 : REFRESH FAST of "string"."string" unsupported after mixed DML
  • ora-08108 : may not build or rebuild this type of index online
  • ora-06791 : TLI Driver: poll returned error event
  • ora-02844 : Invalid value for the leave open flag
  • ora-38708 : not enough space for first flashback database log file
  • ora-39054 : missing or invalid definition of the SQL output file.
  • ora-06708 : TLI Driver: message receive failure
  • ora-27193 : sbtinfo2 did not return volume label
  • ora-09321 : slzdtb: unable to convert zoned decimal to binary
  • ora-02478 : merge into base segment would overflow MAXEXTENTS limit
  • ora-30686 : no dispatcher accepted TCP/IP connection request
  • ora-40301 : invalid cost matrix specification
  • ora-38719 : Invalid DUMP FLASHBACK object.
  • ora-22292 : Cannot open a LOB in read-write mode without a transaction
  • ora-19999 : skip_row procedure was called
  • ora-03204 : the segment type specification should indicate partitioning
  • 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.