Critical Patch January 2012 Applied

Hi,

Today i applied Critical Patch January 2012 on our all Production database successfully. 

without any error :) 

http://www.oracle.com/technetwork/topics/security/cpujan2012-366304.html

Applying patch set 11.2.0.3.0 on windows 2003 server

11.2.0.3.0 patchset has been released in Nov-11. 

You can download patch set for windows 2003 from here

 

Why enable maintenance mode

I received email from one of my readers about maintenance mode (oracle application).

Q1: why we need to enable maintenance mode when we are shut down all the application during patching?

A1:  maintenance mode ensure optimal performance and reduce downtime during patching sessions, Autopatch required that enable maintenance mode when apply a patch. 

enabling maintenance mode shut down the workflow business events and set up function security so that oracle functions are unavailable to users.

Q2: Can we apply patch without enable maintenance mode?

A2: Yes, we can apply patch without enable maintenance mode but it is not recommended.

Q3: How to apply patch without enable maintenance mode?

A3: use the following syntax

adpatch options=hotpatch

Critical Patch Update July 2011 for e-Business Suite r12

Oracle released CPU ( Critical Patch Update) July -2011 including E-BUSINESS SUITE.

Kindly use the following link to find out more and how to start and apply the patch on e-biz.

https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1315202.1

Apply Patch Fails with 'Patch ID is null' and Error Code 73

I got this error on 11gr2 ( 11.2.0.1.0).

Clause

Wrong version of opatch,
The patch requires a version of opatch higher than the version used (check the README file of the patch).

Solution:

- Download from My Oracle Support last version of Opatch (patch 6880880)

- Install this patch following instructions from the README file

- Check the version of opatch using:
opatch version

- Use this version of opatch to apply the patch

Java could not be located. OPatch cannot proceed

Hi,

After a very long time i am going to post ... :) , the reason is didn't get time for posting. sorry for that.

Critical Patch Update (CPU) January-2010 released.

I was applying CPU to all our PRODUCTION box.

one of my DEV box (win2k3 + 11gr1) i was getting below error message.

"Java could not be located. OPatch cannot proceed ..."

Java.exe exist in the $JAVA_HOME folder & $JAVA_HOME properly set , but still getting the same message.

There is a small workaround to use "-jdk" and full path of JAVA.EXE.

something like below

%ORACLE_HOME%OPatch>opatch apply -jdk <<{full path of JAVA.EXE}>>

with the "-jdk" parameter opatch will find the JAVA.EXE and executed without error.

Thanks

Critical Patch Update - Jan-2009

After applied the CPU-JAN-09 on Windows 2003 server 10gr2(10.2.0.4.0) I was getting following warning message...

OUI-67078: Interim patch 7584866 is a superset of the patch(es) [ 7386320 ] in OH $ORACLE_HOME

Opatch Session completed with warnings.

After Searched on metalink I found the following Metalink Note: Doc ID: 553244.1

It is just a warnings message...but always review the PATCH log file if there is not ORA- error found it means patch update done successfully.

EXP-00056 + ORA-00932

The following error message i am getting during export operation in 10gr1 on windows platform after apply the cpu october 2008 patch.

EXP-00056: ORACLE error 932 encountered

ORA-00932: inconsistent datatypes: expected BLOB, CLOB got CHAR

When i Search on metalink i found below metalink note: 339938.1

The above problem can be fixed to run the following SQL script as SYSDBA user.

SQL> connect / as sysdba

SQL> @?/rdbms/admin/catmetx.sql

SQL> @?/rdbms/admin/utlrp.sql

Critical Patch Update 2008

Oracle Released Critical Patch Update Security Patch 2008 at 14-oct for the various product.

Check the below link for the full details

Oracle Technology Network: http://www.oracle.com/technology/deploy/security/alerts.htm

Oracle, PeopleSoft and JD Edwards products: http://www.peoplesoft.com/corp/en/support/security_index.jsp

Oracle BEA products: https://support.bea.com/application_content/product_portlets/securityadvisories/index.html

What is Oracle Critical patch update ?

