This post is to help DBA’s migrate the application from Windows 2003 32 bit to Windows 2008 R2 64 bit

Prepare your new Windows 2008R2 environment.

Install the below softwares required as a pre-req to run Oracle EBS on Windows 2008 R2

    • Visual Studio 2008.Install Visual Studio from the CD/DVD and make sure there is no space in the installation directory for e.g D:\Visual Studio this will give issues while installing or configuring Oracle EBS, instead make the path as D:\VS2008
    • Cyvgwin (www.cygwin.com). Install Cygwin under a directory, name it as cygwin for e.g D:\cygwin
    • Copy GNUMAKE from patch 5897842
    • User either local or domain account who has admin privileges on the server
    • Apply below listed patches on the source environment i.e Application running on Windows 2003
      1. R12.TXK.delta.3 (8919489) or later
      2. Oracle Applications R12.1 Techstack Patch 10283021
      3. Patch 11071569 to address an AD script issue with Windows Server 2008 R2
      4. Patch 9902749
Note:For this migration, users must use the latest 12.1 Rapid Clone rollup patch (9171651:R12.OAM.B or later).
  • Migrating the Database
    1. Shutdown the Source Database
    2. Install Oracle software on the target server. Oracle version should be the same as source , instead of 32 bit it should be 64 bit. for e.g : Source : 11.2.0.3 (32 bit) Target : 11.2.0.3 (64 bit)
    3. Apply RDBMS patches (p4247037_112030_Generic,p6880880_112000_MSWIN-x86-64,p9858539_112030_Generic,
      p13001379_112030_Generic,p13258936_112030_Generic,p13366268_112030_Generic,p13413168_112030_MSWIN-x86-64)
    4. Copy the parameter file from source to target
db_name = THRMS
control_files = D:\APP\ORACLE\ORADATA\THRMS\CONTROL01.CTL
db_block_size = 8192
compatible = 11.2.0
_system_trig_enabled = true
o7_dictionary_accessibility = FALSE #MP
local_listener = LISTENER_THRMS
nls_territory = america
nls_date_format = DD-MON-RR
nls_numeric_characters = ".,"
nls_sort = binary # Required 11i setting
nls_comp = binary # Required 11i setting
nls_length_semantics = BYTE # Required 11i setting
diagnostic_dest = D:\app\oracle\product\11.2.0\db_1\admin\THRMS_uatdb
max_dump_file_size = 20480 # trace file size
_trace_files_public = TRUE
processes = 2000 # Max. no. of users x 2
sessions = 4000 # 2 X processes
db_files = 1024 # Max. no. of database files
dml_locks = 10000
cursor_sharing = EXACT # Required 11i settting
open_cursors = 1000 # Consumes process memory, unless using MTS.
session_cached_cursors = 500
sga_target = 1G
shared_pool_size = 400M
shared_pool_reserved_size = 40M
db_block_checking = FALSE
db_block_checksum = TRUE
log_checkpoint_timeout = 1200 # Checkpoint at least every 20 mins.
log_checkpoint_interval = 100000
log_checkpoints_to_alert = TRUE
log_buffer = 10485760
undo_management=AUTO # Required 11i setting
undo_tablespace=APPS_UNDOTS1 # Required 11i setting
workarea_size_policy=AUTO # Required 11i setting
olap_page_pool_size = 4194304
pga_aggregate_target=1G
plsql_optimize_level = 2 # Required 11i setting
plsql_code_type = INTERPRETED # Default 11i setting
utl_file_dir = c:\temp,c:\temp,D:\app\oracle\product\11.2.0\db_1\plsql\temp,D:\app\oracle\product\11.2.0\db_1\appsutil\outbound\THRMS_uatdb,c:\temp
aq_tm_processes = 1
job_queue_processes = 2
log_archive_dest_1 = 'LOCATION=D:\APP\ORACLE\ORADATA\THRMS\archive'
log_archive_format = %t_%s_%r.dbf
parallel_max_servers = 8
parallel_min_servers = 0
sec_case_sensitive_logon = FALSE
OS_AUTHENT_PREFIX=""
_TRACE_FILES_PUBLIC=FALSE
SQL92_SECURITY=TRUE
AUDIT_SYS_OPERATIONS=TRUE
_b_tree_bitmap_plans = FALSE # Required 11i setting
_like_with_bind_as_equality = TRUE
_sort_elimination_cost_ratio=5
_fast_full_scan_enabled = FALSE
optimizer_secure_view_merging=false
_optimizer_autostats_job=false # Turning off auto statistics
  • Copy the datafiles, control file, log files  from source to target
  • Create service on the target server i.e oradim -new -sid THRMS -start_mode manual -pfile  D:\app\oracle\product\11.2.0\db_1\database\initTHRMS.ora
  • Start the service through services.msc
  • Create listener through netca and start the listener
