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

Mathijs wrote:
> 01 nov 2006, (Charles Hooper):
>
> > Check the initialization file, check the alert log.
>
> The init.ora only contains valid paths (the installation was done 'out of
> the box', and I tried to stick to the defaults... I did not edit the
> config files manually). The alert_xe.log file contains no data after the
> third reboot (1 nov). I don't know what the look for in the alert_xe.log.
> I've copied the content below, starting from thursday 26th of october.
>
> Thanks in advance,
> M.
>
>
> [alert_xe.log]
> Thu Oct 26 11:20:04 2006
> db_recovery_file_dest_size of 10240 MB is 0.98% used. This is a
> user-specified limit on the amount of space that will be used by this
> database for recovery-related files, and does not reflect the amount of
> space available in the underlying filesystem or ASM diskgroup.
> Dump file f:\oraclexe\app\oracle\admin\xe\bdump\alert_xe.log
> Mon Oct 30 11:35:02 2006
> ORACLE V10.2.0.1.0 - Production vsnsta=0
> vsnsql=14 vsnxtr=3
> Windows Server 2003 Version V5.2 Service Pack 1
> CPU : 1 - type 586, 1 Physical Cores
> Process Affinity : 0x00000000
> Memory (Avail/Total): Ph:957M/1271M, Ph+PgF:1514M/1697M, VA:1933M/2047M
> Mon Oct 30 11:35:02 2006
> Mon Oct 30 11:35:58 2006
> Memory Notification: Library Cache Object loaded into SGA
> Heap size 2208K exceeds notification threshold (2048K)
> KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==

I don't have access to XE here, so the commands might be a little different. It could be that the PATH statement, or one of the other environment variables is not set correctly, the service is not set to auto-start, or the initialization files can't be found or are corrupt.

As a starting point, open a command prompt and enter the following: C:\> PATH The path should include the Oracle home bin folder, which might be:   F:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\db_1\bin

Then, make certain that the spfile is in the expected location: C:\> DIR F:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA Check the registry to make certain that the correct values are entered.  The values will likely be located near: HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ Verify that the Oracle related services are set to Automatic startup and that their status is Started.

Try to connect to Oracle as the SYS user, from a command prompt:

C:\> SQLPLUS /NOLOG
SQL> CONNECT SYS/MY_SECRET_PASSWORD_at_XE AS SYSDBA
SQL> STARTUP

If the XE database instance fails to start, take a look inside the spfile, again from a command prompt:
C:\> TYPE F:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA The file will contain binary characters - do not be too concerned with that. Look through the output, are the values specified in the spfile the same as what you posted as listed in the alert file?
> sga_target = 348127232
> control_files = F:\ORACLEXE\ORADATA\XE\CONTROL.DBF
> __db_cache_size = 226492416
> compatible = 10.2.0.1.0
> db_recovery_file_dest = F:\oraclexe\app\oracle\flash_recovery_area
> db_recovery_file_dest_size= 10737418240
> undo_management = AUTO
> undo_tablespace = UNDO

...

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Wed Nov 01 2006 - 07:59:50 CST