Tag: Oracle

DBD::Oracle 1.46 and 1.47_00 Hit CPAN

After a little more than two weeks of soaking without any issues (yay!), version 1.45_00 of DBD::Oracle has been promoted to general use as v1.46.

And because some contributors have been very busy in the meantime, the next trial version, v1.47_00, is also already on its way to CPAN. This new version offers a few bug fixes (more details in the changelog excerpt below) as well as a rework of the platform-specific troubleshooting guides as POD documents. As usual, it’ll be left around for a minimum of two weeks before it gets promoted to v1.48. Happy upgrade!

Read More >

Minimal Downtime Option for Upgrading Oracle 9i/10G Databases to 11G

Often, a hardware is updated at the same time as a database version. In such cases, we migrate a database from an original location to a new server upgrading the database version and sometimes changing operational system. If this is your situation, you can use the upgrade process to minimize the system’s downtime to 1 hour, independently from the size of the database you migrate.

Read More >

Migrating Your 10G Database to ODA with Minimal Downtime

This blog post is a short summary of one of our migration strategies used to migrate Oracle 10g databases to ODA balancing the requirements of minimal downtime and efforts/costs of the project.

Read More >

Survey Results: Why Do You Use RMAN Catalog DB for Your Oracle DB Backups?

Backup is one of the most important topics for any Oracle DBA. It is our primary responsibility to make sure that at any point in time we can recover a database. Some time ago, I created a survey (my very first one): “Why do you use RMAN catalog DB for your Oracle DB backups?” In this blog post, I will share the survey’s results.

Read More >

SLOB on Steroids – Part 1

SLOB on steroids v0.1: Use it at your own risk. First of all, let me state that I’m falling in love with SLOB :).

Read More >

Interval Partitioning and Parallel Query Limit Access Paths

Interval partitioning – this ability to create partitions on the fly was introduced in 11g. When the feature came out, there were several nasty bugs. One such particular “limitation” has to do with parallel group by on the partition key. If you want to see just that part, skip towards the end, but I think reading the whole post will offer some insight on how Oracle Parallel Query works.

Read More >

Oracle Direct NFS: How to Start

First of all, if you are using NFS to store Oracle database data files, I strongly advise you to enable Oracle Direct NFS (DNFS) to access these files. However, if you are not using NFS, DNFS is probably not of interest to you, and you should stop reading here. But, if you want to set it up, let’s go!

Read More >

SQLcode = 1008 When Executing RMAN Commands in 11.2.0.2

A while ago, I was paged by a client having backup job failure. Doing my routine as usual, I started the investigation by looking at the job execution log. Connected to the box was a strange output. Here it is!

Read More >

Log Buffer #276, A Carnival of the Vanities for DBAs

Sharing knowledge not only is beneficial to others, but also enhances one’s own knowledge and broadens the spectrum. Blogging is all about sharing and this Log Buffer Edition brings together some great blog posts from around the database arena.

Read More >

How to Upgrade from 11.1.0.7 to 11.2.0.3 on Linux

Recently, I was upgrading a database from 11.1.0.7 to the current 11.2.0.3 version. The database was using ASM, but I should notify at the beginning that the configuration is for a Stand-Alone Server and not RAC. Basically, the first things to be done for this procedure are part of the following checklist…

Read More >
Page 32 of 141« First Page...10...3031323334...40...Last Page »