Reaped: ERROR: 1804 '(UNKNOWN OCI STATUS 1804) OCIInitialize

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

Replies are listed 'Best First'.
Re: ERROR: 1804 '(UNKNOWN OCI STATUS 1804) OCIInitialize by mje (Curate) on May 13, 2010 at 08:37 UTC
This error is nearly always that ORACLE_HOME is not set properly and sometimes missing/incorrect NLS environment variables. You have: `ORACLE_HOME=/ora00/app/oracle/product/11.2.0/db_1` [download] are you absolutely sure that is correct? You don't seem to have any NLS_LANG settings either and your TZ looks wrong. When you create a database Oracle creates a shell script you can run to set your environment properly. It does not look like you've run it. Apart from that the versions of DBI and DBD::Oracle and Perl are very old now so I presume you are using them for a good reason.	[reply] [d/l]

Replies are listed 'Best First'.

This error is nearly always that ORACLE_HOME is not set properly and sometimes missing/incorrect NLS environment variables. You have:

ORACLE_HOME=/ora00/app/oracle/product/11.2.0/db_1
[download]

are you absolutely sure that is correct? You don't seem to have any NLS_LANG settings either and your TZ looks wrong.

When you create a database Oracle creates a shell script you can run to set your environment properly. It does not look like you've run it.

Apart from that the versions of DBI and DBD::Oracle and Perl are very old now so I presume you are using them for a good reason.