While using DBUA to upgrade database from 11.2.0.2 to 11.2.0.3, DBUA was throwing an error starting with PRCR-1079: Failed to start resource ora.xxx.db followed by bunch of other errors.
One error in between those error stack kinda made me obvious to look the file "oracle" permissions.
One error in between those error stack kinda made me obvious to look the file "oracle" permissions.
Ora-27303: additional information: startup egid = 80 (dba),
current egid = 82 (asmadmin)
So, comparing the file permissions on both Oracle Home and Grid Home tells me that they are not same:
/opt/oracle>ls -al
app/product/11.2.0.3/db_1/bin/oracle
-rwsr-s--x 1 oracle dba 232399431 Apr 29 12:39
app/product/11.2.0.3/db_1/bin/oracle
/opt/oracle>
/opt/oracle>ls -al
/opt/grid/app/11.2.0.3/grid/bin/oracle
-rwxr-xr-x 1 oracle dba 203973009 Apr 4 17:08
/opt/grid/app/11.2.0.3/grid/bin/oracle
/opt/oracle>
Changing the permissions on Grid Home Oracle and after this DBUA had no issues.
/opt/oracle>cd
/opt/grid/app/11.2.0.3/grid/bin/
/opt/grid/app/11.2.0.3/grid/bin>chmod 6751 oracle
/opt/grid/app/11.2.0.3/grid/bin>ls -al
oracle
-rwsr-s--x 1 oracle dba 203973009 Apr 4 17:08 oracle
/opt/grid/app/11.2.0.3/grid/bin>
No comments:
Post a Comment