On Sun, 12 Jan 2003 17:19:09 +0200 Moshe Rivel <[EMAIL PROTECTED]> wrote:
> yes i can > > -----Original Message----- > From: Michael A Chase [mailto:[EMAIL PROTECTED]] > Sent: Sunday, January 12, 2003 5:25 PM > To: '[EMAIL PROTECTED]'; Moshe Rivel > Subject: Re: can't connect to oracle > > > On Sun, 12 Jan 2003 16:49:40 +0200 Moshe Rivel <[EMAIL PROTECTED]> wrote: > > > oracle 9.0.1 > > linux RH 7.1 > > DBI connect('ora901','system',...) failed: ORA-12154: TNS:could not > resolve > > service name (DBD ERROR: OCIServerAttach) at ./db_connect.pl line 4 > > DB connect not made: ORA-12154: TNS:could not resolve service name (DBD > > ERROR: OCIServerAttach) at ./db_connect.pl line 4. > > That sort of error usually indicates a problem in SQL*Net, most often > in tnsnames.ora. Can you connect using SQL*Plus in the same host with > the exact same instance and userid? Then post a snippet that demonstrates the problem and try running it with tracing set to level 4 just before the connect attempt. Look at `perldoc DBI` and look for trace and debugging to see how to use trace(). -- Mac :}) ** I normally forward private questions to the appropriate mail list. ** Ask Smarter: http://www.tuxedo.org/~esr/faqs/smart-questions.html Give a hobbit a fish and he eats fish for a day. Give a hobbit a ring and he eats fish for an age.
