install

用perl写的Oracle管理工具

   Requirements:
   =============

   Perl v5.004 or greater. 
   DBI v1.12 or greater.
   DBD::Oracle v1.02 or greater.
   A web server that allows CGI.

   All of these are available at http://www.cpan.org or
   from links at http://www.oracletool.com/requirements.html

   There are several additional modules that you may wish
   to install to enable cookie encryption. These modules are
   optional, but recommended. Oracletool will work with or 
   without them. Please refer to the SECURITY file for more
   information. The minimum modules you can install and have
   some level of cookie encryption are.. 

   1) Digest-MD5
   2) Mime-Base64

   For maximum security, you should install...

   1) Digest-MD5
   2) Crypt-IDEA
   3) Crypt-CBC

   Installation:
   =============

   Instructions for those who already have DBI and DBD::Oracle
compiled into their perl. 

   1) Copy oracletool.pl to your CGI directory.
   2) Copy oracletool.sam to oracletool.ini, in the same
      directory as Oracletool.
   3) Set a few parameters at the top of the ini file.
   4) Set the path to perl correctly at the top of oracletool.pl
   5) Execute it like so... 

            http://yourhost/yourcgidir/oracletool.pl


   Now the long version...

   Installation of Oracletool is pretty straightforward, especially if you
have  installed stuff on your web server before. The main thing is that you
need to  have the DBI and DBD::Oracle modules compiled into your Perl
BEFORE you attempt to install Oracletool. These instructions will assume that
you have already done so. If you have not done that yet, download the 
required Perl modules and follow the instructions to install them. I have
compiled the DBI and DBD::Oracle modules many times and have had very few
problems. If you do encounter problems with DBI or the DBD::Oracle module,
there is a whole mailing list devoted to the subject, please use it. You can
subscribe to the DBI mailing list from the following URL. 

	http://www.symbolstone.org/technology/perl/DBI/

   OK, let's get to it! At this point, you should have a recent version of Perl
with the DBI and DBD::Oracle modules compiled in and tested. You also have
a functional web server in place, right? If not, back up and come back here
when you've got those things in place. Download Oracletool if you have not
already. 

Make sure you change this to the path to your perl binary with
DBI and DBD::Oracle compiled in!  AND make sure you do a chmod
755 oracletool.pl !!  

#!/usr/bin/perl 

OK, on to the less obvious stuff. 

Copy oracletool.sam to oracletool.ini, and put it in the same directory as
oracletool.pl. 

There are several variables in oracletool.ini that may need to be set. These are 
at the very top of the script and there is an explanation of each variable
above it.

You will see a section at the top of the oracletool.ini that looks like this... 

#============================================================================= 
# Begin user editable section. You may need to change some things in this
# section 
#============================================================================= 

        The first variable you may want to set is for your $ORACLE_HOME. 
        Set this in the line that looks like this.
 
 ORACLE_HOME = /home/oracle/app/oracle/product/8.0.5

      Next, set your $TNS_ADMIN variable, if you use one that is not default. 
      The default is $ORACLE_HOME/network/admin.
 
 TNS_ADMIN = /home/oracle/admin/sqlnet

        The rest of the variables in this section are self explanatory, and you 
        can mess with them if you choose to. The default colors work OK for
        me. 

        When you see the following... 
#======================================================================== 
# End user editable section. Do not edit below this point. 
#======================================================================== 

Then you're almost ready to go!.   

   Copy oracletool.pl to a directory that is defined to the web server as a    
cgi directory. For instance, under Redhat Linux, the default CGI directory
is /home/httpd/cgi-bin.
 
   Make sure that oracletool.pl is executable by the web server, meaning that, 
the web server may not run as the same userid that installed oracletool.pl.
Doing a chmod 755 oracletool.pl is safe. There is no info stored in the script
that people shouldn't see for any reason. When you are finished with all of the 
above, you should be able to execute oracletool.pl by putting something like the
following into your browser address window. Let's assume that your web server 
is named 'webserver' and that you copied oracletool.pl into the default CGI 
directory on your web server.

http://webserver/cgi-bin/oracletool.pl 

   And you should get back a window with entries from your tnsnames.ora file 
in a drop down list. 

   If you have problems, I can be reached at [e-mail]