Category Archives: Uncategorized

OBIEE 11.1.1.6 Installs in record time

For the last three years I have been installing OBIEE 11g. It has been a painful and disappointing process – unitl now.

I just downloaded, installed RCU and full Enterprise edition in less than ONE HOUR. Amazing!

 

About v6

Thank you Oracle. It took you a while but you now seem to have a great product that installs, and best of all it runs on FIREFOX 10.

OBIEE 11G version 11.1.1.6 Release

The tweeters did a good job of sending out the word that version 6 of version 1 is now available for download from edelivery.oracle.com.

I have downloaded and installed the RCU and guess what?,
IT WORKED! Yippee.

It’s definitely time to start recommending version 11g to your clients.

I will update you when I have installed the application itself.

Active Directory Installation

We recently installed a set of new servers at Addidici HQ for testing and development of OBIEE 11g.  I wanted to make it more real world so we included Microsoft Active Directory (MSAD) on one of the servers.
Having never installed or used MSAD as an administrator previously, I quickly scanned the books available and found an on-line guide that seemed to fit my needs.

At 1000 pages, Configuring Windows Server® 2008 Active Directory was certainly comprehensive!
For me the book was perfect, given that it introduces the concepts and then walks the reader through an actual installation and set-up.  The book is actually an exam preparation guide, and I didn’t intend doing the exam, but armed with the book I think that maybe I should now!

From chapter one you are involved in building your first domain, and getting stuck in to creating users and groups (all very useful for our OBIEE 11g integration).

This book did have the potential to just be a standard study text, but we are treated throughout to Dan Holme’s ‘Real World’ extracts.  These give great feedback about what happened on real projects, and helps to make sure you learn from Dans vast experience.

Thanks to the book we have a great working LDAP, easy to manage, and integrating well with OBIEE 11g.  If I need to undertake some of the more complex tasks such as digital rights management and replication then I will be turning back to the book.

And if the market for OBIEE fall apart I can certainly retrain to be an AD Consultant.

The ISBN is: 978-0-7356-5193-7
Full title is : MCTS Self-Paced Training Kit (Exam 70-640): Configuring Windows Server® 2008 Active Directory®
Thanks to the article at http://www.lavc.edu/library/bookreview.htm for giving me some hints on how to review the book.

Also found along the way was US Commerce website  http://www.ntis.gov/

 

OBIEE 11g and IE9

Just a quick note to say that IE9 does not appear to work with 11g. Viewing Dashboards can work but editing dashboards does not, and BI Publisher wont even start.
Best avoided for now, stick with Firefox which works well.

@d

Reconfiguring Oracle EM

When running lots of VirtualBox VM’s I often find that during some reconfig the database Enterprise Manager gets in a confused state.  This is usually due to network changes, and most people end up re-installing Oracle.  One solution is to keep snapshots of a working Database set-up but I find I run out of space pretty quickly on my laptop.

