ORA-27140: attach to post/wait facility failed

P720:/u01/app_new/product/11.2/bin$rman target /

Recovery Manager: Release 11.2.0.3.0 - Production on Thu May 30 20:14:51 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-27140: attach to post/wait facility failed
ORA-27300: OS system dependent operation:invalid_egid failed with status: 1
ORA-27301: OS failure message: Not owner
ORA-27302: failure occurred at: skgpwinit6
ORA-27303: additional information: startup egid = 1000 (oinstall), current egid = 1100 (asmadmin)
P720:/u01/app_new/product/11.2/bin$

P720:/u01/app_new/product/11.2/bin$ ls -l oracle
-rwsr-s--x    1 oracle   asmadmin  300832042 May 30 18:55 oracle
P720:/u01/app_new/product/11.2/bin$
P720:/u01/app_new/product/11.2/bin$ls -l |grep dba
-rwxr-xr-x    1 oracle   oinstall       9439 May 30 18:55 osdbagrp
-rwxr-xr-x    1 oracle   oinstall       9250 Oct 05 2011  osdbagrp0
P720:/u01/app_new/product/11.2/bin$

# pwd
/u01/app_new/product/11.2/bin
# ls -l oracle
-rwsr-s--x    1 oracle   asmadmin  300832042 May 30 18:55 oracle
# chown oracle:oinstall oracle
# ls -l oracle
-rwsr-s--x    1 oracle   oinstall  300832042 May 30 18:55 oracle
#

P720:/u01/app_new/product/11.2/bin$rman target /

Recovery Manager: Release 11.2.0.3.0 - Production on Thu May 30 20:18:55 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: SGERP5 (DBID=3580899532, not open)

RMAN>

 

 

 

 

 

 

 

 

 

SQL> startup
ORACLE instance started.

Total System Global Area 3.7413E+10 bytes
Fixed Size                  2229304 bytes
Variable Size            3.3152E+10 bytes
Database Buffers         4160749568 bytes
Redo Buffers               98418688 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00704: bootstrap process failure
ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 1
ORA-01555: snapshot too old: rollback segment number 118 with name
"_SYSSMU118_28602772$" too small
Process ID: 11075710
Session ID: 937 Serial number: 3

Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_ora_15073518.trc:
ORA-00704: bootstrap process failure
ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 1
ORA-01555: snapshot too old: rollback segment number 118 with name "_SYSSMU118_28602772$" too small
Errors in file /u01/app/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_ora_15073518.trc:
ORA-00704: bootstrap process failure
ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 1
ORA-01555: snapshot too old: rollback segment number 118 with name "_SYSSMU118_28602772$" too small
Error 704 happened during db open, shutting down database
USER (ospid: 15073518): terminating the instance due to error 704
Instance terminated by USER, pid = 15073518
ORA-1092 signalled during: ALTER DATABASE OPEN...
opiodr aborting process unknown ospid (15073518) as a result of ORA-1092
Thu May 30 16:41:45 2013
ORA-1092 : opitsk aborting process

*.undo_management='MANUAL'
*._offline_rollback_segments=(_SYSSMU118_28602772$)
*._offline_rollback_segments=true
*._corrupted_rollback_segments=(_SYSSMU118_28602772$)

alter system set "_corrupted_rollback_segments"="_SYSSMU118_28602772$" scope=spfile;

 alter system set db_block_checking=false;
 alter system set db_block_checksum=false;

SQL> select * from v$recover_file;
ERROR:
ORA-03114: not connected to ORACLE