Hi! I'm new to Meltano. I'm trying to get `tap-ora...
# troubleshooting
a
Hi! I'm new to Meltano. I'm trying to get
tap-oracle
to work and it seems that it's not recognizing my Oracle client:
Copy code
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?
j
you make a connection with just theoracle client?
s
The installation instructions for the Oracle Client need to be followed. You may need to install dependent OS libraries for the Oracle Client to be installed e.g.
# 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.
Copy code
# 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"