jump to navigation

Which OS are you!! November 13, 2008

Posted by Manpreet Johal in General, Oracle Application Server.
add a comment

Oracle Portal Performance Reporting October 20, 2008

Posted by Manpreet Johal in Oracle Application Server, Portal.
Tags: ,
add a comment

Oracle Portal provides performance reporting scripts tool, with help of which administrators can generate performance statistic reports for portal page access, web cache hits, portlet response time, etc.

Performance reporting scripts tool is a collection of scripts which create a schema named OWA_PERF in the database to store performance data captured from OracleAS log files. OWA_PERF schema can be created in Metadata Repository database for test environment. Since the performance data loading and access consumes significant database resources, it is recommended that this schema should be created in separate database, other than the database used by OracleAS i.e. neither Metadata Repository database nor a customer database (used for application data).

Administrators can upload performance data from OracleAS log files, into the database using set of scripts provided. Performance reporting scripts set provides set of SQL scripts, which can be executed against OWA_PERF schema to access performance statistics for various Portal components in simple tabular format reports. 

Portal Page Access by Day Report

Portal Page Access by Day Report

Performance reporting scripts provide a HTML file which contains links to performance reports generated via these set of scripts. 

Portal Performance Reports

Portal Performance Reports

References:

OracleAS 10g Patch Set 3 (10.1.2.3.0) May 18, 2008

Posted by Manpreet Johal in Oracle Application Server, Portal.
Tags: ,
add a comment

Oracle has released OracleAS 10g Patch Set 3 (10.1.2.3.) – ML Patch#5983622 in April ‘08.

This patch set can be applied to following releases of OracleAS 10g:

  • OracleAS 10g Release 2 (10.1.2.0.0, 10.1.2.0.2, 10.1.2.1.0, 10.1.2.2.0)
  • OracleAS 10g Release 2 Standard Edition One (10.1.2.0.1)
  • OracleAS Forms and Reports Services (10.1.2.0.2)
  • OracleAS Portal 10g Release 2 (10.1.4, 10.1.4.1)
  • Oracle Developer Suite 10g (10.1.2.0.2)
  • Oracle BI 10g Release 2 (10.1.2, 10.1.2.0.2)
  • Oracle BI Tools 10g Release 2 (10.1.2, 10.1.2.0.2)

This patch set will also upgrade Portal version from 10.1.4.1 to 10.1.4.2.

Oracle Applications 11i or R12 customer must check the certification matrix before upgrading standalone OracleAS 10g instances which are integrated with Oracle Applications environment.

References:

Search in Oracle Portal May 10, 2008

Posted by Manpreet Johal in Oracle Application Server, Portal.
Tags: ,
add a comment

Oracle Portal provides a deployment framework for applications based on industry standards e.g. J2EE, JSR168, WSRP etc. Oracle Portal is also used as a document management or content management solution, as a centralized store for corporate documents. This feature offers more enhancements than storing documents in network share e.g. at NTFS drive located in Windows environment. I will dedicate a separate post for comparison between Oracle Portal based document management solution and network share based document storage. One of the major enhancements is the option to search the documents or content uploaded to Oracle Portal based document repository.

In this post, I would like to highlight the options available to search the content in Oracle Portal. Following are the options to search content in Oracle Portal:

  • Basic Search – Item and Portlet: This is available as a built-in item type and portlet for Page Designer/Developers. It does not provide an option to provide search operators while performing search.
  • Advanced Search – Portlet: It provides additional search operators for search. It also provides an option to search based on item/document attributes e.g. search based on Author of the item/document.
  • Custom Search – Portlet: In addition to features available in Advanced Search portlet, it provides an option to define the layout of Search Form and Results Page. It also allows Portlet Publishers to use separate Search Results page for each of the Custom Search portlet. Another useful feature of Custom Search is that it provides an option to automate the search action based on search term specified i.e. whenever user will access the page, Custom Search portlet will perform the search and will display the results in portlet region. For example, end user can create Custom Search portlet to show list of documents uploaded to Oracle Portal in last 7 days.

Oracle Portal search options mentioned above, provide an interface to perform search on item/document uploaded to repository. Oracle Portal Search crawls and index the content/document in Portal repository at regular interval. Oracle Portal Search uses Oracle Text for indexing of items/documents uploaded by default. Administrators can enable/disable the option to use Oracle Text for Oracle Portal search. However, if Oracle Text is disabled in Oracle Portal, search will only return results based on terms found in item/document metadata only. In order to search the content of the documents uploaded e.g. Word, Excel, Powerpoint, PDF etc. Oracle Text must be enabled.

Oracle Portal Search perform the search based on permissions available to end user i.e. users will be able to search the content/document for which he/she is authorized. Thus, it will not violate the security policy by searching the un-authorized content and returning results to users.

References:

Oracle Portal Release 11 March 17, 2008

Posted by Manpreet Johal in Oracle Application Server, Portal.
Tags: ,
add a comment

While reading Portal Statement of Direction, I found a glimpse of new features that Oracle has planned to introduce in next major release of Portal i.e. Portal Release 11.

For those who are curious, like me, to find out what Oracle is introducing in next release of Portal, I have summarised few of the new features in this post that I found useful:

  1. A two-step portal export/import model based on database links configured between source and target portal instances. It will really improve the code deployment process among Portal deployments.
  2. OmniPortlet will provide an advanced parameter form that allows you to populate a LOV dynamically based on a SQL query/database column. This feature is available in Portal 10g as well. However, it was not out of the box, it was required to tweak portlet configuration files, which was quite error prone. Another option is that develop your own custom parameter form based on PL/SQL. So, this new feature will definitely reduce the complexity and time involved in custom parameter form development.
  3. BPEL-based Process Content Routing and Approval – a useful feature for customers who are using Portal as a document/content management framework, whether they want to leverage simple workflow included in Portal or more complex approval chain based on Oracle BPEL Workflow.
  4. New list of portlets:
    1. Oracle Oracle Secure Enterprise Search (search submission and search results)
    2. Oracle BPEL (notifications, task analysis, reporting),
    3. Oracle Business Intelligence Enterprise Edition (Siebel BI Tools)
    4. Hyperion System 9 BPM (Business Performance Management)
    5. Support for incorporation of portlets from Peoplesoft Applications, including PeopleSoft Version 9These features will allow customers to leverage Portal interface to publish dispersed content from various enterprise applications in personalized interface.

So next release of Oracle Portal will also enhance customers’ application integration experience where they want to extend Oracle Portal by building new presence-aware and context-aware applications on top of Portal layer, using Oracle WebCenter. Thus, adding Web 2.0 capabilities to Oracle Portal.

This is a glimpse based on Statement of Direction document, final product release will give us a real insight into what new features Portal Release 11 holds. Let us wait and watch.

References:

Recovering OracleAS Instance after Node Failure February 11, 2008

Posted by Manpreet Johal in Oracle Application Server.
Tags: , ,
add a comment

In earlier post, we discussed about OracleAS Recovery Manager, a tool to perform backup and recovery operations at Oracle Application Server instances. In this post we will discuss about Loss of Host Automation (LOHA), a feature of OracleAS Recovery Manager to recover OracleAS node after operating system or hardware failure.

LOHA provides a solution for a loss of host when you want to restore the original instances to a new environment without having to reinstall the instances and preserve the application data. LOHA automates the tasks necessary for the Oracle Application Server administrator to migrate Oracle Application Server instances from one host to another. The new host can be a different host running the same operating system or the same host after system re-install.

Following are the few points to be considered while using LOHA:

  • LOHA supports all middle-tier installations (Web Cache, J2EE, Portal/Wireless, Business Intelligence and Forms), and the new host’s name can be the same or different from the original host.
  • For metadata repositories and Infrastructure installations, only the target host name must be the same as the original host.
  • For an Oracle Identity Management installation, full automation is supported if the new hostname is the same as the original.
  • LOHA does not support the Toplink standalone install type.
  • Manual work is required for different host names.

LOHA can move all the Oracle Application Server instances from one host to a new host if the new host does not have any other Oracle Application Server instances already running.

