Re: sqlplus works, isqlplus gives ora-27101

From: E <E_at_nowhere.nohow>
Date: Tue, 13 Jul 2004 21:31:10 GMT
Message-Id: <pan.2004.07.13.21.30.20.970783@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

>
> 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 - 16:31:10 CDT