Re: sqlplus works, isqlplus gives ora-27101

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

Daniel Morgan Received on Mon Jul 12 2004 - 22:24:19 CDT