Like OracleAS Recovery Manager, Loss of Host Automation (LOHA) is a functionality that must be utilized by OracleAS deployments.

How LOHA recovers the OracleAS instance to new host?

It make use of node/image backup performed at former host to build the environment at target host.

In order to implement LOHA, one can refer to standard OracleAS 10g R2 documentation.

References:

What is OracleAS Recovery Manager? January 6, 2008

Posted by Manpreet Johal in Oracle Application Server.
Tags: , , ,
2 comments

In this article, I am putting some glimpse on OracleAS Recovery Manager (earlier known as OracleAS Backup and Restore Tool), which is a perl based tool to perform backup and recovery operations for Oracle Application Server 10g installations i.e. Infrastructure and Middle-Tiers.  It is installed by default when OracleAS 10g Middle-Tier or Infrastructure is installed.

I have seen customers who have implemented Oracle Application Server instances and are relying on daily cold backup strategy for Infrastructure and Middle-Tier instances. Very few are using Oracle Database Recovery Manager (RMAN) to backup Metadata Repository Database.

OracleAS Recovery Manager is a tool that supports online backup for configuration files (including the J2EE applications deployed) and Metadata Repository Databases. It supports two types of backups for Oracle Application Server:

1. Image Backup: It includes the Oracle home directory for that instance, the OraInventory directory, the oratab file, and Windows registries on that node and finally a cold instance backup of that Oracle Application Server instance. Following images shows the files that are backed up during Image Backup:

2. Instance Backup: It includes the configuration information of Oracle Application Server components and deployed applications.  Instance backup is further divided into three types:

i) OracleAS Infrastructure Backup: It backs up the entire Oracle Metadata Repository database. Next, the tool requests Distributed Configuration Management (DCM) to create and export a consistent archive (jar file) of the configuration schemas from the DCM repository for DCM-managed components like Oracle HTTP Server (OHS) and OracleAS Containers for J2EE (OC4J). Then, the tool adds the archive file to the backup.

ii) OracleAS Middle-Tier Backup: It backups the configuration information of all its Oracle Application Server components and deployed applications. Some of these components, like Portal, Wireless, Integration B2B, and Oracle Business Intelligence Discoverer are not managed by DCM. They have their product metadata in the Oracle Application Server Metadata Repository database which is backed up by the Backup and Recovery Tool in the Oracle Application Server Infrastructure instance.

However, it can also be used to perform backup and recovery operations for Metadata Repository Databases created using Metadata Repository Configuration Assistant (MRCA).

As a best practice, Image Backup should be performed after installation or whenever any major configuration change (e.g. patch application) is performed. It serves as a baseline backup for all subsequent Instance Backups. Instance backup should be performed on regular basis.

OracleAS Recovery Manager provides another powerful feature known as Loss of Host Automation (LOHA). LOHA automates the tasks necessary for the Oracle Application Server user to migrate Oracle Application Server instances from one host to another. E.g. if you lost the operating environment due to hardware failure and you need to setup the complete environment at new machine, with fresh operating system; LOHA provides the functionality to restore the OracleAS instance to new machine by setting Oracle installation environment i.e. registry entries (for Windows), oratab entries (for UNIX/Linux), oraInventory entries, and system files. LOHA utilizes Image Backup to restore the OracleAS instance to its backed up state. I will explain more about this feature in future posts.

This tool is pretty simple to configure. Administrators can configure it via command line or using OracleAS Control Console. After configuration it populates backup template scripts located at ORACLE_HOME/backup_restore directory as per environment and components installed.

OracleAS Recovery Manager uses RMAN for database backups and recovery. It supports full and incremental backups for configuration files and databases. Administrators can use the pre-defined incremental backup scripts with various levels (Level 0, Level 1, Level 2, Level 3, and Level 4) and can customize them as per backup strategy requirements. Incremental backup levels are applicable to database backups only, and are not applicable for configuration files. So if administrator is using incremental scripts specifying Level 1, it will perform Level 1 incremental backup for Metadata Repository database and standard incremental backup for configuration files.

