[oracle@ypdb02 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Thu Dec 3 11:29:29 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA_DG/ypdb/spfileypdb.ora'
ORA-17503: ksfdopn:10 Failed to open file +DATA_DG/ypdb/spfileypdb.ora
ORA-12547: TNS:lost contact
********************************************************************************
排查：
--检查ASM实例运行情况
[grid@ypdb02 ~]$ srvctl status asm -n ypdb02
ASM 正在 ypdb02 上运行
--磁盘DATA磁盘有没有MOUNT
[grid@ypdb02 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Thu Dec 3 11:34:22 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> select name,free_mb from v$asm_diskgroup;
NAME FREE_MB
------------------------------ ----------
DATA_DG 404878
OCR_DG 2146
--查看实例1上的oracle权限
[root@ypdb01 ~]# ll /oracle/product/11.2.0/db_1/bin/oracle
-rwsr-s--x 1 oracle asmadmin 239811987 12月 2 17:54 /oracle/product/11.2.0/db_1/bin/oracle
--查看实例2上的oracle权限，发现权限不对。
[grid@ypdb02 ~]$ ls -l $ORACLE_HOME/bin/oracle
-rwxr-x--x 1 grid oinstall 209914479 12月 1 16:14 /oracle/11.2.0/grid/bin/oracle
--更改权限
[grid@ypdb02 ~]$ chmod 6751 $ORACLE_HOME/bin/oracle
[grid@ypdb02 ~]$ ls -l $ORACLE_HOME/bin/oracle
-rwsr-s--x 1 grid oinstall 209914479 12月 1 16:14 /oracle/11.2.0/grid/bin/oracle
--再次启动
SQL> startup
ORACLE instance started.
Total System Global Area 4275781632 bytes
Fixed Size 2260088 bytes
Variable Size 1442841480 bytes
Database Buffers 2818572288 bytes
Redo Buffers 12107776 bytes
Database mounted.
Database opened.

ITPub博客

Oracle 11.2.0.4 RAC $ORACLE_HOME/bin/oracle权限不对导致无法启动实例

最新文章