重庆思庄Oracle、Redhat认证学习论坛
标题: rac启动数据库报ORA-01565，ORA-17503，ORA-15001的解决办法 [打印本页]
作者: jiawang 时间: 2017-9-11 16:19
标题: rac启动数据库报ORA-01565，ORA-17503，ORA-15001的解决办法
[oracle@rac01 ~]$sqlplus / as sysdba
SQL*Plus: Release11.2.0.4.0 Production on Wed Aug 30 11:14:39 2017
Copyright (c) 1982,2013, Oracle. All rights reserved.
Connected to anidle instance.
SQL>startup
ORA-01565:error in identifying file '+DATA/sztech/spfilesztech.ora'
ORA-17503:ksfdopn:2 Failed to open file +DATA/sztech/spfilesztech.ora
ORA-15001:diskgroup "DATA" does not exist or is not mounted
ORA-15040:diskgroup is incomplete
ORA-15040:diskgroup is incomplete
报错原因：找不到+DATA/sztech/spfilesztech.ora文件，DATA磁盘组不存在
解决办法：确认+DATA/sztech/下面是否存在spfilesztech.ora文件
[grid@rac02 ~]$asmcmd
ASMCMD> ls
DATA/
ASMCMD> cd DATA/
ASMCMD> ls
SZTECH/
rac-cluster/
ASMCMD> cdSZTECH/
ASMCMD> ls
CONTROLFILE/
DATAFILE/
ONLINELOG/
PARAMETERFILE/
TEMPFILE/
spfilesztech.ora
ASMCMD> pwd
+DATA/SZTECH
确定spfilesztech.ora文件存在后，查看data磁盘组的状态；
[grid@rac02 ~]$crsctl status res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE rac01
ONLINE ONLINE rac02
ora.LISTENER.lsnr
ONLINE ONLINE rac01
ONLINE ONLINE rac02
ora.asm
ONLINE ONLINE rac01 Started
ONLINE ONLINE rac02 Started
ora.gsd
OFFLINE OFFLINE rac01
OFFLINE OFFLINE rac02
ora.net1.network
ONLINE ONLINE rac01
ONLINE ONLINE rac02
ora.ons
ONLINE ONLINE rac01
ONLINE ONLINE rac02
ora.registry.acfs
ONLINE ONLINE rac01
ONLINE ONLINE rac02
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac01
ora.cvu
1 ONLINE ONLINE rac01
ora.oc4j
1 ONLINE ONLINE rac01
ora.rac01.vip
1 ONLINE ONLINE rac01
ora.rac02.vip
1 ONLINE ONLINE rac02
ora.scan1.vip
1 ONLINE ONLINE rac01
ora.sztech.db
1 ONLINE ONLINE rac01 Open
2 OFFLINE OFFLINE InstanceShutdown
显示DATA磁盘组在线状态，但是启动不了数据库，可能是因为权限不足的关系，先到gi用户下确定磁盘组的权限，再查看GI、ORACLE、rdbms $ORACLE_HOME/bin下的oracle权限是否是6751.
[grid@rac01 ~]$ cd$ORACLE_HOME
[grid@rac01 grid]$cd bin
[grid@rac01 bin]$pwd
/u01/app/11.2.0/grid/bin
[grid@rac01 bin]$ls -l oracle
-rwsr-s--x. 1 gridoinstall 210122878 8月 30 10:23 oracle
[oracle@rac01 bin]$chmod 6751 oracle
[grid@rac01 bin]$ls -l oracle
-rwsr-s--x. 1 gridoinstall 239839854 8月 29 16:43 oracle
[oracle@rac02 bin]$pwd
/u01/app/oracle/product/11.2.0/db_1/bin
[oracle@rac02 bin]$ls -l oracle
-rwsr-s--x. 1oracle asmadmin 239839854 8月 29 17:42 oracle
以上权限全部正确的情况下，oracle还是无法连接到数据库，就可能是oracle用户的组属未写到asmdisk组内，需要手工添加。
[grid@rac02 ~]$ ls-l /dev/sdb
brw-rw----. 1 gridasmadmin 8, 16 8月 3109:14 /dev/sdb
[grid@rac02 ~]$ ls-l /dev/sdc
brw-rw----. 1 gridasmadmin 8, 32 8月 3109:14 /dev/sdc
uid=501(oracle)gid=502(oinstall) 组=502(oinstall),501(dba),503(oper),504(asmdba)
[root@rac01]#usermod –g 501,502,503,504,505 /oracle
[root@rac01 ~]# idoracle
uid=501(oracle)gid=502(oinstall) 组=502(oinstall),501(dba),503(oper),504(asmdba),505(asmadmin)
最后，全部退出后，在使用oracle用户启动数据库。
[root@rac01 ~]# su- oracle
[oracle@rac01 ~]$sqlplus / as sysdba
SQL*Plus: Release11.2.0.4.0 Production on Thu Aug 31 09:11:08 2017
Copyright (c) 1982,2013, Oracle. All rights reserved.
Connected to anidle instance.
SQL> startup;
ORACLE instancestarted.
Total System GlobalArea 1185853440 bytes
Fixed Size 2252664 bytes
Variable Size 822083720 bytes
DatabaseBuffers 352321536 bytes
Redo Buffers 9195520 bytes
Database mounted.
Database opened.
SQL>
作者: jiawang 时间: 2017-9-12 09:42
错误修改：
[root@rac01]#usermod –G 501,502,503,504,505 oracle
| 欢迎光临 重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/) |
Powered by Discuz! X3.2 |