Overview

After installing Actional 12 server using AureaMonitor_Management_Server_LNX.bin and executing <Actional install location>/DefaultProfile/bin/StartAureaMonitorServer.sh you may see one of the following errors in the logs:

• com.actional.jms.ext.JMSMisconfiguredException: You must specify the property 'ConnectionFactory' or 'ConnectionFactoryExt'
• java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
• java.sql.SQLException: Invalid Oracle URL specified, <msg><![CDATA[APPL0002:
• Invalid parameter named 'Connection' with a value of: <<null>>

Solution

Perform the following steps to remedy the error:

1. Use ojdbc7.jar since ojdbc8.jar is more restrictive.
2. Make sure you have executed ActionalServerCreationScript.sql which will create the necessary tables and views.
3. Provide the JDBC connection string in the format: jdbc:oracle:thin:@db_ip:db_port:db_instance_id. Contact your DB Administrator to find the correct values to use in the JDBC connection string. 

Testing

Actional will connect successfully to the database.