Re: ORA-27101 hell!!!

Chris Clarke wrote:

>Hi all,
>
>I've installed Oracle 8.1.7 EE on RedHat 7.2 (as per install guide,
>v2.1 gcc libs etc.)
>
>I managed to create an instance "O817DB" using dbassist.
>
>I started the instance as follows:
>
>$ sqlplus internal
>
>SQL> startup
>
>The startup procedures gave no errors.
>
>I then tried to get into the DB as follows:
>
>$ sqlplus system/manager
>
>No problems there either. I could run queries, create users, etc.
>
>Now I tried to start the TNS listener:
>
>$ lsnrctl start
>
>Doing:
>
>$ lsnrctl status
>
>...revealed that I had 1 service handler for O817DB as expected. So I
>tried to connect to the machine again using:
>
>$ sqlplus system/manager_at_O817DB
>
>Bang! Produced this error:
>
>ORA-01034: ORACLE not available
>ORA-27101: shared memory realm does not exist
>Linux Error: 2: No such file or directory
>
>I found some information in the Net8 installation guide about adding
>the listener to the /etc/services file, which I did as follows:
>
>LISTENER 1521/tcp # Net*8
>
>Rebooted, restarted, same again. The $ORACLE_SID and $ORACLE_HOME are
>correct. The database instance is definately alive as I managed to log
>on locally - I even managed to get "emca" (Enterprise Manager
>Configuration Assistant) to create a repository on the database (using
>localhost:1521:O817DB as a connection string).
>
>Anyone got any ideas before I throw the machine out of the window and
>book myself into the loony bin???
>
>Thanks,
>
>Chris
>
>

You indicate that you followed the installation instructions so my usual advice will probably not
be valid but you get it anyway. Verify that shared memory and semaphore values are set correctly.

After that ... read the alert log in bdump for additional clues.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)