When upgrading from Oracle Grid Infrastructure release 12.1.0.1 to release 12.1.0.2, the upgrade process automatically updates the group memberships and the disk ACLs for Oracle ASM privileges.
The disk ACLs are updated to add ORA_ASMADMIN
and remove ORA_ASMDBA
.
The database service SIDs are added to both ORA_ASMADMIN
and ORA_ASMDBA
The Oracle Service user (typically the Oracle Home user) is added to ORA_ASMDBA
These updates ensure that databases using either Oracle Database release 12.1.0.1 or release 12.1.0.2 can use Oracle ASM after the upgrade to Oracle Grid Infrastructure release 12.1.0.2.
If Oracle ASM is freshly installed as part of Oracle Grid Infrastructure 12c Release 1 (12.1.0.2), then only the 12.1.0.2 version of the privileges are configured:
The database service SIDs are added to ORA_ASMADMIN
The Oracle Service user (typically the Oracle Home user) is added to ORA_ASMDBA
The disk ACLs are updated to include ORA_ASMADMIN
Before you install Oracle Database 12c release 12.1.0.1 software on a system with a new installation (not an upgraded installation) of Oracle Grid Infrastructure 12c Release 1 (12.1.0.2), you must apply a patch to ensure the proper privileges are configured when you create an Oracle Database 12c release 12.1.0.1 database.