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 ?
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.
The value should be set in the registry by the installer, along with other environment variables that have to be set manually in Unix.