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
  • Upgarde DB to
  • 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
  • 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
  • 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 kindly check http://onlineAppsDBA.comin future
    Oracle Apps R12 Forms : Servlet or Socket
    Thursday, June 28, 2007
    Register for R12 upgrade
    Default Forms connection mode in Oracle Applications R12 is "SERVLET" where as in Oracle Apps 11i default form connect mode is "SOCKET" So

    What is difference between socket and servlet mode in Forms ?
    What are advantages and disadvantages of each ?
    Can we change default R12 forms mode from servlet to Socket ?

    Oracle Form Servlet Overview in apps R12

    i) In this mode, Java servlet handles communication between forms client(java based) and Oracle Forms Service (10g).

    ii) All connection is via HTTP Server so there is no need to start form server and no need to open form server port on firewall between client machine and application tier.

    iii) More secure as compared to Forms Socket Mode.

    iv) Network traffic is more as HTTP protocol is more chatty so little bit network bandwidth hungry when compared with SOCKET mode

    v) No additional certificate requirement during SSL implementation for application tier, single certificate will handle both forms & web connection.

    How to change from default Servlet mode (in apps R12) to Socket mode ?

    Refer to Oracle Metalink Note # 384241.1 Using Forms Socket Mode with Oracle E-Business Suite Release 12

    Are there any network overheads of using Forms in Servlet Mode ?

    Note # 311091.1 Understanding the Network Overhead Of Forms Servlet Listener Architecture Compared to Forms Server, covers some interesting points w.r.t. network traffic

    Advantage & Disadvantages of Forms Servlet Mode

    -- Simple SSL Configuration (as no separate ssl configuration is required for Forms as connections are via web/http server)

    -- No port need to open to access forms in firewall

    -- More secure method of deployment over Internet

    -- Result in more network traffic because of HTTP is more chatty than socket (dedicated) so not preferred in WAN implementation.

    Related Doc
    ---------------- (Oracle Forms Listener Servlet for deployment of Forms on Internet)

    Question to readers ....

    How will you identify if you are using Forms in Socket or Servlet mode in Oracle Applications 11i or R12 ? (leave your comments )

    Labels: ,

    We have moved to

    kindly check in future

    add to  ¦  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 @ 11:47 AM   11 Comments

    We have moved to kindly check http://onlineAppsDBA.comin future
    Install Oracle SOA Suite :
    Wednesday, June 20, 2007
    Register for R12 upgrade
    This is third and last part of installing Oracle SOA Suite version

    Overview of SOA Suite Installation
    1. Download and Install Database (I used but and higher is also valid)
    2. Upgrade database to (If this is EE)
    3. Load SOA schema in database
    4. Install SOA Suite

    In Order to install Oracle SOA Suite with 10g R2 database you should have database 10.2.X installed ( for XE or or higher for EE).

    Before starting SOA Suite installation make sure you have

    -- Installed Database version on this link on how to install database on linux)
    --Upgraded Database to version (only If you selected EE database during installation)

    1. Download SOA Suite Software (soa_linux_x86_101310_disk1.cpio) from

    2. unzip them as "cpio -idmv less_than_sign_here soa_linux_x86_101310_disk1.cpio"

    Load ORABPEL, ORAESB, ORAWSM schema into Database

    cd /extracted_soa_directory/install/soa_schemas/irca

    sh (IRCA stands for Integration Repository Creation Assistance)

    When prompted for database connection details pass on connection detail in format hostname port_no SID

    --When prompted for database sys schema password , provide database password
    --Then it will ask for ORABPEL, ORAESB and ORAWSM schema password which you wish to set (enter password which you would like to set. This password will be required during SOA Suite installation)

    Install Oracle SOA Suite Installation

    start installation by running runInstaller from SOA unzipped disk

    cd /full_path_of_extracted_soa_software

    You can opt for Basic or Advanced Installation (For more option and flexibility go for Advanced installation)

    Click on Yes for warning message

    Select First option "J2EE , Web Server and SOA Suite"

    Click OK on warning message

    Provide database connection information (This is the database we installed and upgraded in previous post)

    on clicking next if you get error message like ORABPEL is not available on specified Oracle Database , Make sure you executed as mentioned above.

    Provide Password which you supplied during above

    Provide ias_instance and oc4j instance name

    Use this screen if you are using this instance from HTTP server hosted in other machine and want join as part of cluster (High Availaibity)

    Click on install and this will take 1-3 hours depending on your system.
    Integration of E-Business Suite with Siebel using Application Integration Pack on above SOA Suite (Fusion Middleware) coming soon .....

    Labels: ,

    We have moved to

    kindly check in future

    add to  ¦  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 @ 7:56 PM   10 Comments

    We have moved to kindly check http://onlineAppsDBA.comin future
    Upgrade Oracle Database to : SOA Suite Install Part II
    Saturday, June 16, 2007
    Register for R12 upgrade
    Next step in installing SOA Suite after installing database is to upgrade this oracle database to version (4547817).

    For Oracle Database Installation Step and Software location click here

    If you selected Standard Edition during database installation, you can skip this database upgrade step. This is because for Enetrprise Edition Database, SOA Suite is certified only with and higher (in 9i database) or version ( For Standard Edition database is certified with SOA Suite

    For detailed information on how to upgrade from database to version follow readme of patch 4547817 or metalink note 316900.1

    Few things about patch set
    i) patch set is not complete software, You can only apply it on top of existing 10.2.0.X installation.
    ii) This patchset on linux can be applied on following version of linux Suse 9, Red Hat AS/ES 3, 4

    Pre Installation Steps
    i) Download patch (download patch according to your operating system like windows, solaris..) and copy it to your linux machine

    ii) Unzip patch as “unzip”

    iii) Set ORACLE_HOME and ORACLE_SID to your database (10.2.0.X) on which you are planning to apply this patchset . In my case its
    ORACLE_HOME = /home/oracle/product/10.2.0/db

    (Command to export environment variable differ as per your shell, above command is used for bash, bourne or ksh)

    iv) Stop database and database listener as mentioned at end of database installation in my previous post

    v) Backup your system (In case anything goes wrong)

    Database Patch Set Installation
    i) Login as user who installed 10.2.0.X database (In my case its “oracle” )

    ii) cd patchset_unzip_directory/DISK1

    iii) ./runInstaller

    iv) On welcome screen click Next

    v) On Specify file location screen, in Name field and Path select Database on which you wish to apply this patch (If you have multiple database installed on your machine you will see drop down menu to select database oracle_home)

    vi) On summay screen, click Install

    vii) In the end when prompted to run , login as root from another window and execute in ORACLE_HOME

    viii) In the end of installation screen click Exit, and click Yes to exit from Oracle Universal Installer

    This step will complete database software upgraded to patchset but we haven’t upgraded our database yet to (In next step we will upgrade our database to version).

    Upgrade 10.2.0.X database to
    Please note steps mentioned here are for upgrading database to from 10.2.0.X version, for upgrade from previous release (8i, 9i, 10g) refer metalink note mentioned above

    i) Make sure you have applied patchset on oracle_home (on which database is installed)

    ii) Login as database owner (oracle) and exexute sqlplus “/as sysdba”

    iii) SQL> startup upgrade
    iv) SQL> spool 10202upgrade.log
    v) SQL> @/rdbms/admin/catupgrd.sql
    vi) SQL> spool off

    (Check if there are any error message in 10202upgarde.log and rerun catupgrd.sql after fixing errors)

    In the end of log file (10202upgarde.log) you should see output like below with component version as

    vii) SQL> shutdown
    viii) SQL> startup
    ix) SQL> @?/rdbms/admin/utlrp.sql
    x) SQL> select count(*) from dba_objects where status like ‘INVALID’;
    Count (*)
    xi) SQL> shutdown immediate (After upgrade and invalid object compilation restart your database cleanly)
    xii) lsnrctl start
    xiii) SQL> startup

    This completes your oracle database upgrade to version.

    If you are hitting any issues in upgrade, raise them in forum dedicated to apps dba's at or leave a comment here.

    Loading ORABPEL, ORAESB and ORAWSM schema in above database and SOA Suite installation coming next...

    Labels: , ,

    We have moved to

    kindly check in future

    add to  ¦  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 AM   3 Comments

    We have moved to kindly check http://onlineAppsDBA.comin future
    Oracle SOA Suite Installation Part I : Database Installation
    Wednesday, June 13, 2007
    Register for R12 upgrade
    In next few posts I’ll cover installation of SOA Suite (Service Oriented Architecture Suite) which is one of the components in Oracle Fusion Middleware. For more information on Oracle Fusion Middleware and its various components and overview visit

    Fusion Middleware Part I
    Fusion Middleware Part I

    --In order to install SOA suite version 10.1.3.X you need Database version 10.2.X or higher to hold schema for BPEL, ESB, WSM ....
    --This database can exist on same machine (but under different ORACLE_HOME) or can be on different machine where you are planning to install SOA.
    --For this installation demo, I installing Database release on same machine under ORACLE_HOME.
    --This demo installation is on Redhat Linux ES 3 which is on VMWare.

    Install Oracle Database

    Software for Oracle Database can be downloaded from this link

    Operating System Prereq.
    For linux following version are supported for database version at time of writing this doc

    I picked up Red hat ES -3 (Enterprise Server) as operating system.

    Packages and Kernel Parameters mentioned below are for database on Red Hat linux Version 3 (Check Installation Documentation if your operating system version differs)

    Following packages with atleast following version should be installed

    To check if package/rpm is installed
    rpm –qa grep {rpm_name} (From root)

    To install package/rpm
    rpm –ivh {rpm_name} (From root)

    Kernel Parameter
    Make sure you add following entry in /etc/sysctl.conf

    After adding these entries execute below command to take these parameters in to effect

    sysctl –p /etc/sysctl.conf

    Unzip software you downloaded above as


    Starting Database Installation
    Start Oracle Universal Installer (OUI) by running

    ./runInstaller (from location where you unzipped database) *Use operating system user like oracle or orainstall (don’t execute runInstaller from root user)

    With this screen you get option to do basic database installation where as I opted for Advanced Installation (With Advanced Installation Option you get flexibility on where to keep database and various other options). You can also choose Basic Installation and OUI will ask only basic question and for rest values it will take default (pre configured) values.

    Again you have three options for type of installation for your database (Choose one as per your requirement, if you are not sure which one to pick, leave default i.e. Enterprise Edition)

    This is important detail which is prompting for Database ORACLE_HOME Name and Destination Path.

    ORACLE_HOME is always unique per system which identifies oracle software installed (Oracle Software can be database, application server or various other oracle software)
    PATH is directory where your oracle database software will be installed (Please note Oracle Software is not same as Oracle Data files)

    In my case Oracle Database 10.2.X requires minimum 900 MB memory but just had 750 MB allocated to Virtual Machine on which I am installing this database so I got warning related to memory. If you get warning related to memory you can ignore it (Not for Production or UAT deployment)

    In above screen you have option to Create Database, Configure ASM (more coming on ASM with RAC soon ...) or Install database software only.

    If you select database software only you can create database later as well (this option will only install oracle database software and will not create any database)

    Leave default General Purpose in above screen

    If you have selected “Create a Database” above on this screen you have option to define SID and Global Database name for database which we are going to create with install. (You can leave default “orcl” SID or change like “SOADEV” to uniquely identify this database that it is going to be used with SOA Suite)

    Leave default “Database Control Management” or choose option 1 if you have Grid Control Agents installed on machine on which you are trying to install this database.

    Here you can specify type of storage management for database (SOADEV) which you are going to install. This storage management as seen in image can be File System, ASM or Raw device.

    Specify Database file location if you choose File System as storage management. (Database file location can exist under ORACLE_HOME or any other location. * better keep this different from ORACLE_HOME for better management)

    Choose password for your various schema (For security reasons, don’t choose same password for all accounts on production instance)

    Click on “Install” button to start your installation (Installation may take 30 minutes to 3 hours depending on your machine)

    If you wish to unlock non system accounts click on “Password Management” or click “OK” for unlocking them later. (For SOA Suite Installation, you can leave them locked)

    execute command from root user as shown blow

    This will complete your database installation for SOA Suite Installation.

    If you wish to start/stop oracle database installed above

    export ORACLE_HOME = /home/oracle/product/10.2.0/db
    export ORACLE_SID = SOADEV
    export PATH = $PATH:$ORACLE_HOME/bin

    (Where ORACLE_HOME and ORACLE_SID we entered above while installing database)

    Stopping database services
    sqlplus “/as sysdba”
    SQL> shutdown immediate
    lsnrctl stop

    Starting database services
    lsnrctl start
    sqlplus “/as sysdba”
    SQL> start

    For SOA Suite installation stay tuned (coming soon...)

    You can also subscribe to email feeds on right menu of this page for updates on this Apps DBA blog.

    Labels: ,

    We have moved to

    kindly check in future

    add to  ¦  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 @ 7:56 PM   0 Comments

    We have moved to kindly check http://onlineAppsDBA.comin future
    Start-up Shutdown Scripts in Oracle Apps R12
    Sunday, June 10, 2007
    Register for R12 upgrade
    This Post covers Start-up Shutdown scripts in Oracle Applications Release 12, If you wish to know more about Startup/Shutdown scripts in Oracle Apps 11i click here

    Order of Startup Shutdown
    As in Oracle Apps 11i order for startup is
    A) Start Database Tier Services
    --Start Database Listener
    --Start Database
    B) Start Application/Middle Tier Services

    Order for shutdown in Oracle Apps R12 is
    A) Stop Application/Middle Tier Services
    B) Stop Database Tier Services
    --Stop Database
    --Stop Database Listener

    Database Tier Scripts in R12
    For Database tier you need to start database and database listener. Scripts are located in Database_Install_Dir/db/tech_st/10.2.0/appsutil/scripts/$CONTEXT_NAME

    - For Database

    Use script

    - For Database Listener
    Use script

    or alternatively you can use
    lsnrctl startstop listener_name (For Database Listener)
    sqlplus "/as sysdba"
    SQL> startup shutdown immediate

    Middle/Application Tier Scripts in R12

    Scripts for Application Tier services in R12 are located in "Install_base/inst/apps/$CONTEXT_NAME/admin/scripts"
    where CONTEXT_NAME is of format SID_HOSTNAME

    Master script to start all components/services of middle tier or application tier. This script will use Service Control API to start all services which are enabled after checking them in context file (SID_HOSTNAME.xml or CONTEXT_NAME.xml)

    Master script to stop all components/services of middle tier or application tier.

    Script to start / stop apps listener (FNDFS and FNDFS). This listener will file will be in 10.1.2 ORACLE_HOME (i.e. Forms & Reports Home)
    listener.ora file will be in $INST_TOP/apps/$CONTEXT_NAME/ora/10.1.2/network/admin directory
    (Mostly similar to one in 11i with only change in ORACLE_HOME i.e. from 8.0.6 to 10.1.2 )

    Script to start/stop Web Server or Oracle HTTP Server. This script uses opmn (Oracle Process Manager and Notification Server) with syntax similar to opmnctl [startstop]proc ohs
    like opmnctl stopproc ohs .

    (In 11i this script directly used to call apachectl executable but now calls opmnctl which in turn calls apachectl. In 11i web server oracle home was but in R12 its 10.1.3)

    Script to start / stop concurrent manager, Similar to one in 11i. (This script in turn calls )

    Script to start / stop Forms OC4J from 10.1.3 Oracle_Home. This script will also use opmnctl to start/stop Forms OC4J like
    opmnctl stopproc type=oc4j instancename=forms

    This script is used only if you wish to start forms in socket mode. Default forms connect method in R12 is servlet.
    If started this will start frmsrv executable from 10.1.2 Oracle_Home in Apps R12

    This script will start/stop oacore OC4J in 10.1.3 Oracle_Home. This scripts will also use opmnctl (similar to adapcctl & adformsctl) to start oacore instance of OC4J like
    opmnctl startproc type=oc4j instancename=oacore

    This script will start/stop oafm OC4J in 10.1.3 Oracle_Home. This scripts will also use opmnctl (similar to above) to start oacore instance of OC4J like
    opmnctl startproc type=oc4j instancename=oafm

    This script will start/stop opmn service in 10.1.3 Oracle_Home. opmn will control all services in 10.1.3 Oracle_Home like web server or various oc4j instances. If any services are stopped abnormally opmn will/should start them automatically.

    This script will be used to start/stop one to one fulfilment server.

    To start / stop mwa telnet server where mwa is mobile application.

    Log File Location for Startup Shutdown Services in R12
    Log files for startup/shutdown scripts for application/mid tier in R12 are in $INST_TOP/apps/$CONTEXT_NAME/logs/appl/admin/log
    (adalnctl.txt, adapcctl.txt, adcmctl.txt, adformsctl.txt, adoacorectl.txt, adoafmctl.txt, adopmnctl.txt, adstrtal.log, jtffmctl.txt )

    --Are you facing any issues in startup/shutdown scripts ?
    --Should Oracle Create single script which should start/stop entire application including database ?

    Labels: ,

    We have moved to

    kindly check in future

    add to  ¦  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:27 PM   3 Comments

    We have moved to kindly check http://onlineAppsDBA.comin future
    Synchronize Oracle Calendar directly from Mobile Part II
    Friday, June 08, 2007
    Register for R12 upgrade
    This is second and last part of configuring Oracle Calendar (Part of Oracle Collaboration Suite) so that your meetings, schedule, room bookings can be updated/synched directly from your mobile handset.

    For Part I Installing Calendar and Web Server, Click here

    In order to synchronize calendar directly from any mobile handset, corresponding handset profile should be available in ocst_profiles file. This file is in CAL_INSTALL_DIR/ocas/conf/ocst_profile .

    Oracle Calendar version doesn't contain profiles for Nokia E50 or E61 (as these handsets were certified later in version i.e. patch set 4) hence we have to patch it to version If mobile handset you are trying to configure is not listed in above ocst_profile file, check with Oracle Support if your handset is certified with calendar or not.

    Below is the step to patch calendar to version

    Upgrade Calendar to version
    Upgrade of Calendar services is required in order to configure Nokia E61 and Nokia E50 handset.

    Upgrade OPatch

    Download patch 2617419 from metalink with version 10.1.2 and copy it to $CAL_HOME i.e. /apps/oracle/product/CAL

    Unzip patch in above directory /apps/oracle/product/CAL , This will create OPatch directory in above location. When prompted for overwriting existing file select All and overwrite entire OPatch directory

    Check opatch version
    opatch version (opatch is available in /apps/oracle/product/CAL/OPatch)Make sure version is

    Upgrade Calendar
    ---Download patch 5551332 from Metalink and unzip it in any directory. This will create directory 5551332

    ---Shutdown Calendar and OHS
    unistop -all
    ocasctl -stopall
    opmnctl stopall

    ---Start opatch as
    cd /patch_unzip_location/5551332
    /apps/oracle/product/CAL/OPatch/opatch apply

    When prompted for Is Oracle Service down, Select YES. Make sure patch finishes successfully.

    Start Calendar and OHS services mentioned in first post

    Nokia Handset Configuration
    Menu -> Connectivity -> Sync -> Options -> New Sync Profile
    -> Calendar - Include in Sync - Yes
    Remote Database -> Calendar , Synchronize Type - Common
    Connection Setting -> Server Version -1.1, Server ID -1, Data Bearer - Internet, Host Address - , Port No - 7777
    User Name, Password (Type user Name password you created / admin username password)

    Select sync in mobile handset and your calendar in Mobile should be synchronized with Oracle Calendar server.

    For more information on how to enter these details in nokia handset play video in link

    Nokia E61 Demo
    Nokia E50 Demo

    Related Document
    Oracle Mobile Data Sync and Sync Server
    Architecture of Oracle Calendar Application

    Coming Next : How to Start / Stop Services on Oracle Applications R12 and associated Log Files.

    Labels: ,

    We have moved to

    kindly check in future

    add to  ¦  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 @ 7:04 PM   0 Comments

    We have moved to kindly check http://onlineAppsDBA.comin future
    Synchronize Oracle Calendar Directly from Mobile Handset
    Sunday, June 03, 2007
    Register for R12 upgrade

    Below post covers Synchronization of Oracle Calendar directly from your WAP enabled mobile handset like Nokia, Sony Ericson... This is covered in two parts , Part I covers isntallation of calendar and standalone Web (HTTP) Server and in next part II, I'll cover synchronization steps with Mobile Handset and important files.

    Traditional way of synchronizing your calendar data with your mobile handsets is via Desktop Machine (First synchronize your desktop machine with calendar server data and then synchronizing your mobile handset by connecting it to your desktop machine or laptop and vice versa).
    With mobility you need a mechnism to synchronize your calendar data directly from your handset without connecting your mobile to desktop or laptop. Today's post covers overview and implementation steps for providing infrastructure so that users/managers/employees can be in synch and update their meetings, shedules directly from mobile.

    Overview of Oracle Calendar
    Oracle Calendar is component of Oracle Collaboration Suite which you can
    install stndalone as well as part of oracle collaboration suite . Calnedar is used to book your schedule, online diaries, events and meetings.
    Below note explain implementation of Standalone Calendar so that they can be synchronized with Mobile Handset (For explanation purpose I have taken example of Nokia E61 and Nokia E50 series)
    In order to synch your mobile handset with Calendar you need standalone calendar server and HTTP Server (Oracle HTTP Server or any other web server like Apache, Webspahere...). If you installed Calendar as part of Oracle Collaboration Suite, you don't need web server as it is installed by default with Collaboration Suite.

    Overview of Standalone Oracle Calendar synch directly from Mobile Handset

    A) Install Standalone Oracle Calendar Server
    B) Install Standalone Oracle HTTP Server
    C) Configure Oracle Calendar to access via Oracle HTTP Server
    D) Upgrade Calendar to version to get Nokia E50 and E61 profiles
    E) Configuration at Nokia Handset / Mobile device
    F) Related Documentation

    Below is software and operating system I used which can vary as per your

    --Standalone calendar Server
    --Standalone Web Server (Oracle HTTP Server)

    Installed on same machine in two different oracle_home (Though you can install them on different machine as well)

    ORACLE HOME for Calendar : /apps/oracle/product/CAL
    ORACLE HOME for Oracle Web Server : /apps/oracle/product/OHS

    -- Operating System is Red Hat Linux ES 3 (Though this can be on ES4, solaris or windows as well)

    Calendar and other Software Location
    i) Standalone Calendar -> Calendar Software for Linux
    ii) Standalone Oracle HTTP Server -> Application Server Companion CD
    iii) Red Hat Linux ->

    Operating System Prereq.
    i) Make sure kernel version of Red Hat ES3 should be minimum 2.4.21-27 or higher
    ii) Install following additional RPM’s if they are not installed already. sysstat-4.0.7-4.EL.3.3

    (To check if RPM is already installed or not use "rpm -qa grep {rpm_name}" )

    iii) Add following kernel parameters in /etc/sysctl.conf
    kernel.shmall = 3279547
    kernel.shmmax = 2147483648
    kernel.shmmni = 4096
    #semaphores: semmsl, semmns, semopm, semmni
    kernel.sem = 256 32000 100 142
    fs.file-max = 327679
    net.ipv4.ip_local_port_range = 10000 65000
    kernel.msgmni = 2878
    kernel.msgmax = 8192
    kernel.msgmnb = 65535

    and execute "sysctl –p /etc/sysctl.conf" (From root user)

    iv) Add following lines in /etc/security/limits.conf
    * soft nproc 4096
    * hard nproc 16384
    * soft nofile 16384
    * hard nofile 65536 (Don't forget to put *)

    Start Standalone Calendar Installation
    Login with user "oracle" (or any other user with whom you wish to install software). Navigate to standalone calendar software location and start installation like

    i) /calendar_standalone/runInstaller

    ii) Click Next on Welcome Screen and enter ORACLE_HOME name PATH and click next.
    PATH /apps/oracle/product/CAL

    iii) Select component you wish to install and click Next, Select All Components

    iv) Select language (leave default) and click Next

    v) Select directory server you wish to use : Select Internal in our case

    vi) Enter Oracle Calendar Administrator Password (This will be used during administration and user management)

    vii) In Oracle-Calendar Node ID screen enter Node ID, since this is our first and only Node so lets make this one as Master Node with ID as 1 (Select this as Master Node)

    viii) Enter Host or Alias, Enter host name here as any thing your actual hostname of machine or virtual name like

    ix) Click Next & then click on Install Button

    On successful installation Next Step is to install Web Server (Oracle Standalone HTTP Server)

    Standalone Oracle HTTP Server Installation
    Login with username "oracle" or any other user with whom you wish to install HTTP Server. Navigate to Oracle HTTP Server software location and Start OHS Installation using runInstaller

    i) ./runInstaller

    ii) Click Next on Welcome Screen and enter ORACLE_HOME name PATH and click next
    PATH /apps/oracle/product/OHS

    iii) Select Product to Install, Select Web Server Services

    iv) Select Installation Type Select Oracle HTTP Server with Apache 2.0

    v) Select other default options till install screen

    vi) Click Next & then click on Install Button

    vii) In the end it will ask you to execute From root execute like /apps/oracle/product/OHS/

    Configure Oracle Calendar With Oracle HTTP Server
    In Order to configure Calendar via Mobile Handset, first it should be accessible via HTTP Server on HTTP/HTTPS protocol. So in this step we will configure Oracle Calendar with HTTP Server

    i) Include following files in httpd.conf of HTTP Server at

    /apps/oracle/product/CAL/ocad/config/ocad.conf and /apps/oracle/product/CAL/ocas/conf/ocal.conf

    (Here ocad.conf is Oracle Calendar Server Configuration file and ocal.conf is Oracle Calendar Application Server or OCAS configuration file)

    ii) Restart OHS as
    export ORACLE_HOME

    opmnctl stopall
    opmnctl startall (opmnctl is located in $OHS_HOME/opmn/bin directory)
    iii) Start Calendar & OCAS Server
    export ORACLE_HOME
    unistart (located in $CAL_HOME/ocal/bin)
    ocasctlstartocasctl –start –t ochecklet
    (located in $CAL_HOME/ocas/bin)

    iv) Create users and groups using Node administration Screen

    In my case during Calendar Installation, I hostname or Alias as and default HTTP Server port number during installation was 7777 so I'll access Calendar Administration Screen as

    v) Check if you can access Calendar via Web Services URL
    http://hostname.domainname:port/ocas-bin/ocas.fcgi?sub=web or

    If you get message like "Message Catalogue Unavailable" check Metalink Note # 275524.1

    Synch Calendar from Mobile Part II


    Collaboration Suite Overview
    Calendar Server Overview

    Synchronizing Calendar directly from Mobile Handset with important files and related documentation coming in part II

    Labels: ,

    We have moved to

    kindly check in future

    add to  ¦  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:36 PM   2 Comments

    We have moved to kindly check http://onlineAppsDBA.comin future
    URL Firewall in DMZ/Self Service Setup (url_fw.conf)
    Friday, June 01, 2007
    Register for R12 upgrade
    In Self Service or DMZ Setup (from 11.5.10) you might have noticed new configuration file url_fw.conf under $IAS_ORACLE_HOME/Apache/Apache/conf . In today's post We'll understand requirement of this file , building blocks of this file, mod_rewrite module of apache and regular expressions.

    Overview of url_fw.conf file is required ?

    This file is delievered by patch 3942483 (included in 11.5.10) and called by Apache/Webserver configuration file httpd.conf .

    This file uses mod_rewrite module of Apache to allow/disallow URL's matched by regular expression.

    Why I need this file - > This file provide extra security for DMZ or Self Service implementation accessible over internet. Only few URL's opened/allowed by this file are accessible thus protecting secured URL which should not be accessible via internet.

    On what basis its decided to include url_fw.conf -> If node trust level is marked as external (Three type of Node Trust level for a node , External, Internal, Administration) then Autoconfig includes url_fw.conf file in httpd.conf

    What is mod_rewrite and where to get more information -> mod_rewrite is URL Rewrite Engine in Apache (on which Oracle-Apache or Oracle HTTP Server or Web Server in Apps). mod_rewrite is powerful tool for URL manipulation like to

    - Restrict Access to directories and files
    - Conditional redirection of access
    - Relocating Servers, File System or Directories
    - Regeneration of static pages based on HTTP Header Variable

    For more information on mod_rewrite module of apache visit

    How to debug mod_rewite issues ?
    If you think some of URL's (complete url or partial - gif, jpg, html or jsp file) are blocked by above URL Firewall and you wish to know which file is blocked , you can enable logging by adding following directive in url_fw.conf

    RewriteLog "/your_log_directory/rewrite.log"
    RewriteLogLevel 7

    By default logging is disabled , logLevel value is from 0-10 (0 means no logging and 10 is log everything which records all steps mod_rewrite is doing in background) a sensible value is 6 or 7 and you will see in log what URL is blocked and by what rule; so that if you think user should have access to that URL you can grant access on that resource by adding new rule in url_fw.conf

    Sample url_fw.conf value and its meaning -
    RewriteRule ^/$ /OA_HTML/AppsLocalLogin.jsp [R,L]
    RewriteRule ^/OA_HTML/jsp/fnd/fndhelp.jsp$ - [L]

    Here first rule is saying that when user type / i.e. after hostname , domainname and port number and then /; redirect user to /OA_HTML/AppsLocalLogin.jsp and stop applying any rewrite rule after that.

    In second rule; - which means don't do any thing and present User same url as mentioned in left side i.e. /OA_HTML/jsp/fnd/fndhelp.jsp

    here [R,L] in end
    R- Means Rewrite
    L - Last rewrite rule (No more rule to apply after this)

    In order to understand above rules , you should know regular expression and here few tips/meta characters on regular expressions

    1) . (dot) means matches any characters
    2) [] specifies a class
    ---> [a-z] matches any lower case characters from a to z
    --->[a-zA-Z0-9] matches any character upper or lower case from a to z and numeric 0 to 9
    ---> [abc$] matches a or b or c or $
    ---> [^0-9] matches anything except digit 0 to 9 . Here ^ is negation

    Meta Characters in Regular Expressions

    ^ -> Matches Start of a line
    $ -> Matches End of line


    ^appsdba -> Matches any line starting with appsdba
    appsdba$ -> Matches any line ending with appsdba
    ^appsdba$ -> Matches any line which consist of just one word appsdba

    Quantifiers for Characters
    --> ? matches zero or one instance of character
    --> + matches one or more instance of character
    --> * matches zero or more instance of character

    For Example
    appsdba? matches appsdb or appsdba
    appasdba+ matches appsdba, appsdbaa, appsdbaaa and so on
    appsdba* matches appsdb, appsdba, appsdbaa, appsdbaaa and so on

    Few error messages related to URL Firewall are
    -- Access to requested URL has been blocked by the url firewall
    -- Gone URL you are looking for is blocked by url Firewall
    -- Error in opening up attachments or date picker in iStore, iRec, iProc
    -- FW-1 at Firewall-2: Access denied

    For more information on DMZ and E-Business Suite visit Steven Chan's post at

    Please leave your comments about anything and things you wish to see on this blog.

    Few things on Users Request, coming soon on Oracle Applications R12
    -- Startup / Shutdown scripts and changes in scripts with 11i version
    -- New Top INSTANCE_TOP and its advantages in Oracle Apps Release 12

    Labels: ,

    We have moved to

    kindly check in future

    add to  ¦  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:55 PM   2 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 @

    See my complete profile

    View Atul Kumar's profile on LinkedIn

    E-mail Subscription

    Enter your email address:

    Delivered by FeedBurner

    Only search this Blog
  • 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
    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
    Copyright © 2006 All rights reserved Presented by Atul Kumar