Oracle 11g RAC环境下单实例非缺省监听及端口配置(二)
obinson Cheng
-- Blog : http://blog.csdn.net/robinson_0612
-->下面是使用netca配置后的结果，包括listener.ora以及tnsnames.ora
[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.
ADR_BASE_LISTENER_CNBO = /u01/app/oracle
LISTENER_CNBO = #--监听器的名字为LISTENER_CNBO，端口为1522
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.7.21)(PORT = 1522))
)
)
[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 = 192.168.7.21)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME = cnbo.orasrv.com)
)
)
--提示没有找到监听器，无法ping通，因为我们配置的监听器并没有启动
--尽管服务在缺省的监听器注册，但无法ping，即此路不通
[oracle@linux1 ~]$ tnsping cnbo
TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 16-AUG-2013 14:28:47
Copyright (c) 1997, 2009, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.7.21)(PORT = 1522)))
(CONNECT_DATA = (SERVICE_NAME = cnbo.orasrv.com)))
TNS-12541: TNS:no listener
--下面我们启动非缺省的监听器
[oracle@linux1 ~]$ lsnrctl start LISTENER_CNBO
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 16-AUG-2013 14:29:14
..............
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linux1.orasrv.com)(PORT=1522)))
The listener supports no services
The command completed successfully
[oracle@linux1 ~]$ lsnrctl status LISTENER_CNBO
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 16-AUG-2013 14:30:20
.............
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linux1.orasrv.com)(PORT=1522)))
The listener supports no services -->没有任何服务及实例注册到监听器，等N久也不会有实例注册
The command completed successfully -->因为这个是非缺省的，而且我们还没有配置动态注册
--下面我们来设置动态注册
--查看参数local_listener，此时已经被设置了，而且端口是1521，IP用的是虚IP
--这就是为什么实例创建后，会被自动注册到grid用户下缺省监听器的缘故
SQL> show parameter local_lis
NAME TYPE VALUE
------------------------------------ --------------------------------- ------------------------------
local_listener string (DESCRIPTION=(ADDRESS_LIST=(AD
DRESS=(PROTOCOL=TCP)(HOST=linu
x1-vip)(PORT=1521))))
--设置动态注册，收到了错误消息
SQL> alter system set local_listener='LISTENER_CNBO';
alter system set local_listener='LISTENER_CNBO'
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network