Hi Michael, Unfortuantely when I did the client install I only put on the required libraries to get DBI-Oracle working, so I haven't got SQL*Plus to test with. However I'm pretty sure that tnsnames.ora is OK, as a tnsping was working OK before I started testing with DBI.
However, I've just tried doing a tnsping again, and got: Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=orasrv01)(PORT=1521)) TNS-12535: TNS:operation timed out Running the same command a few seconds later I got: Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=orasrv01)(PORT=1521)) OK (100 msec) Pinging the original v8 databases always works fine, which again makes me think that the Oracle client may need upgrading... ? Regards, Rob -----Original Message----- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Thursday, October 31, 2002 4:31 PM To: [EMAIL PROTECTED]; Rob Leadbeater Subject: Re: Oracle libraries required for connecting On Thu, 31 Oct 2002 13:31:11 +0000 [EMAIL PROTECTED] wrote: > I've got a couple of systems here running DBI 1.21 and DBD-Oracle 1.06, > which successfully communicate with an Oracle Database (v 8.1.7). > The components of the Oracle client which are installed are version > 8.0.5. > > I'm trying to get the same client machines to talk to a newly installed > Oracle 9i box, however this fails with errors like this: > > DBI->connect(ORASRV) failed: ORA-12203: TNS:unable to connect to > destination (DBD ERROR: OCIServerAttach) at > /usr/local/lib/perl5/site_perl/5.6.1/alpha-dec_osf/DBI/Shell.pm line 749 > > Am I right in thinking that these errors are due to me requiring > something newer than the 8.0.5 client ? > I know DBI and DBD are fairly old as well. Are newer version required to > talk to Oracle 9 ? The Oracle 8 SQL*Net client should be able to talk to Oracle 9. It looks like there is a problem in tnsnames.ora. Try cutting and pasting the exact connect information (instance, username, password) to login using the SQL*Plus that is part of the Oracle 8 client to confirm. Newer versions of DBI and DBD are almost always a good idea, but I don't think they are your problem yet. -- 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. This message is intended only for the use of the person(s) ("The intended Recipient(s)") to whom it is addressed. It may contain information which is privileged and confidential within the meaning of applicable law. If you are not the intended recipient, please contact the sender as soon as possible. The views expressed in this communication are not necessarily those held by LYNX Express Limited.
