Question Re: System copy for ABAP+JAVA system using SAPINST method in Technology Q&A

System copy for ABAP+JAVA system using SAPINST method

Former Member — Thu, 02 Aug 2007 05:59:36 GMT

Dear support,

We have recently upgraded to ECC 6.0 system and we have been still doing system copy by using backup and restore method. I know its wrong.

which involves below steps , this old methos works fine for ABAP engine and evreything looks ok.But java engine will not work.

So we need to use SAPINST method as described in note 785848 and system copy guide available on OSS. But i am really not able to understand sequence

for tasks to be carried out in this SAPINST method.

Can anybody list few sequence along with step by step procedure as i mentioned below for old system copy procedure.

Is it really difficult to make that for SAPINST as everybody says refer to standard guide and note ?

Anybody if possible can make the same way as i did below , i think it would rather be small as far as my understanding after reading those docs.

Simple old system copy procedure works for ABAP is as:

Run the following command on source system.

a. Login as <sid>adm

b. svrmgrl

c. connect internal

d. alter database backup controlfile to trace;

e. exit;

f. Above command will generate a .trc file in /oracle/P01/saptrance/usertrace directory.

g. Copy the text from CREATE CONTROLFILE until the ( and paste it in to any new .sql or controlfile.sql file.

h. Copy the controlfile.sql to target system.

i. Edit the file and replace the entire source SID to target SID.

j. Edit the reuse database command with the set database command

Copy the aft generated during the backup file from the source system to target system. (/oracle/<SID>/sapbackup)

a. Change all the source <SID> to target <SID>.

b. Only don't change the backup volume name it must be target system <SID>.

c. Copy the above aft file name line from the source back<SID>.log to target<SID>.log file.

5. Shutdown the target server instance.

6. From this onwards all the command on the target system only.

a. Login as <SID>adm

b. run the SAPDBA

c. select J (Restore/Recovery)

d. select B (Full restore and recovery)

e. select A (Select backup of type)

f. Select the offline backup which you want to restore.

g. It will take some time to restore.

h. Once the database is restored login as <SID>adm and run the

i. svrmgrl

j. connect internal;

k. startup nomount (if the database is already mounted shutdown it using the shutdown command)

l. run the following command

m. @controlfile.sql (file name of the control file contains the CREATE CONTROLFILE statement)

n. After the run the above command it should give the "Statement Processed)

o. alter database open resetlogs.

I am really looking forward to see anybody take some time out to prepare this kind of step by step procedure.

It would be of greate help for all of us for performing system copy with sapinst method.

Looking forward for your support.

Best Regards,

AjitR

Re: System copy for ABAP+JAVA system using SAPINST method

Former Member — Thu, 02 Aug 2007 07:40:59 GMT

below sequence is not supported and out-of-date since a longer time.

the acutality starts with svrmgrl.

this tools is no longer existing since Oracle9.

sapdba is no longer existing (at least not on version where SAP supports J2EE stack).

>>But i am really not able to understand sequence

>>for tasks to be carried out in this SAPINST method.

it is not necessary to understand them, but to use them.

by the way: it is not possible to copy a J2EE instance by just copying the database.

regards

Peter

Re: System copy for ABAP+JAVA system using SAPINST method

Former Member — Thu, 02 Aug 2007 08:07:34 GMT

Peter,

I have discussed with you earlier about this topic and got feedback from you.

My point in this post is forget about i used svrmgrl instead sqlplus.

I have made this step by step procedure for understanding old system copy procedure in single glance.May be some of contents from 8i which i can modify if anybody want.

My question is i need same kind of steps in 10 to 20 lines about SAPINST procedure

for example:

1) Run sapinst.exe and select system copy

export abap+java

then...............

Could you please prepare the same.

If possible as we have never done system copy using this SAPINST method and we are now supposed to do for our production

I just need steps , i have already read guide but unable to get exact steps

Re: System copy for ABAP+JAVA system using SAPINST method

Former Member — Mon, 06 Aug 2007 10:31:20 GMT

Peter,

Since nobody has answered my question i have prepared demo document for neweaver system copy ABAP+JAVA using SAPINST method

Can anybody suggess changes or mistakes in same please ?

Please let me know in detail as we are supposed to do it in production.

We have netweaver 2004s ABAP + JAVA system and this is central system on windows 2003 platform and Oracle 10.2.

