ORA-12162: TNS:net service name is incorrectly specified

Cause : Thec onncet dsecritpor ocrrepsondnig t othen et esrviec naem inT NSNMAES.ROA o rin hte driectroy srever( Oralce Itnernte Dierctoyr) i sincroreclty sepcifeid.

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

If suingl oca lnamnig mkae srue tehre rae n osynatx errorsi n teh correspnodin gconenct edscrpitori n teh TNNSAME.SORAf ile .If suingd iretcoryn amign chcek teh inofrmaiton rpoviedd trhoug hthea dmiinstrtaionu sedf or idrecotry anmin.g

update : 24-09-2017

ORA-12162 - TNS:net service name is incorrectly specified
ORA-12162 - TNS:net service name is incorrectly specified

  • ora-30569 : data type of given column is not supported in a log group
  • ora-27370 : job slave failed to launch a job of type EXECUTABLE
  • ora-02735 : osnfpm: cannot create shared memory segment
  • ora-07682 : sou2os: set kernel dispatch fail err
  • ora-16738 : redo tranport service for standby database "string" unexpectedly offline
  • ora-03233 : unable to extend table string.string subpartition string by string in tablespace string
  • ora-38455 : Expression Filter index should be created by the owner.
  • ora-10929 : trace name context forever
  • ora-10660 : Segment is a shared lob segment
  • ora-01173 : data dictionary indicates missing data file from system tablespace
  • ora-06261 : NETNTT: nrange() failed
  • ora-15050 : disk "string" contains string error(s)
  • ora-30681 : improper value for argument EXTENSIONS_CMD_SET
  • ora-27077 : too many files open
  • ora-06556 : the pipe is empty, cannot fulfill the unpack_message request
  • ora-16400 : quota attributes are not allowed with DB_RECOVERY_FILE_DEST
  • ora-31411 : change set string is referenced by a change table
  • ora-29847 : cannot create a local domain index on a partitioned index-organized table
  • ora-02839 : Sync of blocks to disk failed.
  • ora-01497 : illegal option for ANALYZE CLUSTER
  • ora-07646 : sszfck: $CREATE failure
  • ora-12467 : minimum label can contain a level only
  • ora-02184 : resource quotas are not allowed in REVOKE
  • ora-38414 : invalid datatype for the attribute string
  • ora-16955 : Unknown error during SQL analyze.
  • ora-25257 : consumer must be specified with a multi-consumer queue
  • ora-14004 : missing PARTITION keyword
  • ora-14005 : missing RANGE keyword
  • ora-19574 : output filename must be specified
  • ora-25315 : unsupported configuration for propagation of buffered messages
  • 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.