Hello everybody, I had installed docker Oracle 12c:
docker run -d -it --name OracleDB -P store/oracle/database-enterprise:18.104.22.168
then I logged into the container’s inner sqlplus to create a new user “MYUSER” for the default PDB: ORCLPDB1
docker exec -it OracleDB bash -c "source /home/oracle/.bashrc; sqlplus /nolog"
SQL>connect sys/Oradoc_db1@ORCLCDB as sysdba
BUT I can only log into Oracle’s ORCLCDB from host using mapped port, and can’t login ORCLPDB1 using user “MYUSER”, I use DBeaver. I noticed there have no “tnsnames.ora” under ‘/u01/app/oracle/product/12.2.0/dbhome_1/network/admin/’ in container’s environment and add the file by using:
docker exec -it OracleDB bash -c "vi /u01/app/oracle/product/12.2.0/dbhome_1/network/admin/tnsnames.ora"
But it doesn’t work at all.in addition , I can’t log into Oracle’s ORCLCDB from the host using
sys. It says:
Connection refused, socket connect lapse 1 ms. /172.17.0.1 32769 0 1 true
How can I log from outside the container using my created user?
One more word: I can log into the inner container’s sqlplus using “MYUSER/pswd@ORCLPDB1”