Migration from Oracle 9ion Red Hat 2.1 Advanced Server to Oracle 9ion Red Hat Enterprise Linux (RHEL) 3.0
The purpose of this document is to provide a procedure for migrating a system running Oracle 9iTM with 9.2.0.4 patch on Red Hat®2.1 Advanced Server to RHEL3.0 while keeping the Oracle 9iTMdata intact.
Assumptions
This document makes the following assumptions.
- All the systems in the clusterare running RedHat Advanced Server 2.1 and Oracle 9i with 9.2.0.4 patch set installed.
- The quorum,srvm and data files are on an Oracle Cluster File System (OCFS) residing on the shared storage.
- The systems in the cluster are compatible with the software and hardware configuration as described in the “Oracle 9i Database – Linux Deployment Guide Version 3.0” document. This document can be obtained at the Dell Support website at
Requirements
During the migration the following CDs and documentswill be required.
- Oracle 9i Database – Linux Deployment Guide Version 3.0
- Oracle 9i Database – Linux Deployment CD-1 and CD-2
- 4 CDs of RHEL 3.0with latest Quarterly Update
- 3 CDs of Oracle 9i Database Patchset 9.2.0.4
Migration Path
Migration will be performed in the following 6 steps.
Step 1: Shutting down Oracle Instances, database and shared storage
Before migration, perform the following steps. Login as user oracle and perform the following steps on each node of the cluster.
I.Shutdown Oracle instances: From one node type the following command.
[oracle@node1 oracle]$ srvctl stop database –d <dbsid> (dbsid = database SID)
II.Shutdown gsdctl : On each node type the following command.
[oracle@nodeN oracle]$ gsdctl stop
Delete extra spaces here.
III.Stop oracm : On each node login as user root and type the following command.
[root@nodeN root]$ killall -9 oracm
Step 2: Backing up Oracle configuration directories
Create a backup of required directories on all the nodes of the cluster and keep them in a safe location from which they can be restored once the system is re-installed with RHEL 3 and Oracle 9i. Create a directory called orabackup on the safe location.Login as useroracle and create a directory called nodeN (N = node number) in the home directory.
[oracle@node1 oracle]$ mkdir $HOME/node1
[oracle@node1 oracle]$ cd $HOME/node1
[oracle@node1 oracle]$ mkdir admin dbs trace audit oratab
Note: In addition to the above directories, if the redo and archive logs are stored on the local disk of the node create one more directory called redo for backing them up.
[oracle@node1 oracle]$ mkdir redo
Now backup the files as follows.
[oracle@nodeN oracle]$ cd $HOME/nodeN (N = Node Number)
[oracle@nodeN oracle]$ cp –fr $ORACLE_HOME/network/admin/* admin/
[oracle@nodeN oracle]$ cp –fr $ORACLE_HOME/dbs/* dbs/
[oracle@nodeN oracle]$ cp –fr $ORACLE_BASE/admin/* trace/
[oracle@nodeN oracle]$ cp –fr $ORACLE_HOME/rdbms/audit/* audit/
[oracle@nodeN oracle]$ cp –f /etc/oratab oratab/
If the redo log files are also needed to be backed up please do the following in addition to the above commands.
[oracle@nodeN oracle]$ cp –fr /path_to_redo_logs/* redo/
Perform the same steps on all the nodes of the cluster and copy the nodeN directories from all the nodes to orabackup using any convenient file transfer mechanism.For example if you are using scp for file transfer the command should be
[oracle@nodeN oracle]$ scp –p -r $HOME/nodeN user@host:/safelocation/orabackup
At the end of this operation the directory structure of the orabackup directory should look like as shown below.
Step 3: Backing up data files
IMPORTANT:The datafiles from the existing databases are stored on the shared storagedrivein OCFS volumes. So make sure to disconnect the shared storage while installing RHEL3 and keep the datafiles safe.
Step 4: Re-install all the nodes in the system with RHEL 3.0 and Oracle 9i
- For re-installing the system with RHEL 3 and Oracle 9i and Oracle 9.2.0.4 patchset please follow the step by step procedure as described in the document “Oracle 9i Database – Linux Deployment Guide Version 3.0”. This document can be obtained at the Dell Support website at
Omit the following steps from the deployment guide during installation of Oracle 9i.
I.Creating partitions on the shared storage, as altering the existing partitionson the shared storage will cause in data loss.
II.Creating the srvm config file (dd if=/dev/zero of=/mountpoint/srvm.dbf)
III.Initializing the srvm configuration file (srvconfig –init)
During installation of Oracleuse the old srvm.dbf file on the shared storage drive(?). The configuration files in Oracle use the hostnames, so make sure to retain host names as it was in the previous Red Hat installation.Mount the OCFS volumes at the same mount point as done in the previous Red Hat / Oracle installation.Add the entries to the /etc/fstab files for mounting them permanently during system reboots.
Step 5:Restoring the backed up files
After the installation is over, login as user oracle and copy the respective directory named nodeN from the safe location to the respective node in the home directory. This means copy the directory node1 from the safe location to the /home/oracle on node1. Now go to the directory node1 and perform the following steps.
[oracle@node1 oracle]$ gsdctl stop
[oracle@node1 oracle]$ lsnrctl stop
[oracle@node1 oracle]$ cd node1
[oracle@node1 oracle]$ cp –r admin/* $ORACLE_HOME/network/admin/
[oracle@node1 oracle]$ cp –r dbs/* $ORACLE_HOME/dbs/
[oracle@node1 oracle]$ cp –r trace/* $ORACLE_BASE/admin/
[oracle@node1 oracle]$ cp –r audit/* $ORACLE_HOME/rdbms/audit/
[oracle@node1 oracle]$ cat oratab/oratab > /etc/oratab
[oracle@node1 oracle]$ cp –r redo/* /path_for_redo_logs/
Continue the same set of steps on all nodes of the cluster.
Step 6:Starting up the database
After restoring the files on each node of the clusterperform the following steps on each and every node.
[oracle@node1 oracle]$ gsdctl start
[oracle@node1 oracle]$ lsnrctl start
Now the system is ready to run Oracle 9i. Run dbca and the previously created databases should show up as existingdatabases.
THIS INFOBYTE IS FOR INFORMATIONAL PURPOSES ONLY, AND MAY CONTAIN TYPOGRAPHICAL ERRORS AND TECHNICAL INACCURACIES. THE CONTENT IS PROVIDED AS IS, WITHOUT EXPRESS OR IMPLIED WARRANTIES OF ANY KIND.
Dell and the Dell Logo are trademarks of Dell Inc. Oracle and Oracle9i are trademarks of Oracle Corporation. RedHat is a registered trademark of Red Hat, Inc. Linux is a registered trademark of Linus Torvalds. Other trademarks and trade names may be used in this document to refer to either the entities claiming the marks of their products. Dell disclaims proprietary interest in these marks and names of others.
© Copyright 2004 Dell Inc. All rights reserved. Reproduction or translation of any part of this work beyond what is permitted by U.S. copyright laws without the written permission of Dell Inc. is unlawful and strictly forbidden. For more information contact Dell.
REVISION 1.0, DATE May 2004
DELL Proprietary & Confidential