Installing... err... I mean building Oracle
- Started building cqtalk, a Perl process to interact with Clearquest
- Spent time attempting to install/build Oracle client for Linux
Installing/Building Oracle
We have an application, ucmwb, which uses Oracle to talk directly to our Clearquest databases. This application runs on Solaris and hopefully soon Linux. In particular it talks to RANCQ on RANDBS. AFAICT RANDBS is an Oracle 9.2 server.
I would love to go to Oracle 10.x because with 10.x comes regexs and they would help ucmwb tremendously. However I can't get a 10.x client to talk to this 9.x server.
Working on the Solaris side for now, I can use the 9.2 version of sqlplus to connect to our RANCQ database:
Randws016:echo $ORACLE_HOME /usr/local/oracle/product/9.2 Randws016:$ORACLE_HOME/bin/sqlplus RAN_WB/RAN_WB@RANCQ_RANDBS SQL*Plus: Release 9.2.0.1.0 - Production on Wed Aug 29 14:46:53 2007 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.6.0 - Production SQL>
but I cannot use the 10.2 version of sqlplus to connect to RANCQ:
Randws016:echo $ORACLE_HOME /home/p6258c/Solaris/10.2.0.3/instantclient_10_2 Randws016:$ORACLE_HOME/sqlplus RAN_WB/RAN_WB@RANCQ_RANDBS SQL*Plus: Release 10.2.0.3.0 - Production on Wed Aug 29 14:48:21 2007 Copyright (c) 1982, 2006, Oracle. All Rights Reserved. ERROR: ORA-12154: TNS:could not resolve the connect identifier specified Enter user-name:
Will had stated that he thought that 10.2 clients could talk to 9.2 servers. Is that true? If so why can't I run sqlplus and connect to RANCQ?