3 Replies Latest reply on Jun 11, 2018 4:26 AM by mdtaylor

    DBUA - 12c

    Beauty_and_dBest

      EBS 12.1.3

      11.1.0.7 upgrade to 12.1.0.2

      OL6

       

      Hi ALL,

       

      I am running DBUA when upgrading our 11.1.0.7  database to 12.1.0.2.

      But I encountered error below:

       

      Please help how to resolve the issue

      I can not extend the TEMP because database is down when upgrading.

      Do I need to abort and restart? or ignore and continue?

       

       

      Please help what to do...

       

      Kind regards,

      jc

        • 1. Re: DBUA - 12c
          mdtaylor

          Hi jc,

           

          You can connect to another xterm or putty session and increase TEMP.

           

          Here are some example blogs on restarting DBUA:

           

          https://blogs.oracle.com/upgrade/restarting-a-failed-database-upgrade-with-dbua-122

          http://db12c.blogspot.com/2013/06/upgrade-oracle-database-11203-to-121010.html

           

          I usually modify TEMP before doing any upgrades:

           

          Here is an example:

           

          Fix TEMP tablespace and enable autoextend on datafiles.

           

          CREATE SMALLFILE TEMPORARY TABLESPACE "TEMP3" TEMPFILE

          '/lv03/oracle/uat122/data/temp04.dbf' SIZE 100M REUSE

          EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K;

           

          ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP3;

           

          alter tablespace TEMP1 tablespace group '';

          alter tablespace TEMP2 tablespace group '';

           

          shutdown immediate

          startup

           

          DROP TABLESPACE TEMP;

           

          DROP TABLESPACE TEMP1 INCLUDING CONTENTS AND DATAFILES;

          DROP TABLESPACE TEMP2 INCLUDING CONTENTS AND DATAFILES;

           

          CREATE SMALLFILE TEMPORARY TABLESPACE "TEMP" TEMPFILE

          '/lv03/oracle/uat122/data/temp01.dbf' SIZE 2048M REUSE,

          '/lv03/oracle/uat122/data/temp02.dbf' SIZE 2048M REUSE

          EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K;

           

          ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP;

           

          shutdown immediate

          startup

           

          DROP TABLESPACE TEMP3 INCLUDING CONTENTS AND DATAFILES;

           

           

          select 'ALTER DATABASE DATAFILE '''||file_name||''' AUTOEXTEND ON NEXT 10M;' from dba_data_files order by 1;

           

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/a_archive01.dbf' AUTOEXTEND ON NEXT 10M;

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/a_int01.dbf' AUTOEXTEND ON NEXT 10M;

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/a_int02.dbf' AUTOEXTEND ON NEXT 10M;

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/a_media01.dbf' AUTOEXTEND ON NEXT 10M;

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/a_nolog01.dbf' AUTOEXTEND ON NEXT 10M;

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/a_queue01.dbf' AUTOEXTEND ON NEXT 10M;

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/a_queue02.dbf' AUTOEXTEND ON NEXT 10M;

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/a_ref01.dbf' AUTOEXTEND ON NEXT 10M;

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/a_ref02.dbf' AUTOEXTEND ON NEXT 10M;

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/a_ref03.dbf' AUTOEXTEND ON NEXT 10M;

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/a_ref04.dbf' AUTOEXTEND ON NEXT 10M;

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/a_ref05.dbf' AUTOEXTEND ON NEXT 10M;

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/a_ref06.dbf' AUTOEXTEND ON NEXT 10M;

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/a_summ01.dbf' AUTOEXTEND ON NEXT 10M;

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/a_txn_data01.dbf' AUTOEXTEND ON NEXT 10M;

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/a_txn_data02.dbf' AUTOEXTEND ON NEXT 10M;

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/a_txn_data03.dbf' AUTOEXTEND ON NEXT 10M;

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/a_txn_data04.dbf' AUTOEXTEND ON NEXT 10M;

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/a_txn_ind01.dbf' AUTOEXTEND ON NEXT 10M;

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/a_txn_ind02.dbf' AUTOEXTEND ON NEXT 10M;

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/a_txn_ind03.dbf' AUTOEXTEND ON NEXT 10M;

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/a_txn_ind04.dbf' AUTOEXTEND ON NEXT 10M;

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/a_txn_ind05.dbf' AUTOEXTEND ON NEXT 10M;

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/a_txn_ind06.dbf' AUTOEXTEND ON NEXT 10M;

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/apps_ts_tools01.dbf' AUTOEXTEND ON NEXT 10M;

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/ctxd01.dbf' AUTOEXTEND ON NEXT 10M;

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/odm.dbf' AUTOEXTEND ON NEXT 10M;

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/olap.dbf' AUTOEXTEND ON NEXT 10M;

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/owad01.dbf' AUTOEXTEND ON NEXT 10M;

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/portal01.dbf' AUTOEXTEND ON NEXT 10M;

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/sysaux01.dbf' AUTOEXTEND ON NEXT 10M;

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/sysaux02.dbf' AUTOEXTEND ON NEXT 10M;

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/system01.dbf' AUTOEXTEND ON NEXT 10M;

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/system02.dbf' AUTOEXTEND ON NEXT 10M;

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/system03.dbf' AUTOEXTEND ON NEXT 10M;

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/system04.dbf' AUTOEXTEND ON NEXT 10M;

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/system05.dbf' AUTOEXTEND ON NEXT 10M;

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/system06.dbf' AUTOEXTEND ON NEXT 10M;

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/system07.dbf' AUTOEXTEND ON NEXT 10M;

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/system08.dbf' AUTOEXTEND ON NEXT 10M;

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/system09.dbf' AUTOEXTEND ON NEXT 10M;

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/system10.dbf' AUTOEXTEND ON NEXT 10M;

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/system11.dbf' AUTOEXTEND ON NEXT 10M;

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/system12.dbf' AUTOEXTEND ON NEXT 10M;

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/system13.dbf' AUTOEXTEND ON NEXT 10M;

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/system14.dbf' AUTOEXTEND ON NEXT 10M;

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/system15.dbf' AUTOEXTEND ON NEXT 10M;

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/system16.dbf' AUTOEXTEND ON NEXT 10M;

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/system17.dbf' AUTOEXTEND ON NEXT 10M;

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/system18.dbf' AUTOEXTEND ON NEXT 10M;

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/system19.dbf' AUTOEXTEND ON NEXT 10M;

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/system20.dbf' AUTOEXTEND ON NEXT 10M;

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/system21.dbf' AUTOEXTEND ON NEXT 10M;

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/system22.dbf' AUTOEXTEND ON NEXT 10M;

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/system23.dbf' AUTOEXTEND ON NEXT 10M;

          ALTER DATABASE DATAFILE '/lv03/oracle/uat122/data/system24.dbf' AUTOEXTEND ON NEXT 10M;

           

          Regards,

          Michael

          • 2. Re: DBUA - 12c
            Beauty_and_dBest

            Thanks you very much Micheal,

             

             

            But right now the database of concern is down

            Do I need to start it up? What will happen to the pending DBUA? Will it continue?

             

            Ok I will try to start up and autoextend all datafiles....brb

             

            Kind regards,

            • 3. Re: DBUA - 12c
              mdtaylor

              Hi jc,

               

              Normally, the database should be up when you start dbua, that was it can connect to it and upgrade it.

               

              Regards,

              Michael