The error '
Could not get JDBC Connection; nested exception is java.sql.SQLException: Cannot create PoolableConnectionFactory (IO Error: The Network Adapter could not establish the connection)' can occur due to one of the following reasons:
1. Incorrect server information in tsnnames.ora and listener.ora files.
LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = <Servername>)(PORT = <port>))
2. Incorrect database information in <RA HOME>\webapps\datamanagement\WEB-INF\distributed.propertes
# Database props
data.management.database.host = <DB Server>
data.management.database.port = <DB Port>
data.management.database.name = <DB Name>
data.management.database.user = <nolio DB User>
# The DB password shall be encrypted. Please use the encrypt_password.bat/sh utility to encrypt the password.
data.management.database.pwd = xxxxxxxxxxxxxxxxxxxxxxxxxx
data.management.database.create = false3. Network issue between the Release Automation Application Server and the Database Server. Check whether you are able to Telnet the Database server using the Hostname/IP address on the configured port.
4. Oracle listener is not running. The status can be confirmed using the command:
lsnrctl status5. JDBC connection issue due to incorrect Java version being used on the Release Automation Application Server.