All of the topics discussed here in this blog comes from my real life encounters. They serve as references for future research. All of the data, contents and information presented in my entries have been altered and edited to protect the confidentiality and privacy of the clients.

Various scenarios of designing RPD and data modeling

Find the easiest and most straightforward way of designing RPD and data models that are dynamic and robust

Countless examples of dashboard and report design cases

Making the dashboard truly interactive

The concept of Business Intelligence

The most important concept ever need to understand to implement any successful OBIEE projects

Making it easy for beginners and business users

The perfect place for beginners to learn and get educated with Oracle Business Intelligence

Thursday, May 23, 2013

Upgrading OBIEE from 10G to 11G and post upgrade activities Part 2

From the previous entry of this series, we went through what was like to upgrade OBIEE 10G to 11G, which was not bad. We also covered some of the post upgrade activities that we pretty much had to do for the system to start working. This time, I want to expand on that and add one more post upgrade activity that is almost a must for everybody going from 10g to 11g.

In order for 11G to successfully connect to the DB and fetch data, we must have the proper Tnsname file stored on the server machine. Normally, the Tnsname file is stored in the OracleDB Home/Network/Admin directory. For OBIEE 11G, there is one more directory the Tnsname file needs to be copied to:

Your OBIEE 11G Home/Oracle_BI1/Network/Admin

Your Tnsname.ora file should have all of the connectivity information for the DB machine, if not you should consult with your DBA.. If you are not sure whether the Tnsname is correct or not, you can always try connecting from your OBIEE server machine to the DB Machine through sqlplus.

In you Putty terminal:

$ sqlplus username/password@instance name

If your connection is successful, that means the TNS Entry is working in the file, then move on to the following step.

Modify the user.cmd file from the following directory:

Your OBIEE 11G Home/instance/instance1/BIfoundation/OracleBIApplication/coreapplication/setup.

The user.cmd file has the environment variable $TNS_ADMIN, which by default has no value. The path where tnsname.ora file was located from the above-mentioned step will need to be entered in the user.cmd file. Below is a sample file from my environment after modification, which is linux:

@echo off
REM This file is a placeholder for setting environment variables

After that, restart OBIEE service in Weblogic's em interface.

You should be able to connect to the DB from OBIEE.

Related Posts Plugin for WordPress, Blogger...