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

You can configure Oracle Database 10g R2 or Oracle Database 11g R1 as an external database on a dedicated server for ZENworks 7.3 Linux Management. Before installing the Oracle Database 10g R2 or Oracle Database 11g R1, ensure that the 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. To install Oracle Database 11g R1, see the Oracle 11g documentation.

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

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

  1. On the ZENworks 7.3 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 or Oracle 11g R1 database server location specified in the linux-createdb-oracle-10g.sql file.

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

  1. On the ZENworks 7.3 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 or Oracle 11g R1 database server location specified in the windows-createdb-oracle-10g.sql file.