http://www.oracle.com/technology/deploy/security/pdf/cpu_whitepaper.pdf

Oracle Released Critical Patch Update in Every Three months interval. according to that oracle will released next cpu patch at the following dates

January 13, 2009
April 14, 2009
July 14, 2009
Oct 13, 2009

It is almost require to apply on database but some DBA's are not agree with this. so it is depands on production enviourment finally.

Always apply and test cpu at TEST instance before going to production.

I applied CPU patch on the following production instance.

1. 10gr1 (10.1.0.5.0) on windows 2003

2. 10gr2 (10.2.0.4.0) on windows 2003

next week i am going to apply on linux based system for the same version.

Everything done successfully in 10gr2. but i got EXP-00056 + ORA-00932 error in 10gr1 after cpu patch applied during export operation. click here for more details

Database & Patch set Upgrade

Database & patch upgrade is one of the most important work for Database Administrator.

Before going further first understand what are “upgrade” & “migration” & “patch set” & “CPU patch” word.

Upgrade:
Usually use for oracle database upgrade.
Eg: upgrade from oracle 9i to oracle 10g.

Migration:
Usually use for migrate non oracle database to oracle database.
Eg: From SQL server database to oracle database

Patch set:
There are two types of patch upgrade
1. Patch set update
From one oracle version to another oracle version
Eg: oracle 9i to oracle 10g

NOTE: Patch set based on oracle base release
Eg: oracle 10gr1 (10.1.0.2.0) and for 10gr2 (10.2.0.1.0)

2. CPU patch (Critical Patch update)
Patches is apply for fix database bug suppose after apply latest patch set for current release if there is any bug occur then oracle release cpu patches in regular interval to fix those bug.
Eg: oracle 10gr1 base rel: 10.1.0.2.0, Latest Patch set: 10.1.0.5.0, Latest CPU patch: Jan-08 CPU patch for 10.1.0.5.0

NOTE: CPU patch based on latest patch set.
For more info: http://www.oracle.com/technology/deploy/security/alerts.htm
How to upgrade database to oracle 10gr2?

Determine the Upgrade Path to the New Oracle Database 10g Release
http://download.oracle.com/docs/cd/B19306_01/server.102/b14238/preup.htm#i1007814

Before upgrading process we need to define upgrade method
There are four methods to upgrade our database
1. DBUA (Database upgrade assistant)
2. Manually upgrade
3. Export/Import
4. Data copying
http://download.oracle.com/docs/cd/B19306_01/server.102/b14238/preup.htm#i694345
Patch set upgrade example:
1. From oracle 9ir2 (9.2.0.2 to 9.2.0.8) on Windows http://babudba.blogspot.com/2007/11/patch-installation.html
2. From oracle 9ir2 (9.2.0.1 to 9.2.0.7) on Solaris
http://sabdarsyed.blogspot.com/2007/02/upgrade-oracle-database-9201-to-9207-on.html
3. From oracle 10gr1 (10.1.0.2 to 10.1.0.5) on windows
http://dbataj.blogspot.com/2007/06/upgrading-database-from-101020-to.html

4. From oracle 10gr2 (10.2.0.2 to 10.2.0.3) on windows
http://babudba.blogspot.com/2007/11/upgrade-oracle-10202-to-10203.html

5. From oracle 10gr2 (10.2.0.1 to 10.2.0.3) on Linux
http://sabdarsyed.blogspot.com/2007/03/upgrading-oracle-database-server-10g.html

Critical Patch update example:
On Oracle 10gr1 (10.1.0.5.0) patch set
http://dbataj.blogspot.com/2007/06/critical-patch-update.html

Critical Patch Update

Example : Below procedure based on our test enviourment if you follow this instruction please go through README.TXT file comes with PATCH SET.




Patch Installation Procedures for Oracle Database Release 10.1.0.5
Patch Number : p5907304_10105_WINNT.zip



SYSTEM Overview

Platforms : Windows XP SP2
Database : 10.1.0.5.0


OPatch Utility Information


