Monday 15 December 2014

ORACLE Upgradation 11.2.0.1.0 to 11.2.0.4.0

ORACLE Upgradataion 11.2.0.1.0 to 11.2.0.4.0
download the software Oracle 11.2.0.1.0 from oracle support

[root@oranode1 ~]# /u01/app/oracle/product/11.2.0/dbhome_2/root.sh
Performing root user operation for Oracle 11g

The following environment variables are set as:
   ORACLE_OWNER= oracle
   ORACLE_HOME=  /u01/app/oracle/product/11.2.0/dbhome_2

Enter the full pathname of the local bin directory: [/usr/local/bin]: y
Creating y directory...
  Copying dbhome to y ...
  Copying oraenv to y ...
  Copying coraenv to y ...

Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Finished product-specific root actions.

[oracle@oranode1 ~]$ ps -ef|grep smon
oracle   14039     1  0 17:06 ?        00:00:02 ora_smon_orcl
oracle   26297 26262  0 22:40 pts/4    00:00:00 grep smon
[oracle@oranode1 ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.1.0 Production on Thu Dec 4 22:41:05 2014

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning option

SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> !lsnrctl stop

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 04-DEC-2014 22:41:37

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
The command completed successfully

Once Shutdown the database and listener, then start upgrading

$export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_2/
$/u01/app/oracle/product/11.2.0/dbhome_2/bin/dbua &




Keep the FRA Location as it is, You no need to change


I am not using any grid control, In this case you can UNCHECK the box



OLAP features, we are not using that errors can be ignore




Once Completed
SQl>SELECT INSTANCE_NAME,VERSION FROM V$INSTANCE;
SQL>SELECT * FROM DBA_OBJECTS WHERE STATUS=’INVALID’;

$lsnrctl status , if need stop and start and verify

5 comments:

  1. Hi,

    Very nicely explained. thanks for this post.

    Keep it up !!!!!!

    Regards,
    Anil Bhardwaj
    Email : mca.anil.ocp@gmail.com
    Mob. +91-9582358737

    ReplyDelete
  2. This comment has been removed by the author.

    ReplyDelete
  3. HI,

    In DBUA step 5 of 5...I am getting the same version under both the Database and the target database columns....please tell me which step am I missing,
    Thanks

    Natansh Negi

    ReplyDelete
  4. Hello Guys
    Chech it out for upgradation in windows,Its work perfectly for me
    https://sapbasisrohitkandwal.blogspot.in/2017/02/oracle-database-upgradation-112010-to.html

    ReplyDelete
  5. Hello Guys
    Chech it out for upgradation in windows,Its work perfectly for me
    https://sapbasisrohitkandwal.blogspot.in/2017/02/oracle-database-upgradation-112010-to.html

    ReplyDelete

Popular Posts