Cassandracle
the Oracle monitoring component of the ArsDigita
Server Architecture
Cassandracle is a Web-based monitor for an Oracle installation. The
goal is that, at a glance, a novice Oracle DBA ought to be able to
identify problems and find pointers to relevant reference materials.
Expert DBAs should find the software useful because it enables the
checking of remote Oracle servers without the need to install SQL*Net
and manage the attendant security risk.
How it works
Cassandracle is an AOLserver that
connects to Oracle with the DBA role. To manage the security risk, this
is done via a specially compiled version of the ArsDigita
Oracle driver. This version won't allow Tcl scripts to INSERT,
DELETE, UPDATE, or DECLARE BEGIN ... END (anonymous PL/SQL blocks that
might do all kinds of violence).
Installation
Make sure that you have the latest version, linked from
http://arsdigita.com/free-tools/cassandracle.html.
Make sure that you have our latest utilites.tcl file installed in your
shared Tcl directory (/home/nsadmin/modules/tcl). You can download this
from http://photo.net/wtr/thebook/utilities.txt.
As the DBA user under which Cassandracle will run, you need to define
the procedures in helper-procedures.sql.
tcollins@arsdigita.com