Trouble setting Environment variable ORACLE_HOME

oracle11g database-connection tnsping
Sai Avinash picture Sai Avinash · Apr 8, 2014 · Viewed 36.2k times · Source

I have a fresh installation of Oracle 11g client.

I am having trouble using tnsping. It is giving an error:

Message 3511 not found; No message file for product=NETWORK, facility=TNSTNS-0
05: Message 3505 not found; No message file for product=NETWORK, facility=TNS

I have set the Environment variable for ORACLE_HOME as follows:

D:\oracle\product\11.2.0\client_1\BIN

I am not sure what should be exact path for ORACLE_HOME .

How to identify what is the exact path for ORACLE_HOME directory?

Is it D:\oracle\product\11.2.0\client_1 ? or D:\oracle\product\11.2.0\client_1\BIN

Any suggestions or solutions ?

Answer

Alex Poole picture Alex Poole · Apr 8, 2014

Your ORACLE_HOME should be D:\oracle\product\11.2.0\client_1, assuming that is where you installed the software. The BIN directory under it should be in PATH.

Read more about ORACLE_HOME

The value should be set in the registry by the installer, along with other environment variables that have to be set manually in Unix.

Related questions

java.sql.SQLRecoverableException: Closed Connection; State=08003; ErrorCode=17008

I am getting the below error while inserting some rows in oracle database table by using loops java my loop will go nearly 25000 times: java.sql.SQLRecoverableException: Closed Connection; State=08003; ErrorCode=1700 8 at oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnec tion.java:3331) …

Read More
ORA-12514 TNS:listener does not currently know of service requested in connect descriptor

We have an application running locally where we're experiencing the following error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor I've tested the connection using TNSPing which resolved correctly and I tried SQLPlus to try …

Read More
How do I do top 1 in Oracle?

How do I do the following? select top 1 Fname from MyTbl In Oracle 11g?

Read More