现有一台机器,需要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 这样就实现开机自动启动了。二○一六年十月十四日
评论区