Oracle Repository Installation

Home | Index/DBAmon Doc. | DBAmon Version/Change History | DBAmon Event/Error Doc. | What DBAmon Monitors | DBAmon Download | Free Oracle Tool: orastat | Request Support

Oracle Repository Installation Steps

  • Oracle Software Installation - Instance Creation

    Install an Oracle instance or use an existing instance. You do not need to create a seperate instance for DBAmon. It uses its own schema owner dbamon for ownership of all tables (which you will be creating later in this process), so it will not interfere with the data of an existing Oracle instance. The schema which will contain the DBAmon repository must be named dbamon. Note the ORACLE_SID and ORACLE_HOME values.

  • dbamonrc Settings

    Decide on an internal Oracle DB password for the userid "dbamon" which you will be creating later. We will call it "opensesame" in our example.


        Use_Oracle:      Y
        ORACLE_SID:      {Your ORACLE_SID Value}
        ORACLE_HOME:     {Your ORACLE_HOME Value}
        ORACLE_Password: opensesame
    parameter in your dbamonrc Configuration File (/opt/dbamon/adm/dbamonrc).

  • Perl DBD/DBI

    The DBAmon repository requires that the Perl DBD/DBI interface for Oracle be installed on your DBAmon Master server. There are actually two layers. The first, DBI, is not DB specific. Then DBD, or more specifically DBD for Oracle resides on top of DBI. To install DBI and/or DBD, you will probably need root access since you need to write to the Perl "lib". Ask you system administrator. To see if DBI for Oracle is installed on your server, run:

    /usr/local/bin/perl /opt/dbamon/bin/dbamon_perl_dbi_list.pl
    If DBD/DBI for Oracle is installed, you will see output that looks like:
    DBI test application $Revision: 10.4 $
    Using /home/border/dbi/DBI-1.14/blib
    Switch: DBI 1.14 by Tim Bunce, 1.14
    Available Drivers: ADO, ExampleP, Multiplex, Oracle, Proxy, mysql
    dbi:ExampleP:: testing 5 sets of 20 connections:
    Connecting... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
    Connecting... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
    Connecting... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
    Connecting... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
    Connecting... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
    Made 100 connections in  0 wallclock secs ( 0.07 usr +  0.01 sys =  0.08 CPU)
    Testing handle creation speed...
    5000 NullP statement handles cycled in 1.9 cpu+sys seconds (2645 per sec)
    /opt/dbamon/bin/dbamon_perl_dbi_list.pl done
    If you do not see "Oracle" as you see above, then you need to install DBI and DBD for Oracle. For information on how to install this software, see: CPAN Search Page and enter "Oracle DBD" as the search argument. When you get the results page, click on "DBD-Oracle-1**". This is the CPAN Oracle DBD Page. Then click the README file and follow the instructions. I found the installation of DBI and DBD to be, ummmm, challenging. Here is a tip: the scripts that you run as part of the install supply commands to run for the next step in their stdout output. Pay more heed to these messages than to the documentation that comes with the interface. Note that you will have to run the ANSI C Compiler to compile the interface. You may need to enlist your UX administrator. To see if you have the ANSI C compiler, run: cc -p /opt/dbamon. If you DO NOT have the ANSI C option, then you will see a message that looks like:
    $  cc -p /opt/dbamon
    (Bundled) cc: warning 480: The -p option is available only with the C/ANSI C product; ignored.

  • Create "dbamon" Oracle DB Userid

    You now need to create the dbamon user internal to the DB. The script mentioned below will create the DB user.

    1. Log onto the Master Server with a UX userid that can perform Oracle "connect internal".
    2. Set your environment to point to the Oracle DB that you spefied in the dbamonrc file (above).
    3. Your instance will need two tablespaces:
      • DBAMON_D (Used for storing DBAmon tables)
      • DBAMON_X (Used for storing DBAmon indices)
      Create them with 200MB each to start.
    4. Run /opt/dbamon/bin/dbamon_install_oracle.pl and watch the output to ensure that it runs error-free. You will be asked to specify the internal DB password that you picked above. This will be the password of the dbamon userid. This script will create the "dbamon" DB userid.

Click Back to return to the installation checklist.

This Document: http://dbamon.com/installation/db_oracle.shtml