Labels

Showing posts with label Patch. Show all posts
Showing posts with label Patch. Show all posts

Thursday, March 6, 2014

Oracle Patch information

12c


11g
Patch 13390677 – 11.2.0.4.0 PATCH SET FOR ORACLE DATABASE SERVER
Patch 10404530 – 11.2.0.3.0 PATCH SET FOR ORACLE DATABASE SERVER
Patch 10098816 – 11.2.0.2.0 PATCH SET FOR ORACLE DATABASE SERVER
Patch 6890831  – 11.1.0.7.0 PATCH SET FOR ORACLE DATABASE SERVER

10g

Patch 8202632 – 10.2.0.5 PATCH SET FOR ORACLE DATABASE SERVER
Patch 6810189 – 10.2.0.4 PATCH SET FOR ORACLE DATABASE SERVER
Patch 5337014 – 10.2.0.3 PATCH SET FOR ORACLE DATABASE SERVER
Patch 4547817 – 10.2.0.2 PATCH SET FOR ORACLE DATABASE SERVER
Patch 4505133 – 10.1.0.5 PATCH SET FOR ORACLE DATABASE SERVER
Patch 4163362 – 10.1.0.4 PATCH SET FOR ORACLE DATABASE SERVER
Patch 3761843 – 10.1.0.3 PATCH SET FOR ORACLE DATABASE SERVER

9i

Patch 4547809 – 9.2.0.8 PATCH SET FOR ORACLE DATABASE SERVER
Patch 4163445 – 9.2.0.7 PATCH SET FOR ORACLE DATABASE SERVER
Patch 3948480 – 9.2.0.6 PATCH SET FOR ORACLE DATABASE SERVER
Patch 3501955 – 9.2.0.5 PATCH SET FOR ORACLE DATABASE SERVER
Patch 3095277 – 9.2.0.4 PATCH SET FOR ORACLE DATABASE SERVER
Patch 2761332 – 9.2.0.3 PATCH SET FOR ORACLE DATABASE SERVER
Patch 2632931 – 9.2.0.2 PATCH SET FOR ORACLE DATABASE SERVER
Patch 3301544 – 9.0.1.5 PATCH SET FOR ORACLE DATABASE SERVER
Patch 2517300 – 9.0.1.4 PATCH SET FOR ORACLE DATABASE SERVER
Patch 2271678 – 9.0.1.3. PATCH SET FOR ORACLE DATA SERVER

8i


Patch 2376472 – 8.1.7.4 PATCH SET FOR ORACLE DATA SERVER
Patch 2189751 – 8.1.7.3 PATCH SET FOR ORACLE DATA SERVER
Patch 1909158 – 8.1.7.2 PATCH SET FOR ORACLE DATA SERVER
at No comments:
Labels:

Monday, February 24, 2014

Patch set reference

Database Patch Number Description
11.2.0.3.2 13696216 DATABASE PATCH SET UPDATE 11.2.0.3.2 (INCLUDES CPU APR2012)
11.2.0.3.1 13343438 DATABASE PATCH SET UPDATE 11.2.0.3.1 (INCLUDES CPU JAN2012)
11.2.0.3 10404530 11.2.0.3.0 PATCH SET FOR ORACLE DATABASE SERVER
11.2.0.2.6 13696224 DATABASE PATCH SET UPDATE 11.2.0.2.6 (INCLUDES CPU APR2012)
11.2.0.2.5 13343424 DATABASE PATCH SET UPDATE 11.2.0.2.5 (INCLUDES CPU JAN2012)
11.2.0.2.4 12827726 DATABASE PSU 11.2.0.2.4 (INCLUDES CPUOCT2011)
11.2.0.2.3 12419331 DATABASE PSU 11.2.0.2.3 (INCLUDES CPUJUL2011)
11.2.0.2.2 11724916 DATABASE PSU 11.2.0.2.2 (INCLUDES CPUAPR2011)
11.2.0.2.1 10248523 DATABASE PSU 11.2.0.2.1
11.2.0.2 10098816 11.2.0.2.0 PATCH SET FOR ORACLE DATABASE SERVER
        
