Operating System - HP-UX
1748224 Members
4431 Online
108759 Solutions
New Discussion юеВ

Re: Supressing error about unset ORACLE_HOME from DBD::Oracle

 
Jean-Luc Oudart
Honored Contributor

Re: Supressing error about unset ORACLE_HOME from DBD::Oracle

Sorry,
sometimes the screen goes to wide and I cannot see if there is an attachment.

may be a "refresh" pb.

JL
fiat lux
Ralph Grothe
Honored Contributor

Re: Supressing error about unset ORACLE_HOME from DBD::Oracle

Merijn,

I looked up my Netscape bookmarks file.
There I marked "http://www.cpan.org/"

I always thought this would redirect me by some dispatcher process (most likely written in Perl?) on that server to a mirror closest to me with enough free bandwith.

I can remember that when I configured the CPAN module (on first time of its shell invocation) that I was presented with a list of some 20 German CPAN mirrors of which I selected 5.

But I don't think Netscape is consulting the CPAN module's configuration ;-)

TK for the debugger?
Ough, that meant I could do my Perl scripting only if I had an X-server running.
Too much production in my view.
I've been most happy with Perl's own debugger.
I'm one of those anachronistic guys who don't believe in fancy images and click away icons ;-)
Madness, thy name is system administration
H.Merijn Brand (procura
Honored Contributor

Re: Supressing error about unset ORACLE_HOME from DBD::Oracle

Jean-Luc, attachment is on initial message
Ralph, I'm worse. I use print and printf statements.

N/A

BTW I just don't like Oracle!
Enjoy, Have FUN! H.Merijn
Ralph Grothe
Honored Contributor

Re: Supressing error about unset ORACLE_HOME from DBD::Oracle

Then I guess you are like me a civil engineer (in my case Naval Architecture) who had been too long exposed to Fortran.
(I think print/write statements are the classic Fortran debugger).
Madness, thy name is system administration
H.Merijn Brand (procura
Honored Contributor

Re: Supressing error about unset ORACLE_HOME from DBD::Oracle

Only had some fortran in school. Come and discuss on https://www.beepz.com/itrc-chat/client/index.html

prints is mostly a sninnoff of my parrallel thinking and processing (no POSIX threads though)
Enjoy, Have FUN! H.Merijn
Ralph Grothe
Honored Contributor

Re: Supressing error about unset ORACLE_HOME from DBD::Oracle

Sigh,
I envy you for your parallel thinking capabilities.
My neural network only only does things sequentially (that's why I'm so slow), or at least blocks any deliberate parallel paths.
I will have a look at your chat room...
Madness, thy name is system administration
Brian Crabtree
Honored Contributor

Re: Supressing error about unset ORACLE_HOME from DBD::Oracle

Ralph,

Most likely, the reason that you are connecting is because DBD/DBI was compiled with the Oracle Home attached. I would recommend leaving the ORACLE_HOME in place, as using the TNS_ADMIN enviroment variable will suffice. The search order is as follows:

$TNS_ADMIN
/etc
$ORACLE_HOME/network/admin
$HOME/.tnsnames.ora

Provided that you are setting the TNS_ADMIN variable, it should not matter if the ORACLE_HOME is set, and you would not get this error message.

You other option, rather than building a static tnsnames.ora file, would be to build connections dynamicly with the system name, dbname, and port number.

Brian