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

Home

Tech

Tips and Tricks

Tech - Tips and Tricks

View Comments

Posted by Anand Kahaly in Tips and Tricks on June 14, 2010 | 0 Comments

The error [ORA-12162 TNS:net service name is incorrectly specified] is very misleading. The first thing that hits you is, there is something wrong with tnsnames.ora. In reality it has nothing to do with tnsnames.ora. This arises if you have not set ORACLE_HOME and ORACLE_SID. I faced this problem while installing Oracle11gR1 on Suse Linux 10.

past stomach ulcers generic viagra without a perscription. narcotic pain medication a newly released history in past times months of an stroke, stroke, heart surgery, or life-threatening cardiac rhythm problem viagra professional online. You ought not take cyclobenzaprine when you have recently were built with a cardiac arrest, or should you have a heart rhythm disorder, congestive heart failure, Adams-Stokes syndrome, or an overactive thyroid cialis without prescription.

To solve [ORA-12162 TNS:net service name is incorrectly specified] error you just have to set ORACLE_HOME and ORACLE_SID. In Unix system, type the following commands as Oracle user:

prompt:\> export ORACLE_HOME=/oracle/app/oracle/product/11.1.0/db_1
prompt:\> export ORACLE_SID=orcl

Where orcl is the database name which you give while running dbca. Its orcl by default. In Windows systems the solution is same, you just have to set ORACLE_HOME and ORACLE_SID.

Tags: