Skip to Content
avatar image
Former Member

Requirements regarding homogeneous system copy on the OS and Database level

Hello Colleagues,

I have a question regarding requirements for a homogeneous system copy on the OS and database level.

Homogeneous system copy = your target system is on the same operating system and database system as your source system

This is general accepted but what about different patchlevels or versions regarding OS and/or database for the source system and target system?

Example:

Source system:

OS: Windows Server 2003 E, 64 bit, SP1

DB: Oracle 10.1.0.2

Target system:

OS: Windows Server 2003 E, 64 bit, SP2

DB: Oracle 10.2.0.5

Is here something special to keep in mind? What is the best practice here?

Many thanks in advance!

Regards,

Jochen

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jan 13, 2012 at 11:18 PM

    Hello Jochen,

    The key criterion that defines whether a migration is homogeneous or heterogeneous is the 'binary compatibility' of the database. In your example the migration is without any doubt homogeneous. The fact that the Windows service pack is different is immaterial. Even migrating from Windows 2003 to 2005/2008 would still count as a homogeneous migration.

    However, there is a further distinction: for a homogeneous migration you can either use R3load or a "database-specific" method; the latter is typically backup/restore. Backup/restore is only possible if the database software is at the exact same release on source and target. To come back one more to your example: the migration is homogeneous but you would not be able to do a straight backup/restore because of the different Oracle versions. Your alternatives are therefore:

    (a) use R3load method (which is the same as a heterogeneous migration, only you don't need to get a certified consultant involved nor do you have to use the SAP migration check service)

    (b) upgrade the source to 10.2.0.5 and then use backup/restore

    Hope this clarifies things,

    Mark

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Ratnajit Dey

      My file shows below contents, do i need to add parameters? what parameters should i use? I had also checked my original server but in that too, there are no parameters are been added

      #.******************************************************************************************************************************

      #.*                                                                                                                            *

      #.*       Instance profile ECD_DVEBMGS00_DEVECC00                                                                              *

      #.*                                                                                                                            *

      #.*       Version                 = 000002                                                                                     *

      #.*       Generated by user = DDIC                                                                                             *

      #.*       Generated on = 23.05.2012 , 04:45:31                                                                                 *

      #.*                                                                                                                            *

      #.******************************************************************************************************************************

      #parameter created                          by: DDIC         23.05.2012 04:45:22

      login/no_automatic_user_sapstar = 0

      SAPSYSTEMNAME = ECD

      SAPGLOBALHOST = DEVECC00

      SAPSYSTEM = 00

      INSTANCE_NAME = DVEBMGS00

      DIR_CT_RUN = $(DIR_EXE_ROOT)\$(OS_UNICODE)\NTAMD64

      DIR_EXECUTABLE = $(DIR_INSTANCE)\exe

      rdisp/wp_no_dia = 10

      rdisp/wp_no_btc = 3

      icm/server_port_0 = PROT=HTTP,PORT=80$$

      #-----------------------------------------------------------------------

      # SAP Message Server parameters are set in the DEFAULT.PFL

      #-----------------------------------------------------------------------

      ms/server_port_0 = PROT=HTTP,PORT=81$$

      rdisp/wp_no_enq = 1

      rdisp/wp_no_vb = 1

      rdisp/wp_no_vb2 = 1

      rdisp/wp_no_spo = 1

      ssl/ssl_lib = $(DIR_EXECUTABLE)$(DIR_SEP)$(FT_DLL_PREFIX)sapcrypto$(FT_DLL)

      sec/libsapsecu = $(ssl/ssl_lib)

      ssf/ssfapi_lib = $(ssl/ssl_lib)

      login/accept_sso2_ticket = 1

      login/create_sso2_ticket = 2

  • avatar image
    Former Member
    Jan 13, 2012 at 04:23 PM

    Hi,

    You cannot do system copy between different Oracle Patch level systems.

    Both Source and Target Systems must have Same Operating System and Database System. Also Patch levels must be same.

    Refer to below link

    http://www.saptechies.com/system-copy-guides/

    Regards,

    Arjun

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 13, 2012 at 05:21 PM

    Hello Jochen,

    Homogeneous system copy means entire environment of target system should be same as source system including OS service patch and DB patch levels.

    Please go through the system copy guide available in SMP for requirements and best practices.

    Thanks,

    Siva Kumar

    Add comment
    10|10000 characters needed characters exceeded