SkillBuilders Oracle Database Manager

Formerly ALATO

SkillBuilders Oracle Database Manager (SB-ODM) is a FREE lightweight Oracle database administration tool.

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 without EE and Packs!)

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!

SB-ODM is essential for:

  • ISV’s shipping Oracle Database under an “embedded license” where 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

 

In addition to standard administrative functions usually found in all administration tools, SB-ODM provides essential functionality that other tools simply do not have:

  • Schedule any OS Script with a GUI for Parameters
  • Scheduled Database Duplication (Clones)
  • APEX Application and Workspace Backups
  • Metric Threshold Alerts and Notifications, even with Standard Edition
  • Reporting and Management of ASM Storage
  • Scheduled APEX exports optionally includes exports (data pump) of the parsing schema(s).
  • View the execution plan of currently running SQL statements.
  • Scheduled execution of custom written PL/SQL blocks, existing stored procedures and custom written OS executables

 


Overview

SB-ODM is designed for 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:
    • Cloning (Database Duplications)
    • APEX Application and Workspace Backups
    • RMAN Backups
    • Data Pump Export / Import
    • All jobs are logged and email notification can be configured for job completion
  • Also support for:
    • 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
    • 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 email us to see how we can help you.


Videos

ALATO Webinar recorded Dec 22

How to Install SB-ODM

How to Clone with SB-ODM

How to Satisfy Clone Prerequisites for SB-ODM

How to Set Thresholds Alerts and Notifications in SB-ODM

Learn how to configure SB-ODM to recognize a new Automatic Storage Management (ASM and Grid Infrastructure) installation.

 


Technical Specifications

  • SB-ODM supports:
  • Operating Systems: Windows, Linux and any UNIX supporting a bash shell.
  • Oracle Editions ENTERPRISE, STANDARD and EXPRESS
  • Oracle Versions: 11g R2 and 12c
  • APEX Versions: V4 and V5
  • Linux Installers, see SBADMIN112-installReadMe-Linux.txt
  • Windows installers, see SBADMIN112-installReadMe-Windows.txt
  • Available in APEX theme 26 and Universal Theme (42) for APEX version 5.

We’ve made a copy of ALATO available for you to try – Now!

(you won’t be able to make changes to our database, but you will be able to see what ALATO has to offer).

ALATO is currently available for a free 30 day trial. ALATO on Oracle Express Edition is free.

Fill in the following info, and we’ll send you an email to get your download of SB-ODM.

 

Free Online Registration Required

The tutorial session you want to view requires your registering with us.

It’s fast and easy, and totally FREE.

And best of all, once you are registered, you’ll also have access to all the other 100’s of FREE Video Tutorials we offer!

 

×