现有一台机器,需要oracle自动启动多个数据实例,并监听
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 |
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
这样就实现开机自动启动了。
二○一六年十月十四日