While I was off, Oracle released OBIEE 11.1.1.6.5 which is another bugfixing patch set which doesn’t bring in new functionality but irons out quite a few quirks.
Here you can find the main MOS article detailling the patches making up this patch set as all bugs fixed in it.
By the way…make sure you don’t forget JDEV patch 13952743.
Cheers!
Patch 11.1.1.6.4 is here and can be downloaded from MOS.
Once more it’s a 7-pack patch and here are the patch numbers and direct links:
Patch 14538078: PATCH 11.1.1.6.4 (1 OF 7) ORACLE BUSINESS INTELLIGENCE INSTALLER
Patch 14538128: PATCH 11.1.1.6.4 (2 OF 7) ORACLE REAL TIME DECISIONS
Patch 14285344: Patch 11.1.1.6.4 (3 of 7) Oracle Business Intelligence Publisher
Patch 14538164: PATCH 11.1.1.6.4 ( 4 OF 7) ORACLE BUSINESS INTELLIGENCE ADF COMPONENTS
Patch 14415773: Patch 11.1.1.6.4 (5 of 7) Enterprise Performance Management Components Installed from BI Installer 11.1.1.6.x
Patch 14405222: Patch 11.1.1.6.4 (6 of 7) Oracle Business Intelligence
Patch 14409674: Patch 11.1.1.6.4 (7 of 7) Oracle Business Intelligence Platform Client Installers and MapViewer
Documentation’s here: https://updates.oracle.com/Orion/Services/download?type=readme&aru=15499675
Cheers!
After an OBIEE 11.1.1.6 in-place upgrade I accidentally found weird warnings in the startup log of WebLogic since the upgrade. “By accident” since the server started nicely and was available without loss of functionality or performance, so I never checked in detail what happens during startup.
The WLSStart.log contained the following nice list:
{May 1, 2012 9:36:03 AM CEST} {Warning} {oracle.dms.collector} {BEA-000000} {Metric table “discussion:Response” has no key column. It will not be collected.}
{May 1, 2012 9:36:03 AM CEST} {Warning} {oracle.dms.collector} {BEA-000000} {Metric table “oracle_bi_instance:essbaseServerMetrics” has no key column. It will not be collected.}
{May 1, 2012 9:36:03 AM CEST} {Warning} {oracle.dms.collector} {BEA-000000} {Metric table “oracle_bi_instance:wls_app_rollup” has no key column. It will not be collected.}
{May 1, 2012 9:36:03 AM CEST} {Warning} {oracle.dms.collector} {BEA-000000} {Metric table “oracle_bi_instance:wls_web_rollup” has no key column. It will not be collected.}
{May 1, 2012 9:36:03 AM CEST} {Warning} {oracle.dms.collector} {BEA-000000} {Metric table “oracle_bi_instance:wls_server” has no key column. It will not be collected.}
{May 1, 2012 9:36:03 AM CEST} {Warning} {oracle.dms.collector} {BEA-000000} {Metric table “oracle_bi_instance:obis_rollup” has no key column. It will not be collected.}
{May 1, 2012 9:36:03 AM CEST} {Warning} {oracle.dms.collector} {BEA-000000} {Metric table “oracle_bi_instance:obips_rollup” has no key column. It will not be collected.}
{May 1, 2012 9:36:03 AM CEST} {Warning} {oracle.dms.collector} {BEA-000000} {Metric table “oracle_bi_instance:obips_requests_rate” has no key column. It will not be collected.}
{May 1, 2012 9:36:05 AM CEST} {Warning} {oracle.dms.collector} {BEA-000000} {Metric table “webcache:request_filter_denied_stats” has no key column. It will not be collected.}
{May 1, 2012 9:36:05 AM CEST} {Warning} {oracle.dms.collector} {BEA-000000} {Metric table “oracle_oim:overall” has no key column. It will not be collected.}
{May 1, 2012 9:36:05 AM CEST} {Warning} {oracle.dms.collector} {BEA-000000} {Metric table “domain_oracle_oim:jdbc” has no key column. It will not be collected.}
{May 1, 2012 9:36:05 AM CEST} {Warning} {oracle.dms.collector} {BEA-000000} {Metric table “oracle_soainfra:total_faults” has no key column. It will not be collected.}
{May 1, 2012 9:36:06 AM CEST} {Warning} {oracle.dms.collector} {BEA-000000} {Metric table “portaltools:Response” has no key column. It will not be collected.}
{May 1, 2012 9:36:06 AM CEST} {Warning} {oracle.dms.collector} {BEA-000000} {Metric table “weblogic_j2eeserver:jvm_runtime” has no key column. It will not be collected.}
{May 1, 2012 9:36:06 AM CEST} {Warning} {oracle.dms.collector} {BEA-000000} {Metric table “weblogic_j2eeserver:jvm_compilation_time” has no key column. It will not be collected.}
{May 1, 2012 9:36:06 AM CEST} {Warning} {oracle.dms.collector} {BEA-000000} {Metric table “weblogic_j2eeserver:jvm_memory_usage” has no key column. It will not be collected.}
{May 1, 2012 9:36:06 AM CEST} {Warning} {oracle.dms.collector} {BEA-000000} {Metric table “weblogic_j2eeserver:jvm_class_loading” has no key column. It will not be collected.}
{May 1, 2012 9:36:06 AM CEST} {Warning} {oracle.dms.collector} {BEA-000000} {Metric table “weblogic_j2eeserver:jvm_threads” has no key column. It will not be collected.}
{May 1, 2012 9:36:07 AM CEST} {Warning} {oracle.dms.collector} {BEA-000000} {Metric table “essbaseapp:appMetrics” has no key column. It will not be collected.}
{May 1, 2012 9:36:07 AM CEST} {Warning} {oracle.dms.collector} {BEA-000000} {Metric table “domain_oracle_oaam:OAAM_Datasource” has no key column. It will not be collected.}
{May 1, 2012 9:36:07 AM CEST} {Warning} {oracle.dms.collector} {BEA-000000} {Metric table “oracle_forms:aggr_FormsResourceUsage” has no key column. It will not be collected.}
{May 1, 2012 9:36:07 AM CEST} {Warning} {oracle.dms.collector} {BEA-000000} {Metric table “oracle_forms:NumberOfSessions” has no key column. It will not be collected.}
{May 1, 2012 9:36:07 AM CEST} {Warning} {oracle.dms.collector} {BEA-000000} {Metric table “oracle_forms:JVMResourceUsage” has no key column. It will not be collected.}
{May 1, 2012 9:36:07 AM CEST} {Warning} {oracle.dms.collector} {BEA-000000} {Metric table “oracle_forms:servlet_rollup_agg” has no key column. It will not be collected.}
{May 1, 2012 9:36:07 AM CEST} {Warning} {oracle.dms.collector} {BEA-000000} {Metric table “reports:Reports_Server_Information” has no key column. It will not be collected.}
{May 1, 2012 9:36:07 AM CEST} {Warning} {oracle.dms.collector} {BEA-000000} {Metric table “reports:Reports_Server_Performance” has no key column. It will not be collected.}
{May 1, 2012 9:36:07 AM CEST} {Warning} {oracle.dms.collector} {BEA-000000} {Metric table “reports:Reports_Server_Response” has no key column. It will not be collected.}
{May 1, 2012 9:36:07 AM CEST} {Warning} {oracle.dms.collector} {BEA-000000} {Metric table “reports:Reports_Servlet_Response” has no key column. It will not be collected.}
{May 1, 2012 9:36:07 AM CEST} {Warning} {oracle.dms.collector} {BEA-000000} {Metric table “reports:Remote_Bridge_Elements” has no key column. It will not be collected.}
{May 1, 2012 9:36:07 AM CEST} {Warning} {oracle.dms.collector} {BEA-000000} {Metric table “analytics:Response” has no key column. It will not be collected.}
{May 1, 2012 9:36:07 AM CEST} {Warning} {oracle.dms.collector} {BEA-000000} {Metric table “portal:portal_page_engine_response_codes_delta” has no key column. It will not be collected.}
{May 1, 2012 9:36:07 AM CEST} {Warning} {oracle.dms.collector} {BEA-000000} {Metric table “portal:portal_page_engine_response_codes” has no key column. It will not be collected.}
{May 1, 2012 9:36:07 AM CEST} {Warning} {oracle.dms.collector} {BEA-000000} {Metric table “portal:portal_page_engine” has no key column. It will not be collected.}
{May 1, 2012 9:36:07 AM CEST} {Warning} {oracle.dms.collector} {BEA-000000} {Metric table “activitygraph:Response” has no key column. It will not be collected.}
{May 1, 2012 9:36:07 AM CEST} {Warning} {oracle.dms.collector} {BEA-000000} {Metric table “essbase:serverMetrics” has no key column. It will not be collected.}
{May 1, 2012 9:36:07 AM CEST} {Warning} {oracle.dms.collector} {BEA-000000} {Metric table “oracle_federation:protocol_profiles_rollup” has no key column. It will not be collected.}
{May 1, 2012 9:36:07 AM CEST} {Warning} {oracle.dms.collector} {BEA-000000} {Metric table “oracle_federation:protocol_profiles_events_rollup” has no key column. It will not be collected.}
{May 1, 2012 9:36:07 AM CEST} {Warning} {oracle.dms.collector} {BEA-000000} {Metric table “oracle_federation:protocol_profiles_protocol_phase_events_rollup” has no key column. It will not be collected.}
{May 1, 2012 9:36:08 AM CEST} {Warning} {oracle.dms.collector} {BEA-000000} {Metric table “personalization:Response” has no key column. It will not be collected.}
Browsing through MOS I found MOS document ID 1434193.1 which states:
Cause:
This is known to be caused by a change to the Metric Service.
This does not cause any functional problem and it is expected to be fixed in the future versions. An internal bug is logged and progressed to have this addressed.
Solution:
The warnings can be ignored as it has no affect on the Reports Servers and the its functionality.
So really good to know in case you are browsing your log files for warnings and come across this.
Cheers!
If you look at the official upgrade guide, all went fine up to item 6: “Upgrading system components“. Executing upgradenonj2eeapp.sh, however, threw an error while re-deploying:
./upgradenonj2eeapp.sh -oracleInstance /bishiphome/Middleware/instances/myinstance/ -adminHost localhost -adminPort 7001 -adminUsername weblogic
Command failed: NonJ2EEManagement Applicationdeployment failed.
[Deployer:149163]The domain edit lock is owned by another session in non-exclusive mode – this deployment operation requires exclusive access to the edit lock and hence cannot proceed. If you are using “Automatically Aquire Lock and Activate Changes” in the console, then the lock will expire shortly so retry this operation.
SEVERE: Command failed:
oracle.as.config.ProvisionException: Exception while unregistering the instance
at oracle.as.config.impl.OracleASInstanceImpl.unregister(OracleASInstanceImpl.java:290)
at oracle.as.config.impl.OracleASInstanceImpl.unregister(OracleASInstanceImpl.java:250)
at oracle.as.config.provisioner.commands.UnregisterInstanceCommand.execute(UnregisterInstanceCommand.java:34)
at oracle.as.config.provisioner.InstallerCmdLine.run(InstallerCmdLine.java:146)
at oracle.as.config.provisioner.InstallerCmdLine.main(InstallerCmdLine.java:46)
Caused by: oracle.as.config.impl.SimpleProvisionException: Failed to unregister instance instance1. It does not exist on the adminserver.
1.) Deploy the instance again:
./opmnctl redeploy -oracleInstance /bishiphome/Middleware/instances/myinstance -adminHost localhost -adminPort 7001 -adminUsername weblogic
Command requires login to weblogic admin server (localhost):
Username: weblogic
Password:Redeploying NonJ2EEManagement Application…weblogic.Deployer invoked with options: -adminurl localhost:7001 -username weblogic -name NonJ2EEManagement -source /bishiphome/Middleware/Oracle_BI1/opmn/applications/NonJ2EEManagement.ear -redeploy -upload -noexit
Task 1 initiated: [Deployer:149026]deploy application NonJ2EEManagement [Version=11.1.1] on AdminServer.
Task 1 completed: [Deployer:149026]deploy application NonJ2EEManagement [Version=11.1.1] on AdminServer.
Target state: redeploy completed on Server AdminServerDone
Command succeeded.
./opmnctl registerinstance
Command requires login to weblogic admin server (localhost):
Username: weblogic
Password:Registering instance
Command succeeded.
After these steps, I was able to run the actual shell for the upgrade process again:
./upgradenonj2eeapp.sh -oracleInstance /bishiphome/Middleware/instances/instance1/ -adminHost localhost -adminPort 7001 -adminUsername weblogic
Unregister instance…Command requires login to weblogic admin server (localhost):
Username: weblogic
Password:Unregistering instance
Command succeeded.
redeploy NonJ2EEManagement.ear…Command requires login to weblogic admin server (localhost):
Username: weblogic
Password:Redeploying NonJ2EEManagement Application…weblogic.Deployer invoked with options: -adminurl localhost:7001 -username weblogic -name NonJ2EEManagement -source /bishiphome/Middleware/Oracle_BI1/opmn/applications/NonJ2EEManagement.ear -redeploy -upload -noexit
Task 2 initiated: [Deployer:149026]deploy application NonJ2EEManagement [Version=11.1.1] on AdminServer.
Task 2 completed: [Deployer:149026]deploy application NonJ2EEManagement [Version=11.1.1] on AdminServer.
Target state: redeploy completed on Server AdminServerDone
Command succeeded.
re-register instance…Command requires login to weblogic admin server (localhost):
Username: weblogic
Password:Registering instance
Command succeeded.
Successfully upgraded NonJ2EEManagement.ear and the registeration.
One of those little things that can ruin your evening…
Cheers!
The official list of bugfixes included in 11.1.1.6 is out:
OBIEE 11.1.1.6 became available yesterday evening (CET) first on edelivery and in the meantime on OTN as well. Here’s a link library of the most important and interesting sources.
Overview and explanatory blog posts:
PeakIndicators
“New Features with OBIEE 11.1.1.6”
RittmanMead
“OBIEE 11.1.1.6 Now Available for Download – Release Highlights”
“OBIEE 11.1.1.6 : MDS XML Repositories, and Integration with Source Control”
Michael Verzijl
“OBIEE 11.1.1.6 Released – Short overview”
Addidici
“OBIEE 11g R1.6 New Admin Feature”
Alex Hansal
“OBIEE 11.1.1.6 is here”
Fiston
“OBIEE 11.1.1.6 new features/enhancements”
Official Documentation
Documentation Library
New Features OBIEE 11.1.1.6
New Features OBIEE 11.1.1.6 for Users
(h/t @lex!)
This is just a first list and will grow over time. If you have new, interesting links to add, please put them in the comments and I’ll update the list.
Cheers!