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
