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!

ORA-27100: shared memory realm already exists

DBA2011Mar 28 2012 — edited Mar 29 2012

what's the fix , can't start db?

SQL> connect sys/******* as sysdba;
Connected to an idle instance.
SQL> startup;
ORA-27100: shared memory realm already exists
SQL> startup pfile='C:\Oracle\admin\clin\pfile\init.ora.226201215818'
ORA-27100: shared memory realm already exists
SQL>

i even followed this one
http://www.dba-oracle.com/t_ora_27100_shared_memory_realm_already_exists.htm

tail alert log
ORACLE V10.2.0.4.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows NT Version V5.2 Service Pack 2
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:2505M/4095M, Ph+PgF:3982M/5971M, VA:1924M/2047M
Wed Mar 28 16:43:54 2012
Starting ORACLE instance (normal)
Wed Mar 28 16:44:31 2012
Starting ORACLE instance (normal)
Wed Mar 28 16:45:31 2012
Starting ORACLE instance (normal)

Edited by: DBA2011 on Mar 28, 2012 3:48 PM

This post has been answered by Nelson Calero on Mar 28 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 26 2012

Added on Mar 28 2012

#general-database-discussions

2 comments

1,739 views