Shulou(Shulou.com)06/01 Report--

Information of host,ipvip and scan of two nodes in # eth0-Public IP162.12.0.1 cqltjcpt1162.12.0.3 cqltjcpt2#eth2 PRIVATE IP192.12.0.1 cqltjcpt1-prvi192.12.0.3 cqltjcpt2-prvi#VIP162.12.0.5 cqltjcpt1-vip162.12.0.7 cqltjcpt2-vip#SCAN162.12.0.9 cqltjcptscan11G rac The listening file is configured by default under grid users [root@cqltjcpt2 ~] # su-grid [grid@cqltjcpt2 ~] $cd $ORACLE_ Home [grid @ cqltjcpt2 grid] $cd network/admin/ [grid@cqltjcpt2 admin] $ll-rw-r--r-- 1 grid oinstall 189 Jan 7 21:21 endpoints_listener.ora-rw-r--r-- 1 grid oinstall 350 Jan 7 21:21 listener.oradrwxr-xr-x 2 grid oinstall 4096 Jan 7 21:04 samples-rw-r--r- -1 grid oinstall 205 May 11 2011 shrept.lst-rw-r--r-- 1 grid oinstall 227 Jan 7 21:21 sqlnet.oraOracle 11.2 later A new listening file, endpoints_listener.ora, is introduced, which contains the IP and VIP information of the node. The function of the Endpoints_listener.ora file is to be backward compatible with the database before version 11.2. When DBCA builds the database, You need to configure database parameters and tnsnamesing [grid @ cqltjcpt2 admin] $more endpoints_listener.ora LISTENER_CQLTJCPT2= (DESCRIPTION= (ADDRESS_LIST= (ADDRESS= (PROTOCOL=TCP) (HOST=cqltjcpt2-vip) (PORT=1521)) (ADDRESS= (PROTOCOL=TCP) (HOST=162.12.0.3) (PORT=1521) (IP=FIRST) by getting the location information of endpoints, because DNS is not configured in this case by parsing configuration with hosts There is only one scan listener scan snooping is only running on Node1 [grid@cqltjcpt2 admin] $ps-ef | grep tnslsnrgrid 9840 10 Jan07? 00:00:22 / u01/oracle/grid/bin/tnslsnr LISTENER-inheritgrid 22674 21922 0 11:08 pts/1 00:00:00 grep tnslsnr [grid@cqltjcpt2 ~] $ssh cqltjcpt1 [grid@cqltjcpt1] $ps-ef | grep tnslsnrgrid 8211 10 Jan07? 00:00:44 / u01/oracle/grid/bin/tnslsnr LISTENER-inheritgrid 8380 10 Jan07? 00:00:02 / u01/oracle/grid/bin/tnslsnr LISTENER_SCAN1-inheritgrid 22060 22021 0 11:08 pts/1 00:00:00 grep tnslsnr from the ps-ef output can see Both scan snooping and local snooping are running under the oracle_home of grid users. NODE2 local snooping points to vip address 162.12.0.7. Because rac provides services through vip [oracle@cqltjcpt2 ~] $sqlplus / as sysdbaSQL > show parameter local_listenerNAME TYPE VALUE -- local_listener string (DESCRIPTION= (ADDRESS_LIST= (ADDRESS= (PROTOCOL=TCP) (HOST=162.12.0.7) (PORT=1521) remote_listener points to the scan listener name SQL > show parameter remote_listener NAME TYPE VALUE-- -remote_listener string cqltjcptscan:1521 switches to grid user [root@cqltjcpt2 ~] # su-grid [grid@cqltjcpt2 ~] $cd $ORACLE_HOME/network/ admin [grid @ cqltjcpt2 admin] $lsendpoints_listener.ora listener.ora samples shrept.lst sqlnet.ora to view the contents of the listening file [grid@cqltjcpt2 admin] $more listener. OraLISTENER_SCAN1= (DESCRIPTION= (ADDRESS_LIST= (ADDRESS= (PROTOCOL=IPC) (KEY=LISTENER_SCAN1) LISTENER= (DESCRIPTION= (ADDRESS_LIST= (ADDRESS= (PROTOCOL=IPC) (KEY=LISTENER) the bottom two lines of ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON parameters relate to the ENABLE_GLOBAL_DYNAMIC_ENDPOINT parameter The function of the ENABLE_GLOBAL_DYNAMIC_ENDPOINT parameter is to allow the listener to accept the listening status for connections that were not dynamically registered before oracle 11.2. You can see that the cqltgsqz2 instance has been running [grid@cqltjcpt2 ~] $srvctl status listenerListener LISTENER is enabledListener LISTENER is running on node (s): cqltjcpt1,cqltjcpt2 [grid@cqltjcpt2 ~] $lsnrctl status listenerLSNRCTL for Linux: Version 11.2.0.3.0-Production on 08-JAN-2013 10:58:30Copyright (c) 1991, 2011, Oracle. All rights reserved.Connecting to (DESCRIPTION= (ADDRESS= (PROTOCOL=IPC) (KEY=LISTENER)) STATUS of the LISTENER----Alias LISTENERVersion TNSLSNR for Linux: Version 11.2.0.3.0-ProductionStart Date 07-JAN-2013 22:44:03Uptime 0 days 12 hr. 14 min. 26 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File / u01/oracle/grid/network/admin/listener.oraListener Log File / u01/oracle/app/oracle/diag/tnslsnr/cqltjcpt2/listener/alert/log.xmlListening Endpoints Summary... (DESCRIPTION= (ADDRESS= (PROTOCOL=ipc) (KEY=LISTENER) (DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=162.12.0.3) (PORT=1521) (DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=162.12.0.7) (PORT=1521) Services Summary...Service "+ ASM" has 1 instance (s). Instance "+ ASM2", status READY, has 1 handler (s) for this service...Service "cqlthxqf" has 1 instance (s). Instance "cqlthxqf2", status READY, has 1 handler (s) for this service...Service "cqlthxqfXDB" has 1 instance (s). Instance "cqlthxqf2", status READY, has 1 handler (s) for this service...Service "cqlthxqz" has 1 instance (s). Instance "cqlthxqz2", status READY, has 1 handler (s) for this service...Service "cqlthxqzXDB" has 1 instance (s). Instance "cqlthxqz2", status READY, has 1 handler (s) for this service...Service "cqltjcpt" has 1 instance (s). Instance "cqltjcpt2", status READY, has 1 handler (s) for this service...Service "cqltjcptXDB" has 1 instance (s). Instance "cqltjcpt2", status READY, has 1 handler (s) for this service...The command completed successfully

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.