RE: SQL+ Client Connection Issue - ORA-07200: slsid: oracle_sid not set

Is the 9i database using the UTF8 character set? Or the AL32UTF8 character set? I know that AL32UTF8 was introduced in 9i, so it would be entirely plausible to me that an old 8.0.5 client would have difficulty with an unrecognized character set.

Is there a reason that you need to use a rather old version of the Oracle client on this machine? Any chance you could upgrade the client?

Justin Cave <jcave_at_ddbcinc.com>
Distributed Database Consulting, Inc.
http://www.ddbcinc.com

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Chen, Sarah Sent: Thursday, November 03, 2005 12:19 PM To: 'oracle-l_at_freelists.org'
Subject: SQL+ Client Connection Issue - ORA-07200: slsid: oracle_sid not set

Hi, everyone

Does anyone has any idea/solutions about the following situation we have?
Please help.

The problem is we have an application that connects to the database that is
currently running the Oracle 8.0.5 client on Solaris 5.6. This client does
not connect successfully to the Oracle 9i database running on Linux. The database we're trying to connect to is using the UTF8 character set and, when we attempt to connect, we get the following error message: SQL>
SQL> connect cdba_at_fcdb454_ITIDEV2
Enter password:
ERROR:
ORA-07200: slsid: oracle_sid not set.
Warning: You are no longer connected to ORACLE. SQL>
We know this client will successfully connect to other Oracle 9i databases
(non-UTF8) on the same server. We also know it will connect to a later version of Oracle 8i that uses the UTF8 character set. But it doesn't seem
to like the combination of Oracle 9i AND UTF8.

Thanks,
Sarah

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Thu Nov 03 2005 - 14:19:18 CST