• Blog
  • Get Help Now!
  • Customer Portal

BlueGecko Denmark

  • Why you need us
    • Why act now
    • Why are we unique
  • What we do
    • Products Supported 24/7
      • MySQL
      • Postgres
      • SQL Server
      • Open Source
      • OS & Storage
  • How we do it
    • Consulting
    • System Monitoring
    • Security
  • Support
    • Blog
      • Oracle
      • MySQL
      • News & Events
      • Oracle Applications
      • Amazon Web Services
      • Jeremiah Wilton’s Oradeblog
      • OurSQL Community Podcast
      • Remote DBA
    • Team viewer
    • Whitepapers
  • About Us
    • Philosophy
    • The Blue Gecko Teams
    • Employment Opportunities
    • Partners
    • News
    • Press
  • Contact Us

June 4, 2013 by lbvanting

Unpleasent ORA-600 [kfdJoin3] caused by FCO/HDD replacement on ODA V1 with OAK 2.5.0

After several HDDs were replaced in a FCO (Field Change Operation) by Oracle Support on two ODAs, we ran into an unpleasent ORA-600 [kfdJoin3], which resulted in ASM disk groups not mounting, thereby causing the CRS stack to not startup properly. … [Read more...]

Filed Under: Oracle Database Appliance Tagged With: ORA-600, Oracle Database Appliance, Oracle DBA, Oracle Grid infrastructure 11.2.0.3

March 6, 2013 by theis

Oracle Database Appliance X3-2 Introduced by Oracle

Oracle introduced the new Database Appliance X3-2 March 5, 2013 and it brings some exciting specs and usability that has been greatly anticipated from the community. It further changes the scene from "RAC-in-a-box" to "Virtual Machines in-a-box".. … [Read more...]

Filed Under: Oracle Database Appliance Tagged With: core, database, licenses, oda, Oracle, Oracle DBA, ovm, x3-2

February 2, 2010 by cedwards

10 Things I Love About RMAN

I was looking at an old backup script the other day.  We acquired a new client who was stiil using shell scripts to execute hot tablespace backups and it got me thinking about how much I take RMAN for granted these days. Remember how meticulous we used to be about backup shell scripts? In the "old days" you had to manage everything in the scripts … [Read more...]

Filed Under: Oracle Tagged With: Oracle DBA, RMAN

February 2, 2010 by cedwards

Jeremiah Wilton published in the latest Oak Table press book!

"Expert Oracle Practices: Oracle Database Administration from the Oak Table" was just released and it features our own Jeremiah Wilton's thoughts on running Oracle on Amazon Elastic Cloud Compute (EC2). As an official Amazon Web Services partner, Blue Gecko has adopted EC2 as a primary database hosting platform, and Jeremiah is leading the charge. … [Read more...]

Filed Under: News & Events, Oracle Tagged With: Amazon Web Services, EC2, Oracle DBA

February 1, 2010 by cedwards

Oracle Correction to Export/Import

If you don't get alerts regularly from Oracle Support you may have missed this notice: If you conducted an import or export of an Oracle10g Release 2 or 11g Release 1 database prior to September 11, 2009, you should follow the instructions in My Oracle Support Knowledge Document 1055539.1 to verify the privileges in your database. This is because a … [Read more...]

Filed Under: Oracle Tagged With: export/import, Metalink, Oracle DBA

December 23, 2009 by cedwards

Metalink wget download script

Looking for a simpler way to download from the new Metalink?  Oracle has replaced the ftp site with http downloads using wget.  If you’re looking for a simple way to use wget without all of that cutting-and-pasting from the web site, you can use a simple script like this: #!/bin/bash # Program:  download.sh # Description:  Download Oracle … [Read more...]

Filed Under: Oracle, Oracle Applications Tagged With: Metalink, Oracle DBA

December 14, 2009 by cedwards

6 things to do after an Oracle Apps R12 install

OK, so there are a ton of things to do right after a fresh R12 install.  And before anyone says anything, I know each of my steps has multiple steps; I though 6 things made a simpler blog title, that's all. Nevertheless, below are the major tasks I think every Apps DBA should do right away before letting anyone log in.  I call these out for two … [Read more...]

