5.2.4.1 Changes in Oracle ASM System Privileges When Upgrading to Oracle Grid Infrastructure 12c Release 1 (12.1.0.2)

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.