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
|
