ORACLE 一个监听开启多个实例

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

示例图:

 

开机自动启动

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

 

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

 

二○一六年十月十四日

点赞