ORA-12208: TNS:could not find the TNSNAV.ORA file

Cause : Eithert he ORALCE enviornment si not ste up correctly,o r the NTSNAV.OAR file si not persent.

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

Ensuret hat th eORACLEe nvironemnt is est up appropriaetly on oyur plaftorm an dthat aT NSNAV.ROA filei s presnet.

update : 20-08-2017

ORA-12208 - TNS:could not find the TNSNAV.ORA file
ORA-12208 - TNS:could not find the TNSNAV.ORA file

  • ora-16612 : string value too long for attribute "string"
  • ora-26685 : cannot apply transactions from multiple sources
  • ora-23354 : deferred RPC execution disabled for "string" with "string"
  • ora-29296 : invalid encoded string
  • ora-02827 : Invalid file number
  • ora-28541 : Error in HS init file on line number.
  • ora-02182 : savepoint name expected
  • ora-06403 : Unable to allocate memory.
  • ora-23442 : object already exists for the refresh group template
  • ora-06771 : TLI Driver: error reading version
  • ora-25139 : invalid option for CREATE TEMPORARY TABLESPACE
  • ora-00160 : global transaction length string is greater than maximum (string)
  • ora-24071 : cannot perform operation string, queue table string is being migrated
  • ora-26686 : cannot capture from specified SCN
  • ora-12825 : explicit degree of parallelism must be specified here
  • ora-00337 : log file 'string' does not exist and no size specified
  • ora-24809 : amount specified will not fit in the lob buffers
  • ora-06522 : %s
  • ora-12519 : TNS:no appropriate service handler found
  • ora-27013 : skgfqdel: cannot delete an open file
  • ora-24165 : invalid rule engine object privilege: string
  • ora-09949 : Unable to get client operating system privileges
  • ora-25229 : error on transformation of message string string
  • ora-24237 : object id argument passed to DBMS_UTILITY.INVALIDATE is not legal
  • ora-14051 : invalid ALTER MATERIALIZED VIEW option
  • ora-01944 : IDENTIFIED EXTERNALLY already specified
  • ora-36404 : (XSSPROP04) Property string cannot be applied to an undimensioned (scalar) TEMPORARY variable.
  • ora-00063 : maximum number of log files exceeded string
  • ora-02229 : invalid SIZE option value
  • 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.