Posts
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
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
