Oracle-instant Client 19.3-basic Download

[Aline Braunbeck]

oraclexe is the name of the docker container running my database (from official repo as well).

First I have to say that when I install ping to the docker client container, I can ping oracle-xe. Also I can connect to the database using sql developer from my windows. And from the oracle client docker container if I use this command line it works :

sqlplus userName/password@oracle-xe/XE

My problem is only when trying to connect using the tnsnames.ora inside the oracle client container.

Here is my command line to run the client : docker run -ti --network=sai --rm oracle-instantclient bash

when I run sqlplus (without parameters) and after entering username/password I got this message :

ORA-12162: TNS:net service name is incorrectly specified

then if I set the ORACLE_SID variable (which shouldn't be needed since it's defined in the tnsnames.ora) I got this other error :

ORA-12545: Connect failed because target host or object does not exist

I wanted to try tnsping but it's not included in the oracle instant client and I didn't know where to find it. I tried using the one installed in the oracle database container but it's not working.

I hope someone can help me solve this issue

3a8082e126