|
| Winding Up SSL Implementation in Oracle Apps 11i |
| Tuesday, October 31, 2006 |
|
We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
Today I am winding up SSL configuration in Apps with explanation, Check Previous Post on SSL at
Overview of SSL in Apps http://becomeappsdba.blogspot.com/2006/10/overview-of-ssl-in-oracle-applications.html
Overview of SSL in Apps Web Server http://becomeappsdba.blogspot.com/2006/10/configure-ssl-or-https-for-oracle-apps.html
SSL Configuration on Web Server broad level Steps
1.1 Create Certificates Using openssl (You can try OWM Oracle Wallet Manager as well)
1.2 Change Context File parameters mentioned in previous post mentioned above
1.3 run Autoconfig
1.4 Test Application
For detailed stesp by step guide for implementing SSL on E-Business Suite follow Metalink Note # 123718.1 11i: A Guide to Understanding and Implementing SSL for Oracle Applications
Above note covers SSL for Web Server , Form Server & Database Server , In typical Implementation you can configure SSL just to web server Node.
Few Important Note/Points w.r.t. SSL
SSL with Multiple Middle Tier
1. If you have multiple middle tier like server1, server2 ..serverN with load balancer infront of them & assume load balancer & assume that you access your apps via URL http://teachmeoracle.com which means ServerName in httpd.conf will have value teachmeoracle.com and while generating SSL under create CSR (Certificate Signing Request)phase Common Name should be same as ServerName in httpd.conf
2. You can use same Certificates as long as ServerName in httpd.conf are same
Cloning SSL Instances
If you are cloning already configured SSL to Target Instance, you need to create new Certificates on Target Instance. If target Instance was previously configured with SSL before cloning take a backup of SSL certificates (By Default certificates are in $IAS_ORACLE_HOME/Apache/Apache/certs/apache ssl.crt & ssl.key) and replace them after cloning.
If you are not sure about location of Certificates , check following directive in Context File ( *.xml file )
web_ssl_directory
web_ssl_keyfile
web_ssl_certfile
web_ssl_certchainfile
Performance with SSL
Yes, there be little bit performance degradation with SSL as server take some time to encrypt & decrypt messages/packets between Client & Server but there will not be big performance degradation. If you can't afford performance hits because of SSL you can use
SSL Accelerators
Related Links
123718.1 11i: A Guide to Understanding and Implementing SSL for Oracle Applications
http://becomeappsdba.blogspot.com/2006/10/overview-of-ssl-in-oracle-applications.html
http://becomeappsdba.blogspot.com/2006/10/configure-ssl-or-https-for-oracle-apps.html
Post your comments on how you find this document ...
Was this useful ? Should I explain in more detail or you need step by step guide
Your Feedback & Comment is quite important in Improving Contents on this Site
http://teachmeoracle.com/forum <- Forum Dedicated to Apps DBA's Labels: 11i, ssl |
We have moved to kindly check onLineAppsDBA.com in future
|
|
|
 del.icio.us
¦
 Digg This
¦
 My Yahoo
¦
 Reddit
¦
 BlinkList
¦
 Furl It
¦
Email This
¦
Leave Your Comments
|
posted by Atul Kumar @ 3:17 PM
  |
