Unable to startup instance – ORA-17503

After a patching on the GI and RDBMS homes i was unable to start the instance.

SQL> startup nomount;
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+TEST_DATA_GRP/adb7/parameterfile/spfile11gR3.ora'
ORA-17503: ksfdopn:2 Failed to open file +TEST_DATA_GRP/adb7/parameterfile/spfile11gR3.ora
ORA-27300: OS system dependent operation:open failed with status: 13
ORA-27301: OS failure message: Permission denied
ORA-27302: failure occurred at: sskgmsmr_7

 

A short look at the pmon, it showed the ASM was run as root and the oracle binary in the GI home happened to be ROOT owned, which should have been oracle:dba.

TEST1:~] ps axuww |grep pmon
root 17788 0.0 0.5 1298620 19192 ? Ss Dec11 0:00 asm_pmon_+ASM1
oracle 30145 0.0 0.0 61156 752 pts/2 S+ 12:19 0:00 grep pmon

+ASM1:grid] pwd
/u01/app/11.2.0.3/grid
+ASM1:grid] cd bin
+ASM1:bin] ls -la ora*
-rwxr-xr-x 1 oracle dba 8559 Dec 11 23:27 oraagent
-rwxr-xr-x 1 oracle dba 28214076 Oct 14 10:08 oraagent.bin
-rwxr-xr-x 1 oracle dba 3779782 Sep 17 2011 orabase
-rwsr-s--x 1 root root 204788202 Dec 11 22:31 oracle
-rwsr-s--x 1 oracle dba 204788202 Dec 11 16:22 oracleO

[root@testMC71 ~]# cd /u01/app/11.2.0.3/grid/bin/
[root@testMC71 bin]# chown oracle:dba oracle
[root@testMC71 bin]# ls -la oracle*
-rwxr-x--x 1 oracle dba 204788202 Dec 11 22:31 oracle
-rwsr-s--x 1 oracle dba 204788202 Dec 11 16:22 oracleO
+ASM1:~] ps axuww |grep pmon
oracle 31222 0.1 0.5 1298344 18716 ? Ss 12:30 0:00 asm_pmon_+ASM1
oracle 31347 0.0 0.0 61156 748 pts/1 S+ 12:31 0:00 grep pmon
+ASM1:~] pwd
+ASM1:bin] chmod 6751 oracle
+ASM1:bin] ls -l oracle*
-rwsr-s--x 1 oracle dba 204788202 Dec 11 22:31 oracle
-rwsr-s--x 1 oracle dba 204788202 Dec 11 16:22 oracleO
+ASM1:bin]

SQL> startup nomount
ORACLE instance started.

Total System Global Area 1603411968 bytes
Fixed Size 2228784 bytes
Variable Size 1090522576 bytes
Database Buffers 486539264 bytes
Redo Buffers 24121344 bytes

 

Advertisements

One thought on “Unable to startup instance – ORA-17503

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s