Month: August 2017

How to Find Mappings Between ASM Disks and Physical Disks

Here are the simple steps for mapping between ASM disks and physical disks in Linux.

Subscribe to get access

Read more of this content when you subscribe today.

Subscribe

PRVG-10091 : failed to retrieve the ASM password file location for an ASM instance

It is a good practice to store ASM password file into ASM diskgroup instead of local disk.

PROBLEM

Verifying system upgrade readiness for Grid Infrastructure 12.1.0.2 to 12.2.0.1 with below command, then get “PRVG-10091” warning:

$ /u01/app/12.2.0.1/grid/runcluvfy.sh stage -pre crsinst -upgrade -rolling -src_crshome /u01/app/12.1.0.2/grid -dest_crshome /u01/app/12.2.0.1/grid -dest_version 12.2.0.1.0 -fixupnoexec -verbose

...
..
.
Verifying Verify that the ASM instance was configured using an existing ASM
parameter file. ...FAILED
PRVG-10091 : failed to retrieve the ASM password file location for an ASM
instance.
...
..
.

Subscribe to get access

Read more of this content when you subscribe today.

Subscribe

How to Disable SELinux or Set SELinux to Permissive Mode

Make sure to disable SELinux or set SELinux to permissive mode for Oracle GI/RAC Linux servers.

It is recommended by Oracle to disable SELinux or set SELinux to permissive mode for Oracle GI/RAC. Otherwise you might get similar below errors:

Disk "ASM_DISK1" does not exist or is not instantiated
Writing disk header: done
Instantiating disk: oracleasm-instantiate-disk: Unable to open manager: No such file or directory 
failed
Clearing disk header: done

Subscribe to get access

Read more of this content when you subscribe today.

Subscribe

ORA-15260: permission denied on ASM disk group

PROBLEM

Try to set ASM diskgroup attribute, then get the following errors:

$ sqlplus / as sysdba
...
..
.
SQL> alter diskgroup OCR_VOTE SET ATTRIBUTE 'compatible.asm' ='11.2.0.2';
alter diskgroup OCR_VOTE SET ATTRIBUTE 'compatible.asm' ='11.2.0.2'
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15260: permission denied on ASM disk group

Subscribe to get access

Read more of this content when you subscribe today.

Subscribe

CRS-4995: The command ‘Delete resource’ is invalid in crsctl

SITUATION

Trying to delete the database resource “ora.RACTEST.db” by using CRSCTL, because ORACLE_HOME has been uninstalled, but the following error occurs.

$crsctl delete resource ora.RACTEST.db
CRS-4995: The command 'Delete resource' is invalid in crsctl. Use srvctl for this command.

Subscribe to get access

Read more of this content when you subscribe today.

Subscribe