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

Phenomenon description: scan ip is not registered to monitor, remote connection scan ip can not access the database. Lsnrctl status listener_scan1LSNRCTL for Linux: Version 11.2.0.4.0-Production on 12-APR-2018 09:28:51Copyright (c) 1991, 2013, Oracle. All rights reserved.Connecting to (DESCRIPTION= (ADDRESS= (PROTOCOL=IPC) (KEY=LISTENER_SCAN1)) STATUS of the LISTENER----Alias LISTENER_SCAN1Version TNSLSNR for Linux: Version 11.2.0.4.0-ProductionStart Date 12-APR-2018 08:47:21Uptime 0 days 0 hr. 41 min. 29 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File / u01/app/11.2.0/grid/network/admin/listener.oraListener Log File / u01/app/11.2.0/grid/log/diag/tnslsnr/roidb1/listener_scan1/alert/log.xmlListening Endpoints Summary... (DESCRIPTION= (ADDRESS= (PROTOCOL=ipc) (KEY=LISTENER_SCAN1) (DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=192.168.1.215) (PORT=1521) The listener supports no servicesThe command completed successfully$SQL > show parameter listenerNAME TYPE VALUE Listener_networks stringlocal_listener string (ADDRESS= (PROTOCOL=TCP) (HOST= 192.168.1.213) (PORT=1521)) remote_listener string (DESCRIPTION= ( ADDRESS_LIST= (ADDRESS = (PROTOCOL=TCP) (HOST=192. (PORT=1521) SQL > $sqlplus roidba/roidba@//192.168.1.215:1521/orcl SQL*Plus: Release 11.2.0.4.0 Production on Thu Apr 12 09:29:27 2018Copyright (c) 1982, 2013, Oracle. All rights reserved.ERROR:ORA-12514: TNS:listener does not currently know of service requested in connectdescriptorEnter user-name: solution: $sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Thu Apr 12 09:29:41 2018Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit ProductionWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP Data Mining and Real Application Testing optionsSQL > show parameter listenerNAME TYPE VALUE-- listener_networks Stringlocal_listener string (ADDRESS= (PROTOCOL=TCP) (HOST= 192.168.1.213) (PORT=1521)) remote_listener string (DESCRIPTION= (ADDRESS_LIST= (ADDRESS= (PROTOCOL=TCP)) (HOST=192. 168.1.214) (PORT=1521)) (168.1.214)) (168.1.214)) (168.1.214) (PORT=1521) (168.1.214) (168.1.214) (168.1.214) (168.1.214) (168.1.214)) (168.1.214) (168.1.214)) (168.1.214) (168.1.214) (168.1.214) (168.1.214) (168.1.214) (168.1.214) (168.1.214) (168.1.214) (168.1.214) (168.1.214) (168.1.214) (168.1.214) (168.1.214)) (168.1.214)) (168.1.214)) (168.1.214) SQL > alter system set remote_listener='roidb-scan:1521' scope=both sid='orcl1';System altered.SQL > alter system register System altered.SQL > show parameter listenerNAME TYPE VALUE-- listener_networks stringlocal _ listener string (ADDRESS= (PROTOCOL=TCP) (HOST=192.168.1.213) (PORT=1521)) remote_listener string roidb-scan:1521SQL > Verification: $lsnrctl status listener_scan1LSNRCTL for Linux: Version 11.2.0.4.0-Production on 12-APR-2018 09:31:38Copyright (c) 1991 2013, Oracle. All rights reserved.Connecting to (DESCRIPTION= (ADDRESS= (PROTOCOL=IPC) (KEY=LISTENER_SCAN1)) STATUS of the LISTENER----Alias LISTENER_SCAN1Version TNSLSNR for Linux: Version 11.2.0.4.0-ProductionStart Date 12-APR-2018 08:47:21Uptime 0 days 0 hr. 44 min. 16 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File / u01/app/11.2.0/grid/network/admin/listener.oraListener Log File / u01/app/11.2.0/grid/log/diag/tnslsnr/roidb1/listener_scan1/alert/log.xmlListening Endpoints Summary... (DESCRIPTION= (ADDRESS= (PROTOCOL=ipc) (KEY=LISTENER_SCAN1) (DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=192.168.1.215) (PORT=1521)) Services Summary...Service "ORCL" has 1 instance (s) Instance "orcl1", status READY, has 1 handler (s) for this service...Service "orclXDB" has 1 instance (s). Instance "orcl1", status READY, has 1 handler (s) for this service...The command completed successfully$$sqlplus roidba/roidba@//192.168.1.215:1521/orcl SQL*Plus: Release 11.2.0.4.0 Production on Thu Apr 12 09:32:01 2018Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit ProductionWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP Data Mining and Real Application Testing optionsSQL > show parameter listenerNAME TYPE VALUE-- listener_networks Stringlocal_listener string (ADDRESS= (PROTOCOL=TCP) (HOST= 192.168.1.213) (PORT=1521)) remote_listener string roidb-scan:1521SQL >

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.