Tools Give Oracle DBAs Better Protection, More Control

DataMirror's iReflect 1.5 is designed to help administrators build a near-zero-latency environment; Embarcadero's Job Scheduler 3.0 will give DBAs centralized control of cross-platform, enterprisewide job scheduling.

SAN FRANCISCO—The long-anticipated unveiling of Oracle Corp.s grid vision at OracleWorld here Monday was greeted by the rollout of new products to support Oracle databases, including extended data protection from DataMirrors iReflect high-availability software and extended cross-platform support for routine data-management tasks from Embarcadero Technologies Inc.s Job Scheduler.

DataMirrors iReflect 1.5 is designed to help the administrators of Oracle environments build a near-zero-latency environment that is close to invincible when it comes to downtime, according to officials. Enhancements are designed to deliver better availability and easier administration. The upgrade features extended support in DDL Refresh, the softwares support and object refresh function. DDL Refresh now can refresh an objects function before refreshing its data. Officials of the Toronto company said that being able to refresh, replicate and audit the data-definition language used to create and modify databases slashes the time and effort of common administrative tasks.

iReflect 1.5 also now offers master-to-master replication. This bidirectional data replication can be used to maintain data integrity while performing load sharing between servers.


Sync Check, yet another data-integrity capability, verifies data definition and the content of objects between source and target Oracle systems. It checks to make sure that data is available and consistent across such systems.

DataMirror did not release pricing or availability information.

For its part, Embarcadero, of San Francisco, rolled out Job Scheduler 3.0, which officials said will give DBAs centralized control of cross-platform, enterprisewide job scheduling. Job Scheduler 3.0 manages tasks in Embarcaderos DT/Studio, its software for data extraction, transaction and loading. It also integrates with DBArtisan, the companys database administration software; RapidSQL, a tool for writing, debugging and tuning databases; and Change Manager, a tool that captures, versions, compares and propagates database schemas as they change.

Job Schedulers Windows support now includes Solaris 2.7/2.8, AIX 5.1, HP-UX 11.00 and Red Hat Linux 7.1 or later, thanks to Embarcaderos having ported the server component to Java.

Also new are wizards to help out with database maintenance, as well as instant HTML reporting and documentation.

Job Scheduler 3.0 starts at $4,995 for one primary scheduling server, three agents and unlimited clients. The server and agents run on Windows and Unix, while the agents run on Windows NT/2000/2003/XP, HP-UX, IBM AIX, Sun Solaris and Red Hat Linux. Job Schedulers repository runs on Oracle and Sybase Inc. databases, as well as Microsoft Corp.s SQL Server.