×
Menu

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:
 
 
After that, install your Oracle Database.
 
 
When downloaded, please start the installer program. Press Next, read the license agreement and accept that. Press Next again, choose the default path for installation and press Next. Now enter SYS Password, click Next and finish the setup by clicking Install.
 

Setting up a new database

 
Create a new connection and enter the following names:
 
Username: SYSTEM
Password: Your SYS Password
Hostname: localhost
SID: xe
 
Click on login, open file CreateDatabase.sql and execute the script. After that, open a Windows Command Prompt and 'cd' into the folder, where aqua dump file is located. In this location enter the following command:
 
imp AQUA/AQUA ignore=Y log=aqua_imp.log file=aqua_3.2.3.0.dmp
 
 
 
In case that you received a diff file, you have to execute this diff.sql to update the dump to the current aqua Version. You can apply this diff.file according to our update guideline.
 
The next step is to create a new connection in your Oracle SQL Developer.
 
 
Finally, we have to configure our license file in database. For that we open our license file with a text editor (e.g. Notepad), copy value of tag CustomerAccount,  paste it into our query and apply it to the database.
 
UPDATE CUSTOMER SET ACCOUNT = 'CustomerAccount'
 
Your aqua Database is now installed.
 

Configuring Database Connection

In the following steps, we connect your aqua system to the database.
 
First we replace the hibernate.cfg.xml into C:\Programm Files\andagon GmbH\aqua for IIS\Web\Webservice\bin. After that we open the Web.config in folder C:\Programm Files\andagon GmbH\aqua for IIS\Web\Webservice.
 
Replace row <add key="Database" value="Data Source=X; User Id=Y;Password=Z;"/> with:
 
<add key="Database" value="Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=$HOST)(PORT=$PORT)))(CONNECT_DATA=(SERVER=DEDICATED)(SID=$SID)));User Id=$USER;Password=$PASSWORD;"/>
 
Replace $HOST,$PORT,$SID,$USER and  $PASSWORD with your data:

<add key="Database" value="Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SID=XE)));User Id=AQUA;Password=AQUA;"/>
 
After that we configure our Oracle Version. For that we open folder C:\app\Administrator\product\11.2.0\client_1\ODP.NET\bin\2.x, open file Ora-ProvCfg and identify the version. This version has to be inserted into the Web.config file.
 
 
 
 
 
 
Now we have to disable 32-Bit Applications in IIS. For that we open the IIS, open context-menu on aquaAPIPool and select Set Application Pool Defaults. Here we set Enable 32-Bit Applications on False.
 
 

Installing ODP driver

aqua requires an ODP.NET driver to successfully connect to an Oracle database. This driver can be retrieved from http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html. Be careful: download the right version (e.g. ODAC121024Xcopy_x64.zip)! Extract the downloaded files, open a command prompt, change directory to the extraction target and execute the following command:
 
install.bat odp.net2 c:\odac odac
 
Finally, you can install your aqua client by installing aqua.msi and start the client. The default login data is as follows:
 
Username: Administrator
Password: default
Server: localhost
 
 
 
Your aqua system should be ready to use!