Object Manager crashes with Errors "Oracle RAC is failing over" or "Oracle RAC failover ended"
(Doc ID 1214563.1)
Last updated on MAY 03, 2021
Applies to:Siebel CRM - Version 184.108.40.206  and later
Information in this document applies to any platform.
OM logs show following errors prior to crash:
DBA has developed a Script that killed DB session for long running SQL:
select 'REM SID: '||a.sid||' SERIAL#: '||a.serial#||' SQL ID: '||b.sql_id||chr(10)||' /*+ '||sql_fulltext||' */' from v\$session a, v\$sql b where b.address = a.sql_add
ress and program = 'siebmtshmw.exe' and command = 3 and status = 'ACTIVE' and last_call_et >= 300 and username = 'SADMIN';
select 'alter system kill session '||''''||sid||','||serial#||''''||';' from v\$session where program = 'siebmtshmw.exe' and command = 3 and status = 'ACTIVE' and last_c
all_et >= 300 and username = 'SADMIN';
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document