Monthly Archives: March 2012

Exalytics Test Drive – April 18th 2012 in London

Some people may have seen that Rittman Mead became the first partner in the UK to buy an Exalytics box in the Oracle newsletter, and as a result we can uniquely offer our customers and community the chance to get hands on with Exalytics to see how it really can help drive your BI capability with extreme performance.

We are about to start working on our first migrations to Exalytics, and we are offering free proofs of concepts for organizations and individuals interested in seeing the potential first hand.

We will also be running a series of events around the world giving people the chance to get hands on with Exalytics, and our first is due to happen in London on April 18th at Oracle’s office at 1 South Place, London, EC2M 2RB.

Places will be limited, but if you would like to sign up for this event please contact us at exalytics@rittmanmead.com.

We will be announcing more test drives and event in the coming weeks for the US and Europe so please keep an eye open for those.

Hope to see you on the 18th!

Morgan

Real-Time BI with Kevin & Stewart: New internet “talk show”

Kevin McGinley and myself have created a new internet talk show, airing on YouTube and Vimeo, called “Real-Time BI with Kevin & Stewart”. Kevin, if you recall, is teaching the Master Class at the BI Forum this year, and I also interviewed him earlier this year about his role in leading the BI content committee at ODTUG Kscope 12.

The show really spawned out of Kevin’s head, and as he mentions on the first episode, he had the idea of having an “Oracle BI Talk Show” in the vein of a sports talk show or a politics talk show. We finally delivered the first episode, complete with technical glitches, which I think Kevin edited with an interesting bit of humor. The show is available on YouTube or Vimeo, and I think it’s a pretty good first take on what both of us had in mind for what we wanted to do. This episode has a theme on blogging and social media, so we invited Chet Justice of OracleNerd.com, and Christian Screen of ArtofBi.com, both of who have very active social personas in the Web 2.0 world.

We’ll be doing this every month, with two different guests each month, and we anticipate having each show be themed with the guests driving the theme, or vice versa. So keep your eyes open for additional episodes, and I hear we’re even coming to iTunes in the not-so-distant future.

OBIEE 11g in-place upgrade issue with configuration lock

In-place upgrade within OBIEE 11 versions (from .3 to .5 o r .6 or from .5 to .6) can be a whole lot quicker than out-of-place ones but are also more interesting in terms of potential issues arising. After two uneventful in-place upgrades from 11.1.1.5 to 11.1.1.6 I had a more challenging third upgrade with some unexpected errors.

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.

Looking into the provision.log (situated in MW_HOME/instances/myinstance/diagnostics/logs/OPMN/opmn) read as follows:
[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.

I ran the upgradenonj2eeapp.sh a second time to see what it would do:
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.

So, a real no-go situation. Luckily, the OBIEE EMG already had a post which contained part of the solution. Root cause of the initial error was that there was a lock on the configuration I hadn't seen:


"Release Configuration" removed the immediate error source. Next step was re-running upgradenonj2eeapp.sh again to see what would happen and obviously the error "Failed to unregister instance instance1. It does not exist on the adminserver." still persisted since initially the first half of the script had run through and un-registered my instance. So off to some opmnctl commands to undo the damage.

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 AdminServer

Done
Command succeeded.

2.) Register the instance again:
./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 AdminServer

Done
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!

New Wednesday Seminar Series from Robin and Mark

Robin Moffatt mentioned the other day that we’ve launched a number of new training initiatives, including a series of seminars, running on Wednesday afternoons and presented either by myself or Robin, aimed at OBIEE 11g developers looking to get skilled-up on a particular focused-area of the product. Rather than attend a week-long training course for just one day that you’re interested in, this seminar series allows you to pick a particular topic and attend the event from your desktop or workstation, via the internet.

The topics we’re covering include:

  • OBIEE 11g RPD Modelling Techniques – always a popular topic
  • OBIEE 11g RPD and Catalog Change Management & Deployment Techniques
  • OBIEE 11g Administration through WebLogic and Enterprise Manager
  • OBIEE 11g Scorecards and KPIs
  • OBIEE 11g Security
  • OBIEE 11g Exalytics Configuration, Administration and Analysis

We’ve priced each seminar at £250 incl. VAT, and you can pay on registration via PayPal (which then allows you to use a credit card, if you like). If you like the sound of all of the seminars and can attend on each Wednesday, you can also register for all eight for just £1250 + VAT. The seminars start in April and go through to the end of May, so if you’re interested and want to register for just one, for some or for all, check out the Rittman Mead Webinar Series 2012 homepage.

Reminder: OBIEE 10g premier suppport ending soon

It has been 19 months since the GA of OBIEE 11g and its third incarnation (11.1.1.6) is celebrating its one-month-birthday today. Time to make a point on the support situation for all OBIEE 10g implementations out there:

The last 10gR3 versions (10.1.3.4.x) will reach the end of the Permier Support lifecycle in 4 months, July 2012.
 

The full documentation for lifetime support of Fusion Middleware products can be found here, on the Oracle website (last updated February 2012). The screenshot above can be found on page 13 of the pdf.

So to wrap up: the product has had more than one and a half years to mature, Oracle provided us with two new version since the release and with the end of premier support quickly coming up, this is really the moment to start thinking about upgrading your 10g solutions!