Tag: DBA Lounge

Pythian Goodies: Oracle Parallel Basics

In this new installment of Pythian Goodies Doug Burns discusses Parallel Basics. This video is a good introduction to using Oracle Parallel features and most importantly, what problems you may have with it.

Read More >

Bug in Oracle DST Patch Rollback

Last week, we discovered a bug related to the rollback of the Java DST patch for 9206 on Linux x86. If you’re in the unfortunate position of needing to roll this patch back, you won’t be able to. When you rollback, you need to restore both of these files, and then do a create or replace java system. Otherwise you risk hitting a dreaded ORA-03114 End of file on communication channel. Those of you familiar with DST patching will have seen this, but for those who haven’t, here are the scripts you need to check for a successful Java implementation:

Read More >

Miracle Scotland DBF 2007

Unfortunately, I’m too slow to blog about news and can never make it first. Today is no exception and Doug Burns has already posted about “one of the best Oracle Conferences of all times”: I can tell you – I’m so excited to see all those bright people presenting. It’s especially a pleasure to see that Doug (who recently joined my team here at Pythian) is presenting there.

Read More >

Exploiting SYSDBA Invoker Rights Using Trigger on Database

This is a follow up on my previous post about SYSDBA keeping invoker rights when calling PL/SQL procedure. Working on the previous test case a bit more I figured that the same anomaly is observed with triggers. So here is one way to get your PL/SQL code called by a SYSDBA. In this case you need to be able to create trigger on database, i. e. need privileges ADMINISTER DATABASE TRIGGER and CREATE TRIGGER.

Read More >

RMAN reports, or What Is the ETA of My Backup?

Over-the-Top Tales from the Trenches: Bringing order to the chaos of every day DBA life. Ever heard this during a recovery of a downed database? The poor thing has either a minor scratch, requires immediate attention, or is dead on arrival (DOA).

Read More >

MySQL Recipes: Connections per hostname using Pager

Over-the-Top Tales from the Trenches: Bringing order to the chaos of every day DBA life. My aim in any posting is to make your job as a DBA in Oracle, SQLserver and MySQL easier. Ever wondered how to get a quick count of the number of connections per hostname from MySQL? Welcome to the arcane (but extremely powerful) world of the MySQL command line pager.

Read More >

No data found -> success in dbms_scheduler

One of our clients found a bug with dbms_scheduler: it logs a job as successful when a ORA-01403 is thrown. Oracle was pointing us to unpublished bug #4552696 . They said a patch is available for 11 and offered to backport the patch.

Read More >

Sequences in Oracle 10g RAC

I got a call from a developer who had a table with a primary key populated by a sequence, a timestamp column with the current date and some other columns. He had a specific set of data that, when ordered by the primary key had out of order timestamps. He was puzzled how this could be. We changed the sequence to “ordered” and increased the cache to 1000. Now selecting on either node gets the next number as he expected. I warned him that there would be some performance implications due to cluster synchronization. Him being a responsive developer, asked me what the impact would be, so I tested it out.

Read More >

Oracle Upgrade to 10.2.0.3 – Watch for ORA-600 [22635]

When checking for new known issues with 10.2.0.3 patchset on Metalink I discovered that an upgrade problem was added – Metalink Note 401435.1. The issue affects all 64 platforms especially when database is upgraded from any previous 32 bit release.

Read More >

ORA-07202: sltln: invalid parameter to sltln

I’ve started to use DBCA more and I try to use its template management capabilities. It looks like templates is not the most robust feature of Database Configuration Assistant. Sometimes, there are issues when I want to reuse template. I reviewed the parameters and found that control_files is set to an empty string. Checked Metaclick and, indeed, this error is related to empty control_files parameter.

Read More >
Page 47 of 60« First Page...10...4546474849...60...Last Page »