Archives

All posts for the month January, 2008

Oracle Discoverer / BIP Integration Update

Posted by Topper on 1/28/2008
Posted in: Business Intelligence, Discoverer, Identity Management, Oracle. Leave a Comment

I keep seeing things pop up and people having trouble getting the Discoverer / BIP integration working.  I will say this is not the easiest of configurations, but with some additional steps anyone should be able to complete the task.  For those of you that have been following along, the latest Discoverer Cumulative Patch (CU4, p6357481) was released and  the Discoverer / BIP integration was not included with created a new interop patch for everyone numbered 6622352.

Just a couple notes on the install.  If you are applying the patch to a unix system you’re going to have to run the dos2unix command on the CreateOIDContainer.sh file in the <OH>/discoverer/util directory.   Also, notice the CreateOIDContainer.sh file, yes its case sensitive and don’t forget to edit the file and replace the %ORACLE_HOME% directive with your actual Oracle Home path, while you’re at it make sure you chmod 750 CreateOIDContainer.sh too.  Can you tell it was a windows guy who wrote the script ;-).

Anyways, before executing the CreateOIDContainer.sh script you’ll also need to properly setup all your paths which includes:
export ORACLE_HOME=<Your Oracle Home Path>
export LIBPATH=$ORACLE_HOME/lib32:$ORACLE_HOME/lib:$ORACLE_HOME/jlib:$LIBPATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib32:$ORACLE_HOME/lib:$ORACLE_HOME/jlib:$LD_LIBRARY_PATH

The big kicker that bit me this last time was that I was getting an error that the Discoverer product container doesn’t  exist in the OID Repository.  Well, for some reason that container doesn’t actually exist until a user is created in the OID through something like OIDDAS, since this client was using Server Chaining to bring in all their users (another blog post soon) we had never actually created a “new” native user in OID.

Needless to say the 10.1.2.3 Discoverer patch set can’t come soon enough which includes this patch with it.  Till then feel free to drop me a line if you have any questions.  If you want some more in depth examples of the config let me know and I’ll get some screen shots the next time I do this.

Ora-Click-Clack Weekly Review #2

Posted by Topper on 1/18/2008
Posted in: ora-click, Oracle. Leave a Comment

Alright, last night I posted on Twitter that this would be released this morning, well its still morning somewhere. Without further ado here is version two of the click-clack. Make sure you read through to the end for some interesting changes coming to the site soon or already deployed.

  1. The first story was submitted by me, and not through the big controversial RSS feed option. The story entitled Do you recognize the man in this picture? came to my through my normal RSS feeds. Mashable is a great site that covers new and exciting web 2.0 site and other technology news. Low and behold I’m going through their feed today and saw an article that sparked my interest on a judge who sentenced a hacker for listing the ips coming from a usenet server. I clicked through and look at the picture in the article and its none other than infamous Oracle DBA / Miniature Horseman / Truffle Entrepreneur Don Burleson. Yes that is truly Don, if you don’t believe me, scroll down to the bottom of his own website for the picture. Too funny. 1,000,000 bonus points for Dan Norris for being the first to identify him.
  2. The next article comes from Patrick Wolf the Oracle ApEx world asking people if its a good thing to create an ApEx certification. Certifications are something that I’ve always debated about with people, many people can read a book, pass a certification test and have no idea how to apply things in the real world. While there are some certifications that combine book and hands-on during the tests many do not. Personally, while certifiable, I don’t carry any certs its just something that doesn’t appeal to me, I prefer to spend my time learning new things and sharing with the world letting me experience and reference speak for themselves. I do agree that for newbies, certifications provide a great way for them Continue Reading

Ora-Click-Clack Weekly Review #1

Posted by Topper on 1/14/2008
Posted in: General, ora-click, Oracle. 2 comments

Well, part of starting Ora-Click I wanted to start a series of blogs covering the top 5 articles of the week. Due to some technical difficulties I’m a week late, but I promise to make it extra extra interesting. So without further ado here are the top 5.

  1. The big story of the week wasn’t Jakes post on the “8 Things” but actually the User Your Nose to Install an Oracle Database article. Some people claim that Oracle software is among the hardest to install. I tend to agree many of the earlier releases (<8) were a pain in the butt, but Oracle’s come a long way since then. Just to prove it Howard posted a link showing exactly how easy it is. I would love to link to it, but as I’ll discuss later Howard has shut down his blog until the “8 Things” craze slows down. When he gets back to earth the article can be found here.
  2. The second article covers the new fixes and features of the latest mix.oracle.com release. I’m proud to be member 41 on the site and really think its a great way to get open and honest customer feedback. As the site grows there’s definitely some new features that need to be added to help manage consuming all the new content but knowing the AppsLab guys they’re already working on it. I would love to see Oracle open up the source to mix, as suggested by Jake here. I know that Anthony and Rich are overloaded fixing bugs and working on new features, it would be great to have the Oracle Continue Reading

Quick Post : Oracle jDeveloper Technical Preview 3 Virtual Machine

Posted by Topper on 1/1/2008
Posted in: Oracle, Personal, VMWare. 1 comment

Just a quick post on something I was working on, my father passed away suddenly yesterday so I don’t have as much time to put into this post as I had hoped. Anyways, over the holiday I put together a quick Ubuntu VMWare virtual machine with Oracle XE, the new 11g Technical Preview 3 jDeveloper release and the SOA suite. Over the last week I uploaded it to Amazon S3 and am now distributing it as a torrent. Here are the links to the four torrent files (Amazon doesn’t let you compress multiple files into a single torrent).

https://matttopper.com/personal/torrents/Oracle11gTechnicalPreview.disk1.zip.torrent
https://matttopper.com/personal/torrents/Oracle11gTechnicalPreview.disk2.zip.torrent
https://matttopper.com/personal/torrents/Oracle11gTechnicalPreview.disk3.zip.torrent
https://matttopper.com/personal/torrents/Oracle11gTechnicalPreview.disk4.zip.torrent

It is a VMWare virtual machine, personally I still like VMWare because I can run it on my laptop and take it with me anywhere. Oracle VM has its place in the server room, but not on the desktop, yet. It can be used by anyone with VMWare Player (www.vmware.com) for free.

The username and password for the machine is : oracle / oraclevms
These are torrents so please continue to seed them after your downloads are complete, this is the only way I’ll be able to afford to keep them online for people. If you are new to torrents check out http://support.bittorrent.com/ there you will find all the info you need, or just ask one of your pirate friends and I’m sure they can help you out. Admittedly the VM isn’t as nicely put together or as small as I normally do, but due to the circumstances I hope people can understand. I may be offline for a few days, but enjoy the download. This is my trial run for the bigger Oracle/VMware torrent site I hope to have together soon. Thanks to everyone helping with it, we’ll be launched shortly.

Oh yeah, and don’t forget to “Click It” below: 😉