Ubuntu 20.x / Oracle 21.3 / ORA-12170: TNS:Connect timeout occurred

[maquejp]

Hello, I am having issue with the docker image on Ubuntu 20.x

Until this week, I was working on a WIN20+WSL2 but I was asked to start working on a new computer which use Ubuntu 20.

So I start to try to created an Oracle Database 21c.

I cloned this project, downloaded the related file (LINUX.X64_213000_db_home.zip) and created the image following the guidelines (not my first time)

Then I have set a simple dockercompose file

version: "3.8" services: service-oracle2130-database: image: oracle2130 container_name: service-oracle2130-database ports: - "1596:1521" environment: - ORACLE_SID=ORCLCDB - ORACLE_PDB=ORCLPDB - ORACLE_PWD=Oracle4System - ORACLE_MEM=2000 - DISABLE_OOB=ON volumes: - ./database/OracleDB/oradata:/opt/oracle/oradata - ./database/scripts/system/setup:/opt/oracle/scripts/setup - ./database/scripts/system/startup:/opt/oracle/scripts/startup networks: - app-oracle2130-network networks: app-oracle2130-network:

The container is well created, the database is successfully created and ready to use. BUT when I try to connect to it it fails. with SQLDeveloper or the command sqlplus system/"Oracle4System"@localhost:1596/ORCLCDB

WIth SQL+ I receive : ORA-12637: Packet receive failed

And I have the following in the log of the server

`Fatal NI connect error 12170, connecting to: (ADDRESS=(PROTOCOL=tcp)(HOST=172.20.0.1)(PORT=45488))

VERSION INFORMATION: TNS for Linux: Version 21.0.0.0.0 - Production Oracle Bequeath NT Protocol Adapter for Linux: Version 21.0.0.0.0 - Production TCP/IP NT Protocol Adapter for Linux: Version 21.0.0.0.0 - Production Version 21.3.0.0.0 Time: 14-JUL-2022 15:49:14 Tracing not turned on. Process Id = 1288 Tns error struct: ns main err code: 12535

TNS-12535: TNS:operation timed out ns secondary err code: 12606 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 2022-07-14T15:49:14.747455+00:00 opiodr aborting process unknown ospid (1288) as a result of ORA-609 2022-07-14T15:49:14.747695+00:00 Errors in file /opt/oracle/diag/rdbms/orclcdb/ORCLCDB/trace/ORCLCDB_ora_1288.trc: ORA-00609: could not attach to incoming connection ORA-12170: TNS:Connect timeout occurred`

I found this issue #1821 and added the sqlora.net with the DISABLE_OOB workaround and it worked with SQL+ BUT not with SQLDeveloper.

As I can work/live without SQLDeveloper, no problems.

So I a took a real project (which use the same parameter for the oracle container) and ran it. But it does not work either. It is using NodeJs and of course the node-oracledb package. Again this project runs smoothly on my WIN10+WSL2 Machine but on Ubuntu.

Base on my previous experience, I modified the Dockerfile that create my NodeJS express server adding the sqlnet.ora file with the DISABLE_OOB. But same as for SQLDeveloper or without the sqlnet.ora trick.

In the NodeJs, the console.log (err) gives me the following [Error: ORA-12170: TNS:Connect timeout occurred] { errorNum: 12170, offset: 0 }

[maquejp]

Additional information following this issue #2210 I have successfully connected with SQLDeveloper and NodeJs... export JAVA_TOOL_OPTIONS="-Doracle.net.disableOob=true"

But why do I have to disable OOB on ubuntu and not on WIN+WSL2(Ubuntu)?

[albfan]

Amazing! that did then trick for me too