Check your $TNS_ADMIN/sqlnet.ora file for a like this:
NAMES.DIRECTORY_PATH = (TNSNAMES,ONAMES)
much like a nsswitch.conf it says in which order to look up information. If
you want tnsnames.ora to come first you'll have to reserve TNSNAMES and
ONAMES in the example above of course. We mostly use TNS and fix the
node-connect troubles using DNS but your approach should work as well.
What output do the sqlplus and tnsping command give ?
-----------------------------------
Frans Postma, (050-58) 81 852
ATOS Origin, Unix Support
"If at first you don't succeed, skydiving isn't for you"
> -----Oorspronkelijk bericht-----
> Van: Morrison Davis [mailto:[EMAIL PROTECTED]]
> Verzonden: donderdag 13 februari 2003 16:41
> Aan: [EMAIL PROTECTED]
> CC: [EMAIL PROTECTED]
> Onderwerp: Re: Oracle connection problems
>
>
> That all works with the exception of sqlplus and I've put the
> IP address
> in the tnsnames.ora file as the host
> to try and avoid any DNS names issues, that was the first thing I
> tried. I am the DBA for this data base but only due to recent
> cutbacks
> not because of my knowledge of oracle.
>
> [EMAIL PROTECTED] wrote:
>
> >Probably name-resolving problem, try to do a "nslookup
> HOSTNAME_HERE" and
> >see if that returns the correct ip for the machine you want
> to connect to.
> >
> >If that works, try a 'tnsping' to the database, followed by a sqlplus
> >session to it. If all those work, then it MIGHT be a DBD problem :)
> >
> >-----------------------------------
> >Frans Postma, (050-58) 81 852
> >ATOS Origin, Unix Support
> > "If at first you don't succeed, skydiving isn't for you"
> >
> >
> >
> >
> >
> >
> >>-----Oorspronkelijk bericht-----
> >>Van: Morrison Davis [mailto:[EMAIL PROTECTED]]
> >>Verzonden: donderdag 13 februari 2003 15:36
> >>Aan: dbi-users
> >>Onderwerp: Oracle connection problems
> >>
> >>
> >>This is probably more of an oracle problem than DBI problem but I'm
> >>getting desperate. I can connect
> >>from any machine thats in the same domain as my server but
> >>not from any
> >>machine outside that domain.
> >>I get the ora-12545 error, target host does not exist. Listener is
> >>running and I can see entries in the listener log file from
> >>these other
> >>machines but they never connect succesfully. I'm suspicious of one
> >>thing, when I see the host names trying to access in the
> log file it
> >>does n't include their domain name I do see their IP address
> >>so I'm not
> >>sure. I have read the perldoc on DBD::Oracle and tried all
> different
> >>connection methods but I get the same error tryin to use
> sqlplus too.
> >>Any advice would be much appreciated, my project is topped
> >>until I can
> >>figure this out.
> >>
> >>--
> >>Thanks Morry
> >>e-mail address: [EMAIL PROTECTED]
> >>phone: X84792/650 786-4792 fax 650 562-2143
> >>
> >>
> >>
> >>
>
> --
> Thanks Morry
> e-mail address: [EMAIL PROTECTED]
> phone: X84792/650 786-4792 fax 650 562-2143
>
>
>
