Oracle database crashing frequently with ORA-600 error
Hi,
Our prod environment is using Oracle EBS: 11.5.10.2
Database version: 11.2.0.1.5
The database was upgraded from 9i to 11gr2 few months back. Since then we didn't have any issue. But last 2 days the database is crashing at 10:00 pm every night.
The alert log shows the below error.
*** 2012-01-27 22:02:45.351
*** SESSION ID:(636.29667) 2012-01-27 22:02:45.351
*** CLIENT ID:() 2012-01-27 22:02:45.351
*** SERVICE NAME:(SYS$USERS) 2012-01-27 22:02:45.351
*** MODULE NAME:(DBMS_SCHEDULER) 2012-01-27 22:02:45.351
*** ACTION NAME:(ORA$AT_SQ_SQL_SW_4286) 2012-01-27 22:02:45.351
Our prod environment is using Oracle EBS: 11.5.10.2
Database version: 11.2.0.1.5
The database was upgraded from 9i to 11gr2 few months back. Since then we didn't have any issue. But last 2 days the database is crashing at 10:00 pm every night.
The alert log shows the below error.
*** 2012-01-27 22:02:45.351
*** SESSION ID:(636.29667) 2012-01-27 22:02:45.351
*** CLIENT ID:() 2012-01-27 22:02:45.351
*** SERVICE NAME:(SYS$USERS) 2012-01-27 22:02:45.351
*** MODULE NAME:(DBMS_SCHEDULER) 2012-01-27 22:02:45.351
*** ACTION NAME:(ORA$AT_SQ_SQL_SW_4286) 2012-01-27 22:02:45.351
Dump continued from file: \PROD\PRODDB\diag\rdbms\prod\prod\trace\prod_j002_3348.trc
ORA-00600: internal error code, arguments: [rworupo.2], [2], [1], [], [], [], [], [], [], [], [], []
Also if we check the below:
0