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
Summary of Contents for COLDFUSION 4.5-ADMINISTRING COLDFUSION...
Page 1: ...Allaire Corporation Administering ColdFusion Server ColdFusion 4 5...
Page 10: ...x Administering ColdFusion Server...
Page 22: ...xxii AdministeringColdFusionServer...
Page 48: ...26 Administering ColdFusion Server...
Page 58: ...36 Administering ColdFusion Server...
Page 60: ...38 Administering ColdFusion Server Using ColdFusion in a Distributed Configuration 68...
Page 98: ...76 Administering ColdFusion Server...
Page 150: ...128 Administering ColdFusion Server...
Page 198: ...176 Administering ColdFusion Server...
Page 205: ...Chapter 6 Creating Scalable and Highly Available Web Sites 183 3 Click the DNS tab...
