SkillBuilders Welcome  |  Log in

SkillBuilders Oracle Database Manager - SB-ODM

Formerly ALATO - The APEX App for DBAs

SkillBuilders Oracle Database Manager (SB-ODM) is a FREE lightweight Oracle database administration tool. SB-ODM installs on and manages a single database.

SB-ODM is EASY To USE! It's chock-full of features for everyday administration tasks including rman backup, datapump database export, datapump database import, apex exports, storage management, Oracle ASM management, tablespace management, database monitoring, system alert and alert log notifications. (Yes, metrics, thresholds and notifications even with Standard Edition!)

SB-ODM is completely extensible - schedule ANY OS script you want to run. And, easily create an APEX GUI for parameters if needed.

SB-ODM is FREE. You can modify the code to meet your requirements!
Please share the news!

SB-ODM is essential for:

  • ISV's shipping Oracle Database under an "embedded license" when OEM is not available
  • 12c Standard Edition customers who need more features than available with "Oracle DB Express" (OEM DB Control is not available with 12c)
  • Enterprise Edition customers who don't require the complexity or overhead of Cloud Control.
  • Features Summary
  • Take a Test Drive
  • Videos
  • Free Download
  • Tech Specs
  • Comments

Overview

SB-ODM is designed for DBA's or any technical personnel charged with Oracle Database administration; we think you will find it amazingly simple to use for a variety of day-to-day administration and monitoring tasks.

If you are using 12c Standard Edition (2) and are dissatisfied with "Database Express" or with the complexity of OEM Grid or Cloud Control for basic tasks, we think you will find SB-ODM a welcome alternative. Additionally, SB-ODM provides features that other tools simply do not have such as scheduled cloning and APEX exports.

SB-ODM is built with Oracle Application Express.

Here's an overview of SB-ODM's main features:

  • Support for Scheduled:
    • Scheduled Database Duplication (Clones)
    • Scheduled APEX Application and Related Schema Backups
    • Scheduled RMAN Backups
    • Scheduled Data Pump Export / Import
    • All jobs are logged and email notification can be configured for job completion
    • Scheduled execution of custom written PL/SQL blocks, existing stored procedures and custom written OS executables
    • E-Mail notifications for threshold alerts and database errors, even with Standard Edition
    • Storage management, including ASM and Fast Recovery Area
    • User-customizable performance metrics
    • Displays for all sessions, waiting sessions, blocked sessions and active SQL
    • View the execution plan of currently running SQL statements.
    • Editable online help module featuring topic to page linking
    • Application roles for application maintenance, database administration and monitoring only
    • Comprehensive error logging


Dashboard

  • User customizable region selection.
  • Three user-selectable charts of over a hundred critical metrics.
  • Reports unacknowledged server alert log entries. Report entries can be controlled by user defined filters. Scanned every five minutes.
  • Reports unacknowledged system generated alerts and user defined threshold alerts.
  • Reports unacknowledged internal application errors.
  • Reports unacknowledged OS filesystem usage alerts.
  • Reports unacknowledged Fast Recovery Area usage alerts.
  • Lists all database instance parameters.
  • Lists all recent RMAN backups.
  • Shows all current user sessions.
  • Shows all currently waiting sessions.
  • Shows all currently blocked sessions.
  • Shows currently running SQL statements.
  • Updated every five seconds.

Alerts

  • Alerts based on configurable metric thresholds
  • Stateful alerts (eg, tablespace usage) and non-stateful (eg, elapsed time per call)
  • More than two hundred possible metrics
  • Lists all system and user defined alerts, acknowledged and unacknowledged
  • E-mail notifications to nominated users

Backups

  • Lists the RMAN configuration
  • Facilitates the setting of the most important RMAN parameters for disk and media manager backups.
  • Facilitates job scheduling of one or more RMAN disk and media manager backups.
  • Immediate, once and repeated schedules.
  • Lists available backup sets.
  • Comprehensive logging of all backup operations.

Database Duplication (Clone)

  • Facilitates job scheduling of one or more database duplication (Clone) operations.
  • Immediate, once and repeated schedules.
  • Duplication to local and remote server is supported.
  • Comprehensive logging of all database duplication operations.

Export - Import

  • Full, Tablespace, Schema and Table exports
  • Facilitates job scheduling of one or more export operations.
  • Immediate, once and repeated schedules.
  • Schema and Table imports including schema and tablespace remap and selectableTable Exists Action.
  • Comprehensive logging of all export and import operations.
  • Oracle directory creation to facilitate alternative dump file locations.

Database

  • Database user management including the setting of password, password expiry, account locking, default tablespaces, tablespace quotas, database roles, system privileges.
  • Tree and list view of all database schema objects.
  • Compilation of stored program type objects.
  • Table and Index reorganization.
  • Lists of all database metrics.
  • Current and historical (last two days) charts of all metrics.
  • Shows the server alert logs. Database, listener and ASM logs.
  • Lists all application scheduled jobs.
  • Shows the database scheduler log.

Storage

  • Creation and modification of Tablespaces and Datafiles.
  • Oracle Automatic Storage Management (ASM) administration.
  • View of ASM status and parameters.
  • Chart of ASM disk group usage.
  • ASM disk group creation and modification.
  • Chart and list of the Fast Recovery Area usage.

Application Express (APEX)

  • Facilitates job scheduling of one or more APEX export operations.
  • Immediate, once and repeated schedules.
  • Workspace and application exports are supported.
  • Comprehensive logging of all APEX export operations.

Maintenance

  • Flexible application configuration for operating system directory locations, E-Mail settings, ASM settings etc.
  • Application user management.
  • Application roles.
  • Extensible job template library.
  • All job logs of any category (Backup, Clone etc.)
  • SQL scripts repository with edit and upload capability.
  • Running of SQL scripts.
  • Comprehensive logging of all SQL script operations.
  • File repository with upload and write to operating system capability.
  • Manage alert log filters. Allows contains and does not contain filters.
  • View application error log. Acknowledged and unacknowledged.

Contact us at (888) 803-5607 (01-401-783-6172 outside U.S.) or to see how we can help you.