Senthilkumar Rajendran's Blog

dbms_stats.gather_system_stats errors to stop

noreply@blogger.com (Senthil Rajendran) — Fri, 04 May 2012 09:17:00 +0000

Over the weekend I upgraded two databases to 11.2.0.3, Upgrade was successful.

I ran dbms_stats.gather_system_stats to gather system statistics on both the database.
After two days I wanted to stop it.

On one database it errors

oracle@proddb[PRD1]$ sy

SQL*Plus: Release 11.2.0.3.0 Production on Wed Apr 11 07:50:01 2012

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options

SQL> execute dbms_stats.gather_system_stats('stop');
BEGIN dbms_stats.gather_system_stats('stop'); END;

*
ERROR at line 1:
ORA-01426: numeric overflow
ORA-06512: at "SYS.DBMS_STATS", line 27218
ORA-06512: at line 1

SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
oracle@proddb[PRD1]$

On the other database it went fine and stopped
oracle@proddb[OWB]$ sy

SQL*Plus: Release 11.2.0.3.0 Production on Wed Apr 11 07:50:29 2012

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options

SQL> execute dbms_stats.gather_system_stats('stop');

PL/SQL procedure successfully completed.

SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
oracle@proddb[OWB]$

A lot of analysis was done with Oracle Support but in the end I found a simple workaround start and stop again worked;

SQL> execute dbms_stats.gather_system_stats('start');

PL/SQL procedure successfully completed.

SQL> execute dbms_stats.gather_system_stats('stop');

PL/SQL procedure successfully completed.

SQL>

Oracle Support has filed a defect for this tool.

Exalytic vs Hana the big fight starts

noreply@blogger.com (Senthil Rajendran) — Thu, 03 May 2012 10:27:00 +0000

It all started with the latest presentation that Oracle made on Exalytic and these two slides are responsible for it.

Post presentation the discussion started on the internet.

http://www.pcworld.com/businesscenter/article/254779/saps_sikka_fires_back_against_oracles_falsehoods_about_hana.html

It is good to see how Oracle and SAP are moving ahead.

SAP has a free trail platform that runs on HANA , take a look at it https://bi.ondemand.com , there are lots of limitation and also some performance issues but not sure that it is from Business Object or the underlying HANA database.

Oracle is yet to open the cloud platform which is said to run on Exadata and Exalogic , not sure if Exalytic is an offering in their cloud.

WebGate 11g Fails after OAM-OIM Integration

noreply@blogger.com (Senthil Rajendran) — Thu, 03 May 2012 09:38:00 +0000

After reading through several documents finally got a setup up and running with OAM 11g and OIM 11g Integrated with WebGate 11g.

The following is the setup and this is certified as of April 2012 but this may change in future.

Oracle Internet Directory LDAP Store is OID version 11.1.1.5.0
Oracle Access Manager 11.1.1.5.0 + OAM Bundle Patch 02 ( 11.1.1.5.2 )
Oracle Identity Manager 11.1.1.5.0 + OIM Bundle Patch 02 ( 11.1.1.5.2 )
Oracle HTTP Server 11.1.1.5.0
Oracle Webgate 11.1.1.5.0 + Webgate Bundle Patch 02 (11.1.1.5.2)

I would suggest that any one who does the integration or installation to follow Oracle Documentation for the version you are working on because the integration steps keeps changing for every version. There are lots of good blogs and books out there in the market and internet but I would honestly tell some of them are outdated even though the steps are very good and presented in a better way than Oracle Documentation.

After following the complete integration as recommended by Oracle Documentation there is a recommended testing for the integrated environment. Some of the major integration testing are
1. User created in OIM should be propagated to the LDAP Store which is in my case OID
2. Webgate validatation
3. User end to end single sign on

The first point worked good in my case without any issues. The problem started with the second step and then the third.

After reading through several notes and I came across one similar to my setup.
Note 1447494.1

As from OAM 11.1.1.5.2 (Bundle Patch 2) and OIM 11.1.1.5.2 (Bundle Patch 2), use of 11g WebGate is supported for integrated OAM and OIM environments. The settings would then be e.g.:
WEBGATE_TYPE: ohsWebgate11g
ACCESS_GATE_ID: Webgate_IDM

