Monday, February 13, 2012

path apply information

1)how to check which patch is present?
a)opatch -lsinventory
b)select * form sys.registry$history;--from database
2)What is optach apply and opath napply?
Ans:-When we are appling only patch we are using opatch where as napply is used when multiple patch files are used.
           b)opatch -napply -skip_subset -skip_duplicate

3)What is the general steps during the patch apply?
a)check if any invalid object
b)shutdown the database
c)shutdown the listner
d)apply the patch in the Oracle Inventory path
e)startup the db
f)recompile the invalid object by executing the utlrp.sql from $ORACLE_HOME/rdbms/admin location
g)start the listner
h)check a santity test

4)What is patch?
Ans:-Patch is generally bug fix provided by oracle.

5)What is critical cpu patch?
Ans:-Critical Patch Updates are the primary means of releasing security fixes for Oracle products to customers with valid support contracts. They are released on the Tuesday closest to the 17th day of January, April, July and October.

No comments:

Post a Comment