maquejp
commented
1 year ago 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
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:
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/ORCLCDBWIth 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 }