Updating Oracle Database

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.
 
<qualifyAssembly partialName="Oracle.DataAccess" fullName="Oracle.DataAccess, Version=4.112.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342" />

    • Related Articles

    • Updating MSSQL Database

      At first, please ensure that all app pools are stopped and that there are no other connections to the relevant database in subject (e.g. from TOAD-s etc.). Then, make a full backup of the corresponding aqua database. For upgrading your database, the ...

    • Connection to Oracle Database 12.2c

      Before you start, you have to install Java on your local server in order to create a connection to the Database later on. You will find a recent Java JRE here: http://www.oracle.com/technetwork/java/javase/downloads/index.html After that, install ...

    • Connection to MSSQL Database

      In this chapter you will find detailed information on how to install and configure the MSSQL Database in order to connect your aqua server to the database. If you want to use an Oracle Database, please follow the installation steps described in the ...

    • Updating Server

      Update the aqua Server by executing the installer package “aqua For IIS Installer.exe”.   After Updating to a major aqua version, e.g. from aqua 20.X to aqua 21.X, please copy the new license(s) to the following folder (in default installations): ...

    • Database (Rich Client)

      In order to connect a database agent to aqua, you have to go through the following steps. First, extract the database agent zip file and open the aquaAgentDatabaseGui.exe.config.   Here, enter the agentCode and the aquaServiceURL.             <add ...