Changing the Oracle Configuration Directories after Discovering Instances

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

  1. From the CommCell Browser, expand Client Computers > client > Oracle.
  2. Right-click the instance and then click Properties.
  3. 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.
  4. Click OK to close the Instance Properties dialog box.