3.3 Configuring Oracle 10g Release 2 as a Remote Database Server

You can configure Oracle Database 10g R2 as an external database on a dedicated server for ZENworks 7.2 Linux Managementwith IR2 Hot Patch 2. Before installing the Oracle Database 10g R2 , ensure that the32-bit (i386) RPM packages of the Oracle Database 10g R2 Instant Client are installed on the ZENworks Linux Management server. For more information on installing the database client, see Section 3.2, Installing the Oracle Database Client.

To install Oracle Database 10g R2, see the Oracle 10g documentation.

Review the following sections to configure the Oracle Database 10g R2 on Linux and Windows:

3.3.1 Configuring Oracle 10g R2 as a Remote Database Server on Linux

  1. On the ZENworks 7.2 Linux Management server, go to /opt/novell/zenworks/share/datamodel,open the linux-createdb-oracle-10g.sql file, and follow the instructions in the file to configure the server.

  2. Copy the linux-createdb-oracle-10g.sql server schema file and the linux-init-oracle-10g.ora initialization script file from /opt/novell/zenworks/share/datamodel to the Oracle 10g R2 database server location specified in the linux-createdb-oracle-10g.sql file.

3.3.2 Configuring Oracle 10g R2 as a Remote Database Server on Windows

  1. On the ZENworks 7.2 Linux Management server, go to /opt/novell/zenworks/share/datamodel, open the windows-createdb-oracle-10g.sql file, and follow the instructions in the file to configure the server.

  2. Copy the windows-createdb-oracle-10g.sql server schema file and the windows-init-oracle-10g.ora initialization script file from /opt/novell/zenworks/share/datamodel to the Oracle 10g R2 database server location specified in the windows-createdb-oracle-10g.sql file.