监听实验及说明如下:
1)配置动态监听、静态监听(作为服务端)
——配置:服务端listener.ora里的动态注册(1521端口):三要素
服务端listener.ora里的静态注册:三要素
[oracle@hong admin]$ vi listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hong)(PORT = 1521))
)
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=CAI)
(ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME=CAI))
)
服务端配置完成需重新reload一下监听(或者重新停启监听)去装载刚刚新建的监听;动态监听由PMON去注册一般慢一点,1分钟之内,手动注册使用alter systen resigter;命令人工命令PMON立刻将实例、数据库等信息注册到监听里(这样更快)
——配置客户端tnsnames.ora(作为客户端,角色转变):四要素
[oracle@hong admin]$ vi tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
120 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.6)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = CAI)
)
)
[oracle@hong admin]$
可以通过tnsping 120去测试客服端访问服务端的网络是否畅通;或者直接以 sqlplus sys/oracle@120 as sysdba进入到服务端的数据库内去验证;
动态监听需配置listener.ora,如果需要从客户端登陆数据库则创建tnsnames.ora。
注:监听主要指令:Lsnrctl start