Recommended Book for Oracle Enterprise Manager Grid Control 11g

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

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

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

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

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

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

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

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

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

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.