Hi everyone,
I am trying to connect to an Oracle Database using tap-oracle in thin mode. I have tried the connection parameters and certificates by connecting to the database via DBeaver and it worked. Now I am trying to do the same in meltano tap-oracle.
In tap-oracle's connectionhelper.py it says: "wallet_location: the directory where the wallet can be found. In thin mode this must be the directory containing the PEM-encoded wallet file ewallet.pem." Do I always need a PEM-wallet when using thin mode or can I avoid that? I am using sqlnet.ora, tnsnames.ora, cwallet.sso and ewallet.p12 so far. Is there anything else I need?
The error message contains the following:
DPY-6005: cannot connect to database (CONNECTION_ID=...).
DPY-4011: the database or network closed the connection
Any help would be greatly appreciated!