Orac - Database Administration Tool

The open source Perl/Tk Database Administration tool for GNU world DBAs

 Purpose

 Orac is an open source database administration tool written in perl/Tk. It was written
  primarily by and for DBAs. However, it will also be very useful to developers and anyone else
  that wants to understand more about how (and how well) their database is working.

  Orac is muli-platform and multi-database aware. Currently, it is known to work on Solaris,
   Linux and Windows NT but it should work on any platform that supports perl 5.005 and Tk
   8.0015. Database support is currently included for Oracle, Sybase and Informix. The Orac
   team would very much like to support an open source database such as mSQL or PostGres and
   is acitvely soliciting for volunteers for this task.

1. To start to install orac you need to download four files from
www.kkitts.com/orac-dba and you must have oracle and it's listener
installed properly on your machine.  The files to download are:
    Tk800.015.tar.gz
    DBI-1.14.tar.gz
    DBD-oracle-1.06.tar.gz
    orac-1.2.0.tgz

2. Untar the files into a directory,  I used /home/oracle/orac.  The files are
dependant on each other so be sure to build and install them in the order shown
below.

    2.1 Extracting, building and installing the first two files is relatively
    simple.

        tar -xvzf Tk800.015.tar.gz
        cd tk800.015
        perl makefile.PL
        make
        make test
        make install

        tar -xvzf DBI-1.14.tar.gz
        cd DBI-1.14
        perl makefile.PL
        make
        make test
        make install

    2.2 To extract DBD-oracle-1.06.tar.gz is tricky and it is strongly
    recommended that you read the README file.  Following is what I did.

        2.2.1 Login as oracle and start the oracle database and listener
            su - oracle
            dbstart
            lstnctl start

        2.2.2 Login as root, change directories to the DBD-Oracle-1.06
        directory, and export the ORACLE_HOME environmental variable that
        is set up in user oracle's .bash_profile file.

            su --
            export $ORACLE_HOME=/drive2/ora8/app/oracle/product/8.1.6
            perl makefile.PL
            make
            make test
            su -oracle

        On some flavours of linux you may have to export the load library
        path before you can run "make test" successfully.

            LD_LIBRARY_PATH=$ORACLE_HOME/lib/

        2.2.3 Untar the file "orac-1.2.0.tgz".  In the resulting directory
        "orac-1.2.0" you should find the perl script "orac_dba.pl", this is
        file you will use to start orac.

            tar -xvzf  orac-1.2.0.tgz
            cd orac-1.2.0
            orac_dba.pl

        If orac doesn't start you may have to edit the perl script
        "orac_dba.pl" and change the very first line to point to the location
        of perl on your machine.

           #!/usr/bin/perl   to....    #!/usr/local/bin/perl
    #!/usr/bin/perl   to....    #!/usr/local/bin/perl
  ml>