You must use the OPatch utility release 1.0.0.0.57 or later. You can download it from OracleMetaLink with patch 2617419.



Check Oracle Inventory Setup


C:\>set ORACLE_SID=ORCL

C:\>set ORACLE_HOME=c:\oracle\product\10.1.0\db_1

C:\>cd c:\oracle\product\10.1.0\db_1\opatch

C:\Oracle\product\10.1.0\Db_1\OPatch>opatch lsinventory

Oracle Interim Patch Installer version 1.0.0.0.53

Note: if Opatch utility version is <= 1.0.0.0.53 then you have to download OPATCH utility from metalink site.
[output cut]

Oracle Home = c:\oracle\product\10.1.0\db_1
Location of Oracle Universal Installer components = C:\oracle\product\10.1.0\db_
1\oui
Location of OraInstaller.jar = "C:\oracle\product\10.1.0\db_1\oui\jlib"
Oracle Universal Installer shared library = C:\oracle\product\10.1.0\db_1\oui\li
b\win32\oraInstaller.dll
Location of Oracle Inventory Pointer = N/A
Location of Oracle Inventory = C:\oracle\product\10.1.0\db_1\inventory
Path to Java = "C:\oracle\product\10.1.0\db_1\jre\1.4.2\bin\java.exe"
Log file = c:\oracle\product\10.1.0\db_1/.patch_storage//*.log

Creating log file "C:\oracle\product\10.1.0\db_1\.patch_storage\LsInventory__06-
13-2007_20-18-49.log"

Result:


There is no Interim Patch




OPatch succeeded.
OPatch returns with error code = 0



Preinstallation Instructions


1. Ensure that your Oracle Database installation is the same release for which you are applying this patch.


2. Back up the current database that is installed
-->ORACLE_HOME or ORA INVENTORY

3. Perform a clean shutdown of all Oracle services
C:\>net stop OracleServiceORCL
The following services are dependent on the OracleServiceORCL service.
Stopping the OracleServiceORCL service will also stop these services.

OracleDBConsoleorcl

Do you want to continue this operation? (Y/N) [N]: Y
The OracleDBConsoleorcl service is stopping...............
The OracleDBConsoleorcl service was stopped successfully.

The OracleServiceORCL service is stopping...........
The OracleServiceORCL service was stopped successfully.


C:\>net stop OracleServiceCATDB
The OracleServiceCATDB service is stopping......
The OracleServiceCATDB service was stopped successfully.


C:\>LSNRCTL stop

LSNRCTL for 32-bit Windows: Version 10.1.0.5.0 - Production on 13-JUN-2007 20:30
:30

Copyright (c) 1991, 2004, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
The command completed successfully

C:\>net stop OracleCSService

The OracleCSService service was stopped successfully.


C:\>net stop OracleOraDb10g_home1iSQL*Plus
..
The OracleOraDb10g_home1iSQL*Plus service was stopped successfully.




4. Set the PERL5LIB and PATH environment variables to point to Perl in Oracle Home


C:\>set PERL5LIB=C:\oracle\product\10.1.0\db_1\perl\5.6.1\lib;%PERL5LIB%

C:\>set PATH=C:\oracle\product\10.1.0\db_1\perl\5.6.1\bin\MSWin32-x86;%PATH%


5. set ORACLE_HOME variable


C:\>set ORACLE_HOME=c:\oracle\product\10.1.0\db_1


6. Check if the java and jar executables are present in your Oracle Home


-->JAVA = %ORACLE_HOME%\jre\\bin
-->JAR = %ORACLE_HOME%\jdk\bin


7. Go to directory where download the patch



C:\Oracle\product\10.1.0\Db_1\OPatch>opatch apply c:\5907304




Post Installation Instructions



1. Start All Oracle Services.


C:\>net start OracleServiceORCL

C:\>net start OracleServiceCATDB

C:\>set ORACLE_SID=orcl

C:\>emctl start dbconsole

C:\>LSNRCTL start

C:\>net start OracleCSService

C:\>net start OracleOraDb10g_home1iSQL*Plus


