Re: dbquery.cgi: couldn't connect to database: (UNKNOWN OCI STATUS 1804) OCIInitialize



On Mon, May 19, 2008 at 7:16 AM, Jesse Hess <Jesse@xxxxxxxxxx> wrote:

I am connecting from one server to another server with an ORACLE database.
I have already checked the tnsnames and listener.ora files on the connecting
box (ORACLE) and they are posted further down in the thread. I have searched
for quite some time but haven't found anything helpful yet. I am getting the
following error:


In general, when something works from the command line and not from a web
server, the problem is environment. 99+% of the time (I'm tempted to say
99.9+%)





dbquery.cgi: couldn't connect to database: (UNKNOWN OCI STATUS 1804)
OCIInitialize. Check ORACLE_HOME
and NLS settings etc. at ./dbquery.cgi line 19.



And that message seems to be saying the same.


Remember, web servers, where you run .cgi files, sanitize the environment
thoroughly before running anything else. Look up PassEnv and SetEnv
directives (and mod_env).


Responses to the list - not to me.

--
Jonathan Leffler <jonathan.leffler@xxxxxxxxx> #include <disclaimer.h>
Guardian of DBD::Informix - v2008.0229 - http://dbi.perl.org
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."


Relevant Pages

  • ORACLE DBA -- Western Suburbs of Chicago
    ... OPERATIONAL ORACLE DBA ... DBA will work in the Oracle environment and help manage a complex ... with many constituencies to develop database solutions to business ... with a minimum of 3 years' of Oracle DBA experience. ...
    (comp.lang.python)
  • SUMMARY: Solaris 10 zone - user processes crashing randomly
    ... When talking to Oracle the ... I am in a Solaris 10 environment. ... or similar user processes crashed again. ... According to some core-files it ...
    (SunManagers)
  • Compiling Multiple versions of DBD::Oracle
    ... supporting a large Solaris Environment. ... I need to compile a set of DBI/DBD::Oracle modules such that they are able ... revision' oracle environment would be backward compatible, ... may not have a C compiler in my production environments, ...
    (perl.dbi.users)
  • Re: gc quiesce
    ... instance RAC environment hosted on Microsoft Windows 2003 Server (x64 ... Any idea what causes this random 'gc quiesce' event blocks? ... In RAC context, GC quiesce probably means to quiesce a resource DB. ... Oracle Corp. and work with them. ...
    (comp.databases.oracle.server)
  • Oracle Apps Dba, Financial, Dallas, Texas..Contract to hire.
    ... Procurement and stand alone Oracle RDBMS ... Oracle applications include G/L, A/P, ... upgrading the current applications environment and stand alone RDBMS to ... application client/server tiers, etc.). ...
    (comp.databases.oracle.marketplace)