Database Session has been disconnected. Reconnect?

[Andres Lopez]

Hello, I have an issue with the Mac version. I'm working with two databases, one in Oracle 12c and the other in 19c. The behavior is the same: I open a session, start writing the code, execute my query, open a new SQL document, create and execute the query, then return to the first document and when trying to execute it again, the message Database Session has been disconnected. Reconnect? is displayed. What should I do to prevent the session from automatically disconnecting? I'm using Oracle 19c client.

I've put these lines on sqlnet.ora to test and has the same behavior:

SQLNET.EXPIRE_TIME = 0
SQLNET.INBOUND_CONNECT_TIMEOUT = 0
SQLNET.SEND_TIMEOUT = 0
SQLNET.RECV_TIMEOUT = 0

 

[Marco Kalter]

I cannot immediately reproduce this. Did you change the connection between the 12c and 19c databases anywhere in this scenario?

Can you also do the following?

1. Exit all Plyxon applications.
2. Start a new Plyxon application.
3. Reproduce the problem above.
4. Exit Plyxon.
5. Send $HOME/Documents/plyxon/log/debug.txt to support@allroundautomations.com.

Thanks in advance!

 

[Andres Lopez]

Thanks, I already send the email, but the last one got error on the domain

DNS Error: DNS type 'mx' lookup of allroundautomation.com responded with code NOERROR DNS type 'aaaa' lookup of localhost. responded with code NXDOMAIN DNS type 'a' lookup of localhost. responded with code NXDOMAIN

I'm attachin file here (just in case)
View attachment debug.txt

 

[Marco Kalter]

Thanks. We'll investigate.