Re: Getting ORA-24365 via SQL*Plus (Please Help)

The problem is that your Sun Database is running a 7 bit character set (US7ASCII) and your NT Database is using a 8 bit character set (WE8ISO8859P1). You will have to change the character setting of one of your databases, and I don't think its as easy as changing the NLS setting in the init<sid>.ora file. I'm not really sure, ask around to be certain.

Good Luck

Regards,
Satar
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

In article <369B9B36.3B819876_at_ibm.net>,   brio152_at_ibm.net wrote:
>
> It's interesting that I can connect to the Alpha from the Sun, but not
> to the NT system.
> I checked the NT registry and saw NLS_LANG is set to
> AMERICAN_AMERICA.WE8ISO8859P1.
> Still don't know what it is set to on the Alpha and I'm not sure how to
> tell.
>
> I set the NLS_LANG environment on the Sun, but it didn't make a
> difference.
> setenv NLS_LANG AMERICAN_AMERICA.WE8ISO8859P1
>
> Does anyone have an answer to my problem?
>
> TIA,
>
> Jack
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Jan 13 1999 - 13:46:00 CST