Blog Aggregator - Amardeep Sidhu

Even with all of the high-tech bells and whistles that 10G offers, the database is useless to us if we can’t administer it effectively. For years now, Oracle Enterprise Manager (OEM) has been the sissy GUI administrative tool of choice for Oracle databases. Oracle10G’s OEM is radically different than previous versions. In this blog, I’ll provide you with a high level overview of Oracle10G OEM and Giant Eagle’s OEM testing plan.

Let’s take a quick look at our first 10G data warehouse database. Well begin by reviewing some basic reports that describe the general database environment and database structures. As a gift from your friendly ex-Oracle instructor, I’ll also provide you with the scripts that generated them. I’ll finish the blog with an overview of our Oracle10G testing strategies.

In Part 2 of our series on upgrading databases to 10G, we review the different upgrade mechanisms available to us: Export/Import, manual upgrade, data copy and the Database Upgrade Assistant (DBUA). I’ll finish by providing you with some hints and tips that will help you choose the most appropriate upgrade method for your environment.

Oracle10G, like all previous releases, allows administrators to choose their conversion toolsets. Let’s take a couple of minutes to investigate, compare and contrast the primary Oracle10g upgrade mechanisms that are available. I’ll start our discussion by providing you with some upgrade hints and tips that will help you create a successful Oracle10G upgrade strategy.

Before we continue with our discussion on Oracle 10G, I’d like to take a quick literary detour into the world of 10G on Linux. One of our warehouse developers, Jason Heese, has been testing and benchmarking Oracle10G on Linux for some time now. Since I respect Jason’s opinion, I thought I’d reserve this blog for Jason’s thoughts on the Oracle10G/Linux combination.