Home » RDBMS Server » Server Administration » Oracle shutdowns while setting the RESOURCE_MANAGER_PLAN (Oracle 10.2.0.4, RHEL-4)
Oracle shutdowns while setting the RESOURCE_MANAGER_PLAN [message #460305] Thu, 10 June 2010 09:15 Go to next message
ArbindK
Messages: 3
Registered: June 2010
Location: Kathmandu, Nepal
Junior Member
Hi,
The Oracle Instance gets down while setting the Resource_manager_plan with internal error in trace file:
SQL> ALTER SYSTEM SET RESOURCE_MANAGER_PLAN='EST_EXEC_TM';
ALTER SYSTEM SET RESOURCE_MANAGER_PLAN='EST_EXEC_TM'
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel

Trace File Log:
error 600 detected in background process
ORA-00600: internal error code, arguments:
[kkkdplr:!efn], [1279729], [], [], [], [], [], []
Where as same is working in other server. Any possible solution to resolve this ?
Re: Oracle shutdowns while setting the RESOURCE_MANAGER_PLAN [message #460306 is a reply to message #460305] Thu, 10 June 2010 09:16 Go to previous messageGo to next message
cookiemonster
Messages: 13923
Registered: September 2008
Location: Rainy Manchester
Senior Member
ORA-00600 means oracle bug means contact oracle support.
Re: Oracle shutdowns while setting the RESOURCE_MANAGER_PLAN [message #460307 is a reply to message #460305] Thu, 10 June 2010 09:17 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support
Re: Oracle shutdowns while setting the RESOURCE_MANAGER_PLAN [message #460339 is a reply to message #460307] Thu, 10 June 2010 10:58 Go to previous message
ArbindK
Messages: 3
Registered: June 2010
Location: Kathmandu, Nepal
Junior Member
Thanks to both of you for your suggestions. Oracle Support is working on this undocumented bug.
Previous Topic: Database down often
Next Topic: db creation ctl error
Goto Forum:
  


Current Time: Sun May 19 19:02:38 CDT 2024