Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sqlplus works, isqlplus gives ora-27101
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
Check the values for ORACLE_HOME and ORACLE_SID
Daniel Morgan Received on Tue Jul 13 2004 - 00:34:02 CDT