Archive

Archive for the ‘SuSE Linux’ Category

AOUG Experts Forum 13.10.2011: Storage Technologies for Oracle Database Systems and Best Practices

October 14th, 2011 Matthias Pölzinger No comments

InITSo was invited to hold a lecture on Oracle ACFS / Oracle Cloud File System at the Austrian Oracle User Group’s Experts Forum on Storage Technologies for Oracle Database Systems – Best Practices (“AOUG Expertentreff: Storage Technologien Oracle Datenbanksystem – Best Practices“).

If you are interested in this topic, you can download an English or German version of the presentation via the following links:

 

Oracle RAC on Linux: PRVF-5449 and PRVF-5431 when executing addNode.sh

Problem description:

Executing addNode.sh in 11.2 results in PRVF-5449 and PRVF-5431 if Voting Disks are located on Oracle ASM Disks:

Checking Oracle Cluster Voting Disk configuration...
 
ERROR:
PRVF-5449 : Check of Voting Disk location "ORCL:GRID01(ORCL:GRID01)" failed on the following nodes:
Check failed on nodes:
        racn02
 
        racn02:No such file or directory
 
ERROR:
PRVF-5449 : Check of Voting Disk location "ORCL:GRID02(ORCL:GRID02)" failed on the following nodes:
Check failed on nodes:
        racn02
 
        racn02:No such file or directory
 
ERROR:
PRVF-5449 : Check of Voting Disk location "ORCL:GRID03(ORCL:GRID03)" failed on the following nodes:
Check failed on nodes:
        racn02
 
        racn02:No such file or directory
 
PRVF-5431 : Oracle Cluster Voting Disk configuration check failed
Time zone consistency check passed
 
 
 
[grid@racn01 bin]$

Although the Oracle ASM Disks are available on the node to add:

[root@racn02 ~]# service oracleasm listdisks | grep GRID
GRID01
GRID02
GRID03
[root@racn02 ~]#

Cause:

addNode.sh is checking Oracle ASM disks incorrectly and will cancel the node addition for Voting Devices on ASM disks.

Problem resolution:

Check manually if the Oracle ASM Disks are available on the nodes to add:

[root@racn02 ~]# service oracleasm listdisks | grep GRID
GRID01
GRID02
GRID03
[root@racn02 ~]#

If the voting disk locations check was the only one that failed, use the environment variable IGNORE_PREADDNODE_CHECKS and rerun addNode.sh. Otherwise resolve the other errors first before continuing.

Example usage of IGNORE_PREADDNODE_CHECKS:

[grid@racn01 bin]$ export IGNORE_PREADDNODE_CHECKS=Y
[grid@racn01 bin]$ ./addNode.sh "CLUSTER_NEW_NODES={racn02}" "CLUSTER_NEW_VIRTUAL_HOSTNAMES={racn02-vip}"
...
...

SuSE/SLES: hostname does neither print domain name nor fully qualified hostname

Problem description:

The hostname command does not recognise the domainname and will not use it in its output formats:

sles01:~ # hostname
sles01
sles01:~ # hostname -f
sles01
sles01:~ # hostname -d
 
sles01:~ #

Although the configuration seems correct:

  • /etc/HOSTNAME:

    sles01:~ # cat /etc/HOSTNAME
    sles01.mydomain
    sles01:~ #
  • /etc/resolv.conf:

    sles01:~ # cat /etc/resolv.conf
    search mydomain
    nameserver 192.168.0.1
    sles01:~ #

Problem resolution:

Check your /etc/hosts file and the order of the entries for your host. The fully qualified domain name should be in first position. In my case, the hosts-file somehow contained an entry with a wrong order:

sles01:~ # cat /etc/hosts
#
# hosts         This file describes a number of hostname-to-address
#               mappings for the TCP/IP subsystem.  It is mostly
#               used at boot time, when no name servers are running.
#               On small systems, this file can be used instead of a
#               "named" name server.
# Syntax:
#
# IP-Address  Full-Qualified-Hostname  Short-Hostname
#
 
127.0.0.1       localhost
 
192.168.0.100   sles01 sles01.mydomain
sles01:~ #

Example for a correct order of the entries:

sles01:~ # cat /etc/hosts
#
# hosts         This file describes a number of hostname-to-address
#               mappings for the TCP/IP subsystem.  It is mostly
#               used at boot time, when no name servers are running.
#               On small systems, this file can be used instead of a
#               "named" name server.
# Syntax:
#
# IP-Address  Full-Qualified-Hostname  Short-Hostname
#
 
127.0.0.1       localhost
 
192.168.0.100   sles01.mydomain sles01
sles01:~ #
Categories: Linux, Oracle, SuSE Linux Tags: