|
We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
| Oracle Collboration Suite |
| Monday, February 26, 2007 |
|
With today's post I'll cover another Fusion Middleware product which I am using for quite some time now i.e. Oracle Collaboration Suite .
Major components in Oracle Collaboration Suite are
-Real Time Collaboration
-Content Server
-Mail Server
-Calendar
-Meetings
-VoiceMail
-Fax
-Threaded discussion
-Workspaces
Few reason why an Enterprise should prefer Oracle Collaboration Suite against other Collaboration Tool in market:
1. Easy to Use Content Management tool with Version Control & fine grained access policy at various levels for regulatory Compliance
2. Secure way of communicating instantly with individuals or groups in and across enterprise using text, voice or conferencing features of OCS for problem solving, mitigate risk and deliver crisp and instantaneous communication to users across globe
3. Single Integrated view of oracle mail, meeting invitation, voicemail, fax and threaded discussion from single integrated box
4. OCS establishes process controls across all content with a centralized repository to cost-effectively audit, retain, archive, and manage content for compliance—and to react with agility when new regulatory pressures appear.
5. Adaptability of business processes with Service Oriented Architecture
6. Highly secure Oracle Messenger solution built on XMPP standard & archived interactions (chat / web conference) into database
Questions you should ask before Implementation:
- How many user are going to access OCS ( Smaller, Medium, Large , Very large )
- What all component of OCS customer is planning to use from following (Mail, Mobile, RTC, Content, Calendar, Search, Discussion)
- Customer want to access internally (Intranet) or externally as well (Internet) over SSL or Non SSL
- Availability / Failover Strategy (What is acceptable downtime during planned & unplanned outages) , Does customer want to implement Failover site & any backup strategy they are already following
- Scalability - Plan for growth - How much growth customer is expecting in Usages in future
- Any specific Security requirement at Enterprise level
- How many Instances (Development / Test / UAT/ Production) customer is interested
Installation/Upgrade/disaster recovery/High Availability/Troubleshooting/SSL implementation for Oracle Collaboration Suite coming soon ..Labels: 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 @ 11:12 PM
  |
