This discussion is archived
1 Reply Latest reply: Feb 20, 2013 6:01 AM by Erik Janssen RSS

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

TorstenW. Newbie
Currently Being Moderated
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 Pro
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points