Tag: Oracle

Oracle RAC SIG Web Seminar — RAC Connection Management

Oracle RAC SIG web cast presented by your humble servant. Don’t miss it today! You can register on the RAC SIG web-site. This is a longer than usual session (90 minutes) packed with details of connection failover, load balancing and implementation details.

Read More >

Log Buffer #113: A Carnival of the Vanities for DBAs

his is the 113th edition of Log Buffer, the weekly review of database blogs.

Read More >

How to Find Objects Creating nologging Changes

In an Oracle-l thread, this question was raised: how can you find objects creating nologging changes?

Read More >

Ubiquity and Tahiti: Together At Last!

You can load the command in your Ubiquity-enabled browser by visiting this page. Ubiquity users should already see the notice at the top of the page to subscribe to this command. You can view the source code at the end of this post.

Read More >

Pythian Penal Colony: Inmate #8777984426

Long story short — I’m moving to Australia. My flight from Ottawa leaves in three hours and I’m all packed and ready to go. Today we had a kiss-goodbye lunch at here at the Pythian office in Ottawa, and I was presented my new role Down Under. Hmm . . . to be honest, I expected it to be somewhat different….

Read More >

Log Buffer #112: A Carnival of the Vanities for DBAs

Welcome to the 112th edition of Log Buffer, the weekly review of database blogs.

Read More >

Oracle Silent Mode, Part 8: Add a Node to a 11.1 RAC Database

The process of adding a node to a 11.1 RAC is very similar to the 10.2 process described in Part 5 of this series. For this reason, this post will just focus on what has changed between the 2 versions. Make sure you’ve kept a copy of the voting disk and that you have a backup of the OCR. Check that the locations for all the components to be installed, i.e.: Inventory, Clusterware, ASM, database software, OCR, Voting Disks, and data files, are writable. Confirm that all the prerequisites are met for the node and for the whole cluster with the node to be added.

Read More >

Log Buffer #111: A Carnival of the Vanities for DBAs

Crisis has struck! This week’s Log Buffer editor had to beg off at the eleventh hour when his time vanished. It happens. But, in every crisis, an opportunity (well . . . maybe, maybe not). The opportunity — an open discussion of this week’s best database blog articles. Readers in control.

Read More >

Multi-Node to Single-Node Cloning in R12 and 11i

Anybody who has tried this multi-node to single-node cloning in 11i knows that it’s difficult and very error-prone. If we outline the Apps Tier cloning process, it looks like this (supposing we have a two-node instance with the DB and CM on one node, and Web and Forms on the other): This process is called merging appltops. It’s not as easy as it looks. Many times, the production environment might not have proper values in the fnd_nodes table, which makes adcfgclone.pl fail to properly recognize the appltops for merging. But in R12, life is made easy. Let me show you.

Read More >

Does Oracle’s Block Change Tracking File Shrink?

.Recently in IRC (#oracle on freenode, to be precise), a fresh face asked if the Block Change Tracking file ever shrinks. I began to do some reading. For some reason, actually reading the official tahiti docs was last on my list. A search of the 10gR2 docs quickly yielded this (from RMAN Incremental Backups)…

Read More >
Page 100 of 144« First Page...10...9899100101102...110...Last Page »