Modifying Oracle connection settings

If your Oracle configuration changes for your AX Server database, you need to update the connection settings for AX Server, and for AX Engine Node and AX Exception if they are part of your ACL Analytics Exchange implementation.

To modify your Oracle connection settings:

  1. Modify the aclDatabase.xml and aclQuartz.properties template configuration files with the settings required for your database. For non-SSL configurations use the files in the Oracle folder, and for SSL configurations use the Oracle_SSL subfolder.

    The template folders are located in the Installation_Backup\Configuration subfolder where the ACL Analytics Exchange application server you are updating is installed. Save and close the file after you have made the necessary changes.

  2. Modify the db-resource-adapter XML file for your configuration with the connection information for your server. If you are configuring SSL, there are specific XML files for each supported Oracle version that must be used. The TNSEntryName property must specify the correct Host, Port and Service_Name settings to connect to your ACL Analytics Exchange database. Save and close the file after you have made the necessary changes.
  3. Copy aclDatabase.xml and aclQuartz.properties from the template folder to the geronimo\var\config subfolder. You should delete the database account information from the aclDatabase.xml template file after you copy the file to the config subfolder.
  4. Open a command prompt and switch to the Installation_backup subfolder where AX Server is installed.
  5. Redeploy the database layer using the appropriate command for your configuration. The required uid and pwd values are the username and password you use to log in to the Geronimo Console web application and the AX Server Configuration web application. You also need to replace <version_number> with the correct version number for your installation.

    Non-SSL:

    java -jar %GERONIMO_HOME%\bin\deployer.jar --user uid --password pwd redeploy deploy\tranql-connector-oracle-local-1.5.rar configuration\oracle\db-resource-adapter-oracle.xml com.acl.ax.server/AclAuditExchangeDbPool/<version_number>/rar

    SSL for Oracle 11g:

    java -jar %GERONIMO_HOME%\bin\deployer.jar --user uid --password pwd redeploy deploy\tranql-connector-oracle-local-1.5.rar configuration\oracle_ssl\db-resource-adapter-oracle-ssl.xml com.acl.ax.server/AclAuditExchangeDbPool/<version_number>/rar

    SSL for Oracle 10g:

    java -jar %GERONIMO_HOME%\bin\deployer.jar --user uid --password pwd redeploy deploy\tranql-connector-oracle-local-1.5.rar configuration\oracle\db-resource-adapter-oracle10g-ssl.xml com.acl.ax.server/AclAuditExchangeDbPool/<version_number>/rar
  6. Restart the ACL Analytics Exchange Geronimo service.
  7. Navigate to the Geronimo Console and start any components that have not started automatically in the Web App Wars and Application EARs pages under Applications in the Console Navigation treeview.

    AX Server

    • com.acl.ax.server/db/<version_number>/car

    • com.acl.cas/cas-server/<version_number>/war

    • com.acl.ax.server/AclAuditExchange/<version_number>/car

    • com.acl/gateway-backend/<version_number>/war

    • com.acl.ax/webclient/version_number/war

    • com.acl.ax.server/AXSystemAdministration/<version_number>/car

    • com.acl.ax.server/rest/<version_number>/car

    AX Engine Node

    • com.acl.ax.server/db/<version_number>/car

    • com.acl.ax.server/AclSchedulingNode/<version_number>/car

    AX Exception

    • com.acl/ax-em_admin/<version_number>/war

    • com.acl/exceptionmgmt/<version_number>/war

Related tasks
Related reference

(C) 2015 ACL Services Ltd. All Rights Reserved.