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 : 26-06-2017
ORA-12206

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

  • ora-15067 : command or option incompatible with diskgroup redundancy
  • ora-04063 : %s has errors
  • ora-24016 : cannot create QUEUE_TABLE, user string does not have execute privileges on QUEUE_PAYLOAD_TYPE string.string
  • ora-33092 : (XSAGCOMP04) number is not the name of a MODEL in any attached analytic workspace.
  • ora-39216 : object type "string"."string" hashcode mismatch
  • ora-23538 : cannot explicitly refresh a NEVER REFRESH materialized view ("string")
  • ora-16249 : Terminal apply failed to complete during failover
  • ora-38102 : Invalid column in the INSERT WHERE Clause: string
  • ora-06767 : TLI Driver: alloc failed during release
  • ora-30576 : ConText Option dictionary loading error
  • ora-35578 : (SQLOUT11) SQL cursor 'number' cannot be used with CURRENT OF syntax
  • ora-28003 : password verification for the specified password failed
  • ora-31491 : could not add logfile to LogMiner session
  • ora-15102 : invalid POWER expression
  • ora-23473 : replication RPC processing for "string"."string" is disabled
  • ora-13453 : GeoRaster metadata layer error
  • ora-02073 : sequence numbers not supported in remote updates
  • ora-13604 : The specified parameter string cannot be fetched as a SQL table.
  • ora-19023 : The first argument to UPDATEXML operator has to be an XMLTYPE
  • ora-40208 : duplicate or multiple algorithm settings for function string
  • ora-15038 : disk 'string' size mismatch with diskgroup [string] [string] [string]
  • ora-19756 : corrupt block number string found in change tracking file
  • ora-02841 : Server died on start up
  • ora-01255 : cannot shutdown - file string in recovery manager backup
  • ora-23605 : invalid value "string" for STREAMS parameter string
  • ora-14409 : inserted partition key is outside specified subpartition
  • ora-01343 : LogMiner encountered corruption in the logstream
  • ora-16639 : specified instance inactive or currently unavailable
  • ora-19670 : file string already being restored
  • ora-30074 : GLOBAL partitioned index on TIME/TIMESTAMP WITH TIME ZONE not allowed
  • 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.