ORA-27101: shared memory realm does not exist

[Ellen Zhao]

Hi folks,

just installed the latest release of Oracle DB 10g enterprise edition in my SuSE linux 9.2 box. The installation went pretty smoothly. After the installation the db was up and I tried sqlplus and isqlplus and the html em port, everything worked perfectly (that means, all the hardware and kernel parameter requirements were met). But after a reboot, when I tried to run sqlplus again, got message like this:

ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist

I googled for solution:
result
got tons of hints but unfortunately no right-to-the-point _solution_. The most impressive one is here:
http://www.freelists.org/archives/oracle-l/01-2005/msg01043.html

Frustrated. I just want to get the DB up and work, tons of tasks at hand, really no luxury to read that much text just in order to get several lines of environment configuration right. Anyone who could kindly tell me which file(s) to configure and how please? I would be much obliged!

Here're the oracle processes after the reboot:

 ellen@reticent:/opt/oracle/OraHome_1/network/admin> ps -ef |grep oracle
oracle    6617     1  0 04:11 ?        00:00:00 /bin/su -l oracle -c exec /opt/oracle/OraHome_1/bin/ocssd
oracle    6662  6617  0 04:11 ?        00:00:00 /opt/oracle/OraHome_1/bin/ocssd.bin
ellen     7884  7562  0 05:33 pts/5    00:00:00 grep oracle
 

Best Regards,
Ellen
[ May 31, 2005: Message edited by: Ellen Zhao ]

[Avi Abrami]

Ellen,
Pardon me if I am stating the obvious, but Oracle doesn't automatically start up when you boot your linux system -- unless you have configured it to do so. And from your description, it appears that you have not configured Oracle to start up automatically when your system boots up.

For your information, you can use SQL*Plus to start up Oracle. This is described in the Oracle documentation -- which is available from:

http://tahiti.oracle.com

I don't use 10g, so I think it is probably best if you refer to the documentation in order to get the exact syntax of the command. Try the "Database Administrator's Guide", it usually has a chapter on how to start up the database.

Good Luck,
Avi.