2. For each database instance running out of the ORACLE_HOME being patched, connect to the database using SQL*Plus as SYSDBA and run catcpu.sql as follows:


C:\>rem go to CPU directory

C:\>CD C:\oracle\product\10.1.0\db_1\CPU\CPUApr2007

C:\Oracle\product\10.1.0\Db_1\cpu\cpuapr2007>sqlplus /nolog

SQL*Plus: Release 10.1.0.5.0 - Production on Thu Jun 14 08:21:34 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> conn sys as sysdba
Enter password:
Connected.
SQL> select instance_name from v$instance;

INSTANCE_NAME
----------------
orcl

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> STARTUP MIGRATE
ORACLE instance started.

Total System Global Area 356515840 bytes
Fixed Size 789400 bytes
Variable Size 330036328 bytes
Database Buffers 25165824 bytes
Redo Buffers 524288 bytes
Database mounted.
Database opened.

SQL> @CATCPU.SQL

[OUTPUT CUT]

SQL> SHUTDOWN IMMEDIATE;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> quit


If catcpu.sql reports any Invalid Objects, compile the invalid objects as follows


C:\>cd C:\oracle\product\10.1.0\db_1\rdbms\admin

C:\Oracle\product\10.1.0\Db_1\RDBMS\ADMIN>sqlplus /nolog

SQL*Plus: Release 10.1.0.5.0 - Production on Thu Jun 14 08:47:26 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> conn sys as sysdba
Enter password:
Connected to an idle instance.
SQL> STARTUP
ORACLE instance started.

Total System Global Area 356515840 bytes
Fixed Size 789400 bytes
Variable Size 330036328 bytes
Database Buffers 25165824 bytes
Redo Buffers 524288 bytes
Database mounted.
Database opened.

SQL> @utlprp.sql 0

SQL> select OBJECT_NAME from dba_objects where status = 'INVALID';

no rows selected


3. If any databases have been created without using DBCA (that is, using the command line), and you need to monitor such a database by using Oracle Enterprise Manager 10g, follow these steps:


> sqlplus SYS / AS SYSDBA
SQL> ALTER USER DBSNMP ACCOUNT UNLOCK
SQL> PASSWORD DBSNMP
Changing password for DBSNMP
New password: new_password
Retype new password: new_password

Upgrading Database From 10.1.0.2.0 to 10.1.0.5.0

Example : Below procedure based on our test enviourment if you follow this instruction please go through README.TXT file comes with PATCH SET.





Upgrading Oracle Database Server 10g Release 10.1.0.2 to Oracle Database 10g Release 10.1.0.5 on Windows XP Sp2



Patch Set Overview

You can apply the Oracle Database 10g release 10.1.0.5 patch set to the following Oracle Database 10g release 1 (10.1.0.2, 10.1.0.3, or 10.1.0.4) installations.

Oracle Universal Installer Version Requirements

This patch set includes Oracle Universal Installer release 10.1.0.5, which is also installed when you install this patch set.

System Requirements

Hardware requirement : Intel Pentium
OS requirement : Windows XP Prof
Oracle DB : 10gr1(10.1.0.2) or later

Preinstallation Tasks

1. Identify the Oracle Database Installation


This is not a complete software distribution. You must install it in an existing Oracle Database 10g Oracle home.


2. Download and Extract the Installation Software


Download and extract the p4505133_10105_WINNT.zip patch set.


3. Shut Down Oracle Databases


C:\>sqlplus sys@ORCL/pwd as sysdba
SQL>shutdown immediate;

C:\>sqlplus sys@CATDB/pwd as sysdba
SQL>shutdown immediate;


Stop All Services


C:\>net stop OracleOraDb10g_home1iSQL*Plus
..
The OracleOraDb10g_home1iSQL*Plus service was stopped successfully.


C:\>net stop OracleServiceORCL
The following services are dependent on the OracleServiceORCL service.
Stopping the OracleServiceORCL service will also stop these services.

OracleDBConsoleorcl

Do you want to continue this operation? (Y/N) [N]: Y
The OracleDBConsoleorcl service is stopping....
The OracleDBConsoleorcl service was stopped successfully.

