Oracle Expertize
HI All,
Here i am sharing the steps i follow to patchset Oracle from 10.2.0.2 to 10.2.0.4 and activate Oracle enterprise manager
1) Activate OEM in SAP
emca -config dbcontrol db -repos create
Then Provide info as it ask
emctl start dbconsole
then point your browser at http://Srevr_name:5500/em
Note :386413 enterprise manager configuration oracle
592393 – FAQ: Oracle
355770 – Oracle Enterprise Manager Database Control
105047 – Support for Oracle functions in the SAP environmt
2) Note 871096 – Oracle Database 10g: Patch sets/patches for 10.2.0
Note 839187 – Oracle Database 10g: Patch set installation
Note 509314 – Downloading Oracle patches from SAP Service Marketplace
Note 839182 – Oracle database 10g: OPatch
Note 1137346 – Oracle Database 10g: Patches for Release 10.2.0.4
3) Download Patchset From Service Market Place
509314 – Downloading Oracle patches from SAP Service Marketplace====IMP
Sap Provide Patch in .bin format (Here i waste My full Day)
To get the original zip-file back, use the following commmands for:
UNIX cat aa.bin ab.bin … >> .zip
Windows copy aa.bin /B + ab.bin /B + … .zip
4) Now run runinstaller for Patchset before that shutdown DB and all services
5) Post Upgrade Steps:Database upgrade from Release 10.2.0.2 -> 10.2.0.4
When you upgrade a database from Oracle Release 10.2.0.2 to 10.2.0.4, you need to adapt the Oracle Dictionary to the new Oracle version during postprocessing. In this case, catupgrd.sql must run in accordance with the defaults described in the patch set documentation.
dbua -silent -dbname $ORACLE_SID -oracleHome $ORACLE_HOME -sysDBAUserName sys -sysDBAPassword bandhan6 -recompile_invalid_objects true
@/oracle/SID/102_64/rdbms/admin/catupgrd.sql
@/oracle/SID/102_64/rdbms/admin/utlrp.sql
emca -upgrade db
@/oracle/SRP/102_64/rdbms/admin/catupgrd.sql
6) Apply Opatch :Displaying the OPatch version
% opatch version
Displaying the online help
% opatch -help
Displaying the online help for a certain command
% opatch -help
= apply, rollback, lsinventory, util
Displaying the Oracle inventory (see below)
% opatch lsinventory [-all][-detail]
Installing a patch (see below)
% opatch apply
Uninstalling a patch (see below)
% opatch rollback -id
That’s All but you can face different problems while following this so ping me AnyTime:
Regards,
Gagan Deep Kaushal
Oracle Expertize
HI All,
Here i am sharing the steps i follow to patchset Oracle from 10.2.0.2 to 10.2.0.4 and activate Oracle enterprise manager
1) Activate OEM in SAP
emca -config dbcontrol db -repos create
Then Provide info as it ask
emctl start dbconsole
then point your browser at http://Srevr_name:5500/em
Note :386413 enterprise manager configuration oracle
592393 – FAQ: Oracle
355770 – Oracle Enterprise Manager Database Control
105047 – Support for Oracle functions in the SAP environmt
2) Note 871096 – Oracle Database 10g: Patch sets/patches for 10.2.0
Note 839187 – Oracle Database 10g: Patch set installation
Note 509314 – Downloading Oracle patches from SAP Service Marketplace
Note 839182 – Oracle database 10g: OPatch
Note 1137346 – Oracle Database 10g: Patches for Release 10.2.0.4
3) Download Patchset From Service Market Place
509314 – Downloading Oracle patches from SAP Service Marketplace====IMP
Sap Provide Patch in .bin format (Here i waste My full Day)
To get the original zip-file back, use the following commmands for:
UNIX cat aa.bin ab.bin … >> .zip
Windows copy aa.bin /B + ab.bin /B + … .zip
4) Now run runinstaller for Patchset before that shutdown DB and all services
5) Post Upgrade Steps:Database upgrade from Release 10.2.0.2 -> 10.2.0.4
When you upgrade a database from Oracle Release 10.2.0.2 to 10.2.0.4, you need to adapt the Oracle Dictionary to the new Oracle version during postprocessing. In this case, catupgrd.sql must run in accordance with the defaults described in the patch set documentation.
dbua -silent -dbname $ORACLE_SID -oracleHome $ORACLE_HOME -sysDBAUserName sys -sysDBAPassword bandhan6 -recompile_invalid_objects true
@/oracle/SID/102_64/rdbms/admin/catupgrd.sql
@/oracle/SID/102_64/rdbms/admin/utlrp.sql
emca -upgrade db
@/oracle/SRP/102_64/rdbms/admin/catupgrd.sql
6) Apply Opatch :Displaying the OPatch version
% opatch version
Displaying the online help
% opatch -help
Displaying the online help for a certain command
% opatch -help
= apply, rollback, lsinventory, util
Displaying the Oracle inventory (see below)
% opatch lsinventory [-all][-detail]
Installing a patch (see below)
% opatch apply
Uninstalling a patch (see below)
% opatch rollback -id
That’s All but you can face different problems while following this so ping me AnyTime:
Regards,
Gagan Deep Kaushal
-
Archives
- August 2009 (2)
- July 2009 (1)
- May 2009 (2)
- April 2009 (10)
- March 2009 (3)
- February 2009 (1)
- January 2009 (21)
- December 2008 (2)
- November 2008 (12)
- October 2008 (28)
- September 2008 (2)
- May 2008 (7)
-
Categories
- ABAP in SAP
- Activate Add-On in ECC 6.0
- Activate WebGui For SAP
- Add Company Logo in SAP Screen
- Apply Opatch procedure in SAP+Oracle
- Back To Action
- BRTOOL IN SAP
- Central User administration Configuration in SAP
- Configure ADS in SAP Netweaver
- Configure CUA in SAP
- Configure Oracle Entripse Manager In SAP
- Configure Printer in SAP
- Configure solution database in SAP CRM 2007/Solution Manager
- Configure SSO in EP
- CUA configuration
- CUA in SAP
- default url in crm web ui
- Difference Between SAP_ALL and SAP_NEW
- Generate Solution Manager Key
- How do you add your company logo in CRM 2007 WEB UI?
- How to change default log-off url in CRM web ui ??
- How To Change Title of SAP Transaction Code
- How To configure CUA in SAP
- How to find sap transaction codes
- How to List All the T-codes For a Role in SAP ?
- How to Lock or Unlock a Client in SAP ?
- How to send a message to a specific user in sap
- How to use Solution database in Service desk
- Install TOP utility for Solaris
- Installing two Oracle databases on a host
- Intersting Piece of information
- Kernel Update On Unix
- Kernel Update Process
- List All T-codes For a Role
- LOG IN TO BR*TOOL STUDIO
- Long running transport in SAP
- Nahi Bhulunga
- OEM
- Oracle DB parameter tuning
- Oracle DB Performance Issue
- Oracle in SAP
- Oracle Optach
- Oracle Upgrade 10.2.0.2 to 10.2.0.4;OEM
- Oracle upgrade 9.2.0.6 o 10.2.0.4
- Oracle Upgrade From 9i To 10g
- Problem in transport
- Registering a program on the Gateway
- Reset Buffers in sap
- Resize Redolog Groups in Oracle
- Run OS Commands from SAP GUI
- SAP Oracle Parameter fine tuning
- SAP BASIS TRICKS
- SAP BR*TOOL STUDIO
- SAP CUA
- SAP GUI FOR HTML
- SAP Interview Questions
- SAP LIBRARY INSTALLATION
- SAP NOTES
- SAP Notes–That help me a lot
- SAP Performance
- SAP_ALL vs SAP_NEW
- Search and reuse existing solution in Service Desk
- Service Desk Configuration
- Setting Up the Help Center in SAP CRM
- SMS Integration in SAP
- SMS Setting in SAP
- Spam/Saint Update
- Step by Step configuration for SMS integration in SAP
- STMS error
- T-Codes
- T-Codes You Need
- Temporary tablespace in Oracle
- Transactions in SAP
- Troubleshoot With SPAM (At Your Own Risk)
- Unable to read Software Component Versions from SLD
- Uncategorized
- Unforgettable
- Unix Commands
- Welcome
- WHAT IS SAP
- What is the difference between a Transport Domain and a Transport group
-
RSS
Entries RSS
Comments RSS