Readers of an earlier post on this blog
will know about my latest forays into the world of Direct NFS. Part of that means stumbling over configuration hiccups or slamming into brick walls when you find new bugs.
To quickly re-set the table, my organization purchased the Oracle ZFS Storage Appliance (ZFSSA) 7420
. Oracle sold us on the Infiniband connectivity as a way to make a possible future transition to Exadata easier. However the pre-sales (more...)
When I sat down at my desk yesterday morning I was greeted with some disturbing email alerts notifying me that one of the NFS mounts on my standby database host was full. This was the NFS mount that held an image copy of my database that is updated daily from an incremental backup. The concept and an example can be found in the documentation
. With a 25Tb database, waiting to restore from backups is not (more...)
When adding ZFSSA targets to #EM12c
, be sure to uncheck "kiosk user" for the oracle_agent user in ZFSSA. Doc ID 1609846.1https://twitter.com/dtseiler/status/428210917155692544
We recently upgraded our EM12c 188.8.131.52 installation to 184.108.40.206. This service was configured to authenticate logins against our Active Directory server via LDAP. However, after upgrading we found that authentication stopped working, even after recreating the Active Directory Authenticator (as required). I could see the list of users from AD, but could not authenticate them in EM!
In this post I'm going to share what we did to diagnose (more...)
When I started out as an Oracle DBA on Oracle 7.3, nearly everyone would tell you to avoid doing a "shutdown abort" if at all possible since it leaves the database open to possible corruptions. In the years and versions since, that thinking has softened greatly, to the point (more...)
Yesterday I was creating a new Oracle 220.127.116.11 database from a copy of datafiles and archivelogs taken from our standby. I was sure to include archivelogs from just prior to well after the span of the datafile backup time. I had created a new controlfile, gotten everything (more...)
Bobby Curtis just posted a great post about adding a database to Oracle Restart
, aka srvctl. The post is a must-read, but I do have one thing to add. In Bobby's example, he leaves out the instance_name clause (noted by the -i parameter). This won't cause a problem for (more...)
Had an interesting little case come up today when helping a client re-write a view. This legacy application stored a date value as January 1, 1970 when they didn't have a date (basically using it as a de facto NULL). I did my best to lecture the client on why (more...)
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...)
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...)
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...)
Here's a quick picture of me during my RMOUG 2012 presentation, giving a tour of the Oracle 11g ADR:
This post is long overdue, as I was supposed to blog about my appearance at NoCOUG before I left (sorry, Vanessa!). However in my efforts to rehearse and adjust my presentation, blogging about it just fell to the wayside. However now that NoCOUG 2011 Summer Conference is in the (more...)
No, this isn't a re-post of my earlier blog about bug 1233183.1
. We've found a fun new bug that seems to be specific to our poor standalone ASM instances when upgrading from Oracle Grid Infrastructure 18.104.22.168 to 22.214.171.124.
The bug was first brought (more...)
We have a client that runs an application that, for whatever reasons, does NOT like daylight saving time. For that reason, the Oracle server is kept in Eastern Standard Time and does not change with the rest of the eastern United States when DST begins and ends every year. They (more...)
Well I didn't make the judges cut, but through Oracle Mix's Suggest-A-Session, you can still send me to OOW by voting for my session, which is unofficially titled, "Making Love to the ADR ... the Don Seiler Way
." The official title is much less romantic.
NOTE: This post originally appeared on the Pythian blog.
The past four days have found me very frustrated and at wits' end while testing upgrades of standalone Oracle Grid Infrastructure (ASM) 126.96.36.199 to 188.8.131.52 on RHEL/OEL 5 VMs. The upgrade would seem to go (more...)
Arup Nanda posted a great blog article about one of the most fundamental, yet misunderstood, behaviors of the Oracle database: the relationship of the COMMIT statement and buffer caches being flushed to disk
. I plan to re-read this every day for month. This clip seems apropos:
The article is titled (more...)