Now we have to perform system copy from this server to another server which is of same release and platform and we would like to do with SAPINST method.

Now procedure suggested by us is as following,

On Source system ,

Stop SAP system and let database be running.

We have installation master DVD from where we need to start SAPINST.exe and then

Welcome screen ->Netweaver 2004s -> choose Additional Software Life-Cycle Tasks® System Copy® Oracle® Source Systemà Export preparation

Continue with follwup activities

Best Regards,

AjitR

Re: System copy for ABAP+JAVA system using SAPINST method

Former Member — Tue, 07 Aug 2007 06:52:58 GMT

Hello Ajeet,

i want to perform sytem copy for SAP Solution Manager 4.0 through sapinst which is ABAP+ JAVA based . as u hv mentioned here the procedure u must hv done tat by now, if u hv prepared such simple 12 lines procedure with mentioned steps ,it shall be gr8 help if u can share this with me as i also went through the guide and its confusing. My Email id is reachme.saumya@gmail.com .

Regards,

Somya

Re: System copy for ABAP+JAVA system using SAPINST method

Former Member — Tue, 07 Aug 2007 10:06:04 GMT

Hi,

As per the guide you need to do source system Technical Preparations, in that running the export preparation is also one. You need to run this first before you start the export, if and only if export will successful if preparation is successful.

Yes you need to create the export directory to take the export copy of source system, it may be any where in your server. It should be having 6 to 8 GB free space.No need to create the export directory in target system, after export is completed in the source system you copy the export directory to the target system.

Target system

Yes you need to take the back up file system and delete all the contents of the directory.

Yes it can be considered as fresh system installation but copy of source system.

Yes the process follows after you giving the export directory path .

Next screen you will get the database drop and recreate screen chouse the drop and recreate method

Next J2EE user name and password

Next DDIC password

Next you have to give kernel and oracle client dvd path

Next Parameter checking screen here if you are selected database drop and recreate you have to revise the oracle database system option

If you are selecting review next screen is database advance option you have to select the advanced option

Next you have to select following option to recreate

1 Sapdata directory mapping

2 Database instance file system

3 Create database parameter

4 Create tablespace

Next screen sapdata directory creating

Next screen you can just click next no need to change any setting

Next table creation

Next screen specify oracle instance directories

Next again parameter checking and last this is last screen

Next will be the execution screen

Reward points if usefull

Re: System copy for ABAP+JAVA system using SAPINST method

Former Member — Tue, 07 Aug 2007 10:43:50 GMT

Hello Rakesh,

Can u revert me the solution to the case which i hv referred , my source system and target system are same ,how shld i proceed ...................

Thanks,

Saumya

Re: System copy for ABAP+JAVA system using SAPINST method

Former Member — Tue, 07 Aug 2007 10:57:52 GMT

Hi,

Procedure is same for your solution manager also, even if the source system and the target system is same. Only thing is it should be in different system means system name should different.

Re: System copy for ABAP+JAVA system using SAPINST method

Former Member — Tue, 07 Aug 2007 11:06:14 GMT

Hello ,

Can u give me step wise procedure consisting of 12-20 lines for the same ,it shall be helpful really. Bcoz my source and target system are same ,do i need to scrap off the application after export and before import so tat i can install new central instance / the saystem has to be left as it is . Curretly my system is running fine and how to change SID during this system copy?So if u could give me step wise procedure consisting of 12-20 lines for the same ,it shall be helpful really>

requested to revert at earliest. points guaranteed.

Regards,

Somya

Re: System copy for ABAP+JAVA system using SAPINST method

Former Member — Tue, 07 Aug 2007 16:43:51 GMT

Rakesh,

Thanks for excellent reply , i will go as per your steps.But even Somya is saying is right and valid point ? in this entire procedure on the target system where is the step to change SID ? Is it after deleting all existing datafiles start SAPINST and then select new SID after giving path to Export dir which we have copied from source system ? and then proceed with installation ? Sorry to trouble you more but i didnt find step where we change SID ...

Expecting your early reply..

Best Regards,

AjitR

Re: System copy for ABAP+JAVA system using SAPINST method

Former Member — Wed, 08 Aug 2007 08:13:51 GMT

Hello Ajeet,

Can u give me a step wise step procedure of 15 - 20 steps giving steps of system copy in detail which wll help in understanding the procedure . My Email id is reachme.saumya@gmail.com . Points guaranteed.Also revert to the queries mentioned in the message plz

