Try setting ORACLE_HOME and ORACLE_SID, clearing TWO_TASK, and using
'dbi:Oracle:' for the connect string and see if that helps.
--
Mac :})
** I normally forward private database questions to the DBI mail lists. **
Give a hobbit a fish and he'll eat fish for a day.
Give a hobbit a ring and he'll eat fish for an age.
----- Original Message -----
From: "A Dsouza" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, March 30, 2001 7:44 AM
Subject: DBD:Oracle connection failure


> My oracle data base and perl DBI are on the same unix host.But when i
> tried to connect using $dbhandle =
> DBI->connect('dbi:Oracle:SHIPDB','userid','passwd');
> I get error as DBI->connect(SHIPDB) failed: ORA-12541: TNS:no listener
> (DBD ERROR: OCIServerAttach) at testoracle.pl line 15A)
>
> I know that my oracle DB has no listener installed.
> How can I connect locally,since I am on the same host.
> I tried setting a bunch of $ENV variables such as ORACLE_HOME and
> TWO_TASK,ORAPIPES etc , but no help.


Reply via email to