OS DB Migration

Pre Export Process In Application level:-

o Check the Java JRE version (Min 1.4.1).
o Check the QCM table entries of SAP.
o Check for cancelled and update task
o Delete table entries from TATGPC, TATGPCA
o Check the incremental table conversion
o Cancel all released jobs
o Check for the operation modes
o Delete unnecessary spool data
o De-schedule all SAP jobs
o Delete all the batch jobs
o Release all repairs and correction and transports
o delete background input logs
o Delete job logs
o Delete the tRFC
o Check for the code pages installed
o Check the DDIC password for 000 client

Pre Export Process In OS level:-

o Deschedule all OS DB backups
o Shutdown all external interface
o The source should have minimum SP3

Pre Export Process In DB level:-

o Update DB statistics
o Change the DB to no archive log mode

Steps to Start the DB export

o Enter the system as adm
o Create to directory in the source system eg, Export, Install
o Check for the PSAPTEMP, the size should be 2 times the largest index
o Start the R3setup.bat program from the kernel CD (use the 45B_EXT kernel cd for the migration as the target system is AIX 5.3, always check the PAM before using the kernel cd.)
o Edit the DBEXPORT.R3S file and skip the update of statistics as it is already done and update statistics of R3SETUP is high time consuming. It can even run for days for a DB size more than 1 TB
o Edit the DBEXPORT.R3S to stop for splitter
o Start the export
o The export stops at the given breakpoint for the splitter
o Split the STR files generated
o Repeat the export process


Import process

o Check the Java version ( Minimum JRE version 1.4.1 )
o Check all necessary drives and filesystems. ( #mkdir /oracle/client/92x_64, # cd /oracle/stage, #mkdir 920_64 )
o Create to directory eg, Install, Import
o From install directory run instool.sh of Ext. kernel cd for AIX.
o set environment.
#csh
#setenv LIBPATH /sapmnt//exe:/oracle//920_64/lib.
o Install the central instances. R3SETUP –f CENTRAL.R3S
o In the next installation process choose “Exit”
o Install Oracle software as per WAS640 guide with ora user.
o After the oracle installation is done repeat the installation of the R3SETUP
o The R3SETUP stops for Migration key check phase
o Create the tablespaces of the required sizes
o Restart the database in no archive log mode
o Start the import process
o Complete the post installation steps from the migration guide of 45 B


Some of the problems faced with the above mentioned source and target system

1. During the export phase after the STR files are created the export stops with an error saying
“Cannot connect to DB”

Solution: Delete the following R3load, R3szchk, R3ldctl from the Instal directory.

2. Use update of DB statistics by sapdba or brtools. Avoid using the update of statistics by the export
Process

Solution: Edit the DBEXPORT.R3S file and delete the lines DBCOMPUTESTAT4MIG_XT*,
DBCOMPUTESTAT4MIG*, BRCONNECTEXPSTAT*

3. Export takes a huge time

Solution: Use the java based package splitter to split the STR files for the export.

4. Export fails complaining the PSAPTEMP size is small.

Solution: Check the size of the PSAPTEMP before export. It should be atleast 2 times the size of the largest index for R/3.

5. During the import process check the aio settings in the OS level.

Solution: We have used the mix server of 512 and max server of 1024 during the import process

6. The import process fails due to lack of space to extend the extent at PSAPROLL

Solution: Try using the PSAPUNDO in place of PSAPROLL

7. The total system downtime could be reduced if MIGMON was used. The firewall rule prevented
from the use of migmon between the source and the target.


Post Installation jobs for BASIS area

1. Replace the disp+work of the kernel.
2. Delete the table entries as mentioned in the Heterogeneous system copy guide of 45B
3. Edit the RFC destination address of other connected system.
4. Change the printer definition of the target. Test all the printers are working or we need to make changes in the settings.
5. Set up the TMS
6. Check for the ALE and IDOCS flow after the new system is up
7. Schedule all the basic BASIS background jobs.
8. Take a full offline backup


Reason for moving to Oracle 9.2.0.7

9.2.0.4 being the first stable release of R/3 had many bugs which are listed in the SAP and Oracle sites were later removed in later subsequent releases.

This oracle will be upgraded to Oracle 10.2.0.2 and for the upgrade the source should be at oracle 9.2.0.7 before it can be upgraded to 10g.

As we go higher up in the in the Optimizer gets improved hence the execution plans are improved and this results is transactions executing faster

Using of the Package splitter

The java based package splitter can be used to split the STR files
• Open new terminal preparation for splitter tool.
• Edit packet_splitter_end.properties file
• Use splitter guide for clarification.
• setenv JAVA_HOME /usr/opt/java141.
• using adm user, start split process.