Oracle connection information

The following table provides an example of an Oracle connection created in version 2003.06.00 and earlier, with the LONG datatype set to CLOB. In this example, the SQL*Net Alias ORA1alias points to a SID of CQ1 on server ORA1, port 1521.

Connection information for the schema repository:

Version 2003.06.00 connection information Value
Vendor ORACLE
SQL*Net Alias ORA1alias
User Name susan
Password ********
Connect Options HOST=ora1.example.com;SID=CQ1; SERVER_VER=8.1;CLIENT_VER=8.1; LOB_TYPE=CLOB

If the same connection is viewed in version 2003.06.13 and later, after upgrading to Oracle version 9.2:

Version 2003.06.13 and later connection information Value
Vendor ORACLE
Server ORA1alias
SID susan
User Name susan
Password ********
Connect Options HOST=ora1.example.com;SID=CQ1; LOB_TYPE=CLOB

This connection works in version 2003.06.13 because the HOST and SID parameters in the Connect Options field are the same values used in version 2003.06.00 and override the Server and SID values in the main part of the connection. If the connect options do not have the correct HOST and SID values, this connection does not work.


Feedback