11.2.0.1.6 12419378  DATABASE PSU 11.2.0.1.6 (INCLUDES CPUJUL2011)
11.2.0.1.5 11724930 DATABASE PSU 11.2.0.1.5 (INCLUDES CPUAPR2011)
11.2.0.1.4 10248516 DATABASE PSU 11.2.0.1.4 (INCLUDES CPUJAN2011)
11.2.0.1.3 9952216 DATABASE PSU 11.2.0.1.3 (INCLUDES CPUOCT2010)
11.2.0.1.2 9654983 DATABASE PSU 11.2.0.1.2 (INCLUDES CPUJUL2010)
11.2.0.1.1 9352237 DATABASE PSU 11.2.0.1.1
        
11.1.0.7.11 13621679 DATABASE PATCH SET UPDATE 11.1.0.7.11 (INCLUDES CPU APR2012)
11.1.0.7.10 13343461 DATABASE PATCH SET UPDATE 11.1.0.7.10 (INCLUDES CPU JAN2012)
11.1.0.7.9 12827740 DATABASE PSU 11.1.0.7.9 (INCLUDES CPUOCT2011)
11.1.0.7.8 12419384 DATABASE PSU 11.1.0.7.8 (INCLUDES CPUJUL2011)
11.1.0.7.7 11724936 DATABASE PSU 11.1.0.7.7 (INCLUDES CPUAPR2011)
11.1.0.7.6 10248531 DATABASE PSU 11.1.0.7.6 (INCLUDES CPUJAN2011)
11.1.0.7.5 9952228 DATABASE PSU 11.1.0.7.5 (INCLUDES CPUOCT2010)
11.1.0.7.4 9654987 DATABASE PSU 11.1.0.7.4 (INCLUDES CPUJUL2010)
11.1.0.7.3 9352179 DATABASE PSU 11.1.0.7.3 (INCLUDES CPUAPR2010)
11.1.0.7.2 9209238 DATABASE PSU 11.1.0.7.2 (INCLUDES CPUJAN2010)
11.1.0.7.1 8833297 DATABASE PSU 11.1.0.7.1 (INCLUDES CPUOCT2009)
11.1.0.7 6890831 11.1.0.7.0 PATCH SET FOR ORACLE DATABASE SERVER
        
10.2.0.5.7 13632743 [*] DATABASE PATCH SET UPDATE 10.2.0.5.7 (INCLUDES CPU APR2012)
10.2.0.5.6 13343471 [*] DATABASE PATCH SET UPDATE 10.2.0.5.6 (INCLUDES CPU JAN2012)
10.2.0.5.5 12827745 DATABASE PSU 10.2.0.5.5 (INCLUDES CPUOCT2011)
10.2.0.5.4 12419392 DATABASE PSU 10.2.0.5.4 (INCLUDES CPUJUL2011)
10.2.0.5.3 11724962 DATABASE PSU 10.2.0.5.3 (INCLUDES CPUAPR2011)
10.2.0.5.2 10248542 DATABASE PSU 10.2.0.5.2 (INCLUDES CPUJAN2011)
10.2.0.5.1 9952230 DATABASE PSU 10.2.0.5.1 (INCLUDES CPUOCT2010)
10.2.0.5 8202632 10.2.0.5.0 PATCH SET FOR ORACLE DATABASE SERVER
        
10.2.0.4.11 12879929 [*] DATABASE PATCH SET UPDATE 10.2.0.4.11 (PRE-REQ 10.2.0.4.4|INCLUDES CPUJAN2012)
10.2.0.4.10 12827778 DATABASE PSU 10.2.0.4.10 (REQUIRES PRE-REQUISITE 10.2.0.4.4|INCLUDES CPUOCT2011)
10.2.0.4.9 12419397 DATABASE PSU 10.2.0.4.9 (REQUIRES PRE-REQUISITE 10.2.0.4.4|INCLUDES CPUJUL2011)
10.2.0.4.8 11724977 DATABASE PSU 10.2.0.4.8 (REQUIRES PRE-REQUISITE 10.2.0.4.4|INCLUDES CPUAPR2011)
10.2.0.4.7 10248636 DATABASE PSU 10.2.0.4.7 (REQUIRES PRE-REQUISITE 10.2.0.4.4|INCLUDES CPUJAN2011)
10.2.0.4.6 9952234 DATABASE PSU 10.2.0.4.6 (REQUIRES PRE-REQUISITE 10.2.0.4.4|INCLUDES CPUOCT2010) 
10.2.0.4.5 9654991 DATABASE PSU 10.2.0.4.5 (REQUIRES PRE-REQUISITE 10.2.0.4.4|INCLUDES CPUJUL2010)    [overlay PSU]
10.2.0.4.4 9352164 DATABASE PSU 10.2.0.4.4 (INCLUDES CPUAPR2010)
10.2.0.4.3 9119284 DATABASE PSU 10.2.0.4.3 (INCLUDES CPUJAN2010)
10.2.0.4.2 8833280 DATABASE PSU 10.2.0.4.2 (INCLUDES CPUOCT2009)
10.2.0.4.1 8576156 DATABASE PSU 10.2.0.4.1 (INCLUDES CPUJUL2009)
10.2.0.4 6810189 10.2.0.4.0 PATCH SET FOR ORACLE DATABASE SERVER
10.2.0.3 5337014 10.2.0.3 PATCH SET FOR ORACLE DATABASE SERVER
10.2.0.2 4547817 10.2.0.2 PATCH SET FOR ORACLE DATABASE SERVER
at No comments:
Labels: , ,

