29.7 Configuring the ZENworks Server to Point to the New Oracle Database Containing Data Moved from Another Oracle Database

If you move the data from one Oracle database to another Oracle database, the Windows or Linux ZENworks Server must be configured to point to the new Oracle database.

The following sections provide detailed information:

29.7.1 Preparing to Move the Data

Before configuring the server to point the new Oracle database, do the following:

  • Make sure that the ZENworks Server is configured to an Oracle database. The database can be installed on the ZENworks Server or on a different device. Assume that the device that currently host the Oracle database is called ORDB1.

  • Make sure that you have another Windows device with an Oracle database installed with the same database credentials as the ORDB1. Assume that this device is called ORDB2. For more information on how to install an Oracle database, see Installing an External ZENworks Database in the ZENworks 10 Asset Management Installation Guide.

  • Move the data from ORDB1 to ORDB2. For more information about moving the data, see the Oracle database documentation.

  • Stop all the ZENworks Services on all the ZENworks Servers in the Management Zone.

    • On Windows: Do the following

      1. Execute the following command at the server prompt:

        novell-zenworks-configure -c Start

      2. Specify the number next to the Stop action, then press Enter.

    • On Linux: Do the following:

      1. Execute the following command at the server prompt:

        /opt/novell/zenworks/bin/novell-zenworks-configure -c Start

      2. Specify the number next to the Stop action, then press Enter.

29.7.2 Configuring the ZENworks Server to Point to the New Oracle Database

To configure the ZENworks Server to point to the new Oracle database (ORDB2), perform the following tasks on the ZENworks Server:

  1. Edit zdm.xml (located in ZENworks_installation_path\conf\datamodel on Windows and in /etc/opt/novell/zenworks/datamodel on Linux) to do the following:

    • Make sure that the value of the Port entry key is the port number on which the Oracle database is running.

    • Set the value of the Server entry key to the IP address of the ORDB2 device.

    • Set the value of the Database entry key to net service name of the Oracle database installed on the ORDB2 device.

  2. Start all the ZENworks Services on all the ZENworks Servers in the Management Zone.

    • On Windows: Do the following

      1. Execute the following command at the server prompt:

        novell-zenworks-configure -c Start

      2. Specify the number next to the Start action, then press Enter.

    • On Linux: Do the following:

      1. Execute the following command at the server prompt:

        /opt/novell/zenworks/bin/novell-zenworks-configure -c Start

      2. Specify the number next to the Start action, then press Enter.

ZENworks Server should now point to the new database.

29.7.3 Configuring ZENworks Reporting Server to Point to the New Oracle Database

If you have installed ZENworks Reporting Server, do the following to point ZENworks Reporting Server to the new database (ORDB2). The following steps are applicable for both Windows and Linux platforms.

  1. (Conditional) If you have installed ZENworks Reporting Server, continue with Section 29.7.2, Configuring the ZENworks Server to Point to the New Oracle Database.

  2. Launch the Oracle Net Configuration Assistant Welcome Window:

    • On Windows, navigate to %ORACLE_HOME%/bin directory, then double-click the netca.bat file.

    • On Linux, navigate to the $ORACLE_HOME/bin directory, then double-click the netca executable or run the netca executable by using the vi $ORACLE_HOME/bin/./netca command.

  3. Select Local Net Service Name configuration, then click Next.

  4. Select Reconfigure, then click Next.

  5. Select the net service name that you want to reconfigure, then click Next.

  6. Specify the service name of ORDB2, then click Next.

  7. Select TCP as the protocol, then click Next.

  8. Specify the hostname of the device where the ORDB2 database is installed, then click Next.

  9. Select Yes, perform a test option to verify the connection to the ORDB2, then click Next.

  10. Click Change Login.

  11. In the Change Login window that is displayed, specify the username and password to connect to ORDB2.

  12. Click OK.

    A message is displayed indicating that the connection to ORDB2 is successful.

  13. Click Next.

  14. Specify the service name that you provided in Step 6 as the net service name, then click Next.

  15. Click Next twice.

  16. On the Oracle Net Configuration Assistant Welcome page that is displayed, click Finish to complete reconfiguring the new database ORDB2.

  17. Run the novell-zenworks-configure -c UpdateBOE command.