Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sqlplus works, isqlplus gives ora-27101

Re: sqlplus works, isqlplus gives ora-27101

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Mon, 12 Jul 2004 22:34:02 -0700
Message-ID: <1089696858.424331@yasure>


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 Received on Tue Jul 13 2004 - 00:34:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US