Error: F_JG202F Attempt to Load Dynamic Shared Library Failed

Issue

While setting up a new Oracle location, the connection test fails with the following error:

Error: Test location connection failed. F_JG202F Attempt to load dynamic shared library '/home/hvr/hvr_home/lib/hvr_or190.so' failed with error: 'libclntsh.so.19.1: cannot open shared object file: No such file or directory'. This problem could be because this library or a library it referenced was not contained in library search path variable 'LD_LIBRARY_PATH'.

Environment

• HVR 6
• Database: Oracle

Resolution

To resolve this issue, follow the steps for your deployment scenario.

Scenario 1: HVR agent is installed on the Oracle Database server

If the HVR agent is installed on the same server as the Oracle Database and the full Oracle client is already available, do the following:

1. Configure the Oracle environment variables for the HVR agent user. Add the following lines to the HVR agent installation user's .bash_profile:

   export ORACLE_HOME=<DB_Oracle_Home_Path>
   export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$HVR_HOME/lib:$LD_LIBRARY_PATH
   export PATH=$ORACLE_HOME/bin:$PATH:$HVR_HOME/bin
   

2. Ensure the HVR agent user can access the Oracle libraries. For example:

   chmod 750 $ORACLE_HOME/lib/libclntsh.so.19.1
   chmod 750 $ORACLE_HOME/lib/libclntshcore.so.19.1
   

   Adding the HVR agent user to the Oracle groups, such as oinstall or dba, is not sufficient if the Oracle library directory does not grant group access.

3. Validate the Oracle environment and library access:

   echo $ORACLE_HOME
   echo $LD_LIBRARY_PATH
   which sqlplus
   ldd $HVR_HOME/lib/hvr_or190.so
   

4. Test SQL*Plus as the HVR agent user:

   sqlplus
   

   If SQL*Plus starts successfully, the Oracle client environment is configured correctly. If it fails, the HVR connection test will also fail. For help, contact our support team.

5. Test the HVR connection again.

Scenario 2: HVR agent installed on a separate server (remote agent)

If the HVR agent runs on a different server than the Oracle Database, do the following:

1. Install the full Oracle Database Client.
   Instant Client is not supported.

2. Configure the Oracle environment variables and permissions as described in Scenario 1.
3. Verify that SQL*Plus loads successfully and that hvr_or190.so resolves the required Oracle libraries.
4. Test the HVR connection again.

Oracle RAC environments

For Oracle RAC environments:

• Install the full Oracle Database Client on every host where the HVR agent runs.
• Ensure the HVR agent user has the required permissions on every host.
• Repeat the HVR agent environment setup on each RAC host.

Cause

This issue occurs when the HVR Oracle plug-in, hvr_or190.so, cannot find or access the required Oracle client libraries. This may happen for one of the following reasons:

• The agent is running on a server where the Oracle client is not installed.
• The full Oracle Database Client is not installed. Oracle Instant Client is not supported.
• The HVR agent user's Oracle environment variables, such as ORACLE_HOME and LD_LIBRARY_PATH, are missing or incorrect.
• The HVR agent user does not have read or execute permissions for the Oracle library files in $ORACLE_HOME/lib.

For more information, see our Oracle Database Client requirements.