on 11-23-2015 8:55 AM
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.
Kindly Suggest your Opinions also.
Regards
Rableen
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@ 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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
>>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
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.
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.