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.
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.
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.