Installation guide

MAXINSTANCES 1

MAXLOGHISTORY 112

LOGFILE GROUP 1 '/lnx_x86-64_path/oradata/eegp22/redo01.log'size 25M,

GROUP 2 '/lnx_x86-64_path/oradata/eegp22/redo02.log'size 25M

DATAFILE '/lnx_x86-64_path/oradata/eegp22/system01.dbf',

'/lnx_x86-64_path/eegp22/sysaux01.dbf',

'/lnx_x86-64_path/eegp22/users01.dbf',

'/lnx_x86-64_path/eegp22/undotbs01.dbf'

CHARACTER SET WE8DEC

ALTER DATABASE OPEN ;

8. To change the word size of the release, run the following commands:

SQL> STARTUP UPGRADE;

SQL> @$ORACLE_HOME/rdbms/admin/utlirp.sql

9. Run the utlrp.sql script to recompile all PL/SQL packages now instead of

when the packages are accessed for the first time. This step is optional but

recommended.

SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql

10. Perform a clean shutdown of the database.

SQL> SHUTDOWN IMMEDIATE

11. Take a complete backup of the database.

5.10.2 Migrating Oracle RAC Database from Linux x86 to Linux x86-64

To migrate Oracle RAC 10g release 2 from Linux x86 to Linux x86-64, complete

the following procedure:

1. Complete steps 1 to 5 of the "Migrating Single Instance Database from Linux

x86 to Linux x86-64" section.

2. Use the following command to ensure that gsd is running:

$ ps -elf | grep gsd

3. Use the $ORACLE_HOME/bin/srvctl utility to add the database name and

the cluster node names in Linux x86-64. To create a database, use a command

similar to the following command:

$ srvctl add database -d 10gdb -o ORACLE_HOME -m us.oracle.com \-s

/dev/raw/raw2

Note: In the preceding example, the path value changes as per the

system.