SQL+ Client Connection Issue - ORA-07200: slsid: oracle_sid not s et

  • From: "Chen, Sarah" <Sarah_Chen@xxxxxxxxx>
  • To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 3 Nov 2005 12:19:24 -0500

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


Other related posts:

  • » SQL+ Client Connection Issue - ORA-07200: slsid: oracle_sid not s et