|
We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
| Install Oracle SOA Suite : 10.1.3.1.0 |
| Wednesday, June 20, 2007 |
|
This is third and last part of installing Oracle SOA Suite version 10.1.3.1.0
Overview of SOA Suite Installation
1. Download and Install Database (I used 10.2.0.1 but 9.2.0.7 and higher is also valid)
2. Upgrade database to 10.2.0.2 (If this is 10.2.0.1 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 (10.2.0.1 for XE or 10.2.0.2 or higher for EE).
Before starting SOA Suite installation make sure you have
-- Installed Database version 10.2.0.1(Click on this link on how to install database on linux)
--Upgraded Database to version 10.2.0.2 (only If you selected EE database during installation)
1. Download SOA Suite Software (soa_linux_x86_101310_disk1.cpio) from http://www.oracle.com/technology/software/tech/webservices/index.html
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.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
./runInstaller
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 irca.sh as mentioned above.
Provide Password which you supplied during irca.sh 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: fusion, soa |
We have moved to kindly check onLineAppsDBA.com in future
|
|
|
 del.icio.us
¦
 Digg This
¦
 My Yahoo
¦
 Reddit
¦
 BlinkList
¦
 Furl It
¦
Email This
¦
Leave Your Comments
|
posted by Atul Kumar @ 7:56 PM
  |
|
|
|
We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
| Upgrade Oracle Database to 10.2.0.2 : SOA Suite Install Part II |
| Saturday, June 16, 2007 |
|
|
Next step in installing SOA Suite after installing 10.2.0.1 database is to upgrade this oracle database to version 10.2.0.2 (4547817).
For Oracle Database 10.2.0.1 Installation Step and Software location click here
If you selected Standard Edition during 10.2.0.1 database installation, you can skip this database upgrade step. This is because for Enetrprise Edition Database, SOA Suite is certified only with 9.2.0.7 and higher (in 9i database) or version 10.2.0.2. ( For Standard Edition database 10.2.0.1 is certified with SOA Suite 10.3.0.1).
For detailed information on how to upgrade from 10.2.0.1 database to version 10.2.0.2 follow readme of patch 4547817 or metalink note 316900.1
Few things about 10.2.0.2 patch set
i) 10.2.0.2 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 p4547817_10202_LINUX.zip (download patch according to your operating system like windows, solaris..) and copy it to your linux machine
ii) Unzip patch as “unzip p4547817_10202_LINUX.zip”
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
ORACLE_SID = SOADEV
export ORACLE_HOME ORACLE_SID
(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 10.2.0.2 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 root.sh , login as root from another window and execute root.sh 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 10.2.0.2 but we haven’t upgraded our database yet to 10.2.0.2 (In next step we will upgrade our database to 10.2.0.2 version).
Upgrade 10.2.0.X database to 10.2.0.2
----------------------------------------------------
Please note steps mentioned here are for upgrading database to 10.2.0.2 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 10.2.0.2 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 10.2.0.2.0
vii) SQL> shutdown
viii) SQL> startup
ix) SQL> @?/rdbms/admin/utlrp.sql
x) SQL> select count(*) from dba_objects where status like ‘INVALID’;
Count (*)
0
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 10.2.0.2 version.
If you are hitting any issues in upgrade, raise them in forum dedicated to apps dba's at http://teachMeOracle.com/forum or leave a comment here.
Loading ORABPEL, ORAESB and ORAWSM schema in above database and SOA Suite installation coming next...Labels: database, soa, upgrade |
We have moved to kindly check onLineAppsDBA.com in future
|
|
|
|
del.icio.us
¦
Digg This
¦
My Yahoo
¦
Reddit
¦
BlinkList
¦
Furl It
¦
Email This
¦
Leave Your Comments
|
| posted by Atul Kumar @ 9:52 AM
|
|
|
|
We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
| Oracle SOA Suite Installation Part I : Database Installation |
| Wednesday, June 13, 2007 |
|
|
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 10.2.0.1 on same machine under ORACLE_HOME.
--This demo installation is on Redhat Linux ES 3 which is on VMWare.
Install Oracle Database 10.2.0.1
-------------------------------------------
Software for Oracle Database can be downloaded from this link
Operating System Prereq.
For linux following version are supported for database version 10.2.0.1 at time of writing this doc
-Redhat-3
-Redhat-4
-SuSe-9
-Aslinux-1
-Aslinux-2
I picked up Red hat ES -3 (Enterprise Server) as operating system.
Packages and Kernel Parameters mentioned below are for database 10.2.0.1 on Red Hat linux Version 3 (Check Installation Documentation if your operating system version differs)
Packages
Following packages with atleast following version should be installed
binutils-2.14
gcc-3.2
libaio-0.3.96
glic-2.3.2-95.47
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
unzip 10201_database_linux32.zip
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)
This will complete your database installation for SOA Suite Installation.
If you wish to start/stop oracle database installed above
Set PATH, ORACLE_HOME, ORACLE_SID like
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: fusion, soa |
We have moved to kindly check onLineAppsDBA.com in future
|
|
|
|
del.icio.us
¦
Digg This
¦
My Yahoo
¦
Reddit
¦
BlinkList
¦
Furl It
¦
Email This
¦
Leave Your Comments
|
| posted by Atul Kumar @ 7:56 PM
|
|
|
|
We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
| Start-up Shutdown Scripts in Oracle Apps R12 |
| Sunday, June 10, 2007 |
|
|
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
Then
B) Start Application/Middle Tier Services
-- adstrtal.sh
Order for shutdown in Oracle Apps R12 is
A) Stop Application/Middle Tier Services
-- adstpall.sh
Then
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 addbctl.sh
- For Database Listener
Use script addlnctl.sh
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
i) adstrtal.sh
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)
ii) adstpall.sh
Master script to stop all components/services of middle tier or application tier.
iii) adalnctl.sh
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 )
iv) adapcctl.sh
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 1.0.2.2.2 but in R12 its 10.1.3) v) adcmctl.sh
Script to start / stop concurrent manager, Similar to one in 11i. (This script in turn calls startmgr.sh )
vi) adformsctl.sh
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
vii) adformsrvctl.sh
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
viii) adoacorectl.sh
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
ix) adoafmctl.sh
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
x) adopmnctl.sh
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.
xi) jtffmctl.sh
This script will be used to start/stop one to one fulfilment server.
xii) mwactl.sh
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: apps, r12 |
We have moved to kindly check onLineAppsDBA.com in future
|
|
|
|
del.icio.us
¦
Digg This
¦
My Yahoo
¦
Reddit
¦
BlinkList
¦
Furl It
¦
Email This
¦
Leave Your Comments
|
| posted by Atul Kumar @ 6:27 PM
|
|
|
|
We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
| Synchronize Oracle Calendar directly from Mobile Part II |
| Friday, June 08, 2007 |
|
|
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 10.1.2.0.0 doesn't contain profiles for Nokia E50 or E61 (as these handsets were certified later in version 10.1.2.4 i.e. patch set 4) hence we have to patch it to version 10.1.2.4. 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 10.1.2.4.0
Upgrade Calendar to version 10.1.2.4
------------------------------------------------
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 1.0.0.0.56
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
Application -> 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 - http://focusthread.com/ocst-bin/ocas.fcgi , 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: calendar, ocs |
We have moved to kindly check onLineAppsDBA.com in future
|
|
|
|
del.icio.us
¦
Digg This
¦
My Yahoo
¦
Reddit
¦
BlinkList
¦
Furl It
¦
Email This
¦
Leave Your Comments
|
| posted by Atul Kumar @ 7:04 PM
|
|
|
|
We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
| Synchronize Oracle Calendar Directly from Mobile Handset |
| Sunday, June 03, 2007 |
|
|
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)
ocasctl –startocasctl –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: calendar, ocs |
We have moved to kindly check onLineAppsDBA.com in future
|
|
|
|
del.icio.us
¦
Digg This
¦
My Yahoo
¦
Reddit
¦
BlinkList
¦
Furl It
¦
Email This
¦
Leave Your Comments
|
| posted by Atul Kumar @ 8:36 PM
|
|
|
|
We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
| URL Firewall in DMZ/Self Service Setup (url_fw.conf) |
| Friday, June 01, 2007 |
|
|
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 http://httpd.apache.org/docs/1.3/mod/mod_rewrite.html
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]
or
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
i.e.
---> [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
like
^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
http://blogs.oracle.com/schan/2006/05/17
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 12Labels: apps, security |
We have moved to kindly check onLineAppsDBA.com in future
|
|
|
|
del.icio.us
¦
Digg This
¦
My Yahoo
¦
Reddit
¦
BlinkList
¦
Furl It
¦
Email This
¦
Leave Your Comments
|
| posted by Atul Kumar @ 6:55 PM
|
|
|
|
|
|
