2024年1月30日发(作者：)

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

SID_LIST_LISTENER =

(SID_LIST = (SID_DESC = (GLOBAL_DBNAME = orcl002) (SID_NAME = orcl002) ) (SID_DESC = (GLOBAL_DBNAME = orcl) (SID_NAME = orcl) ) )ADR_BASE_LISTENER = /opt/oracle可见我配置了 SID_LIST_LISTENER ，将两个SID都静态配置了。接下来修改监听器配置，删除静态配置：$ sqlplus / as sysdbaSQL> shutdown immediateSQL> quit$ lsnrctl stop$ vim $ORACLE_HOME/network/admin/修改后的内容如下（删除了SID_LIST_LISTENER）$ cat $ORACLE_HOME/network/admin/# Network Configuration File: /opt/oracle/product/11.2.0/network/admin/# Generated by Oracle configuration ER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ) )ADR_BASE_LISTENER = /opt/oracle[oracle@localhost admin]$

重新启动数据库和监听器，查看状态：$ lsnrctl start$ lsnrctl statusLSNRCTL for Linux: Version 11.2.0.1.0 - Production on 22-AUG-2020 20:07:52Copyright (c) 1991, 2009, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))STATUS of the LISTENER------------------------Alias LISTENERVersion TNSLSNR for Linux: Version 11.2.0.1.0 - ProductionStart Date 22-AUG-2020 20:07:49Uptime 0 days 0 hr. 0 min. 2 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File /opt/oracle/product/11.2.0/network/admin/tener Log File /opt/oracle/diag/tnslsnr/localhost/listener/alert/tening (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))The listener supports no servicesThe command completed successfully$ sqlplus / as sysdbaSQL> startup

ORACLE instance System Global Area 1586708480 bytesFixed Size 2213736 bytesVariable Size 1224738968 bytesDatabase Buffers 352321536 bytesRedo Buffers 7434240 bytesDatabase se > exitDisconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options$ lsnrctl statusLSNRCTL for Linux: Version 11.2.0.1.0 - Production on 22-AUG-2020 20:08:08Copyright (c) 1991, 2009, Oracle. All rights reserved.