Re: ORA-27101: shared memory realm does not exist

Mathijs wrote:
> Hi,
>
> I installed OracleExpress on a windows 2003 server. Right after the
> installation, I was able to create and use a database. Then, after the
> first reboot, the database didn't start automatically, but after
> SQL> connect /
> SQL> startup
> things worked fine again. Now, after a third reboot, this trick doesn't
> work anymore:
> SQL> connect /
> ERROR:
> ORA-01034: ORACLE not available
> ORA-27101: shared memory realm does not exist
>
> Q: How can I fix this? (there is already data in my database that I
> really would like to use) And that Oracle behaves differently after the
> second and the third reboot?
>
> Thanks in advance for your help. Below is the result of a few obvious
> things that I checked before posting this message.
>
> M.
>
>
> I've checked the ORACLE_SID in the environment and it is set to XE.
> >set
> ...
> ORACLE_SID=XE
> ...
>
> The listener is running:
> >lsnrctl status XE
> STATUS of the LISTENER
> ------------------------
> Alias LISTENER
> Version TNSLSNR for 32-bit W..: Ver.. 10.2.0.1.0 - Production
> Start Date 01-NOV-2006 10:29:36
> Uptime 0 days 0 hr. 1 min. 22 sec
> Trace Level off
> Security ON: Local OS Authentication
> SNMP OFF
> Default Service XE
>
> and tnsping works:
> >tnsping xe
> ...
> OK (30 msec)

Problems that I have seen which cause the problem (check the alert log):
init.ora or spfile contains LOG_ARCHIVE_START, which is depreciated init.ora or spfile contains DB_RECOVERY_FILE_DEST, string cannot be translated

The init.ora or spfile may specify a folder that does not exist, or other file which does not exist. You may have attempted to edit the spfile using Notepad - this will corrupt the binary file.

Check the initialization file, check the alert log.

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Wed Nov 01 2006 - 06:00:17 CST