[DCO#17849] Question about Oracle Server (fwd) #cr001862

[Kenneth Cheong]

Hey,

That's the answer I get from eecs. Do you know how can I do it? Can you
tell me step by step what I should do to set up the oracle server in eecs?
Can we meet sometimes to talk about it?

thanks,
Kenneth

---------- Forwarded message ----------
Date: Tue, 6 Apr 1999 11:37:44 -0400 (EDT)
From: Dennis J. Holt <dh...@eecs.umich.edu>
To: kch...@eecs.umich.edu
Cc: he...@eecs.umich.edu
Subject: Re: [DCO#17849] Question about Oracle Server

Kenneth,
To my knowledge the EECS web server (a Linux box running Apache) does
not have the neccessary drivers to connect to a remote Oracle database
nor are there any plans to do so soon. Here's an example of just one
element of accessing a remote Oracle dB:

"If you want to use your Linux system as a database client that connects
to an Oracle server on another platform, you will need to use the Net8
protocol. Your client program will need to be linked with the Oracle client
libraries. Besides, you will need to set up the file tnsnames.ora in the
$ORACLE_HOME/network/admin directory with information such as network
parameters, target database id, etc."

The above comes directly from Oracle. I suggest you talk with your instructor
and perhaps the folks at CAEN who maintain the Oracle server over there. Perhaps
they have another machine set up to run CGI applications? Good luck. -dkj

[Woody Kellum]

Kenneth - I'm sorry. I thought the EECS web server was a Sun running
Solaris. A cgi script running on a Linux system can't use the Sun Oracle
drivers you copied to /n/trip/z. The Oracle binraies you copied do work,
but it must be run on the Sun/Solaris platform. One option now is to
copy down the Linux Oracle binaries from the Oracle web site, and install
them where the Apache server can run them. I'm assuming now that Linux is
running on Intel PC hardware. Copy the tnsnames.ora &
sqlnet.ora files from /usr/caen/oracle-8.0/local into the network/admin
directory in the Linux Oracle home , and you should be able to connect
to the muscle server. The following environment variables must
be set (I assume that it is the same under Linux as the other Unix
platforms)
ORACLE_HOME
TWO_TASK

I do not have any experience with the Linux version of Oracle, so
you'd be on your own for the install of that. I can copy the tar/zip file
to your directory if you wish. It's 168 Megs
Check the web site http://technet.oracle.com for further info.
- Woody