oracle扩展dblink数。

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

Compilation errors for PROCEDURE ZDGAME.GFF_FETCH_MZR_LOG

Error: 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 use
Line: 1
Text: CREATE OR REPLACE PROCEDURE gff_fetch_mzr_log(v_yesterday VARCHAR2) IS　　

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

下面是解决方案：

[oracle@bjmxy_server12_17 admin]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Tue Jul 14 14:20:24 2015

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> show parameter open_links

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
open_links                           integer     4
open_links_per_instance              integer     4
SQL> alter system set open_links=50;
alter system set open_links=50
                 *
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified


SQL>  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_links

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
open_links                           integer     4
open_links_per_instance              integer     4
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 2.0310E+10 bytes
Fixed Size                  2212976 bytes
Variable Size            1.5301E+10 bytes
Database Buffers         4831838208 bytes
Redo Buffers              175132672 bytes
Database mounted.
Database opened.
SQL> show parameter open_links

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
open_links                           integer     200
open_links_per_instance              integer     200