Error ORA-15260 when attempting to issue an alter diskgroup command.

No Comments

The ORA-15260 error when attempting ot issue an alter diskgroup command is a permissions issue. It will generally be because you are logged in as SYSDBA rather than SYSASM.

Prior to 11gR2 you could log in and administer diskgroups with SYSDBA privileges but this changed with 11.2.

 

SQL> ALTER DISKGROUP DATA add disk ‘/dev/oracleasm/disks/DISK2’;
ALTER DISKGROUP DATA add disk ‘/dev/oracleasm/disks/DISK2’
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15260: permission denied on ASM disk group
Log out and log back in as SYSASM to fix the error.
Categories: Errors Tags: Tags:

Error PRVF-5472 during an Oracle Grid infrastructure install

No Comments

This is a problem with the config of the NTP daemon (ntpd) which synchronizes time across the cluster.
The specific error is to do with the boot time behavior of the daemon and needing the ‘Slewing’ option enabled.

If you need to enable slewing, you can do it by typing ‘ntpd -x’, however, the grid installer requires it to be set up to start like that at boot time.
Again, this is an easy change:

vi /etc/sysconfig/ntpd

Alter the line:
OPTIONS=”-u ntp:ntp -p /var/run/ntpd.pid”
to
OPTIONS=”-x -u ntp:ntp -p /var/run/ntpd.pid”

# Drop root to id ‘ntp:ntp’ by default.
OPTIONS=”-x -u ntp:ntp -p /var/run/ntpd.pid”

# Set to ‘yes’ to sync hw clock after successful ntpdate
SYNC_HWCLOCK=no

# Additional options for ntpdate
NTPDATE_OPTIONS=””

Then rerun the checks and that one should pass..