[Sqlrelay-discussion] Oracle 10g: could not resolve the connect identifier specified

[Dominik M. <ne...@gm...>]

Hello

First, I'm completely new to sqlrelay. I've installed it to use it with
an Oracle 10g database.

The relevant part of my sqlrelay.conf file looks like this:

<connection connectionid="exampleconnection"
string="user=my_user;password=my_password;oracle_sid=DVECILS;"
metric="1"/>

The tnsnames.ora file looks like this:
DVECILS =
 (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = labdev)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SID = dvecils)
    )
 )

Whenever I start sqlrelay I get:

Starting 3 connections to labdev :
  sqlr-connection-oracle8 -id labdev -connectionid labdev
-config ../etc/sqlrelay.conf
OCIServerAttach() failed.


ORA-12154: TNS:could not resolve the connect identifier specified

Couldn't log into database.

sqlr-connection-oracle8 failed to start.


If I'm trying to connect directly with sqlplus or from a remote machine
with the Oracle Client everything works fine.

What am I doing wrong?

Thanks, Dominik

-- 
Dominik Meister <ne...@gm...>
My public GnuPG key is available at http://meischter.homelinux.org/gpg.txt