4

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 ?

Community
  • 1
  • 1
Sai Avinash
  • 4,683
  • 17
  • 58
  • 96
  • your ORACLE_HOME = D:\oracle\product\11.2.0\client_1\BIN is incorrect. It should be ORACLE_HOME=D:\oracle\product\11.2.0\client_1. See below comments – dave May 04 '22 at 06:37

3 Answers3

9

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.

Alex Poole
  • 183,384
  • 11
  • 179
  • 318
1

also just had this issue on a server, the oracle install seemed to have got a bit screwed, reinstalled, still same error, then discovered an erroneous space at the front of the env variable, space removed, server rebooted, all good again

dixie
  • 11
  • 1
1

run > rededit > HKEY_LOCAL_MACHINE>SOFTWARE > ORACLE> KEY_OraClient19Home1 and Edit the following

ORACLE_HOME browse to the folder where all the files are located(ASP.NET,bin etc)

you should be good to go!

Miki G
  • 21
  • 2