Unable to connect to nosql database on oracle cloud from sql developer on localmachine

02802866-3ee2-44b0-bd83-e67062c7b7c7

Unable to connect to nosql db using following connection details, nosql db store is setup on instance Oracle-Linux-7.7-2020.01.28-0 on cloud infrastructure it is community edition nosql. Have been able to nc to ip and port also

nc -vz 132.145.70.128 5000

found 0 associations

found 1 connections:

     1: flags=82<CONNECTED,PREFERRED>

outif en8

src 192.168.29.183 port 60609

dst 132.145.70.128 port 5000

rank info not available

TCP aux info available

Connection to 132.145.70.128 port 5000 [tcp/commplex-main] succeeded!

Error Received

oracle.kv.FaultException: Could not establish an initial login from: [132.145.70.128:5000] (12.2.4.5.12)

Fault class name: oracle.kv.KVStoreException

at oracle.kv.KVStoreFactory.getStoreInternal(KVStoreFactory.java:227)

at oracle.kv.KVStoreFactory.getStore(KVStoreFactory.java:122)

at oracle.dbtools.raptor.onsd.connection.NSConnection.open(NSConnection.java:170)

at oracle.dbtools.raptor.onsd.connection.ConnectionCreator.createConnection(ConnectionCreator.java:27)

at oracle.dbtools.raptor.onsd.connection.NSConnections$C.getConnection(NSConnections.java:42)

at oracle.dbtools.raptor.onsd.connection.NSConnections.getConnection(NSConnections.java:187)

at oracle.dbtools.raptor.onsd.navigator.OnsdConnection.openConnectionImpl(OnsdConnection.java:166)

at oracle.dbtools.raptor.onsd.navigator.OnsdConnection.openConnectionImpl(OnsdConnection.java:26)

at oracle.dbtools.raptor.navigator.db.BaseConnectionNode.getConnection(BaseConnectionNode.java:46)

at oracle.dbtools.raptor.onsd.navigator.ConnectionTreeNode$LoadTask.doWork(ConnectionTreeNode.java:63)

at oracle.dbtools.raptor.onsd.navigator.ConnectionTreeNode$LoadTask.doWork(ConnectionTreeNode.java:26)

at oracle.dbtools.raptor.backgroundTask.RaptorTask.call(RaptorTask.java:199)

at java.util.concurrent.FutureTask.run(FutureTask.java:266)

at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$RaptorFutureTask.run(RaptorTaskManager.java:702)

at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)

at java.util.concurrent.FutureTask.run(FutureTask.java:266)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

at java.lang.Thread.run(Thread.java:748)

Caused by: oracle.kv.KVStoreException: Could not establish an initial login from: [132.145.70.128:5000]

at oracle.kv.impl.security.login.RepNodeLoginManager.bootstrap(RepNodeLoginManager.java:232)

at oracle.kv.KVStoreFactory.getStoreInternal(KVStoreFactory.java:210)

... 18 more

Caused by: java.rmi.ConnectIOException: Exception creating connection to: 10.0.0.2; nested exception is:

java.net.SocketTimeoutException: connect timed out

at sun.rmi.transport.tcp.TCPEndpoint.newSocket(TCPEndpoint.java:631)

at sun.rmi.transport.tcp.TCPChannel.createConnection(TCPChannel.java:216)

at sun.rmi.transport.tcp.TCPChannel.newConnection(TCPChannel.java:202)

at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:129)

at java.rmi.server.RemoteObjectInvocationHandler.invokeRemoteMethod(RemoteObjectInvocationHandler.java:227)

at java.rmi.server.RemoteObjectInvocationHandler.invoke(RemoteObjectInvocationHandler.java:179)

at com.sun.proxy.$Proxy36.getSerialVersion(Unknown Source)

at oracle.kv.impl.util.registry.RemoteAPI.<init>(RemoteAPI.java:40)

at oracle.kv.impl.security.login.UserLoginAPI.<init>(UserLoginAPI.java:55)

at oracle.kv.impl.security.login.UserLoginAPI.wrap(UserLoginAPI.java:69)

at oracle.kv.impl.security.login.UserLoginAPI.wrap(UserLoginAPI.java:63)

at oracle.kv.impl.security.login.RepNodeLoginManager.bootstrapLogin(RepNodeLoginManager.java:444)

at oracle.kv.impl.security.login.RepNodeLoginManager.bootstrap(RepNodeLoginManager.java:151)

... 19 more

Caused by: java.net.SocketTimeoutException: connect timed out

at java.net.PlainSocketImpl.socketConnect(Native Method)

at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)

at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)

at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)

at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)

at java.net.Socket.connect(Socket.java:589)

at oracle.kv.impl.util.registry.ClientSocketFactory.createTimeoutSocket(ClientSocketFactory.java:414)

at oracle.kv.impl.util.registry.ssl.SSLClientSocketFactory.createSocket(SSLClientSocketFactory.java:289)

at sun.rmi.transport.tcp.TCPEndpoint.newSocket(TCPEndpoint.java:613)

... 31 more

userBDBDMS-Oracle

What version of Oracle NoSQL are you using?  Also what version of SQL developer are you using?

SureshDooly-Oracle

Still, facing this issue? open a Service Request.

Suresh Umapathy