Sunday, November 17, 2013

Silent upgrade database from 11.2.0.2.0 to 11.2.0.3.0

Silent upgrade of database from 11.2.0.2 to 11.2.0.3. We required to adjust things for Oracle restart.
1. Start the silent install using database upgrade assistance:

export ORACLE_HOME=/oracle/home/11.2.0.3.0
export PATH=$ORACLE_
HOME/bin:$PATH
ota5013#ORCLDB1>>/oracle>dbua -
silent -sid ORCLDB1

Log files for the upgrade operation are located at: /oracle/home/cfgtoollogs/dbua/ORCLDB/upgrade1
Performing Pre Upgrade
1% complete
.
.
.
92% complete
Generating Summary
Database upgrade has been completed successfully, and the database is ready to use.
100% complete

Now for Oracle restart to work properly for this database do the following

ota5013#ORCLDB1>>/oracle>srvctl config database -d ORCLDB

Database unique name: ORCLDB
Database name: ORCLDB1
Oracle home: /oracle/home/11.2.0.2.0
Oracle user: grid
Spfile: +DATA/spfileORCLDB.
ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Disk Groups: DATA,FRA
Services:

2. Now modify the database for oracle restart

ota5013#ORCLDB1>>/oracle> srvctl modify database -d ORCLDB -o /oracle/home/11.2.0.3.0

ota5013#ORCLDB1>>/oracle> srvctl config database -d ORCLDB

Database unique name: ORCLDB
Database name: ORCLDB1
Oracle home: /oracle/home/11.2.0.3.0
Oracle user: grid
Spfile: +DATA/spfileORCLDB.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Disk Groups: DATA,FRA
Services:

change in /etc/oratab the oracle home
ORCLDB1:/oracle/home/11.2.0.3.0:N

ota5013#ORCLDB1>>/oracle>srvctl
 upgrade database -d ORCLDB -o /oracle/home/11.2.0.3.0
This to prevent the oratab to be overwritten with the old oracle home of this database.


Now your done database is upgraded and oracle restart still works for this database.

No comments:

Post a Comment