注意设置grid用户下的
listener.ora
su - grid
cd /u01/app/grid/product/11.2.0/grid
vi listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = db-dg)(PORT = 1521)) --填写本机主机名或者IP地址也可以
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = orcldb) --填写实例名
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
(GLOBAL_DBNAME= orcldb_dg) --填写服务名
)
)
黄色字部分为自己修改的部分,注意绿色部分填写的是oracle用户下的$ORACLE_HOME路径
这里需要注意,修改完listener.ora文件后,需要重启监听
grid用户下
srvctl stop listener
srvctl start listener
后续再用oracle用户开listener.ora
su - grid
cd /u01/app/grid/product/11.2.0/grid
vi listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = db-dg)(PORT = 1521)) --填写本机主机名或者IP地址也可以
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = orcldb) --填写实例名
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
(GLOBAL_DBNAME= orcldb_dg) --填写服务名
)
)
黄色字部分为自己修改的部分,注意绿色部分填写的是oracle用户下的$ORACLE_HOME路径
这里需要注意,修改完listener.ora文件后,需要重启监听
grid用户下
srvctl stop listener
srvctl start listener
后续再用oracle用户开listener.ora
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/28371090/viewspace-2152225/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/28371090/viewspace-2152225/