rac无法通过scanip连接

目录

客户端无法登陆

问题原因

解决方法

---

客户端无法登陆

ERROR:

ORA-12514: TNS:listener does not currently know of service requested in connect

descriptor

问题原因

有套rac库没有设置remote_listener，导致无法通过scanip访问。

11gR2数据库，默认设置local_listener参数为local listener(本地监听器，ip地址为vip)，为vip listener提供服务。

remote_listener参数设置为scan listener，为scan ip提供服务

SQL> show parameter listener

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

listener_networks                    string

local_listener                       string       (DESCRIPTION=(ADDRESS_LIST=(A

                                                 DDRESS=(PROTOCOL=TCP)(HOST=10.

                                                 134.90.221)(PORT=1521))))

remote_listener                      string

 

grid@t5a01:~$ lsnrctl status LISTENER_SCAN1

LSNRCTL for Solaris: Version 11.2.0.4.0 - Production on 24-MAR-2020 17:18:44

Copyright (c) 1991, 2013, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER_SCAN1

Version                   TNSLSNR for Solaris: Version 11.2.0.4.0 - Production

Start Date                17-MAY-2019 01:48:59

Uptime                    312 days 15 hr. 29 min. 45 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /export/u01/11g/grid/network/admin/listener.ora

Listener Log File         /export/u01/11g/grid/log/diag/tnslsnr/t5a01/listener_scan1/alert/log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.134.90.223)(PORT=1521)))

The listener supports no services

The command completed successfully

解决方法

alter system set remote_listener=’epmfdp-scan:1521’ scope=both sid=’*’;

alter system register;