Re: sqlplus works, isqlplus gives ora-27101

From: E <E_at_nowhere.nohow>
Date: Tue, 13 Jul 2004 10:59:55 GMT
Message-Id: <pan.2004.07.13.10.59.05.97391@nowhere.nohow>

On Mon, 12 Jul 2004 22:34:02 -0700, Daniel Morgan wrote:

> E wrote:

>> On Mon, 12 Jul 2004 20:24:19 -0700, Daniel Morgan wrote:
>>
>>

>>>E wrote:
>>>
>>>
>>>>I recently installed Oracle 10g on my Fedora Core 1 machine.  After
>>>>the install, isqlplus was working, but the command line sqlplus
>>>>was not.  After adding the compatibility setting to initORCL.ora,
>>>>I was able to get both working.
>>>>
>>>>Since that time, the box has been rebooted, and I cannot seem to
>>>>get isqlplus working again.  When the machine boots, I manually
>>>>log in as oracle, connect to sqlplus and start the instance, then
>>>>run lsnrctl start and isqlplus start to start the listener and
>>>>isqlplus processes manually.  However, when I try to log into the
>>>>system using isqlplus, I get ORA-01034 Oracle not available 
>>>>ORA-27101: shared memory realm does not exist Linux Error: 2: No 
>>>>such file or directory.  I can still log in through the command
>>>>line, though.
>>>>
>>>>This sounds like isqlplus is looking for a different instance than
>>>>sqlplus.  Can anyone help me figure out what is going wrong?
>>>>
>>>>Thanks in advance
>>>>Eric
>>>
>>>Changes to init.ora are meaningless unless compiled into the spfile.
>>>http://www.psoug.org/reference/library.html
>>>and search for SPFile

>>
>>
>> Thanks for your response. I did that and it doesn't seem to have
>> had any affect:
>> SQL> shutdown
>> Database closed.
>> Database dismounted.
>> ORACLE instance shut down.
>> SQL> create spfile from pfile='initORCL.ora';
>>
>> SQL> show parameter spfile
>>
>> NAME TYPE VALUE
>> --------- ------- ------------------------------
>> spfile string /usr/local/oracle/product/10.1.0/db_1/dbs/spfileORCL.ora
>>
>> SQL> startup
>> ORACLE instance started.
>>
>> Total System Global Area 96468992 bytes
>> Fixed Size 777576 bytes
>> Variable Size 95429272 bytes
>> Database Buffers 0 bytes
>> Redo Buffers 262144 bytes
>> Database mounted.
>> Database opened.
>>
>> Any other pointers are greatly appreciated!
>> Eric

> 
> 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 webbased  isqlplus?

Eric Received on Tue Jul 13 2004 - 05:59:55 CDT