Unable to add Autosys scheduler that has an Oracle database to new AAI environment.
search cancel

Unable to add Autosys scheduler that has an Oracle database to new AAI environment.

book

Article ID: 217746

calendar_today

Updated On:

Products

Automation Analytics & Intelligence

Issue/Introduction

Unable to add an Autosys scheduler that has an Oracle database on a new AAI server that was just installed. 

Environment

Release : 6.2.0-2

Component : AUTOMIC AUTOMATION INTELLIGENCE ENGINE

Resolution

For connecting to an Oracle database for a scheduler or for AAI, you will need the oracle ojdbc8.jar driver.

 

Without it  you may see an error like below in the jaws.log

     java.sql.SQLException: No suitable driver


Instructions for this can be found in the link below:

Support for Non Redistributable Database Drivers

 

You can download it from here:

https://www.oracle.com/database/technologies/instant-client.html

 

The driver needs to be in the <Install Dir>\jboss\standalone\deployments directory and you will need to restart the AAI service once it is in place. 

Additional Information

Note that in the upcoming 6.4.6 this driver will be included with the AAI installation.