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.
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
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
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
(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',)||
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
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
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
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