Thank You all {Simon Bosse <bosse@python.konbib.nl>,"K.Ravi"
<RAVKRISH.IN.ORACLE.COM.ofcmail@in.oracle.com>, "V. Denzer"
<denzer@hmi.de>, "V. Q. Hoang" <vqh@dwrock.dw.lucent.com>, Karl Vogel
<vogelke@c17mis.region2.wpafb.af.mil>, ddelija@srce.hr (Damir Delija)} for
your quick responses (included below);
I finally was able to connect to our oracle database.
From the responses below and more search on the net, I set the
"TNS_ADMIN" ENV variable within the perl cgi script. I also changed the
connect string to "@<database_name>" instead of
"@T:<dbserver>:<database_name>"
I was not able to connect with a user/pass string.
We were already using the DBI utility (oraperl within it). I did not have
to get any other software nor re-compile what I had.
original query;
We are moving from a Solaris 2.3/Oracle 7.1/sql*net v1 platform to a
Solaris 2.5.1/Oracle 7.3 platform/SQL*net V2.
Under Oracle 7.1 we used to access the oracle database from a Home Page by
way of a Perl cgi script (using oraperl). Oracle used to use the orasrv
service.
Oracle dropped orasrv from 7.3/sql*net v2 version. Now we cannot access
the database from the home page.
Has anyone successfully tried to access the oracle database from a home
page with a perl cgi script (oraperl)? Alternatives?
---------------------------------------------------------
--------------------replies below------------------------
Date: Fri, 20 Feb 1998 07:53:07 +0100 (MET)
From: Simon Bosse <bosse@python.konbib.nl>
we use oracle 7.3 on a DEC alpha with digital unix 4.0. To connect to the
database from web pages we use DBI-perl
http://www.hermetica.com/technologia/DBI/ the successor to oraperl You have
to use perl 5.004 or higher i think. There is a compatibility library in
DB-oracle ( place "use Oraperl;" in your scripts).
-----
Date: 20 Feb 98 13:16:22 +0530
From: "K.Ravi" <RAVKRISH.IN.ORACLE.COM.ofcmail@in.oracle.com>
Hi,
Don't take this as Oracle's official statemnet, but here is some info I got:
------------------------
As of Perl version 5.001 oraperl no longer really exists. It is replaced
by the loadable modules called DBD and DBI. You refer to the oraperl
functions by loading them at run time - as long as the perl binary can use
the loadable modules. Ensure you are not using an oraperl binary but
actually reference the perl binary utilizing either the dynamic or static
modules for Oraperl. Connections made in this way will use SQL*NET V2 on a
7.3XX DB.
-------------------------
I haven't used Oraperl myself, so I don't understand all the implications.
Let me know is u need more details.
-----
Date: Fri, 20 Feb 1998 09:29:47 +0100
From: "V. Denzer" <denzer@hmi.de>
Hello, a good morning.
We run Oracle 7.3.2 for some months now. With Sql*Net V2 you don't get the
orasrv since you don't need it anymore. You have to install the
TNS-Listener (tnslsnr) instead. You have to do this by configuring the
network configuration files and then starting
the listener with 'lsnrctl start'. For novice SQL*Net 2 users I would
recommend using 'netman' to enter your network and rdbms configuration and
then generating
the network administrative files. A Hint: You don't have to setup the name
server ORACLE*Names. This one is only needed if you want to set up clients
which don't know
about the DB Server.
-----------
Now to the sencond part of the question: oraperl
First of all: There is a newer database interface for perl.
It's called DBI::. This interface is the same for whatever
database you want to use. You only have to install the specific
database driver (I think: DBI::Oracle :-)).
Oh, BTW: You need perl 5 for that one.
Second: Using this DBI:: Interface there is an oraperl emulation
out there (in the net). This emulation has some smaller differences
in the function calls to the original. But you should be able to
use it without too much recoding.
We have build a small application on top of that interface here
at HMI. If you have further questions, please mail me.
-----
Date: Fri, 20 Feb 1998 07:39:54 -0700
From: "V. Q. Hoang" <vqh@dwrock.dw.lucent.com>
If your copy of oraperl was compiled with a oracle install that has sqlnet
v2, oraperl'll work with it just fine.
-----
Date: Fri, 20 Feb 1998 11:16:47 -0500 (EST)
From: Karl Vogel <vogelke@c17mis.region2.wpafb.af.mil>
A> Has anyone successfully tried to access the oracle database from a home
A> page with a perl cgi script (oraperl)? Alternatives?
In Perl-5, there's an Oracle module that should do what you want.
http://www.perl.org/
-----
From: Stephen Harris <sweh@mpn.com>
Date: Sat, 21 Feb 1998 21:43:08 +0000 (GMT)
Under SQL*Net version 2 you must have the listener set up correctly. Next,
if your home page is on the same machine, then you must have ORACLE_SID set
up correctly. If it's on a different machine, you must have tnsnames.ora
set correctly, set the TWO_TASK variable (then user/pass works OK).
Nowadays people use DBD and DBI instead of Oraperl (but there is an oraperl
that works). Check www.hermetica.com
Note: your existing oraperl would need recompiling to link in the v2
libraries!
Hmm, I've used the same v2 code from 7.1.6.2.0 through 8.0.3.0.0 without
any change ;-)
-----
From: ddelija@srce.hr (Damir Delija)
Subject: Re: orasrv/oraperl
> page with a perl cgi script (oraperl)? Alternatives?
Maybe TCL or netscape LIVEWIRE ?
This archive was generated by hypermail 2.1.2 : Fri Sep 28 2001 - 23:12:31 CDT