Please send your Questions & Answers or Feedback to "dvmadhavreddy@javabook.org"

Please send your Questions & Answers or Feedback to "mohan@javabook.org"

Upgrading - Action plan


We need to install 10.2.0.5 and upgrade the database to 10.2.0.5.
Going to install 10.2.0.1 in /u02/app/oracle/product/10.2.0.1/db_home.
install 10.2.0.5 on top of /u02/app/oracle/product/10.2.0.5/db_home.
Take downtime from customer(bring down all services from db_home).
Copy pfile/spfile to new oracle_home/dbs
SQL> startup upgrade
SQL> @$ORACLE_HOME/rdbms/catupgrade.sql
SQL> @ORACLE_HOME/rdbms/admin/utlrp.sql

In oracle 11g release 2, oracle has introduced out of place/out of home patching(since 11.2.0.2 and 11.2.0.3 can be considered as the base versions as well as patch sets)to minimise the down time.
To know the list of patches installed in the current home
root> opatch lsinventory
or
root> opatch lsinventory -detail $ORACLE_HOME

Related Posts Plugin for WordPress, Blogger...

Flag Counter