Re: Oracle 9i with connection mgr through a router

I had queried using "router" and "connection manager" but came up empty. Your fix worked, though. I just couldn't remember exactly how to do it.

Thanks!

"Sybrand Bakker" <gooiditweg_at_sybrandb.verwijderdit.demon.nl> wrote in message news:fe7ah094rd5vkoe459aik4bgsqdkdvhbj1_at_4ax.com...
> On Sat, 7 Aug 2004 12:59:52 -0500, "Dave Penn"
> <djpenn3_at_hotmail.com_spammenot> wrote:
>
> >My setup is:
> >
> >An Oracle 9.2.0.1.0 Enterprise Edition Win2K DB server with ConnMgr
> >installed and running. The DB looks fine and I can connect via SQL*Plus
> >from the same machine.
> >
> >From another machine on the same Gigabit Ethernet switch, I can't
connect.
> >Gives an ORA-12564 connection refused error.
> >
> >As I recall from a previous Oracle setup, an addition entry needs to be
made
> >in the tnsnames.ora file for the net service on each of the computers.
> >Something like this:
> > DBASE =
> > (DESCRIPTION =
> > (ADDRESS_LIST =
> > (ADDRESS=(PROTOCOL=TCP)(HOST = host_name1)(PORT=1521))
> > (ADDRESS=(PROTOCOL=TCP)(HOST = host_name2)(PORT=1630))
> > )
> > (CONNECT_DATA =
> > (SERVER=DEDICATED)
> > (SERVICE_NAME=dbase)
> > )
> > )
> >
> >How exactly do I need to do this on the server and client machines?
> >
> >Thanks tons for the help...
> >
> >Dave Penn
> >
> >
>
> add source_route=yes after description. And of course one quick query
> on tahiti.oracle.com would also have provided this answer.
>
>
> --
> Sybrand Bakker, Senior Oracle DBA
Received on Sat Aug 07 2004 - 19:58:17 CDT