User Guide

Connecting to Oracle Databases 129
Example This is an example of a tnsnames.ora file:
scup=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=scup)
(PORT=1521))
(CONNECT_DATA=(SID=WG73)))
The following table describes the code:
When you complete all the steps in this section, you must 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.# Set during install
CFHOME=/opt/coldfusion
# Sybase Open Client directory
SYBASE=/work/sybclient11.1
# Oracle SQL *Net RDBMS directory
# See CFHOME/odbc/src/oracle for script to build library
ORACLE_HOME=/opt/oracle7
# Set library search path
#
# NOTE: Add your database client library directory to the FRONT of this
list
#
# 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
#==========================================================
Code Description
scup= Setting for the connect string name in the ColdFusion Administrator.
HOST=scup The IP address, as in HOST=205.185.22.33.
PORT=1521 Port that the tcp listener is assigned to. To identify it, look at the /etc/
services file of the UNIX computer where the Oracle server resides.
SID=WG73 Database identifier. See your Oracle administrator. These settings
are configured when you install the database.
install.book Page 129 Thursday, May 10, 2001 12:59 PM