Question

Database: Configure Oracle Net manager:

Create the directory E:\oracle\net to be used by Oracle Net configuration files and then set TNS_ADMIN variable to point to this. To set this variable you will need to open regedit.exe (the “Registry Editor”) first. Next, you will create and set the key TNS_ADMIN as a string variable in the registry in the Oracle Home branch. This will likely be: HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDB12Home1

How to set TNS_ADMIN variable correctly.

Answer 1

Hi,

Please find the answer below:
-------------------------------

Steps to Set TNS_ADMIN registry key:

Open Registry editor app by typing regedit in the search prompt.

Click Yes on the elevation prompt.

Go to the registry hive:

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\<KEY to Orace Home>

Right click on the key >> Choose New >> String value.

Name the Key as TNS_ADMIN

Point the key to the E:\oracle\net

Test:

Close Registry editor.
Open command shell and type

c:/> tnsping <oracle_service_ID>

We can find the service ID in ORACLE_SID registry key.

-------------------------------------------

TNS_ADMIN is an environment variable that points to the directory where the database listner cand configuration files are located. We need to have the following files in the pointed directory. These files would be generated by Oracle configuration tools.

• listener.ora
• sqlnet.ora
• tnsnames.ora

The above process sets the variable. We can use the Oracle Net Manager to create the service connection files or view them. We need to configure Service name, Hostname/ Port.

-------------------------------

Hope this helps.
Let me know if you need more help with this.
Kindly, like the solution if you find it useful
Thanks.