cancel
Showing results for 
Search instead for 
Did you mean: 

System Copy - Same DB different UNIX

Former Member
0 Kudos

Hi Gurus,

We are doing a hardware upgrade of our SAP NW7.0 system. from HPUX to Solaris UX.

We are deciding whether to do a homogeneous or heterogeneous system copy.

Based on the guide, as long is the same OS and same DB, homogeneous is possible. But what about the release versions?

Since both HP and Solaris are Unix OS, is homogeneous still possible?

Also our DB is Oracle 10g, the new DB will be Oracle 11g. homogeneous also possible for this case?

Thanks all.

Regards,

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

     It is a HETEROGENEOUS SYSTEM COPY.Homogenous system copy is NOT POSSIBLE.

Both OS & DB should be same for homogeneous system copy.  You will have to do a system export and import in your scenarios.Exported data is independent of OS as well as DB.

You can use the latest oracle version 11G in the target system.

Please let us know if you require any further information.

Thanks and Regards,

Vima

Former Member
0 Kudos

HI Vima and Deepak,

Thanks for your prompt replies. But I have a query

Solaris and HPUX and both UNIX OS, so based on that it's both are still big endian. Even that homogeneous is still not possible? I find no evidence on the SAP guides that mentioned that?

Anyone has like a link or something I can use to convince my clients on the approach?

Putting OS aside, am I right to assume Oracle 10G and 11G are architecturally different that's why homogeneous is not possible? (A workaround I can think of is to perform homogeneous 10G to 10G, then upgrade to 11G)

Thanks so much!

Former Member
0 Kudos

Hi,

During the system copy, you change either the operating system or the database system,

or both. Heterogeneous system copy is a synonym for migration.

Please refer the below link.

http://help.sap.com/saphelp_nw70/helpdata/en/a2/2f0c173a5e43d19585724239ff4de7/content.htm

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/40642346-0a01-0010-29b5-def9be06d...

Thanks and Regards,

Vimal

former_member188883
Active Contributor
0 Kudos

Hi Jansen,

Yes you are right in saying that HPUX and Solaris are both Unix as well as Big Endians. But still homogenous system copy could not done due to differences in their OS compilers. Due to these differences they need to have different set of SAP executables.

For a detailed archicture difference you may refer below link.

http://www.oracle.com/technetwork/systems/solaris-developer/hp-unix-sol-porting-guide-455659.pdf

Now coming to your approach.

1) You want to migrate from HPUX to Solaris

2) Upgrade Oracle database from 10g to 11g

Answer: You may go with System copy method using R3load where you export your database in 10g and import the same into 11g. This will save you effort and cost.

Hope this helps.

Regards,

Deepak Kori

Former Member
0 Kudos

Hi Deepak,

I was reading your documentation and it dawned on me that, while we are not able do a homogeneous system copy, how about homogenenous database system copy? From the link it seems like HPUX and Solaris can talk.

My HP system is a distributed system.

DB version aside, I understand that OS compilers of the UNIX system are different but if I were to go from HPUX Oracle 10G to Solaris Oracle 10G, it's logically possible in the database level right?

Why I'm so concern to go homogeneous is due to the amount of time we can save with the backup/restore method of the Oracle DB. My hardware migration is time-critical that's why I'm exploring this avenue. Oracle 10G to 11G upgrade can wait and can be done in the new hardware...

My approach.

- UP-UX backup db

- Solaris, install the CI first

- restore DB to Solaris.

- then do a homogeneus system copy of the db instance in Solaris.

Possible?

Thanks!

Former Member
0 Kudos

Hi,

  As far as I know, it is not possible to restore HP Oracle to Solaris Oracle . Reason is the data bit differs in each of the Operating system.

What is the size of the database??? How much downtime the company can provide?

I would strongly suggest you to go with System export/ Import method which is easier as well as safe method.

Advantages :

1. You can import it in any of the Operating system.

2. You can use the latest Oracle version in your target system.

3. Importing it in same version and upgrading it is bit time consuming.

Just think of this scenario :  If you want to go with your suggestion, You have to do three things .1. install CI,2,restore the DB 3. then upgrade the oracle 10G to 11.

Myself & Deepaks suggestions -> just take export and import which WILL BE LESS time consumption than your suggestions.

Please let us know if you require any further information.

Thanks and Regards,

Vimal

former_member188883
Active Contributor
0 Kudos

Hi Jansen,

Hope my previous response was useful to you. Now coming back to your approach

My approach.

- UP-UX backup db

- Solaris, install the CI first

- restore DB to Solaris.

- then do a homogeneus system copy of the db instance in Solaris.

Possible?

Answer: This is not possible. You may physically backup the files on the HPUX OS and restore the same on Solaris OS. But the underlying database software/binaries on respective platform is different.  Oracle s/w running on HPUX is not the same like Oracle s/w running on Solaris platform. For each unix flavour HPUX, AIX, Solari, RHEL Oracle binaries are different.

Due to this difference it becomes difficult for the underlying s/w to identify the datafiles which you will copy in your approach.

The only best option which you have is to perform export/import. You may keep the database same viz 10g while doing this or you may keep a higher database s/w version 11g on Solaris env. In this approach we create a dump file which is independent of OS and database. It is dependent only only on the SAP release of source system.

Hope this answers your query.

Regards,

Deepak Kori

JPReyes
Active Contributor
0 Kudos

Deepak is absolutely right... You need to perform a Heterogeneous System Copy.

To add to that the migration has to be performed by a OS/DB Migration Certified Consultant, otherwise SAP will not provide support.

Regards, Juan

Answers (1)

Answers (1)

former_member188883
Active Contributor
0 Kudos

Hi Jansen,

Based on your scenario you need to perform Heterogenous system copy using R3load method.

Here you export your source database using sapinst

Import this database into your target landscape.

Perform post migration steps.

Regards,

Deepak Kori