Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle 10G - ORA-27100 & ORA-27101 shared memory realm

419978May 27 2004 — edited Jun 29 2004
Suddenly my database started having this issue :

I set ORACLE_SID=Build
sqlplus /nolog
connect sys/dba as sysdba
Connected to an idle instance.
startup

I get the error
ORA-27100: shared memory realm already exists
and so I run
shutdown

I get the error
ORA-27101: shared memory realm does not exist

I delete and recreated the instance, I deleted the password file and recreated the password file.. but the problem still exists. I rebooted the machine but I am not able to start the database. I am not able to connect to the database.

Database Verion : 10.1.0.2.0
Windows Version : Microsoft Windows Server 2003 Advanced Server

There are not errors or any trace files. Alert log just shows this :
Thu May 27 10:33:35 2004
ORACLE V10.1.0.2.0 - Production vsnsta=0
vsnsql=13 vsnxtr=3
Windows Server 2003 Version V5.2
CPU : 1 - type 586, 1 Physical Cores
Process Affinity: 0x00000000
Memory (A/P) : PH:2582M/3069M, PG:4637M/4964M, VA:1959M/2047M
Thu May 27 10:33:35 2004
Starting ORACLE instance (normal)
Thu May 27 10:34:43 2004
Starting ORACLE instance (normal)

Any help in this is greatly appreciated.

-Nags
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 27 2004
Added on May 27 2004
2 comments
1,025 views