This discussion is archived
5 Replies Latest reply: Dec 19, 2012 5: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 Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Oracle ACE Director
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Oracle ACE Director
    Currently Being Moderated
    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

Legend

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