|
|
|
| Installing 10g Application Server / Fusion Middleware |
| Monday, October 30, 2006 |
|
|
We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
Imp. Note:
Few of you subscribed to email Notification but didn't confirm for this service from Inbox, Click on Verify Link in Inbox/Junk folder else you will not receive mail about new port in your Inbox. For those who are not aware of this , check bottom of this post.
========
Yesterday we discussed about Overview of 10g Application Server (Fusion middleware), If you missed that post you can now check it at
http://becomeappsdba.blogspot.com/2006/10/fusion-middleware-10g-application.html
If you don't understand what is OID, OIDDAS, DIP, SSO, MR or any other component at this minute don't worry . I'll discuss about them in future in detail.
Overview of 10g Application Server Installation
-- infrastructure & Middle Tier Should (MUST) be isntalled under separate Oracle Homes. Though they can be on Same Physical Machine or on different Machines
-- First you have to install Infrastructure Tier then only you can install Middle Tier
-- You can install Portal/Wireless or IM Repository in an existing database (Choose RepCA, Repository Creation Assistance tool for this option. If you are new to 10g AS skip this for time being as this is optional feature)
-- Before Installation, Make sure all prereq. are complete (Check installation Document mentioned at bottom of this page)
-- You can use eDelivery.oracle.com for software or use link http://www.oracle.com/technology/software/htdocs/devlic.html?=/technology/software/products/ias/htdocs/101202.html (Choose right version, suggestion 10.1.2.0.2 if this is Test as E-Business Suite is certified with Portal Version 10.1.4 )
-- For Portal 10.1.4 , you need 10.1.2.0.2 & then Upgrade portal to 10.1.4 (P.S. Portal version is different than Application Server Version)
Options in Installation
While Installing Infrastructure Tier, you will get three options
- Identity Management & Metadata Repository
- Identity Management only
- Metadata Repository only
If you are new select option 1 i.e. IM+MR as option 2 & 3 are for advanced configuration like Infrastructure on Multiple Machines
While Installing Middle Tier, you will again get three options
- J2ee & Webcache
- Portal & Wireless
- Business Intelligence & Forms
BI & Form type Installation include first two options so this selection will include all J2ee, Webcache, Portal, Wireless, BI & Forms
Portal & Wireless include first option so this selection will include J2ee, Webcache, Portal, Wireless
J2ee & Webcache will install only j2ee & webcache. So if you are not aware of at this minute what you want better select option three i.e. Business Intelligence & Forms
Installation Document mentioned below should be enough, if not leave comments & I'll post step by step installation of 10g Application Server.
It takes 5-6 hours installing 10g AS depending on your Server Capacity.
Installation Document
Installation Document from oracle for Application Server version 10.1.2.0.2 is available at
http://download-uk.oracle.com/docs/cd/B14099_19/getstart.htm . Select as per your Operating System
Now you can subscribe Email Notification For New Post on this Site
--Check on right Menu Bar of Page under E-mail Subscription enter your email ID
--click on "subscribe".
--It will open new window to verify (If pop up blocker is enabled , allow for this session)
--You have to type text message displayed on pop up window
--"click on complete subscription".
Final step is to Verify in your mail box that you only asked for Subscription.
Go to your inbox , you should see a mail with Subject "Activate your Email Subscription to:.. "
Open that mail & click on link
like http://www.feedburner.com/fb/a/emailconfirm?id=329104
If you don't see this mail in your inbox then check your Junk eMail Folder
Click on this link
Relax & you will get notification in your mail box as soon I post new Topic here .
 Labels: 10gAS |
