1 Reply Latest reply: Feb 20, 2013 8:01 AM by Erik Janssen RSS

    Portal 10g upgrade fails with INST-07285 in config.sh

    TorstenW.
      Hi, I have installed a OFM 11.1.1.6 with OID, OAM, Discoverer, Portal, Forms, Reports. The task is to export all datas from my OAS 10.1.2.3 to the new OFM. That works for OID, SSO -> OAM, but not for Portal. I know, Portal export/import is only possible between same versions and so I have to migrate portal 10g to 11g. After database upgrade to 11.2.0.3 and middletier software installation I start the config.sh. In this program the 10g portal schema is required, but this fails with INST-07285. The recommended solution in Metalink Note 876470.1 is not helpful.
      Any ideas ?
        • 1. Re: Portal 10g upgrade fails with INST-07285 in config.sh
          Erik Janssen
          Steps below should fix the issue :
          <ol>
          <li>Connect to the Portal metadata repository database as SYS user
          <li>Run the following PL/SQL block :
          declare
          -- TO RUN WITH SYSTEM
          l_version varchar2(128);
          begin
          select version into l_version from portal.wwc_version$;
          insert into schema_version_registry
          (
          COMP_ID,COMP_NAME,MRC_NAME,MR_NAME,MR_TYPE,OWNER,VERSION,STATUS,UPGRADED,
          START_TIME,MODIFIED) values ('PORTAL','Oracle Application Server Portal',
          'APPSERVER','APPSERVER','APPSERVER','PORTAL',l_version ,'VALID','Y',
          to_timestamp('11-FEB-10 11.31.58.586797000 AM','DD-MON-RR HH.MI.SS.FF AM'),
          to_timestamp('11-FEB-10 12.10.23.179905000 PM','DD-MON-RR HH.MI.SS.FF AM')
          );
          commit;
          end;
          <li>Repeat config.sh
          </ol>

          Thanks,
          EJ