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



Reply via email to