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 -> sqlplus works, isqlplus gives ora-27101

sqlplus works, isqlplus gives ora-27101

From: E <E_at_nowhere.nohow>
Date: Tue, 13 Jul 2004 03:13:44 GMT
Message-Id: <pan.2004.07.13.03.12.57.133585@nowhere.nohow>


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 Received on Mon Jul 12 2004 - 22:13:44 CDT

Original text of this message

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