Configure Exadata storage cell to receive email notifications

As an Exadata DBA and sysadmin this is one of those important, most crucial configurations you can make for monitoring your storage cells.  Sure the Exadata plugin for EM12C provides alot of information and similar alerting, I have never put all my eggs in one basket.  Setting up SMTP alerting on the storage cells is […]

2013 Great Lakes Oracle Conference

Join the Northeast Ohio Oracle Users Group and the Ohio Oracle Users Group at their newly formed Great Lakes Oracle Conference (GLOC). The event has been re–branded as the Great Lakes Oracle Conference to attract participants from all over the Great Lakes region, not just Ohio. We anticipate this to be the largest Oracle user conference in […]

NEOOUG November meeting 2012

Come on out and join us for lunch and a meeting. Are next meeting is 1 week month away. Meeting details below. What: NEOOUG November meeting When: Friday November 16, 2012 – 12:00pm – 4:00pm Where: Oracle Corporation Cleveland Office – Independence, Ohio 44131 Lunch: Available from 12:00pm to 12:45pm For this meeting we have […]

resync catalog from db_unique_name all — fails ***UPDATE

Previously I talked about ‘RESYNC CATALOG FROM DB_UNIQUE_NAME ALL;’ (LINK) and the issues we have faced.  As promised here is some followup. Oracle had asked us to perform a few steps. The first was to test 2 new net service names in the tnsnames.ora file on both the primary and the standby database.  Here is […]

Oracle DBA Interview Questions

Before I started some job searching….around 10 months ago I compiled a list of interview questions for preparation.  Yes I am a seasoned DBA, but not having gone through an interview in 5 years I decided I needed a refresher.  Some questions I came up with, others I found on Google.  I can honestly say […]

First off, my apologies for being away

I apologize for not updating the blog sooner than this.  I have had a very very busy few months.  Here is a few things that I have been working hard on: Space reclamation 4 projects going live Exadata storage expansion project due by 12/31/2011 New set of Exadata clusters for a project Decommissioning databases But […]

SEV 1 SR – 8 Node Exadata Database Hang – Update 1

Because of the potential bug that we hit (8738555) which is resolved with patchset 11.2.0.2, Oracle has been reviewing some parallel query trace files. Here is some example output of the trace files: *** 2011-10-09 19:44:55.218*** SESSION ID:(116.3167) 2011-10-09 19:44:55.218*** CLIENT ID:() 2011-10-09 19:44:55.218*** SERVICE NAME:(SYS$BACKGROUND) 2011-10-09 19:44:55.218*** MODULE NAME:() 2011-10-09 19:44:55.218*** ACTION NAME:() 2011-10-09 […]

Creating public database link with/without username

Create a public database link without specifying a username CREATE PUBLIC DATABASE LINK LINK_TEST01 USING ‘(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=server1.instabc.com)(PORT=1521))(CONNECT_DATA= (SERVER=dedicated)(SERVICE_NAME=inttest)))’; Create a public database link while specifying a username to use CREATE PUBLIC DATABASE LINK LINK_TEST01 CONNECT TO TESTUSER IDENTIFIED BY TESTPASS USING ‘(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=server1.instabc.com)(PORT=1521))(CONNECT_DATA= (SERVER=dedicated)(SERVICE_NAME=inttest)))’; When creating a database link you have the option of using a username […]

Quick PL/SQL to add many privileges to a ROLE or a USER

I was asked to add many hundreds of grants to a user where they only needed the READ privileges against tables. To make things easier I wrote a quick procedure to handle it for all schemas that the user needed to have READ access to. First I needed to create a role CREATE ROLE NEW_ROLE; […]