5 Replies Latest reply: Dec 19, 2012 7:26 AM by Srini Chavali-Oracle RSS

    Upgrade Database from 10.2.0.5.0 to 11.2.0.3.0 in Silent Mode

    976124
      Hello there,

      Previously, I had posted a thread on how to upgrade database from 10.2.0.5.0 to 11.2.0.3.0 through the wizards provided (GUI-based) and had successfully upgraded the database. Now, I am attempting to upgrade the database from 10.2.0.5.0 to 11.2.0.3.0 once more but this time, in silent mode (console-based). Unfortunately, I am lack of knowledge regarding the installation of the software and upgrading the database in silent mode.

      I managed to figure out this much so far:
      1 . Traverse through the installation directory to the directory shown below:
             11.2.0.3 > Extracted > database > response
      
      2 . Fill up the blanks of db_install.rsp file:
             oracle.install.option=INSTALL_DB_SWONLY
             SELECTED_LANGUAGES=en
             ORACLE_HOME=C:\Oracle\11g\DBSwLoc
             ORACLE_BASE=C:\Oracle\11g
             oracle.install.db.InstallEdition=EE
             oracle.install.db.EEOptionsSelection=false
             oracle.install.db.isRACOneInstall=false
             oracle.install.db.config.starterdb.memoryOption=true
             oracle.install.db.config.starterdb.installExampleSchemas=false
             oracle.install.db.config.starterdb.enableSecuritySettings=true
             oracle.install.db.config.starterdb.control=DB_CONTROL
             oracle.install.db.config.starterdb.automatedBackup.enable=false
             oracle.installer.autoupdates.option=SKIP_UPDATES
      
      3 . Save new db_install.rsp file to a new location (shorter path name without spacing will be best recommended)
      
      4 . Traverse through the installation directory to where the setup file is located.
      
      5 . Execute the following command:
             setup.exe -silent -waitforcompletion -responseFile C:\db_install_updated.rsp
      The result I received is as shown below:
      Starting Oracle Universal Installer...
      
      Preparing to launch Oracle Universal Installer from C:\Users\...\Temp\OraInstall2012-12-13_03-16-43PM.  Please wait ... [WARNING] - My Oracle Support Username/Email Address Not Specified
      [SEVERE] - Provide the My Oracle Support password.
      
      Please press Enter to exit...
      Previously in the db_install_updated.rsp response file, I had set autoupdate option to SKIP_UPDATES but why does it still prompt me for the Oracle Support account?

      Edited by: Maxwell T on Dec 13, 2012 4:05 PM
        • 1. Re: Upgrade Database from 10.2.0.5.0 to 11.2.0.3.0 in Silent Mode
          976124
          My bad! I forgot to set the following in the db_install_updated.rsp file:
          SECURITY_UPDATES_VIA_MYORACLESUPPORT=false
          DECLINE_SECURITY_UPDATES=true
          P/S:
          I am going to leave this thread open in case I do face any other issues during the silent mode upgrade.
          • 2. Re: Upgrade Database from 10.2.0.5.0 to 11.2.0.3.0 in Silent Mode
            976124
            After running the command below to upgrade the current database (Oracle 10.2.0.5.0):
            dbua -silent -sid DB01 -oracleHome C:\Oracle\10g\DBSwLoc -oracleBase C:\Oracle\10g -diagnosticDest C:\Oracle\11g -sysDBAUserName sys -sysDBAPassword password -autoextendFiles -upgradeTimezone -commonFileLocation C:\Oracle\11g\DBSwLoc\oradata\database -recompile_invalid_objects true -degree_of_parallelism 7 -dbsnmpPassword DefaultPassword1 -sysmanPassword DefaultPassword1 
            This is the result:
            Oracle recommends gathering dictionary statistics prior to upgrading the database.  Refer to the Upgrade Guide for Performing Pre Upgrade
            UPGRADE_PROGRESS : 0%
            UPGRADE_PROGRESS : 4%
            Upgrading Oracle Server
            UPGRADE_PROGRESS : 5%
            UPGRADE_PROGRESS : 6%
            UPGRADE_PROGRESS : 7%
            UPGRADE_PROGRESS : 8%
            UPGRADE_PROGRESS : 9%
            UPGRADE_PROGRESS : 10%
            UPGRADE_PROGRESS : 11%
            UPGRADE_PROGRESS : 12%
            UPGRADE_PROGRESS : 13%
            UPGRADE_PROGRESS : 14%
            UPGRADE_PROGRESS : 15%
            UPGRADE_PROGRESS : 16%
            UPGRADE_PROGRESS : 17%
            UPGRADE_PROGRESS : 18%
            UPGRADE_PROGRESS : 19%
            UPGRADE_PROGRESS : 20%
            UPGRADE_PROGRESS : 20%
            UPGRADE_PROGRESS : 21%
            UPGRADE_PROGRESS : 22%
            UPGRADE_PROGRESS : 23%
            UPGRADE_PROGRESS : 24%
            UPGRADE_PROGRESS : 25%
            UPGRADE_PROGRESS : 26%
            UPGRADE_PROGRESS : 27%
            UPGRADE_PROGRESS : 28%
            UPGRADE_PROGRESS : 29%
            UPGRADE_PROGRESS : 30%
            Collecting information from database
            UPGRADE_PROGRESS : 31%
            UPGRADE_PROGRESS : 32%
            UPGRADE_PROGRESS : 53%
            Modifying and starting Oracle instance
            UPGRADE_PROGRESS : 58%
            Copying database files
            UPGRADE_PROGRESS : 60%
            Switching database files
            UPGRADE_PROGRESS : 62%
            UPGRADE_PROGRESS : 63%
            ORA-01167: two files are the same file/group number or the same fileORA-00202: control file: 'C:\ORACLE\11G\FULLCLIENT\ORADATA\DATABASE\LV01\CTRLLV01.ORA'
            Any suggestions for this error?

            Thank you in advance.
            • 3. Re: Upgrade Database from 10.2.0.5.0 to 11.2.0.3.0 in Silent Mode
              Srini Chavali-Oracle
              I assume you are running the dbua command from the 11gR2 ORACLE_HOME. Can you post the last 100 lines from the upgrade log file ?

              This may be a bug - pl open an SR with Support

              ORA-1167 When Creating a Controlfile with a Database Copy [ID 471960.1]

              HTH
              Srini
              • 4. Upgrade DB from 10.2.0.5.0 to 11.2.0.3.0 in Silent Mode + Moving Datafile
                976124
                Hi Srini

                First of all, thank you for your reply.
                Srini Chavali wrote:
                I assume you are running the dbua command from the 11gR2 ORACLE_HOME. Can you post the last 100 lines from the upgrade log file ?

                This may be a bug - pl open an SR with Support

                ORA-1167 When Creating a Controlfile with a Database Copy [ID 471960.1]
                Yes, I am running the dbua command from Oracle 11gR2's ORACLE_HOME\BIN folder.
                The problem was solved by renaming the control file and updating the "control_files" variable in the "init.ORA" file.

                I managed to progress further but am now facing another error as could be seen below:
                ORA-010921: ORACLE instance terminated.  Disconnected forced
                ORA-01173: data dictionary indicates missing data from system tablespace
                • 5. Re: Upgrade DB from 10.2.0.5.0 to 11.2.0.3.0 in Silent Mode + Moving Datafile
                  Srini Chavali-Oracle
                  Pl check the database alert log and upgrade log. Pl post all of the steps that you took prior to this error occurring.

                  OERR: ORA 1173 data dictionary indicates missing datafile from system tablespa [ID 18746.1]

                  HTH
                  Srini