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 : 28-07-2017

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

  • ora-25241 : cannot change correlation ID from string to string without FIRST_MESSAGE option
  • ora-19638 : file string is not current enough to apply this incremental backup
  • ora-09752 : pw_attachPorts: port_allocate failed.
  • ora-19263 : XQ0043 - duplicate namespace prefix string
  • ora-12919 : Can not drop the default permanent tablespace
  • ora-14506 : LOCAL option required for partitioned indexes
  • ora-13272 : geometric object string in table string is invalid
  • ora-27470 : failed to re-enable "string.string" after making requested change
  • ora-19400 : System type conflict with object SYS.string
  • ora-27122 : unable to protect memory
  • ora-31090 : invalid database schema name "string"
  • ora-01981 : CASCADE CONSTRAINTS must be specified to perform this revoke
  • ora-32847 : operation is not supported on this platform
  • ora-27060 : could not set close-on-exec bit on file
  • ora-07589 : spdde: system ID not set
  • ora-01415 : too many distinct aggregate functions
  • ora-39056 : invalid log file specification.
  • ora-27453 : %s is an invalid job or program argument name.
  • ora-24789 : start not allowed in recursive call
  • ora-07253 : spdes: semctl error, unable to destroy semaphore set.
  • ora-39098 : Worker process received data objects while loading metadata. Invalid process order range is string..string
  • ora-22976 : incorrect number of arguments to MAKE_REF
  • ora-16028 : new string causes less destinations than LOG_ARCHIVE_MIN_SUCCEED_DEST requires
  • ora-24909 : call in progress. Current operation cancelled
  • ora-28500 : connection from ORACLE to a non-Oracle system returned this message:
  • ora-00022 : invalid session ID; access denied
  • ora-08320 : scnget: Call to scnget before scnset or scnfnd.
  • ora-07682 : sou2os: set kernel dispatch fail err
  • ora-22953 : Cardinality of the input to powermultiset exceeds maximum allowed
  • ora-09208 : sftcls: error closing file
  • 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.