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

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

Thanks for your reply. In the meantime, I've found out that it works if
I start sqlrelay as the oracle user. So I guess it has something to do
with the environment. I'll ask my DBA.

Thanks again, Dominik

On Tue, 2006-01-24 at 21:47 +0700, Rachman Chavik wrote:
> 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
-- 
Dominik Meister <ne...@gm...>
My public GnuPG key is available at http://meischter.homelinux.org/gpg.txt