ORA-17503

APPLIES TO

Operating System - Oracle Linux Server 7.9
Oracle Database - Enterprise Edition - version 11.2.0.4.0
Oracle Grid Infrastructure - version 11.2.0.4.0

SYMPTOMS

GI 群集正常,ASM 磁盘挂载正常,启动数据库报错:

ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/coco/spfilecoco.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/coco/spfilecoco.ora
ORA-12547: TNS:lost contact

CAUSE

Oracle binary should have permission of 6751. To correct the permission, as owner of oracle binary

SOLUTION

~]# chmod 6751 $GRID_HOME/bin/oracle
~]# ll $GRID_HOME/bin/oracle
-rwsr-s--x 1 grid oinstall 209840392 Dec 19 17:28 /u01/app/grid/product/11.2.0.4/grid/bin/oracle