How to Fix ORA-12162 TNS:net service name is incorrectly specified Error in Oracle?

sometimes  the oracle profile is not prepared correctly and this give so many errors and you should go direct to directory of SqlPlus to start DB

/u01/app/oracle/product/11.2.0/dbhome_1/bin

./sqlplus sys/password as sysdba;

the following error will arises

ORA-12162 TNS:net service name is incorrectly specified

Cause

This arises if you have not set ORACLE_HOME and ORACLE_SID.

Solution

you can fix it by setting the ORACLE_HOME and ORACLE_SID as following

> export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
> export ORACLE_SID=ECMTEST

and try to start the DB 

./sqlplus sys/password as sysdba;
sql> startup force;
Advertisements

About lorddisk

WebCenter Content, WebCenter Portal, WebCenter Sites,Weblogic, Identity and Access Management (IAM),SSO,OAM,OIM,OAAM,OUD, OPAM,OID, OVD ,Oracle API Gateway ,OBIEE,OEDQ, Oracle ADF, Oracle SOA,J2EE, CackePHP ,PHP,J2SE,J2EE,Spring,Hibernate,JQuery,CSS,Java Script ,Joomla,Drupal,Worpress
This entry was posted in oracle and tagged , , , , , , . Bookmark the permalink.

2 Responses to How to Fix ORA-12162 TNS:net service name is incorrectly specified Error in Oracle?

  1. Gurudatta N.R says:

    Thanks for the quick fix.

  2. OIM says:

    thanks, for the quick fix, you are the best

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s