Note: additional, currently undocumented configuration will be required if 11g WebGate is used. It is recommended to register the 11g WebGate with auto-create policies unchecked and Preferred Host set to IAMSuiteAgent. Also resources the following resources will need to be added to the IAM Suite Application Domain because 11g WebGate implements Deny On Not Protected:
/oam -- excluded resource
/oam/.../* -- excluded resource
/oim/ -- Public Authentication Policy, Protected Authorization Policy

I tried to set the preferred host to IAMSuiteAgent and then also added the resources as described under the undocumented configuration.
Now the http://ohs:port is getting to the authentication page.

So now with the additional undocumented steps my Webgate11g validation passed.

But still I could not get the User authenticated and perform a complete end-to-end SSO. I will make a short write up on the same on the up coming post.

Good luck then with the ConFusion Middleware.

ORACLE bug still alive

noreply@blogger.com (Senthil Rajendran) — Mon, 30 Apr 2012 04:10:00 +0000

Four-year old critical Oracle bug still alive - News - iTnews Mobile Edition

Sachin Tendulkar makes 100th International Century

noreply@blogger.com (Senthil Rajendran) — Fri, 16 Mar 2012 11:15:00 +0000

Sachin Tendulkar makes 100th International Century in his Cricket Career.

TIME Magazine's quote on Sachin Tendulkar

"When Sachin Tendulkar travelled to Pakistan to face one of the finest bowling attacks ever assembled in cricket, Michael Schumacher was yet to race a F1 car, Lance Armstrong had never been to the Tour de France,

Diego Maradona was still the captain of a world champion Argentina team, Pete Sampras had never won a Grand Slam.

When Tendulkar embarked on a glorious career taming Imran and company, Roger Federer was a name unheard of; Lionel Messi was in his nappies, Usain Bolt was an unknown kid in the Jamaican backwaters. The Berlin Wall was still intact, USSR was one big, big country, Dr Manmohan Singh was yet to "open" the Nehruvian economy.

It seems while Time was having his toll on every individual on the face of this planet, he excused one man. Time stands frozen in front of Sachin Tendulkar. We have had champions, we have had legends, but we have never had a Sachin Tendulkar and we never will."

Tendulkar is the greatest gift to the world of cricket.

DBUA or Manual Upgrade ???

noreply@blogger.com (Senthil Rajendran) — Fri, 10 Feb 2012 11:09:00 +0000

DataBase Upgrade Assistant or Manual Upgrade ??? If this question was asked to me a year or two back , I would have opted to use manual upgrade of oracle databases. DBUA in the past from my experiences had many bugs and issues.
Once such experiences was DBUA helped me to upgrade on the Test and Development databases. On the production upgrade day it pulled my legs , I have to use the manual approach which I did not plan for.

Did Oracle make the DBUA better ? I think so yes. I used DBUA to upgrade three databases to 11gR2 and all went fine. Also I have made sure that all the pre-upgrade tasks are completely met so that the upgrade is not disturbed because of incorrect setting of some kernel settings or some missed operating system patches. Applying the PSU or CPU to the new Oracle Home also addresses some of the issues.

What has to be done when DBUA fails to do the upgrade ?
Well there are lots of reasons for the failure , but DBUA would stop the upgrade and then give back the option to continue with the upgrade manually after fixing the issue. There are other options that may help you to use DBUA again and rather spending time doing the manual upgrade. One such is to create a restore point prior to the upgrade and incase if DBUA fails in between , then you can restore the database to the flashback restore point and then apply the fix , retry DBUA.

Oracle Database PSU 11.2.0.3.1

noreply@blogger.com (Senthil Rajendran) — Thu, 09 Feb 2012 06:14:00 +0000

Are you applying CPU 11.2.0.3 then consider applying PSU 11.2.0.3.1 as it contains the latest CPU and all the one-off fixes that makes you in sync with Oracle Support. I always make a practice of applying the latest PSU when upgrading database to the next release.

Patch Set Updates (PSUs) are proactive cumulative patches containing recommended bug fixes that are released on a regular and predictable schedule. PSUs are on the same quarterly schedule as the Critical Patch Updates (CPU), specifically the Tuesday closest to the 17th of January, April, July, and October.

The PSUs serve as a new baseline version for reporting issues to Oracle.

There are two latest PSU available
Patch 13343438 DATABASE PATCH SET UPDATE 11.2.0.3.1 (INCLUDES CPU JAN2012)
Patch 13348650 GRID INFRASTRUCTURE PATCH SET UPDATE 11.2.0.3.1 (INCLUDES DB PSU 11.2.0.3.1)

If you are having the Grid Infrastructure home and other database home you can consider applying Patch 13348650 which includes PSU for both the GI and DB Home.

I applied on the Upgraded ASM Home (GI Home) as root user

cat root.sh
export ORACLE_HOME=/oracle/product/asm11.2
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH
export PATCHTOP=/dev/stage/if/stage/11gR2/patchset
opatch auto $PATCHTOP -oh $ORACLE_HOME -ocmrf $ORACLE_HOME/asmocm.rsp

oracle@devdb[+ASM]$ sudo /home/oracle/root.sh
Last successful login: Tue Feb 7 14:48:15 UTC 2012
Last authentication failure: Tue Feb 7 13:22:14 UTC 2012
Executing /usr/bin/perl /oracle/product/asm11.2/OPatch/crs/patch112.pl -patchdir /dev/stage/if/stage/11gR2 -patchn patchset -oh /oracle/product/asm11.2 -ocmrf /oracle/product/asm11.2/asmocm.rsp -paramfile /oracle/product/asm11.2/crs/install/crsconfig_params
opatch auto log file location is /oracle/product/asm11.2/OPatch/crs/../../cfgtoollogs/opatchauto2012-02-07_15-51-25.log
Detected Oracle Restart install
Using configuration parameter file: /oracle/product/asm11.2/crs/install/crsconfig_params
Successfully unlock /oracle/product/asm11.2
patch /dev/stage/if/stage/11gR2/patchset/13348650 apply successful for home /oracle/product/asm11.2
patch /dev/stage/if/stage/11gR2/patchset/13343438 apply successful for home /oracle/product/asm11.2
CRS-4123: Oracle High Availability Services has been started.
oracle@devdb[+ASM]$

The procedure can be used to apply the PSU on the DB Homes as well.

oracle@devdb[+ASM]$ $ORACLE_HOME/OPatch/opatch lsinventory|grep "Patch Set Update"
Patch Description: "Database Patch Set Update : 11.2.0.3.1 (13343438)"
Patch Description: "Grid Infrastructure Patch Set Update : 11.2.0.3.1 (13348650)"
oracle@devdb[+ASM]$

ASM 11g Release 2 and HP Disk Owner Patch

noreply@blogger.com (Senthil Rajendran) — Wed, 08 Feb 2012 10:12:00 +0000

It is always fun with ASM. When upgrading from 11gR1 to 11gR2 ASM might not work properly in discovering the disks. There are some relevant bugs reported with the disk discovery issue when upgrading to 11.2.0.2

The fix is to apply PHCO_41479 which is the latest patch. In my case the server had a much lower version yet the same diskowner patch PHCO_40381.

11.2.0.3 did not have any issue when upgrade and discovering the asm disk with PHCO_40381.
Saved a big downtime in getting the September 2011 HPUX Bundle Patch

It is Database Upgrade Time !!!

noreply@blogger.com (Senthil Rajendran) — Tue, 07 Feb 2012 06:50:00 +0000

With Database 11.1.0.7 Premier Support ending on August 2012 , I have signed up with my existing customer for Database Upgrade to 11.2.0.3. There are two productive environment with each having a test and development environment. Both the environment uses Oracle Warehouse Builder and Fusion Middleware BI Platforms. In total there are going to be 18 database upgrade on HPUX and SUSE platform.

Looks interesting but a lot of planning ahead.

Have started most of the necessary pre-work. I started my career with 10g Release 1 and have done a lots of upgrade. Now here with 11.2.0.3 I believe life is going to be easier with the upgrade process.

I will write about interesting facts that I come across the database upgrade. It is a two months project and I hope will be sharing my experience with the upgrade.

Very large customers with many interconnected Oracle Databases may need to follow the CPU Patch

noreply@blogger.com (Senthil Rajendran) — Wed, 18 Jan 2012 06:46:00 +0000

Came across an article from InfoWorld http://www.infoworld.com/d/security/fundamental-oracle-flaw-revealed-184163-0 If you are supporting very large customers with many interconnected Oracle Databases then there is a possibility of getting a strange bug with SCN. Was wondering if this has ever happened at any customer base or just at the InfoWorld

Good Bye 2011 and Welcome 2012

noreply@blogger.com (Senthil Rajendran) — Mon, 02 Jan 2012 10:53:00 +0000

I wish every one a Happy New Year 2012.

2011 for me was great. It was fun and a thrilling year. I was busy with my one year old son and could not blog much. He kept me busy and took away all my spare time which I used to learn and blog.

Yet with the left over time I was able to master Fusion Middleware 11g Technologies.

Otherwise I saw the big event from Oracle "Open World 2011".
Oracle was very bold in introducing the Exadata , Exalogic and Exalytics hardware.
Oracle got a foot into Cloud Computing and Social Networking.

Oracle and Competitors that kept me very busy. It also gave me a better understanding of what the future is going to be.
- Netezza TwinFin started a lots of discussion explaining and comparing their product with Exadata.
- EMC Greenplum doing the same as Netezza (but more of from storage)
- To join them Teradata gave their explanation for their Exadata Replacement at a Japanese Customer Place.
- Salesforce.com vs Oracle Cloud (everybody who followed Open World will know it better).

Some new products which excited me are Oracle Enterprise Manager 12c and Weblogic 12c.

Wish that I have more time to start blogging this year.

Beware of false clouds

noreply@blogger.com (Senthil Rajendran) — Tue, 11 Oct 2011 07:45:00 +0000

“Beware of false clouds,” Ellison warned. Larry is talking about Salesforce.com

This is the one key slide from his presentation which I am more interested and I do not want to write about the dirty talks between Ellison and Benioff.

Separate Virtual Machines are going to run Database and Applications as per the Customers needs. These virtual machines are running on Exadata and Exalogic.

Migration from an in-house Data Center to Oracle Clould or from another Cloud Service to Oracle Cloud are going to be easier as per Oracle's Statement.

Oracle Public Cloud

noreply@blogger.com (Senthil Rajendran) — Mon, 10 Oct 2011 11:41:00 +0000

Oracle on the Open World 2011 announced their offering towards Cloud and Larry did it in his way.

Oracle sounds serious with its cloud offering. Oracle cloud is unlike the other cloud services available on the market. Oracle Exadata and Oracle Exalogic appliances are the back end for this offering. There are going to be various services offered by Oracle on the Cloud running on Oracle Data Centers.

PaaS (Platform as a Service) and SaaS (Software as a Service) are mixed together to form Larry's foot print on Cloud Computing. Its competitors are Salesforce, Microsoft , IBM and many others.

With the power of Exadata and Exalogic I think Oracle Cloud is going to make a change.

In the end I could see a new definition for the Cloud. It is a new Season "Oracle Cloud"

FMW 11g IDM Setup Part 11

noreply@blogger.com (Senthil Rajendran) — Tue, 06 Sep 2011 13:21:00 +0000

FMW 11g Upgrade Master Index

After completing the middle ware upgrade I am starting with the Identity Management Upgrade to 11g

Oracle Internet Directory was in version 10.1.2.3.0 and this version is certified and recommended by Oracle Support to start with the upgrade. Oracle Support and Development has tested upgrading from this version of 10g to 11g. It is also recommended to move from any earlier version of OID 10g to the supported starting point version.

The first step towards the IDM Upgrade is to configure WebLogic. I have already documented the installation of WebLogic here which was part of the Middleware Upgrade.

Download the latest available IDM Installation Setup and Patchset
Here when I did the install IDM 11.1.1.4.0 was the latest and so I had to download the 11.1.1.2.0 Setup and Patchset 11.1.1.4.0

Below are the steps for the installation
1. Install WebLogic
2. Install IDM 11.1.1.2.0
3. Apply Patchset IDM 11.1.1.4.0

Screenshot from IDM Install

Next I will document about the Config Assistance and Upgrade Assistance

Recommended Book for Oracle Enterprise Manager Grid Control 11g

noreply@blogger.com (Senthil Rajendran) — Mon, 22 Aug 2011 14:01:00 +0000

Recommended Book for Oracle Grid Control 11g specially for people who are in large organization where complete oracle stack in managed in Grid or for people who are at Data centers.

The book goes in-depth on Business Service Management using Oracle Grid Control 11g and also its importance. It deals with the challenges in managing today's data centers. The book also covers the concept of modeling IT infrastructure as systems and services. It also covers in managing IT resources and also how to share it to get more use of them.

Hope this book helps people to know more about Oracle Enterprise Manager 11g and its usability.

FMW 11g Discoverer Version 11.1.1.4.0 Check

noreply@blogger.com (Senthil Rajendran) — Thu, 18 Aug 2011 06:40:00 +0000

FMW 11g Upgrade Master Index

Upgrading Portal+Discoverer Middletire from 11.1.1.3.0 to 11.1.1.4.0
Patch Set p11060983_111140_Linux-x86-64.zip

Using the runInstaller updated the Oracle Home and it was successful.
Then as per the Readme (http://download.oracle.com/docs/cd/E17904_01/doc.1111/e16793/patch_set_installer.htm#CCHBCCGB) , I updated the Schema

Reference FMW 11g Upgrade : MiddleTire 11.1.1.4.0 PatchSet Part 10

Version Check

SQL> SELECT version, status FROM schema_version_registry WHERE owner='PORTAL';

VERSION STATUS
------------------------------ -----------
11.1.1.4.0 VALID

SQL> SELECT version, status FROM schema_version_registry WHERE owner='DEV_DISCOVERER';

VERSION STATUS
------------------------------ -----------
11.1.1.3.0 VALID

SQL>

Now I am seeing that PORTAL has been upgraded to 11.1.1.4.0 but Discoverer keeps in version 11.1.1.3.0 even though 11.1.1.4.0 Patchset is appled.

The reason is documented in the below node
Review Why Does Discoverer Version On Weblogic Console Shows 11.1.1.2 Where As It Should Be 11.1.1.4? (Doc ID 1324782.1)

Applies to:

Oracle Discoverer - Version: 11.1.1.4.0 and later [Release: 11g and later ]
Information in this document applies to any platform.
Discoverer, 11g, Fusion Middleware

Goal

Why Does Discoverer Version On Weblogic Console Shows 11.1.1.2 Where As It Should Be 11.1.1.4?

Solution

If patch 11060983 to patch from version 11.1.1.2 to 11.1.1.4 completed successfully, then your install is fine and it is at the correct version.

The release notes of this patch discuss the fact that some components do not have version numbers that get successfully upgraded with the patch but that does not represent a problem.

Version 11.1.1.2 represents the base version although it was also originally a patch. Version 11.1.1.4 is a patch level but the fact that your version numbers were not updated is not a problem as other Fusion Middleware components have the same problem.

So no need to worry , but I feel Oracle should give a simple script which can be run after post verification to update the version.

FMW 11g Upgrade : MiddleTire 11.1.1.4.0 PatchSet Part 10

noreply@blogger.com (Senthil Rajendran) — Wed, 17 Aug 2011 11:14:00 +0000

FMW 11g Upgrade Master Index

After the successful installation of FMW MiddleTire 11.1.1.3.0 Portal and Discoverer , here are the steps to get them on the latest patchset level 11.1.1.4.0

Pre Steps
- Make a backup of the Oracle Home
- Make a backup of the Database or a Snapshot of the Database before the upgrade

Step 1: Installing the Middletire Software
Step 2: Upgrading the Schema

Installing the Middletire Software

Download the 11.1.1.4.0 Portal and Discoverer Patchset and start the installer. The runInstaller has only the option to upgrade the Oracle Home.

Upgrading the Schema

Schema Upgrade is not done from the UI and instead there is a Patch Set Assistance Script to do it.
The PSA Script is going to only update the PORTAL Schema and there are no upgrade required for the Discoverer Schema.

Set ORACLE_HOME
Go to $ORACLE_HOME/bi
./psa -dbConnectString //fmwserver:1521/INFDB -dbaUserName sys -schemaUserName portal
Watch the logfile of PSA and you should be able to see if there are any errors.
Recompile the Invalids
Complete all the post upgrade steps as per the patch readme.

PSA Log

oracle@testas[]$ cd $ORACLE_HOME/bin

oracle@testas[]$ ./psa -dbConnectString //fmwserver:1521/INFDB -dbaUserName sys -schemaUserName portal

Oracle Fusion Middleware Patch Set Assistant 11.1.1.4.0

Enter the database administrator password for "sys":

Enter the schema password for schema user "portal":

Log file is located at: /oraapp/tst/ora/as/app/products/middleware/as_portal_discoverer/upgrade/logs/psa2011-07-14-06-48-09AM.log

Updating the Oracle Fusion Middleware Metadata Schema to release 11.1.1.4.0.

Updating schema for component Oracle Portal.

The command completed successfully

oracle@testas[]$

FMW 11g Discoverer Plus Error Loading Applet

noreply@blogger.com (Senthil Rajendran) — Tue, 16 Aug 2011 14:03:00 +0000

FMW 11g Upgrade Master Index

After Upgrading to Discoverer 11g 11.1.0.3.0 , loading Discoverer Plus gave the below error message on the Java Console and there was a blank screen with Discoverer Plus

Java(TM) Plug-in: Version 1.4.2_06

Using JRE version 1.4.2_06 Java HotSpot(TM) Client VM

User home directory = C:\Documents and Settings\skrajend

----------------------------------------------------

c: clear console window

f: finalize objects on finalization queue

g: garbage collect

h: display this help message

l: dump classloader list

m: print memory usage

o: trigger logging

p: reload proxy configuration

q: hide console

r: reload policy configuration

s: dump system properties

t: dump thread list

v: dump thread stack

x: clear classloader cache

0-5: set trace level to

----------------------------------------------------

Cache size is: 67562695 bytes, cleanup is necessary

Registered modality listener

Invoking JS method: document

Invoking JS method: URL

Referencing classloader: sun.plugin.ClassLoaderInfo@d9896e, refcount=1

Loading applet ...

Initializing applet ...

Starting applet ...

Connecting http://fmwserver.fmwdomain.com:80//discoverer/plus_files/disco5i.jarjar with no proxy

Connecting http://fmwserver.fmwdomain.com:80//discoverer/plus_files/disco5i.jarjar with cookie "oracle.uix=0^^GMT+2:00^p; orasso=9.0.3+en-us+us+AMERICA+A36002EB37016180E04400237DAA5065+95F5182D2C78A0B6F5A78AFEF9CB7A5542EA593FA7ED2475C5B2EC03A1427E422F1144EF1C5236C6B815D469CB8627CBB3CE975E3AA04CDF73C94A8A12EE4A9D898890AF6D5A17DFC0CBA436896C8B592E4F43974FA9C623; OHS-fmwserver.fmwdomain.com-443=134D0F6EBF6C49A2F9541A5ECFF461BF0417AD00E44FAD079D5FE65856CCB8863C8A50C5C9F2264C9DC3299646FC3C0F91CBD8425F134C64C34D6CC897C5A81A3381273441BEB7E5251BB88EF37CA01F270DC8409F038D0C6E4011ED01B6B7C91C4F8FE354BC9CE61B7BA33259A0FC9D74A2C9C92B1FB06C55DB00007D313CC17608497334F42C3E59999FE49C87EE01E75DEAAE9AF5B53B902D92BDE8C84C1604E6348C31FEF9A0D19BD62D65B461C83A0C5D492CE0849326A926830405D746A03123B914FEBAD365E03362574DB378A80D0B7975FF526E850C7754AED6877BF2136C82C532C6E16B8B70B93B2488E9AECF89FE9FFB5C0511D91FB0DBF715EB536ABB4BB29E6BE8; ORA_WX_SESSION=41C7467683D747E4A69EA4A3314B506C2D5D6A47-0#1; ORA_PORTAL_SESSION_portal=11.1+en-us+us+AMERICA+A3601804D3816AC5E04400237DAA5065+73099B9AFD251A5F32BE723EDCDD0BA8B91EAE0A43D7715C028CA3C0C4457BB0443C0EA139E7F9D27CE939298CF623F42BF8C6FA9DC516BAF862693E809448EA711EA838F6EC1F18D6B52371D6906BD7E0D0814278585A6D"

Downloading http://fmwserver.fmwdomain.com:80//discoverer/plus_files/disco5i.jarjar to cache

Cached file name: disco5i.jarjar-47421506-2d051c7a.zip

Loaded Root CA certificates from C:\PROGRA~1\Java\J2RE14~1.2_0\lib\security\cacerts

Loading JPI certificates from C:\Documents and Settings\skrajend\Application Data\Sun\Java\Deployment\security\deployment.certs

Loaded JPI certificates from C:\Documents and Settings\skrajend\Application Data\Sun\Java\Deployment\security\deployment.certs

Loading certificates from JPI session certificate store

Loaded certificates from JPI session certificate store

Checking if certificate is in JPI permanent certificate store

java.lang.UnsupportedClassVersionError: oracle/disco/DiscoApplet (Unsupported major.minor version 50.0)

at java.lang.ClassLoader.defineClass0(Native Method)

at java.lang.ClassLoader.defineClass(Unknown Source)

at java.security.SecureClassLoader.defineClass(Unknown Source)

at java.net.URLClassLoader.defineClass(Unknown Source)

at java.net.URLClassLoader.access$100(Unknown Source)

at java.net.URLClassLoader$1.run(Unknown Source)

at java.security.AccessController.doPrivileged(Native Method)

at java.net.URLClassLoader.findClass(Unknown Source)

at sun.applet.AppletClassLoader.findClass(Unknown Source)

at java.lang.ClassLoader.loadClass(Unknown Source)

at sun.applet.AppletClassLoader.loadClass(Unknown Source)

at java.lang.ClassLoader.loadClass(Unknown Source)

at sun.applet.AppletClassLoader.loadCode(Unknown Source)

at sun.applet.AppletPanel.createApplet(Unknown Source)

at sun.plugin.AppletViewer.createApplet(Unknown Source)

at sun.applet.AppletPanel.runLoader(Unknown Source)

at sun.applet.AppletPanel.run(Unknown S

Cause

JRE 1.4 is not supported

Solution

Upgrade or Install the latest JRE 1.6 which is Supported.

FMW 11g Post Install using the Verify Option in Upgrade Assistance gives failure message for Discoverer

noreply@blogger.com (Senthil Rajendran) — Tue, 16 Aug 2011 06:16:00 +0000

FMW 11g Upgrade Master Index

Upgraded Portal and Discoverer to FMW 11g

Post Install using the Verify Option in Upgrade Assistance gives failure message for Discoverer

[2011-05-06T08:20:04.037+00:00] [Verify] [ERROR] [UPGAST-02004] [upgrade.Verify] [tid: 12] [ecid: 0000Iz4P5zs52jk5Oz_Aid1DkuvX000004,0] Error sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target while requesting http://testserver.tdomain.com:80/discoverer/viewer(7799,7781,80).
[2011-05-06T08:20:04.037+00:00] [Verify] [ERROR] [] [upgrade.Verify] [tid: 12] [ecid: 0000Iz4P5zs52jk5Oz_Aid1DkuvX000004,0] Cause: The server was unavailable. Action: Review the log file for the server. Verify that the source of the URL is correct.
[2011-05-06T08:20:04.038+00:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 12] [ecid: 0000Iz4P5zs52jk5Oz_Aid1DkuvX000004,0] All web checks failed
[2011-05-06T08:20:04.038+00:00] [Verify] [ERROR] [] [upgrade.Verify] [tid: 12] [ecid: 0000Iz4P5zs52jk5Oz_Aid1DkuvX000004,0] Test of Discoverer named discoverer failed

Here is what Oracle Support has to say about it.

For some upgrade scenarios, the Oracle Fusion Middleware Upgrade Assistant provides a Verify feature that attempts to analyze the upgraded 11g environment. When you run the Verify feature, the Upgrade Assistant automatically reports any problems it finds with the upgraded environment.

However, there are cases where the Verify feature incorrectly identifies a problem. For example, when single sign-on is enabled, the Verify feature might report that it cannot access specific URLs for the upgraded components.

In these cases, you should enter the URL directly into a Web browser to verify the URL. In those cases, the URL might indeed be valid and you can ignore the errors generated by the Verify feature.

This information has been published by development in the FMW release notes 11.1.1.4

ref. Oracle® Fusion Middleware Release Notes 11g Release 1 (11.1.1) for Linux x86-64
3.1.16 Inaccurate Results When Running the Upgrade Assistant Verify Feature
http://download.oracle.com/docs/cd/E17904_01/doc.1111/e14770/upgrade.htm#BABJGJBG

Today India celebrates its Independence Day

noreply@blogger.com (Senthil Rajendran) — Mon, 15 Aug 2011 02:44:00 +0000

FMW 11g Portal and Discoverer Post Upgrade verification failed with ORA-7445

noreply@blogger.com (Senthil Rajendran) — Sun, 14 Aug 2011 13:34:00 +0000

FMW 11g Upgrade Master Index

After upgrading Discoverer and Portal to 11g logging on the portal or discoverer results in ORA-7445 in the database.

Manual verification of the SSO component failed.

Fri May 06 09:19:16 2011

Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x7573FFFFBF387C52] [PC:0x400000000429ED11, pfrinstr_BRNCNULL()+177] [exception issued by pid: -1086817198, uid: 0]

Errors in file /oracle/base/diag/rdbms/infdb/INFDB/trace/INFDB_ora_5858.trc (incident=721877):

ORA-07445: exception encountered: core dump [pfrinstr_BRNCNULL()+177] [SIGSEGV] [ADDR:0x7573FFFFBF387C52] [PC:0x400000000429ED11] [Address not mapped to object] []

Fri May 06 09:19:19 2011

Sweep Incident[721877]: completed

The cause for this issue is seen as a Bug 9210925 - AFTER MANUAL UPGRADE TO 11.1.0.7 PL/SQL CALLS INCORRECT FUNCTION

Incorrect fast-validation would happen when a parent of a library unit was modified in an incompatible way and the parent was referenced via a synonym. Symptoms could include wrong results and ORA-7445s.

Unfortunately the BUG is fixed in 11.2 and I am running 11.1 , so had to follow the workaround

Workaround Solution

Connect to the INFDB Database as SYSTEM

alter system set "_disable_fast_validate"=TRUE;

Connect to the INFDB Database as ORASSO User

alter package WWCTX_SSO compile;

alter package WWCTX_SSO compile body;

alter package WPG_SESSION_PRIVATE compile;

alter package WPG_SESSION_PRIVATE compile body;

Validate the ORASSO and OIDDAS Pages

https://dev.server.com/pls/orasso/htp.p?cbuf=test

and login to

https://dev.server.com /pls/orasso/

https://dev.server.com /oiddas

Reference ORASSO DAD Fails After Upgrading Application Mid-tier and Repository DB to 11g (Doc ID 1094047.1)

FMW 11g Discoverer Upgade Failed while updating ptm5_instance

noreply@blogger.com (Senthil Rajendran) — Sat, 13 Aug 2011 13:59:00 +0000

FMW 11g Upgrade Master Index

While trying to upgrade metadata repository schema (checked the Discoverer Schemas and Portal schemas checkbox) using Oracle FMW Upgrade Assistant, it fails while upgrading Discoverer Repository Schema.

Filename = ua2011-07-13-06-57-10AM.log
See the following error:
[2011-07-13T06:59:34.874+00:00] [DISCOVERER] [ERROR] [] [upgrade.DISCOVERER] [tid: 13] [ecid: 0000J4YITMq52jk5Ozg8yd1E7K76000002,0:12] Cause: Specified Discoverer 10g metadata record is corrupt. Action: Delete the corrupted record and rerun metadata repository upgrade.
[2011-07-13T06:59:34.875+00:00] [DISCOVERER] [NOTIFICATION] [] [upgrade.DISCOVERER] [tid: 13] [ecid: 0000J4YITMq52jk5Ozg8yd1E7K76000002,0:12] oracle.ias.mrua.plugin.discoverer.PortletMetadataMigrationException: Error while executing query: UPDATE TST_DISCOVERER.ptm5_instance SET ins_property = EMPTY_BLOB() WHERE ins_surrgt_pk = ? [[
at oracle.ias.mrua.plugin.discoverer.PortletMetadataMigration.executeQuery(PortletMetadataMigration.java:320)
at oracle.ias.mrua.plugin.discoverer.PortletMetadataMigration.migrateInstance(PortletMetadataMigration.java:164)
at oracle.ias.mrua.plugin.discoverer.PortletMetadataMigration.migrateInstanceKey(PortletMetadataMigration.java:153)
at oracle.ias.mrua.plugin.discoverer.PortletMetadataMigration.migrate(PortletMetadataMigration.java:122)
at oracle.ias.mrua.plugin.discoverer.DiscovererPlugin.massageData(DiscovererPlugin.java:615)
at oracle.ias.mrua.plugin.discoverer.DiscovererPlugin.discoUpgrade(DiscovererPlugin.java:560)
at oracle.ias.mrua.plugin.discoverer.DiscovererPlugin.doUpgrade(DiscovererPlugin.java:145)
at oracle.ias.mrua.MRUA.executePlugins(MRUA.java:2711)
at oracle.ias.mrua.MRUA.internal_driver(MRUA.java:1757)
at oracle.ias.mrua.MRUA.driver(MRUA.java:1205)
at oracle.ias.upgrade.gui.UAUpgradeThread.run(UAUpgradeThread.java:380)
Caused by: java.sql.SQLException: SQL string is not Query
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1442)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3752)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3806)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1667)
at oracle.ias.mrua.plugin.discoverer.PortletMetadataMigration.executeQuery(PortletMetadataMigration.java:316)
... 10 more

]]
[2011-07-13T06:59:50.995+00:00] [FrameworkMR] [NOTIFICATION] [] [upgrade.FrameworkMR] [tid: 14] [ecid: 0000J4YIq9K52jk5Ozg8yd1E7K76000003,0] finalize() instance 2 of 3
[2011-07-13T07:00:31.087+00:00] [DISCOVERER] [NOTIFICATION] [] [upgrade.DISCOVERER] [tid: 13] [ecid: 0000J4YITMq52jk5Ozg8yd1E7K76000002,0:12] Query to verify existence of named tables and columns
[2011-07-13T07:00:31.091+00:00] [DISCOVERER] [NOTIFICATION] [] [upgrade.DISCOVERER] [tid: 13] [ecid: 0000J4YITMq52jk5Ozg8yd1E7K76000002,0:12] Number of columns in the schema TST_DISCOVERER : 50
[2011-07-13T07:00:31.093+00:00] [DISCOVERER] [NOTIFICATION] [] [upgrade.DISCOVERER] [tid: 13] [ecid: 0000J4YITMq52jk5Ozg8yd1E7K76000002,0:12] Number of columns in the schema TST_DISCOVERER_PS : 30
[2011-07-13T07:00:31.275+00:00] [DISCOVERER] [NOTIFICATION] [] [upgrade.DISCOVERER] [tid: 13] [ecid: 0000J4YITMq52jk5Ozg8yd1E7K76000002,0:12] Discoverer upgrade phase finished
[2011-07-13T07:00:31.275+00:00] [FrameworkMR] [ERROR] [UPGAST-01006] [upgrade.FrameworkMR] [tid: 13] [ecid: 0000J4YITMq52jk5Ozg8yd1E7K76000002,0:12] Schema upgrade failed for Oracle Business Intelligence Discoverer.
[2011-07-13T07:00:31.275+00:00] [FrameworkMR] [ERROR] [] [upgrade.FrameworkMR] [tid: 13] [ecid: 0000J4YITMq52jk5Ozg8yd1E7K76000002,0:12] Cause: Repository Upgrade framework detected that schema upgrade of the component named in the error message failed. Action: Examine the upgrade log files for additional error messages. It may be possible to correct the problem and retry the upgrade.
[2011-07-13T07:00:31.275+00:00] [FrameworkMR] [NOTIFICATION] [] [upgrade.FrameworkMR] [tid: 13] [ecid: 0000J4YITMq52jk5Ozg8yd1E7K76000002,0:12] Upgrading component Oracle Portal.

Possible Reason for the Issue
The issue could have been caused by the change in jdbc execution method used in Fusion Middleware 11.1.1.4.0 Upgrade Assistant.

From the error message it suggests that the FMw 11.1.1.4.0 Upgrade Assistant is trying to execute a DML statement(UPDATE TST_DISCOVERER.ptm5_instance SET ins_property..) using executeQuery method and it is unable to execute it as it is not a Query.

Solution
1. Install Oracle Fusion Middleware 11g(11.1.1.2.0) - Portal, Forms, Reports and Discoverer (11.1.1.2.0)
2. Install Oracle Fusion Middleware 11g(11.1.1.3.0) - Portal, Forms, Reports and Discoverer (11.1.1.3.0)
3. Run Config.sh (available under /bin directory)
4. Run UA (Oracle FMw Upgrade Assistant , available under /bin directory)

Now Discoverer Metadata repository schemas will upgrade fine without any issues.

5. Then can apply FMw patchset 11.1.1.4.0 - Patch 11060983: FMW 11G PS3 (11.1.1.4) FOR PORTAL, FORMS, RPTS, DISCO

FMW 11g Upgrade : MiddleTire Schema Upgrade Assistance - Part 9

noreply@blogger.com (Senthil Rajendran) — Fri, 12 Aug 2011 07:00:00 +0000

FMW 11g Upgrade Master Index

Before I begin explaining the schema upgrade will update some of the pre-steps that will make the upgrade easier.

0. In Part 6. Installing Portal and Discoverer Middletire I have explained that I could not apply the 11.1.1.4.0 patchset since there were issues. Instead I applied 11.1.1.3.0 and after the upgrade is over I applied the 11.1.1.4.0 patchset.

1. Make a Database Backup or create a Restore Point. Oracle support always asks to restore the database if there are some issues with the portal upgrade. So keeping a restore point would be the easiest way to handle it.

2. Restart the Database so that there are no Portal Sessions running.

3. After the restart make sure that there are no active portal sessions.

4. If there are it should be the Portal Application. Follow the below note and stop the Portal Server
Upgrading from Portal 10g to 11g WWU-00011 There are concurrent sessions running [ID 1202638.1]

5. In some cases the upgrade assistance will fail to migrate the Discoverer Portlet information from the old PTM5_CACHE to the new 11g Discoverer Schema. The reason in my case was the length of the CCH_URL column. It will be by default VARCHAR2 (3000 Bytes) and you can modify it to VARCHAR2(4000 Bytes)

Invoke the UA Upgrade Assistance from the Oracle Home of the Portal and Discoverer Instance
Select the second option Upgrade Metadata Repository Schema and make sure that Discoverer and Portal is selected.

Then provide the information for Oracle Internet Directory Server connections details.
Then provide the database connection details where the metadata repository resides.

Select the new 11g Discoverer Schema

The examine process will verify if Portal and Discoverer are fine to upgraded.

Proceed next and you should see that all the components will be upgrade.

Note : For any failures I recommend to contact Oracle Support. If they ask to redo the upgrade you can flashback the database to the Pre-Upgrade restore point and then continue doing the same.

FMW 11g Upgrade : MiddleTire Upgrade Assistance - Part 8

noreply@blogger.com (Senthil Rajendran) — Tue, 09 Aug 2011 06:34:00 +0000

FMW 11g Upgrade Master Index

After completing the installation and configuration of 11g Portal/Discoverer, now the upgrade assistance will be invoked to upgrade the 10g OH to 11g FMW

The first step would be to Upgrade the MiddleTire Instance. Here select the 10g Oracle Home for Discoverer

After completing the Oracle Home upgrade , the installer prompts with the below success message.

The next step would be to upgrade the Schema.

FMW 11g Upgrade : MiddleTire Configuration Assistance - Part 7

noreply@blogger.com (Senthil Rajendran) — Tue, 26 Jul 2011 06:44:00 +0000

FMW 11g Upgrade Master Index

After installing the MiddleTire software necessary for Portal and Discoverer , now it is the time to configure the system.

Under ORACLE_HOME/bin/config.sh is the utility which is helping to configure the system.

Configuration Assistant

Create a Domain using the Configuration Assistance

Provide the necessary SCHEMA details and OID Details , then the installer takes to the Configuration Screen

Make sure that there are no errors during the configuration process.

The configuration assistance creates the Domain , Managed Servers for Portal and Discoverer.
The next process would be to upgrade the 10g Portal and Discoverer to 11g FMW