OCM考试实验-Skillset1----Network configuration

Questition:3. Server-sid Network Configuration        3.1 Create a listener using the default listener name.        3.2 The TCP/IP protocol will be used for all connectionps,Use the machine name (not the IP address) for host.        3.3 This listener will listen on the default port        3.4 Databases will be serviced by this listener.        3.5 Add a second listener,named LSNR2,which will listen on port 1526.         3.6 Set up the PROD1 instance to automatically register with the LSNR2.         3.7 Start both listeners.Reference: Net Services Reference->7 Oracle Net Listener Parameters (listener.ora)

问题：

3.服务器端网络配置
3.1使用默认侦听器名称创建侦听器。
3.2 TCP / IP协议将用于所有连接，使用机器名称（而不是IP地址）作为主机。
3.3此侦听器将侦听默认端口
3.4数据库将由此侦听器提供服务。
3.5添加一个名为LSNR2的侦听器，它将侦听端口1526。
3.6设置PROD1实例，自动向LSNR2注册。
3.7启动两个监听器。
参考：Net Services Reference-> 7 Oracle Net Listener参数（listener.ora）

---

3.1-3.4 创建默认的监听使用监听名listener，端口号为1521，数据库可以注册到本监听

[oracle@rookie admin]$ cd $ORACLE_HOME/network/admin/[oracle@rookie admin]$ cat listener.ora LISTENER=  (DESCRIPTION=    (ADDRESS_LIST=      (ADDRESS=(PROTOCOL=tcp)(HOST=rookie)(PORT=1521))      (ADDRESS=(PROTOCOL=ipc)(KEY=extproc))))SID_LIST_LISTENER=  (SID_LIST=    (SID_DESC=      (GLOBAL_DBNAME=PROD3)      (ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1)      (SID_NAME=PROD3)))

3.5 创建一个监听名字为LSNR2，端口号为1526，需要在原有的listener.ora文件中追加内容：

需要修改监听名，端口号，和key值

[oracle@rookie admin]$ cat listener.ora LISTENER=  (DESCRIPTION=    (ADDRESS_LIST=      (ADDRESS=(PROTOCOL=tcp)(HOST=rookie)(PORT=1521))      (ADDRESS=(PROTOCOL=ipc)(KEY=extproc))))SID_LIST_LISTENER=  (SID_LIST=    (SID_DESC=      (GLOBAL_DBNAME=PROD3)      (ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1)      (SID_NAME=PROD3)))LSNR2=  (DESCRIPTION=    (ADDRESS_LIST=      (ADDRESS=(PROTOCOL=tcp)(HOST=rookie)(PORT=1526))      (ADDRESS=(PROTOCOL=ipc)(KEY=extproc1))))

3.6 需要将PROD1动态注册到LSNR2上：

参考：Reference –> LOCAL_LISTENER参数

SQL> show parameter listenerNAME                     TYPE    VALUE------------------------------------ ----------- ------------------------------listener_networks            stringlocal_listener               string  LISTENER_PROD1remote_listener              stringSQL> alter system set local_listener='(ADDRESS=(PROTOCOL=tcp)(HOST=rookie)(PORT=1526))';System altered.

3.7 启动两个监听

--启动默认监听[oracle@rookie admin]$ lsnrctl startLSNRCTL for Linux: Version 11.2.0.1.0 - Production on 18-JUL-2017 12:07:22Copyright (c) 1991, 2009, Oracle.  All rights reserved.Starting /u01/app/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait...TNSLSNR for Linux: Version 11.2.0.1.0 - ProductionSystem parameter file is /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.oraLog messages written to /u01/app/oracle/product/11.2.0/db_1/diag/tnslsnr/rookie/listener/alert/log.xmlListening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rookie)(PORT=1521)))Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rookie)(PORT=1521)))STATUS of the LISTENER------------------------Alias                     LISTENERVersion                   TNSLSNR for Linux: Version 11.2.0.1.0 - ProductionStart Date                18-JUL-2017 12:07:22Uptime                    0 days 0 hr. 0 min. 0 secTrace Level               offSecurity                  ON: Local OS AuthenticationSNMP                      OFFListener Parameter File   /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.oraListener Log File         /u01/app/oracle/product/11.2.0/db_1/diag/tnslsnr/rookie/listener/alert/log.xmlListening Endpoints Summary...  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rookie)(PORT=1521)))  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))Services Summary...Service "PROD3" has 1 instance(s).  Instance "PROD3", status UNKNOWN, has 1 handler(s) for this service...The command completed successfully--启动lsnr2[oracle@rookie admin]$ lsnrctl start LSNR2LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 18-JUL-2017 12:07:26Copyright (c) 1991, 2009, Oracle.  All rights reserved.Starting /u01/app/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait...TNSLSNR for Linux: Version 11.2.0.1.0 - ProductionSystem parameter file is /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.oraLog messages written to /u01/app/oracle/diag/tnslsnr/rookie/lsnr2/alert/log.xmlListening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rookie)(PORT=1526)))Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=rookie)(PORT=1526))STATUS of the LISTENER------------------------Alias                     LSNR2Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - ProductionStart Date                18-JUL-2017 12:07:26Uptime                    0 days 0 hr. 0 min. 0 secTrace Level               offSecurity                  ON: Local OS AuthenticationSNMP                      OFFListener Parameter File   /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.oraListener Log File         /u01/app/oracle/diag/tnslsnr/rookie/lsnr2/alert/log.xmlListening Endpoints Summary...  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rookie)(PORT=1526)))The listener supports no servicesThe command completed successfully--查看PROD1是否注册到LSNR2上[oracle@rookie admin]$ lsnrctl status LSNR2LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 18-JUL-2017 12:08:46Copyright (c) 1991, 2009, Oracle.  All rights reserved.Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=rookie)(PORT=1526))STATUS of the LISTENER------------------------Alias                     LSNR2Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - ProductionStart Date                18-JUL-2017 12:07:26Uptime                    0 days 0 hr. 1 min. 19 secTrace Level               offSecurity                  ON: Local OS AuthenticationSNMP                      OFFListener Parameter File   /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.oraListener Log File         /u01/app/oracle/diag/tnslsnr/rookie/lsnr2/alert/log.xmlListening Endpoints Summary...  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rookie)(PORT=1526)))Services Summary...Service "PROD1.oracle.com" has 1 instance(s).  Instance "PROD1", status READY, has 1 handler(s) for this service...Service "PROD1XDB.oracle.com" has 1 instance(s).  Instance "PROD1", status READY, has 1 handler(s) for this service...The command completed successfully