cancel
Showing results for 
Search instead for 
Did you mean: 

When we can update Oracle parameters during System Copy with R3LOAD

Former Member
0 Kudos

Hi All,

There is a SAP Note (936441 - Oracle settings for R3load based system copy) we can follow to optimize R3load based system copy. Of course we can set some Oracle parameters before the export, but when we have a chance to update Oracle parameters in target system during the import as Oracle parameters are provided by SAPINSTS tool and it will not stop for us to update some parameters before step ABAP Import?

Yohanes

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Purbaya,

  You can perform the following in your target location before start of the import

1. Go to /sapmnt/SID/exe

2. Rename the R3load to someother name.

3. Start the sapinst in your target location

4. In one phase, SAPINST will throw an error that it is not able to find R3load file.

5. Stop the DB , Make the necessary changes in the oracle parameters file.

6. Start the DB

7. Rename back the R3load file name to R3load

8. Click on Retry option.

This step is also an another way..

Thanks and Regards,

Vimal

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Juan,

Thanks for your feedback, for some reasons (maybe I imported on the same hosts and Oracle software was already installed) the installation was not stopped on Oracle Server installation, but your post is also helpful.

Hi Vimal,

Thanks for the trick, it works.

Regards,

Yohanes

JPReyes
Active Contributor
0 Kudos

but when we have a chance to update Oracle parameters in target system during the import

You won't change parameters during the import, before the import, SAPINST will stop for you to install the Oracle DB + SAP Bundle patches this is when you apply your parameter changes too.

Regards

Juan