Menu
When I run the sql developer and set the all data,click the connect but i get this error:
Status : Failure -Test failed: IO Error: Got minus one from a read call
I am beginner in Oracle. How can I solve that error?
I use 64-bit Windows7 and oracle 12c.
700
sql. SQLRecoverableException: IO Error: Got minus one from a read call, connect lapse 11 ms., Authentication lapse 0 ms.) This error is generated by the DBMS (on this case, Oracle) and it means that PAM is requesting the availability to open new connections against the database, but the DBMS is not doing it.
The ROLLBACK statement undoes all changes for the current session up to the savepoint specified by savepoint_name. If this clause is omitted, then all changes are undone. Optional. It is used to force the rollback of a transaction that may be corrupt or in doubt.
The sqlnet. ora file enables you to do the following: Specify the client domain to append to unqualified names. Prioritize naming methods.
In my case the error is connected to a problem about the client's (SQL Developer) ojdbc8 driver and the Oracle 19.3 docker container. The solution for me was to set a system property on the client -- you can do it within the JDBC connection string):
jdbc:oracle:thin:@tcp://host:port/service?oracle.net.disableOob=true
This is the thread that lead me to the answer.
The cause of the error is described here:
https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=357910144923387
You can also solve this problem by dissabling OOB on server side in the sqlnet.ora:
DISABLE_OOB=ON
Another workaround is to use the ojdbc7 driver.
Hope this helps some of us.
105
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
