Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris
 
PerlMonks  

Re^4: DBI and oracle: How can I specify more than one host in connect string?

by Skeeve (Vicar)
on Dec 03, 2009 at 11:15 UTC ( #810808=note: print w/ replies, xml ) Need Help??


in reply to Re^3: DBI and oracle: How can I specify more than one host in connect string?
in thread DBI and oracle: How can I specify more than one host in connect string?

a) I find it difficult to see just how much code you'd have to change for a change in connect calling (how many calls to connect can you have scattered around)

It's difficult for me too. In this case it would be one script on 2 machine. But since there are several similar scripts I would have to find out which ones should be changed too. And then those scripts are used on otehr machines to and to keep it consistant I would have to apply the changes to the other n-hundred machines too.

b) you have not ascertained where the problem is yet and

Correct. Except that it fails as soon as DBI::connect is executed.

c) the use of "stupid bug" doesn't seem too productive

not productive, but descriptive ;-)

But to answer your question: It never worked on that machine (Intel Solaris). I just copied over a perl from another intel machine. There it fails too. I didn't "install" nor compile anything. It's work done by others in this big company I work for. I already told them but they have no time yet, fixing the bug.

sqlpls works perfectly on the machine. But I can't compile on the machine as there are no compilers (not allowed).

BTW: Even connecting with a host given, is not working perfectly as the connect itself needs aboz 70 seconds.

Thanks for your tips. I will have to talk to the one who compiled perl.


s$$([},&%#}/&/]+}%&{})*;#$&&s&&$^X.($'^"%]=\&(|?*{%
+.+=%;.#_}\&"^"-+%*).}%:##%}={~=~:.")&e&&s""`$''`"e


Comment on Re^4: DBI and oracle: How can I specify more than one host in connect string?
Select or Download Code
Re^5: DBI and oracle: How can I specify more than one host in connect string?
by mje (Curate) on Dec 03, 2009 at 11:37 UTC

    So you are running pretty much the same scripts on hundreds of machines - surely you keep those in some sort of central repository - never mind. Anyway, I think you are in a world of pain, copying binaries around across machines and I am sorry you cannot change anything, install anything etc but I cannot help you any further under those limitations.

      ;-) Sure it's a pain. Thanks for your compassion.

      I already asked the responsible guys to give me a proper perl.

      And yes: We have a "central" repository but it's all a bit of a mess. It's all not worth working around a bug that shouldn't be there.


      s$$([},&%#}/&/]+}%&{})*;#$&&s&&$^X.($'^"%]=\&(|?*{%
      +.+=%;.#_}\&"^"-+%*).}%:##%}={~=~:.")&e&&s""`$''`"e

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://810808]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others studying the Monastery: (11)
As of 2015-07-02 08:33 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (31 votes), past polls