SID_LIST_THRMS =
(SID_LIST =
(SID_DESC =
(SID_NAME = THRMS)
(ORACLE_HOME = D:\app\oracle\product\11.2.0\db_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:D:\app\oracle\product\11.2.0\db_1\bin\oraclr11.dll")
)
)
THRMS =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = uatdb.ods.com)(PORT = 1522))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
)
)
ADR_BASE_ERPUAT = D:\app\oracle
    •  Start the database in upgrade mode i.e startup upgrade
startup upgrade
    • Execute the script to migrate database from 32 bit to 64 bit
@utlirp.sql
  • Shutdown the database and start in normal mode to compile invalid objects
shutdown immediate
startup
@?\rdbms\admin\utlrp.sql
  • Migrate the Database to Autoconfig
  • Login to the Source Application and generate appsutil.zip by executing admkappsutil.pl located under %AD_TOP%\bin
cd %AD_TOP%\bin
perl admkappsutil.pl
  • Copy the appsutil.zip to the target database server under %ORACLE_HOME% and unzip the file.
cd %ORACLE_HOME%
unzip appsutil.zip
  • Clean the nodes by executing the below command
    sqlplus apps/apps
    exec fnd_conc_clone.setup_clean;
    commit;
    exit
  • Execute perl adbldxml.pl on the database side to generate the XML file
  • cd %ORACLE_HOME%\appsutil\bin
    perl adbldxml.pl
    adconfig.cmd contextfile=
  • Migrate Application
  • Run adpreclone.pl on the source
  •  cd %ADMIN_SCRIPTS_HOME%
    perl adpreclone.pl appsTier
  • Shutdown the application and copy the directories to Windows 2008 Server
  • cd %ADMIN_SCRIPTS_HOME%
    adstpall.cmd apps/apps
    Note: When copying the application tier files to the target machine, users must initiate the copy from the target system or there may be permissions issues in accessing the files on the target system. The user doing the copying must also be the same user performing the clone operations, and be part of the Local Administrators group on the target system.
  • Change File System Ownership
  • E:\> takeown /f E:\APPS /r
    E:\> icacls E:\APPS /grant:r :F /T
    E:\> icacls "C:\PROGRAM FILES (X86)" /SAVE ACLFILE /T
    E:\> takeown /f "C:\PROGRAM FILES (X86)" /r
    E:\> icacls "C:\PROGRAM FILES (X86)" /grant:r :F /T
  • Run adcfgclone on the target system
  • cd E:\oracle\apps\apps_st\comn\clone\bin
    perl adcfgclone.pl appsTier
  • Run Post Migration steps
  1. Relink AD executables (Use AD Relink for this step)
  2. Relink Applications programs
  3. Maintain Snapshot Information
  4. Generate message files
  5. Generate form files
  6. Generate report files
  7. Generate product JAR files
  • Finishing Tasks
  1. Update profile options
  2. Update printer settings
  3. Update Workflow configuration settings
  4. Verify APPLCSF variable setting
  5. Update the SESSION_COOKIE_DOMAIN value in ICX_PARAMETERS
  6. Re-Implement SSL and SSO configuration
Tagged with →  
Share →
0 comments
Skip to toolbar