avery_dagostino
12/29/2022, 5:27 PMtap-oracle
to work and it seems that it's not recognizing my Oracle client:
cx_Oracle.DatabaseError: DPI-1047: Cannot locate a 64-bit Oracle Client library: "libclntsh.so: cannot open shared object file: No such file or directory".
I installed Meltano via pipx
inside of WSL2, and I believe my Oracle client is installed, but I'm not sure if it's configured properly.
Any tips?jaye_howell
12/29/2022, 10:22 PMsteve_clarke
02/13/2023, 7:26 PM# Install the libaio1 library for the Oracle Client
You may need to also define path variables to ensure the Oracle Client binaries and libraries are known.
# Set required Oracle Client environment variables
export ORACLE_HOME="/opt/oracle/instantclient_19_12"
export PATH="$PATH:$ORACLE_HOME" \
LD_LIBRARY_PATH="$LD_LIBRARY_PATH:$ORACLE_HOME" \
TNS_ADMIN="$ORACLE_HOME/network/admin"