ITPub博客

首页 > 数据库 > Oracle > Oracle 11gR2 开启oracle rac 顺序

Oracle 11gR2 开启oracle rac 顺序

Oracle 作者:hanweisso 时间:2014-03-01 11:36:46 0 删除 编辑

检查cluster状态

[root@rac1 bin]# ./crsctl stat res -t

CRS-4535: Cannot communicate with Cluster Ready Services

CRS-4000: Command Status failed, or completed with errors.

[root@rac1 bin]# ./crsctl check cluster -all

CRS-4639: Could not contact Oracle High Availability Services

CRS-4000: Command Check failed, or completed with errors.

启动crs服务

[root@rac1 bin]# ./crsctl start crs

CRS-4123: Oracle High Availability Services has been started.

使用crsctl查看是否所有服务已经全部开启

[root@rac1 bin]# ./crsctl check cluster -all

**************************************************************

rac1:

CRS-4537: Cluster Ready Services is online

CRS-4529: Cluster Synchronization Services is online

CRS-4533: Event Manager is online

**************************************************************

[root@rac1 bin]# ./crsctl stat res -t

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

NAME           TARGET  STATE        SERVER                   STATE_DETAILS      

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

Local Resources

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

ora.DATA.dg

               OFFLINE OFFLINE      rac1                                        

ora.LISTENER.lsnr

               ONLINE  ONLINE       rac1                                        

ora.LOG.dg

               OFFLINE OFFLINE      rac1                                        

ora.OCR.dg

               ONLINE  ONLINE       rac1                                        

ora.asm

               ONLINE  ONLINE       rac1                     Started            

ora.eons

               ONLINE  ONLINE       rac1                                        

ora.gsd

               OFFLINE OFFLINE      rac1                                         

ora.net1.network

               ONLINE  ONLINE       rac1                                        

ora.ons

               ONLINE  ONLINE       rac1                                        

ora.registry.acfs

               ONLINE  ONLINE       rac1                                         

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

Cluster Resources

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

ora.LISTENER_SCAN1.lsnr

      1        ONLINE  ONLINE       rac1                                        

ora.oc4j

      1        OFFLINE OFFLINE                                                  

ora.oracle.db

      1        OFFLINE OFFLINE                                                   

      2        OFFLINE OFFLINE                                                  

ora.rac1.vip

      1        ONLINE  ONLINE       rac1                                        

ora.rac2.vip

      1        ONLINE  INTERMEDIATE rac1                     FAILED OVER         

ora.scan1.vip

      1        ONLINE  ONLINE       rac1                                  

 

由上可知rac2还未启动crs,然后启动rac2crs即可。

最后用crsctl stat res –t确认集群所有的服务都已开启。

进去asm确认asm磁盘组状态

sqlplus / as sysasm

SQL> select group_number,name,state,voting_files from v$asm_diskgroup;

 

GROUP_NUMBER NAME                           STATE       V

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

           1 OCR                            MOUNTED     N

           0 DATA                           DISMOUNTED  N

           0 LOG                            DISMOUNTED  N

因为oracle数据库还未启动所以DATALOG磁盘为dismonted状态。

 

启动oracle数据

srvctl start instance -d oracle -n rac1

srvctl start instance -d oracle -n rac2

确认数据库状态

[oracle@rac1 ~]$ srvctl status database -d oracle

Instance oracle2 is running on node rac1

Instance oracle1 is running on node rac2

数据库启动完毕。

查看asm磁盘状态

SQL> select group_number,name,state,voting_files from v$asm_diskgroup;

 

GROUP_NUMBER NAME                           STATE       V

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

           1 OCR                            MOUNTED     N

           2 DATA                           MOUNTED     N

           0 LOG                            DISMOUNTED  N

数据库使用的DATA磁盘组正常mounted(注:LOG磁盘组为笔者新添加的日志磁盘组还未使用)。

<!-- 正文结束 -->

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24384027/viewspace-1114863/,如需转载,请注明出处,否则将追究法律责任。

下一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2011-03-30

最新文章