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.
Can somebody help me out.
Thanks