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-04-2017
ORA-12162

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

  • ora-36258 : (XSAGINFO00) When the AGGMAPINFO function is called, workspace object must be an AGGMAP.
  • ora-23343 : no match for specified conflict resolution information
  • ora-39117 : Type needed to create table is not included in this operation. Failing sql is: string
  • ora-01552 : cannot use system rollback segment for non-system tablespace 'string'
  • ora-25194 : invalid COMPRESS prefix length value
  • ora-32818 : AQ queue string does not exist
  • ora-12989 : invalid value for checkpoint interval
  • ora-12214 : TNS:missing local communities entry in TNSNAV.ORA
  • ora-29962 : fatal error occurred in the execution of ODCIINDEXALTER routine
  • ora-03207 : subpartitioned type must be specified for composite object
  • ora-01761 : DML operation does not map to a unique table in the join
  • ora-13376 : invalid type name specified for layer_gtype parameter
  • ora-14622 : Value string already exists in subpartition string
  • ora-29852 : keyword IS is missing
  • ora-22868 : table with LOBs contains segments in different tablespaces
  • ora-29313 : tablespace 'string' cannot be imported twice
  • ora-07454 : queue timeout, string second(s), exceeded
  • ora-22955 : The cardinality parameter is not within the allowed limits
  • ora-07613 : $GETJPIW failed in retrieving the user's process label
  • ora-24079 : invalid name string, names with AQ$_ prefix are not valid for string
  • ora-26080 : file "string" is not part of table string.string partition string
  • ora-38726 : Flashback database logging is not on.
  • ora-12985 : tablespace 'string' is read only, cannot drop column
  • ora-25196 : keyword MOVE in ALTER TABLE MOVE must immediately follow
  • ora-31011 : XML parsing failed
  • ora-08184 : attempting to re-enable Flashback while in Flashback mode
  • ora-23361 : materialized view "string" does not exist at master site
  • ora-25131 : cannot modify unique(string) - unique key not defined for table
  • ora-00288 : to continue recovery type ALTER DATABASE RECOVER CONTINUE
  • ora-00965 : column aliases not allowed for '*'
  • 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.