11g rac scan ip 无法连接问题

现象描述：scan ip 没有注册到监听中，远程连接scan ip 无法访问数据库。$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=(AD                                                 DRESS=(PROTOCOL=TCP)(HOST=192.                                                 168.1.214)(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: 解决方法：$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=(AD                                                 DRESS=(PROTOCOL=TCP)(HOST=192.                                                 168.1.214)(PORT=1521))))##这里需要注意不用使用sid='*' 这种方式，要使用sid='实例名'，不然重启后不生效。                                              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> 验证：$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>