3.4 Migrating the Data from one Oracle Database to another Oracle DatabaseMigrating the Data from one Oracle Database to another Oracle Database

ZENworks 7.3 Linux Management allows you to migrate the data from:

You can also migrate the data across different releases of the same versions. For example, you can migrate the data from Oracle Database 10g R1 to Oracle Database 10g R2.

NOTE:In this section, the database from which you are migrating the data is referred to as the source, and the database to which you are migrating the data is referred to as the destination.

Do the following on the Primary Server and Secondary Servers existing in your Management Zone:

  1. Install and configure the destination database.

    For more information, see Section 3.3, Configuring Oracle 10g Release 2 or Oracle 11g Release 1 as a Remote Database Server.

    While configuring the Oracle database, do not perform Steps 11, 12, and 13 in the linux-createdb-oracle.sql file on Linux, or in the windows-createdb-oracle.sql file.

  2. On the ZENworks 7.3 Linux Management server configured with the source database, stop all the ZENworks services by using the following command:

    zlm-config --stop

  3. On the source database that has its database instance running, take a logical backup of the ZENworks database objects schema by running the export utilities as follows as an Oracle database user:

    exp zenadmin/novell@ORCL FILE=NOVELL-ZENWORKS-ORAZLM.DMP LOG=NOVELL-ZENWORKS-ORAZLM.LOG OWNER=ZENADMIN

    where ORCL is the default Oracle system identifier.

    This creates the NOVELL-ZENWORKS-ORAZLM.DMP backup file and the ZENWORKS-ORAZLM.LOG log file on the Oracle Database server.

  4. Manually copy the NOVELL-ZENWORKS-ORAZLM.DMP backup file that is created in Step 3 to the destination database.

  5. Run the import utility as follows as an Oracle database user on the destination database to import the data and objects:

    imp zenadmin/novell@ORCL FILE=NOVELL-ZENWORKS-ORAZLM.DMP LOG=NOVELL-ZENWORKS-ORAZLM.LOG IGNORE=Y FROMUSER=ZENADMIN TOUSER=ZENADMIN

    where ORCL is the default Oracle system identifier, and novell is the default password for the zenadmin user.

    IMPORTANT:Before running the import utility, take a reliable backup of the /opt/oracle/novell/zenworks/database directory on the destination database.

    Ignore any compilation warnings that might occur during the object creation process.

  6. On the destination database, login as sysdba user, and stop and start the Oracle instance by using the following commands at the SQL prompt:

    shutdown immediate

    startup

  7. On the destination database server, stop and start the listener service by using the following commands at the SQL prompt:

    lsnrctl stop

    lsnrctl start

  8. On the ZENworks 7.3 Linux Management server, edit the /etc/opt/novell/zenworks/hibernate.cfg.xml configuration file to configure the hibernate connection properties used by the destination database server as follows:

    1. Set the connection URL to jdbc:oracle:thin:@//IP address:port/ORACLE_SID where the IP address is the address of the Oracle database server, the port is the Oracle database port, and ORACLE_SID is the Oracle system identifier.

      The default Oracle database port is 1521, and the default Oracle_SID is ORCL.

    2. Set the connection username to the Oracle database username that is used to connect to the ZENworks database. The default username is zenadmin.

    3. Set the connection password. The default password for the zenadmin user is novell.

    4. Add the following line to allow the Oracle 10g JDBC client to support data greater than 32 KB for CLOB datatypes:

      <property name="connection.SetBigStringTryClob">true</property>

  9. On the ZENworks 7.3 Linux Management server, start all the ZENworks services by using the following command:

    zlm-config --start