sapinst system copy error on oracle 11g database

During System Copy using ECC 6.0 SR3 Installation master on oracle database version 11g you may encounter another problem with sapinst if it tries to execute the command execute DBMS_SCHEDULER.DISABLE('GATHER_STATS_JOB'); This job does not exist in 11g and your installation will stop with the message:

DIAGNOSIS: Error message: ORA-27476: "SYS.GATHER_STATS_JOB" does not exist

You need to edit the control.xml file in your installation directory and comment out the GATHER_STATS_JOB disabling command. Just put "--" before the word "execute" so your line looks like this:

stream.putLine("--execute DBMS_SCHEDULER.DISABLE('GATHER_STATS_JOB');");

This shouldn't be necessary, but do it anyway: Edit the file dbms_scheduler.sql in your installation directory and comment out the line (created as per control.xml) so it looks like this

--execute DBMS_SCHEDULER.DISABLE('GATHER_STATS_JOB');

Stop sapinst! Restart sapinst, chosing exactly the same options as before, and choose "continue old installation". Your installation should run through now.

2 Response to "sapinst system copy error on oracle 11g database"

  1. Anonymous January 11, 2012 at 7:08 AM
    Saved my day

Post a Comment