Using the installutil commands registeroracleoptions and getoracleoptions

The installutil registeroracleoptions command enables an override for the connect options of Oracle-based HCL Compass databases. This command should only be used for troubleshooting purposes or special circumstances. In a majority of cases, the connect options for schema repositories and user databases suffice for defining Oracle connection information.

Here is the syntax for this command:

installutil registeroracleoptions "<connect_options>"

You provide the same connect option values as you would in the HCL Compass Maintenance Tool and HCL Compass Designer.

Here is an example:

installutil registeroracleoptions "PORT=1523"

Installutil getoracleoptions is the HCL Compass command line tool that will display the entry you have specified with installutil registeroracleoptions command. There is no syntax. You only need to run this command:

installutil getoracleoptions

If you have not previously run the registeroracleoptions command, you will receive an error.

On UNIX® & Linux® Operating Systems

The installutil command does not exist with HCL Compass on UNIX or Linux platforms. However, you can define the Oracle override environment variable CQ_OVERRIDE_ORACLE_CONNECT_OPTIONS. Here is an example of setting this variable and viewing it with a C shell:

setenv CQ_OVERRIDE_ORACLE_CONNECT_OPTIONS "PORT=1523"

echo $CQ_OVERRIDE_ORACLE_CONNECT_OPTIONS