ORACLE DB Upgrade

ORACLE DB Upgrade

ORACLE Database Upgrade 11.2.0.1 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