MACROMEDIA COLDFUSION 4.5-ADMINISTRING COLDFUSION..., Manual

Page: 123 / 350

Chapter 4: Managing Data Sources 101
#
# Example:
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$SYBASE/lib:/usr/dt/lib:/lib:/usr/
openwin/lib:$CFHOME/lib
# This is the list of variables that ColdFusion will see
# Add any special Database environment varaibles here
VAR_LIST="LD_LIBRARY_PATH CFHOME SYBASE ORACLE_HOME INFORMIXDIR
INFORMIXSERVER II_SYSTEM"
#==========================================================
# You should not need to touch anything below this point
#==========================================================
Troubleshooting
If ColdFusion is unable to establish a connection to the Oracle 7.3 driver, try the
following workarounds:
•
You may need to move the location of the ORACLE_HOME/lib to the end of the
LD_LIBRARY_PATH in the start script. Make sure that the $ORACLE_HOME
directory has a /lib directory below it. In that lib directory there should be a
libclntsh.so file.
•
Make sure that the listener port number is the the right one you are pointing to
in
tnsnames.ora file.
•
Check in
$ORACLE_HOME/lib
directory for the existence of the
libclntsh.so
file. If it does not exist you need to reinstall the oracle client software.
•
Oracle 7.1 users must build the Oracle client shared library (
libclntsh.so
for
Solaris) before the Oracle driver can be used. Run the genclntsh script found in
the
odbc/src/oracle
directory to build the library.
What to do if the connection test fails
If the basic information you entered in the Oracle Net8 Easy Config is correct, but the
connection test fails, then a visit to your local Oracle 8 DBA is probably necessary. The
first thing to do is check the basic connection information: hostname, SID, username,
and password. You can do this using the Net8 Easy Config utility or by directly
inspecting the
tnsnames.ora
file.
In addition, on UNIX, make sure you have the Oracle client library and ORACLE_HOME
defined in the
coldfusion/bin/start
script.
In some cases, connection problems can be solved by clearing your system of the
Oracle 8 Client and reinstalling it. Unfortunately, Oracle does not provide an
uninstaller for the Oracle 8 Client; you must uninstall manually.
Connecting to Oracle 8.0.x through ODBC (UNIX)
To use Oracle 8.0x databases with ColdFusion on UNIX, you need to build the
libclntsh.so
shared object file.