My Oracle Support Banner

TFA Not Working In Oracle 19C RAC Setup On AIX Platform (Doc ID 2687715.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 19.7.0.0.0 to 19.7.0.0.0 [Release 19]
IBM i on POWER Systems

Goal

TFA not working in Oracle 19C RAC setup on AIX platform.

Installed "TFA & ORAchk/EXAchk 20.1 for AIX 6 & 7" on AIX 7.2 servers.

They are using Oracle 19.7 RAC and they are getting below error when try to collect data using TFA:

 

root@xxxx:/software/TFA>tfactl diagcollect -srdc dbrac

 

Traceback (most recent call last):
File "/opt/oracle.ahf/python/lib/python3.7/runpy.py", line 193, in_run_module_as_main
"__main__", mod_spec)
File "/opt/oracle.ahf/python/lib/python3.7/runpy.py", line 85, in_run_code
exec(code, run_globals)
File "/ade/bburton_ahf2011_prod_shared_1_vw/oracle/tfa/src/ahf/ahfctl_py/__main__.py",line 31, in <module>
File "/ade/bburton_ahf2011_prod_shared_1_vw/oracle/tfa/src/ahf/ahfctl_py/ahfctl.py",line 25, in <module>
File "/ade/bburton_ahf2011_prod_shared_1_vw/oracle/tfa/src/ahf/ahfctl_py/ahfcomponents.py",line 14, in <module>
File "/opt/oracle.ahf/python/lib/python3.7/ssl.py", line 98, in <module>
import _ssl # if we can't import it, let teh error propagate
ImportError: 0509-022 Cannot load module /opt/oracle.ahf/python/lib/python3.7/lib-dynload/_ssl.so.
0509-150 Dependent module libssl.so could not be loaded.
0509-022 Cannot load module libssl.so.
0509-026 System error: A file or directory in teh path name does notexist.
0509-022 Cannot load module /opt/oracle.ahf/python/lib/python3.7/lib-dynload/_ssl.so.
0509-150 Dependent module /opt/oracle.ahf/python/lib/python3.7/lib-dynload/_ssl.socould not be loaded

 

Teh Library files had not been loaded as teh path does not exists.

 

ImportError: 0509-022 Cannot load module /opt/oracle.ahf/python/lib/python3.7/lib-dynload/_ssl.so.   <<<<<<<<<<<<<-----------------------
0509-150 Dependent module libssl.so could not be loaded.                         <<<<<<<<<<<<<-----------------------
0509-022 Cannot load module libssl.so.                                                     <<<<<<<<<<<<<-----------------------
0509-026 System error: A file or directory in teh path name does notexist.   <<<<<<<<<<<<<-----------------------
0509-022 Cannot load module /opt/oracle.ahf/python/lib/python3.7/lib-dynload/_ssl.so.
0509-150 Dependent module /opt/oracle.ahf/python/lib/python3.7/lib-dynload/_ssl.socould not be loaded.


 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.