29 March 2012

Step by Step Oracle EBS Database 10.2.0.4 Linux 32bit to linux 64 bit Migration

Migrating Oracle E-Business Suite R12 from Linux 32-bit to Linux 64-bit (Doc ID 471566.1)

Interoperability Notes Oracle EBS R12 with Oracle Database 10.2.0.4 [ID 1135955.1]

Source Node :- Linux 32bit
Upgrade 9.2.0.5 to 10.2.0.4  Apply all required patches
p4653225_11i_LINUX
p6521934_10204_Linux-x86
p6600051_10204_Linux-x86
p6880880_102000_LINUX
p7496636_10204_Linux-x86
p7497678_10204_Linux-x86

SQL> alter database backup controlfile to trace as '/oracle/mig.sql';

Shut down the original (source) database.

Target Node:-  Linux 64bit

Install Oracle software 10.2.0.1 64bit .

Install Companion 10.2.0.1 64bit

Install Patchset 10.2.0.4 64bit Pach set number is 6810189

https://updates.oracle.com/download/6810189.html

Apply additional 10.2.0.4 RDBMS patches 64bit

Apply the following patches:

For all UNIX/Linux platforms, apply RDBMS patches:

    4247037
    6084656
    6600051
    6870937
    6991626
    7014646

Copy all datafiles(dbf) file and logfile from source(32bit) to target(64bit)

Copy init.ora change the parameters and controlfile location.

[oracle@test oracle]$ sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.4.0 - Production on Thu Mar 29 06:20:30 2012

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup nomount;
ORACLE instance started.

Total System Global Area  444596224 bytes
Fixed Size                  2021440 bytes
Variable Size             134219712 bytes
Database Buffers          306184192 bytes
Redo Buffers                2170880 bytes
SQL>@/oracle/mig.sql

CREATE CONTROLFILE REUSE SET DATABASE "MUT" RESETLOGS  NOARCHIVELOG
    MAXLOGFILES 32
    MAXLOGMEMBERS 5
    MAXDATAFILES 512
    MAXINSTANCES 8
    MAXLOGHISTORY 7260
LOGFILE
  GROUP 1 (
    '/oracle/MUT/mutdata/log01a.dbf',
    '/oracle/MUT/mutdata/log01b.dbf'
  ) SIZE 10M,
  GROUP 2 (
    '/oracle/MUT/mutdata/log02a.dbf',
    '/oracle/MUT/mutdata/log02b.dbf'
  ) SIZE 10M
-- STANDBY LOGFILE

DATAFILE
  '/oracle/MUT/mutdata/system01.dbf',
  '/oracle/MUT/mutdata/system02.dbf',
  '/oracle/MUT/mutdata/system03.dbf',
  '/oracle/MUT/mutdata/system04.dbf',
  '/oracle/MUT/mutdata/system05.dbf',
  '/oracle/MUT/mutdata/ctxd01.dbf',
  '/oracle/MUT/mutdata/owad01.dbf',
  '/oracle/MUT/mutdata/a_queue02.dbf',
  '/oracle/MUT/mutdata/odm.dbf',
  '/oracle/MUT/mutdata/olap.dbf',
  '/oracle/MUT/mutdata/sysaux01.dbf',
  '/oracle/MUT/mutdata/system10.dbf',
  '/oracle/MUT/mutdata/system06.dbf',
  '/oracle/MUT/mutdata/portal01.dbf',
  '/oracle/MUT/mutdata/system07.dbf',
  '/oracle/MUT/mutdata/system09.dbf',
  '/oracle/MUT/mutdata/system08.dbf',
  '/oracle/MUT/mutdata/system11.dbf',
  '/oracle/MUT/mutdata/undo01.dbf',
  '/oracle/MUT/mutdata/a_txn_data01.dbf',
  '/oracle/MUT/mutdata/a_txn_ind01.dbf',
  '/oracle/MUT/mutdata/a_ref01.dbf',
  '/oracle/MUT/mutdata/a_int01.dbf',
  '/oracle/MUT/mutdata/a_summ01.dbf',
 '/oracle/MUT/mutdata/a_nolog01.dbf',
  '/oracle/MUT/mutdata/a_archive01.dbf',
  '/oracle/MUT/mutdata/a_queue01.dbf',
  '/oracle/MUT/mutdata/a_media01.dbf',
  '/oracle/MUT/mutdata/a_txn_data02.dbf',
  '/oracle/MUT/mutdata/a_txn_data03.dbf',
  '/oracle/MUT/mutdata/a_txn_ind02.dbf',
  '/oracle/MUT/mutdata/a_txn_ind03.dbf',
  '/oracle/MUT/mutdata/a_txn_ind04.dbf',
  '/oracle/MUT/mutdata/a_txn_ind05.dbf',
  '/oracle/MUT/mutdata/a_ref02.dbf'
CHARACTER SET UTF8
;

Control file created.

SQL> alter database open resetlogs;

Database altered.

SQL>ALTER TABLESPACE TEMP ADD TEMPFILE '/oracle/MUT/mutdata/temp01.dbf' SIZE 1100M REUSE AUTOEXTEND OFF;

Tablespace altered.
SQL>

Configure Listner.ora and tnsname.ora:-

Listner.ora:-
SID_LIST_MUT =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /oracle/MUT/mutdb/10.2.0)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = MUT)
      (ORACLE_HOME = /oracle/MUT/mutdb/10.2.0)
      (SID_NAME = MUT)
    )
  )

MUT =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = dev138.chainsys.com)(PORT = 1600))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
  )

  Tnsnames.ora:-
 
  MUT =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = dev138.chainsys.com)(PORT = 1600))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = MUT)
    )
  )

SQL> startup upgrade
ORACLE instance started.

Total System Global Area 1145044992 bytes
Fixed Size                  2089888 bytes
Variable Size             964693088 bytes
Database Buffers          163577856 bytes
Redo Buffers               14684160 bytes
Database mounted.
Database opened.
SQL>@$ORACLE_HOME/rdbms/admin/utlirp.sql
System altered.

SQL>
SQL> Rem Continue even if there are SQL errors
SQL> WHENEVER SQLERROR CONTINUE;
SQL>
SQL> Rem ===========================================================================
SQL> Rem END utlip.sql
SQL> Rem ===========================================================================
SQL>
SQL> DOC
DOC>#######################################################################
DOC>#######################################################################
DOC>   utlirp.sql completed successfully. All PL/SQL objects in the
DOC>   database have been invalidated.
DOC>
DOC>   Shut down and restart the database in normal mode and run utlrp.sql to
DOC>   recompile invalid objects.
DOC>#######################################################################
DOC>#######################################################################
DOC>#
SQL> shut   
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 1145044992 bytes
Fixed Size                  2089888 bytes
Variable Size             964693088 bytes
Database Buffers          163577856 bytes
Redo Buffers               14684160 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@test admin]$ sqlplus system/manager@MUT

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Mar 28 19:22:05 2012

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

No comments: