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

[Jesse Hess]

Anyone,

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:

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

Here is the LSNRCTL status:

LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Solaris: Version 9.2.0.7.0 - Production
Start Date                15-MAY-2008 13:28:46
Uptime                    3 days 19 hr. 3 min. 9 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Parameter File   
/u01/app/oracle/products/9.2/network/admin/listener.ora
Listener Log File         /u01/app/oracle/products/9.2/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Services Summary...
Service "NETBOSS" has 1 instance(s).
  Instance "NBPRD", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

Services:

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
Services Summary...
Service "NETBOSS" has 1 instance(s).
  Instance "NBPRD", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:418 refused:0
         LOCAL SERVER
The command completed successfully

LISTENER.ORA
# LISTENER.ORA Configuration 
File:/u02/app/oracle/product/8.1.5/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
      )
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = NETBOSS)
      (ORACLE_HOME = /u01/app/oracle/products/9.2)
      (SID_NAME = NBPRD)
    )
  )

TNSNAMES.ORA
# TNSNAMES.ORA Configuration 
File:/u02/app/oracle/product/8.1.5/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

NETBOSS, NBPRD =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = NETBOSS)
    )
  )


Thanks for anyone's help!!

Jesse