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!

ORA-27101: shared memory realm does not exist and ORA-01139: RESETLOGS

753133Feb 11 2010 — edited Feb 18 2010
HI ALL,
After the oracle has installed on a solaries server successfully, i am unable to login into oracle database.

Below are the errors messages :

1) ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory

2) Media recovery complete.
alter database open resetlogs
*
ERROR at line 1:
ORA-01139: RESETLOGS option only valid after an incomplete database recovery.

and When i try to login into oracle as root .

this is the error :
sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Fri Feb 12 15:52:49 2010

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

ld.so.1: oracle: fatal: libskgxp10.so: open failed: No such file or directory
ERROR:
ORA-12547: TNS:lost contact

my Operating system details :
SunOS Blade3-Chassis2 5.10 Generic_142900-03 sun4v sparc SUNW,Netra-CP3060


Anyone please help me here. waiting for your reply.

Below are the ORACLE_SID Details :
1) echo $ORACLE_SID ----- > ems
2)ps -eaf | grep smon -------> ora_smon_ems
do you need any data?

Edited by: user8959150 on Feb 11, 2010 7:19 PM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 18 2010
Added on Feb 11 2010
8 comments
1,730 views