ORACLE 一个监听开启多个实例

2016年10月14日 3750点热度 4人点赞 0条评论

现有一台机器，需要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

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

二○一六年十月十四日

本作品采用知识共享署名 4.0 国际许可协议进行许可