Dual Stack BW System refresh

[Former Member]

Hi All,

We have to perform dual stack BW system refresh from production system to quality system and both are hosted on different hosts.For abap only systems generally we take online backup of production system and restor it to target and follow standard system refresh procedure.

We have followed same strategy for dual stack systems and perform same stpes as followed in abap only systems but afterwards java was not up and running.

So we planned to take export of database(ABAP+JAVA) and import it on target server.But since we cannot afford downtime for our BW production system so during export we unmark the option "STop Running System" so as to avoid downtime but our query is that since we are not stopping dual stack BW system then how the database will be in consistent state after import of database.

Also please suggest if there is any alternate best proceduere that ensures dual stack BW system refresh by ensuirng no downtime of production system.

Regards

Joy Garg

[Former Member]

Hi Joy,

It doesn't matter even if you do not select STOP RUNING SYSTEM since you are exporting only JAVA schema and it doesn't contain any data in ABAP+ JAVA stack.

So simply you can export the JAVA from Source system and then import into target system once ABAP restore is done on target system.

We followed the same procedure several times and did n't find any issues.

Regards,

Srinivas Chapa.

[Former Member]

Hi Srinivas,

Thansk for updating,

We have tried same option,our refreshed ABAP part is up and running fine now.

But for java we have taken export via sapinst and by following path:

======================================================================================================

SAP NW2004s SR2>Additional Software Life Cycle tasks>System Copy>Oracle>Source System>Central System>based on AS ABAP and Java>> After that we select java schema only and unmark Stop Running System option.

Later on during import via path

SAP NW2004s SR2>Additional Software Life Cycle tasks>System Copy>Oracle>Target System>Central System>based on AS ABAP and Java>> But during phase of Migration Depot (where it prompts for export dump) it throws error of wrong LABEL.ASC

======================================================================================================

======================================================================================================

So we planned to take again export via path SAP NW2004s SR2>Additional Software Life Cycle tasks>System Copy>Oracle>Source System>Central System>based on AS Java>>

and during import vai path

SAP NW2004s SR2>Additional Software Life Cycle tasks>System Copy>Oracle>Target System>Central System>based on AS Java>> It throws error at Migration Depot step that Import from Java only system to dual stack system is not allowed.

======================================================================================================

Please suggest.

Regards

Joy Garg

[Former Member]

Hi,

We have tried a few techniques and it works totally fine.

We restore our database using normal brrestore. Of course the Java schema is also over written. But you can export your cluster data or java specific instance data from config tool.

Once the refresh is done it takes about 30 mins to import the Java part back in, preceded by secstore maintenance to what it was before refresh and also modification of instance.properties file (replacing all production pointers to target). Only this part takes more time but with experience we have grown more proficient to it. If needed reconnect the java schema with the appropriate java schema user (sapsr3db)

THanks and Regards,

Karan Shah

[Former Member]

Hi,

always take JAVA export as ABAP+JAVA system and also Impoort it in the target system from the same path.

Export Path -SAP NW2004s SR2>Additional Software Life Cycle tasks>System Copy>Oracle>Source System>Central System>based on AS ABAP and Java>>

Import Path -SAP NW2004s SR2>Additional Software Life Cycle tasks>System Copy>Oracle>Target System>Central System>based on AS ABAP and Java>>

Can you try to import your first JAVA export i.e ABAP+JAVA once again?

What is your OS and DB ?

Also take a look on the below link .

http://www.sdn.sap.com/irj/scn/elearn?rid=/library/uuid/207ac87d-e28a-2a10-9caa-ac5d69dc9302&overrid...

-Regards,

Srinivas Chapa.

[Former Member]

Hi Srinivas,

We are trying to follow the same procedure,i have doene everything from scrap as per your recommendation but while importing and at step of entering export dump location i.e. Migration Depot screen on entering export dump location it is throwing error:

