Oracle Cloud Infrastructure
Coming soon ...
Apps R12.2
  • R12.2 Architecture
  • Cloning Error (RC-50208)
  • Apps R12.1
  • Major changes from 11i
  • R12:HTTP Debug Logging
  • Compile Apps Schema invalid objects in R12
  • Apps 11i
  • Apps Components and Architecture
  • Concurrent managers
  • Patching
  • Using AD Patch
  • Using AD Control
  • FNDCPASS utility
  • Single-node Installation
  • Multi-node Installation
  • Find Apps Version
  • Cloning
  • Upgrade 11.5.9 to 11.5.10.2
  • Upgrade from 11.5.10.2 to R12
  • Upgrading 9i to 10g with 11i
  • 11i/R12 General Topics
  • AppsDBA System Management Utilities Guide
  • Identifying Long Idle Sessions
  • Identifying High Active Sessions
  • Change hostname for EBS
  • Oracle 12c Database
  • Oracle12c PSU Apply
  • Oracle12c Datafile moved Online
  • Oracle 11g Database
  • Upgrade 10g to 11g R1
  • Upgrade 11.2.0.2 to 11.2.0.3
  • Database 9i-10g
  • Top 99 Responsibilities of a DBA
  • General Info
  • Database Patching
  • 10g:ASM
  • 10g:Data Pump
  • 10g:Data Guard Installing
  • 10g:Rollback Monitoring
  • 10g:Flashback Table
  • Tablespace Management
  • Materialized Views
  • 10g:Enterprise Manager
  • 10g:Upgrade
  • Error:Ora-01631
  • DBA Scripts
  • Disk I/O,Events,Waits
  • Tablespace Information
  • Session Statistics
  • Hit/Miss Ratios
  • User Information
  • Rollback Segments
  • Full Table Scans
  • Contention/Locking
  • Redo Log Buffer
  • Data Dictionary Info
  • Oracle10g Application Server
  • Oracle10g Application Installation
  • (Re)Securing OAS Control
  • Oracle AS10g null protocol issue
  • Oracle Backup & Recovery
  • RMAN
  • RMAN Setup
  • Backup Recovery
  • Flash Recovery Area
  • Oracle10g Discoverer with Apps
    Coming soon ..............
    Troubleshooting
  • Discoverer Troubleshooting
  • Access EBS in mozile
  • Linux and Unix Platforms
  • How To configure NFS
  • Unix/Linux Command
  • Change hostname in Linux
  • SENDMAIL configuration
  • This Oracle Application DBA Portal is the biggest knowledge gateway for the people in the world of Oracle...
    Thursday, May 28, 2015
    Upgrade Oracle Database 10g to 11g R1 (11.1.X)
    Upgrade Oracle Database 10g to 11g R1 (11.1.X)


    Note:-
    1. Direct Upgrade is possible from 10.2.0.1 and higher
    2. There are two methods to upgrade database
      a) Database Upgrade Assistant (DBUA) and
      b) Manual Upgrade
     We are going to use Manual Upgrade
    3. Install 11g database software in different ORACLE_HOME from source Database


    Upgrade Steps
    1. Prepare to Upgrade
    1.1 Install 11g in different (new) ORACLE_HOME with following consideration
    a) When prompted for Upgrade an Existing Database (Select NO)



    b) On Select Configuration Option  select Install Software Only


    Step:1 Pre-upgrade

    1. Analyze database using pre-upgrade information tool ( utlu111i.sql sql script available at 11g_oracle_homne/rdbms/admin/utlu111i.sql  run it from source database i.e. 10g)


    sqlplus “/as sysdba”
    SQL>spool upgrade_info.log
    SQL>@/11g_oracle_home/rdbms/admin/utlu111i.sql



    2. Check the output of the Pre-Upgrade Information Tool in upgrade_info.log and fix any issues
    Obsolete/Deprecated Parameters: [Update Oracle Database 11.1 init.ora or spfile]
    **************************************************
    –> “background_dump_dest” replaced by  “diagnostic_dest”
    –> “user_dump_dest” replaced by  “diagnostic_dest”
    –> “core_dump_dest” replaced by  “diagnostic_dest”



    To fix this obsolete parameter, comment out from initialization parameter file and replace with new parameter like comment above three deprecated parameters and add *.diagnostic_dest


    WARNING: –> Database is using an old timezone file version.
    …. Patch the 10.2.0.1.0 database to timezone file version 4
    …. BEFORE upgrading the database.  Re-run utlu111i.sql after
    …. patching the database to record the new timezone file version.



    To find time zone file version on source database (10g) run



    SQL> select * from v$timezone_file;
    If time zone file version is less than 4 then apply time zone patch  5632264 manually for 10.2.0.1 database (more on How to manually upgrade time zone file version on database coming soon … )


    3. Check invalid objects
    SQL> select object_name, owner, object_type from all_objects where status like ‘INVALID';
    4. Check version & status of all database components
    SQL>select comp_name,version, status from dba_registry;


    5. Take backup of source database i.e. 10g database


    6. If you are using spfile, create pfile
    SQL> create pfile from spfile ;


    This will create pfile in 10g $ORACLE_HOME/dbs/init[SID].ora
    7. Copy initialization file (pfile) from source (10g) to target (11g)


    8. Adjust initialization parameter specific to 11g like
    a) Remove *.background_dump_dest, *.core_dump_dest, *.user_dump_dest and add
    *.diagnostic_dest=’/11g_base’  (11g Base Directory)
    b) Change
    *.compatible=’10.2.0.1.0′
    to
    *.compatible=’11.1.0′
    .
    .
    Step:2. Upgrade Database
    1. Shut down source database (10g) – Your downtime starts here
    sqlplus “/as sysdba”



    SQL>shutdown immediate
    2. Set your environment variables to Oracle Database 11g Release 1 (11.1) :
    export ORACLE_HOME=/u01/oracle/11gbase/11.1.0
    export ORACLE_SID=TEST
    export PATH=$ORACLE_HOME/bin:$PATH


    3. Start Upgrade
    sqlplus “/as sysdba”
    SQL> startup upgrade
    Check shared_pool & java_pool size, to set new values
    SQL>alter system set java_pool_size=512M;
    SQL>alter system set shared_pool_size=800M;

    SQL> spool upgrade.log
    SQL> @?/rdbms/admin/catupgrd.sql  (Upgrade process shut down database after catupgrd.sql)
    Check alert log in 11g at
    /11gBase_Install/diag/rdbms/[sid]/[SID]/trace/alert_[SID].log


    4. Run Post-Upgrade Status Tool provides a summary of the upgrade
    SQL> startup



    SQL>@?/rdbms/admin/utlu111s.sql
    If you hit error like”ORA-00001: unique constraint (SYS.I_DIANA_VERSION) violated” check metalink note # 744693.1


    5. Perform upgrade actions that do not require the database to be in UPGRADE mode
    SQL>@?/rdbms/admin/catuppst.sql


    6. Compile Invalid Objects
    SQL>@?/rdbms/admin/utlrp.sql
    Check invalid objects
    SQL> select count(*) from dba_objects where status like ‘INVALID';
    .
    .
    Step:-3 Post Upgrade steps
    1. Check status of database components
    SQL>select comp_name,version, status from dba_registry;


    2. Copy tnsnames.ora, listener.ora, sqlnet.ora and include file from source (10g) oracle_home to target (11g) oracle_home


    3. Back up upgraded (11g) database.




    Happy Learning
    --Sreene
    posted by Srinivasan .R @ 3:04 AM  
    33 Comments:
    Post a Comment
    << Home
     
    About Me

    Name: Srinivasan .R
    Home: Chennai, India

    About Me:
    I am working as an Oracle Applications DBA specializing in EBS 11i/R12 with Over 14+ years of experience, mainly in different versions of Oracle Database & Application administration on various platforms like HP-UX, SOLARIS, AIX, Red hat Linux & Windows
    See my complete profile
    High Availability
  • Oracle10g RAC Installation
  • A Quick Reference for Oracle Database 10g RAC on Linux and Unix Platforms
  • Implementing Oracle 10g RAC with ASM on AIX
  • Locked objects for whole RAC
  • Monitor Memory RAC
  • Sessions RAC
  • Install Oracle 11g RAC On Linux
  • Migrating Oracle10g DB to ASM
  • Helpful Links
  • Good Metalink Notes
  • Discoverer:Metalink Notes
  • Logs Scripts:Metalink Notes
  • Support:Metalink Notes
  • Previous Post
  • Oracle EBS R12.2 Architecture
  • Cloning the database from 11.2.0.2 to 11.2.0.3 on ...
  • Oracle12c Datafile moved Online
  • Oracle12c PSU Apply
  • Oracle AS 10g null protocol issue
  • (Re)Securing Oracle Application Server Control
  • How to compile Apps Schema (invalid objects) in R12 ?
  • Workflow Notification Mailer Setup
  • Data Dictionary Info
  • Redo Log Buffer
  • Archives
    Download Software
  • Oracle 11g
  • Oracle 10g
  • 10g Express Edition
  • Oracle 9i
  • Oracle Apps
  • Oracle Linux
  • Oracle VM
  • App Server
  • Solaris
  • Fedora
  • Fedora
  • OpenSUSE
  • Ubuntu
  • Advertisement Links
    INTUIT Technology

    MACHS DATA

    Add Ons
    Locations of visitors to this page

    Add to Google Reader or Homepage

    Template by
    Sreene



    Oracle Application DBA Portal