Hi - I'm working on SAP BI 4.0 upgrade and migrated BO 3.1 content to 4.0. After migration, while refreshing the webi reports I'm getting the below error.
Database error: ORA-12154: TNS:could not resolve the connect identifier specified. (IES 10901) (WIS 10901)
Windows 2003 SP2
SAP BI 4.0 (no support and fix packs)
Oralce 11g 32 bit client
Oracle 11g 64 bit client
I tried below workarounds but no luck. Logged a case with SAP but no update.
1. Oracle_home settings pointing to both oracle client installs
2. Path variable changes
3. TNS_Admin settings
Please let me know if you had faced similar issues.
Could you please specify how did you set up your environment variables?
You indicate: Oracle_home settings pointing to both oracle client installs
I presume that the problem is that BI4 can't find the tnsnames.ora or the entry is not there.
WebI is 64bits so you need to make sure that you have the correct combination of middleware and environment variable.
Oracle_Home = <64 bit oracle client path>
Path = <64 bit oracle install path>
TNS_ADMIN= <tnsnames.ora file path>
These are the parameters set in the environment variables but not resolved.
I'm able to refresh the reports from client but from BI launch pad throwing the error message.
Edited by: Suresh Avala on Mar 2, 2012 8:53 PM