Oracle Database Manager, a Free Management Tool

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!

Download your Free copy of SB-ODM here.

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 ALATO a welcome alternative. Additionally, ALATO 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 ALATO’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