>> This is an oracle/environmental problem not a perl/DBI one. Does SQL plus
>> work with the same environment? Is ORACLE_HOME set correctly.
>> Basically the error states that the xxSUNhostxx cannot be resovled using the
>> TNS method. (Usually a tnsnames.ora file in $ORACLE_HOME/network/admin
>> directory but your environment may be different. (Also I don't know about
>> Oracle 9)
Bingo !
SQLplus works only with the fully qualified hostname.
And so the perl script alsoo works when I give the fully qualified
host string:
$dbh = DBI->connect("DBI:Oracle:xxSUNhostxx.fzk.de",'yyyy',....)
I don't know why Oracle is not able or willing to use the capabilities
of the OS (it knows the short name through DNS!). Seems they have
reinvented the wheel, but forgot the tyres...
--
Dr. Udo Grabowski email: [EMAIL PROTECTED]
Institut f. Meteorologie und Klimaforschung II, Forschungszentrum Karslruhe
Postfach 3640, D-76021 Karlsruhe, Germany Tel: (+49) 7247 82-6026
http://www.fzk.de/imk/imk2/ame/grabowski/ Fax: " -6141