Moreover, this is the tool which provides underlying functionality in OracleAS Disaster Recovery configuration to restore node configuration i.e. OracleAS Guard make use of OracleAS Recovery Manager to read configuration changes at active node and apply at standby node.

Oracle Application Server Middle-Tier – Part I June 12, 2007

Posted by Manpreet Johal in Oracle Application Server.
1 comment so far

All the way from WebDB to currently OracleAS 10g has matured enough and accomodated many components into its family. As I discussed in my earlier posts about OracleAS Overview and OracleAS Infrastructure, in this post I will be covering OracleAS Middle-Tier.

OracleAS Middle-Tier is a part of OracleAS 10g which serve as a application server, business-logic store, content caching server, web services directory, wireless access point for business applications, business process monitoring and business intelligence reporting tool.

It is having following components:
OracleAS Wireless: It serves as a wireless application store. We can deploy wireless-enabled J2EE applications which can be accessed from mobile devices.
OracleAS Portal: We can deploy web applications built using PL/SQL and J2EE. It provides integrated development environment known as Portal Builder.
Using Portal Builder, developers/end users can integrate the content from multiple sources e.g web feeds, web services, flat files, database tables and publish as portlets on a single page/multiple pages. Pages built in Portal can be configured to access via Mobile Devices as well.
OracleAS Portal stores its configuration and applications information in database store known as Portal Repository. Portal Repository by default is created in OracleAS Metadata Repository database, but can be stored in a separate database.
Oracle Components for J2EE (OC4J): Heart of OracleAS 10g. This component is providing a mechanism to deploy J2EE compliant applications at OracleAS 10g or you can say this framework is making OracleAS 10g J2EE compliant. Developers can deploy WAR, EAR files built using JDeveloper, Eclipse or any other J2EE compliant IDE.
OracleAS WebCache: It caches the static and dynamic content being served by OracleAS. It stores the cached content in memory and filesystem. Whenever end user accesses the OracleAS URLs, request goes to Web Cache. If Web Cache founds the content matching to user request in its cache, it will process the request and return the response to user browser. This concept is know as Cache Hit. If Web Cache didn’t find the content requested by user’s request in its cache, it will redirect the request to other OracleAS components, depending on type of request. This concept is known as Cache Miss.

Configuring Reverse Proxy in front of OracleAS 10g SSO January 17, 2007

Posted by Manpreet Johal in Identity Management, Oracle Application Server.
add a comment

OracleAS 10g Middle-Tier talks to OracleAS 10g Single Sign-On (Component of OracleAS Infrastructure), which provides a mechanism to authenticate OracleAS application users against LDAP directory store i.e. Oracle Internet Directory.

OracleAS Infrastructue consists of Oracle HTTP Server, which acts as a web listener for Single Sign-On and Delegated Administraion Services. Whenever end-users accesses the SSO protected URL (OracleAS Middle-Tier applications e.g. Portal, Wireless), request got redirected to OracleAS SSO, serving the auth page via Oracle HTTP Server. Thus, end user will get SSO Login page containing URL of Oracle HTTP Server running at OracleAS Infrastructure Services.

Sometimes business needs to hide the OracleAS Infrastructure web URL and Port for security purposes. At that time, reverse proxy came into picture. End users as well as OracleAS Middle-Tier applications will talk to Reverse Proxy URL and Port for requests, which in turn will fetch the content from OracleAS Infrastructure and service the request.

It provides enhanced security model i.e. end user and applications will be aware of Reverse Proxy URL and Port only, not the original OracleAS Infrastructure services URL.

So, let us configure a reverse proxy in front of OracleAS Infrastructure. I have used Oracle HTTP Server Standalone 10.1.2 [Based on Apache 2.0] (OracleAS 10g 10.1.2.0.2 Media – Companion CD) as a reverse proxy. Assume that my OracleAS 10g 10.1.2.0.2 Portal and Wireless installation is functional with Infrastructure on two separate nodes:

URL: http://infra.mycompany.com:7777/

OS User: oracle

Node: infra

OracleAS Middle-Tier Services Node:

URL: http://portal.mycompany.com:7777/

OS User: oracle

