2.Set the TNS_ADMIN environment variable value with one of the copied locations in the step 1 in user.cmd or http://user.sh file depending on your OS.
This file will be found under
(Example : C:OBIinstancesinstance2bifoundationOracleBIApplicationcoreapplicationsetup)
Multiple Oracle Homes exist which can cause confusion to OBI Admin tool for where to reference OCI libraries, NLS and the tnsnames.ora entries.
So this requires a few additional configuration steps in this case.
1. For the Admin Tool installed with the complete OBIEE server installation:
1.1. Edit registry under HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\<Oracle_Home> to make sure NLS_LANG key is set to a valid characterset for the Oracle Client used as the DSN.
1.2. Please edit the file %MiddleWare_Home%\instances\instance1\bifoundation\OracleBIApplication\coreapplication\setup\bi-init.cmd to set %ORACLE_HOME%\bin as first entry in the PATH.
1.3. Please edit the file %MiddleWare_Home%\instances\instance1\bifoundation\OracleBIApplication\coreapplication\setup\user.cmd to set TNS_ADMIN to your Oracle client tnsnames.ora home directory path (in case exists) or to your OBIEE tnsadmin %OBIEE_Client_Home%\Oracle_BI1\network\admin.
2. For the Admin Tool installed with the new standalone installer:
2.1. Edit registry under HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\<Oracle_Home> to make sure NLS_LANG key is set to a valid characterset for the Oracle Client used as the DSN.
2.2. Please edit the file %OBIEE_Client_Home%\\oraclebi\orahome\bifoundation\server\bin\bi_init.bat to set %ORACLE_HOME%\bin as first entry in the PATH.
2.3. Please add TNS_ADMIN entry to the bi_init.bat file to point to your Oracle client tnsnames.ora home directory path.
Please note to open the Oracle BI Admin Tool using the start menu shortcut (Start >> Programs >> Oracle Business Intelligence >> Administration Tool) and not by double clicking the RPD file nor through a Custom shortcut as this is required to initialize required environment variables.
While connecting from your standalone BI Admin Tool client in online mode. please note that in this case you will be using the tnsnames.ora file on the BI server, so please make sure your connection pool has the correct entries for your oracle DB and the tnsnames.ora file on the BI server has the corresponding TNS entry.
Please make your TNS entry is with the same name as the SID. Also TNS_ADMIN environment variable need to be set on the BI server to point to the tnsnames.ora file location.