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

[Rachman C. <rc...@at...>]

Dominik Meister wrote:
> 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
> 

Make sure that SQLrelay gets the appropriate Oracle environment.
Normally, source /usr/local/bin/oraenv before starting sqlrelay.

Furthermore, to test whether your Oracle Net is configured properly,
do:
$ tnsping DVECILS

$ sqlplus username/password@DVECILS

if you simply use user/pass without the @DEVCILS, sqlplus does not use
Oracle Net.  Someone please correct me if I'm wrong.

Rgds
-- 
Rachman Chavik
email: rc...@at...
email: ra...@ch...
email: rc...@et...
www: http://www.chavik.com