I was therefore delighted to find a simple solution at a blog by Mclaughlin Software  (http://blog.mclaughlinsoftware.com/oracle-architecture-configuration/changing-windows-hostname-and-oracle-enterprise-manager/) which showed how to get a New EM installation.

As I use it often I have copied in the steps here:

 

These are the steps:

 

1. Change the %ORACLE_HOME%networkadminlistener.ora file from an IP number to machine name.

2. Change the %ORACLE_HOME%networkadmintnsnames.ora file from an IP number to a machine name.

3. Change the C:WINDOWSSystem32driversetchosts file by adding this line beneath the default localhost line (for the new Hostname value):

127.0.0.1 localhost
172.16.113.128 mclaughlin11g mclaughlin11g.techtinker.com

4. Change the Windows hostname by navigating: Start > Control Panel > System (classic view) from the random assignment of VMWare Fusion.

5. Reboot the machine, and then drop the em configuration with the following commands:

C:Data> set ORACLE_SID=orcl
C:Data> emca -deconfig dbcontrol db -repos drop

6. You’ll receive the following prompts, enter the Oracle SID and Port number without double quotes but you must enter all passwords with double quotes (at least in Oracle Database 11g):

 STARTED EMCA at Jul 13, 2008 8:26:42 AM
EM Configuration Assistant, Version 11.1.0.5.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.

 

Enter the following information:

Database SID: orcl
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:
Password for SYSMAN user:
Do you wish to continue? [yes(Y)/no(N)]: y

7. You should then drop the SYSMAN user manually because it doesn’t happen without your assistance (or, it didn’t happen when I did it). If you don’t drop the SYSMAN schema, you’ll raise an error when you try to recreate it.

 DROP USER sysman CASCADE;
DROP PUBLIC SYNONYM setemviewusercontext;
DROP ROLE mgmt_user;
DROP PUBLIC SYNONYM mgmt_target_blackouts;
DROP USER mgmt_view;

8. You can then create the em environment with the following syntax:

 

C:Data> emca -config dbcontrol db -repos create

9. Again, you’ll receive the following prompts, enter the Oracle SID and Port number without double quotes but you must enter all passwords with double quotes (at least in Oracle Database 11g):

 

STARTED EMCA at Jul 13, 2008 8:28:48 AM
EM Configuration Assistant, Version 11.1.0.5.0 Production
Copyright (c) 2003, 2005, Oracle. ALL rights reserved.

Enter the following information:

DATABASE SID: orcl
Listener port NUMBER: 1521
Password FOR SYS USER:
Password FOR DBSNMP USER:
Password FOR SYSMAN USER:
Password FOR SYSMAN USER: Email address FOR notifications (optional):
Outgoing Mail (SMTP) server FOR notifications (optional):

 

You have specified the following settings

 

DATABASE ORACLE_HOME ................ C:appAdministratorproduct11.1.0db_1
LOCAL hostname ................ mclaughlin11g
Listener port NUMBER ................ 1521
DATABASE SID ................ orcl
Email address FOR notifications ...............
Outgoing Mail (SMTP) server FOR notifications ...............

Do you wish TO continue? [yes(Y)/no(N)]: y

 

Once again, thanks to http://blog.mclaughlinsoftware.com

Also, http://www.akadia.com/services/ora_dbconsole.html

 

@ddi

Steve Jobs

I never got into the Apple Hype, prefering my PC’s for the last 15-20 years.

That changed last year when I got a MacBok Pro (I got it in lieu of £2,000 I was owed).  I didn’t really want it but had to find some way of getting my money back.

I am now happy to say I AM an Apple fan.  The laptop mainly just works (most of the time), is fast, very lightweight, full of great features and looks good.  Same goes for the iPhone and the iPad.  Apple are clearly leading the way with their products.

I have no idea how much of this is down to Steve Jobs, but he obviously had a huge impact on all the people he met judging by the tributes on wired.com.

However, I think the best thing I have seen from him was that speech back in 2005.  All I can say is read it, or watch it, especially part 3.  The full text can be found here or the video is on YouTube

Thanks Mr Jobs

 

@dd

 

 

Exalytics Details

While I am still trying to figure out if I like the name of the new Oracle BI Box (I suppose Exalytics is better than OBB), more details have emerged.

Not only do we have some blogs to read but even a WHITE PAPER.  You may have already seen extracts copied into blogs, but well worth reading the full article.

@ddi

Oracle 11g

The long awaited Oracle 11g Express is out.

I will try it in a couple of VM’s before installing on our production machine here at Addidici.
The question will be what integration is there for OBIEE 11g (Repository and Warehouse?)
http://www.oracle.com/technetwork/database/express-edition/downloads/index.html

Addidici is Born!

We are pleased to announce the new name in Oracle Business Intelligence – Addidici.

Following the legal dispute with RM we have been forced to find a new home for our blog, our company, and our goods friends to find us.

It’s a company name that I was toying with when we settled on Majendi way back when OBI had not even been invented! We loved Majendi, but that company is dead now, long live Addidici.

I will also link to the Addidici Twitter account, please find us there and share your OBI experience with us, as we try to find the time to share our OBI and BI Apps experience with you.

I will share mainly OBI stuff, but will also let you know how the legal battle is going with the people who owe us the money they promised when they bought Majendi, three years ago.

@Adrian

New ODI Blog

I see that John Minkjan has started a new blog on ODI. Nice one John. http://odiee101.blogspot.com/

I look forward to reading about how Oracle are going to move from Informatica to ODI!!! Or is that when?