|
|
OpenCRX Installation Guide for Oracle 9
Version 1.6.0
www.opencrx.org
The contents of this file are subject to a BSD license (the "License"); you may not use this file except in compliance with the License.
You may obtain a copy of the License here
- Table of Contents
- 1. About this Book
- 2. Prerequisites
- 3. Upgrading from previous versions
- 4. Create the database
- 5. Install Database Schema Objects
- 6. Next Steps
- A. Appendix
- Bibliography
- List of Figures
- 4-1. Create a new database.
- 4-2. Create the schema CRX.
- 4-3. Create a new database user and grant permissions.
- 5-1. Strip Null Lines in DDL scripts
- 5-2. Install Database Schema Objects
-
Chapter 1. About this Book
This book describes how to setup an openCRX database instance for Oracle.
Who this book is for
The intended audience are openCRX database administrators.
What do you need to understand this book
This book describes the installation of openCRX for Oracle. The book assumes that you are familiar with Oracle installation and configuration.
Chapter 2. Prerequisites
As a first step you must download the following software packages:
-
Download openCRX for Oracle from here (e.g. opencrx-1.6.1-core.oracle-8.zip or opencrx-1.6.1-core.oracle-8.tar.gz). The distribution contains the Oracle SQL scripts required to install the openCRX database.
-
Download Oracle Database Server from here. You will require an OTN account.
-
You can find the Oracle JDBC driver inside the Oracle client distribution. Alternatively, you can download it from here
Please ensure that you install the correct JDBC driver (i.e. matching JDK, Oracle version, etc.) and one JDBC driver only! Ignoring this wisdom leads to problems as the connection to the database will fail.
As a next step you must install Oracle. The Oracle documentation explains in detail how to install the database.
This document assumes that you use the Oracle dbca tool and the Sql*Plus for database administration. The JDBC driver is required for the application server installation.
Chapter 3. Upgrading from previous versions
If you already have Oracle for openCRX installed, upgrade the database as explained below. You can then skip the rest of this document.
The openCRX distributions provide an SQL script of the form upgrade-from-<version from>-to-<version to>.sql. E.g. If you have installed openCRX 1.5.0 and you want to upgrade to version 1.6.0 you have to run the script upgrade-from-1.5.0-to-1.6.0.sql on your database instance.
Chapter 4. Create the database
An existing database may be utilized, or alternatively you may create a new database.
A new database instance may be created with the Oracle Database Configuration Assistant (dbca). The following snapshots are taken from a windows installation, but the procedure is identical for all supported platforms. It is assumed the base oracle installation directory (Oracle Home) is "c:/oracle".
Start dbca as the Oracle owner account and Create a new "General Purpose" database as shown in Figure 4-1.
Figure 4-1. Create a new database.
Enter CRX as database name as shown in Figure 4-2 and click OK.
Figure 4-2. Create the schema CRX.
Continue through the screens, tuning the database parameters as required (the defaults will work in most simple deployments). Finally, select Create Database and select Finish in Step 7.
Next you must create a database user, tablespaces and grant this user access to the newly created database. Ensure your shell environment is setup with the following variables:
ORACLE_SID=CRX
ORACLE_HOME=c:/oracle
PATH=${ORACLE_HOME}/bin:${PATH}
Launch a terminal, and execute command sequence as demonstrated in Figure 4-3.
Figure 4-3. Create a new database schema.
Of course Oracle Enterprise Manager, Toad and various other 3rd party tools will achieve the equivalent goal, but rarely with the same speed and control if you are not scared of a command line.
You are now done creating the database and database schema.
Chapter 5. Install the OpenCRX Database Schema objects
After creating the schema you are now ready to install the openCRX database schema objects.
Oracle has issues with the null lines in the DDL scripts. This can be resolved by manually editing the files, or alternatively using a command to strip the empty lines out demonstrated in Figure 5-1.
Figure 5-1. Strip Null lines from DDL scripts
Start Oracle Sql*Plus, and login as opencrx_user, password opencrx_user. Copy/paste the database script dbcreate-tables.sql and execute it as shown in Figure 5-2.
Figure 5-2. Install Database Schema objects
Similarly, exec the script dbcreate-indexes-nonulllines.sql.
The scripts should run without errors.
Chapter 6. Next Steps
If you have completed successfully the database installation you are ready to use the openCRX database. The application server installation guides explain how to connect the application server to the openCRX database instance.
Appendix A. Appendix
Bibliography
[01] openCRX - the leading open source CRM solution, opencrx.org.
[02] openMDX - The leading open source MDA platform, openmdx.org.
