- 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.
Code:
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:
/opt/dbamon/bin/dbamon_perl_dbi_list.pl
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
Disconnecting...
Connecting... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Disconnecting...
Connecting... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Disconnecting...
Connecting... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Disconnecting...
Connecting... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Disconnecting...
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.
- Log onto the Master Server with a UX userid that can perform Oracle "connect internal".
- Set your environment to point to the Oracle DB that you spefied
in the dbamonrc file (above).
- 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.
- 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.
|