You entered: /oracle/BWT/sapdata19/export_dualstack/JAVA Found the label SAP:JMIG:700::: but need the label SAP:MIG::EXPORT(1/:😘

******************************************************************************************************************************************************

Also please note that during export, a directory pack gets created in SDM home of source system and we have not transfer any of its file to export dump:

euxc54:bwcadm 112> cd pack

euxc54:bwcadm 113> ll

total 2419644

-rw-r----- 1 bwcadm sapsys 506116963 Aug 22 13:21 packedOrigin_com.adobe.jar

-rw-r----- 1 bwcadm sapsys 727762223 Aug 22 13:20 packedOrigin_sap.com.jar

-rw-r----- 1 bwcadm sapsys 423957 Aug 22 13:21 packedSCAs.jar

-rw-r----- 1 bwcadm sapsys 4535940 Aug 22 13:21 sdmrepository.sdc

euxc54:bwcadm 114> pwd

/usr/sap/BWC/DVEBMGS01/SDM/program/pack

*******************************************************************************************************************************************************

================================================================================

Also please note that structure of export dump generated is as :

euxc54:bwcadm 115> cd /oracle/BWT/sapdata19/export_dualstack

euxc54:bwcadm 116> cd JAVA

euxc54:bwcadm 117> ll

total 48

drwxrwxr-x 5 bwcadm sapsys 96 Aug 22 13:24 APPS

drwxrwxr-x 6 bwcadm sapsys 96 Aug 22 13:07 DB

drwxrwxr-x 2 bwcadm sapsys 96 Aug 22 13:08 JDMP

-rw-rw-r-- 1 bwcadm sapsys 19 Aug 22 13:07 LABEL.ASC

-rw-rw-r-- 1 bwcadm sapsys 14 Aug 22 13:07 LABELIDX.ASC

drwxrwxr-x 2 bwcadm sapsys 96 Aug 22 13:22 SDM

-rw-rw-r-- 1 bwcadm sapsys 193 Aug 22 13:07 SOURCE.PROPERTIES

drwxrwxr-x 2 bwcadm sapsys 96 Aug 22 13:18 TOOLS

=================================================================================

Database is Oracle 10g while OS is HP UX and note that ABAP syetm on refreshed is running fine.

Please suggest.

Regards

Joy garg

Edited by: Joy Garg on Aug 22, 2011 3:53 PM

[Former Member]

Hi Karan,

Ia lso tried to export from configtool of source and export file has been created.but when trying to login to configtool of target system it is not abel to connect to DB and erro message is:

*******************************************************************************************************************************************************

ionFactory#Java#com.sap.sql_0002#com.sap.sql.log.OpenSQLResourceBundle#SQL error occurred on connection : code={0,number,integer}, state="", message="".#5#1017#72000#ORA-01017: invalid username/password; logon denied********************************************************************************************************************************************************

Please note that after ABAP system refresh we have dropped schema SAPSR3Db intentionallly,is it bcause of these,are we getting error.Although i have created user SAPSR3DB by comand create user SAPSR3DB identified by <passwd>

But even now not able to connect to DB of configtool screen.

please suggest.

regards

Joy garg

[Former Member]

Hi Joy,

Sorry of the late reply.

Could you please let us know the status of your problem?

Regards,

Srinivas Chapa.

[Former Member]

Hi Srinivas,

Finally we have followed approach of taking export of ABAP+JAVA schema(by unmarking the option "STop running System" and export has been successful.

Now we have started import part and import of packages through migration montior has also been successful.But at step "Check DDIC Password" system is throwing error.We have checked from OS level and found that application/database is ruuning fine.

R3trans -d is also showing status 0 and all work processes are in status waiting(when checked throw dpmon) but when we tried to login through SAP GUI it throws error Table or view does not exist.On checking the logs it shows following error logs:

A Tue Sep  6 13:18:10 2011
A  *GENER* request remote generation: SAPMHTTP.
A  *GENER* starting inline generation: SAPMHTTP (reason: compile error during remote generation).
A  *GENER* got lock for program SAPMHTTP.
C     OCIStmtExecute() failed with -1=OCI_ERROR
C     SQL error 942:
B  ***LOG BZA=> table D010ENH    does not exist on database R/3        [dbtran#15 @ 7580] [dbtran  7580 ]
A  TH VERBOSE LEVEL FULL

We have checked table D010ENH in source system and it is showing it as kernel view.

Please suggest.

Regards

Joy Garg

[Former Member]

what is the DDIC pwd you entered

You have to make a note of DDIC pwd of client 000 before the system restore and then you have to enter this pwd while importing the JAVA.

Regards,

Srinivas Chapa.

[Former Member]

Hi Srinivas,

I have already entered the password of DDIC of client 000(of source system) and also that of J2ee_admin user of source system that system has prompt at earlier stage but that stage has been over.Now at step 'Check DDIC password" system is doing test check in background an din the absence of gettimg logged to System it is throwing error.

Please assist.

Regards

Joy Garg

[nicholas_chang]

Hi Joy,

Besides DDIC in 000, do you have any user (eg: sap* and etc) that can access to 000 with password reset authorization? You can login to your source system (Prod) and verify. If yes, login to your refreshed system with the specific user and reset the DDIC user password.

If unfortunately you don't have any user besides DDIC, what you can do is reset sap* in sql command. Once reset, login in as sap* and reset DDIC password.

Thanks,

Nicholas Chang.

[Former Member]

Hi Nicholas,

Issue is not DDIC password,infact i already know correct DDIC password of soure system(000) but issue is that at step "Check DDIC password" sapinst has got stuck since test login of target system is getting failed in background.

Even we are not login to SAP GUI of target system although system(ABAP part till now) is running fine at OS level and even in dpmon utility all wp's are in waiting status.But when tried to login thorugh SAP GUI it throws message "Table or view does not exist" On checking logs we found that tab;e or view do10enh is missing and it is kernel view as per m understanding.

Please assist.

Regards

Joy Garg

[Former Member]

Are you able to login into source system with the DDIC password?

[Former Member]

Hi Joy,

After ABAP restore have you created OPS$ user mechanism ?

Please have a look at the below note

Note 400241 - Problems with ops$ or sapr3 connect to Oracle

Regards,

Srinivas Chapa.

[Former Member]

Hi Srinivas,

I am able to login into source system in client 000 with DDIC password.

Also we have not created manually OPS$ users in target system.Although all required OPS$users are present in target system as:'

SAPSR3DB

SAPSR3

DBSNMP

OPS$SR3ADM

OPS$SAPSERVICEBWT

OPS$ORABWT

OPS$BWTADM

SYS

SYSTEM

OUTLN

TSMSYS

where BWT is target SAP System Id.

Also please note that i have again executed sapdba_role.sql,sapconn_role.sql but still issue persists.

Please assist.

Regards

Joy Garg

[nicholas_chang]

Hi Joy,

Have you try to upgrade the kernel, dbsl to latest level and test?

Also, i reckon your sapinst is incomplete and still open, and what's the error in sapinst*.log?

btw, how you perform the system refresh? earlier you said you'r using backup/restore method, i assume you open the database and continue with sapinst for the JAVA Import?

[Former Member]

Hi Nicholas,

I have already updated kernel,dbsl file to latest (to same level as that of source) but even after that no success.

Earlier i have followed approach getting the database restore and then follow standard procedure to open the database but after that on exporting java only and importing java only was not helpful as we were getting issue.

SO i follow the appoach of taking export of ABAP+JAVA and then import it thorugh sapinst(using migration montior tool).

Please find below the logs of sapinst.log file that gets stuck at step 'Check DDIC Password'

INFO 2011-09-01 12:17:25
RFC parameter CLIENT set to value 000.

INFO 2011-09-01 12:17:25
RFC parameter USER set to value DDIC.

INFO 2011-09-01 12:17:25
RFC parameter LCHECK set to value 1.

INFO 2011-09-01 12:17:25
RFC parameter PCS set to value 1.

INFO 2011-09-01 12:17:25
RFC parameter LANG set to value EN.

INFO 2011-09-01 12:17:25
RFC parameter ASHOST set to value euxc54.

INFO 2011-09-01 12:17:25
RFC parameter SYSNR set to value 11.

INFO 2011-09-01 12:17:25
RFC connection information checked successfully.

WARNING[E] 2011-09-01 12:17:25
FRF-00007  Unable to open RFC connection.

Please assist.

Regards

Joy Garg

[Former Member]

first check the owner of the SAPUSER table..I guess SAPUSER table owner is not changed

SELECT OWNER FROM DBA_TABLES WHERE TABLE_NAME = 'SAPUSER';

If the system returns an owner <owner> other than OPS$<sid>ADM, you must delete the relevant SAPUSER tables:

DROP TABLE "<owner>".SAPUSER;

If the system does not return OPS$<sid>ADM, you must create the table SAPUSER as <sid>adm and enter the password:

CREATE TABLE "OPS$<sid>ADM".SAPUSER

(USERID VARCHAR2(256), PASSWD VARCHAR2(256));

Also make susre you are entering the correct password of <sapowner> into SAPUSER table.

Regards,

Srinivas Chapa.

Edited by: Srinivasa Rao Chapa on Sep 12, 2011 5:59 PM

[Former Member]

Joy,

Let us know if you get struck somewhere

-Srini Chapa

[Former Member]

Hello

We generally export and import the java part where as for ABAP part we use the standard method of restoring the database backup of production.

Regards

Vivek

[sunny_pahuja2]

Hi,

As per my personnel experience, what I used to do is, I take Java export some point of time and use to import the same old export whenever we do the system refresh. I have not seen any inconsistency yet because generally there are not much changes on the java part unless and until you do some patching activity or some parameter changes etc.

Thanks

Sunny

[Former Member]

Hi,

I have not done it myself but I know that my collegues use a dual method for a dual stack BW system copy.

They export and reimport the java database schema and they backup/restore the database for the abap stack.

As the Java database schema is much smaller than the abap one, this method is much faster that a full export/reimport method.

Regards,

Olivier