TutorialDBA - Support | Training | Consultant

What are the types of patch in oracle? There are different kinds of oracle patches. CPU - Critical Patch Update Interim patches Generic patches. PSU - Patch Set Update How will you apply a patch ? [oracle@oracleserver 9267897]$ opatch apply -invPtrLoc $ORACLE_HOME/oraInst.loc Invoking OPatch 10.2.0.4.2 Oracle Interim Patch Installer version 10.2.0.4.2 Copyright (c) 2007, Oracle Corporation. All rights reserved. Oracle Home : /u01/product/10.2.0/db_1 Central Inventory : /u01/app/oraInventory from : /u01/product/10.2.0/db_1/oraInst.loc OPatch version : 10.2.0.4.2 OUI version : 10.2.0.4.0 OUI location : /u01/product/10.2.0/db_1/oui Log file location : /u01/product/10.2.0/db_1/cfgtoollogs/opatch/opatch2012-07-11_19-59-25PM. log ApplySession applying interim patch '9267897' to OH '/u01/product/10.2.0/db_1' Running prerequisite checks... Prerequisite check "CheckActiveFilesAndExecutables" failed. The details are: Following exec...

Oracle 10g database is upgrade to oracle 11g database.This upgrade support from 10.2.0.4.0 to 11.1.0.6.0 version only. Step -1 Pre Request 1. Check the database version. SQL> select * from v$version; BANNER —————————————————————- Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – Prod PL/SQL Release 10.2.0.4.0 – Production CORE 10.2.0.4.0 Production TNS for Linux: Version 10.2.0.4.0 – Production NLSRTL Version 10.2.0.4.0 – Production 2. Check the packages validity. SQL> select comp_name, version, status from sys.dba_registry; COMP_NAME VERSION STATUS ———————————————– ———— —— Oracle Database Catalog Views 10.2.0.4.0 VALID Oracle Database Packages and Types 10.2.0.4.0 VALID 2 rows selected. 3. Check whether objects are valid SQL> select object_name,status from dba_objects where status='INVALID'; no rows selected. 4. Check whether any datafile is in backup mode SQL> select * from v$backup where status='ACTIVE'; FILE# STATUS CHANGE# TIME --------- -----...

Oracle 10g database is upgrade to oracle 11g database.This upgrade support from 10.2.0.4.0 to 11.1.0.6.0 version only. Step -1 Pre Request 1. Check the database version. SQL> select * from v$version; BANNER —————————————————————- Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – Prod PL/SQL Release 10.2.0.4.0 – Production CORE 10.2.0.4.0 Production TNS for Linux: Version 10.2.0.4.0 – Production NLSRTL Version 10.2.0.4.0 – Production 2. Check the packages validity. SQL> select comp_name, version, status from sys.dba_registry; COMP_NAME VERSION STATUS ———————————————– ———— —— Oracle Database Catalog Views 10.2.0.4.0 VALID Oracle Database Packages and Types 10.2.0.4.0 VALID 2 rows selected. 3. Check whether objects are valid SQL> select object_name,status from dba_objects where status='INVALID'; no rows selected. 4. Check whether any datafile is in backup mode SQL> select * from v$backup where status='ACTIVE'; FILE# STATUS CHANGE# TIME --------- -----...