User Guide

102 Administering ColdFusion Server
To build a version of libclntsh.so for Oracle 8.0.x:
1. From the shell, set ORACLE_HOME, CFHOME, and LD_LIBRARY_PATH as set in
the start script.
ORACLE_HOME should be set to the location of the Oracle client libraries.
CFHOME should be set to the location of your ColdFusion application server.
LD_LIBRARY_PATH needs to be set the same as in your start script.
For example:
CFHOME=/opt/coldfusion;export CFHOME
ORACLE_HOME=/opt/oracle8;export ORACLE_HOME
LD_LIBRARY_PATH=/lib:/usr/dt/lib:/usr/openwin/lib:$CFHOME/
lib:$ORACLE_HOME/lib;export LD_LIBRARY_PATH
2. From $CFHOME/odbc/src/oracle run the script./genclntsh8.
The script will generate an new
libclntsh.so in CFHOME and place it in $CFHome/
lib
.
Note Oracle 8 users will have the original libclntsh.so library in the
$ORACLE_HOME/lib directory. Therefore when creating the
LD_LIBRAY_PATH in the $CFHOME/bin/start script, the $CFHOME/lib
directory, containing the correct library, must be on the
LD_LIBRARY_PATH before $ORACLE_HOME/lib. Otherwise, the original
Oracle version will be loaded, resulting in an error.
Troubleshooting the Oracle 7.3 Native Driver (Windows)
When using the Oracle 7.3 Native Driver on Windows 95/98 or Windows NT you may
get this error:
Error Diagnostic Information
Oracle Error Code = 0
Internal error: The data access manager failed to initialize the Oracle
environment.
The error occurred while processing an element with a general identifier
of (CFQUERY), occupying document position (3:1) to (3:50).
You may experience this problem with the Oracle 7.3 Native Driver. This can happen in
several situations. Either you cannot verify the connection or you get this error when
running a CFQUERY. The most likely cause of this problem is a duplicate copy of the
OCIW32.DLL file.
To diagnose and fix the problem
1. Make sure that SQL*Net 7.3.4.0 or higher is installed on your server.
2. Make sure that your
winnt\system32 directory contains the file ociw32.dll.
• If you have a copy in
winnt\system32, rename it and then stop and start the
ColdFusion services.