ODP setup for Windows ArrayServer using Oracle Database

From Array Suite Wiki

Jump to: navigation, search


When Windows ArrayServer is using Oracle as database, the recommended option is to use "Oracle Data Provider for .NET" (ODP) connection.

Install Oracle Data Access Components

  • Download the oracle data access components from Oracle, the current recommendation is to use 64-bit ODAC 11.2 Release 5 (11.2.0.3.20) Xcopy for Windows x64
  • Unzip zip file
  • Read the readme.htm file
  • Start command line cmd (RUN as administrator)
  • Install all ODAC products using command install.bat all c:\oracle odac

Configure the ArrayServer.cfg

Add the following database section in ArrayServer.cfg.

Example:

[Database]
Provider=ODP
Server=192.168.1.14
Port=1521
DataSource=om13
User=ArrayServer
Password=omicsoft
DataFileDirectory=C:\Working\NewTest\


Provider: either Sqlite or Oracle or ODP (Windows ArrayServer only for direct ODP connection) (if Sqlite is specified the other options are ignored)

Server: specify the location of the Oracle server (IP address)

Port: specify the port of the Oracle server

DataSource: specify the name of the oracle database to be used

DataFileDirectory: species the location of the tablespace files

User: specify the oracle user to be used for accessing the database

Password: specify the password for the oracle user for accessing the database