OBIEE 11g: UPGCMP-02712

Amusingly, the Usage Tracking components (RPD, Web Catalog) must be upgraded from 10g to 11g (11.1.1.5 for me). Not sure how this was missed, but it was.

I've run through the Upgrade Assistant multiple times, each one failing.



Here's the log:

[2011-09-08T03:07:12.156-04:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 13] 
[ecid: 0000J97r9aPFw000jzwkno1EQ6_m000004,0] Start 11g Components: false
[2011-09-08T03:07:12.185-04:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 13] 
[ecid: 0000J97r9aPFw000jzwkno1EQ6_m000004,0] Starting to upgrade BIEE.
[2011-09-08T03:07:12.239-04:00] [Framework] [ERROR] 
[UPGAST-00138] [upgrade.Framework] [tid: 13] [ecid: 0000J97r9aPFw000jzwkno1EQ6_m000004,0] 
upgrade exception occurred
[2011-09-08T03:07:12.239-04:00] [Framework] [ERROR] [] [upgrade.Framework] [tid: 13] 
[ecid: 0000J97r9aPFw000jzwkno1EQ6_m000004,0] 
Cause: An unexpected upgrade exception has occurred. Action: See the secondary error message 
for additional details.
[2011-09-08T03:07:12.239-04:00] [Framework] [ERROR] [] [upgrade.Framework] [tid: 13] 
[ecid: 0000J97r9aPFw000jzwkno1EQ6_m000004,0] 
UPGCMP-02712: Expected oracle.biee.admin:oracleInstance=*,type=BIDomain.OracleInstance,
group=Service Oracle instance, found 2
[2011-09-08T03:07:12.240-04:00] [Framework] [ERROR] [] [upgrade.Framework] [tid: 13] 
[ecid: 0000J97r9aPFw000jzwkno1EQ6_m000004,0] 
UPGCMP-02712: Expected oracle.biee.admin:oracleInstance=*,type=BIDomain.OracleInstance,
group=Service Oracle instance, found 2
[2011-09-08T03:07:12.240-04:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 13] 
[ecid: 0000J97r9aPFw000jzwkno1EQ6_m000004,0] 
Finished upgrading BIEE with status: Failure.
[2011-09-08T03:07:12.241-04:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 13] 
[ecid: 0000J97r9aPFw000jzwkno1EQ6_m000004,0] 
Finished upgrading components.
[2011-09-08T03:07:12.241-04:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 13] 
[ecid: 0000J97r9aPFw000jzwkno1EQ6_m000004,0]   
0 components upgraded with success.
[2011-09-08T03:07:12.241-04:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 13] 
[ecid: 0000J97r9aPFw000jzwkno1EQ6_m000004,0]   
1 components upgraded with failure.

My Oracle Support (MOS) didn't turn up any hits on that error number. The Google Machine did though. This OTN Forum post has the same exact problem. It appears that Merlin128 is talking to him or herself. I'm ok with that.

yes it was the web-tier.. or actually any component that creates a second instance...the upgrade utility only works with 1 instance installed.. to temporarily have only one instance.. I was able to change this file. run the upgrade. then change it back...middleware\user_projects\domains\bifoundation_domain\opmn\topology.xml

I tried that, commented out the second ias-instance section and restarted all the services (Linux 64).

Run the Upgrade Assistant, no joy.

With a little more research on MOS, I found note ID 1336567.1 which provides an 11.1.1.3 and 11.1.1.5 RPD. Yay.

To my above comment about how a pre-11g component got in there, the MOS note says:

The UsageTracking.rpd shipped is actually a pre 11.1.1.3 version and cannot be opened in the current versions of OBIEE 11g Administrator. It was shipped inadvertently.

All was not lost, I did find the master note for Usage Tracking Issues, ID 1293415.1.

So, I can't open the Usage Tracking web catalog in Catalog Manager (runcat.sh). I tried to deploy just the Usage Tracking catalog...and the BI Presentation server wouldn't come back up. Upgrade Assistant still doesn't work.

Help?

Update 09/08/2011 13:33 EST

So I thought I could use the Oracle created SampleApp (v105, not v107) and received a similar failure:

[2011-09-08T10:29:57.471-07:00] [Framework] [ERROR] [UPGAST-00138] 
[upgrade.Framework] upgrade exception occurred
[2011-09-08T10:29:57.471-07:00] [Framework] [ERROR] 
[upgrade.Framework] 
Cause: An unexpected upgrade exception has occurred. 
Action: See the secondary error message for additional details.
[2011-09-08T10:29:57.471-07:00] [Framework] [ERROR] [upgrade.Framework] 
UPGCMP-02712: Expected oracle.biee.local:* Oracle instance, found 0
[2011-09-08T10:29:57.471-07:00] [Framework] [ERROR] [upgrade.Framework] 
UPGCMP-02712: Expected oracle.biee.local:* Oracle instance, found 0

That VM has Essbase, amongst other components. I speculate there is some sort of (yet unknown) weirdness going on when you don't have a straight (just OBIEE) install.

DROP DATABASE;

I decided to blow away one of my newly created databases. Instead of using the DBCA, I decided to try it manually.

DROP DATABASE;

DROP DATABASE
*
ERROR at line 1:
ORA-01586: database must be mounted EXCLUSIVE and not open for this operation

Not it.

SQL> SHUTDOWN;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> STARTUP MOUNT EXCLUSIVE;
ORACLE instance started.

Total System Global Area 1048059904 bytes
Fixed Size                  2219992 bytes
Variable Size             608174120 bytes
Database Buffers          432013312 bytes
Redo Buffers                5652480 bytes
Database mounted.
SQL> DROP DATABASE;
DROP DATABASE
*
ERROR at line 1:
ORA-12719: operation requires database is in RESTRICTED mode

