Database properties and connection information for Oracle

If you use an Oracle database and are upgrading to version 7.1.x from any version earlier than 2003.06.13 for Windows or clearquest_p2003.06.00-6 for Linux and the UNIX system, you must modify the database properties pages of your schema repositories and user databases.

If you use an Oracle database and you already upgraded to version 2003.06.13 or later, you have already modified the database properties, and do not need to do so when you upgrade to version 7.1.x.

All Rational® ClearQuest® clients must be upgraded to version 2003.06.13 or later to work with databases created with version 7.1.x.

In releases earlier than version 2003.06.13, the following fields were listed by the Maintenance Tool on the database properties page for Oracle:
Beginning with version 2003.06.13, these fields are listed:

One important change in version 2003.06.13 is that the Server and SID fields replaced the SQL*Net Alias field.

In versions earlier than version 2003.06.13, the SQL*Net Alias field was used to obtain the host name of the Oracle Server, the SID, the connection protocol, and the port number of the Oracle Listener.

Beginning in version 2003.06.13, this information is entered in different fields.

A second important change involves the valid parameters in the Connect Options field.

In versions earlier than 2003.06.13, the Connect Options field always included a text string that listed the following parameters:

HOST=;SID=;CLIENT_VER=;SERVER_VER=;LOB_TYPE=;

In version 2003.06.13 and later, these parameters are valid in the Connect Options field:

HOST=;SID=;CLIENT_VER=;SERVER_VER=;LOB_TYPE=;PORT=;

In version 2003.06.13 and later, a PORT option is available. Also, all parameters in the Connect Options field are optional, except LOB_TYPE. Use the other parameters only to override connection information, such as HOST.

The names of the options in the Connect Options field are not case sensitive, but the values are. Options must be separated by semicolons, with no spaces in between.

The valid value for CLIENT_VER= is 9.2.

Versions 7.0 and later no longer support Oracle 8.1 and 8.2, so valid values for SERVER_VER= are 9.2 and 10.1.

When the port number of the database is different from the default for Oracle (1521), you must enter a value for the PORT= in the Connect Options field. The port number must be entered in the form PORT=number.

Beginning with version 2003.06.13, the default value for the LOB_TYPE is CLOB. Versions 7.0 and later do not support the LONG datatype, so all data of the LONG datatype must be converted to CLOB. For information, see Converting Oracle LONG data to CLOB data.


Feedback