Connecting to Oracle Databases
131
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 generates a new libclntsh.so in CFHOME; move it to $CFHome/lib.
Note
Oracle 8 users 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 loads, resulting in an error.
Troubleshooting the Oracle 7.3.4 native driver (Windows)
When using the Oracle 7.3.4 native driver on Win32 systems, you might get the
following 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).
This problem might occur with the Oracle 7.3.4 native driver in several situations:
•
There is a duplicate copy of the OCIW32.DLL file (most common cause).
•
You cannot verify the connection.
•
You are running a
cfquery
.
To diagnose and fix the problem:
1
Make sure that SQL*Net 7.3.4.0 or later 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, then stop and start the
ColdFusion services.
•
If you do not have a copy in winnt\system32, search your hard drive for the
file. If you find a copy anywhere other than orant\bin or cfusion\bin, rename
the file, then restart ColdFusion services.
Configuring the Oracle 8 Client (Windows, UNIX)
This section includes the typical configuration steps that you need to use the Oracle
8 native database driver on UNIX or Windows NT. The following procedures were
written using version 8.0.4.0.0 of the Oracle 8 Client.
install.book Page 131 Thursday, May 10, 2001 12:59 PM
Summary of Contents for COLDFUSION 5 - INSTALING AND CONFIGURING...
Page 1: ...Macromedia Inc Installing and Configuring ColdFusion Server ColdFusion Server 5...
Page 14: ...xiv Welcome to ColdFusion Server...
Page 34: ...22 Chapter 1 Installing ColdFusion Server in Windows...
Page 66: ...54 Chapter 3 Installing ColdFusion Server in Linux...
Page 160: ...148 Appendix Preparing Your Server for ClusterCATS...
