Re: sqlplus works, isqlplus gives ora-27101

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.

Prem
> >
> > Eric,
> >
> > You seem to be using Linux. Check the environment of a running process
> > by cat /proc/<pid>/environ, where <pid> is the ID of isqlplus. Compare
> > ORACLE_HOME and ORACLE_SID with those of your shell.
> >
> > Yong Huang
>
> I assume the following is the correct process:
>
> oracle 8898 3.2 5.8 250492 30040 pts/0 S 17:27 0:03
> /usr/local/oracle/product/10.1.0/db_1/jdk/bin/java
> -Djava.awt.headless=true
> -Doracle.oc4j.localhome=/usr/local/oracle/product/10.1.0/db_1/sqlplus
> -Djava.security.properties=/usr/local/oracle/product/10.1.0/db_1/oc4j/j2ee/home/config/jazn.security.props
> -jar
>
> Checking /proc/8898/environ I see that ORACLE_SID=ORCL and
> ORACLE_HOME=/usr/local/oracle/product/10.1.0/db_1, both of which
> are correct and match the values set in my shell...
>
> Eric
Received on Tue Jul 13 2004 - 21:03:13 CDT