User Guide

100 Administering ColdFusion Server
You’ll need to modify the /opt/coldfusion/bin/start script to include the
ORACLE_HOME environment variable and add the
$ORACLE_HOME/lib directory to the
LD_LIBRARY_PATH. See “The /opt/coldfusion/bin/start Script” on page 100 for an
example.
• Make sure you can connect to the Oracle server from Solaris with sql*plus
before you try to connect from ColdFusion.
• Make sure you have the Oracle listener running
• Make sure you have a
tnsnames.ora file set up. For oracle 7.3 it is in the /var/
opt/oracle
directory.
Here is an example of a
tnsnames.ora file:
scup=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=scup)
(PORT=1521))
(CONNECT_DATA=(SID=WG73)))
The first line above, where it says “scup” is what the connect string name should be set
to in the ColdFusion Administrator.
The HOST=scup line could also say the ip address, as in HOST=205.185.22.33.
The PORT=1521 line is the port the tcp listener is assigned to. You can look at the /etc/
services file of the UNIX machine where the Oracle server resides to find out what it is.
The SID=WG73 is the identifier for the database. See your Oracle administrator. These
settings are set when the database is installed.
When you’ve completed all the steps in this section, you will need to stop and restart
ColdFusion services to reload the odbc.ini file.
The /opt/coldfusion/bin/start Script
#!/bin/sh
# start - setup environment and run ColdFusion servers
# This script should be run as root.
# Run as root, we are able to start the system registry deamon
# and then change to the ColdFusion userid to start the servers
# Set during install
CFHOME=/opt/coldfusion
CFUSER=nobody
# Sybase Open Client directory
SYBASE=/work/sybclient11.1;export SYBASE
# Oracle SQL *Net RDBMS directory
# See CFHOME/odbc/src/oracle for script to build library
ORACLE_HOME=/opt/oracle7;export ORACLE_HOME
# Set library search path
#
# NOTE: Add your database client library directory to the FRONT of this
list