can't connect to oracle

2003-01-12 Thread Moshe Rivel
oracle 9.0.1 linux RH 7.1 DBI connect('ora901','system',...) failed: ORA-12154: TNS:could not resolve serv ice name (DBD ERROR: OCIServerAttach) at ./db_connect.pl line 4 DB connect not made: ORA-12154: TNS:could not resolve service name (DBD ERROR: O CIServerAttach) at ./db_connect.pl line 4.

Re: can't connect to oracle

2003-01-12 Thread Michael A Chase
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

RE: can't connect to oracle

2003-01-12 Thread Moshe Rivel
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

Re: can't connect to oracle

2003-01-12 Thread Michael A Chase
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

RE: can't connect to oracle

2003-01-12 Thread Moshe Rivel
(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',)||

RE: can't connect to oracle

2003-01-12 Thread Moshe Rivel
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

Re: Problem with login as sysdba in DBI/DBD::Oracle

2003-01-12 Thread Jared Still
Georg, I don't think DBD::Oracle knows about the 'shutdown' and 'startup' commands. These are database control features that were previously available only svrmgrl, and are now standard in sqlplus. It seems that you can't directly startup/shutdown a database using DBD::Oracle. I just tried

Re: Using perl to startup/shutdown database

2003-01-12 Thread Jared Still
Hey Mike, I just responded to another thread on that same subject. The answer seems to be 'no'. These are database control functions which don't seem to be included in DBD::Oracle. Jared On Thursday 09 January 2003 14:54, Mike Bates wrote: I have search through the archives and read the

ANNOUNCE: DBD::Pg 1.21

2003-01-12 Thread David Wheeler
DBD::Pg 1.21 has been released and uploaded to CPAN. It should be making its way to your friendly neighborhood mirror very soon. Enjoy! David --- Changes: 1.21 Sun Jan 12 21:00:44 EST 2003 - System tables no longer returned by tables(). [Dave Rolsky] - Fix