The OracleServiceORCL service is stopping.
The OracleServiceORCL service was stopped successfully.

C:\>net stop OracleServiceCATDB
The OracleServiceCATDB service is stopping.......
The OracleServiceCATDB service was stopped successfully.


C:\>LSNRCTL stop

LSNRCTL for 32-bit Windows: Version 10.1.0.2.0 - Production on 13-JUN-2007 16:30
:58

Copyright (c) 1991, 2004, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
The command completed successfully

C:\>net stop OracleCSService

The OracleCSService service was stopped successfully.


Back up the SYSTEM



Installation Tasks


1. Run SETUP.EXE from where you download/extract your patch.





In the Name field in the Destination section, select the 10.1.0.x Oracle home that you want to update from the drop down list, then click Next.





On the Summary screen, click Install.



Upgrading Release 10.1 to Oracle Database 10g Release 1 (10.1.0.5)


1.Check SYSTEM TBS should have 10mb Free Space.
2.SHARED_POOL_SIZE or JAVA_POOL_SIZE at least 150 MB.

SQL> alter tablespace SYSTEM
2 add datafile 'c:\oracle\product\10.1.0\oradata\orcl\system02.dbf' size 20m;


Tablespace altered.

SQL> alter system set SHARED_POOL_SIZE = 150M SCOPE=spfile;

System altered.

SQL> alter system set JAVA_POOL_SIZE = 150M SCOPE=spfile;

System altered.


SQL> SHUTDOWN
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> STARTUP UPGRADE
ORACLE instance started.

Total System Global Area 356515840 bytes
Fixed Size 789400 bytes
Variable Size 330036328 bytes
Database Buffers 25165824 bytes
Redo Buffers 524288 bytes
Database mounted.
Database opened.

SQL> SPOOL patch.log

SQL> @C:\oracle\product\10.1.0\db_1\rdbms\admin\catpatch.sql
DOC>######################################################################
DOC>######################################################################
DOC> The following PL/SQL block will cause an ORA-20000 error and
DOC> terminate the current SQLPLUS session if the user is not SYS.
DOC> Disconnect and reconnect with AS SYSDBA.
DOC>######################################################################
DOC>######################################################################
DOC>#

PL/SQL procedure successfully completed.
....
[OUTPUT CUT]

SQL> SPOOL OFF


Restart the database

SQL>SHUTDOWN
SQL>STARTUP


Run the utlrp.sql script to recompile all invalid PL/SQL packages


SQL> @C:\oracle\product\10.1.0\db_1\rdbms\admin\utlrp.sql


SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.1.0.5.0 - Prod
PL/SQL Release 10.1.0.5.0 - Production
CORE 10.1.0.5.0 Production
TNS for 32-bit Windows: Version 10.1.0.5.0 - Production
NLSRTL Version 10.1.0.5.0 - Production



Known Issues


select dbms_java.full_ncomp_enabled from dual
*
ERROR at line 1:
ORA-29558: JAccelerator (NCOMP) not installed. Refer to Install Guide for
instructions.
ORA-06512: at "SYS.DBMS_JAVA", line 236


IGNORE
---> If you do not use Java in the database, then ignore this error message.

Don't Ignore
--->If you use Java in the database, then install the NCOMP libraries by selecting the Oracle Database 10g Products installation type from the Oracle Database Companion CD.


If RMAN CATALOG is also configure then upgrade RMAN CATALOG


C:\>rman CATALOG=rman/cat@CATDB

Recovery Manager: Release 10.1.0.5.0 - Production

Copyright (c) 1995, 2004, Oracle. All rights reserved.

connected to recovery catalog database

RMAN> UPGRADE CATALOG;

recovery catalog owner is RMAN
enter UPGRADE CATALOG command again to confirm catalog upgrade

RMAN> UPGRADE CATALOG;

recovery catalog upgraded to version 10.01.00
DBMS_RCVMAN package upgraded to version 10.01.00
DBMS_RCVCAT package upgraded to version 10.01.00