Archive

Archive for the ‘General’ Category

Integrating Oracle Apps 11i with MS AD 2008

December 24, 2009 4 comments

After the release of MS Windows 2008, customers are planning to upgrade their MS AD 2003 deployments to MS AD 2008 (as part of OS upgrade to MS Windows 2008) to achieve the benefits provided by MS Windows 2008. For the companies, which are using Oracle Applications 11i or Oracle Internet Directory 10g products, and have integrated these products with MS AD 2003 to achieve Single Sign-On will not be able to keep the certification intact, after upgrade of MS AD 2003 to MS AD 2008. Reason being, Oracle Apps 11i or Oracle Internet Directory 10g are not certified with MS AD 2008 as of now.

Metalink Note – Is OID 10g Compatible with Microsoft Active Directory 2008 [ID 944298.1] states that OID 10g is not certified with MS AD 2008. However, OID 11g is certified with MS AD 2008.

So, as OID 11g is not yet certified with Oracle Apps 11i, integration deployments with Oracle Apps 11i/OID 10g cannot be integrated with MS AD 2008.

Well, there is a way around to achieve this. However, that will involve introduction of additional component I.e. Oracle Identity Manager (OIM), a component of Oracle Identity Management Suite, provides a identity provisioning solution for Oracle and non-Oracle products. Oracle Identity Manager is certified to use with Oracle Internet Directory 10g and MS Active Directory 2008.

Oracle Identity Manager provides connectors for OID 10g and MS AD 2008, which allows users created in MS AD 2008 to be reconciled into OIM, which in turn will propogate user information to OID. In turn, OID will propagate those changes to Oracle Apps 11i FND_USER table.

References:

Which OS are you!!

November 13, 2008 Leave a comment

SQL Developer 1.5 – New Features

Oracle has released SQL Developer 1.5 (1.5.0.53.38)  last month. I tried that version recently, and found couple of new features that are worth mentioning. Following are the few of the new features that I found useful:

SQL Worksheet

  • Flashback. For 10g and 11g, you can use flashback on your data. See the Flashback tab on Tables.
  • Separate unshared worksheet for connections for long running queries. Use the keystroke ctrl+shift+N. This will create a separate, unshared worksheet.

Navigator

  • Run Manage Database report ( as SYS) to shut down and rest rat database
  • Generate DB Doc (right-click for context menu on connections) for all objects in a schema. Open the generated index.html file in a browser to review objects.

Generate DB Doc

Figure 1: Sample output generated using Navigator: Generate DB Doc option

Connections

  • Support for LDAP and Authenticated Enterprise users
  • OS Authentication

Tuning

  • Open *.trc file in SQL Developer for a formatted trace file.

Reports

  • ASH and AWR reports

It seems that Oracle is continuously extending the functionalities available in SQL Developer with every new release. However, I am definitely looking for a dashboard kind of reporting for specific or multiple databases. Hope we should be able to get that feature in future from Oracle or via 3rd party extension.

References:

Categories: General

Web 2.0 to Enterprise 2.0

December 2, 2007 Leave a comment

Oracle coined the term Enterprise 2.0 by extending the Web 2.0 term in a online webcast. I found that webcast really useful in clarifying Web 2.0 myths and how Oracle technology offerings (Oracle WebCenter Suite) can be used to exploit the capabilities of Web 2.0.

In a nutshell, Web 2.0 is much more than AJAX, Wikis, and Discussion Forums.

To check out more, use this link to view the webcast. 

Categories: General Tags: , ,

Catch me at UKOUG 2007

November 19, 2007 Leave a comment

This year I got an opportunity to speak at UKOUG 2007 at one of my favorite technology i.e. AS Guard. Following are the session details:

Date: 05-Dec-2007
Time: 11:35 AM
Location: UKOUG 2007 at ICC Birmingham.
Topic: Design Disaster Recovery Site with OracleAS Guard 10g

Presentation Abstract:
OracleAS Guard 10g is a tool to design an effective disaster recovery site for OracleAS 10g applications.

This presentation will discuss general deployment topologies for OracleAS Guard and walk-through the setup process of Disaster Recovery Site using OracleAS Guard. Simplified failover, switchover and fallback scenarios using OracleAS Guard will be explained.

The presentation will also focus on the High Availability functionality that OracleAS 10g offers to DBAs and OracleAS Administrators and how this meets the business requirements.

Categories: General

Oracle WebCenter Briefing

July 12, 2007 1 comment

I recently attended Oracle WebCenter 10g R3 Briefing conducted by Oracle. Putting a glimpse of that session:

Oracle WebCenter (a new member in Oracle Fusion Middleware family) is added as an extension to Oracle JDeveloper. It consists of following components:

Oracle WebCenter Framework – A Oracle ADF based user interface technology that can be used to embed AJAX-based components, portlets, content.
Oracle WebCenter Studio and Oracle WebCenter Composer – Tools that can be used to build and deploy user interface and business flows.
Oracle WebCenter Anywhere – Developing and deploying interfaces for multiple devices e.g. mobule devices and desktop applications like MS Office.
Oracle WebCenter Services – Allow to use Oracle Secure Enterprise Search, Oracle Content Database, and Oracle Records Database, and Web 2.0 capabilities.
Oracle WebCenter Spaces – Meant for group collaboration and communications.

Oracle WebCenter is considered as a common framework for Fusion Applications. Although it makes use of ADF (Oracle’s Application Development Framework), but is based on standards e.g. SOA, Web 2.0, JSR 168, WSRP 1.0 and 2.0. Using JSF Portlet Bridge developers can publish any Java Server Faces application as a portlet.

Oracle WebCenter has a capability for Content Integration using content components (based on JSR 227 Data Controls) to directly access content from a given repository and display in personalized manner using JSF View Components.

Oracle WebCenter Communication Services offers Threaded Discussions, Presence Server and Instant Messaging (Oracle Communicator).

Links: Oracle WebCenter Overview

Categories: General

Long Break…. ….

Well, it was a long break, being off from my blog for a long time.

Now we will share the same rhythm of Oracle Technologies that I promised to share in my first post on this blog.

As promised in my earlier post, to conclude the OracleAS architecture, next post will be covering OracleAS Middle-Tier services.

Categories: General

First Post…

November 28, 2006 1 comment

Well, this is my first post to my first blog ever.

This is an attempt to put some technical insight into latest happenings in IT world related to Oracle technologies especially Oracle Application Server and Oracle E-Business Suite.

Categories: General
Follow

Get every new post delivered to your Inbox.