【标记】在进行数据迁移时；出现

Compilation errors for PROCEDURE ZDGAME.GFF_FETCH_MZR_LOGError: ORA-04052: error occurred when looking up remote object mf_game_db.g_account@MZRA_ALL       ORA-00604: error occurred at recursive SQL level 1       ORA-02020: too many database links in useLine: 1Text: CREATE OR REPLACE PROCEDURE gff_fetch_mzr_log(v_yesterday VARCHAR2) IS　　

单独通过dblink去查是OK；但是编译存储过程会出现上面问题。问题出现在参数上面

下面是解决方案：

[oracle@bjmxy_server12_17 admin]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on Tue Jul 14 14:20:24 2015Copyright (c) 1982, 2009, Oracle.  All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> show parameter open_linksNAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------open_links                           integer     4open_links_per_instance              integer     4SQL> alter system set open_links=50;alter system set open_links=50                 *ERROR at line 1:ORA-02095: specified initialization parameter cannot be modifiedSQL>  alter system set open_links=200 scope=spfile;System altered.SQL>  alter system set open_links_per_instance=200 scope=spfile;System altered.SQL> show parameter open_linksNAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------open_links                           integer     4open_links_per_instance              integer     4SQL> shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.SQL> startupORACLE instance started.Total System Global Area 2.0310E+10 bytesFixed Size                  2212976 bytesVariable Size            1.5301E+10 bytesDatabase Buffers         4831838208 bytesRedo Buffers              175132672 bytesDatabase mounted.Database opened.SQL> show parameter open_linksNAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------open_links                           integer     200open_links_per_instance              integer     200