Database ORA-600 / ORA-7445 Analysis , Diagnostic Repository (ADR) & Packaging (MOSC)

MOSC Banner

In 12.2 Auto Space Advisor Job Fails With ORA-60 (Doc ID 2321020.1)

After upgrade to 12.2 , space advisor job fails and the following message appears on the alert log:

ORA-00060: deadlock resolved; details in file /opt/oracle/diag/rdbms/oratest/oratest/trace/oratest_j001_162692.trc <<< Deadlock Trace File
Errors in file /opt/oracle/diag/rdbms/oratest/oratest/trace/oratest_j001_162692.trc
ORA-12012: error on auto execute of job "SYS"."ORA$AT_SA_SPC_SY_2629"
ORA-00060: deadlock detected while waiting for resource
ORA-06512: at "SYS.DBMS_SPACE", line 2741
ORA-06512: at "SYS.DBMS_HEAT_MAP_INTERNAL", line 716
ORA-06512: at "SYS.DBMS_HEAT_MAP_INTERNAL", line 1164
ORA-06512: at "SYS.DBMS_HEAT_MAP", line 228

Oracle provides any patch to fix this problem?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center