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 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 following the command (the username is aqua):
sqlplus aqua/password
5. Start spooling of output to log file by invoking command:
SPOOL diff.log;
6. Execute diff script by typing:
@Diff-"your version"-To-"target version".sql;
7. If everything was fine (no errors) then execute:
COMMIT;
SPOOL OFF;
and close sqlplus by typing
EXIT
8. In case of any problems please ask for support.
Note:
When upgrading from one of 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 saves the old backup).
