Forum Stats

  • 3,816,047 Users
  • 2,259,134 Discussions
  • 7,893,369 Comments

Discussions

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

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!

Screenshot 2020-02-07 at 15.32.55.png

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

Answers