Saturday, October 24, 2009

Raise SR to MetaLink with Customary RDA

I have made myself a rule regarding raising SRs to Metalink, the premier Oracle Support Portal.

When I raise SR, however the trivial or complex looking problem, I make sure that I include the RDA output with my SR. I try to generate RDA output w.r.t to the problem. RDA allows you to generate output for full product, or drill down to the component of that product. For example, if I am having issues with the Oracle HTTP Server of iAS 10g, I could generate RDA output for just OHS.

Remote Diagnostic Agent is a fine tool to gather the information about your system, not only for the Oracle Support guys, but also for yourself.

RDA assist the Oracle Support person in resolving your problem, it contain vast amount of configuration and diagnostic data that reduces the shuttling between you and the support guy.

Read more about RDA in Doc ID: 330363.1 of metalink.

Wednesday, October 21, 2009

Error While Registering Report Services in Metadata Repository of AS10g

I am installing Oracle Application Server 10g (10.1.2.0.2) on Redhat Linux AS 4.

I have two machines, one is aimssrv.test.com and the other is aimsrep.test.com. I am installing the metadata repository and the forms services on aimssrv.test.com and report services on the aimsrep.test.com. I have managed to successfully install the metadata repository and the forms services on aimssrv.test.com.

When I try to install the report services on aimsrep.test.com, during installation, OracleAS 10g Rel 2 (10.1.2.0.2) midde tier install is giving the following error in the "Select Oracle Application Server 10g Metadata Repository" screen.

Invalid Database or either the database or listener are not running. Please verify your selection

The Metadata Repository database and the TNS Listener are both up and running. A connection to the Metadata Repository via SQL*Plus and tnsping works fine.

The problem as it turns out is that there was no entry for the servers in the DNS. As I mapped the IP addresses of the servers in DNS server, the error got away.

This is one of the many reasons, I believe that the Oracle Application Server is the not a charming product at all. I have my hosts file configured, and when I give the OID credentials in report services installation screens, it picks up the information from the metadata repository, but then says that the invalid database.

I hop Oracle WebLogic Server is a better alternative.

Sunday, October 11, 2009

Oracle Open World 2009 Today

Oracle is taking the world by storm today. The bombastic event which is about to be unfolded contains thousands of sessions, thousands of speakers and visitors, and under one roof, it's an exquisite amalgamation of DBA, Developers, sysadmins, storage and hardware enthusiasts and many more.

Oracle is about to unleash it's new dazzling offers from core database 11g R2 to OLTP machine to Oracle Fusion Middleware to game arena to much more.

Visit Oracle Open World, where ever you are in the world.

Saturday, October 10, 2009

Oracle Apps R12: From iAS10g to WebLogic Server

Right now, Oracle's E-Business Suite R12 uses Oracle Application Server 10.1.2 and Oracle Application Server 10.1.3 in the technology stack of the Application Tier.

As Oracle is moving forward with the WebLogic Server, an integral part of the Oracle Fusion Middleware, replacing the Oracle Application Server, the question is what's it's implications for the Oracle Applications R12?

Thursday, October 8, 2009

An unexpected error has been detected by HotSpot Virtual Machine

I was trying to install Oracle 11g Release 2 (32-bit) on Oracle Enterprise Linux (32-bit) and the hardware was 64 bit.

Everything went fine but at the end of the installation process, the netca and the dbca failed. I started to manually configure them, but they failed again.

After long searching, the answer was that it was a BUG!!!

And the bug number is Bug 8930861, according to metalink note:942076.1

There is no workaround still.

To avoid this, you have to use 64 bit oracle with 64 bit OS on 64 bit hardware

Sunday, October 4, 2009

Portal Galore at Oracle

So which Portal option, should I choose from Oracle:

Oracle Portal
Oracle WebLogic Portal
Oracle WebCenter Portal
Oracle PeopleSoft Portal

have I missed any other portal technology from Oracle?