ITPub博客

ORA-27123: unable to attach to shared memory segment

原创 Oracle 作者:parknkjun 时间:2015-09-01 21:03:58 0 删除 编辑
今日启动RAC数据库,遇到报错
1、环境说明
Oracle 11.2.0.4 两节点RAC
Redhat 6.3 
2、错误如下
SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/JZH/spfileJZH.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/JZH/spfileJZH.ora
ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
Linux-x86_64 Error: 13: Permission denied
Additional information: 26
Additional information: 229382
3、查看两节点$ORACLE_HOME/bin下oracle文件
[oracle@jzhdb1 bin]$ ls -l oracle
-rwsr-s--x 1 oracle asmadmin 239626689 Sep  1 15:14 oracle
[oracle@jzhdb2 bin]$ ls -l oracle
-rwsr-s--x 1 oracle asmadmin 239626689 Sep  1 15:16 oracle
文件权限一样,大小一样,奇怪了,偿试用stat查看
[root@jzhdb1 bin]# stat oracle
  File: `oracle'
  Size: 209914519       Blocks: 409992     IO Block: 4096   regular file
Device: 804h/2052d      Inode: 14292436    Links: 1
Access: (6751/-rwsr-s--x)  Uid: (  502/    grid)   Gid: ( 1001/oinstall)
Access: 2015-09-01 13:20:06.950937676 +0800
Modify: 2015-09-01 13:18:35.594987626 +0800
Change: 2015-09-01 13:18:35.650044711 +0800

[root@crmdb2 bin]# stat oracle
  File: `oracle'
  Size: 209914519       Blocks: 409992     IO Block: 4096   regular file
Device: 4164h/16740d    Inode: 656439      Links: 1
Access: (0751/-rwxr-x--x)  Uid: (  502/    grid)   Gid: ( 1001/oinstall)
Access: 2015-09-01 14:20:30.268079585 +0800
Modify: 2015-09-01 13:20:03.569234713 +0800
Change: 2015-09-01 14:16:32.834033345 +0800

权限果然不一样,节点一是6751,节点二是0751,接下来将节点二的oracle文件权限改6751
[root@jzhdb2 bin]# chmod 6751 oracle
[root@jzhdb2 bin]# stat oracle
  File: `oracle'
  Size: 209914519       Blocks: 409992     IO Block: 4096   regular file
Device: 4164h/16740d    Inode: 656439      Links: 1
Access: (6751/-rwsr-s--x)  Uid: (  502/    grid)   Gid: ( 1001/oinstall)
Access: 2015-09-01 14:20:30.268079585 +0800
Modify: 2015-09-01 13:20:03.569234713 +0800
Change: 2015-09-01 16:57:46.962643194 +0800

4、再次启动数据库
[root@jzhdb2 bin]# su - oracle
[oracle@jzhdb2 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Tue Sep 1 16:58:35 2015
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area 2.5254E+10 bytes
Fixed Size                  2264976 bytes
Variable Size            4496294000 bytes
Database Buffers         2.0670E+10 bytes
Redo Buffers               85803008 bytes
Database mounted.
Database opened.
终于数据库启来了!


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

请登录后发表评论 登录
全部评论

注册时间:2008-02-11

  • 博文量
    113
  • 访问量
    502012