DBD::Oracle / Oraperl still connecting problems.. 
Author Message
 DBD::Oracle / Oraperl still connecting problems..

Hi everybody,

all my tries to connect to a remote Oracle db will fail.

$ENV{ORACLE_HOME} = '/home/oracle/app/oracle/product/7.3.2';
$ENV{TWO_TASK}    = 'tp6:adler.lih.rwth-aachen.de:lih';

$dbh = DBI->connect('dbi:Oracle:tp6','tp2' , '<passwd>') || die $DBI::errstr;

#or ................................,'tp2/<passwd>')...

#oraperl statements will also fail
#$lda = &ora_login ('tp6', 'tp2', 'oracle') or die "Can not connect: $ora_errstr";      
#$lda = &ora_login('dbi:Oracle', 'tp2', 'oracle') | die "not connected" ;

follow. error occur:
ORA-12154: TNS:could not resolve service name (DBD: login failed) at ora.pl line 17

For help many thx

Detlef

--
~~\  |  /~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~+~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~+~~~~~~~~~~~
     _     Lifeartist is  D.  Weitz     | :-) Lifetime is too short just for working (-: |      __o
 -- (_) --  Fachschaft Geol./Mineral.   |        so share work with unemployeed &        |    _`\<,_

  /  |  \     ICQ: 18279899 || 22637374 |             a month/year isn't enough          |
~~~let it shine     ***   http://www.*-*-*.com/ ~maen/  ***                 |



Fri, 17 Aug 2001 03:00:00 GMT  
 DBD::Oracle / Oraperl still connecting problems..

Quote:

> Hi everybody,

> all my tries to connect to a remote Oracle db will fail.

> $ENV{ORACLE_HOME} = '/home/oracle/app/oracle/product/7.3.2';
> $ENV{TWO_TASK}    = 'tp6:adler.lih.rwth-aachen.de:lih';

> $dbh = DBI->connect('dbi:Oracle:tp6','tp2' , '<passwd>') || die $DBI::errstr;

> ORA-12154: TNS:could not resolve service name (DBD: login failed) at ora.pl line 17

I had the same error message when trying to connect.
is your database named in the TNSnames.ora file??
if the tnsnames.ora file at 'ORACLE_HOME'??
and try your two_task version and the tnsnames one with:

use $dbh = DBI->connect('dbname', userid, passwd, 'Oracle') || die etc.

Richard H



Sat, 25 Aug 2001 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. DBD-Oracle: Problems connecting to Oracle

2. Another funny problem connecting to an Oracle DB using DBD

3. Problem connecting with DBD-Oracle on WinNT

4. Problems connecting DBD::Oracle

5. Unable to connect to Oracle through SQL*NET V2 and DBD 0.38

6. DBI / DBD Oracle connect question

7. DBD-Oracle Connect (NT)

8. NT ORACLE PERL DBD DBI->connect format

9. Unabel to connect to Oracle using DBD

10. DBI/DBD/Oracle connect won't work (ORA-12154)

11. NT ORACLE PERL DBD DBI->connect format

12. Oraperl / DBD / Perl5 Performance for Oracle query?

 

 
Powered by phpBB® Forum Software