Steve Callan

In addition to performing replication, GoldenGate can also be used to dump the contents of a table into a formatted file. Getting Oracle GoldenGate up and running in a simple configuration for unidirectional replication is fairly easy to accomplish. The simplicity of this, compared to what it takes in Oracle Streams, will make you appreciate […]

In this article, we’ll take a look at what takes place within Oracle GoldenGate in terms of how data gets from the source database to the target database. As the diagram below shows, there are four steps to perform in configuring GoldenGate. Typically, we replicate from one database to another, but in the case of […]

Steve Callan offers an overview of Oracle Streams and GoldenGate, comparing topology similarities and differences. Replication in any database system, not just Oracle, provides functionality that can fill many needs. One of the main benefits of replicating data in Oracle is reducing (and practically eliminating) the load on a production server. It’s not just DML […]

Oracle Corp. has acquired so many companies of late that it’s getting to be a job to keep up with things. GoldenGate is one of the products you’ll want to stay on top of. It’s still kind of under the radar, but it’s going to be big. Really big. Oracle (the corporation) has acquired so […]

A DBA is expected to know the basics of database administration, but to be successful, proficiency in more advanced database administration is required. Read on to learn the top 5 skill areas for the advanced DBA. Complacency. Although it’s nice to be comfortable in a job, isn’t what you do more interesting or exciting when […]

Learn how to install the Oracle Enterprise Manager Grid Control component on Windows 2003 Server. In prior articles, installing Oracle Enterprise Manager, database preparation and installation of the middleware (Oracle WebLogic Server) were addressed. In this article, the installation of Grid Control is covered. My Oracle Support (MOSC) note 1067438.1, Master Note for Grid Control […]

Two major prerequisites for installing Oracle Enterprise Manager (OEM) are having an existing, certified Oracle Database and an installation of Oracle WebLogic Server. Steve Callan shows you the steps performed for database preparation and for installation of Oracle WebLogic Server. Two major prerequisites for installing Oracle Enterprise Manager (OEM) are having an existing, certified Oracle […]

Learn what’s new in Oracle Enterprise Manager 11g, and how you will benefit by learning to use it. For home use and learning purposes, it’s very common to create a new Oracle database using the Database Configuration Assistant (DBCA). Along the way, one of the screens in Oracle Universal Installer presents you with an option […]

Setting up a connection to Oracle Database from SQL Server is fairly easy, but the opposite is not so true. Steve Callan walks you through a complete example of how to access SQL Server from Oracle Database using, named Database Gateways (Oracle’s new and improved method). Setting up a connection to Oracle Database from SQL […]

APEX is only getting better with time. If you need a web-based application or interface into your data, and want to empower developers and end-users (in terms of letting them do more with less overhead), APEX is the way to go. In a bit more than six years since its initial release as HTML DB, […]

The fourth edition of Oracle SQL by Example is an excellent resource for not only learning SQL but also for serving as a reference book for experienced users. This book covers the fundamentals as well as more advanced constructs in SQL. The fourth edition of Oracle SQL by Example is an excellent resource for not […]

If you consider “normal” recovery as anything having to do with RMAN (and what it replaced), then you’re actually limiting yourself in terms of what Oracle has to offer. Recovery – in the traditional sense – isn’t just recovery anymore, but more like recovery plus various flashback options. Right along with the skills a database […]