Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW
 
PerlMonks  

Database connection error

by valavanp (Curate)
on Aug 31, 2006 at 12:55 UTC ( [id://570597]=perlquestion: print w/replies, xml ) Need Help??

valavanp has asked for the wisdom of the Perl Monks concerning the following question:

This node falls below the community's threshold of quality. You may see it by logging in.

Replies are listed 'Best First'.
Re: Database connection error
by shmem (Chancellor) on Aug 31, 2006 at 13:11 UTC
    You wrote:
    Since i am not able to access the database the possiblities for the error may be due to
    1. Database Name
    2. Database user name.
    3. Database passwd.
    I guess Database host is missing (or at the wrong place of your command line), since the error message comes from the unix utility host - and I guess you are invoking a shell script...

    Is this perl related in any way?

    After hitting the button preview you see a prominent line under the rendered text, which reads:

    If something looked unlike you expected it to you might need to check out Writeup Formatting Tips

    Do so.

    Just hacking your question in and clicking preview and create is just bad manners.

    <update>And then there's the node How do I post a question effectively? to read...
    (formatting of OP was fixed after posting this reply)</update>

    --shmem

    _($_=" "x(1<<5)."?\n".q·/)Oo.  G°\        /
                                  /\_¯/(q    /
    ----------------------------  \__(m.====·.(_("always off the crowd"))."·
    ");sub _{s./.($e="'Itrs `mnsgdq Gdbj O`qkdq")=~y/"-y/#-z/;$e.e && print}
Re: Database connection error
by cdarke (Prior) on Aug 31, 2006 at 13:11 UTC
    Please supply the Perl code that generates this error message!
    I would check the obvious first, that is exactly what the error message tells you to do, check ORACLE_HOME and NLS settings etc.
    It (whatever 'it' is) is giving a usage listing, so another posibility is that incorrect arguments have been supplied.
    Methinks this is a question for Oracle support...
Re: Database connection error
by Grey Fox (Chaplain) on Aug 31, 2006 at 14:19 UTC
    Howdy;

    Depending on the OS you are using, I would check the ODBC connections. I have run into similar types of errors if the ODBC is not set up correctly. In windows it's set with the ODBC Data Source Administrator. Also I found a link to a similar discussion using google.

    www.issociate.de/board/post/172801/NLS_issues_if_using_DBD::Oracle_from_mod_perl2.html

    -- Grey Fox
    Perl - Hours to learn lifetime to master.
Re: Database connection error
by xorl (Deacon) on Sep 01, 2006 at 15:23 UTC
    If this is 10g, The error message that is produced is very misleading. Whatever user that is running the script needs to be in the same group as the owner of the $ORACLE_HOME directory.
      hi xorl, The problem is rectified. This is due to database name and user accounts are wrongly given by the client. And also the files which are transferred are in binary mode. So some internal server errors. Thanks for your valuable suggestion. Regards valavan.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: perlquestion [id://570597]
Approved by Corion
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others musing on the Monastery: (4)
As of 2024-04-19 12:00 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found