BI Admin tool unable to connect to database
937299May 14 2012 — edited May 15 2012HI , I 'm a newbie in OBIEE and have just installed OBIEE11g on windows 64bit machine , my problem is that I'm unable to import metadata in repository and getting connection error
I've tried everything mentioned in forums mainly :
Copy the tnsnames.ora from Oracle Database home (ORACLE_HOME\NETWORK\ADMIN\) to the following locations.
\OracleBI1\network\admin (Example: C:\OBI\Oracle_BI1\network\admin)
\oracle_common\network\admin (Example: C:\OBI\oracle_common\network\admin)
Set the TNS_ADMIN environment variable value with one of the copied locations in the step 1 in user.cmd or user.sh file depending on your OS.
I might be missing something, Please help!!! It's taking up lot of time and am not able to resolve this.
Thanks in advance.