Node: portal

Oracle HTTP Server (Reverse Proxy) Node:

URL: http://proxy.mycompany.com:7779/

OS User: oracle

Node: proxy

Install Oracle HTTP Server Standalone 10.1.2 at nodename proxy. During installation, chose Web Services 10.1.2.0.0 as a Product and Oracle HTTP Server (based on Apache 2.0) as an Installation Type. After installation, OHS Standalone is functional at URL: http://proxy.mycompany.com:7777

1. Navigate to OHS Standalone Home/ohs/conf directory. Edit httpd.conf to add following directives in respective sections.LoadModule proxy_module modules/mod_proxy.so
LoadModule proxy_http_module modules/mod_proxy_http.so
LoadModule proxy_connect_module modules/mod_proxy_connect.so
ProxyRequests Off

Order deny, allow
Allow from all

ProxyPass / http://infra.mycompany.com:7777/
ProxyPassReverse / http://infra.mycompany.com:7777/

2. Restart OHS

At this stage Oracle HTTP Server Standalone will be functional.

Now let us made changes at OracleAS Infrastructure tier

1. Navigate to $ORACLE_HOME/Apache/Apache/conf directory.

2. Edit httpd.conf to modify following directives with corresponding values:
KeepAlive off
ServerName proxy.mycompany.com
Port 7777

3. Add VirtualHost directive at end of httpd.conf file:

RewriteEngine On
RewriteOptions inherit

4. Save the httpd.conf, and update DCM Repository:
$ dcmctl updateconfig –ct ohs –v –d

5. Modify SSO Server Home URL to reverse proxy hostname and port:
$ORACLE_HOME/sso/bin/ssocfg.sh http proxy.mycompany.com 7777

6. Re-register mod_osso on SSO Middle-tier with reverse proxy hostname and port:
$ORACLE_HOME/sso/bin/ssoreg.sh
-oracle_home_path $ORACLE_HOME
-site_name inf1012.infra.mycompany.com
-config_mod_osso TRUE
-mod_osso_url http://proxy.mycompany.com:7777

7. Login to OID using OIDADMIN, and change orcldasurlbase attribute (Location: Entry Management->cn=OracleContext->cn=Products->cn=DAS->cn=OperationURLs) to reflect reverse proxy hostname and port i.e. http://proxy.mycompany.com:7777

8. Update DCM Repository:
$ dcmctl updateconfig –ct ohs –v –d

9. Restart OC4J_Security and Oracle HTTP Server at Infrastructure tier:
$ opmnctl restartproc process-type=HTTP_Server
$ opmnctl restartproc process-type=OC4J_Security

10. Verify by accessing the DAS and SSO Home using Reverse Proxy Hostname and Port:
SSO Home URL: http://proxy.mycompany.com:7777/pls/orasso
DAS URL: http://proxy.mycompany.com:7777/oiddas

11. Validate that login and logout URLs contains reverse proxy hostname and port only.

Now, let us re-configure OracleAS Middle-Tier to work with Reverse Proxy.

1. Re-register mod_osso at middle-tier:
$MID_ORACLE_HOME/sso/bin/ssoreg.sh
-site_name mid1012.portal.mycompany.com
-mod_osso_url http://portal.mycompany.com:7777
-config_mod_osso TRUE
-oracle_home_path $ORACLE_HOME
-admin_info cn=orcladmin

2. Re-register Portal with SSO Server:
$ ptlconfig -dad portal -pw -sso -host portal.mycompany.com -port 7777
You need to retrieve Portal Schema password to execute the above command.

3. Clear Portal Cache

a. Stop all the middle-tier processes

b. Delete the content of following directories at Middle-Tier Home:
$ORACLE_HOME/Apache/modplsql/cache/plsql
$ORACLE_HOME/Apache/modplsql/cache/session

c. Start the middle-tier processes

d. Login to Portal as admin user, and navigate to Administration tab.

e. Click Global Settings link, and click on Cache tab.

f. Scroll down and select the checkbox Clear the entire Web Cache.

g. Click Apply, and then OK.

4. Update Cache for OID Parameters in Portal

