Oracle 11g:Upgrade 11.2.0.x version to latest 11.2.0.4.1 patchset:Upgrade

Oracle 11g:Upgrade 11.2.0.x version  to latest 11.2.0.4.1 patchset:Upgrade 


Once We finish the installation of 11.2.0.4 on different then we will go further for upgrade database.
For Installation,
http://oracle-mssql-dba.blogspot.in/2014/07/oracle-11gupgrade-1120x-version-to.html

Step 2.Run Pre-upgrade Information Tool 

SQL>spool /utlu112i.log
SQL>@ORACLE_HOME/rdbms/admin/utlu112i.sql

 Check timezone .Need to upgrade if it is require by tool.

 Step 3.Run dbupgdiag.sql.Check any invalid objects in dba_registry.
Valid all Dba_registry object by running utlrp.sql

 sql>sqlplus / as sysdba
sql>@?/rdbms/admin/utlrp.sql
Step 4.Backup database.

 a)take rman backup with latest spfile & controlfile.
b)take cold backup by mount the database after shutdown normal db.
Step 5.Shut down database normal.

 SQL>shutdown normal.

 Step 6.Set New Oracle_HOME,PATH,LIBRARY_PATH.Copy tnsnames.ora,listener.ora,spfile,pfile & password to new oracle_home location.Update /etc/oratab.

 a)update oratab.
#oraupg:/u01/oracle/product/11.2.0/dbhome_1:N
oraupg:/u01/oracle/product/11.2.0.4:N
b)export ORACLE_HOME=/u01/oracle/product/11.2.0.4/
   export ORACLE_SID=oraupg
c) Copy pfile,spfile & password files
cp *ora /u01/oracle/product/11.2.0.4/dbs/
d)Copy tnsnames.ora,listener.ora & sqlnet.ora
cp *ora /u01/oracle/product/11.2.0.4/network/admin/


Step 7.Upgrade database manually.

a)
[oracle@localhost admin]$ echo $ORACLE_HOME
/u01/oracle/product/11.2.0.4


cd $ORACLE_HOME/rdbms/admin


 sql>sqlplus / as sysdba
sql>spool /tmp/catupgrd.log
sql>startup upgrade
sql>set echo on;
sql>@catupgrd.sql
sql>spool off;
sql>shutdown normal

 catupgrd.sql will take around 5 hours to finish on single database.Do parallel if more than 1 databases.
b)Check catupgrd.sql spool file for errors.

 c)Restart database normal.

 d)SQL>@$ORACLE_HOME/rdbsm/admin/catuppst.sql

 e)SQL>@$ORACLE_HOME/rdbms/admin/utlrp.sql

 f)Run dbupgdiag.sql scirpt for invalid objects in dba_registry. and no invalid objects in dba_objects.

 Step 8.Gather stats of whole database.
******************************************FINISH*******************************************************

Comments

  1. BhaveshJuly 29, 2014 at 1:19 AM

    SQL> SELECT TO_NUMBER('DATA_VAULT_OPTION_ON') FROM v$option
    2 WHERE
    3 value = 'TRUE' and parameter = 'Oracle Database Vault';
    SELECT TO_NUMBER('DATA_VAULT_OPTION_ON') FROM v$option
    *
    ERROR at line 1:
    ORA-01722: invalid number



    ---\

    Solution::::

    SQL> shut immediate
    Database closed.
    Database dismounted.
    ORACLE instance shut down.
    SQL> exit

    [oracle@localhost admin]$ cd $ORACLE_HOME/rdbms/lib
    [oracle@localhost lib]$ pwd
    /u01/oracle/product/11.2.0.4/rdbms/lib
    [oracle@localhost lib]$ make -f ins_rdbms.mk dv_off
    /usr/bin/ar d /u01/oracle/product/11.2.0.4/rdbms/lib/libknlopt.a kzvidv.o
    /usr/bin/ar cr /u01/oracle/product/11.2.0.4/rdbms/lib/libknlopt.a /u01/oracle/product/11.2.0.4/rdbms/lib/kzvndv.o
    [oracle@localhost lib]$ cd $ORACLE_HOME/bin
    [oracle@localhost bin]$ relink all
    writing relink log to: /u01/oracle/product/11.2.0.4/install/relink.log

    --Again start database in Step 7

    ReplyDelete

