Tuesday, 20 August 2013

SAP-Oracle controlfile creation issue during system copy

While performing system copy in any platform with Oracle DB using backup restore method, there may be situation where the basis consultant will re-create controlfile manually and then tries to continue the setup, but Sapinst will throw error during the controlfile creation phase.

This is a common manual issue, as of 700 sap version, there is no need of manual creation of controlfile in the target system DB.

Before starting target system installation, you may create controlfile trace from source system manually and modify contents or create the target controlfile using oradbatools from installation source directory.

Once the target controlfile script is ready just rename the file as control.sql and paste it in the sapinst directory of the target system and then continue setup from DB restore phase.

Just in case if basis consultant manually updated controlfile in DB and then continues setup, sapinst will throw error as could not create controlfile.

The simple solution to this issue is to create a control.sql file with a single command entry as exit and paste it in the sapinst directory of the target system and then continue setup from error page.

This will resolve the issue..

1 comment:

Pages