| DBMS_AUTO_SQLTUNE [message #570129] |
Mon, 05 November 2012 15:30  |
 |
debrucer2
Messages: 6
Registered: August 2012
Location: San Diego California
|
Junior Member |
|
|
DBMS_AUTO_SQLTUNE was introduced in 11.2.0.2.0 and an interface for DBMS_SQLTUNE. We are on 64-bit Linux version 6.2.
SQLTUNE is working when manually executed; but, the AUTO is not. It fails with the following error stack:
Sun Nov 04 14:03:25 2012
Errors in file /u01/app/oracle/diag/rdbms/ritws/ritws/trace/ritws_j002_3438.trc:
ORA-12012: error on auto execute of job "SYS"."ORA$AT_SQ_SQL_SW_1428"
ORA-13605: The specified task or object SYS_AUTO_SQL_TUNING_TASK does not exist for the current user.
ORA-06512: at "SYS.PRVT_ADVISOR", line 2735
ORA-06512: at "SYS.DBMS_ADVISOR", line 241
ORA-06512: at "SYS.DBMS_SQLTUNE", line 821
ORA-06512: at line 4
There are no broken objects. I have rerun "$ORACLE_HOME/rdbms/admin/dbmssqlt.sql" which completed with no errors; however, no change.
Short of opening an SR with MOS, does anyone have any suggestions?
Thanks,
David R.
|
|
|
|
|
|
| Re: DBMS_AUTO_SQLTUNE [message #570152 is a reply to message #570129] |
Mon, 05 November 2012 23:54  |
 |
Michel Cadot
Messages: 54219
Registered: March 2007
Location: Nanterre, France, http://...
|
Senior Member
Account Moderator |
|
|
ORA-13605: The specified task or object %s does not exist for the current user.
*Cause: The user attempted to reference an advisor task or object
using a name that does not exist in the Advisor repository.
*Action: Adjust the name and retry the operation.
Regards
Michel
|
|
|
|
] 
Members
Search
Help
Register
Login
Home
