Search

OakieTags

Who's online

There are currently 0 users and 32 guests online.

Recent comments

Oracle

I am now an ex-ACE Director

How apt that this should be my next blog post, following So long, and thanks for all the fish. I’ve been an Oracle ACE Director since 2009, and watched the program evolve in form considerably over that time. It’s always difficult to maintain high quality advocacy as a program grows – my time as part of the OakTable ‘junta’ … Continue reading "I am now an ex-ACE Director"

I am now an ex-ACE Director

How apt that this should be my next blog post, following So long, and thanks for all the fish. I’ve been an Oracle ACE Director since 2009, and watched the program evolve in form considerably over that time. It’s always difficult to maintain high quality advocacy as a program grows – my time as part of the OakTable ‘junta’ … Continue reading "I am now an ex-ACE Director"

What keeps database administrators awake at night and the search for the promised land

What keeps you and me awake at night? When I was a consultant for a Fortune 500 company in Southern California, we were getting beaten up to prove that databases were being backed up correctly and that disaster recovery would work. The truth of the matter was that we didn’t even have an accurate list of all the databases and databases would go down for days without anybody noticing which means that they were not even being monitored correctly. In fact, the yet unsolved NoCOUG murder mystery...(read more)

What Dr. Edgar Codd said about the relational model in 1981

Dr. Edgar Codd introduced the relational model in his 1970 paper “A Relational Model of Data for Large Shared Data Banks”—there was an earlier 1969 version but let’s not digress. The 1970 paper was reprinted in the 25th anniversary edition of the NoCOUG Journal. It’s terribly mathematical and consequently not very comprehensible to mere mortals. But his 1981 ACM Turing Award lecture is a study in contrast so I recommend it highly. You can read it in the 30th anniversary edition of the NoCOUG Journal.(read more)

NoCOUG 30th anniversary conference sponsored by Google Cloud Platform

NoCOUG is “the little user group that could!” As you might imagine, it requires a vast amount of work to organize a full-day users group conference and publish a printed journal every quarter. No sooner has a conference ended and a journal mailed than it is time to start work on the next conference and the next journal. But the awesome NoCOUG volunteers have pulled it off—quarter after quarter—for 30 long years. The upcoming NoCOUG conference sponsored by Google Cloud Platform on Thursday, November 17 at PayPal Town Hall in San Jose will be its 120th quarterly conference! The theme is “A Bright and Cloudy Future for All Your Databases.” The advantages of the cloud are inescapable so buckle up and ride the wave. After the conference, join NoCOUG for its 30th anniversary celebration at Casino M8trix, Silicon Valley’s premier 24/7 entertainment destination. Can you hold a tune?

The most inventive thing I’ve done

The most inventive thing I’ve done is a software program that I wrote for my first employer almost 30 years ago. I was a fresh-faced COBOL programmer for a software company in Bombay (now Mumbai) which had won a turnkey contract to write hundreds of COBOL reports for the very first computerization effort of the Department of Banking Operations and Development (DBOD) of the Reserve Bank of India. The report layouts had been designed by systems analysts from the software company I worked for...(read more)

The curious case of the missing semctl call

This article is about the internals of how the Oracle database handles transactions. In this case the communication mechanism of foreground sessions to the logwriter process is examined. The tests in this article have been executed using the following versions:
– Oracle database 12.1.0.2.161018
– Oracle linux 7.2, kernel 4.1.12-61.1.14.el7uek.x86_64 (UEK4)

A technical security analysis of the snmp daemon on Exadata

Recently I was asked to analyse the security impact of the snmp daemon on a recent Exadata. This system was running Exadata image version 12.1.2.1.3. This blog article gives you an overview of a lot of the things that surround snmp and security.

First of all what packages are installed doing something with snmp? A list can be obtained the following way:

# rpm -qa | grep snmp
net-snmp-utils-5.5-54.0.1.el6_7.1.x86_64
net-snmp-libs-5.5-54.0.1.el6_7.1.x86_64
net-snmp-5.5-54.0.1.el6_7.1.x86_64
sas_snmp-14.02-0103.x86_64

Essentially the usual net-snmp packages and a package called ‘sas_snmp’.

A next important thing is how the firewall is configured. However, the default setting of the firewall on the compute nodes with exadata is the firewall turned off:

The Roots of Relational

A conversation with Chris Date about the term relational, and how that term
came to be used to describe database engines such as SQL Server and Oracle
Database.



Read the full post at www.gennick.com/database.

The Roots of Relational

Tenth in a series of posts in response to Tim Ford's #EntryLevel Challenge.

Special guest this month: Chris Date