Updating Oracle Database

First, please ensure that the aqua app pools are stopped (server is not running) and that there are no other connections to the relevant database (e.g. from TOAD-s etc.). Then, make a full backup of the aqua database.

Then, in order to upgrade your database, the attached SQL file (Diff-"your version"-to-"target version".sql) must be applied as follows:

1. Copy the file to the temporary folder on the database server machine

2. Copy the attached login.sql file to the same folder. This is a default configuration file of the sqlplus tool and is used automatically (see http://www.adp-gmbh.ch/ora/sqlplus/login.html)

3. Open the command prompt window and change the current directory to the temporary folder

4. Start the sqlplus command line tool and login to the aqua database. Usually, you can login by invoking the following command (the username is aqua):

sqlplus aqua/password

5. Start spooling of output to log file by invoking the command:

SPOOL diff.log;

6. Execute script to configure SQLPlus:

@login.sql;

7. Execute diff scripts by typing:

@Diff-"your version"-to-"target version".sql;

8. If everything was fine (no errors) then execute:

COMMIT;

SPOOL OFF;

and close sqlplus by typing

EXIT

9. In case of any problems please ask for support.

Note:

When upgrading from one of the previous versions of aqua, it might be required to extend permissions of an aqua user by adding permission to create JOBs. This can be done by executing the following line through DB admin (SYS or SYSTEM user):

GRANT CREATE JOB TO aqua;

After upgrading your database, we recommend to backup again (but keep the old backup).

Starting with aqua18, odp.net4 is supported. You can switch from odp.net2 to odp.net4 by changing the entry in the web.config.