Regards,

Somya

Re: System copy for ABAP+JAVA system using SAPINST method

Former Member — Wed, 08 Aug 2007 09:48:41 GMT

Somya

let us collect info or update from rakesh and then i will prepare doc and forward to u

Re: System copy for ABAP+JAVA system using SAPINST method

Former Member — Wed, 08 Aug 2007 10:02:45 GMT

Hello Ajit,

Requested to prepare the document urgently as i need it badly,when can u send it to me. plz also give me ur Email iD.

regards,

Somya

Re: System copy for ABAP+JAVA system using SAPINST method

Former Member — Wed, 08 Aug 2007 16:01:44 GMT

so do i ? also need it urgently as i am going to perform for my production but instead of giving u wrong document i prefer giving correct one.

Rakesh,

We are still waiting just for your small input.

Could you let us know at earliest about SID change option in SAPINST?

Re: System copy for ABAP+JAVA system using SAPINST method

Former Member — Wed, 08 Aug 2007 17:52:30 GMT

By the way Somya, you cannot give out points if you are not the person who started the topic!

Re: System copy for ABAP+JAVA system using SAPINST method

Former Member — Thu, 09 Aug 2007 07:27:25 GMT

Hi,

Their is no option comes asking target system id.Once you start the installation It will ask system to be enter then you can give your target system id.

Reward the points if useful

Re: System copy for ABAP+JAVA system using SAPINST method

Former Member — Thu, 09 Aug 2007 07:36:56 GMT

Rakesh,

please confirm that means on target system:

run SAPINST.exe and Welcome screen ->Netweaver 2004s -> choose Additional Software Life-Cycle Tasks~~>System Cop~~> Oracle~~> Target systemà~~>central system based on ABAP and JAVA

Then just enter SID as target SID for which we have deleted all datafiles.So installation will proceed..

Right?

Re: System copy for ABAP+JAVA system using SAPINST method

Former Member — Thu, 09 Aug 2007 07:43:54 GMT

Hi,

run SAPINST.exe and Welcome screen ->Netweaver 2004s -> choose Additional Software Life-Cycle Tasks~~>System Cop~~> Oracle~~> Target system~~>central system based on ABAP and JAVA.

Next select Typical

Next give the location of java comp DVD.

Next give the SID as target sid

installation will proceed.........

Reward the points if useful

Re: System copy for ABAP+JAVA system using SAPINST method

Former Member — Fri, 10 Aug 2007 02:36:39 GMT

I am performing this task as per Rakesh's feedback this weekend for our Production database , downtime is already planned , I will get back to all of you once finished successfully.

Re: System copy for ABAP+JAVA system using SAPINST method

Former Member — Sat, 11 Aug 2007 07:51:42 GMT

Rakesh,

please go through tasks i performed and let me know where i went wrong .

I have successfully completed Export preparation on source system and then entire export successfully finished and created in Export directory.

I have copied this Export directory to Target system.

Now on fresh target system I have installed Oracle database 10G software and rest of the prerequisites for installation.

Then I have executed SAPINST.exe

Welcome screen ->Netweaver 2004s -> choose Additional Software Life-Cycle Tasks~~>System Cop~~> Oracle~~> Target system~~>central system based on ABAP and JAVA.

Given Target SID ,

All java comp CDs and JCE policy path correctly ,

System copy method : standard system copy method

Migration export : Given the path to Export directory copied to Target system

IF I AM CORRECT TILL THIS STEP THEN PLEASE LET ME KNOW DO THE DIRECTORIES SHOULD BE SAME NAME LIKE 😧 , E: AND F: AS PER SOURCE SYSTEM ?

Now I am getting error as below,

ERROR 2007-08-11 13:03:12

CJS-30129 Creating node $(DIR_TRANS) with type DIRECTORY failed. Original exception text was: syslib.filesystem.nodeCreationFailed:Unable to create node
ispat\sapmnt\ with type DIRECTORY: can't create parent node..

ERROR 2007-08-11 13:03:12

FCO-00011 The step createSystemDirectories with step key |NW_Doublestack_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_System|ind|ind|ind|ind|5|0|createSystemDirectories was executed with status ERROR .

NOW WHAT DID I DO WRONG ? PLEASE LET ME KNOW AT EARLIEST ?