Local Repository error! BODI - 20006

dataservices administration
1

Hi,

I have installed BODI 3.2 onto a windows 2008 64 bit server which has the 32 bit Oracle client installed, using TNSNAMES.

I can connect to the database using SQLPLUS and can also TNSPING it, so I know everything on the Oracle side is set up correctly.

However when I try to connect using repository manager I get the following error message

Cannot open connection to the repository. The error message from the underlying DBMS is <OCI call for connection failed: <ORA-12154: TNS:could not resolve the connect identifier specified>.>. (BODI-20006)

Where is the path that BODI follows for the TNSNAMES file?

Anyone have any ideas?

Thanks

Badger

Badger (BOB member since 2008-12-17)

2

We are loading the oci.dll that is found first (usually found in $ORACLE_HOME/bin/oci.dll with ORACLE_HOME being the first in the PATH environment variable). This oci.dll then goes through its logic.

  • Is TNS_ADMIN set? No, then
  • Is there a $ORACLE_HOME/network/admin/tnsnames.ora?
    …
    …

Werner Daehn :de: (BOB member since 2004-12-17)