Chinaunix首页 | 论坛 | 博客
  • 博客访问: 468352
  • 博文数量: 57
  • 博客积分: 877
  • 博客等级: 准尉
  • 技术积分: 1275
  • 用 户 组: 普通用户
  • 注册时间: 2011-03-24 16:16
文章分类

全部博文(57)

文章存档

2014年(2)

2013年(15)

2012年(20)

2011年(20)

我的朋友

分类: Oracle

2012-06-11 13:51:04

     装完RAC 以后,发现RAC中的一个节点的数据库实例无法启动
    
  1. [oracle@rac2 ~]$ sqlplus /nolog
  2. SQL*Plus: Release 11.2.0.1.0 Production on Tue Jun 5 23:11:57 2012
  3. Copyright (c) 1982, 2009, Oracle. All rights reserved.
  4. SQL> conn /as sysdba
  5. Connected to an idle instance.
  6. SQL> startup mount
  7. ORA-01078: failure in processing system parameters
  8. ORA-01565: error in identifying file '+DATA/orcl/spfileorcl.ora'
  9. ORA-17503: ksfdopn:2 Failed to open file +DATA/orcl/spfileorcl.ora
  10. ORA-01031: insufficient privileges
  11. SQL> exit
根据提示,检查了asm磁盘组的属组,没发现什么异常,后网上google了一把,有人说这可能是由oracle 属组的问题引起的,就信誓旦旦的检查了oracle用户组,发现有问题的节点的oracle组 的确存在问题:

  1. [oracle@rac2 ~]$
  2. [root@rac2 11.2.0]# id oracle
  3. uid=500(oracle) gid=501(oinstall) groups=501(oinstall),502(dba),503(oper),505(asmoper)
  4. [root@rac2 11.2.0]# id grid
  5. uid=501(grid) gid=501(oinstall) groups=501(oinstall),502(dba),503(oper),504(asmadmin),505(asmoper),506(asmdba)
正常节点oracle用户属性:

  1. [root@rac1 etc]# id oracle
  2. uid=500(oracle) gid=501(oinstall) groups=501(oinstall),502(dba),503(oper),506(asmdba)
  3. [root@rac1 etc]# id grid
  4. uid=501(grid) gid=501(oinstall) groups=501(oinstall),502(dba),503(oper),504(asmadmin),505(asmoper),506(asmdba)
  5. [root@rac1 etc]#
找到了原因以后,修改oracle 属组,再启动数据库,一切正常了:

  1. [root@rac2 11.2.0]# usermod -g oinstall -G dba,oper,asmdba oracle
  2. [root@rac2 11.2.0]# id oracle
  3. uid=500(oracle) gid=501(oinstall) groups=501(oinstall),502(dba),503(oper),506(asmdba)
  4. [root@rac2 11.2.0]# su - oracle
  5. [oracle@rac2 ~]$
  6. [oracle@rac2 ~]$
  7. [oracle@rac2 ~]$ sqlplus /nolog
  8. SQL*Plus: Release 11.2.0.1.0 Production on Tue Jun 5 23:35:06 2012
  9. Copyright (c) 1982, 2009, Oracle. All rights reserved.
  10. SQL> conn /as sysdba
  11. Connected to an idle instance.
  12. SQL> startup
  13. ORACLE instance started.
  14. Total System Global Area 849530880 bytes
  15. Fixed Size 1339824 bytes
  16. Variable Size 562040400 bytes
  17. Database Buffers 281018368 bytes
  18. Redo Buffers 5132288 bytes
  19. Database mounted.
  20. Database opened.
  21. SQL>





 
阅读(2313) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~