After you have upgraded Oracle ASM, Oracle recommends that you perform tasks such as resetting the Oracle ASM passwords and configuring disk groups.
Create a Shared Password File In the ASM Diskgroup
If you advance the COMPATIBLE.ASM disk group attribute, then create a shared password file.
If you advanced the COMPATIBLE.ASM disk group attribute to 12.1 or later, then you are required to create a shared password file in the ASM diskgroup.
Oracle Automatic Storage Management Administrator's Guide for complete information about managing a shared password file in a disk group
Reset Oracle ASM Passwords to Enforce Case-Sensitivity
To take advantage of enforced case-sensitive passwords, you must reset the passwords of existing users during the database upgrade procedure.
In releases earlier than Oracle Database 11g Release 1 (11.1), passwords are not case sensitive. You can enforce case sensitivity for passwords. For example, the password
hPP5620qr fails if it is entered as
For new Oracle ASM instances, there are no additional tasks or management requirements. For upgraded Oracle ASM instances, each user password must be reset with an
If the default Oracle Database security settings are in place, then passwords must be at least eight characters, and passwords such as
oracle are not allowed. See Oracle Database Security Guide for more information.
Advancing the Oracle ASM and Oracle Database Disk Group Compatibility
You can advance the Oracle Database and the Oracle ASM disk group compatibility settings across software versions.
If you advance the
COMPATIBLE.RDBMS attribute, then you cannot revert to the previous setting. Before advancing the
COMPATIBLE.RDBMS attribute, ensure that the values for the
COMPATIBLE initialization parameter for all of the databases that use the disk group are set to at least the new setting for
COMPATIBLE.RDBMS before you advance the attribute value.
Advancing compatibility enables new features only available in the new release. However, doing so makes the disk group incompatible with older releases of the software. Advancing the on disk compatibility is an irreversible operation.
compatible.asm attributes to specify the minimum software release required by the database instance and the Oracle ASM instance, respectively, to access the disk group. For example, the following
ALTER DISKGROUP statement advances the Oracle ASM compatibility of the disk group
ALTER DISKGROUP asmdg2 SET ATTRIBUTE 'compatible.asm' = '12.2'
In this case, the disk group can be managed only by Oracle ASM software of release 12.2 or later, while any database client of release 11.2 or later can use the disk group.
Oracle Automatic Storage Management Administrator's Guide for complete information about disk group compatibility
Oracle Database SQL Language Reference for more information about the disk group compatibility attributes on the
ALTER DISKGROUP and
CREATE DISKGROUP statements
Set Up Oracle ASM Preferred Read Failure Groups
Oracle ASM administrators can specify some disks as preferred read disks for read I/O operations.
When an ASM administrator defines Oracle ASM preferred read failure groups, Oracle ASM can then read from the extent that is in the nearest preferred read disk, rather than always reading the primary copy.
Oracle Clusterware Administration and Deployment Guide for information about specifying failure groups settings in an extended cluster
Oracle Automatic Storage Management Administrator's Guide for complete information about Oracle ASM preferred read failure groups, and specifying the new
ASM_PREFERRED_READ_FAILURE_GROUPSinitialization parameter to list failure group names that contain the preferred read disks for each node in a cluster
Oracle Database Reference for the