Apr 16, 2018 at 04:33 PM

Migration from Oracle 11.2.0.4 (SI/FS) to Oracle 12.2.0.1 (Oracle RAC using ASM)

634 Views

Hi

Our customer is looking to migrate their SAP systems currently running Oracle 11.2.0.4 SI/FS databases installed on SerivceGuard packages (platform Linux RHEL 6.9) to Oracle 12.2.0.1 on Oracle RAC using ASM (Linux RHEL 7.x).

We were considering the below two approaches before we were made aware of the target environment using Oracle RAC with ASM.

1.Upgrade Oracle to 12c on source servers, install SAP installations on target servers with Oracle 12c and then migrate to target servers via sys copy.
Or
2.Install SAP installations on target servers with Oracle 12c and then migrate to target servers using db independent tools for copy (export/import tools)

The move to Oracle RAC seems to have complicated the migration approach and the current advice from one of our dba experts is that we will need to follow approach:

1) disable serviceguard on source

2) Upgrade Oracle 11.2.0.4 to Oracle 12.2.0.1 on source server

3) Install Oracle binaries on target server

4) Homogeneous copy to target

5) Convert to Oracle RAC

We however have some concerns over this approach due to the requirement to build a SI/FS configuration in the customer’s new environment … creating substantial additional effort for our customer.

SAP do not yet have any best practice documents available for such a move.

For those with experience or knowledge in performing migrations from Oracle SI/FS to Oracle RAC using ASM, I would very much appreciate if you could share any information and advice on how you performed such a move and maybe how we might progress in our particular migration scenario.

Thanks,

Jan