Oracle Database Discussions

Hi All

We are on 11.2.0.1 database, in alert log iam getting this below error,

Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
Error 604 trapped in 2PC on transaction 9.6.313682. Cleaning up.
Error stack returned to user:
ORA-00604: error occurred at recursive SQL level 2
ORA-02047: cannot join the distributed transaction in progress
ORA-06512: at "SYS.HS$_DDTF_SQLTABLES", line 58
ORA-06512: at line 1
SYS_AUTO_SQL_TUNING_TASK exiting with error "2063" for execution "EXEC_9367". See DBA_ADVISOR_EXECUTIONS for more details.
End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
Errors in file /ebiz/oracle/proddb/11.2.0/diag/rdbms/prod/PROD/trace/PROD_j001_2544.trc:
ORA-12012: error on auto execute of job 965257
ORA-02063: preceding 6 lines from MSQL
ORA-06512: at "SYS.PRVT_ADVISOR", line 2693
ORA-06512: at "SYS.DBMS_ADVISOR", line 241
ORA-06512: at "SYS.DBMS_SQLTUNE", line 772
ORA-06512: at line 4

here MSQL is a database link, link will take data from sql server to oracle database.

The Trace file Content:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /ebiz/oracle/proddb/11.2.0
System name: Linux
Node name: odhdbprod.omniyat.local
Release: 2.6.9-42.ELsmp
Version: #1 SMP Wed Jul 12 23:27:17 EDT 2006
Machine: i686
Instance name: PROD
Redo thread mounted by this instance: 1
Oracle process number: 122
Unix process pid: 2544, image: oracle@odhdbprod.omniyat.local (J001)


*** 2012-09-27 00:07:54.178
*** SESSION ID:(236.32554) 2012-09-27 00:07:54.178
*** CLIENT ID:() 2012-09-27 00:07:54.178
*** SERVICE NAME:(SYS$USERS) 2012-09-27 00:07:54.178
*** MODULE NAME:(DBMS_SCHEDULER) 2012-09-27 00:07:54.178
*** ACTION NAME:(ORA$AT_SQ_SQL_SW_1428) 2012-09-27 00:07:54.178

ORA-12012: error on auto execute of job 965257
ORA-02063: preceding 6 lines from MSQL
ORA-06512: at "SYS.PRVT_ADVISOR", line 2693
ORA-06512: at "SYS.DBMS_ADVISOR", line 241
ORA-06512: at "SYS.DBMS_SQLTUNE", line 772
ORA-06512: at line 4


Please share your valuable thoughts on this


Thanks
Shaik

Edited by: Shaik on Sep 26, 2012 11:03 PM