ALL POSTS

Oracle 10g Transparent Encryption: Not So Encrypted

I had been asked by a client to try out Oracle 10g’s transparent encryption. I’ve created the wallet, set it up into the sqlnet.ora file, and opened it. I initialized the certificate, created a test table, and encrypted a column with it. Maybe you’ve done the same, and thought, “now my data is safe and encrypted”. Are you sure? Did you check? I did. And here’s what I found.

“ORA-1652: Unable To Extend Temp Segment” in RAC

Today I’ve seen a question on OTN forum about ORA-1652 in alert.log in RAC environment. I immediately recalled the bug and thought that I should mention that here. I quickToday I’ve seen a question on OTN forum about ORA-1652 in alert.log in RAC environment. I immediately recalled the bug and thought that I should mention that here. I quickly found Metalink Note 258941.1 and was surprised to see that there are actually two bugs on that and I only was aware of one so I definitely have to blog about it now.ly found Metalink Note 258941.1 and was surprised to see that there are actually two bugs on that and I only was aware of one so I definitely have to blog about it now.

Beta-Testing Oracle 11g

Let me tell you the story of the on-site beta testing of Oracle 11g, where success is measured by the number of times you caused Oracle to misbehave. And let me tell you, it’s very hard to do so, even in the beta. It takes a specific mindset and a bit of adjustment to get in the mood to make things not work.

What Happens When You Leave an Oracle Database in Backup Mode

So one fine evening, there was a scheduled maintenance, and one of the databases didn’t shutdown cleanly (thanks to mis-configured Windows services, if I recall correctly). Consequently, the database crashed and later didn’t come back up.When I looked at it in the morning, the error message rang a bell: “Datafile 1 needs media recovery” in combination with the request for very old archivelogs.The moral of the story: do not leave datafiles in backup mode. If you use hot backups outside of RMAN, such as snapshot technologies, take care to implement monitoring so that the database doesn’t stay in backup mode for much time.

Changing Hostnames in Oracle RAC

Sometimes there is a desperate need to change hostnames for one or all nodes of an Oracle RAC cluster. However, this operation is not officially supported. One way to do it is to remove a node from a cluster, change its hostname, and then add it back to the cluster as a new node. If you are brave enough, there is another way to do this. Find out here.

Christo Kutrovsky, Oracle Pinup!

Congratulations to Christo, Senior (and stylish!) DBA for The Pythian Group, on his spread in the July/August issue of Oracle Magazine, which you can download! Just jump straight to page 41 (not page 3), feast your eyes and hear what he has to say about Oracle Enterprise Manager! Here’s a sneak preview!

Oracle Coherence vs. Oracle RAC or Coherence + MySQL = MySQL RAC?

I came across Oracle Coherence today. Seems like this is another approach to clustering than Oracle RAC. Seems like this is a way to scale middle tiers that require shared data without actually using the central database for that. On the other hand, looks like a clustering framework with rules defined by developers as opposed to Oracle RAC that is designed and built to be a black box delivering database services. Has anyone (yeah, I’m asking developers reading the blog) played with it and knows how it feels?

MSDBF 07: Final Wrap Up

A few days ago, I did a short post about the start of the Miracle Scotland Database Forum 2007. I decided to wait until getting back home to complete a full-blown description of the event. I should warn you, this will be quite lengthy, so draw a deep breath.

Database sharding and the end of RAID?

A short post to draw your attention to this article by Kevin Burton titled “MySQL and the Death of Raid”. Although it’s written from the MySQL point of view, he does bring up some interesting points on the advantages of what he calls a “RAISe” or Redundant Array of Independent Servers” architecture (actually I coined the RAISe acronym just now :-) ) over the traditional RAID approach of hardening the availability and performance of your disk. Take a look and let me know what you think.

Page 219 of 256« First...102030...217218219220221...230240250...Last »