Management Pack for Oracle DB Connection Failed with root user

  • Document ID:KM03793183
  • Creation Date:30-Mar-2021
  • Modified Date:08-Jun-2021
    • Micro Focus Products:
      obm management pack

Summary

Checking the connection with dbspicao -dpv shows a failed status.

Error

Running /var/opt/OV/bin/instrumentation/dbspicao -dpv when logged in the server as root user fails:

Checking instance: 'db' @ '/u01/app/oracle/product/18.0.0/dbhome_1':
        Connect:         FAILED

 

Policies were deployed but no metric collected.

All MP tools fails when executing them as root user.

It works when log in as Oracle user.

 

Cause

Wrong permissions on $ORACLE_HOME/bin/oracle file:

# ls -al oracle

-rwxr-xr-x. 1 oracle oinstall 436988344 Jan  8  2020 oracle

Fix

Provide the correct permissions to $ORACLE_HOME/bin/oracle file:

# chmod 6755 oracle

# ls -al oracle

-rwsr-sr-x. 1 oracle oinstall 436988344 Jan  8  2020 oracle