[Sqlrelay-discussion] Oracle 10g: could not resolve the connect identifier specified
Brought to you by:
mused
|
From: Dominik M. <ne...@gm...> - 2006-01-24 11:34:37
|
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
|