a. Login to Portal as admin user, and navigate to Administration tab.

b. Click Global Settings link, and click on SSO/OID tab.

c. Scroll down, and select check box Refresh Cache for OID Parameters.

d. Click Apply.

e. Verify that DAS Host Name parameter in Cache for OID Parameters section is showing reverse proxy hostname and port.

5. Validate the Portal Logout link. It should contain reverse proxy hostname and port.

So, this completes our setup of Reverse Proxy in front of OracleAS Infrastructure Services.

Put Infrastructure In Place December 15, 2006

Posted by Manpreet Johal in Identity Management, Oracle Application Server.
1 comment so far

OracleAS Infrastructure Services, logical component of Oracle Application Server 10g, provides security services for OracleAS Middle-Tier applications as well as external applications integrated with OracleAS Infrastructure services. OracleAS Infrastructure has evolved to a state where it can be deployed along with other Identity Management products like Microsoft AD and SunONE Directory Server.

It can be broken down into two sub-components:- Oracle Identity management: Group of applications providing authentication, authorization, policy definition, policy enforcement, entity lifecycle management for integrated applications e.g. OracleAS Portal, Oracle Database, E-Business Suite, Oracle Collaboration Suite, and third party applications.

Brief description of Identity Management Components:

o Oracle HTTP Server: It provides web-interface for Infrastructure Services e.g. Delegated Administration Service and Single Sign-On. OHS is based on Apache 1.3.31. This is not a standard Apache available at http://www.apache.org/. It does contains Oracle’s extensions to standard Apache.

o Oracle Internet Directory: At core of Oracle IDM Infrastructure, an LDAPv3 Directory Service, providing LDAP interface for storage and retrieval of applications configuration data. It stores information about Users, Groups, Network Configurations, Databases, OracleAS Products, and Access Control Lists etc. It stores that complete information in Oracle Database known as OracleAS Metadata Repository. In other words, Oracle Internet Directory is an application running on Oracle Database.

o Oracle Delegated Administration Service: This is a web-based Self Service Console to define users, groups, realms, and configuration entries for custom object classes. In other words, this is a web interface for Users Management of Users data stored in Oracle Internet Directory.

o Directory Integration: A very useful component of IDM stack. Using this you can integrate your Oracle Internet Directory with 3rd Party Directory Services like Microsoft AD, SunONE Directory etc. You can push data from OID to other directories as well as pull data from them.

o Oracle Directory Integration Provisioning Service: Alongwith its counterpart Directory Integration, DIP Service extends the integration capabilities. DIP will help you to achieve integration of Oracle E-Business Suite with Oracle Internet Directory for synchronization of Users data.

o OracleAS Single Sign-On: A gateway to OracleAS Identity Management for web-applications. It protects the web resources of Oracle Application Server like Portal, Delegated Administration Service (Partner Applications) and third-party applications like Yahoo Mail (External Applications)

o Oracle Certificate Authority: A component to generate X.509V3 certificates for OracleAS.

Oracle Metadata Repository: It contains OracleAS configuration data stored in Oracle Database 10g. Alongwith configuration data, OracleAS components Schemas also reside in Metadata Repository. But these can be installed in another database as well, provided that has been prepared for, by Metadata Repository Creation Asisstant. By default, Portal schemas are installed in Metadata Repository.

During installation of OracleAS Infrastucture, Metadata Repository will be installed in Oracle Database 10g. OracleAS component uses this database. In order to store data for custom applications, you must use a separate database known as Customer Database. It helps in more granular control on both these databases.

OracleAS Infrastructure services can be deployed independent of OracleAS Middle-tier i.e. no need to deploy complete Oracle Application Server. To leverage the centralized storage of application Users and Groups, Oracle Internet Directory can be deployed. Alongwith Single Sign-On can be used protect web resources using same centralized Users and Groups information.

In past, Oracle has done couple of acquisitions that has really extended the Identity Management offering and solutions provided by Oracle.

My focus is to first explain the base Oracle Application Server product, followed by advanced topics, integration, and extensions.

Coming Up Next:

OracleAS Middle-Tier Services