#cat /opt/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora # listener.ora Network Configuration File: /opt/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora # Generated by Oracle configuration tools. SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = orcl) (ORACLE_HOME = /opt/oracle/product/11.2.0/dbhome_1) (SID_NAME = orcl) ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = in)(PORT = 1521)) ) ) ADR_BASE_LISTENER = /opt/oracle
重新启动监听及数据库，查看静态监听状态：
数据库关闭后：
静态监听时远程数据库处于关闭状态，是需要启动到nomount或者mount状，客户端（sys用户）都可以连接上，可以在客户进行操作启动到mount或是open状态。