DBA Solutions

by

Case: Oracle Dataguard switchover test

Recently, we migrated a large customers database environments to new databases on new hardware. The new setup consists of a cold failover Linux Cluster, which is located in the preferred production site, and two Dataguard(standby) databases in a remote DR site. Oracle 11gR2 Grid Infrastructure is used as basis for ASM diskgroups and for … [Read more...]

by

Conditional PL/SQL compilation

Conditional PL/SQL compilation. Note the $IF, $THEN, $ELSIF and $END directives. Create or replace procedure selective_directives is begin $IF DBMS_DB_VERSION.VER_LE_10_1 $THEN dbms_output.put_line('I'm on a Database 10 release 1'); $ELSEIF DBMS_DB_VERSION.VER_LE_10_2 $THEN dbms_output.put_line('I'm on a Database 10 release 2'); $ELSEIF … [Read more...]

by

Amazon RDS for Oracle: First Impressions

On Tuesday, Amazon announced availability of an Oracle version of their Relational Database Service (RDS). RDS is one of Amazon’s cloud services. You can think of it as ”database as a service.” Amazon provides a running database, storage, horsepower and a variety management tasks. And all you have to do is store you data in it. … [Read more...]

by

Oracle tablespace hot backup mode revisited

Here’s a revised version of an old popular article I wrote over ten years ago.  I wrote this when I was at Amazon.com, long before I came to work at remote DBA provider Blue Gecko. Enjoy! Oracle’s pre-RMAN hot backup mode is the subject of one of the most pervasive and persistent misconceptions about Oracle. During an Oracle tablespace … [Read more...]

by

YPDNGG: You Probably Don’t Need Golden Gate

Before launching into this, I must give due deference to Mogens Nørgaard’s landmark article, You Probably Don’t Need RAC (YPDNR), available here, but originally published Q3 2003 in IOUG Select Journal.  Mogens showed that you can be a friend of Oracle without always agreeing with everything they do. At Blue Gecko, many of our remote … [Read more...]

by

MySQL Editions and Support- what do I get with community?

The new licensing that was announced by Oracle earlier this month caused some FUD in the community that was addressed last week in an updated graphic comparing support and binary options and blog post from Oracle.  However, one of our customers sent me this earlier this week – We are now re-evaluating whether we want to renew our MySQL … [Read more...]

by

How I got access to My Oracle Support (MOS) for US$2.67

Oracle professionals know that the two main sites for information and support on running Oracle products are the Oracle Technology Network (OTN), and My Oracle Support (MOS). OTN is free for anyone, and provides discussion forums, white papers and free base-release software downloads under the Developer License. MOS requires a paid software … [Read more...]

by

Report from Oracle Openworld

Openworld 2010, despite the supposedly lagging economy, had record attendance again this year.  No doubt this was the result of Oracle acquiring something like fourteen companies since last year, including Sun in 2009.  The crowds were thick, divided about evenly between geeks in badly-fitting vendor t-shirts and slick sales-side hustlers with … [Read more...]

by

A Cloud over San Francisco for OpenWorld 2010

Oracle OpenWorld 2010 is just bursting with big cloud-related announcements this week.  As I prepare to present on the Amazon cloud at OOW2010 on Thursday (http://bit.ly/aSKdIQ), I thought I would highlight two of the biggest cloud-related announcements of the week. Exalogic We all know about Exadata, Oracle’s hardware-based storage-optimized … [Read more...]

Blog Categories

Contact Blue Gecko

Blue Gecko A/S
info@bluegecko.com
Phone: +45 70 60 52 10

Networks