Disclaimer

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.

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
REM set TNS_ADMIN=
/home/oracle/app/MV_Home/Oracle_BI1/network/admin

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

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

Thanks

2 comments:

heena goyal said...

HEY,
This is a nice piece of information provided http://www.wiziq.com/course/22309 is a e-learning platform and is useful for the people who wants to learn online.

obiee training in hyderabad said...

please suggest me the best obiee training institutes in hyderebad

Related Posts Plugin for WordPress, Blogger...