Oracle 11g RAC环境下单实例非缺省监听及端口配置(三)
name 'LISTENER_CNBO'
--对于前面出现的错误，给出两种解决方案，
--一是按照前面local_listener参数值的格式设置新的ip及端口，或者将这个描述信息添加到tnsnames.ora文件中
--下面我们选用了第二种解决方案
[oracle@linux1 ~]$ echo "
> LISTENER_CNBO =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.7.21)(PORT = 1522))
> )">>$ORACLE_HOME/network/admin/tnsnames.ora
--再次设置参数local_listener
SQL> alter system set local_listener='LISTENER_CNBO';
System altered.
--下面可以看到实例及服务已经自动注册到监听器LISTENER_CNBO
[oracle@linux1 ~]$ lsnrctl status LISTENER_CNBO
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 16-AUG-2013 14:35:04
...................
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linux1.orasrv.com)(PORT=1522)))
Services Summary...
Service "cnbo.orasrv.com" has 1 instance(s).
Instance "cnbo", status READY, has 1 handler(s) for this service...
Service "cnboXDB.orasrv.com" has 1 instance(s).
Instance "cnbo", status READY, has 1 handler(s) for this service...
The command completed successfully
--下面查看grid用户下原来的服务cnbo.orasrv.com及实例cnbo也不复存在
[grid@linux1 ~]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 16-AUG-2013 14:37:46
.....
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.7.21)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.7.31)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
The command completed successfully
3、配置非缺省的监听器并实现静态注册
[sql]
--对于非缺省监听器，我们也可以为其配置静态注册方式
--首先我们停止监听器，并清空Oracle用户下的listener.ora与tnsnames.ora
[oracle@linux1 ~]$ lsnrctl stop LISTENER_CNBO
[oracle@linux1 ~]$ cat /dev/null>$ORACLE_HOME/network/admin/listener.ora
[oracle@linux1 ~]$ cat /dev/null>$ORACLE_HOME/network/admin/tnsnames.ora
SQL> alter system set local_listener='';
--下面使用netmgr来配置监听器及tnsnames
[oracle@linux1 ~]$ export DISPLAY=192.168.7.133:0.0
[oracle@linux1 ~]$ netmgr
--下面是配置后的结果，此时我们使用了新的端口号1523以及新的监听器名字LISTENER_NEW
[oracle@linux1 ~]$ more $ORACLE_HOME/network/admin/listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
# 我们使用netmgr为其添加了数据库服务，即SID_LIST_LISTENER_NEW项，而netca无法完成此项任务
LISTENER_NEW =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = linux1.orasrv.com)(PORT = 1523))
)
ADR_BASE_LISTENER_NEW = /u01/app/oracle
SID_LIST_LISTENER_NEW =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = cnbo.orasrv.com)
(ORACLE_HOME = /u01/app/oracle/db_1)
(SID_NAME = cnbo)
)
)
[oracle@linux1 ~]$ more $ORACLE_HOME/network/admin/tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
CNBO =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = linu