Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery

Database connection error

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

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

The error which i am getting is listed below.

Database connection not made: ERROR OCIEnvNlsCreate (check ORACLE_HOME + and NLS settings etc.)Usage: host [-aCdlrTwv] [-c class] [-n] [-N nd +ots] [-t type] [-W time] [-R number] hostname [server] -a is equivalent to -v -t * -c specifies query class for non-IN data -C compares SOA records on authoritative nameservers -d is equivalent to -v -l lists all hosts in a domain, using AXFR -i Use the old IN6.INT form of IPv6 reverse lookup -N changes the number of dots allowed before root lookup is don +e -r disables recursive processing -R specifies number of retries for UDP packets -t specifies the query type -T enables TCP/IP mode -v enables verbose output -w specifies to wait forever for a reply -W specifies how long to wait for a rep

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.

So Monks please tell what will be the other possibilities of the errors. Thanks monks and regret for any mistakes.

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>


    _($_=" "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

    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.

    -- 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?

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

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (10)
As of 2021-01-27 17:12 GMT
Find Nodes?
    Voting Booth?