Register for Apps DBA Training
For Apps DBA Beginner's
  • Start From Here
  • Order of Apps Study
  • 11i Software
  • Apps Architecture
  • Install Apps 11i
  • Install Apps 11i Part II
  • Startup/Shutdown
  • Request Flow in Apps
  • Various TOP's
  • Cloning Basics
  • Cloning I
  • Cloning II
  • Autoconfig Basics
  • Autoconfig Config File
  • Template Files in Autoconfig
  • Discoverer Overview
  • Workflow Mailer in Apps
  • Printing Overview
  • Configuring Printers
  • Pasta Printing
  • Performance Overview
  • Install 10g Application Server
  • Apps DBA Certification
  • Common DBA Topics
  • Scared of RAC ?
  • Install RAC on your laptop part I
  • Step by Step build RAC part II
  • Step by Step install RAC using VMWare part III
  • Install Oracle RAC Database part IV
  • oraInventory Basics
  • Install Database 10.2.0.1
  • Upgarde DB to 10.2.0.2
  • Fusion
  • Is Fusion a conFusion ?
  • Fusion Middleware Overview I
  • Fusion Middleware Overview II
  • Application Integration Architecture
  • SOA Install Part I
  • SOA Install Part II
  • SOA Install Part III
  • Install BPEL Process Manager
  • Apps Integration OID/SSO
  • Management Qs for Apps Integration with SSO/OID
  • 25 things your DBA should know for Apps/SSO integration
  • Identity Management
  • COREid Overview
  • Oracle COREid or Idm & Access Mgmt overview
  • Installing Access Manager 10.1.4
  • WebGate request flow
  • Identity Manager Architecture
  • Installing Identity Manager
  • OAS-SSO Overview
  • OID Overview
  • OID Basics II
  • OID Cluster
  • OID Integration with Other LDAP Servers overview
  • Integrate OID with AD I
  • OID Replication Overview
  • Multi Master OID Replication
  • Migrate OID/SSO to new Host
  • Apps R 12
  • Socket or Servlet in R12
  • Startup/Shutdown Scripts in R12
  • Unified APPL_TOP
  • Apps R 12.0.1
  • Difference between 11i & R12 Technical
  • Prepare for R12 Installation
  • Install VMWare on Windows for Linux Install
  • Install Linux for Apps R12 Install
  • Install Apps R12 on Linux Virtual Machine
  • R12 Upgrade & database
  • R12 Fils System Changes
  • R12 Release Date
  • 10g Application Server
  • 10g AS Overview
  • Installing 10g AS
  • Start/Stop 10g AS
  • Web Cache Basics
  • Single Sign-On Overview
  • OID Overview
  • Cloning 10g AS
  • 10g AS Middle tier Cloning & Overview
  • OID Cluster Imp. Points
  • CPU Patch, Infra Tier
  • CPU Patch, Middle Tier
  • AS Guard / DR Overview
  • Oracle Apps 11i
  • My Site
  • Apps DBA Scripts
  • Apps DBA Interview Q's
  • 11i JVM's
  • Apps Training in India
  • 11i Health Check
  • Good Metalink Notes
  • About Me  
  • For Advanced Apps DBA
  • URL Firewall in DMZ Setup
  • Upgrade Apps to 11.5.10.2
  • Load Balancer Overview
  • Load Balancer Config
  • HTTP layer Load balancing in Apps 11i
  • Dataguard Overview
  • Configure Dataguard / Standby database
  • Standby Site for Apps 11i
  • How to change Hostname on Apps Instance
  • SSL Overview in Apps
  • Configure SSL to Web Server
  • Key Points for SSL in Apps
  • Reduce Patch Timing
  • Reduce Patch Timing II
  • Shared APPL_TOP Overview
  • Configure Shared APPL_TOP
  • 11i Database Upgrade I
  • 11i Database Upgrade II
  • Change Session TimeOut
  • Patching
  • Apps Patch Basics
  • Apps Patch Basics II
  • Apply Apps Patch
  • CPU Overview
  • Steps to Apply CPU Patch
  • CPU Patch on Infra Tier
  • CPU Patch on AS Middle Tier
  • Troubleshooting
  • Web Server TS Part I
  • Web Server TS Part II
  • CM Troubleshooting
  • 10g Discoverer with Apps
  • Discoverer Bascis in Apps
  • Discoverer 10g Upgarde Basics
  • Discoverer 10g Configuration Steps with 11i
  • Collaboration Suite
  • Collaboration Suite
  • Calendar Overview
  • Sync Calendar from Mobile I
  • Sync Calendar from Mobile II
  • OCS Mail Architecture
  • Apex / HTMLDB
  • Install Apex 2.2
  • Apex with SSO part I
  • Apex with SSO part II
  • SSO Authentication Schemes
  • Certification
  • Possible Certifications for DBA
  • Apps DBA Certification
  • 1Z0-311-OCA-10g OAS Overview
  • 1z0-312-OCP-10g OAS Overview
  • 1z0-312 - Managing Customization and Topology
  • 1z0-312 - Cloning and Staging OAS
  • Apps DBA Jobs
  • Working / Apps DBA in UK
  • Oracle Recruiting Apps DBA's
  • Apps DBA Jobs Updated Regularly
  • Apps Job at Satyam
  • Useful Links
  • Good Metalink Notes
  • petefinnigan's Oracle Security
  • Linux Basics
  • Atul Mehta's Oracle Links
  • Others
  • Apps DBA Training Institute
  • 1 Year Journey of this Blog
  • How To ?
  • Change APPS Password
  • Preserve Customizations
  • Blog Roll
    Apps / E-Business Suite
  • Steven Chan Apps
  • Anil Passi Technical
  • Fadi Apps DBA
  • Senthil Apps DBA
  • Bas Klaassen EBS DBA
  • Sam Apps DBA
  • Black Geek Apps DBA
  • Bandari Apps
  • Vikram ERP Architect
  • OraBiz
  • Eric Core DBA
  • SOA
  • Navdeep Saini Apps DBA
  • tugdualgrall Web Services
  • Mohan Dutt's Apps Certification
    IdM
  • Nishant Kaushik's IdM
  • Nulli Blog, OAM
  • Identity Musing
  • Identity nd Access Management
    Core DBA
  • Vidya Bala DBA
  • Sabdar DBA
    Data Management
  • Ivan Pellegrin Data Management


  • We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
    Winding Up SSL Implementation in Oracle Apps 11i
    Tuesday, October 31, 2006
    Register for R12 upgrade
    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: ,


    We have moved to

    http://onlineAppsDBA.com

    kindly check onLineAppsDBA.com in future

    add to del.icio.usdel.icio.us  ¦  digg thisDigg This  ¦  My Yahoo!My Yahoo  ¦  RedditReddit  ¦  add to BlinkListBlinkList   ¦  Furl ItFurl It  ¦  Email This Email This  ¦     Leave Your Comments
    posted by Atul Kumar @ 3:17 PM   8 Comments


    We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
    Installing 10g Application Server / Fusion Middleware
    Monday, October 30, 2006
    Register for R12 upgrade
    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 .

    Become Apps DBA

    Labels:


    We have moved to

    http://onlineAppsDBA.com

    kindly check onLineAppsDBA.com in future

    add to del.icio.usdel.icio.us  ¦  digg thisDigg This  ¦  My Yahoo!My Yahoo  ¦  RedditReddit  ¦  add to BlinkListBlinkList   ¦  Furl ItFurl It  ¦  Email This Email This  ¦     Leave Your Comments
    posted by Atul Kumar @ 4:45 PM   9 Comments


    We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
    Fusion Middleware / 10g Application Server Overview
    Sunday, October 29, 2006
    Register for R12 upgrade
    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: ,


    We have moved to

    http://onlineAppsDBA.com

    kindly check onLineAppsDBA.com in future

    add to del.icio.usdel.icio.us  ¦  digg thisDigg This  ¦  My Yahoo!My Yahoo  ¦  RedditReddit  ¦  add to BlinkListBlinkList   ¦  Furl ItFurl It  ¦  Email This Email This  ¦     Leave Your Comments
    posted by Atul Kumar @ 12:00 AM   20 Comments


    We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
    Oracle Apps DBA Forum Administrator
    Friday, October 27, 2006
    Register for R12 upgrade

    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: ,


    We have moved to

    http://onlineAppsDBA.com

    kindly check onLineAppsDBA.com in future

    add to del.icio.usdel.icio.us  ¦  digg thisDigg This  ¦  My Yahoo!My Yahoo  ¦  RedditReddit  ¦  add to BlinkListBlinkList   ¦  Furl ItFurl It  ¦  Email This Email This  ¦     Leave Your Comments
    posted by Atul Kumar @ 9:52 PM   3 Comments


    We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
    Configure SSL or HTTPS for Oracle Apps 11i
    Thursday, October 26, 2006
    Register for R12 upgrade
    Yesterday we looked at SSL overview in Oracle Applications 11i, you can look at that post from link

    http://becomeappsdba.blogspot.com/2006/10/overview-of-ssl-in-oracle-applications.html

    Lets continue with where we left yesterday

    What happens when we enable SSL in Oracle Web Server ?
    I am assuming that SSL is already enabled at web server , so you type url with protocol as https (where s stands for Secure ), web server understand that this is SSL request so Web Server sends its certificates back to client stating its identity & with that its send a Public key which your browser use to encrypt & decrypt message send by Web Server . Web Server uses its private key(known to itself only, stored in either wallet or ssl directory discussed later in this post) & public key(key which is known to everyone) to encrypt & decrypt messages. SSL has build in feature which assures that data is not tempered with its from valid source . If you don't understand all this at this minute don't worry you still can configure SSL. This entire concept is called as PKI (Publick Key Infrastructure)

    Myth about SSL Port in webserver ?
    Do I need to only Use on port 443 for Web Server SSL Port ?? not at all , port 443 is standard port for HTTPS as port 80 for HTTP. You can use HTTPS on any port as long as port is listening for HTTPS requests .

    Overview of Steps in configuring SSL over Web Server in Oracle Apps 11i ?
    I am mentioning over view of configuring SSL on web server in Oracle Applications (If you wish to configure SSL for Forms Server & Database Servers ) Steps mentioned here are for Autoconfig Enabled system & Apache 1.0.2.2.2 and higher (If you are not aware of your Apache/httpd version check here http://teachmeoracle.com/version.html)
    1. Create your SSL Certificates (I'll cover later how to generate SSL certificates for Web Server)
    2. Configure SSL parameters for web server variables via OAM or by changing Context File (xml file in APPL_TOP) These parameters I'll discuss shortly.
    3. Copy SSL Certificates created in step1 above, in SSL directories (Discussed Later) or Wallets (If you are using Oracle Wallets to store your certificates)
    4. Run Autoconfig to take new parameters to take into effect
    5. Test Applications with SSL

    Please note that above steps are for implementing SSL only on Web Server there are additional steps if you want to configure SSL on Form Server & Database Server . (I am not mentioning them here as this is not common)

    What is meant by creating SSL Certificates ?
    You remember above I discussed that server sends its certificates (public) to browser & uses private key to encrypt & decrypt messages . So steps in creating Certificates are
    1. Create Private key using openssl
    2. Create certificate request using private key created above
    3. Submit request file to Certifying Authority like verisign
    4. Get Certificates from certifying Authority (CA)
    If you are testing SSL you can use test certificates supplied with Web Server

    What are various parameters in XML file (CONTEXT File) w.r.t. SSL ?
    s_web_ssl_directory - Directory where SSL certificates are stored
    s_url_protocol - https means you are using ssl (Default is http)
    s_local_url_protocol - change it to https for SSL
    s_webssl_port - Apache SSL port
    s_active_webport - same as s_webssl_port
    s_webport - same as s_webssl_port

    Lot more coming in next post on configure SSL with Oracle Apps 11i....

    Labels: ,


    We have moved to

    http://onlineAppsDBA.com

    kindly check onLineAppsDBA.com in future

    add to del.icio.usdel.icio.us  ¦  digg thisDigg This  ¦  My Yahoo!My Yahoo  ¦  RedditReddit  ¦  add to BlinkListBlinkList   ¦  Furl ItFurl It  ¦  Email This Email This  ¦     Leave Your Comments
    posted by Atul Kumar @ 8:56 PM   6 Comments


    We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
    Overview of SSL in Oracle Applications 11i
    Wednesday, October 25, 2006
    Register for R12 upgrade
    Today I am going to cover overview of SSL & various components of oracle Apps in which you can configure SSL.

    If you encounter any Issues or got any doubts w.r.t. Oracle Applications create a Thread in Oracle Apps Forum at http://teachmeoracle.com/forum

    What is SSL ?
    SSL stands for Secure Socket Layer which is protocol developed by Netscape. Data Transferred between Server & Client is Secured (Encrypted)

    Why I need a SSL in Oracle Applications ?
    Usually data transmitted between client machine & server (Web Server on http protocol & Forms Server on Sockets ) is clear text packets. Any one can put Packet Sniffer between Client machine & Server & can open & read all data transaction between your machine & Server (If he/she has network access) Hacker can get your Username/Password or any sensitive data. This become critical when you have Internet access to Oracle Applications 11i (Usually Self Service Implementation)

    Where I need to configure SSL in Apps ?
    Communication between Client & Oracle Applications happen via three components.
    --Oracle Web Server (Initial Connection & all self service access is via Web Server/Apache). If your Form Server is in servlet Mode then Core Applications are also accessed via Web Server (Jserv Component)
    --Oracle Form Server : For Core Oracle Application Access (Forms)
    --Database : You access web server which in turn talks to database Server via UTL_HTTP package via dad (/pls/$SID)

    So You enable SSL on particular component depending on your requirement & component which is accessible over Internet & should be secured. You can Implement across all three component or only one or any two.

    What is common deployment for Internet Facing Oracle Applications ?
    Though you can configure SSL for Web, Forms & database for extra Security but Usually most prone & Internet facing component is Web Server (For Self Service Applications) so common trend is to Enable SSL between Client Machine & Web Server (Apache) in Oracle Applications.

    What will happen w.r.t. Data communication after enabling SSL ?
    By default you access Applications over HTTP (Hyper Text Transfer Protocol) but after enabling SSL on web server you will access via HTTPS (Secure) . Data will be encrypted at one end & decrypted at other end.

    More on
    How Data Encryption Happens ....
    Is there any performance overheads ....
    What is openssl & oracle Wallets ...
    How to configure SSL in Oracle Apps 11i ...
    and lot more on SSL coming in Next Post

    Those of you who want to raise questions/doubts problems , can now do same via Forum http://teachmeoracle.com/forum (Dedicated to Apps DBA, for Fast Response from some of Best Apps DBA's). Check others doubts & you can answer them.

    Labels: ,


    We have moved to

    http://onlineAppsDBA.com

    kindly check onLineAppsDBA.com in future

    add to del.icio.usdel.icio.us  ¦  digg thisDigg This  ¦  My Yahoo!My Yahoo  ¦  RedditReddit  ¦  add to BlinkListBlinkList   ¦  Furl ItFurl It  ¦  Email This Email This  ¦     Leave Your Comments
    posted by Atul Kumar @ 3:43 PM   3 Comments


    We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
    Troubleshooting Concurrent Managers
    Monday, October 23, 2006
    Register for R12 upgrade
    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:


    We have moved to

    http://onlineAppsDBA.com

    kindly check onLineAppsDBA.com in future

    add to del.icio.usdel.icio.us  ¦  digg thisDigg This  ¦  My Yahoo!My Yahoo  ¦  RedditReddit  ¦  add to BlinkListBlinkList   ¦  Furl ItFurl It  ¦  Email This Email This  ¦     Leave Your Comments
    posted by Atul Kumar @ 3:12 PM   14 Comments


    We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
    Site & Forum dedicated to Oracle Apps DBA
    Saturday, October 21, 2006
    Register for R12 upgrade
    There is Forum launched today dedicated to Oracle Apps DBA's
    at

    http://teachmeoracle.com/forum



    Now you can
    -Discuss apps dba problems
    -Can raise doubts
    -Askfor scripts
    - Any problem raise a question .... everything now integrated with forum in site http://teachmeoracle.com (site for Oracle Apps DBA's ) and Forum http://teachmeoracle.com/forum (You need to register just once)

    what's different in this forum than others
    - Dedicated to Apps DBA's
    - Experienced/ Best Apps DBA's in world monitoring forum to answer your queries
    - It your forum so you can request for new category or forum
    - Got a doubt in Apps how adpatch works , how cloning works discuss with other Apps DBA's
    - Raise a question for any document
    - You can look for Job in Jobs section in forum or publish Vacancy in your company for Apps DBA
    - Most other forums are for Core DBA & you don't get proper response
    and on top of this , everything is free

    so what are you waiting for click on http://teachmeoracle.com/forum & click on Register at top right (only one time ) & raise question.

    You can also register via link http://www.teachmeoracle.com/forum/profile.php?mode=register&sid=67694518ed95c0983a354ef40a4d28ac


    Site http://teachmeoracle.com is dedicated to Oracle Apps DBA's & Aspiring Apps DBA's . Site where you can find
    - latest information required for Apps DBA's
    - Scripts required in day to day maintenance
    - Apps DBA Interview Question Papers
    - Technical details about patching , cloning , installation documents
    - How to find version of various component version

    and lot more coming soon ...

    Have you registered for Apps DBA Forum yet at http://teachmeoracle.com/forum ?

    Labels: ,


    We have moved to

    http://onlineAppsDBA.com

    kindly check onLineAppsDBA.com in future

    add to del.icio.usdel.icio.us  ¦  digg thisDigg This  ¦  My Yahoo!My Yahoo  ¦  RedditReddit  ¦  add to BlinkListBlinkList   ¦  Furl ItFurl It  ¦  Email This Email This  ¦     Leave Your Comments
    posted by Atul Kumar @ 12:45 PM   2 Comments


    We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
    Troubleshoot Oracle Apps Web Server and Login Issues
    Wednesday, October 18, 2006
    Register for R12 upgrade
    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: ,


    We have moved to

    http://onlineAppsDBA.com

    kindly check onLineAppsDBA.com in future

    add to del.icio.usdel.icio.us  ¦  digg thisDigg This  ¦  My Yahoo!My Yahoo  ¦  RedditReddit  ¦  add to BlinkListBlinkList   ¦  Furl ItFurl It  ¦  Email This Email This  ¦     Leave Your Comments
    posted by Atul Kumar @ 5:13 PM   15 Comments


    We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
    Stayam Computers is recruiting, Apps DBA Jobs
    Monday, October 16, 2006
    Register for R12 upgrade
    Those who are working as Apps DBA's and looking for a change , Satyam Computer Services Ltd is looking for Oracle Apps DBA's with minimum 1 to 2 years of Exp. as Oracle Apps DBA for Hyderabad & Bangalore (India)

    Necessary Skills :
    1) Overall 5 yrs (3 yrs. in Core DBA and 2/1.6 yrs. in Apps DBA)
    2) Good knowledge :
    1) Oracle Database 8.x/9.x/10.x
    2) Installation and Maintenance on E-Business suite 10.7/11.0.3/11i
    3) Experience in Skill Set : more than one year as an APPS DBA


    Mandatory :
    1) Knowledge in Oracle Database architecture & administration
    2) Knowledge of E-Business suite architecture
    3) Installation and maintenance of E-Business suite
    4) Good communication skills

    Desirable :

    1) upgrade and migration of Oracle Database and Oracle E-Business suite
    2) Configuring High Availability and business continuity with E-Business suite
    3) performance tuning


    You can mail your CV to my id atul_iiit@yahoo.com or to uma_bala@satyam.com

    If you think you are very good in Apps DBA but don't meet 3 years core dba Skills then mail me at atul_iiit@yahoo.com

    If your company is recruiting Oracle Apps DBA or if you want to share any other Openings with budding Oracle Apps DBA's then shoot a mail to me at atul_iiit@yahoo.com

    Labels: ,


    We have moved to

    http://onlineAppsDBA.com

    kindly check onLineAppsDBA.com in future

    add to del.icio.usdel.icio.us  ¦  digg thisDigg This  ¦  My Yahoo!My Yahoo  ¦  RedditReddit  ¦  add to BlinkListBlinkList   ¦  Furl ItFurl It  ¦  Email This Email This  ¦     Leave Your Comments
    posted by Atul Kumar @ 4:26 PM   0 Comments


    We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
    Oracle Apps Web Server Apache, Login Troubleshooting
    Sunday, October 15, 2006
    Register for R12 upgrade
    This week I will focus on troubleshooting of Oracle Apps and there are fundamentals of troubleshooting :
    - You should know about that particular component
    - log files are quite powerful and important in finding cause of problem
    - try to understand flow between various components

    For Oracle Applications Web Server which is build on Apache 1.3..X version and also called as Oracle-Apache . Oracle Apps Web Server bundled with Applications is version 1.0.2.2.2 but you can also install & configure 10g Application Server Version. In this post I 'll focus on Web Server Version 1.0.2.2.2 only .

    Most of the things about Web Server ( Oracle-Apache Server ), I have already covered in my site at
    http://teachmeoracle.com/apc.html
    http://teachmeoracle.com/apc02.html
    http://teachmeoracle.com/apc03.html
    http://teachmeoracle.com/apc04.html
    http://teachmeoracle.com/apcvrbl.html

    If you don't understand any topic on above four pages then drop a mail to me or leave a comment here .

    So when you try to access login page via URL http://hostname.domainname:portnumber
    and if you don't see page you need to look into log files . As you know there are two main component of Web Server Core Apache & Jserv ( for Java requests)
    Core Apache Log Files
    Core Apache log files are in directory $IAS_ORACLE_HOME/Apache/Apache/logs
    - error_log or error_log.$timestamp
    - error_log_pls or error_log_pls.$timestamp

    Jserv Log files
    Jserv log files are in directory $IAS_ORACLE_HOME/Apache/Jserv/logs
    and JVM ( Java Virtual Machine ) logs at $IAS_ORACLE_HOME/Apache/Jserv/logs/jvm

    Check if you see any error message in Jserv/logs mod_jserv.log or jserv.log.
    jserv.log by default is disabled so if you want to find any error message w.r.t. jserv.log then change log=false to log=true in jserv.properies and bounce webserver/apache using adapcctl.sh and check any error message.

    When you start Apache you should see clean start up of Web Server & no error message in this log files.

    Common Problems in Starting Apache
    Here is the list of common problems while starting web server which might be useful to you in appsdba Interview are
    - Could not bind port (Port already in Use)
    - found .pid file ( When Apache starts it creates .pid file in logs directory and when you shutdown apache it cleans this .pid file so if this file is already there then Apache will not start. Fix: Simply move this file
    If there is no error messages in error_log or error_log_pls then there might be issues in starting Jserv component of web server ( which caters Java requests by mod_jserv)
    - mobile is enabled in zone.properties disable it if you are not using it .

    If you mistype any directive in Apache ( httpd.conf or any conf file ) Apache will not start & it will not write even in error_log in that case it will report any error message related to mis configuration in directive in file $COMMON_TOP/admin/log/$CONTEXT_NAME/adapcctl.txt

    I hope once you have error message you can check related hits in metalink or oracle forums or any other Apps Forum. Most of the error message are because of changes , so check what changes you made recently.

    Once you are able to access http://hostname.domainname:port and if you are getting any error message that means your web server ( Core Apache ) is working but there are various component called as modules and there may be issues with those modules which we will check these modules in next post. few modules of our interest are
    -mod_jserv
    -mod_pls
    -mod_oprocmgr
    -mod_ossl (If you have ssl enabled on web server )
    -mod_osso (If single sign on server is enabled on web server)

    If you don't know port number of your web server you can check it in file $IAS_ORACLE_HOME/Apache/Apache/conf/httpd.conf with directive Listen & Port

    Your Feedback is quite important to me so please leave feedback on How you rate this post ( Can you understand it or its too basics, too tough, too technical ? if you want me to include some tips on troubleshooting then leave a comment or drop mail at atul_iiit@yahoo.com )

    Labels: ,


    We have moved to

    http://onlineAppsDBA.com

    kindly check onLineAppsDBA.com in future

    add to del.icio.usdel.icio.us  ¦  digg thisDigg This  ¦  My Yahoo!My Yahoo  ¦  RedditReddit  ¦  add to BlinkListBlinkList   ¦  Furl ItFurl It  ¦  Email This Email This  ¦     Leave Your Comments
    posted by Atul Kumar @ 8:07 PM   21 Comments


    We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
    Applying CPU patches on AS Middle Tier and E-Business Suite
    Friday, October 13, 2006
    Register for R12 upgrade
    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: ,


    We have moved to

    http://onlineAppsDBA.com

    kindly check onLineAppsDBA.com in future

    add to del.icio.usdel.icio.us  ¦  digg thisDigg This  ¦  My Yahoo!My Yahoo  ¦  RedditReddit  ¦  add to BlinkListBlinkList   ¦  Furl ItFurl It  ¦  Email This Email This  ¦     Leave Your Comments
    posted by Atul Kumar @ 4:35 PM   9 Comments


    We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
    Oracle Apps DBA Interview Questions
    Thursday, October 12, 2006
    Register for R12 upgrade
    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: , ,


    We have moved to

    http://onlineAppsDBA.com

    kindly check onLineAppsDBA.com in future

    add to del.icio.usdel.icio.us  ¦  digg thisDigg This  ¦  My Yahoo!My Yahoo  ¦  RedditReddit  ¦  add to BlinkListBlinkList   ¦  Furl ItFurl It  ¦  Email This Email This  ¦     Leave Your Comments
    posted by Atul Kumar @ 6:49 PM   23 Comments


    We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
    Oracle CPU Patch July for application Server Contd...
    Tuesday, October 10, 2006
    Register for R12 upgrade
    If you are reading this post directly then first read post listed at

    http://becomeappsdba.blogspot.com/2006/10/apply-oracle-july-cpu-patch.html

    So lets continue with Oracle CPU patch for July , yesterday I updated steps to install patch for Portal Database (Remote Database ) Installed using Rep CA .

    1.3.2 Apply Application Server patch on infrastructure Tier
    --In Application Server Infrastructure consist of OID+SSO & database to store metadata for OID & SSO.
    --Patch number mentioned here are for Infrastructure version 10.1.2.0.2 with database version 10.1.0.5
    -- The patch number for 10g Infra tier with database 10.1.0.5 is 5225797 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 5225797 , assume you have downloaded patch at /u01/patch/cpu/jul06/5225797 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)
    You should see OPatch succeeded Then
    -- sh /u01/patch/cpu/jul06/5225797/cpu_root.sh from root
    --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
    --SQL> @?/rdbms/admin/utlrp.sql ( Compile Database Objects)

    This will complete your Installation but if you try to start ldap server after this your OID will not compe up. This is because oid library files in $OH/lib32 folder were overwritten by database patch . Follow metalink note # 361800.1

    This Complete your Jul CPU patch on Infrastructure Tier .

    In order to apply CPU patch on Application Tier on AS version 10.1.2.0.2 patch number is 5249970. When you try to apply this patch on Middle Tier you might encounter error like

    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 Infarstructure Database Version .

    Why you get this error ?
    How to apply CPU Patch on 10g Application Server Middle Tier ?
    How to apply CPU patch on E-Business Suite ?

    Coming in next post ...

    Related Links :

    CPU Patch Overview
    Apply CPU on Database & AS Infrastructure Tier

    Labels: ,


    We have moved to

    http://onlineAppsDBA.com

    kindly check onLineAppsDBA.com in future

    add to del.icio.usdel.icio.us  ¦  digg thisDigg This  ¦  My Yahoo!My Yahoo  ¦  RedditReddit  ¦  add to BlinkListBlinkList   ¦  Furl ItFurl It  ¦  Email This Email This  ¦     Leave Your Comments
    posted by Atul Kumar @ 4:52 PM   3 Comments


    We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
    Apply Oracle July CPU patch
    Monday, October 09, 2006
    Register for R12 upgrade
    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:


    We have moved to

    http://onlineAppsDBA.com

    kindly check onLineAppsDBA.com in future

    add to del.icio.usdel.icio.us  ¦  digg thisDigg This  ¦  My Yahoo!My Yahoo  ¦  RedditReddit  ¦  add to BlinkListBlinkList   ¦  Furl ItFurl It  ¦  Email This Email This  ¦     Leave Your Comments
    posted by Atul Kumar @ 5:26 PM   17 Comments


    We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
    My Site Content & Questions are Copyright protected
    Saturday, October 07, 2006
    Register for R12 upgrade
    It has come to my notice again that few readers are copying content from here & my other site http://teachmeoracle.com in to their own site .

    Please note that my both sites are protected under copyright act and its illegal to copy content without my prior permission. Vikas at appsdbablog dot wordpress dot com has copied Interview Questions . Please note that I can take legal actions but since we belong to same community ( Apps DBA) and I think Vikas has done it under ignorance so I am not going in to legal actions at this minute. I expect owner of site appsdbablog at wordpress to remove my content/interview Q's .

    Those of you who think that its illegal to copy others work ; kindly leave a note/comment to our friend Vikas at http://appsdbablog.wordpress.com/about/ asking him to remove my content from his page.

    You can very well create link on your site referring to study material at this site or my any other site . Lets make internet better & healthy way to share knowledge.

    Related Links
    http://becomeappsdba.blogspot.com/2006/09/this-site-is-copyright-protected.html

    Labels:


    We have moved to

    http://onlineAppsDBA.com

    kindly check onLineAppsDBA.com in future

    add to del.icio.usdel.icio.us  ¦  digg thisDigg This  ¦  My Yahoo!My Yahoo  ¦  RedditReddit  ¦  add to BlinkListBlinkList   ¦  Furl ItFurl It  ¦  Email This Email This  ¦     Leave Your Comments
    posted by Atul Kumar @ 3:07 AM   9 Comments


    We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
    Autoconfig in Apps template files Contd....
    Friday, October 06, 2006
    Register for R12 upgrade
    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: , ,


    We have moved to

    http://onlineAppsDBA.com

    kindly check onLineAppsDBA.com in future

    add to del.icio.usdel.icio.us  ¦  digg thisDigg This  ¦  My Yahoo!My Yahoo  ¦  RedditReddit  ¦  add to BlinkListBlinkList   ¦  Furl ItFurl It  ¦  Email This Email This  ¦     Leave Your Comments
    posted by Atul Kumar @ 2:55 PM   27 Comments


    We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
    Unwrapping XML , Context File or Autoconfig configuration file
    Thursday, October 05, 2006
    Register for R12 upgrade
    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

    http://onlineAppsDBA.com

    kindly check onLineAppsDBA.com in future

    add to del.icio.usdel.icio.us  ¦  digg thisDigg This  ¦  My Yahoo!My Yahoo  ¦  RedditReddit  ¦  add to BlinkListBlinkList   ¦  Furl ItFurl It  ¦  Email This Email This  ¦     Leave Your Comments
    posted by Atul Kumar @ 5:18 PM   11 Comments


    We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
    Autoconfig Basics
    Wednesday, October 04, 2006
    Register for R12 upgrade
    I am getting lots of request for Autoconfig so I thought lets start with this most powerful tool (in my views) in Oracle Apps .

    What is Autoconfig ?
    Autoconfig is tool in Apps to configure oracle Applications 11i , Application Tier as well Database Tier.

    How to run Autoconfig ?
    If you want to configure database tier then you have to execute autoconfig script adautocfg.sh on database tier else if you want to configure on application tier (Middle Tier ) then you have to execute one on middle tier .

    Here is the script location
    For Database tier its $ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME
    For Application Tier its $OAD_TOP/admin/scripts/$CONTEXT_NAME

    adautocfg.sh calls adconfig.sh from $AD_TOP/bin which inturn calls adconfig.pl from $AD_TOP/bin

    Don't forget to take backup before executing autoconfig.

    What source of information for Autoconfig to update configuration files ?
    If you are wondering where is configuration information stored about your apps 11i instance based on which it updates your Instance then this file is xml file also called as Context file and its in $APPL_TOP/admin for Application Tier or $ORACLE_HOME/appsutil in Database Tier

    I am going to unwrap this xml / context file which is most important file . If you get a chance open this file & go through it so wait for my next post on Context File Contents with explanation & how to put your customization so that Autoconfig can't overwrite them ..

    We have moved to

    http://onlineAppsDBA.com

    kindly check onLineAppsDBA.com in future

    add to del.icio.usdel.icio.us  ¦  digg thisDigg This  ¦  My Yahoo!My Yahoo  ¦  RedditReddit  ¦  add to BlinkListBlinkList   ¦  Furl ItFurl It  ¦  Email This Email This  ¦     Leave Your Comments
    posted by Atul Kumar @ 4:42 PM   37 Comments


    We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
    Forms, iAS and other component patching in Oracle Apps
    Sunday, October 01, 2006
    Register for R12 upgrade
    If one talks about oracle apps patching , usually they talk in terms of Oracle Apps patches i.e. one applied using adpatch but there are lot of other component & correspondingly you patch those component both for new functionality of bugs. Lets understand what these products are & how to apply these patches.

    Apps Patch : Usually Apps Patch Update your APPL_TOP (To know more about various tops in Apps visit What are various TOP's in APPS ) as well some database objects. These patches are applied using utility called as adpatch ( applications dba patch ). Here are my previous post on Apps & various types of apps patches
    Apps Patches Basics, One off, standalone, Minipack, Family Pack & Maintenance Patch
    AD Patch basics & various Drivers
    How to Apply Apps Patches

    Database Patches : Database patches are applied using utility opatch & these patches update files in DB_TOP .

    Forms Patches /Developer 6i Patch: These patches update 806_TOP which is top level directory 8.0.6 under ORA_TOP. Currently latest forms patch set is patchset version 18 i.e. forms server version 27. These patches are applied using shell script. You can also say that these patches are bundeled in Shell Script & you need to execute these shell scripts.

    iAS Patches : These patches updates IAS_TOP or IAS_ORACLE_HOME which is top level directory iAS under ORA_TOP. These patches are also bundled together in a shell script & you need to execute shell script after setting environment variable. In post installation steps patch might ask you to relink some executables or some other instructions mentioned in readMe of Patch.

    Mystery of Forms Patch Set & Form Server Version:
    I don't know how it started but Form Server Version = Forms Patchset Version + 9 , so if your form server version is 8.0.6.26 that menas 26 -9 = 17 you are on patchset 17 :-). Check
    How to find your form server version

    Instructions on Applying Forms Patches:
    Open read me of patch & follow it throughly & don't forget to take backup of system before applying patch (Though unlike apps patch you can revert back forms patches)
    Here is overview of instrcutions on applying forms patch
    - Set your ORACLE_HOME to 8.0.6 directory (By defualt ORACLE_HOME on middle tier points to 8.0.6 only)
    - Unzip the patch to ORACLE_HOMEc on application tier (Not on Database Tier )
    - Execute shell script given in patch
    - Check log files for any error message
    - Relink Report & Forms

    This finishes your patch application on forms & reports server.

    Note * Forms & Report together are part of Developer 6i

    Don't forget to leave your feedback & comments.

    Atul Kumar
    Oracle Applications DBA

    We have moved to

    http://onlineAppsDBA.com

    kindly check onLineAppsDBA.com in future

    add to del.icio.usdel.icio.us  ¦  digg thisDigg This  ¦  My Yahoo!My Yahoo  ¦  RedditReddit  ¦  add to BlinkListBlinkList   ¦  Furl ItFurl It  ¦  Email This Email This  ¦     Leave Your Comments
    posted by Atul Kumar @ 6:56 PM   4 Comments
    About Me


    Name: Atul Kumar
    Home: London, United Kingdom

    About Me: I am Independent Oracle consultant. If you wish to hire me on Contract or to Quote on project basis contact me at
    atul @ onlineappsdba.com

    See my complete profile

    View Atul Kumar's profile on LinkedIn

    E-mail Subscription

    Enter your email address:

    Delivered by FeedBurner

    Search
    Only search this Blog
    Categories
  • Advanced Topics
  • Application Server
  • Apex / HTMLDB
  • Apps 11i
  • Apps R12
  • Autoconfig
  • Basics
  • Certification
  • Cloning
  • Discoverer
  • Fusion
  • OID
  • Patching
  • Printer
  • Single Sign-On
  • Useful Sites & Forum
  • Previous Post
    Archives
    Add On
     

    Add to Technorati Favorites

     

     

    Add to Google

     

    Add to My AOL

     

    Subscribe in Bloglines

     

    Subscribe in NewsGator Online

     
    Powered by



    Hits Since 30, Jul 06

    Blog Counter

    Technology Blogs - Blog Top Sites
    Comments
    ADs
    Copyright © 2006 teachmeoracle.com All rights reserved Presented by Atul Kumar