Oracle 19C 监听无法动态注册实例

环境：

DB:Oracle 19.3.0.0.0

OS:Red Hat Enterprise Linux Server release 7.5 (Maipo)

问题：

Oracle 19C数据库，将主机名由CJCDB修改为CJCOS01，同时修改了listener.ora中主机名信息，但是监听还是无法注册实例。

[oracle@cjcos01 admin]$ pwd

/u01/app/oracle/product/19.0.0/dbhome_1/network/admin

[oracle@cjcos01 admin]$ cat listener.ora

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = cjcos01)(PORT = 1521))

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

)

问题现象：

[oracle@cjcos01 admin]$ lsnrctl status

......

Listening Endpoints Summary...

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

The listener supports no services

The command completed successfully

解决方案：

尝试添加静态监听

[oracle@cjcos01 admin]$ pwd

/u01/app/oracle/product/19.0.0/dbhome_1/network/admin

[oracle@cjcos01 admin]$ cat listener.ora

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME = cjcdb)

(ORACLE_HOME = /u01/app/oracle/product/19.0.0/dbhome_1)

(SID_NAME = cjcdb)

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = cjcos01)(PORT = 1521))

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

)

可以静态注册实例了

[oracle@cjcos01 admin]$ lsnrctl status

......

Services Summary...

Service "cjcdb" has 1 instance(s).

Instance "cjcdb", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

为什么监听可以静态注册实例，不能动态注册实例呢？

可能和local_listener参数有关。

SQL> show parameter local_listener

NAME TYPE VALUE

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

local_listener string LISTENER_CJCDB

查看tnsnames.ora中有关LISTENER_CJCDB信息，发现对应的HOST也已经修改过了。

[oracle@cjcos01 admin]$ cat tnsnames.ora

LISTENER_CJCDB =

(ADDRESS = (PROTOCOL = TCP)(HOST = cjcos01)(PORT = 1521))

由于监听 使用默认的 1521端口,可以将local_listener重置回之前的默认值，即空值。

SQL> alter system set local_listener='';

System altered.

手动注册

SQL> alter system register;

System altered.

监听可以动态注册实例了

[oracle@cjcos01 admin]$ lsnrctl status

......

Listening Endpoints Summary...

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

Services Summary...

Service "86b637b62fdf7a65e053f706e80a27ca" has 1 instance(s).