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
    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 10.1.2.4 to get Nokia E50 and E61 profiles
    E) Configuration at Nokia Handset / Mobile device
    F) Related Documentation

    Assumptions
    ---------------------
    Below is software and operating system I used which can vary as per your
    requireemnt.

    --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 -> http://rhn.redhat.com/

    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
    gnome-libs-1.4.1.2.90-34.2
    compat-glibc-7.x.2.2.4.32.6

    (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.
    ORACLE_HOME CAL_HOME
    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 focusthread.com

    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
    ORACLE_HOME OHS_HOME
    PATH /apps/oracle/product/OHS

    iii) Select Product to Install, Select Web Server Services 10.1.2.0.2

    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 root.sh From root execute like /apps/oracle/product/OHS/root.sh

    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/OHS/ohs/conf

    /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
    ORACLE_HOME=/apps/oracle/product/OHS
    export ORACLE_HOME

    opmnctl stopall
    opmnctl startall (opmnctl is located in $OHS_HOME/opmn/bin directory)
    iii) Start Calendar & OCAS Server
    ORACLE_HOME=/apps/oracle/product/CAL
    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
    http://hostname.domainname:port/ocad-bin/ocad.cgi?object=nodeadm

    In my case during Calendar Installation, I hostname or Alias as
    focusthread.com and default HTTP Server port number during installation was 7777 so I'll access Calendar Administration Screen as
    http://focusthread.com:7777/ocad-bin/ocad.cgi?object=nodeadm

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

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

    Next
    Synch Calendar from Mobile Part II


    Related

    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

    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:36 PM  
    2 Comments:
    • At 7:45 AM, Blogger Unknown said…

      Hello Atul,

      I like your document on Oracle Calendar. However, I have a question. Does the Oracle Calendar Server require a live I/P.

      As I have both Pocket PC and Nokia E50 Mobile Phone, but no live I/P. So if thats the case, I would need to purchase one.

      Regards,
      Irfan Momin
      Oracle Applications DBA

       
    • At 12:26 PM, Blogger Atul Kumar said…

      Irfan,
      Since you are going to sync to calendar server via your data service provider in your case your phone service provider and they can only see public IP and not your private IP so yet you need a public IP on OCS in order to synch oracle calendar directly from mobile

       
    Post a Comment
    << Home
     
    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