ORACLE 一个监听开启多个实例

2016-10-14

现有一台机器，需要oracle自动启动多个数据实例，并监听

SID_LIST_LISTENER_orcl =
    (SID_LIST =
      (SID_DESC =
      (SID_NAME = orcl)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
      (PROGRAM = extproc)
      (GLOBAL_DBNAME = orcl)
    )
LISTENER_orcl =  
      (DESCRIPTION_LIST =  
        (DESCRIPTION =  
          (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.75.131)(PORT = 1521)(IP = FIRST))  
        )  
      )  
SID_LIST_LISTENER_test1 =
     (SID_LIST = 
      (SID_DESC =
      (SID_NAME = test1)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
      (PROGRAM = extproc)
      (GLOBAL_DBNAME = test1)
      )
    )
LISTENER_test1 =
      (DESCRIPTION_LIST =
        (DESCRIPTION =
          (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.75.131)(PORT = 1521)(IP = FIRST))
        )
      )

SID_LIST_LISTENER_orcl =

(SID_LIST =

(SID_DESC =

(SID_NAME = orcl)

(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)

(PROGRAM = extproc)

(GLOBAL_DBNAME = orcl)

)

LISTENER_orcl =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.75.131)(PORT = 1521)(IP = FIRST))

)

SID_LIST_LISTENER_test1 =

(SID_LIST =

(SID_DESC =

(SID_NAME = test1)

(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)

(PROGRAM = extproc)

(GLOBAL_DBNAME = test1)

)

LISTENER_test1 =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.75.131)(PORT = 1521)(IP = FIRST))

)

示例图：

开机自动启动

修改/etc/oratab文件，将需要启动的实例名称后面的N修改为Y,如果要全部都启动，则使用
:g/N/s//Y/g将全部N修改为Y

这样就实现开机自动启动了。

二○一六年十月十四日

阅读剩余

作者：龙魂

链接：https://blog.wlzs.cn/oracle-%e4%b8%80%e4%b8%aa%e7%9b%91%e5%90%ac%e5%bc%80%e5%90%af%e5%a4%9a%e4%b8%aa%e5%ae%9e%e4%be%8b/

文章版权归作者所有，未经允许请勿转载。

THE END