ORA-12202: TNS:internal navigation error

Cause : Internal navigation error.

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

Not normally visible to the user. For further details contact Worldwide Customer Support.

update : 28-04-2017

ORA-12202 - TNS:internal navigation error
ORA-12202 - TNS:internal navigation error

  • ora-16237 : SGA specified for Logical Standby is too small
  • ora-00072 : process "string" is not active
  • ora-16741 : the destination parameter of standby database "string" has incorrect syntax
  • ora-19204 : Non-scalar value 'string' is marked as XML attribute
  • ora-36836 : (XSLMGEN06) Dimension string.string!string hierarchy string level string is missing a PHYSICALNAME property value
  • ora-01276 : Cannot add file string. File has an Oracle Managed Files file name.
  • ora-02057 : 2PC: string: bad two-phase recovery state number string from string
  • ora-16057 : DGID from server not in Data Guard configuration
  • ora-14630 : subpartition resides in offlined tablespace
  • ora-38956 : Target platform string not cross platform compliant
  • ora-19108 : WHITESPACE keyword expected
  • ora-32585 : duplicate specification of a supplemental log attribute
  • ora-22894 : cannot add constraint on existing unscoped REF columns of non-empty tables
  • ora-32700 : error occurred in DIAG Group Service
  • ora-19653 : cannot switch to older file incarnation
  • ora-02160 : index-organized table can not contain columns of type LONG
  • ora-24038 : RETRY_DELAY and MAX_RETRIES cannot be used for a 8.0 compatible multiple consumer queue
  • ora-29886 : feature not supported for domain indexes
  • ora-00257 : archiver error. Connect internal only, until freed.
  • ora-24760 : invalid isolation level flags
  • ora-16577 : corruption detected in Data Guard configuration file
  • ora-30742 : cannot grant SELECT privilege WITH HIERARCHY OPTION on this object
  • ora-31110 : Action failed as resource string is locked by name
  • ora-30653 : reject limit reached
  • ora-39762 : streams must be loaded in conversion order
  • ora-31525 : could not find column string in CDC change table string.string
  • ora-29320 : datafile header error
  • ora-01082 : 'row_locking = always' requires the transaction processing option
  • ora-40203 : model string does not exist
  • 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.