Upgrade to Oracle Enterprise Manager Cloud Control 12c Release 3 (12.1.0.3)

Just a quick wrap up on EM12cR3 upgrade. I have to say that I was pleasantly surprised that everything went so smooth. I didn’t expected anything else, but with so how many products and components we have there I got few things in mind. The version I got was already (more...)

Improving data move on EXADATA V

Wrap-up

This is the last post in this series and I’ll not introduce anything new here, but rather just summarise the changes explained and talk a bit about the value the solution delivers to the organisation.

Let’s first review the situation we faced before implementing the changes.

The cost of writing (more...)

Demystifying Big Data for Oracle Professionals

Ever wonder about Big Data and what exactly it means, especially if you are already an Oracle Database professional? Or, do you get lost in the jargon warfare that spews out terms like Hadoop, Map/Reduce and HDFS? In this post I will attempt to explain these terms from the perspective (more...)

Improving data move on EXADATA IV

Reducing storage requirements

In the last post in this series I talked about how we sped up the move of data from operational to historical tables from around 16 hours down to just seconds. You find that post here.

The last area of concern was the amount of storage this (more...)

Improving data move on EXADATA III

Moving to history tables

In the last post I talked about how we made the speed of actually writing all those log-records much faster. It has to date been so fast that no a single report of a problem has been filed. you find that post here.

Once the data (more...)

Improving data move on EXADATA II

Writing log records

The last post in this series introduced the problem briefly. You find that post here.

In this post I’ll talk about the changes made to make that writing of log records fast enough. There were 50 million records that was written. Each of them pretty much in its (more...)

Faster data move on EXADATA I

Introduction

In my work among other things I tune and tweak solutions for EXADATA. Today I’ll write about a big improvement we achieved with a process that moves data from the operational tables to the ones where the history is stored.

This will not be a technical post. While I (more...)

NZOUG 2013 Conference: Agenda online – register while Earlybird Pricing still here!

The New Zealand Oracle Users Group - NZOUG Conference 2013 is open for registrations and Earlybird pricing is still available! The agenda is now available.

NZOUG 2013 is being held in Wellington at the iconic Te Papa Museum on the beautiful waterfront on the 18th and 19th of March, with an additional Workshop Day on the 20th March.

The conference will see a wealth of brilliant speakers from around the world, including Tom Kyte, Graham Wood, Andrew Holdsworth, John Schiff and Nadia Bendjedou and of course top speakers from Middle Earth (NZ) as well. Tom, Andrew and Graham will be (more...)

Learning to Love the ADR – Part 4: Incident Packaging Service

This post is the fourth (and final) in a short series about Oracle 11g ADR. These posts are based on the presentations I gave at the NoCOUG Summer Conference in August 2011 and at the RMOUG Training Days in February 2012.


IPS


Any DBA that has had to file a (more...)

Learning to Love the ADR – Part 3: Purging (Out With The Old)


This post is the third in a short series about Oracle 11g ADR. These posts are based on the presentations I gave at the NoCOUG Summer Conference in August 2011 and at the RMOUG Training Days in February 2012.

One of the benefits of the new ADR system is the (more...)

Learning to Love the ADR – Part 2: Diagnostic Files and ADRCI

This post is the second in a short series about Oracle 11g ADR. These posts are based on the presentations I gave at the NoCOUG Summer Conference in August 2011 and at the RMOUG Training Days in February 2012.

Wherever the DIAGNOSTIC_DEST is (remember that the default is the $ORACLE_BASE (more...)

Poor man’s data discovery for Oracle

I’m sure we all did something similar once or twice in our DBA lives. I had to create a simple script to perform regular expression based data discovery for Oracle. This script will be used as a check in our McAfee Database Vulnerability Manager. We do support data discovery directly in the tool but the [...]

Amazon announces Redshift, a data warehouse service!

Share

Today at Amazon AWS re:invent, Amazon announced a cloud service for data warehouse customers. It allows to easily analyse petabytes of data, interacts with known BI solutions, and it’s usually 10 times faster than traditional implementations… queries run really blazing fast! This service is certified by MicroStrategy and Jaspersoft.

Redshift runs (more...)

Cloud Databases : MongoDB

Share

For several years I’ve been using Oracle and other SQL relational databases. I’ve dedicated most of the time of my researching and developing on Oracle technology. There’s no question that Oracle leads on site installations and that the quality of the products and the ROI is one of the best. (more...)

ORA-00001: unique constraint (SYS.I_PLSCOPE_SIG_IDENTIFIER$) violated

Just a quick mention when you get the error bellow while trying to create a trigger for example:

 

CREATE OR REPLACE TRIGGER AGE_GROUP_TRG
BEFORE INSERT ON AGE_GROUP REFERENCING
NEW AS NEW
FOR EACH ROW
BEGIN
SELECT AGE_GROUP_SEQ.nextval INTO :NEW.AGE_GROUP_ID FROM dual;
END;

 

ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [kqlidchg1], [], [], [], [], [], [], [], [], [], [], []
ORA-00604: error occurred at recursive SQL level 1
ORA-00001: unique constraint (SYS.I_PLSCOPE_SIG_IDENTIFIER$) violated
00603. 00000 -  “ORACLE server session terminated by fatal error”
*Cause:    An ORACLE server session (more...)

Learning to Love the ADR – Part 1: Location, Location, Location!

This post is the first in a short series about Oracle 11g ADR. These posts are based on the presentations I gave at the NoCOUG Summer Conference in August 2011 and at the RMOUG Training Days in February 2012.

The Automatic Diagnostic Repository, or "ADR", is a location on disk (more...)

Follow Beyond Oracle on facebook

Share

Hi folks,

We can’t stop the social flow! Social networks are ruling the world. So as I had some free time lately, I decided do create a facebook fan page. For most of us with a facebook profile visited daily, it’s easier to follow syndications and we’ve got a better (more...)

Failed creating physical standby database

These days I’m implementing Oracle Dataguard for two Oracle databases 10.2 as part of disaster recovery project, one of them is around 1.7TB, not yet production. As part of the DG setup backups have to be available for both primary and standby. I preferred to use ASM and was able to negotiate with the storage admin to run storage replication for the FRA disks during the backup. This way I would have the same structure and files, locally at the disaster site immediately after the backup of the primary database is completed.

Unfortunately two weeks passed and by (more...)

Don’t be evil Google!

Share

In the last 10 weeks suddenly I lost 80% of my blog visits… thanks to google! In the last 6 months I found dozens of copycats of posts I wrote and those sites have a greater rank than my legit original blog!

For that, Thank you a lot google… you’re (more...)

When will RHEL6 be certified?

Red Hat Enterprise Linux has been out since November of 2010.  Here we are 16 months later and it's not certified for database use by Oracle yet. Yes, I know the database can be installed on RHEL6.  In fact, I have it running in my development environment right now with no issues related to the OS/DB integration.  Try to get Oracle Support to help you on those platforms for an issue unrelated to