Managing the database on Oracle

Configure the database, run setup database scripts, set up SSL, or backup and restore the Oracle database server.

Using SSL and running database scripts manually

Before you run the AX Server setup wizard to install the application, run the supplied SQL script to create the AX Server database user.

You must run these scripts manually before installing AX Server if you intend to use an SSL connection.

For more information, see Running the Oracle database scripts.

Change Oracle connection settings

If your Oracle configuration changes, update the connection settings for AX Server, AX Engine Node, and AX Exception so that the applications can connect to the database.

1. Update the unencrypted copies of the aclDatabase.xml and aclQuartz.properties configuration files with your database settings and then save and close the files.

   aclDatabase.xml must inlude the following:

   <entry key="jdbcUrl">jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS = (PROTOCOL = TCPS)(HOST = server_ip)(PORT = 2484))(CONNECT_DATA = (SERVICE_NAME = AX51)))</entry>
   <entry key="connectionProperties">oracle.net.ssl_cipher_suites=(SSL_DH_anon_WITH_3DES_EDE_CBC_SHA,SSL_DH_anon_WITH_RC4_128_MD5)</entry>

2. Copy the edited configuration files to the Tomcat\conf sub-folder and then delete the database account information from the unencrypted copy of aclDatabase.xml.
3. Restart the TomEE application server service and from the Tomcat Web Application Manager, start any applications that do not start automatically.