3.4 Migrating the Data from an Oracle 9i R2 Database to an Oracle 10g R2 Database

ZENworks 7.2 Linux Managementwith IR2 Hot Patch 2 allows you to migrate the data froman Oracle 9i R2 database to an Oracle 10g R2 database.

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.

IMPORTANT:You cannot migrate the data from a PostgreSQL database to an Oracle 10g R2 database.

To migrate the data from an Oracle 9i R2 database to an Oracle 10g R2 database:

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 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.2 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-ORA9ZLM72.DMP LOG=NOVELL-ZENWORKS-ORA9ZLM72.LOG OWNER=ZENADMIN

    where ORCL is the default Oracle system identifier.

    This creates the NOVELL-ZENWORKS-ORA9ZLM72.DMP backup file and the ZENWORKS-ORA9ZLM72.LOG log file on the Oracle 9i R2 database .

  4. Manually copy the NOVELL-ZENWORKS-ORA9ZLM72.DMP backup file from the Oracle 9i R2 database to the destination database.

  5. On the Oracle 10g R2 database, run the import utility as follows as an Oracle user to import the data and objects from the Oracle 9i R2 database:

    imp zenadmin/novell@ORCL FILE=NOVELL-ZENWORKS-ORA9ZLM72.DMP LOG=NOVELL-ZENWORKS-ORA10ZLM72.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.2 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.2 Linux Management server, start all the ZENworks services by using the following command:

    zlm-config --start