Using Oracle with GeNet

---

GeNet's Oracle back-end storage system allows users to take advantage of the scalable capacity and architectural robustness of an Oracle database. Users can query data directly from the Oracle table structure using the GeNet schema.

You must have the following components before you can set up GeNet to work with Oracle:

• A license key that permits use of GeNet with a relational database. GeNet Oracle will not run without this.
• Oracle's Classes12.zip must be installed somewhere on the machine running GeNet. You must have the correct version of this file for your version of Oracle.

To set up GeNet to work with Oracle, do the following:

1. Stop Tomcat.
   • On Windows systems, open the Start Menu and select the command to stop GeNet.
   • On Unix/Linux/Solaris systems, navigate to the main GeNet directory and issue the following command:

% ./httpd stop

2. Open the GeNet startup script in a text editor. On Windows, this script is C:\GeNet\StartGeNet.bat. On Unix/Linux/Solaris systems, it is the httpd-start file in the GeNet home directory.
3. Add the full path to classes12.zip to the CLASSPATH line. For example, if you are on a Windows system, you might see the following:

rem set CLASSPATH=c:\sig\compiled;c:\sig\libraries

If classes12.zip on your system is located in C:\sig\classes12.zip, edit the CLASSPATH line to read:

rem set CLASSPATH=c:\sig\compiled;c:\sig\libraries;c:\sig\classes12.zip

4. Create a new database instance for GeNet.
   • For test purposes, create a username and password of genet/genet.
   • You can use most of the default parameter values for a Decision Support System.
   • Enable an unlimited number of rollback extents, since transactions can be very large.
   • GeNet does not use stored procedures, so buffer cache is more important than shared pool.
   • For best results, set the Shared Pool Size to approximately one quarter the size of (Block Size) * (Block Buffers).
5. Make a copy of the existing GeNet preferences file and name it "GeNetPreferencesBackup". On Windows this file is C:\GeNet\tomcat\GeNet Preferences. On Unix-based systems the file is GeNet/tomcat/GeNetPreferences.
6. Open the GeNet Preferences file in a text editor and locate the Database Preferences section. Change the settings as follows:
   • DB_UseDatabase : true
   • DB_DriverName : oracle.jdbc.driver.OracleDriver
   • DB_DatabaseURL : jdbc:oracle:thin:@ip_address:port_number:GeNet (where ip_address and port_number are the IP address and port number of the Oracle machine to which you are connecting GeNet)
   • DB_Username : genet
   • DB_Password : genet
   • AutoTransfer : true (This should be set to true only if you want all of the current data held in GeNet flat files to be transferred to GeNet Oracle. To disable this feature, set this value to false.)
7. Restart Tomcat.

GeNet should now start up in database mode. If it is truly running in database mode, the text "GeNet 2.5 Enterprise" appears beneath the two login boxes on the login screen.