Oracle Virtualization and Cloud Consulting
view counter

Database Feed

Oracle Database, Oracle 10g, Oracle 11g, Oracle XE, Oracle RAC, Oracle Instant Client, Oracle Data Guard and Oracle Exadata resources, news, and support articles.

Just Learned more - Rename an Oracle database name -)

It's nothing in this post. I just changed Oracle database name and did it something for Grid Infrastructure for standalone server also.

- Check

SQL> select name from v$database;

NAME

---------

ORCLOLD

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

Swapping the white shirt for a towel ?

For almost three years I have been a consultant. Dark suit, white shirt, tie. The official uniform of the 'You can trust us' brigade. [Aside, I was reading Superfreakonomics recently and learned that ties are often germ ridden so the soon we all stop wearing them, the better!]

CRS-1006: No more members to consider

I had an error which i would call weird cause i couldn’t understand it . I was asked to start 2-Node 10.2.0.5 RAC db and its services.

11GR2 – Grid Infrastructure Upgrade – 11.2.0.1 to 11.2.0.2

Please follow the following steps in order to upgrade 11.2.0.1 Grid Infrastructure to 11.2.0.2

Prerequisites:

You need to apply GIPS2 ( Patch 9655006 – 11.2.0.1.2 – Grid Infrastructure PSU 2) before you could upgrade it to 11.2.0.2. You also must have latest 11.2 OPatch  – 11.2.0.1.6.Latest OPatch for 11.2 – Patch 6880880.  . . . → Read More: 11GR2 – Grid Infrastructure Upgrade – 11.2.0.1 to 11.2.0.2

Theory

Here’s a quote that says it all:

Dr Joseph Lykken of Fermilab – in response to some (negative) results from the Large Hadron Collider that suggest the simplest form of SuperSymmetry is wrong:

“It [supersymmetry] is a beautiful idea. It explains dark matter, it explains the Higgs boson, it explains some aspects of cosmology; but that doesn’t mean it’s right.”

Mind you, Feynmann got there years ago:

RDBMS Online Patching

If you support Oracle RDBMS 11.2.0.2 and want to zero downtime applying
patches to databases then it is time to have a look at new possibility
of Online Patching delivered with 11.2.0.2 version and described here
RDBMS Online Patching Aka Hot Patching [ID 761111.1]

Setting Up Oracle Connection Manager

The Problem

It seems really simple. We have an Oracle database (on all nodes of a full rack Exadata, to be exact), which a lot of end-users connect to through apps designed in a rather adhoc and haphazard manner - on Excel spreadsheets, Access forms, TOAD reports and other assorted tools. We want to control the access from these machines and streamline them.

Reduce the number of commits

“Oftentimes, a database administrator (DBA) simply looks at the symptoms and immediately starts changing the system to fix those symptoms”
Op. Cit. Oracle Database Performance Tuning Guide 11g Release 2 (11.2)

Ok, let’s do this :-)

Deadlock

Here’s a deadlock graph the appeared on Oracle-L and OTN a couple of days ago.

Alter waiting on Select statement to complete

A few days ago, we faced an interesting problem on one of our customer’s slave mysqld servers.  An Alter for adding a new column was run on master server took 542 seconds where as it took few hours on the slave server to complete due to a SELECT blocking the Alter was not allowed to complete.

Here is the the select on the master server and it’s execution time from the binary logs.

view counter