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

Hi Sarah,

I had a similar problem to this before, connecting from 8.1.7. to 9i (on Solaris). It was to do with a mismatch in the character sets, one being UTF8. *But* I cannot remember all of the details.... I have searched metalink and some oracle-l achives and cannot find my old posts :-(

If you have access to Metalink, then take a look at Doc ID: Note:237593.1 it is related and hopefully, may help you out.

Tony
----- Original Message -----
From: "Chen, Sarah" <Sarah_Chen_at_BUDCO.com> To: <oracle-l_at_freelists.org>
Sent: Thursday, November 03, 2005 6:19 PM 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