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: E <E_at_nowhere.nohow>
Date: Tue, 13 Jul 2004 04:05:53 GMT
Message-Id: <pan.2004.07.13.04.05.06.692665@nowhere.nohow>


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 Received on Mon Jul 12 2004 - 23:05:53 CDT

Original text of this message

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