cancel
Showing results for 
Search instead for 
Did you mean: 

Upgrade of Landscape

Former Member
0 Kudos

Dear Expert,

We have a requirement where our client is looking for Oracle upgrade to 12c with EHP7 .  Current they are on oracle 10g and ECC 6.0 with AIX 5.3 , Kindly suggest the best approach , In my mind Best Approach is below.

  • Export of ECC 6.0 and Migrate with Latest oracle to AIX 7.1
  • ECC EHP7 Upgrade on ECC

Kindly Suggest your Opinions also.

Regards

Rableen

Accepted Solutions (1)

Accepted Solutions (1)

hariprasadsri
Explorer
0 Kudos

Hi Rubleen,

On New Hardware or on same Hardware?

If on new hardware,

Use Export/Import method.

1.Take the export of present production server with SWPM.

2.Install AIX 7.1 and Import. while importing download install Oracle 12.1 instead of 10g

3. And upgrade using SUM tool to EHP 7 (take stackfile to EHP7 and download the software).

Kindly correct me if i am wrong.

Thanks/Hari

Answers (5)

Answers (5)

Former Member
0 Kudos

@ Amerjit : Oracle 10 g will not support the AIX 7.1 ,so this procedure will not work.

@ RB : Why to do the Oracle upgrade to 11 G , why not directly export and while import only install the 12c in target system .Please correct me if i am wrong.

and do you have any SAP note number to refer for splitting the tables and also making use of parallel export/import.

Thanks

Rableen

Reagan
Advisor
Advisor
0 Kudos

>>Why to do the Oracle upgrade to 11 G , why not directly export and while import only install the 12c in target system .Please correct me if i am wrong.<<

The upgrade to 11G and OS upgrade to 7.1 was suggested if you plan to do an in-place upgrade (same machine). If you plan to set up the target system on a different machine then export/import is the right one. You can setup up the target system on AIX 7.1 and Oracle 12c

Former Member
0 Kudos

Do you have any SAP note number to refer for splitting the tables and also making use of parallel export/import.


Thanks

Rableen

Reagan
Advisor
Advisor
0 Kudos

The system copy guide has table splitting and package splitting information.

As you have an Oracle database and if you prefer to use a more efficient splitting instead of the R3ta splitting then you may check the SAP note 1043380 - Efficient Table Splitting for Oracle Databases to use the option PL/SQL based splitting.

Former Member
0 Kudos

Hello Rableen,

My apologies as I read the message too quickly and somehow read 6.1 as opposed to 7.1 .... mea culpa.

As has been well covered by Graham/Reagan/Hari, one way you could go is to do a parallel export/import using table splitting to reduce your migration downtime. Overall runtime will of course come down to your h/w resources.

Another option that could be considered would be upgrading your current AIX 5.3 to 6.1 with the required 6.1 TL for 12g. You could then upgrade your existing 10g DB to 12g, test and then mount the f/s on the 7.1 server (relink etc ), test.

The questions of course are which of the two approaches is more complex, requires the most/least effort and results in the lowest downtime. Equally, what would be the take of your systems team as they have to do the work of upgrading AIX and handle their approach if as I assume your prod is in a HACMP config.


Kindest Regards,

Amerjit

Reagan
Advisor
Advisor
0 Kudos

If the target version of AIX is 7.1 then you will need to do an export and import unless you do an Oracle upgrade to 11G on the existing system and then upgrade the AIX to 7.1 as Oracle support 11.2.0.1 and higher on AIX 7.1. 1458918 - Support for AIX 7.1

You can reduce the downtime of export/import by splitting the tables and also making use of parallel export/import.

Former Member
0 Kudos

Hello Rableen,

I don't see the absolute need to perform an export/import.

1. Install Oracle 10 on your new server with the same SBP as your source server.

2. Get your systems team to unmount the various f/s on old server and mount them on the new server.

3. Adapt your profiles that contains the old hostname.

4. Test stop/start of system.

4. Perform your Oracle upgrade to 12c (Please check 12c matrix for minimum SAP/Kernel supported versions)

5. Perform your ERP6 EHP upgrade.

You could even avoid installing Oracle on your target machine and go to step (2). All you would have to do then would be to relink Oracle ($ORACLE_HOMR/bin/relink all).

That's just my take on it.

KR,

Amerjit

Former Member
0 Kudos

Hi Frds,

Your suggestion is helpful , But what about downtime , if we are having 700 GB database , How much downtime will be required for export and import ..

Regards

Rableen

Former Member
0 Kudos

Hi Rableen,

You are going to have to perform a test export to know the answer to that.  Do a system copy from a backup and try the export with similar compute power.

Regards,

Graham

hariprasadsri
Explorer
0 Kudos

Hi Rubleen,

It depends upon your Server Performance (and parallel Jobs you have mentioned).

We have done with HP G9 Servers with 64GB of Ram and took export 6 Hours, Import 12 Hours and EHP Upgrade took 26 Hours.

300GB DB Export took 60GB (you can calculate yours)

Thanks/H

Former Member
0 Kudos

Hi Rableen,

I definitely agree that you need to export/import.  This will allow you to take advantage of the new data compression found in Oracle 11 (and 12) and should significantly decrease the size of the DB.  You will  also need to check whether there are any steps in the way of going from ECC 6 straight to EHP 7.  You may find that there are other dependencies too.

Regards,

Graham