Skip to Content
avatar image
Former Member

Dual Stack system copy problems on windows

Hello Gurus,

I recently noticed while trying to do an OS Migration that our BI Production[ ABAP+Java ]  stack is not in synch with our BI Development & BI Quality.

Before I joined , the earlier consultant had built the BI Development system as a Pure ABAP stack, Though at the DB level I can see both the ABAP and Java schemas. Also luckily / unluckily for us, the Java stack is not used at all in the BI team.

Kindly note that once the BI DEV /QA systems are in sych with  the BI Prod , we intend to perform the Dual Stack Splitting using the Dual Stack Split Tool [SWPM]  before we perform an OS Migration, so eventually we would be only doing a ABAP stack OS Migration  and since the Java stack is anyways not used, reinstall a fresh Java stack on the Migrated OS .

Here are the details for the Platform

BI Prod     -  ABAP+JAVA Stack

OS- Windows Server 2003

DB - Oracle 11.2.03 [ Upgraded 6 months back]

BI Dev     -   ABAP Stack

OS - Windows 2003

DB -  11.2.0.3

Since this particular BI  Dev system is technically incorrectly built , Would like to rebuild this correctly to simulate the Dual Stack Split.

Please suggest if I am following the right approach or alternatively suggest a new method

1.  Java Add On on existing ABAP BI  DEV system  -  May not work as the existing Java schema at the OS level may get dropped ,

Also a Java Add On to an existing ABAP system may not be the same as a BI Dual stack system.

2. Perform a BI DEV  rebuild as a dual stack system using a BI Prod Backup .-  Backup Restore from BI Prod & Java Stack Export from BI Prod.

The System copy Tool [SWPM] does not support the windows 2003 OS , as it is lets you install /create new systems only on newer OS [win 2008  / win 2012] . So I tried using the old SAP system Copy tool  - NW2004s(7.0) _Installation Master [ predecessor of SWPM], this works fine on the Windows 2003 and however this installer doesn’t recognize the Oracle 11g Oracle Home which I installed and only gives an option for the Oracle 10.2

This means we are in a sort of deadlock  - 

new  SWPM tool – doesn’t work on the old Windows 2003 OS [ after OS rebuild on SBQ]

old BI_Inst_Master tool -  Works with the OS windows 2003 , but doesn’t recognize  the Oracle 11.2  , only gives option for Oracle 10.2 .

Additionally is our Migration approach of first Splitting the Dual stack system and then only Migrating the ABAP stack and then reinstalling the Java stack on the migrated OS feasible ?

Appreciate your help and patience.

Cheers

Prashant

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Dec 04, 2014 at 05:01 PM

    Hi Prashant,

    At first glance, I think I would probably approach this in a multi-step fashion. Your end-goal is to have a consistent landscape with split ABAP and Java stacks, right? And since your current DEV system was built by system copy from PRD, it probably doesn't hurt much if you overwrite it again with a new system copy. Is that right?  If so, then:

    1. Set up three new servers (new DEV, new QAS, new PRD) with new OS, since Windows 2003 is running out of support anyway.
    2. Using backup/export of PRD as the source, use SWPM system copy to install new DEV and QAS as dual-stack systems, just like PRD. After confirming all goes well, do the same to migrate PRD onto the new PRD server. Now all of your landscape is consistent (dual-stack) and on updated OS.
    3. Use dual-stack split tool to separate Java stack from DEV, then QAS, then PRD, as you normally would and had been planning to do.

    This way you get to test the dual-stack split properly, rather than going straight for it in PRD and possibly encountering risks.

    I would not attempt to install a Java add-on to your existing DEV/QAS systems, as this would not end up looking like your dual-stack PRD system. Besides I'm not sure installing a Java add-on is a supported process anymore, anyway.

    Regards,

    Matt

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Matt Fraser

      Hi Matt,

      I agree without validations, we couldnt have confirmed our concept. Thanks for all the help.

      At the moment, since our Java stack [which was newly split off from the dual stack]  tallies with the original source BI Prod Java stack in terms of  number of objects in the schema level, so I take this as a good enough sign . The BI functional team confirms that there is indeed no usage of the Java stack, so we can safely say that the newly built Java is good too.

      Will have to wait till the Sybase migration to check if the newly installed Java only stack can integrate seamlessly into the migrated ABAP only BI stack  and we might have to select the same usage [ as AS JAVA, BI JAVA and EP CORE] to ensure Java stacks here and on the migrated DB are the same.

      But I too feel, Java migrated will un neccessarily complicate things when its actually not needed and installing a fresh Java only stack to connect to the migrated ABAP may the best course of action, but time will tell 😊

      Thanks again for all your help and time.

      Merry Christmas and a Happy New year ahead !!

      Cheers,

      Prashant

  • Dec 05, 2014 at 10:39 PM

    Hello Prashant

    As the Java stack is not used (by the BI team) then there is no point in doing a stack split. Like Matt said this not a migration. What you can do is setup the target server and install the Oracle 11G database software. Start the sapinst on the target server for the target system installation and instead of doing an export and import you can do backup and restore. During the target system creation using sapinst select the option for database specific option. There is no issue in restoring the database backup taken on Windows 2003 to Windows 2008. What matters is the Oracle version. As you have the source system on 11.2.0.3 you should install the same patch set on the target server and restore the database. To get rid of the Java stack from the database you may drop the Java schema after the restore on the target system.

    Reagan

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Reagan,

      Thanks for your helpful answer. This did cross my mind, when I first rebuilt the BI DEV on Win 2008 and saw the Java schema at the DB level, my gut instinct was to drop this schema altogether.

      While I agree with you that there is no point in doing a Dual Stack split, however we are slated to upgrade to BI 7.4  in Jan and we don't want to miss out on features due to the lack of our Java stack, so we would like to keep the stack , however we'd like to keep it as an isolated stack not directly affecting our BI ABAP stack.

      And thanks for the approach regarding the system copy via Backup/restore on Win 2008. It worked like a charm like Matt and you suggested.

      Thanks a lot for helping out.

      Cheers

      Prashant