Wednesday, June 19, 2013

The June 2013 Oracle Java SE Critical Patch Update was released on June 18, 2013

The June 2013 Oracle Java SE Critical Patch Update was released on June 18, 2013. Oracle strongly recommends applying the patches as soon as possible.

The Critical Patch Update Advisory is the starting point for relevant information. It includes the list of products affected, a summary of the security vulnerabilities, and a pointer to obtain the latest releases and patches.

Also, it is essential to review the Critical Patch Update supporting documentation referenced in the Advisory before applying patches, as this is where you can find important pertinent information.

The Advisories are available at the following location:

June 2013 Oracle Java SE Critical Patch Update:
http://www.oracle.com/technetwork/topics/security/javacpujun2013-1899847.html
For information about Oracle Critical Patch Updates and Security Alerts see Oracle Technology Network:
http://www.oracle.com/technetwork/topics/security/alerts-086861.html

Oracle Java SE Critical Patch Update Schedule

The next four scheduled dates for Oracle Java SE Critical Patch Updates are:

  • 16 April 2013
  • 18 June 2013
  • 15 October 2013
  • 14 January 2014
at No comments:
Labels:

Monday, February 13, 2012

path apply information

1)how to check which patch is present?
Ans:-
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.
syntax:-a)opatch  
           b)opatch -napply -skip_subset -skip_duplicate

3)What is the general steps during the patch apply?
Ans:-
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.













at No comments:
Labels:

Wednesday, May 11, 2011

Patch apply steps


Steps for July 2007 security Patch apply  on oracle 10.2.0.4 database

1) Required opatch version  – The required opatch version is 10.2.0.4.8 or higher. This thing you can check from patch read manual.
Check the opatch version and confirm that the patch can be applied
#opatch version

2) Compile all the invalid objects by running utlrp.sql script
SQL> @ORACLE_HOME/rdbms/admin/utlrp.sql

3) Login to each individual databases and Shutdown all the databases
SQL>SHUTDOWN IMMEDIATE

4) shutdown all the listners if it is running.
#lsnrctl stop
#lsnrctl status
5) Ensure no process in the name of oracle running under the oracle bin folder
#fuser -u $ORACLE_HOME/bin/oracle
   if you found any process running under its name then kill that session from its process id.
         #kill -9
6)visit to the patch directory and apply the patch
         #opatch napply -skip_subset   -skip_duplicate
Ensure no errors
7) check the erros if any $ORACLE_HOME/cfgtoologs/catbundle and start the database  and execeute the catbundle script
sqlplus / as sysdba
startup
@catbundle.sql cpu apply
@utlrp.sql
quit

8) Now check in the registry file for any kind of error
  sql>select * from registry$history where id=6452863;

9)now upgrade the database and apply the view_recompile package as bug in the july 2007 patch

$cd $ORACLE_HOME/cpu/view_recompile
sqlplus
shutdown immediate
statup upgrade
@view_recompile_jan2008cpu.sql
shutdown immediate
startup;
quit

10)Compile any invalid objects if found
cd $ORACLE_HOME/rdbms/admin
sqlplus / as sysdba
@utlrp.sql

11) Check any object is invalid. If u found any object in invalid state then recompile it.
example:- alter package compile;
at No comments:
Labels:
Subscribe to: Posts (Atom)