概述
Centos6.5 有两个数据库实例 orcl1 和 orcl2
需要都起来
关键:操作每个数据库实例之前设置ORACLE_SID变量
export ORACLE_SID=数据库实例
启动orcl1
使用oracle用户登录主机
[root@entel2 ~]# su - oracle
oracle@entel2:[/oracle]$export ORACLE_SID=orcl1
oracle@entel2:[/oracle]$sqlplus sys/system as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Wed Sep 28 07:23:47 2016 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL>startup
无误即可。
启动orcl2
使用oracle用户登录主机
[root@entel2 ~]# su - oracle
oracle@entel2:[/oracle]$export ORACLE_SID=orcl2
oracle@entel2:[/oracle]$sqlplus sys/system as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Wed Sep 28 07:23:47 2016 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL>startup
监听启动
切到oracle用户
[root@entel2 ~]# su - oracle
查看监听状态
oracle@entel2:[/oracle]$lsnrctl status LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 28-SEP-2016 07:25:02 Copyright (c) 1991, 2013, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.45.7.198)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production Start Date 28-SEP-2016 06:06:16 Uptime 0 days 1 hr. 18 min. 46 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /oracle/product/112/network/admin/listener.ora Listener Log File /oracle/diag/tnslsnr/entel2/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.45.7.198)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.123.1)(PORT=1521))) Services Summary... Service "orcl1" has 2 instance(s). Instance "orcl1", status UNKNOWN, has 1 handler(s) for this service... Instance "orcl1", status READY, has 1 handler(s) for this service... Service "orcl2" has 2 instance(s). Instance "orcl2", status UNKNOWN, has 1 handler(s) for this service... Instance "orcl2", status READY, has 1 handler(s) for this service... The command completed successfully
启动/停止
lsnrctl start/stop
监听 UNKNOWN状态解释
实例状态为UNKNOWN值时表明此服务是静态注册的设置。这时监听器用来表明它不知道关于该实例的任何信息，只有当客户发出连接请求时，它才检查该实例是否存在。
动态注册的数据库通过状态信息中的状态READY或状态BLOCKED（对于一个备用数据库）来指明。不管关闭何时数据库，动态注册的数据库都会动态地从 监听器注销，而与之相关的信息将从状态列表中消失。这样，不管数据库是在运行还是已经关闭，监听器总是知道它的状态。该信息将被用于连接请求的回退（fallback）和负载平衡。
既然有动态监听为什么还要静态监听呢？原因如下：
1.监听器不是最早启动，oracle实例先启动
2.监听器重启
3.oracle实例没有open
更加详细的解释请看David的博文 Oracle Listener 动态注册 与 静态注册