Upgrade to Oracle Database 11.2.0.3.0 to 11.2.0.4.0

Upgrade to  Oracle Database 11.2.0.3.0 to 11.2.0.4.0

Manual Upgrade:

Source Database : Release 11.2.0.3.0
Target Database : Release 11.2.0.4.0

1. Copy Pre upgrade Information gathering Script:

$ORACLE_HOME/rdbms/admin/
ls | grep utlu112i.sql
ls | grep utlzuv2.sql

[oracle@db11g admin]$ ls | grep utltzuv2
utltzuv2.sql

2. Execute Pre Upgrade Script:

$ sqlplus '/ as sysdba'
SQL> spool upgrade_info.log
SQL> @utlu112i.sql
SQL> spool off
SQL>






Check the spool file and examine the output of the upgrade information tool.

3. Check for the integrity of the source database:

$ cd $ORACLE_HOME/rdbms/admin
$ sqlplus "/ as sysdba"
SQL> @utlrp.sql

4. Check that National Characterset:

SQL> select value from NLS_DATABASE_PARAMETERS where parameter = 'NLS_NCHAR_CHARACTERSET';
AL16UTF16

5. Optimizer Statistics:

SQL> EXEC DBMS_STATS.GATHER_DICTIONARY_STATS;

6. Ensure that no files need media recovery:

Sql> SELECT * FROM v$recover_file;

# To Start DBCA :

./dbca

 

Here, I use different ORACLE_HOME for Upgradation.






[root@db11g ~]# vi /etc/sysctl.conf
[root@db11g ~]#
[root@db11g ~]#
[root@db11g ~]#
[root@db11g ~]# sysctl -p
net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
net.ipv4.conf.default.accept_source_route = 0
kernel.sysrq = 0
kernel.core_uses_pid = 1
net.ipv4.tcp_syncookies = 1
kernel.msgmnb = 65536
kernel.msgmax = 65536
kernel.shmmax = 4398046511104
kernel.shmall = 4294967296
fs.suid_dumpable = 1
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 4398046511104
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586

 

 ------xXx------

http://www.dbas-oracle.com/2011/06/step-by-step-manual-database-upgrade-to.html