• Blog
  • Get Help Now!
  • Customer Portal

DBA Solutions

  • 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

January 28 by lbvanting

Oracle12c R1 RDBMS New Features: Upgrading to 12cR1 (pluggable) database

When upgrading to 12cR1 (pluggable and non-CDB) database we can choose between the following methods: 1) Upgrade the pre-12cR1 database to 12cR1 using DBUA or command-line/upgrade script (catctl.pl); for some releases a Direct Upgrade to 12cR1 is possible (10.2.0.5, 11.1.0.7 and >=11.2.0.2). Notice that in 12cR1 the upgrade can now run in … [Read more...]

Filed Under: Oracle

September 16 by lbvanting

Challenges with object invalidation and ORA-04045 in Active Data Guard STANDBY-database

At one of our customers Oracle Active Data Guard is being utilized for resource intensive BI queries during normal business hours. The setup is based on 11.2.0.3 EE on OEL 6.4 and everything is running just smooth. One issue has been identified - namely implicit invalidation of database objects, e.g. VIEWS and PL/SQL procedures. The invalidation … [Read more...]

Filed Under: Oracle

September 6 by kanthonisen

Oracle Listener crash, TNS-01153: Failed to process string, on Windows

A few days ago, I was working at a customer and made a few changes to the running listener's configuration. After having verified that my changes were working as expected, I asked the listener to save the configuration, but the result was quite unexpected. The listener crashed with TNS-1153. I had hit bug #8612344, which is affecting all 10.2 … [Read more...]

Filed Under: downtime, Infrastructure, Oracle, outage

August 28 by jjjensen

12cR1 (12.1.0.1.0) SQL*Plus session switches instance without reconnecting

This blog is about my first installation of Oracle 12c(12.1.0.1.0) on Windows8 and a possible bug I was facing. I have created a Service Request at Oracle Support and they are trying to reproduce with different constallations of Oracle Database software and Windows OS versions. SR 3-7725167161 : Installing 2nd database with connection to 1st … [Read more...]

Filed Under: Oracle

July 1 by lbvanting

Oracle12c R1 RDBMS New Features: Creating pluggable database within an existing container database

One of the important new features in Oracle12c RDBMS is the concept of container databases (CDB) containing several pluggable databases (PDB). This enables customers to easily consolidate databases and will be an important feature for a Cloud database (12c, c = Cloud). The overhead in system resource usage will be reduced as the PDBs will share … [Read more...]

Filed Under: Oracle

June 26 by kanthonisen

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...]

Filed Under: Oracle

June 26 by kanthonisen

Oracle RAT – an easy way of proving how performance will be after an upgrade/change

An often overlooked feature of Oracle is Real Application Testing, called RAT. RAT is by far the best way of testing the impact of changes to the database (not applications). This can be anything from upgrading to new hardware, upgrading the database release, adjusting database parameters, creating new optimizer statistics, adding indexes, … [Read more...]

Filed Under: Oracle, performance

March 15 by hharsfort

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...]

Filed Under: Oracle

May 26 by jwilton

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...]

Filed Under: Amazon Web Services, Jeremiah Wilton's Oradeblog, Oracle

December 9 by jwilton

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...]

Filed Under: hot backup, Jeremiah Wilton's Oradeblog, misconception, Oracle, proof

November 22 by jwilton

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...]

Filed Under: Jeremiah Wilton's Oradeblog, MySQL, Oracle, replication, SQL Server Tagged With: goldengate, streams

November 22 by snovotny

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...]

Filed Under: MySQL, Oracle, Remote DBA

October 21 by jwilton

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...]

Filed Under: Education, Jeremiah Wilton's Oradeblog, Oracle, Oracle Applications Tagged With: access, MOS, My Oracle Support

September 23 by jwilton

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...]

Filed Under: Amazon Web Services, Education, Jeremiah Wilton's Oradeblog, MySQL, Oracle, Oracle Applications Tagged With: amazon, ClosedWorld, cloud, openworld

September 21 by jwilton

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...]

Filed Under: Amazon Web Services, Jeremiah Wilton's Oradeblog, Oracle, Oracle Applications Tagged With: amazon, cloud, EC2, exalogic, openworld

  • 1
  • 2
  • 3
  • …
  • 5
  • Next Page »

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

Search

Blog Categories

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

Contact Blue Gecko

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

Networks

  • Email
  • Facebook
  • Twitter

© Blue Gecko Group