Problem: 

Loading <server>:8080 into a browser works. But when clicking the button to access the ROC it returns the error:

HTTP Status 404 - /datamanagement/index.jsp

Also, when trying to log into ASAP with your user/pass it returns the error: Failed to contact Nolio Server. 

Accessing the ROC and getting the 404 is typically more telling than an error while trying to login to ASAP UI. 

Environment:  

Release Automation 5.5.2.191

Oracle DB

Cause: 

This problem was related to Oracle preventing all JDBC connections from being made. The sqldeveloper tool experienced the same exact problem. 

There are a number of articles on the internet pointing to the SID vs. ServiceName and other things. When running lsnrctl status it showed that the SID/SERVICE (being used by RA) was READY as well as a few UNKNOWN.  The lsnrctl status also showed the TCP protocol was using the IPV6 address.

Resolution:

1. Change the listener to only use IPV4 addresses by adding "IP=V4_ONLY" (defined in the listener.ora).
   • Note: This alone did not resolve the issue and may not have had any impact.
2. Make sure that the service name is in the listener.ora. In this case it was not. The service name shown was for one of the UNKNOWN services. Once it was changed to the service name used by RA (and recycled the Oracle<Service> service and OracleListener service) it began allowing JDBC connections. 

IMPORTANT:

Please consult your Oracle DBA if you experience the errors shown in the "Additional Information" section below. This way they can confirm the root cause and identify an appropriate solution instead of making misc configuration changes to oracle without their approval.

Additional Information:

Confirm if this article applies to your situation by:

1. Stop RA services on the NAC
2. Delete the files in your NACInstallDir/logs folder
3. Start RA services on the NAC
4. Open the nolio_dm_all.log and search for the message: Could not retrieve version info from DB. org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC connection; nested exception is java.sql.SQLException Cannot create PoolableConnectionFactory (IO Error: The Network Adapter could not establish the connection).

You can normally search for version_table to see how the connection to the database is going.

Release: NOLNAC99000-5.5-Nolio-Automation Center
Component: