Alert.log
Mon Feb 02 22:00:03 2015
Errors in file /opt/oracle/app/oracle/diag/rdbms/prod/prod/trace/prod_j004_14211.trc:
ORA-12012: error on auto execute of job “SYS”.”ORA$AT_SQ_SQL_SW_6362″
ORA-13717: Tuning Package License is needed for using this feature.
ORA-06512: at “SYS.PRVT_SMGUTIL”, line 52
ORA-06512: at “SYS.PRVT_SMGUTIL”, line 37
ORA-06512: at “SYS.PRVT_ADVISOR”, line 7382
ORA-06512: at “SYS.PRVT_ADVISOR”, line 7432
ORA-06512: at “SYS.PRVT_ADVISOR”, line 7485
ORA-06512: at “SYS.DBMS_ADVISOR”, line 238
ORA-06512: at “SYS.DBMS_SQLTUNE”, line 937
ORA-06512: at line 4
Trace soubor
Trace file /opt/oracle/app/oracle/diag/rdbms/prod/prod/trace/prod_j004_14211.trc
Oracle Database 12c Release 12.1.0.1.0 – 64bit Production
ORACLE_HOME = /opt/oracle/app/oracle/product/12.1.0/dbhome_1
System name: Linux
Node name: prod-db.dba.cz
Release: 2.6.18-400.1.1.el5
Version: #1 SMP Thu Dec 18 00:59:53 EST 2014
Machine: x86_64
Instance name: prod
Redo thread mounted by this instance: 1
Oracle process number: 104
Unix process pid: 14211, image: oracle@prod-db.dba.cz (J004)
*** 2015-02-02 22:00:03.475
*** SESSION ID:(45.31845) 2015-02-02 22:00:03.475
*** CLIENT ID:() 2015-02-02 22:00:03.475
*** SERVICE NAME:(SYS$USERS) 2015-02-02 22:00:03.475
*** MODULE NAME:(DBMS_SCHEDULER) 2015-02-02 22:00:03.475
*** ACTION NAME:(ORA$AT_SQ_SQL_SW_6362) 2015-02-02 22:00:03.475
ORA-12012: error on auto execute of job “SYS”.”ORA$AT_SQ_SQL_SW_6362″
ORA-13717: Tuning Package License is needed for using this feature.
ORA-06512: at “SYS.PRVT_SMGUTIL”, line 52
ORA-06512: at “SYS.PRVT_SMGUTIL”, line 37
ORA-06512: at “SYS.PRVT_ADVISOR”, line 7382
ORA-06512: at “SYS.PRVT_ADVISOR”, line 7432
ORA-06512: at “SYS.PRVT_ADVISOR”, line 7485
ORA-06512: at “SYS.DBMS_ADVISOR”, line 238
ORA-06512: at “SYS.DBMS_SQLTUNE”, line 937
ORA-06512: at line 4
Řešení
ORA-12012 ORA-13717 encountered after upgrading database to 12c (Doc ID 1920922.1)
SQL> select client_name,status from DBA_AUTOTASK_CLIENT;
CLIENT_NAME STATUS
—————————————————————- ——–
auto optimizer stats collection ENABLED
auto space advisor ENABLED
sql tuning advisor ENABLED
SQL> BEGIN
dbms_auto_task_admin.disable(
client_name => ‘sql tuning advisor’,
operation => NULL,
window_name => NULL);
END;
/
PL/SQL procedure successfully completed.
SQL> select client_name,status from DBA_AUTOTASK_CLIENT;
CLIENT_NAME STATUS
—————————————————————- ——–
auto optimizer stats collection ENABLED
auto space advisor ENABLED
sql tuning advisor DISABLED