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
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