Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change
 
PerlMonks  

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

by Skeeve (Vicar)
on Dec 02, 2009 at 17:28 UTC ( #810620=note: print w/ replies, xml ) Need Help??


in reply to Re: 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?

Okay :-( Then I'm lost as I'm not allowed to (nor willing to) change all the code we have to cope for this stupid bug I have. I think we "simply" have to find the reasson why per dumps core. After that we can do it the right way.


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


Comment on Re^2: DBI and oracle: How can I specify more than one host in connect string?
Select or Download Code
Re^3: DBI and oracle: How can I specify more than one host in connect string?
by roboticus (Canon) on Dec 02, 2009 at 17:33 UTC
    Skeeve:

    That would be my suggestion. Understanding and fixing errors is usually much more profitable than engineering band-aids.

    ...roboticus
Re^3: DBI and oracle: How can I specify more than one host in connect string?
by mje (Deacon) on Dec 02, 2009 at 20:07 UTC

    I would tend to agree with roboticus on this one. If you are getting a coredump when using a SID something is wrong and although you only know about one thing being broken right now it may turn out you've got other problems you have not found yet.

    However, I'm a little surprised at the comment "not allowed to (nor willing to) change all the code we have to cope for this stupid bug" as 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) b) you have not ascertained where the problem is yet and c) the use of "stupid bug" doesn't seem too productive. We don't know where the problem lies; it may be in your perl, DBD::Oracle, OCI, NET8, the way any of them were built or perhaps it is a fixed problem and you are using old versions. Did it ever work on this machine and did you install DBD::Oracle without running the tests or install it after running the tests and some of them failed.

    Step back and check sqlplus out with your SID to check that is working then if that works move on to unpacking DBD::Oracle, building it and running the tests - do they pass? If you still have problems the dbi-users mailing list is a good place to start but make sure you post the relevant information like platforms, perl -V, versions of modules etc.

      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

        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.

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (9)
As of 2014-08-29 20:56 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (289 votes), past polls