IT36673: ADVERSE SETTING IN '/ETC/FSTAB' PREVENTING ORACLE DB SERVER FROMREBOOT

APAR status

• Closed as program error.

Error description

• The Oracle DB server is not coming online after reboot if vSnap
  server in an IBM Spectrum Protect Plus environment is either off
  or not reachable. During startup the mount software on Oracle DB
  server is attempting the NFS (Network File System) to be mounted
  automatically.
  By adding 'user,noauto' to the Oracle DB server '/etc/fstab'
  configuration file, the Oracle DB server will reboot even if
  vSnap server is either off or not reachable. The options
  'user,noauto' will permit any user to mount the file system and
  the mount will not be done automatically.
  
  
  Example:
   cat /etc/fstab | grep -i spp
   <IPvSnap>:/vsnap/vpool1/fsX /mnt/spp/vsnap/vool1/fsX/<IPvSnap>
      nfs rw,bg,hard,nointr,user,noauto,rsize=32768,wsize=32768,
      tcp,noac,actimeo=0,vers=3,timeo=600 0 0
  
  
  The modified options at '/etc/fstab' are not shown at the job
  log of the Oracle DB backup:
    DETAIL,<Time,Server Time,Task ID>,CTGGA4005,[IP_GuestHost]
      Collecting list of volumes and shares to be mounted.
    DETAIL,<Time,Server Time,Task ID>,CTGGA4132,[IP_GuestHost]
      Mounting nfs share <IP_vSnap>:/vsnap/vpool1/fsx to
      mount point /mnt/spp/vsnap/vpool1/fs16/<IP_vSnap>
    DETAIL,<Time,Server Time,Task ID>,CTGGA4133,[IP_GuestHost]
      Using mount options: rw bg hard nointr rsize=32768
      wsize=32768 tcp noac actimeo=0 vers=3 timeo=600
    DETAIL,<Time,Server Time,Task ID>,CTGGA4034,[IP_GuestHost]
      Completed mount operation in 1s. 1 volumes/shares
      mounted successfully and 0 volumes/shares failed
  
  
  
  Initial Impact: Medium
  
  IBM Spectrum Protect Plus Versions Affected:
  IBM Spectrum Protect Plus 10.1.x
  
  Additional Keywords: SPP, SPPLUS, TS004906373, Oracle, fstab,
                       noauto
  

Local fix

• Add mount options 'user,noauto' to Oracle configuration file
  '/etc/fstab'
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Spectrum Protect Plus level 10.1.x                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * see ERROR Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply the fixing level when available. This problem is       *
  * currently projected to be fixed in IBM Spectrum Protect Plus *
  * level 10.1.8 patch1 and 10.1.9                               *
  * Note that this is subject to change at the discretion of     *
  * IBM.                                                         *
  ****************************************************************
  

Problem conclusion

• Added no-auto to mount options for Oracle log backup target.
  This will prevent startup issues of Oracle server if the vSnap
  server is not reachable during that time.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  SP PLUS

• Fixed component ID

  5737SPLUS

Applicable component levels