Using the installutil commands registeroracleoptions and getoracleoptions

The installutil registeroracleoptions command enables an override for the connect options of Oracle-based Rational® ClearQuest® 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 Rational ClearQuest Maintenance Tool and Rational ClearQuest Designer.

installutil registeroracleoptions "PORT=1523"

Installutil getoracleoptions is the Rational ClearQuest 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 this error message:

Failed to read from registry: "Software\Rational Software\ClearQuest\2003.06.00\Core", name: "OverrideOracleConnectOptions".

On UNIX® & Linux® Operating Systems

The installutil command does not exist with Rational ClearQuest on UNIX or Linux platforms. However, you can define the Oracle override environment variableCQ_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