|
|
|
We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
| Independent Oracle Applications DBA Consultant |
| Sunday, February 25, 2007 |
|
|
I was thinking of this for quite some time & I have finally decided to work as an Independent Oracle consultant. I am Oracle Applications DBA (E-Business Suite/ Financials/ HRMS, Fusion Middleware /Application Server /Collaboration Suite /Application Express) certified on Oracle Applications and have been awarded with prestigious Oracle ACE designation. A former Oracle Employee, I have proven track record in big implementations with Advanced configuration including HA Clusters & DR, Installation, Upgrades, Migration & Support.
I accept work related to Oracle Applications varying from 1 day to few months (daily/hourly rate) or entire project (Mail/Phone Me for Quotations) . For more information contact me via Mail or Phone at +44 (0) 7701 030035
Broad Category of Work related to Oracle Apps DBA
-- New Implementations / Installations
-- Migrations & Upgrades
-- Onsite / Remote Applications Support including patching, cloning, maintenance
-- Heath Checks/Performance Tuning
-- Oracle Trainings
on Database, E-Business Suite, Fusion Middleware, Application Server, Collaboration Suite
This is an overview of some of my skills & work which I have done recently.
Oracle Applications/E-Business Suite (Financials / HRMS - AP, AR, GL, FA, INV, Grants, CRM, Web ADI, iProcurement, iRecruitment, Workflow, XML, Student System )
- Upgrade Oracle Apps 11.5.9 to 11.5.10.2 and database upgrade to 10g R2
- Implementing & configuring self service middle tier with SSL in DMZ setup , Multiple domain URL's for Internal & External Apps Users
- Installing Oracle Applications Instance 11.5.7-10 & R12 version
- Installing & configuring Discoverer 10g with Apps 11i
- Configuring middle tier cluster with shared APPL_TOP for High Availability
- Configuring RAC database with Apps with Parallel Concurrent Processing
- Implementing Disaster Recovery solution for apps using Data-Guard & Maximum Availability Architecture
- Patching , Cloning, Performance Tuning various Apps components including database
- Backup & Recovery using RMAN
- Monitoring Oracle Applications database including Forms, Web, Reports, CM, Jserv via OEM-OAM plug-in with email & mobile alerts
- Configuring 10g Application Server with Apps 11i
- Configuring & Supporting Apps with two Node RAC and multiple middle tier for High Availability
Oracle Application Server 9i/10g or Fusion Middleware (HTTP Server, OC4J, Portal, Webcache, OID, SSO, AS Guard)
- Install Fusion Middleware products (AS, BPA, BI, SOA, IM) with Single Node / Multi Node
- Seamless Disaster Recovery solution for 10g Application Server including Middle Tier using AS Guard (Application Server Guard) & Data Guard
- Upgrading Portal for 9.0.4 to 10.1.4 on multi-node installation
- Migrating Portal from Solaris to Linux with integration of Portal OID with Microsoft Active Directory
- Configuring Virtual Host & SSL implementation on Single Sign-On Server including Server Hardening for Security
- Configuring Multiple Node Middle Tier cluster for High Availability with Virtual Host Implementation
- Configuring Webcache clusters & tuning webcache for better response
- Implementing Fusion Middleware in High Availability Model with two Node RAC database, two Node OID cluster & multiple middle tier cluster
- Migrating OID users & groups across various OID Instances
- Monitoring & system usages of Portal web site using freeware web access monitoring tool like AWSTAT
- Patching & cloning of Fusion Middleware products
Oracle Collaboration Suite (Real Time Collaboration, Content, Workspace)
- Installation of Oracle Collaboration Suite 10g with Multi Node architecture
- Upgrading OCS to 10.1.2.3 & databases to 10g R2
- Implementing SSL for Single Sign-On Server for secure authentication
- Oracle Drive & MS Web folder configuration
- Integrating collaboration Suite OID for automatic user & group synchronization with Portal OID
- Backup & Recovery implementation using RMAN tools
- Disaster Recovery implementation with Failover & Switchover configuration during planned & un-planned outages
Applications Express / HTMLDB
Contact me via Mail or call me at +44 (0) 7701 030035
For any Issues/Doubts in Apps use Forum at http://teachMeOracle.com/forum Labels: others |
We have moved to kindly check onLineAppsDBA.com in future
|
|
|
|
del.icio.us
¦
Digg This
¦
My Yahoo
¦
Reddit
¦
BlinkList
¦
Furl It
¦
Email This
¦
Leave Your Comments
|
| posted by Atul Kumar @ 6:32 PM
|
|
|
|
We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
| Oracle Fusion Middleware Part II |
| Sunday, February 18, 2007 |
|
|
Lets continue from last post "Overview of Fusion Middleware"
Business Intelligence
--------------------------
This product covers most of business Intelligence needs in today's world like ad hoc query analysis, reporting & publishing, dashboards and real time analysis.
Collaboration Suite
------------------------
This product provides tools to collaborate seamlessly from any application or device in an enterprise. Key component of Collaboration Suite are Real Time Collaboration, Content Services (iFS in past), Workspaces, eMails, Discussions, Calendar . More on this coming soon...
Data Hub
------------
It is central location for your entire enterprise data from all sources to get 360 degree view of enterprise data. You can update & clean you data in data hub and then use application to view this data.
Data Integrator
-------------------
As name suggest this product integrate vast amount of data across heterogeneous systems. This is based on ELT (Extract Load & Transform) architecture and provide Hot-Pluggable (Drop & Deploy) knowledge modules.
EDA Suite (Event Driven Architecture)
---------------------------------------------
Product to create, process, analyze and manage with as less possible custom coding . component of EDA suite are BAM (Business Activity Monitoring), Business Rules, Enterprise messaging, ESB (Enterprise Service Bus), Sensor Edge Server. You will know more about these components in comping topics on Service Oriented Architecture (SOA) Suite.
Identity Management
----------------------------
OID and Oracle SSO integrated with various other Identity management components like Web Access Control, Federated Identity & user provisioning.
SOA Suite
------------
Product for building , managing & developing SOA's . Various components of SOA suite are BPEL, Web Service Manager, BAM (Business Activity Manager)
If this post is quite heavy for you , I am going to cover "preparing Oracle Apps R12 Installation on Linux" . I'll cover on location to download software with Disk labels & staging Oracle Apps R12 software and new features available with Oracle Apps R12 installation.Labels: fusion |
We have moved to kindly check onLineAppsDBA.com in future
|
|
|
|
del.icio.us
¦
Digg This
¦
My Yahoo
¦
Reddit
¦
BlinkList
¦
Furl It
¦
Email This
¦
Leave Your Comments
|
| posted by Atul Kumar @ 12:27 PM
|
|
|
|
We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
| Oracle Fusion Middleware Overview |
| Friday, February 16, 2007 |
|
|
Lets briefly discuss about Oracle Fusion Middleware and one liner on its various components to give you a feel of Oracle Fusion Middleware.
What is Fusion Middleware ?
Oracle Fusion Middleware is a family of oracle product's which will help in application development and integration solution to Identity Management, Collaboration Suite & Business Intelligence reports.
Various products of Fusion Middleware Family are
Application Server
BPA Suite (Business Process Analysis)
Business Integration
Business Intelligence
Collaboration Suite (Content, RTC, Mail Server, Discussion, Calendar)
Data Hub
Data Integrator Developer Tools
EDA Suite (Event Driven Architecture Suite)
Identity Management
SDP Suite (Service Delivery Platform)
SOA Suite (Service Oriented Architecture)
Web center Suite
For most of us grasping/understanding all of them at once is difficult so I 'll be discussing one liner about all these components and later I'll cover them in detail based on each components importance & use in real world.
Application Server
-----------------------
This is core component in Oracle Fusion Middleware. Various component of Application Server are Webcache, j2ee, wireless & portal and uses Infrastructure Services like Single Sign-On and Oracle Internet Directory.
Business Process Analysis (BPA)
---------------------------------------
This helps in modelling business process and converting them to IT executable. Various components of BPA suite helps business user to design, model, simulate and optimize business process. This helps in reducing gap between strategy and actual execution of that strategy. Various components of BPA are Architect, Repository, Simulator & Publisher.
Business Integration
-------------------------
Connecting or Integrating processes, Applications or information with business partners using hot pluggable products which are based on Services Oriented Architecture.
For Next Part Click HereLabels: fusion |
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 @ 11:34 PM
|
|
|
|
We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
| Is Oracle Fusion really ConFUSION ? |
| Wednesday, February 14, 2007 |
|
|
If you ask question "What is Oracle Fusion ?" to yourself I suppose every one will have different opinion. I would like to hear from you all in your words ( via comments on this post ) about what you think is Oracle Fusion .
Common confusion over Oracle Fusion
Most Common confusion over Fusion among most of guys I discuss/meet & also mentioned by Steven Chan in his post is thinking Oracle Fusion Middleware & Oracle Fusion Applications are same. In actual Oracle Fusion Middleware will be used in providing/building Oracle Fusion Applications using Existing Oracle Applications (Oracle E-Business Suite, Siebel, Peoplesoft, JD Eward).
Oracle Fusion Middleware is collection of Oracle Middleware products i.e.
--Oracle Application Server (Portal, Wireless, Forms, Reports, discoverer, Webcache, OC4J)
-- Oracle Identity management (OID, SSO, Web Access Manager, CA, Identity Federation)
--Oracle SOA Suite (Service Oriented Suite)
--Oracle Collaboration Suite (RTC, Mail Server, Discussion, Content, Calendar)
--Oracle DW & BI (BI Beans, OWB, OLAP, Express Server, OSA, OFA, Datamart )
--Oracle development Tools (Designer, developer, SCM, forms, reports)
-- Oracle Data hubs
and
Oracle Fusion Applications will be collection of Oracle Applications i.e.
--Oracle E-Business Suite / CRM
--Oracle Peoplesoft enterprise
--Oracle Siebel CRM
--Oracle JD Edward Enterprise
These fusion applications will use Fusion Middleware mentioned above
Few links which talk about Oracle Fusion Middleware & Fusion Applications are
http://blogs.oracle.com/schan/newsItems/departments/fusionApps
http://oracle.anilpassi.com/oracle-fusion-development-tools.html (Good one for developers & techno functional)
http://blog.oraclecontractors.com/?cat=4
http://www.oracle.com/applications/fusion.html (Good one for Oracle Fusion Applications Road Map)
More on Service Oriented Architecture (SOA Suite) and Oracle Fusion coming soon...
Leave your comments on what you think is Oracle Fusion ? Is this just another Jargon ? Labels: fusion |
We have moved to kindly check onLineAppsDBA.com in future
|
|
|
|
del.icio.us
¦
Digg This
¦
My Yahoo
¦
Reddit
¦
BlinkList
¦
Furl It
¦
Email This
¦
Leave Your Comments
|
| posted by Atul Kumar @ 12:45 PM
|
|
|
|
We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
| Upgrade Oracle Applications to 11.5.10 CU 2 |
| Saturday, February 10, 2007 |
|
|
This post is coming bit late & I know lot of you might be wondering when Oracle Apps R12 is in market why I am still writing on 11.5.10 Upgrade . Looking at quesries/doubts/document request by many of my readers in mail and in forum at http://teachMeOracle.com/forum I thought of covering entire 11.5.10 upgrade and its related docs in this post.
This post will focus on 11.5.10.2 which is oracle apps version 11.5.10 with CU 2 and patch number is 3480000 and related metalink note is 316365.1 . Minimum prereq AD patch for 11.5.10.2 is AD.I.2 (4337683)
Please Note:
1. Patch 348000 (11.5.10.2) is for 11.5.9 or lower version , If you are already on 11.5.10 and which to apply CU2 then this is not right patch for you.
2. Steps mentioned here are for upgarding your apps version 11.5.X , This post doesn't cover upgrade procedure from 10.7 or 11.0.3
3. If you have language other than US then you have to apply translated version of patch as well
4. To reduce Upgrade downtime you can use staged APPL_TOP methodology mentioned in metalink note # 242480.1 Using a Staged Applications 11i System to Reduce Patching Downtime
5. MRC schema is no more used from 11.5.10 onwards so you can drop MRC schema after upgrade so there is no need to maintain/synchronize MRC before or after 11.5.10 (CU2) upgrade
6. 11.5.10.2 requires database version 9.2.X and higher so you can upgarde to 9.2.X or 10.1.X before Upgarde . If you wish to upgrade to database 10.2.X then its better you do it after 11.5.10.2 Update.
7. Since I upgraded Financial & HRMS system so I will focus on steps related to these module but check optional steps mentioned in metalink note # 316365.1 , There are some additional steps for Windows which are not covered in this post
8. To reduce patch downtime online help patches can be applied at later stage
A) Pre Update task
Compulsory Steps
-----------------
A.1 As mentioned above apply AD.I.2
A.2 Update Autoconfig Tech Stack template files - Autoconfig uses Template files to build files specific to your applications
A.3 Run Technology Validation Utility - This will test minimum tech stack components required to run 11.5.10.2 (Tech Stack components are database, forms & reports, discoverer, Jinitiator, JDK, OJSP, JDBC, libraries for web & form server )
A.4 Check OATM step mentioned in optional steps below. If you are not migrating to OATM mentioned above then prepare your table space to include new space requirement and new products . Read me of patch 3180164 will help you in creating additional tablespaces.
Optional Steps
----------------
A.5 Manual Update script - Run this script to find optional & compulsory manual steps you should do before upgarding (This script is specific to an Instance and vary instance to instance)
A.6 Convert database to OATM (Earlier tablespace were based on OFA/Optimal Flexible Architecture where each product used to have one data & one index tablespaces so there were around 200+ tablespace which was difficult to manage which is now moved to ATM/Application Tablespace Model which is simple to manage & there are around 15 table spaces)
A.7 This steps is only required if you are using audit trails & shadow tables name > 26 characters. For auditing purpose you may have auiting enabled for Instance which you want to upgrade then you must change shadow table names (I will cover more on auditing in oracle applications in coming post) before any new columns can be added . HRMS & Payroll customers with Auditing enabled focus on this. If you are not sure if any of your shadow table name is > 26 then use script FNDATCTBL.sql provided with patch 3872242
A.8 If you are using any of product which require ilog planner libraries then apply related patches
A.9 Unmerge of Contacts from TCA Process is long running process during 11.5.10.2 upgrade process so if you wish to reduce downtime during upgrade
then run this program before upgrade else it will be executed during upgrade
process
Apply Maintenance Pack
===================
1. Shutdown application tier services
2. If your database is not 9i upgrade it now
3. Apply maintenance patch . This is unified driver
4. Apply any additional languages patches (If your installation is multi language)
Post Update task
==============
1. Apply Interoperability patch (If you upgraded database to 10g)
2. Register new product , If you want to use any product installed as part of 11.5.10.2 you have to manually license it via OAM
3. Drop MRC schema (As mentioned above MRC schema is no longer required from
11.5.10)
4. If you are not using HRMS Pack I before upgrading to 11.5.10.2 then you have to apply HR legislative updates
5. There are product specific updates which you should carry out with your
functional consultant.
For complete list and extensive steps to upgrade follow metalink note # 316365.1Labels: 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 @ 8:23 PM
|
|
|
|
|
|
