Unable to connect to Oracle database when starting

Still need help?

The Atlassian Community is here for you.

Ask the community

Symptoms

When using Oracle, Fisheye/Crucible fails to start. The following appears in the atlassian-fisheye-YYYY-MM-DD.log:

2014-09-08 10:58:44,026 ERROR [BoneCP-pool-watch-thread-mainPool ] com.jolbox.bonecp.PoolWatchThread PoolWatchThread-fillConnections - Error in trying to obtain a connection. Retrying in 7000ms
java.sql.SQLException: IO Error: The Network Adapter could not establish the connection
	at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:419)
	at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:536)
	at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:228)
	at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
	at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
	at java.sql.DriverManager.getConnection(DriverManager.java:582)
	at java.sql.DriverManager.getConnection(DriverManager.java:185)
	at com.jolbox.bonecp.BoneCP.obtainRawInternalConnection(BoneCP.java:256)
	at com.jolbox.bonecp.ConnectionHandle.obtainInternalConnection(ConnectionHandle.java:211)
	at com.jolbox.bonecp.ConnectionHandle.<init>(ConnectionHandle.java:170)
	at com.jolbox.bonecp.PoolWatchThread.fillConnections(PoolWatchThread.java:101)
	at com.jolbox.bonecp.PoolWatchThread.run(PoolWatchThread.java:82)
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
	at java.lang.Thread.run(Thread.java:619)
Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection
	at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:375)
	at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:422)
	at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:678)
	at oracle.net.ns.NSProtocol.connect(NSProtocol.java:238)
	at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1054)
	at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:308)
	... 14 more
Caused by: java.net.ConnectException: Connection timed out: connect
	at java.net.PlainSocketImpl.socketConnect(Native Method)
	at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
	at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
	at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
	at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
	at java.net.Socket.connect(Socket.java:529)
	at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:201)
	at oracle.net.nt.ConnOption.connect(ConnOption.java:123)
	at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:353)
	... 19 more
2014-09-08 10:58:50,401 ERROR [BoneCP-pool-watch-thread-mainPool ] com.jolbox.bonecp.hooks.AbstractConnectionHook AbstractConnectionHook-onAcquireFail - Failed to acquire connection Sleeping for 7000ms and trying again. Attempts left: 4. Exception: oracle.net.ns.NetException: The Network Adapter could not establish the connection

Cause

Oracle's database listener is not running.

Resolution

Start Oracle's database listener and restart Fisheye/Crucible.

Last modified on Jul 31, 2018

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.