记录一次通过dblink访问adg出异常处理过程

xifenfei

数据库架构历史库通过dblink到ADG查询数据库，发现ORA-04045错误
sys@q9db1> SELECT ID, 'GE_BILL_PRINT_HISTORY'
  2      FROM USR_DML.GE_BILL_PRINT_HISTORY@TOQ9ADG
  3     WHERE PRINT_DATE >=
  4           TO_DATE('2013-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS')
  5       AND PRINT_DATE <
  6           TO_DATE('2013-01-31 00:00:00', 'YYYY-MM-DD HH24:MI:SS')
  7  ;
    FROM USR_DML.GE_BILL_PRINT_HISTORY@TOQ9ADG
                 *
ERROR at line 2:
ORA-04045: errors during recompilation/revalidation of USR_DML.GE_BILL_PRINT_HISTORY
ORA-16000: database open for read-only access
ORA-02063: preceding 2 lines from TOQ9ADG

adg库查询相关同义词
10:25:34 sys@Q9DB>select owner,object_type ,STATUS
10:25:41   2  from dba_objects where object_name='GE_BILL_PRINT_HISTORY' and owner='USR_DML';

OWNER                          OBJECT_TYPE         STATUS
------------------------------ ------------------- -------
USR_DML                        SYNONYM             INVALID


主库上重新编译同义词
alter synonym USR_DML.GE_BILL_PRINT_HISTORY compile;

travel.liu

好像刚才看到这个问题了