首先要做的是停止RAC的监听，这里和停止单实例数据库监听有所不同，单实例数据库，停止监听只需要在命令行模式下执行“lsnrctl stop“即可，而停止RAC下监听需要通过命令crs_stop来执行。
1，通过crs_stat命令查看两个实例的监听名称：
[storm02@/home/db/oracle/crs/bin]#./crs_stat
NAME=ora.storm.db
TYPE=application
TARGET=ONLINE
STATE=ONLINE on storm01
NAME=ora.storm.storm1.inst
TYPE=application
TARGET=ONLINE
STATE=ONLINE on storm01
NAME=ora.storm.storm2.inst
TYPE=application
TARGET=ONLINE
STATE=ONLINE on storm02
NAME=ora.storm01.LISTENER_STORM01.lsnr
TYPE=application
TARGET=ONLINE
STATE=ONLINE on storm01
NAME=ora.storm01.gsd
TYPE=application
TARGET=ONLINE
STATE=ONLINE on storm01
NAME=ora.storm01.ons
TYPE=application
TARGET=ONLINE
STATE=ONLINE on storm01
NAME=ora.storm01.vip
TYPE=application
TARGET=ONLINE
STATE=ONLINE on storm01
NAME=ora.storm02.LISTENER_STORM02.lsnr
TYPE=application
TARGET=ONLINE
STATE=ONLINE on storm02
NAME=ora.storm02.gsd
TYPE=application
TARGET=ONLINE
STATE=ONLINE on storm02
NAME=ora.storm02.ons
TYPE=application
TARGET=ONLINE
STATE=ONLINE on storm02
NAME=ora.storm02.vip
TYPE=application
TARGET=ONLINE
STATE=ONLINE on storm02
以上所显示黑体字标注部分便是两个实例对应的监听名称。
2，停掉主节点上实例监听：
[storm01@/home/db/oracle/crs/bin]#./crs_stop ora.storm01.LISTENER_STORM01.lsnr
Attempting to stop `ora.storm01.LISTENER_STORM01.lsnr` on member `storm01`
Stop of `ora.storm01.LISTENER_STORM01.lsnr` on member `storm01` succeeded.
3，查看是否已经停掉主节点上监听：
4，停止副节点上实例监听：
[storm01@/home/db/oracle/crs/bin]#./crs_stop ora.storm02.LISTENER_STORM02.lsnr
Attempting to stop `ora.storm02.LISTENER_STORM02.lsnr` on member `storm02`
Stop of `ora.storm02.LISTENER_STORM02.lsnr` on member `storm02` succeeded.
5，查看是否已经停掉副节点上监听：
6，停掉主节点数据库并确认：
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
7，停掉副节点数据库并确认：
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
至此，两个节点上的监听、数据库停止完毕，下面要开始分别对clusterware和database进行版本的升级。
阅读(2311) | 评论(0) | 转发(0) |
