Hi Chris,
I am having the EXACT same problem. The only difference I see is that I'm
using a W2k Oracle Server while you're using NT. What version of Oracle 8
are you using? I'm using 8.1.6.
I have documented my struggles in hopes that when I get this problem
resolved others can see my instructions.
Here's what I've got so far:
Take 1 fresh box, Install server class RedHat 6.1 doing a complete format
accept all defaults.
Install ColdFusion 4.5.1 Pro for Linux.
1) Install X11 Server (required for Oracle 8.1.6 setup)
Log in as root and then run the following commands:
mount /mnt/cdrom
cd /mnt/cdrom/RedHat/RPMS
rpm -Uvh --nodeps X11R6-contrib* XFree86-3.3* Xconfigurator* fvwm* xinitrc*
gtk+-* tcl-* tk-*
(XFree86-libs* is also required, but it should be installed already)
Setup X windows by running the following command:
Xconfigurator
It may tell you that it cannot locate the X server in which case you will
need to install the RPM for the server it says it cannot find.
For instance: rpm -Uvh XFree86-SVGA*
If you had to install the X server after running Xconfigurator the first
time, then run Xconfigurator again.
2) Install KDE
Install the following packages (in this order):
rpm -Uvh qt*
rpm -Uvh libungif-4.1.0-2.i386.rpm
rpm -Uvh kdesupport*
rpm -Uvh kdelibs*
rpm -Uvh switchdesk-kde*
rpm -Uvh --nodeps kdebase-1.1.2-14.i386.rpm
3) Perpare for Oracle Client Installation
Add user "oracle" with primary group "oinstall" secondary group "dba".
Log in as the oracle user and add this to the oracle user's .bash_profile:
### Variables Required for Oracle client ###
ORACLE_BASE=/home/oracle/u01/app/oracle;export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/8.1.6;export ORACLE_HOME
PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin;export PATH
umask 022
### ###
Then logout as the root user and log back in as "oracle".
Now logged in as oracle create the directory for installation:
mkdir /home/oracle/u01
4) Install Oracle Client
Logged in as "oracle" start X windows:
startx
Go to the cdrom drive and click on runInstaller, this will begin the oracle
setup wizard.
The wizard may ask you to enter a Unix Group Name, enter "dba".
Choose to install the Oracle Client 8.1.6.0.0 and then on the next screen
choose the "Programmer" client installation
5) Test the installation
After the installation finishes goahead and exit X windows and return to the
console.
At the console type:
sqlplus [EMAIL PROTECTED]
This will log you into your database. Do a couple queries just to test that
the connection is working.
6) Prep Coldfusion for Oracle
Edit the /opt/coldfusion/bin/start script with a text editor with a command
like:
vi /opt/coldfusion/bin/start
Uncomment the ORACLE_HOME line. In our example the line should look like
this:
ORACLE_HOME=/home/oracle/u01/app/oracle/product/8.1.6
Also change the LD_LIBRARY_PATH to look like this:
LD_LIBRARY_PATH=$CFHOME/lib;$ORACLE_HOME/lib
7) Setup a DSN
In the coldfusion administrator add a datasource using the "MERANT Oracle 8
Driver" be sure to secify the username and password in the DSN for testing
purposes.
Setup a .cfm page to test the oracle datasource with the following contents:
<cfquery
name="test_oracle"
datasource="test"
username="yourusername"
password="yourpassword">
select table_name from all_tables
</cfquery>
<table>
<cfoutput query="test_oracle">
<tr><td>#test_oracle.table_name#</td></tr>
</cfoutput>
</table>
8) Wonder "what they hey is going on here!"
Unfortunatly you will now get this error when you load your test page:
ODBC Error Code = IM003 (Specified driver could not be loaded)
I need help here... this is where I dead end.... does anyone know how to
get past this?
Thanks,
Camden
----- Original Message -----
From: "Chris Jensen" <[EMAIL PROTECTED]>
To: "CF-Linux" <[EMAIL PROTECTED]>
Sent: Tuesday, February 13, 2001 10:37 PM
Subject: Using MERANT oracle 8 client under linux
> Hi,
> I'm having difficulty configuring cold fusion to connect to an oracle
> database under linux.
> Cold Fusion is successfully running and serving pages, the oracle
> database is serving windows clients including a cold fusion server under
> NT, and the oracle client is setup on the linux CF server and I can
> tnsping and sqlplus into the server.
> I've setup ORACLE_HOME, LD_LIBRARY_PATH and VAR_LIST in
> $CFHOME/bin/start according to the cold fusion docs.
> However, when i try to setup the datasource in cold fusion adminstrator,
> it is unable to verify the datasource.
> What have i not done/done wrong?
> Is it necissary to setup cold fusion to su to the oracle user i
> installed the oracle client as or something?
>
> Chris Jensen
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
