Re: sqlplus works, isqlplus gives ora-27101

E <E_at_nowhere.nohow> wrote in message news:<pan.2004.07.14.02.32.59.773852_at_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

Eric:
NLS_LANG=AMERICAN_AMERICA.US7ASCII in my enviornment, but not sure that is the cause of your problem.

Prem Received on Wed Jul 14 2004 - 19:26:26 CDT