oracle监听问题记录

1、监听无法识别到数据库服务

今天配置oracle的adg，备库启动的监听无法识别到数据库的服务，实际数据库服务是启动的。

原因就是从rac那边复制的参数文件其中的local_listener  没有注释掉，单机时此参数应该设计为空

alter system set local_listener='';
alter system register;

2、配置adg时，添加了1522端口的静态监听

[oracle@racdg ~ ]$ cat /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = racdg)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

listener_dup =
    (DESCRIPTION=
        (ADDRESS_LIST=
            (ADDRESS = (PROTOCOL = TCP)(HOST = 10.8.98.108)(PORT = 1522))
        )
        )

SID_LIST_listener_dup=
      (SID_LIST=
        (SID_DESC=
          (GLOBAL_PRODDGNAME=proddg)
          (ORACLE_HOME= /u01/app/oracle/product/19.0.0/dbhome_1)
          (SID_NAME=proddg)
                )
          )

但是我发现监听却只有1521端口的。

最后才知道1522 的监听名叫listener_dup

而lsnrctl start 这种启的是默认的监听，所以静态监听需要手动启动lsnrctl start listener_dup

查监听状态也要加lsnrctl status listener_dup