Sample Header Ad - 728x90

On Oracle 21c XE, what should ORACLE_HOME and TNS_ADMIN be set to?

1 vote
1 answer
4122 views
In my Windows Oracle 21c XE installation I have the product installed under: C:\Oracle\product\21c Below that there is: dbhomeXE which contains the bin directory and also network. However, I also have: C:\Oracle\product\21c\homes\OraDB21Home1 This also has network/admin. It looks like dbhomeXE should be the Oracle home, but I have seen it also mentioned that it should be the directory above. I assume TNS_ADMIN should be $ORACLE_HOME/network/admin? But how does it matter anyway? What uses ORACLE_HOME? It isn't currently set on my system and sqlplus launches, although it can't find the PDB I have created. **EDIT:** The variables are used in a batch script to run sqlplus, so I am talking about the client side really, although both the server and the client are on the same PC.
Asked by rghome (143 rep)
Oct 10, 2022, 07:10 AM
Last activity: Oct 31, 2022, 01:17 PM