8i-11G 之间dblink 引起的ORA-04052错误

早上开发部门 发邮件说有如下问题，

查看应该是erp到rdap的dblink 引起的， 应该是某个trigger引起的

+---------------------------------------------------------------------------+

Inventory: Version : 12.0.0

 

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

 

A_INV_P_ON_BUILD_IN_WIP module: A_INV_P_ON_BUILD_IN_WIP(BOM非0版時_ON_BUILD_IN_WIP)

+---------------------------------------------------------------------------+

 

Current system time is 28-SEP-2011 21:00:33

 

+---------------------------------------------------------------------------+

 

**Starts**28-SEP-2011 21:00:33

ORACLE error 4045 in FDPSTP

 

Cause: FDPSTP failed due to ORA-04045: errors during recompilation/revalidation of APPS.A_MTL_SYSTEM_ITEMS_DESC_CHANGE

ORA-04052: error occurred when looking up remote objectSUPPORT.CIS_ITEMS@RDAP01.ASKEY.COM.TW

ORA-00604: er

+---------------------------------------------------------------------------+

Start of log messages from FND_FILE

+---------------------------------------------------------------------------+

+---------------------------------------------------------------------------+

End of log messages from FND_FILE

+---------------------------------------------------------------------------+

Successfully resubmitted concurrent program A_INV_P_ON_BUILD_IN_WIP with request ID 66450268 to start at 29-SEP-2011 01:00:31 (ROUTINE=AFPSRS

 

 

 

根据开发部门反映的时间 查询

select * from dba_objects where object_type='TRIGGER'
AND LAST_DDL_TIME > TO_DATE('2011/09/28 00:00:00','YYYY/MM/DD HH24:MI:SS');

 

 

可以查到这个trigger

看到这个trigger中有 更新dblink的语句

    ----------------  description 變動時同步更新CIS DB 資料
     begin
      update cis_items@rdap01
         set description=:new.description
       where part_number=:new.segment1;
     exception
            when others then
                 null;
     end;
    ----------------
      END IF;
END;

 

 

 

RDAP01好像是8i的，11g连到8i不支持。

 

ora920@[/home/ora920/jobs]:> sqlplus support/support@rdap01

 

SQL*Plus: Release 11.2.0.2.0 Production on Thu Sep 29 09:17:57 2011

 

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

 

ERROR:

ORA-03134: Connections to this server version are no longer supported.

 

 

解决办法将trigger 失效

alter trigger A_MTL_SYSTEM_ITEMS_DESC_CHANGE disable；

之后OK

 详情查看官方文档 Metalink's Document 207303.1

According to Metalink's Document 207303.1, both configurations Client 8i to Server 11g, and Client 11g to Server 8i are unsupported combinations, and should not be used.

"Unsupported combinations may appear to work but can encounter errors for particular operations. The fact that they appear to work should not be relied upon. Issues on unsupported combinations will not be investigated."

If you have access to Metalink, check that document out.

Specifically, if you attempt to connect from 11.1.0.6 to 8.1.7.4, your result is error ORA-03134 "connections to this server version are no longer supported."