Issue

When trying to connect to a location with correct ORACLE_HOME set, the following error appears even though environment variable LIBPATH (AIX) is set for Local Data Processing Operating System user:

F_JG202F: Attempt to load shared library failed.

Environment

Local Data Processing

Resolution

The workaround is different depending on whether the remote connection uses an hvrremotelistener or an inet-daemon.

For the hvrremotelistener make sure that LIBPATH is set for the Local Data Processing Operating System user BEFORE the hvrremotelistener is started. The environment of the running process can be checked using the command: ps eww {pid of hvrremotelistener} If LIBPATH is not returned from the previous command, set the correct LIBPATH and restart the hvrremotelistener.

For the inet-daemon it can happen that the environment variable LIBPATH is not passed to the Local Data Processing process and then the workaround is to add the following in /etc/inetd.conf on the line of the service: -ELIBPATH={path to oracle_home/lib}

(example -ELIBPATH=/u01/app/oracle/product/12.1.0/dbhome_1/lib)

After this the inet-daemon needs to be restarted as root by the following;

stopsrc -s inetd

startsrc -s inetd

Re-test connection and now it should work.