Re^2: DBI and Oracle ORA-12505 error

Thank you for your reply ! I apologize in advance for the French in the error messages below (all this is happening on a French Windows XP box).

First of all, the TWO_TASK environment variable is not set in this Windows system. I have not tried to use it. Here is the output of the snippet that you suggested:

C:\test>perl oracle_test.pl
DBI connect('sid=JUPITER;host=jupitercluster','user',...) failed: ORA-
+12505: TNS : le module d'écoute (listener) n'a pas pu résoudre le SID
+ donné dans le descripteur de connexion (DBD ERROR: OCIServerAttach) 
+at oracle_test.pl line 11
[download]

As for tnsping, I guess that it gives a strong indication. Using it produces a TNS-03505 error for every single alias in the tnsnames.ora file ! This is strange because I can successfully use all the other tnsnames.ora aliases from within Perl/DBI, as well as using the Oracle SQL Developer client. I mean, except the one I am having a problem with, which does not work from within Perl/DBI, but *does* work using the Oracle SQL Developer client.

c:\test> tnsping JUPITER
   or 
c:\test> tnsping jupiter
TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on
+ 13-MAI-2013 17:17:40

Copyright (c) 1997 Oracle Corporation.  All rights reserved.

Fichiers de paramètres utilisés :
C:\Oracle\network\admin\sqlnet.ora

TNS-03505: Echec de la résolution du nom
[download]

Here is the (short) content of sqlnet.ora:

# Generated by our DBA

NAMES.DEFAULT_DOMAIN = mycompany.com

NAMES.DIRECTORY_PATH= (TNSNAMES)
[download]

Any further suggestions ? Again, thanks a lot for your answer. And yes, learning about Oracle and Perl/Oracle is fun ;-)

Comment on Re^2: DBI and Oracle ORA-12505 error Select or Download Code

Replies are listed 'Best First'.
Re^3: DBI and Oracle ORA-12505 error by Tux (Canon) on May 13, 2013 at 16:26 UTC
In your first code snippet, you are still using the uppercase SID. Try it lowercased!. `tnsping` works with the identifier, which most often is not the same as the SID. $ head -4 $ORACLE_HOME/network/admin/tnsnames.ora oradb_btest = ( DESCRIPTION = ( ADDRESS_LIST = ( ADDRESS = ( HOST = oradb )( PORT = 1521 )( PROTOCOL = TCP ))) ( CONNECT_DATA = ( SERVICE_NAME = basetest )) ) $ tnsping oradb_btest TNS Ping Utility for HPUX: Version 10.2.0.4.0 - Production on 13-MAY-2 +013 18:24:26 Copyright (c) 1997, 2007, Oracle. All rights reserved. Used parameter files: /prod/oracle/v102/network/admin/sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact ( DESCRIPTION = ( ADDRESS_LIST = ( ADDRESS = ( P +ROTOCOL = TCP)( PORT = 1521) ( HOST = oradb))) ( CONNECT_DATA = ( SER +VICE_NAME = basetest))) OK (90 msec) $ [download] Enjoy, Have FUN! H.Merijn /code	[reply] [d/l] [select]

Replies are listed 'Best First'.

Re^3: DBI and Oracle ORA-12505 error
by Tux (Canon) on May 13, 2013 at 16:26 UTC

In your first code snippet, you are still using the uppercase SID. Try it lowercased!.

tnsping works with the identifier, which most often is not the same as the SID.

$ head -4 $ORACLE_HOME/network/admin/tnsnames.ora
oradb_btest = ( DESCRIPTION = ( ADDRESS_LIST =
  ( ADDRESS      = ( HOST = oradb )( PORT = 1521 )( PROTOCOL = TCP )))
  ( CONNECT_DATA = ( SERVICE_NAME = basetest ))
  )
$ tnsping oradb_btest

TNS Ping Utility for HPUX: Version 10.2.0.4.0 - Production on 13-MAY-2
+013 18:24:26

Copyright (c) 1997,  2007, Oracle.  All rights reserved.

Used parameter files:
/prod/oracle/v102/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact ( DESCRIPTION = ( ADDRESS_LIST = ( ADDRESS = ( P
+ROTOCOL = TCP)( PORT = 1521) ( HOST = oradb))) ( CONNECT_DATA = ( SER
+VICE_NAME = basetest)))
OK (90 msec)
$
[download]

Enjoy, Have FUN! H.Merijn

[reply]
[d/l]
[select]