Beefy Boxes and Bandwidth Generously Provided by pair Networks
Come for the quick hacks, stay for the epiphanies.
 
PerlMonks  

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

by mje (Curate)
on Dec 02, 2009 at 20:07 UTC ( [id://810672]=note: print w/replies, xml ) Need Help??


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

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.

Replies are listed 'Best First'.
Re^4: DBI and oracle: How can I specify more than one host in connect string?
by Skeeve (Parson) on Dec 03, 2009 at 11:15 UTC

    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.

        ;-) 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
Domain Nodelet?
Node Status?
node history
Node Type: note [id://810672]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others about the Monastery: (3)
As of 2024-03-19 03:48 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found