Ugh.

SQL> STARTUP NOMOUNT;
ORACLE instance started.

Total System Global Area 1048059904 bytes
Fixed Size                  2219992 bytes
Variable Size             608174120 bytes
Database Buffers          432013312 bytes
Redo Buffers                5652480 bytes
SQL> DROP DATABASE;
DROP DATABASE
*
ERROR at line 1:
ORA-01507: database not mounted


SQL> ALTER DATABASE MOUNT;

Database altered.

SQL> DROP DATABASE;
DROP DATABASE
*
ERROR at line 1:
ORA-12719: operation requires database is in RESTRICTED mode

Not it. Here's the SQL Reference. Maybe that RESTRICTED reference means something...

SQL> STARTUP MOUNT RESTRICTED;
ORACLE instance started.

Total System Global Area 1048059904 bytes
Fixed Size                  2219992 bytes
Variable Size             608174120 bytes
Database Buffers          432013312 bytes
Redo Buffers                5652480 bytes
ORA-01504: database name 'RESTRICTED' does not match parameter db_name
'TESTING'

Barnacles. Perhaps the Administrator's Guide has something.

SQL> STARTUP MOUNT TESTING;
ORACLE instance started.

Total System Global Area 1048059904 bytes
Fixed Size                  2219992 bytes
Variable Size             608174120 bytes
Database Buffers          432013312 bytes
Redo Buffers                5652480 bytes
Database mounted.
SQL> DROP DATABASE;
DROP DATABASE
*
ERROR at line 1:
ORA-12719: operation requires database is in RESTRICTED mode


SQL> ALTER DATABASE RESTRICTED;
ALTER DATABASE RESTRICTED
                        *
ERROR at line 1:
ORA-02231: missing or invalid option to ALTER DATABASE


SQL> ALTER DATABASE READ ONLY;
ALTER DATABASE READ ONLY
                    *
ERROR at line 1:
ORA-02231: missing or invalid option to ALTER DATABASE

Last try

SQL> STARTUP NOMOUNT RESTRICT;
ORACLE instance started.

Total System Global Area 1048059904 bytes
Fixed Size                  2219992 bytes
Variable Size             608174120 bytes
Database Buffers          432013312 bytes
Redo Buffers                5652480 bytes
SQL> DROP DATABASE;
DROP DATABASE
*
ERROR at line 1:
ORA-01507: database not mounted


SQL> ALTER DATABASE MOUNT;

Database altered.

SQL> DROP DATABASE;

Database dropped.

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Voila!

OEL: Add More Disk(s)

Many of you know I'm still relatively new to non-Windows platforms. I've been running Ubuntu (from 9.04 > 11.04) at home for a few years now though, in an effort to better understand what I am doing when I don't have to just point-and-click. Fortunately for me, Ubuntu has a pretty slick UI so it's not all done at the command line.

During that same time, I've taken to using Oracle Enterprise Linux for all my software installs, from the database (11gR1 > 11gR2), OBIEE (10.1.3.4 > 11.1.1.5), Informatica components, so on and so forth. I can say with all honesty now, that I would prefer a nix install over a Windows 2008 Server install (security being the biggest issue I have, not that it's bad, I have no idea...let's just say I find it annoying that if I can install the software, I should have access to the directories...which apparently I don't).

All of my testing is done with VirtualBox. For my XP virtual machines, I've gotten to the point where I simply clone an existing "base" VDI and use that (for clients mostly, and some OBIEE software).

Often times I'll allocate n GBs of space. Occasionally, like with my first few attempts with OBIEE, I don't allocate enough space. For me, that means recreating the entire VM with n + x number of GBs. Silly, I know.

I don't have to do that any longer, I finally learned how to add space without starting from scratch. Yay for me.

First up, I go into the settings of the VM (while stopped, of course) and add a new SATA controller. I select Create new disk.



Please ignore the "10" GBs part, I had taken those screenshots last week. I'm actually adding 100 GBs for the remainder of this exercise. I choose a location, name it and give it a size in GBs.



Now you can see (forget the 10, it's 100) it listed in the Storage section of the VM Settings



So now I fire up my VM (OEL 5.7), go to System > Administration > Logical Volume Managment. You'll be prompted for the root password.



Under the Uninitialized Entities, you should see the disk you just added. Select Initialize Entry.

3

Blah blah blah. Yes.



Blah blah blah. Yes.



Now it's migraterd up to your Unallocated Volumes section. Add to existing Volume Group.



You should be prompted with your currently existing Volume Group, in my case, VolGroup00. Select it and then click Add.



Here's a picture of what I have allocated so far, 4.8 GiB (the rest is swap space)



Now, under VolGroup00 (Logical View), select Edit Properties



You'll be prompted with the Edit Logical Volume dialog. On the slider, you can see that it goes up to 104.97 and just below that a, "Use remaining space for this volume: 99.97 Gigabytes"



You can choose either one.



Now you can usee that VolGroup00 has 2 physical volumes which comprise it, sda2 and sdb1, sdb1 is the one I've just added. To the right, you can see the Volume Group Size is now 109.84.



And finally, System Monitor shows that I now have a total of 101.7 GiBs associated with VolGroup00-LogVol00



It's as simple as that.

Someday I'll figure out how to add different disks (well, technically they are different disks, just logically only 1) so that I can layout my tablespaces a bit better. For now though, no more recreating virtual machines just because I didn't plan well enough.

T-Shirt: Now in Pink

I haven't done much with the T-Shirt collection lately. For whatever reason, I finally decided to do one in pink.

You have one month until Oracle OpenWorld...and did I mention it goes to a good cause?