We have moved to kindly check onLineAppsDBA.com in future
|
|
|
|
del.icio.us
¦
Digg This
¦
My Yahoo
¦
Reddit
¦
BlinkList
¦
Furl It
¦
Email This
¦
Leave Your Comments
|
| posted by Atul Kumar @ 4:45 PM
|
|
|
|
| Fusion Middleware / 10g Application Server Overview |
| Sunday, October 29, 2006 |
|
|
We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
Industry has started talking about Fusion Middleware & Oracle recently certified 10g Application Server (Portal 10.1.4) with Oracle E-Business Suite so I am discussing overview of Application Server part of Fusion Middleware Family.
Overview of 10g Application Server
10g Application Server Consist of Infrastructure Tier & Middle Tier
What is Infrastructure Tier ?
Infrastructure Tier provides Infrastructure Services to 10g Application Server & consist of following technical components
- Database -> To Store User/Applications Identity Data (Portal,Wireless,OID data)
- OID -> Oracle Internet Directory, to store User Credentials, Schema passwords, Application details & lot more ...
- HTTP Server -> This Web Server (OHS, Oracle HTTP Server) on Infra Tier is used to access SSO (Single Sign-On Server) & OIDDAS (OID Delegated Administrative Services)
- OC4J -> Oracle Container for J2EE (OC4J_Security for SSO), You have additional OC4J_OCA if you have OCA (Oracle Certifying Autority). OCA is Optional component in Infrastructure Tier
What is Middle Tier ?
Middle Tier is tier where application Server & applications logic resides. It consist of following Technical Components
- HTTP Server -> This OHS (Oracle HTTP Server) is separate from above OHS & this is OHS from where users access application Server like portal, wireless, j2ee
- OC4J -> These are container which provide place holder for j2ee or web applications . Applications are deployed on OC4J's. 10g AS comes with default OC4J name "home", you create more OC4J depending on your requirement
- Web Cache -> Web Cache acts as cache for fast response to web server.
Logical Services for Infrastructure Tier
Above was technical components of Infrastructure Tier , Logically Infrastructure Tier consist of Two main categories which are
Identity Management
&
Metadata Repository
What is Metadata Repository ?
MR is similar to Database Metadata & MR you can further classify as
Metadata repository for Products (Like Portal, Wireless, BI) This MR usually is user data. Lets assume I created some pages, documents in Portal or User entered some data in any application , such data when stored in database is called as Product MR
MR for OID - Oracle Internet Directory contain some data & data related to this , one can classify as MR for IM (as OID is part of Identity Management - discussed later)
MR for SSO - Oracle Single Sign-On data & schema definitions , one can classify as MR for IM (as SSO is part of IM)
So broadly there are three kind of MR (that's how I classify MR)
What is Identity Management ?
Logical Grouping of Services which help in Managing Identity is called as Identity Management.
Identity management Consist of following Services like (Discussed later in Detail)
- OID Oracle Internet Directory
- DAS Delegated Administrative Services
- DIP Directory Integration & Provisioning Services
- SSO Single Sign-On Service
- OCA Oracle Certifying Authority
Explanation of these Services, why they are required & one example of all these services ..
Plus how to Install 10g Application Server , Where to find Document .....
Coming in Future Posts...
Important Note :
Subscribe for Updates Via Email
Now you can subscribe to this Blog via email : Check on right Menu Bar of Page under E-mail Subscription enter your email ID & click on "subscribe". It will open new window to verify (If pop up blocker is enabled , allow for this session)You have to type text message displayed on pop up window , "click on complete subscription".
Final step is to Verify in your mail box that you only asked for Subscription.
Go to your inbox , you should see a mail with Subject "Activate your Email Subscription to:.. "
Open that mail & click on link like
http://www.feedburner.com/fb/a/emailconfirm?id=329104&key=ost3uANgdy6Ryj04asmMUg%3D%3D
If you don't see this mail in your inbox then check your Junk eMail Folder
Relax & you will get notification in your mail box as soon I post new Topic here .
Labels: 10gAS, basics |
We have moved to kindly check onLineAppsDBA.com in future
|
|
|
|
del.icio.us
¦
Digg This
¦
My Yahoo
¦
Reddit
¦
BlinkList
¦
Furl It
¦
Email This
¦
Leave Your Comments
|
| posted by Atul Kumar @ 12:00 AM
|
|
|
|
| Oracle Apps DBA Forum Administrator |
| Friday, October 27, 2006 |
|
|
We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
As you all might be aware that now we all have Forum dedicated to Oracle Apps DBA's at http://teachmeoracle.com/forum
I would take this opportunity to Introduce Ramnik Gupta to you all. Ramnik is contributor to Site http://teachmeoracle.com dedicated to Apps DBA. He has worked extensively on database from version 6,7,8i,9i including 10g and 10+ years of Exp. in E-Business Suite(10.7,11.0.3 & 11i) as Apps DBA. Ramnik will be answering & administering your questions/doubts/issues at forum http://teachmeoracle.com/forum .
I would like to thank all my readers & all those mailed me with content,questions,scripts for there continuous support. If you wish to submit scripts, contents or any useful information for Apps DBA's you can mail me at atul_iiit@yahoo.com .
what's different in Forum at site http://teachmeoracle.com/forum ?
- Best Apps DBA's to answer your queries/questions/problems
- Equal say to all in way you want to run this Forum
- Dedicated to Apps DBA's
- Apps DBA Job, training information, Certification information
- centralized location to find everything an Apps DBA need
Lot more coming on this site
Workflow Mailer, Configuring 10g AS Portal with Apps, RAC setup with E-business Suite, Fusion Middleware, Oracle Internet Directory, SSO configuration, Monitoring Apps with Grid Via OEM-OAM plugin ....
If you wish to submit any information or if you wish to contribute in building Site more useful to Apps DBA's then feel free to mail me. Labels: blogroll, others |
We have moved to kindly check onLineAppsDBA.com in future
|
|
|
|
del.icio.us
¦
Digg This
¦
My Yahoo
¦
Reddit
¦
BlinkList
¦
Furl It
¦
Email This
¦
Leave Your Comments
|
| posted by Atul Kumar @ 9:52 PM
|
|
|
|
| Troubleshooting Concurrent Managers |
| Monday, October 23, 2006 |
|
|
We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
Lets today focus on Concurrent Manager & Issues related to concurrent Manager & how to fix them .
First of all you should be familiar with Concurrent manager concepts , if you wish to know more about CM check few links at my site http://TeachMeOracle.com
http://teachmeoracle.com/cm.html
http://teachmeoracle.com/cm02.html
In above links you can find overview of CM, How to Start/Stop CM , parameters like CONCSUB, DISPLAY, SLEEP, PMON, QUESIZ ...
At http://teachmeoracle.com/cm03.html you can find basic overview of Troubleshooting Concurrent Manager
Lets classify how to start troubleshooting CM
Issues related to startup/shutdown of CM
If you try to start CM using adcmctl.sh or adstrtall.sh script & you encounter problem in starting CM then check for log files. All information related to why Concurrent Manager not coming up is recorder in log file at $APPLCSF/$APPLLOG with default name as $SID_$DD ( where DD is date on which you started Concurrent Manager ). This Concurrent Manager naming convention will be listed in file adcmctl.sh file (Concurrent Manager startup file). If $APPLCSF is not set then you can look for this file in $FND_TOP$APPLLOG
ICM is Up but some managers are still down
As you know adcmctl.sh script starts ICM (Internal Concurrent Manager) and its duty of ICM to start other Managers. If you see ICM is up with some other managers & Issue is with only Particular Managers then look for log files of these managers .
Concurrent -> Manager -> Administer -> Select manager which is not starting -> Click on "Processes" -> Click on "Manager Log" to find out error message.
These individual manager log file, you can access under $APPLCSF/$APPLLOG directory as well.
If you error message is not enough to find out cause of problem then you can enable debug on CM log files . You can enable diagnostics by changing DIAG_PARAM="" to DIAG_PARAM="Y" in adcmctl.sh (CM Startup script file)
Other things you can try for CM startup Issues :
Try to bounce CM & see all FNDLIBR processes are cleared before restrarting CM. You can run cmclean.sql command to clear any Invalid State against any request or manager. Check for any messages in log file. Check status of Manager from administer Concurrent Manager Window.
Concurrent -> Manager -> Administer (Login as System Administrator Responsibility)
More on CM Troubleshooting ..
Commonly faced issues in CM ..
Coming Soon
If you can't figure out or if there is any problem with Single Manager or all Concurrent Manager then you can raise this question in Forum http://teachmeoracle.com/forum under Concurrent Manager Section & I'll respond immediately (You need to register just once to raise your issues in Forum)
So raise as many questions you wish in Forum dedicated to Apps DBA's at
....................... http://teachmeoracle.com/forum .......................Labels: troubleshooting |
We have moved to kindly check onLineAppsDBA.com in future
|
|
|
|
del.icio.us
¦
Digg This
¦
My Yahoo
¦
Reddit
¦
BlinkList
¦
Furl It
¦
Email This
¦
Leave Your Comments
|
| posted by Atul Kumar @ 3:12 PM
|
|
|
|
| Troubleshoot Oracle Apps Web Server and Login Issues |
| Wednesday, October 18, 2006 |
|
|
We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
If you are accessing this page directly without looking at previous post on Web Server log files & basics then my suggestions are that you first go through link
http://becomeappsdba.blogspot.com/2006/10/oracle-apps-web-server-apache-login.html
Now by looking at error_log, jserv.log, mod_jserv.log you can find out error message & depending on error message you can try Metalink or Search engine for related error message encountered by others in past.
Most of the issues happen because of change so try to focus on what changed recently ( See if anything related to change is related) . Once you get first page http://hostname.domain:port
then there are few automated tool, scripts to check login issues.
If you don't get first page even i.e. http://hostname.domain:port then focus on error_log. error_log_pls in Apache/Apache/logs and jserv.log , mod_jserv.log in Apache/Jserv/logs
Once you get first page then when you try to login to application & login is not working then this can be because of number of reasons. In order to understand this you need to understand request flow in Apps . I posted about request flow in August and you can check link at
http://becomeappsdba.blogspot.com/2006/08/oracle-applications-request-flow.html
In order to authenticate your user against database in FND_USER table this request is passed from core Apache Module to mod_pls ( plsql) and it uses few files like wdbsvr.app in Apache/modplsql/conf $CONTEXT_NAME.dbc , tnsnames.ora in 806/network/admin/$CONTEXT_NAME , GUEST user & few other file so focus on these files & directories & see what changed recently. These are quite important and thats why you often these questions in apps dba interview .
Lot of you discussed about difference between GUEST & APPLSYSPUB account ( Both are Public User accounts with very basic access for authentication ). These both are defined in .dbc file under FND_SECURE one for Thin JDBC connection & another for Thick client .
If you can't login to oracle application by clicking on login link , check if
--- dbc file in FND_SECURE is correct.
--- APPL_SERVER_ID in dbc file matches with server ID in FND_NODES table against respective Server
--- GUEST/ORACLE password is correct & user is not end dated
--- APPS password is correct in wdbsvr.app file
--- Check http://hostname.domainnamel:port/pls/$SID and see if package fnd_web can ping & you get output in screen from FND_WEB.ping with correct database_id ( and check if there is correct dbc file in FND_SECURE with name $DATABASE_ID.dbc )
There is JSP tool test to find most of issues via
http://host.domain:port/OA_HTML/jsp/fnd/aoljtest.jsp
Apart from this if you have Metalink access there is very good note at metalink which you can refer
342332.1 Troubleshooting Login Problems in Oracle Applications 11i (11.5.2 Â 11.5.10+)
Tell me if you find this information Useful by leaving your comments .Labels: 11i, troubleshooting |
We have moved to kindly check onLineAppsDBA.com in future
|
|
|
|
del.icio.us
¦
Digg This
¦
My Yahoo
¦
Reddit
¦
BlinkList
¦
Furl It
¦
Email This
¦
Leave Your Comments
|
| posted by Atul Kumar @ 5:13 PM
|
|
|
|
| Applying CPU patches on AS Middle Tier and E-Business Suite |
| Friday, October 13, 2006 |
|
|
We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
Previous Updates you should Read
==========================
Overview of CPU
Apply July CPU / Security Patch
Applying Oracle CPU Patch on Database & Infrastructure Tier
Lets start from where we left last , so we applied CPU i.e. July Security Patch on Standalone database & on Infrastructure database . Now today we will apply on Middle Tier & then on E-Business Suite 11i.
1.3.3 Apply Application Server patch on Middle Tier
--Patch number mentioned here are for Middle Tier version 10.1.2.0.2
-- The patch number for 10g Middle tier is 5249970 but in order to apply this patch you should be on opatch version 1.0.0.0.55 . If you are not sure how to check opatch version Click Here
-- Apply opatch version 1.0.0.0.55 patch
-- Install Patch 5249970 assume you have downloaded patch at /u01/patch/cpu/jul06/5249970 then go to that directory and
-- opatch apply (If you encounter opatch not found then include it in path like export PATH=$PATH/$ORACLE_HOME/OPatch as opatch is in $OH/OPatch Directory)
As mentioned in my previous post it will complain that
MISSING_COMPONENT : oracle.rsf.rdbms_rsf, 10.1.0.5.0
or
MISSING_COMPONENT : oracle.rsf.rdbms_rsf, 10.1.0.4.0 Depending on your infrastructure Database Version .
If you ever wonder why Middle Tier is complaining about database component i.e. rdbms then check metalink note 338338.1 (This is self explanatory, if you don't understand this note then leave comment here and I'll explain detail )
Now apply database patch ( 10.1.0.5.0 or 10.1.0.4.2 depending on what error message you get above - You need to apply software part only i.e. ./runInstaller) after that
-- cd /u01/patch/cpu/jul06/5249970
-- opatch apply
You should see OPatch succeeded Then
-- sh /u01/patch/cpu/jul06/5249970/cpu_root.sh from root
This Completes your Application Server CPU or Security Patches for July
Hey its not finished yet , we are left with E-Business Suite , Collaboration Jul Patch and held on this is not enough Oracle October Security / CPU Patch are scheduled to release on Monday . I don't know if you are tired of reading CPU patches this whole week but atleast I am sick of writing on CPU , though applying CPU might be just 2-3 hours Job but believe me Understanding them & documenting them is big pain.
I need your feedback / comments on CPU, I updated here and in my previous Updates & based on feedback I am going to write on CPU for Oracle Apps or E-Business Suite .Labels: 10gAS, patching |
We have moved to kindly check onLineAppsDBA.com in future
|
|
|
|
del.icio.us
¦
Digg This
¦
My Yahoo
¦
Reddit
¦
BlinkList
¦
Furl It
¦
Email This
¦
Leave Your Comments
|
| posted by Atul Kumar @ 4:35 PM
|
|
|
|
| Oracle Apps DBA Interview Questions |
| Thursday, October 12, 2006 |
|
|
We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
I was quite busy for last two days so I couldn't write on CPU patch for Middle tier & E-Business Suite (Apps) but I'll try to complete it by tomorrow or by this weekend.
Next week I'll focus on troubleshooting Oracle Application(web server, forms,Concurrent) including login issues.
For those who are looking for Oracle Apps DBA Jobs , I have listed 100+ interview questions for Apps DBA's with answers . Most of them sent by those who appeared in Interview for Apps DBA.
# All These Questions are Copyright Protected so don't copy & paste on any other site. You can Refer link on other site #
Here are few links
http://teachmeoracle.com/interview.html
Concurrent Manager Questions, apps web config file
http://teachmeoracle.com/interview03.html
# All These Questions are Copyright Protected so don't copy & paste on any other site. You can Refer link on other site #
Few on cloning , patching, ad utility interview Questions
http://teachmeoracle.com/interview04.html
At bottom of page there is nevigation path and there are in total 23 pages in Interview section .
I realised that few answers I forgot to answer which I'll do as soon as I get some time as on page
I want to thank each one of you who sent me Interview questions.
If you want to send Interview Questions which you don't see on site then mail me at atul_iiit@yahoo.com
Senthil I need to update questions which you sent me few days ago (Thanks a lot to you & good luck with your future projetcs)
Few questions are at
http://teachmeoracle.com/interview18.html
http://teachmeoracle.com/interview22.html
To nevigate to different pages there is Next Page & Previous Page link at bottom of all pages.
One Suggestion for aspiring Apps DBA's please don't remember these questions but try to understand apps by these questions.
Good Luck for your Interview .
# All These Questions are Copyright Protected so don't copy & paste on any other site, You can Refer link on other site. # Labels: blogroll, jobs, others |
We have moved to kindly check onLineAppsDBA.com in future
|
|
|
|
del.icio.us
¦
Digg This
¦
My Yahoo
¦
Reddit
¦
BlinkList
¦
Furl It
¦
Email This
¦
Leave Your Comments
|
| posted by Atul Kumar @ 6:49 PM
|
|
|
|
| Apply Oracle July CPU patch |
| Monday, October 09, 2006 |
|
|
We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
Last month, I Posted about Oracle CPU Patches also called as Critical patch Update or security Patch Update.
You can access that Post or Overview of CPU from below link
http://becomeappsdba.blogspot.com/2006/09/oracle-critical-patch-updates-and.html
Today & in my future posts I am going to cover How to Apply these patches in your Applications. You might be having following applications
Oracle Application Server ( 9i , 10g )
Oracle Collaboration Suite ( 9i or 10g )
Oracle E-Business Suite ( 11i )
Standalone Database (8i, 9i, 10g)
The Steps Mentioned in today's post are specific to Jul 2006 CPU patches for Application Server . This Oct. ( Mid of Month ) Oracle is going to release CPU for Oct 2006 and I'll Update you as and when they are out.
Common things to remember in almost all of CPU Patches
Order of CPU Patch
First Database
Then Application Tier
Previous CPU Patches
E-Business Suite Patches are non cumulative
Application Server, Database or Collaboration Suite CPU patches are cumulative .
1. Applying JUL CPU for 10g Application Server ( Ver. 10.1.2.0.2)
1.1 Assumptions while applying patch
Steps mentioned here are for 10g R2 Application Server version 10.1.2.0.2
Portal Schema Content is stored in separate Database Version 10.2.0.1
OID & SSO Database is stored in Database Version 10.1.0.5
Infrastructure Tier is on separate Host then Middle Tier
Middle Tier & Infrastructure Tier both are on version 10.1.2.0.2
In my application architecture , I have three oracle homes , two on machine1 ( oh_1 for database 10.2.0.1 , oh_2 for infrastructure home with another database 10.1.0.5) , third oracle home on machine2 ( oh_3 application Server Middle Tier)
Don't forget to backup before applying patch as fall back plan
Reference are taken from metalink note # 372930.1
1.2 Order of patches
Based on my configuration my order of patch application will be first database patch on oh_1 for db 10.2.0.1 on machine1
Then apply Infrastructure patch on oh_2 on machine1
Finally apply middle tier patch on oh_3 on machine2
1.3 Exact Steps for applying patches
1.3.1 Apply Database 10.2.0.1 patch
- Login to machine1 under oracle_home1 & need to apply database patch for db version 10.2.0.1 and patch number is 5225798 (This is for Unix) if you are on windows you need 5239698 for 32 bit Windows. If you are on 10.1.0.5 patch # is 5225797 & so on ... ( Check Note # mentioned above for exact patch Number )
- Download patch & shutdown services
- Lets assume you have downloaded patch to /u01/patch/cpu/jul06/5225798 then go to this directory & follow readme.txt ( Steps mentioned here from readme.txt)
- opatch apply (If you encounter opatch not found then include it in path like export PATH=$PATH/$ORACLE_HOME/OPatch as opatch is in $OH/OPatch Directory)
You should see OPatch succeeded
Then
cd $ORACLE_HOME/cpu/CPUJul2006
sqlplus "/as sysdba"
SQL> startup ( Start database )
SQL> spool catcpu.log (to store output of catcpu.sql in log file)
SQL> @catcpu.sql
and this complete your patch on standalone PORTAL repository database.
Same way you have to apply Jul CPU patch on standalone database .
* If your database version is different than 10.2.0.1 then patch number will vary so check note# mentioned above .
How to Apply CPU patch on Application Server Infrastructure Tier, Middle Tier ..
How to Apply CPU patch on Collaboration Suite Infrastructure & Middle Tier ..
How to apply CPU July patch on E-Business Suite ...
Coming in Next Post .......Labels: patching |
We have moved to kindly check onLineAppsDBA.com in future
|
|
|
|
del.icio.us
¦
Digg This
¦
My Yahoo
¦
Reddit
¦
BlinkList
¦
Furl It
¦
Email This
¦
Leave Your Comments
|
| posted by Atul Kumar @ 5:26 PM
|
|
|
|
| Autoconfig in Apps template files Contd.... |
| Friday, October 06, 2006 |
|
|
We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
If you are reading Autoconfig post on this site read my previous post to understand about Autoconfig
Autoconfig Basics
Unwrapping Autoconfig Config file, XML file or Context File
Autoconfig Questions on My Site
Now lets understand how Autoconfig populate/creates files , In order to understand whole process you as apps dba need to understand template files under each product top or tech stack directory in oracle Applications 11i.
These template directory are under each top as well as under $FND_TOP/admin/template . In order to explain here I am taking example on how Apache (Oracle Web Server) related files are created when you run Autoconfig.
If you go to $FND_TOP/admin/template directory, all template files related to iAS ORACLE HOME like http.conf , jserv.conf, zone.properties .. are stored in this their respective directories under template directory.
So template file to create httpd.conf is stored in $FND_TOP/admin/template
similarly template file for jserv.conf will be in
$FND_TOP/admin/template
In these directories you will see file like httpd.conf or jserv.conf with parameter like
ApJServGroup OACoreGroup 1 1 %s_weboh_oh%/Apache/Jserv/etc/jserv.properties (in jserv.conf under template directory)
or
ServerAdmin applmgr@%s_domainname% ( in httpd.conf under template directory)
Now when Autoconfig executes , its picks up these files & replaces parameters like
%s_weboh_oh% & %s_domainname% from Autoconfig Configuration File i.e. Context file or XML file of format SID_HOSTNAME.xml (Discussed in previous post)
So in my case for vision instance in xml file has these values
s_weboh_oh is /u01/applmgr/VIS11i/ora9/iAS
s_domainname is co.in
that's how all my configuration files are created on execution of Autoconfig .
Now there is one issue on executing Autoconfig file i.e. If you have put in some customization in any of these files it will be overwritten by Autoconfig.
How to preserve customization ...
important parameter/tags in xml context file
How to change Hostname or Domain name of Apps Server
Coming in future posts ....
Related :
http://becomeappsdba.blogspot.com/2007/09/preserving-customizations-in-oracle.html Labels: 11i, autoconfig, customization |
We have moved to kindly check onLineAppsDBA.com in future
|
|
|
|
del.icio.us
¦
Digg This
¦
My Yahoo
¦
Reddit
¦
BlinkList
¦
Furl It
¦
Email This
¦
Leave Your Comments
|
| posted by Atul Kumar @ 2:55 PM
|
|
|
|
| Unwrapping XML , Context File or Autoconfig configuration file |
| Thursday, October 05, 2006 |
|
|
We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
Yesterday I discussed about Autoconfig & way to execute it on DB Tier & Application Tier on Oracle Applications 11i.
By now you might be aware that parameters used to configure oracle Applications 11i are stored in XML file of format SID_HOSTNAME.xml in $APPL_TOP/admin directory. I have seen that most of Apps DBA's are scared of executing Autoconfig or Context file (Believe me even I was in start that was way back in 2004) but if you know parameters associated with context file & if you are sure that its set correctly set you should not be worried about executing Autoconfig ( Even still you are not convinced take a back up of File System & execute it ).
I am going to discuss how well this xml file is configured & what are different tags in xml file & few important tags which will be helpful to you in understanding your oracle Applications from Apps DBA perspective .
So xml file also called as context file or autoconfig configuration file stores configuration in these main tags for Application Tier
---
oa_context : For Start of Context file & context related information
oa_system : System related information under this there are further sections which I'll discuss in next post
oa_host : Information specific to local hosts like users, groups, Apps User, Groups..
oa_install : Installation related information like type of FS, Installation Location
oa_environments : environment specific information this tag has further subsections
oa_processes : this section is related to processes for forms, apache, reports, cm i.e. for all services
oa_custom : This section contain any custom setting (If any)
I'll explain subsections under this main section in my coming posts & few important parameters
Similar broad section you will see in Database XML files as well but different sub section & different tags under that specific to database .
Few Important tags in XML file ....
How to preserve customizations from Autoconfig ...
How to create or edit Autoconfig XML file ...
Coming in future posts
I have huge pile up of mails so If I haven't responded to your mail yet, thanks for your patience I'll surely try to respond during this weekend on FCFS basis.
Send me feedback & things you want to hear from me. |
We have moved to kindly check onLineAppsDBA.com in future
|
|
|
|
del.icio.us
¦
Digg This
¦
My Yahoo
¦
Reddit
¦
BlinkList
¦
Furl It
¦
Email This
¦
Leave Your Comments
|
| posted by Atul Kumar @ 5:18 PM
|
|
|
|
|
|
