1 Reply Latest reply: Dec 31, 2012 7:12 AM by Erman Arslan RSS

    DB upgrade with OS migration

    958430
      Hello.

      My 10.2.0.4 database was installed on Windows x64, and all is left from it are dbf files and pfile. I'm trying to find a fastest way to launch it on Linux x64 with 11.2.0.1.
      So far I've installed 11g on linux, copied and modified pfile to correspond to new paths. Then I made startup nomount using this pfile and tried to convert old windows dbfs with rman:
      rman
      connect target
      CONVERT DATAFILE <file list> DB_FILE_NAME_CONVERT '<orig path>','<dest path>' FROM PLATFORM 'Microsoft Windows x86 64-bit';
      Conversion completed successfully.
      Next step - I've recreated control files and made
      alter database open resetlogs upgrade;
      Since I'm unable to run utlu112i.sql, I executed
      ALTER TABLE registry$database ADD (tz_version NUMBER);
      ALTER PACKAGE dbms_registry COMPILE BODY;
      ALTER VIEW dba_registry_database COMPILE;
      ALTER PUBLIC SYNONYM DBA_REGISTRY_DATABASE COMPILE;
      No errors so far.

      After this I've launched @catupgrd.sql and it failed with something like this at the end:
      create or replace
      *
      ERROR at line 1:
      ORA-00604: error occurred at recursive SQL level 1
      ORA-00942: table or view does not exist
      
      Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
      With the Partitioning, Oracle Label Security, OLAP, Data Mining
      and Real Application Testing options
      I would appreciate it if you have any info on performing this without installation of 3 databases or found errors in my method.

      Thanks.
        • 1. Re: DB upgrade with OS migration
          Erman Arslan
          the errors seems produced because the lack of running utlu112i.sql.
          It must create some table, to put the needed information for upgrade.
          then catupgrd will use that table to do some work. (like tz upgrade for ex.)
          So if that so, running utlu will help .. These actions can be taken manually but taking these action manually would be an unsupported move in my opinion.