Re: sqlplus works, isqlplus gives ora-27101

From: E <E_at_nowhere.nohow>
Date: Wed, 14 Jul 2004 02:33:50 GMT
Message-Id: <pan.2004.07.14.02.32.59.773852@nowhere.nohow>

On Tue, 13 Jul 2004 19:03:13 -0700, Prem K Mehrotra wrote:

> E <E_at_nowhere.nohow> wrote in message news:<pan.2004.07.13.21.30.20.970783_at_nowhere.nohow>...

>> On Tue, 13 Jul 2004 12:03:43 -0700, Yong Huang wrote:
>> 
>> > E <E_at_nowhere.nohow> wrote in message news:<pan.2004.07.13.10.59.05.97391_at_nowhere.nohow>...
>> >> >>>>I recently installed Oracle 10g on my Fedora Core 1 machine.  After
>>  ...
>> >> >>>>This sounds like isqlplus is looking for a different instance than
>> >> >>>>sqlplus.  Can anyone help me figure out what is going wrong?
>>  ...
>> >> > Check the values for ORACLE_HOME and ORACLE_SID
>> >> > 
>> >> > Daniel Morgan
>> >> 
>> >> They are obviously correct in the command line, or sqlplus
>> >> would not work.  From where should they be exported for the web-
>> >> based isqlplus?
>> >> 
>> >> Eric

>
>
> Have you looked in Oracle's Apache web server log/error files. I
> remember once I had
> problem with isqlplus (in Oracle9i) it had to do with some NLS_LANG
> setting,
> I think in Apache's config file, just a wild guess.
>

error_log doesn't show anything related to NLS_LANG, but I noticed that the environment information in /proc/<pid>/environ doesn't have a value for NLS_LANG. What should it be? I forget the actual values...

Thanks for your help
Eric Received on Tue Jul 13 2004 - 21:33:50 CDT