VCS WARNING V-16-10031-8 (hostname) Oracle:XXX-oracle:version: File /u01/app/oracle/XXX/env.sh is not a valid text file

book

Article ID: 100015721

calendar_today

Updated On:

Description

Error Message

The following warning messages will be reported in the VCS engine log (/var/VRTSvcs/log/engine_A.log) persistently at regular intervals on the node(s) where the service group is offline:

——
VCS WARNING V-16-10031-8 (hostname) Oracle:XXX-oracle:version: File /u01/app/oracle/XXX/env.sh is not a valid text file
——

Cause


The VCS Oracle agent does not expect any file/directories to be present within the configured mount point directory on the node(s) where the failover service group is offline.

If the VCS Oracle agent finds any file/directory within the location of the configured mount point, it thinks that the mount point is available and hence will also check for the existence of the configured Oracle resource environment file (EnvFile) in that location and expects it to be present. However, since the filesystem is not currently mounted on the node(s), the configured Oracle environment file will not be found and hence the agent will report the warning message.

Below is the snippet of the example configuration in “/etc/VRTSvcs/conf/config/main.cf”


group XXX (
    SystemList = { sys1 = 0, sys2 = 1, sys3 = 2 }
    TriggersEnabled = { POSTONLINE }
    )

Mount XXX-nfs-mnt (
        MountOpt = "-o rw,bg,hard,vers=3,proto=tcp,timeo=600,rsize=32768,wsize=32768,nointr,suid"
        VxFSMountLock = 0
        MntPtOwner = oracle
        FsckOpt = "-n"
        MntPtGroup = oinstall
        BlockDevice = "nfsserver:/vol/test/data"
        MountPoint = "/u01/app/oracle/XXX"
        FSType = nfs
        )

Oracle XXX-oracle (
        Owner = oracle
        User = userxxx
        Table = tablexxx
        EnvFile = "/u01/app/oracle/XXX/env.sh"
        Home = "/u01/app/oracle/XXX/product/11.2.0.4"
        Sid = XXX
        Pword = XXX
        )

Resolution

VCS expects that the configured mount point directory for any mount point should not be in use or have other files and/or directories included within the mount point directory when the filesystem is currently not mounted. Once the file system gets mounted on the mount point, then all underlying files and/or directories (if any) before the mount of the filesystem will not longer be accessible. Hence, the solution to this problem is to move out all the files and/or sub-directories from the location of the configured filesystem mount point from the node(s) where the failover service groups containing the resources are currently offline.
 

Issue/Introduction

Veritas Cluster Server (VCS) will report warning messages of missing Oracle environment file on the node(s) where the service group including the resources is offline.

This issue is identified to occur on Storage Foundation High Availability (SFHA) configuration on the Redhat platform running Oracle 11.2.0.4. However, the issue is not specific to any particular SFHA version or platform and could occur on other platforms and versions too.