permissions are the same. here's my oracle env parameters: $ env|grep -i ora PATH=/Oracle/oracle9_0_1/bin:/bin:/usr/bin:/usr/local/bin:/usr/bin/X11:/usr/ X11R 6/bin:/bin:. USER=ora901 CLASSPATH=/Oracle/oracle9_0_1/JRE:/Oracle/oracle9_0_1/jlib:/Oracle/oracle9_0 _1/r dbms/jlib:/Oracle/oracle9_0_1/network/jlib ORACLE_BASE=/Oracle/oracle9_0_1 ORACLE_HOME=/Oracle/oracle9_0_1 ORACLE_SID=ora901 LOGNAME=ora901 ORA_NLS33=/Oracle/oracle9_0_1/ocommon/nls/admin/data/ MAIL=/var/spool/mail/ora901 LD_LIBRARY_PATH=/Oracle/oracle9_0_1/lib:/lib:/usr/lib:/usr/local/lib HOME=/Oracle/oracle9_0_1
-----Original Message----- From: Sterin, Ilya [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 12, 2003 6:06 PM To: 'Moshe Rivel'; 'Michael A Chase'; [EMAIL PROTECTED] Subject: RE: can't connect to oracle Hmmm, you might want to check and make sure that you are running the script with same permissions as when you run in command line SQL Plus. I'm wondering if your environment is set correctly as well. Ilya -----Original Message----- From: Moshe Rivel [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 12, 2003 10:47 AM To: 'Michael A Chase'; '[EMAIL PROTECTED]' Subject: RE: can't connect to oracle (guess i don't have to mention i'm a DBI newbie, so thanks for your patience) this is a test script (btw, 'make test' worked fine when installing DBD::Oracle): #!/usr/bin/perl -w use strict; use DBI; DBI->trace(4, '/tmp/trace.trc'); my $dbs = DBI->connect ('DBI:Oracle:ora901','system','manager',)|| die "DB conne ct not made: $DBI::errstr"; $dbs->disconnect(); the trace log doesn't reveal something to me: DBI 1.32-nothread dispatch trace level set to 4 -> DBI->connect(DBI:Oracle:ora901, system, ****) -> DBI->install_driver(Oracle) for linux perl=5.006 pid=2633 ruid=119 euid=1 19 install_driver: DBD::Oracle version 1.12 loaded from /usr/lib/perl5/site_ perl/5.6.0/i386-linux/DBD/Oracle.pm New DBI::dr (for DBD::Oracle::dr, parent=, id=) dbih_setup_handle(DBI::dr=HASH(0x8186828)=>DBI::dr=HASH(0x81ecc48), DBD::Ora cle::dr, 0, Null!) dbih_make_com(Null!, DBD::Oracle::dr, 88) thr#(nil) <- install_driver= DBI::dr=HASH(0x8186828) -> connect for DBD::Oracle::dr (DBI::dr=HASH(0x8186828)~0x81ecc48 'ora901' ' system' **** HASH(0x81609c8)) New DBI::db (for DBD::Oracle::db, parent=DBI::dr=HASH(0x81ecc48), id=) dbih_setup_handle(DBI::db=HASH(0x81ecc0c)=>DBI::db=HASH(0x8159020), DBD::Ora cle::db, 81840a8, Null!) dbih_make_com(DBI::dr=HASH(0x81ecc48), DBD::Oracle::db, 116) thr#(nil) OCIErrorGet after OCIServerAttach (er1:ok): -1, 12154: ORA-12154: TNS:could not resolve service name !! ERROR: 12154 'ORA-12154: TNS:could not resolve service name (DBD ERROR: O CIServerAttach)' <- connect= undef at DBI.pm line 513 via ./db_connect.pl line 5 -> errstr in DBD::_::common for DBD::Oracle::dr (DBI::dr=HASH(0x8186828)~0x8 1ecc48) <- errstr= 'ORA-12154: TNS:could not resolve service name (DBD ERROR: OCISer verAttach)' at DBI.pm line 515 via ./db_connect.pl line 5 DBI connect('ora901','system',...) failed: ORA-12154: TNS:could not resol ve service name (DBD ERROR: OCIServerAttach) -> $DBI::errstr (&) FETCH from lasth=HASH >> DBD::Oracle::dr::errstr <- $DBI::errstr= 'ORA-12154: TNS:could not resolve service name (DBD ERROR: OCIServerAttach)' <> DESTROY ignored for outer handle DBI::db=HASH(0x81ecc0c) (inner DBI::db=H ASH(0x8159020)) -> DESTROY for DBD::Oracle::db (DBI::db=HASH(0x8159020)~INNER) DESTROY for DBI::db=HASH(0x8159020) ignored - handle not initialised <- DESTROY= undef dbih_clearcom 0x81ecc0c (com 0x8196290, type 2) done. -- DBI::END -> disconnect_all for DBD::Oracle::dr (DBI::dr=HASH(0x8186828)~0x81ecc48) <- disconnect_all= '' at DBI.pm line 575 via ./db_connect.pl line 0 dbih_clearcom 0x8186828 (com 0x81088a8, type 1) done. <> DESTROY for DBI::dr=HASH(0x8186828) ignored (inner handle gone) -----Original Message----- From: Michael A Chase [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 12, 2003 5:32 PM To: '[EMAIL PROTECTED]'; Moshe Rivel Subject: Re: can't connect to oracle 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.
