Tools Give Oracle DBAs Better Protection, More Control

By Lisa Vaas  |  Posted 2003-09-09 Print this article Print

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.
Lisa Vaas is News Editor/Operations for and also serves as editor of the Database topic center. Since 1995, she has also been a Webcast news show anchorperson and a reporter covering the IT industry. She has focused on customer relationship management technology, IT salaries and careers, effects of the H1-B visa on the technology workforce, wireless technology, security, and, most recently, databases and the technologies that touch upon them. Her articles have appeared in eWEEK's print edition, on, and in the startup IT magazine PC Connection. Prior to becoming a journalist, Vaas experienced an array of eye-opening careers, including driving a cab in Boston, photographing cranky babies in shopping malls, selling cameras, typography and computer training. She stopped a hair short of finishing an M.A. in English at the University of Massachusetts in Boston. She earned a B.S. in Communications from Emerson College. She runs two open-mic reading series in Boston and currently keeps bees in her home in Mashpee, Mass.

Submit a Comment

Loading Comments...
Manage your Newsletters: Login   Register My Newsletters

Rocket Fuel