RE: SQL+ Client Connection Issue - ORA-07200: slsid: oracle_sid not set
- From: "Justin Cave (DDBC)" <jcave@xxxxxxxxxxx>
- To: <Sarah_Chen@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 3 Nov 2005 13:17:04 -0700
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@xxxxxxxxxxx>
Distributed Database Consulting, Inc.
http://www.ddbcinc.com
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Chen, Sarah
Sent: Thursday, November 03, 2005 12:19 PM
To: 'oracle-l@xxxxxxxxxxxxx'
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@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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
