VCS Resource Failure Due to Oracle Error ORA-16032 and ORA-07286

book

Article ID: 100071710

calendar_today

Updated On:

Description

Error Message

The following error messages were observed during the troubleshooting process:
- ORA-16032: parameter LOG_ARCHIVE_DEST destination string cannot be translated
- ORA-07286:  cannot obtain device information
- Linux-x86_64 Error: 2: No such file or directory

These error messages indicate issues with the Oracle database configuration and the underlying file system.

 

Cause

The root cause of the problem was identified as a missing file system that was not present in the fstab configuration. This missing file system prevented the Oracle resource from accessing necessary files, leading to the observed error messages and the failure of the VCS resource to come online.

 

Resolution

To resolve the issue, the following steps were taken:

  1. Verify File System Configuration:

    • Ensure that all required file systems are correctly listed in the fstab configuration.
    • Engage the Database (DB) team to verify the presence and accessibility of the necessary file systems.

  2. Update LD_LIBRARY_PATH:

    • Confirm that the LD_LIBRARY_PATH environment variable is correctly set to include the necessary Oracle library paths.
    • Example: LD_LIBRARY_PATH=/u00/app/oracle/product//lib:/usr/lib

  3. Check Oracle Configuration:

    • Verify the Oracle configuration parameters, specifically LOG_ARCHIVE_DEST, to ensure they are correctly set and accessible.
    • Correct any misconfigurations that may prevent the Oracle resource from starting.

  4. Restart VCS Resource:

    • After verifying and correcting the file system and Oracle configurations, attempt to bring the Oracle resource online again using the VCS commands.
    • Example: hastatus -sum to check the current status and hagrp -online -sys to bring the resource online.

  5. Monitor and Validate:

    • Monitor the system to ensure that the Oracle resource comes online without errors.
    • Validate that the VCS resource is functioning correctly and that the production environment is stable.

 

Issue/Introduction

A critical issue was encountered where the VCS (Veritas Cluster Server) resource failed to come online. The primary symptom was the Oracle resource failing to start, accompanied by specific error messages.
Powered by Wolken Software