ORA-27100: shared memory realm already exists
HI,
Suddenly one of my prod db has been down. While im trying to startup, getting 'ORA-27100: shared memory realm already exists" like below,
SQL*Plus: Release 9.2.0.7.0 - Production on Tue Jun 29 04:26:49 2010
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter user-name: / as sysdba
Connected to an idle instance.
SQL> startup
ORA-27100: shared memory realm already exists
SVR4 Error: 17: File exists
1> Oracle Version : 9.2.0.7
2> OS Version :
XXXXXXX:/oraXXXX/dump/bdump> uname -a
SunOS XXXXXXX 5.8 Generic_117350-33 sun4u sparc SUNW,Sun-Fire-V490
3> running in PFILE.
4> From alert_oraXXXX.log :
Sun Jun 27 09:23:36 2010
ARC0: Evaluating archive log 2 thread 1 sequence 200933
ARC0: Beginning to archive log 2 thread 1 sequence 200933
Creating archive destination LOG_ARCHIVE_DEST_1: '/oraXXXX/arc01/0001_0000200933.dbf'
ARC0: Completed archiving log 2 thread 1 sequence 200933
Sun Jun 27 09:32:32 2010
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 103
Sun Jun 27 09:32:38 2010
ALTER DATABASE CLOSE NORMAL
Sun Jun 27 09:32:38 2010
SMON: disabling tx recovery
SMON: disabling cache recovery
Sun Jun 27 09:32:38 2010
Shutting down archive processes
Archiving is disabled
Sun Jun 27 09:32:38 2010
ARCH shutting down
Sun Jun 27 09:32:38 2010
ARCH shutting down
Sun Jun 27 09:32:38 2010
ARC0: Archival stopped
Sun Jun 27 09:32:38 2010
ARC1: Archival stopped
Sun Jun 27 09:32:39 2010
Thread 1 closed at log sequence 200934
Successful close of redo thread 1
Sun Jun 27 09:32:39 2010
Completed: ALTER DATABASE CLOSE NORMAL
Sun Jun 27 09:32:39 2010
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
5> SGA Size : 700M
6> RAM Size :
XXXXXXXX> prtconf|grep -i mem
Memory size: 16384 Megabytes
memory (driver not attached)
virtual-memory (driver not attached)
memory-controller, instance #0
memory-controller, instance #1
memory-controller, instance #2
memory-controller, instance #3
Thanks in advance!