The ORACLE_HOME environment variable defines where the Oracle application is installed. When databases are discovered, the ORACLE_HOME parameter is automatically defaulted in the corresponding CommCell instances. You can override the default by using the ORACLE_HOME environment variable.
The TNS_ADMIN environment variable defines the directory path for the Oracle Net Services configuration file. If a TNS_ADMIN path is not provided, a default path, \network\admin is appended to the $ORACLE_HOME directory. For example if $ORACLE_HOME is /opt2/oracle, $TNS_ADMIN is/opt2/oracle/network/admin.
In UNIX configurations, you can preserve the UNIX permissions if there are multiple $ORACLE_HOME paths with multiple user-ids and group-ids. See Preserving the User Permissions on UNIX Clients for Oracle.
Procedure
-
From the CommCell Browser, expand Client Computers > client > Oracle.
-
Right-click the instance and then click Properties.
-
On the General tab of the Instance Properties dialog box:
-
In the ORACLE HOME box, enter the path to Oracle Home directory.
Note: You must end the path with a forward slash ("/") for UNIX configurations, or a backward slash ("\") for Windows configurations.
-
In the TNS_ADMIN folder box, enter the location for the TNS Admin directory.
-
-
Click OK to close the Instance Properties dialog box.