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.