Post a Comment

Dear User,

Thank you very much for your kind response

Popular posts from this blog

Oracle 12c : How To Purge The UNIFIED AUDIT TRAIL

Image
Oracle 12c : How To Purge The UNIFIED AUDIT TRAIL  APPLIES TO: Oracle Database - Enterprise Edition - Version 12.1.0.1 and later Information in this document applies to any platform. GOAL  How to purge the  UNIFIED_AUDIT_TRAIL table ? SOLUTION The unified audit trail can be purged using the DBMS_AUDIT_MGMT package:  qlplus / as sysdba SQL>  select  count(*) from unified_audit_trail;   COUNT(*) ----------       2619 SQL>  BEGIN DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL( audit_trail_type         =>  DBMS_AUDIT_MGMT.AUDIT_TRAIL_UNIFIED, use_last_arch_timestamp  =>  FALSE); END; / PL/SQL procedure successfully completed. SQL>  select  count(*) from unified_audit_trail;   COUNT(*) ----------          1 You can also use the last_arch_timestamp, if you don't want to purge all ...
Read more

Oracle 11g: Install Instant Client 11.2.0.3.0 on Linux x86_64 Server.

Oracle 11g: Install Instant Client 11.2.0.3.0 on Linux x86_64 Server. ***What is Instant Client &benefits? As per Oracle docs, Oracle Database Instant Client Instant Client allows you to run your applications without installing the standard Oracle client or having an ORACLE_HOME. OCI, OCCI, Pro*C, ODBC, and JDBC applications work without modification, while using significantly less disk space than before. Even SQL*Plus can be used with Instant Client. No recompile, no hassle. ISVs and Partners   benefit greatly from packaging Instant Client along with their applications, saving customers the extra step of installing and configuring an Oracle client. Free. The same fully-featured, high-performance applications that Oracle ISVs and partners have always delivered will continue to work, untouched. Customers can try new packaged applications and Oracle client features quickly without worrying about other installations. Larger enterprises ca...
Read more

gDBClone Powerful Database Clone/Snapshot Management Tool (Doc ID 2099214.1)

Image
  Didn't find what you are looking for?   Attachments   gDBClone-3.0.4.Solaris.sparc.pkg - 20200722 - $Revision: 3.0.4.2 $ (13.12 MB) gDBClone.el6.x86_64.rpm - 20230531 - $Revision: 3.0.5.3 $ (9.72 MB) gDBClone.el7.x86_64.rpm - 20230531 - $Revision: 3.0.5.3 $ (11.16 MB) gDBClone.el8.x86_64.rpm - 20230531 - $Revision: 3.0.5.3 $ (11.57 MB) gDBClone-Solaris.i386.pkg - 20230531 - $Revision: 3.0.5.3 $ (14.6 MB) gDBClone306.el7.x86_64.rpm - 20231003 - $Revision: 3.0.6.3 $ (12.93 MB) gDBClone306.el8.x86_64.rpm - 20231003 - $Revision: 3.0.6.3 $ (13.34 MB)   Related     Products   Oracle Database Products > Oracle Database Suite > Oracle Database > Oracle Database - Enterprise Edition > STORAGE > ACFS Admin (ACFS IO Errors, Snapshot issues, File system mount issues, ACFS FS resize issue) Oracle Cloud > Oracle Platform Cloud > Oracle Database Cloud Service > Oracle Database Cloud Service Oracle Cloud > Oracle Platform Cloud ...
Read more