Filed Under: Oracle, Oracle Applications Tagged With: Oracle Applications DBA, Oracle DBA, Oracle E-Business Suite, R12

December 9, 2009 by cedwards

Disable Flash for Oracle Metalink

If you want to improve certain aspects of Oracle's new Flash-based Metalink, you can do so by disabling Flash.  In Firefox or IE you can disable Flash discretely; in Safari, you need to disable all plugins. Once Flash is disabled, log out of and back in to your browser and go to http://metalink.oracle.com.  On the right, near the bottom, there … [Read more...]

Filed Under: Oracle, Oracle Applications Tagged With: Metalink, Oracle DBA

December 2, 2009 by cedwards

9 reasons why the new Metalink sucks

I know I’m not alone, and I know I’m not the first to express displeasure, but let me just say: AAAARRRRRRRGHHHH!!!!! I’m going to call the new Metalink “Metaflash.”  Seems like a good name for it.  It combines “meta” and “flash” which sounds really hip and technical, yet communicates nothing.  Kind of like shoving “i” or “e” in front of a … [Read more...]

Filed Under: Oracle, Oracle Applications Tagged With: customer service, Metalink, Oracle DBA, Oracle E-Business Suite

November 23, 2009 by cedwards

How to hire a really good Oracle DBA

Many of our customers have internal database administrators.  FACT:  Any remote DBA organization, and I mean ANY one of them, should be excited to work with a talented on-site person; in fact, part of good remote DBA support should be to help clients hire good DBAs when appropriate.  Without fail, collaboration between solid, focused technical … [Read more...]

Filed Under: Oracle, Oracle Applications, Remote DBA Tagged With: Oracle DBA

November 19, 2009 by jwilton

Converting Hexadecimal Oracle SCNs to Decimal

Oracle serializes transactions and manages concurrency and recovery using an ever-increasing number called a system change number, or SCN. Usually, we see these numbers expressed in decimal, in places like the v$ views and the alert log. Occasionally, however, Oracle's code expresses SCNs in hexadecimal. Unfortunately, you can't just perform a … [Read more...]

Filed Under: Oracle Tagged With: hex, hexadecimal, Oracle DBA, oracle internals, scn, system change number

September 22, 2009 by jwilton

ORA-00054: resource busy and acquire with NOWAIT specified

When trying to perform DDL such as truncate, drop or alter on Oracle objects that are in use by other users, you may encounter the error ORA-00054: resource busy and acquire with NOWAIT specified. This occurs even if you acquire an exclusive DML lock on the table using lock table. Locking a table does not guarantee the success of any subsequent DDL … [Read more...]

Filed Under: Oracle Tagged With: DDL, ddl_lock_timeout, ORA-00054, ORA-54, Oracle DBA, resource busy and acquire with NOWAIT specified

Categories

  • Amazon Web Services
  • Configuration Management
  • downtime
  • Drizzle
  • ebs
  • Education
  • elastic block store
  • elastic compute cloud
  • hosting
  • hot backup
  • ignorance
  • Infrastructure
  • IOUG
  • Jeremiah Wilton's Oradeblog
  • misconception
  • misconceptions
  • Monocle
  • MySQL
  • MySQL Council
  • News & Events
  • Oracle
  • Oracle Applications
  • Oracle Data Guard
  • Oracle Database
  • Oracle Database Appliance
  • Our People
  • OurSQL Community Podcast
  • outage
  • parallel
  • performance
  • podcast
  • proof
  • Remote DBA
  • replication
  • S3
  • Security
  • SQL Server
  • System monitoring
  • Uncategorized

Contact Blue Gecko

  • This field is for validation purposes and should be left unchanged.

Get Our Newsletter

  • This field is for validation purposes and should be left unchanged.

The Fine Print

  • Privacy Policy
  • Terms of Use
  • When is remote DBA the right solution
  • What are remote DBA services
  • Get Help

Blog Categories

  • 24/7 support
  • Blue Gecko 360° Services
  • Products Supported 24/7

Virtual runs

Contact Blue Gecko

Blue Gecko A/S
Slotsgade 21
DK – 4200 Slagelse
Denmark
Phone: (DK) +45 70 60 51 20

Networks

  • Email
  • Twitter

© Blue Gecko Group