This section describes the steps necessary to install and configure Oracle.
System Requirements
The CatDV Enterprise Server for Oracle currently requires the following:
- Operating system: Windows 2000 or Windows XP
- 512MB RAM minimum, 1024MB or more recommended
- Oracle 10g or newer
To install Oracle and the CatDV Server on a machine you will require system administrator privileges and a working knowledge of administration procedures and command line tools for your chosen operating system. If necessary please consult your local system support group.
Oracle DBA skills required
Oracle Database is a large and complex suite of programs which you (or other people in your organization) are assumed to be familiar with already. The instructions provided here cover the bare minimum needed to install Oracle and set up a CatDV database on a single machine. Oracle administration topics such as storage management, security, network operation, load balancing, backups and recovery etc. are well beyond the scope of this guide. Instead, please refer to the documentation provided with Oracle or to any full-time Oracle DBAs within your organization for assistance with installing, configuring and administering the Oracle database.
A note on passwords
In the following instructions, replace topsecret with a password of your own choice for administering Oracle as a whole. Replace secret with another password for use by the CatDV application; this password is less secure and appears in plain text form in scripts or registry entries and should not be the same as any other passwords you use.
It is possible to configure Oracle to use Windows user authentication (host credentials) for controlling access to the database but in the notes below we are assuming that Oracle user names and passwords (database credentials) will be independent of Windows user accounts.
Installing Oracle Full Version
(These notes describe using the full version of Oracle 11g. See 4.3 for a simpler alternative using Oracle 11g Express Edition.)
- Obtain the Oracle Database 10g Installer, either by downloading it from Oracle’s web site or ordering a CD from your Oracle vendor. (Please note that, although the Oracle database software is in general freely available to download and install under a developer/evaluation license, you are responsible for purchasing any required licenses and ensuring you adhere to Oracle’s license conditions.)
- Make sure you have Windows administrator privileges for your machine. Run the Oracle installer and select a Basic Installation of the Enterprise Edition
- Select the option to create a starter database, with global database name ORCL and password topsecret. (You can skip this step and use an existing database instance if you have one, or use a different name if you choose.)
- Let the Oracle installer and configuration assistants run to completion (approx. 30 minutes)
- When the Database Configuration Assistant completes, make a note of the summary information displayed, eg.
Global Database Name: orcl System Identifier (SID): orcl Server Parameter Filename: C:oracleproduct10.1.Db_1databasespfileorcl.ora Enterprise Manager URL: http://localhost:5500/em Ultra Search URL: http://localhost:5620/ultrasearch iSQL*Plus URL: http://localhost:5560/isqlplus
- If you need to connect to and administer the database you can either use the web based Enterprise Manager, or run “mysql /nolog” then type “connect sys/topsecret as sysdba” followed by SQL commands at the SQL> prompt. Refer to the Oracle documentation for further information.
- Once you have installed the Oracle database you need to create a catdv user.
- The Oracle Enterprise Manager is automatically loaded at the end of the Oracle installation process, or you can open a web browser with the Enterprise Manager URL you noted earlier (eg. http://localhost:5500/em).
- Log on to Enterprise Manager: User Name: SYS, Password: topsecret, Connect As: SYSDBA
- Go to the Adminstration tab, then Users (under Security). Click on Create.
- In the Create User form enter these details: User Name: catdv, Password: secret. Leave other options blank or at their default values. Go to the Roles tab, click on Modify, find the “Resource” role in available roles and Move to right. Press OK twice.
Creating a ‘catdv’ user in the Oracle database
- The Oracle Enterprise Manager is automatically loaded at the end of the Oracle installation process, or you can open a web browser with the Enterprise Manager URL you noted earlier (eg. http://localhost:5500/em).
- Log on to Enterprise Manager: User Name: SYS, Password: topsecret, Connect As: SYSDBA
- Go to the Adminstration tab, then Users (under Security). Click on Create.
- In the Create User form enter these details: User Name: catdv, Password: secret. Leave other options blank or at their default values. Go to the Roles tab, click on Modify, find the “Resource” role in available roles and Move to right. Press OK twice.
Installing Oracle 11g Express Edition
As a simpler alternative to the full version of Oracle you can use the new Oracle 11g Express Edition, which is free to download and deploy but omits some of the more advanced features of Oracle. (For example, the Express Edition doesn’t include a Java VM or application server, and many aspects of the installation is simpler because you are limited to a single Oracle database instance.)
- Start by downloading the OracleXE.exe installer from Oracle’s web site. Make sure you have Windows administrator privileges for your machine. Run the installer and follow the instructions. You can leave the destination as its default value of C:oraclexe.
- Choose a password topsecret for the SYS and SYSTEM accounts.
- On completion (this takes several minutes) the installer will launch the Oracle web interface (http://localhost:8080 by default) which you use to administer Oracle.
- In the web interface, log in as user SYSTEM with your password topsecret.
- Click on Administration, then Manage Database Users
- Click Create and create a new user with name catdv and password secret. Leave the other options as their default value (ie. with CONNECT and RESOURCE roles). Click Create to confirm.