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#NGL451T1>>/oracle>dbua -silent -sid NGL451T1
Log files for the upgrade operation are located at: /oracle/home/cfgtoollogs/dbua/NGL451T/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#NGL451T1>>/oracle>srvctl config database -d NGL451T
Database unique name: NGL451T
Database name: NGL451T1
Oracle home: /oracle/home/11.2.0.2.0
Oracle user: grid
Spfile: +DATA/spfileNGL451T.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#NGL451T1>>/oracle> srvctl modify database -d NGL451T -o /oracle/home/11.2.0.3.0
ota5013#NGL451T1>>/oracle> srvctl config database -d NGL451T
Database unique name: NGL451T
Database name: NGL451T1
Oracle home: /oracle/home/11.2.0.3.0
Oracle user: grid
Spfile: +DATA/spfileNGL451T.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
NGL451T1:/oracle/home/11.2.0.3.0:N
ota5013#NGL451T1>>/oracle>srvctl upgrade database -d NGL451T -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.
