I decided this week to be a little brave and upgrade one of the Enkitec Exadata racks to 12.2.0.1. I installed the 12.2.1.1.0 Exadata image a few weeks ago, and have been waiting for a chance to upgrade clusterware to 12.2. Thankfully, Oracle provides a very good note for this, but I did hit one large… Read More »
I was playing around with the Exadata X2-2 in the Enkitec lab this weekend, and hit an interesting issue when patching the storage servers. We were taking the system up to version 12.1.2.3.3 for testing purposes. I fired off the patchmgr script, and one of the storage servers failed when beginning the first phase of the patching… Read More »
In the wake of the great hospitality shown by the OTN crew at Open World, Tim Hall thought that getting the community together for a series of “OTN appreciation” blogs would be a good way to show our thanks back. Thinking about tools provided by Oracle that make my life easier, my mind went to dbnodeupdate.sh. This tool helps… Read More »
I ran in to a small issue while applying the July 2016 quarterly patch to a couple of Exadata racks last week. The systems were running GI 12.1.0.2, previously with the January 2016 PSU. The patches applied successfully, and we were beginning the process of running the post-patch scripts on the databases in the cluster. This… Read More »
While preparing for a virtualized Exalytics upgrade, I was testing the various connection methods that would be needed. Last on the list was to validate that I could connect to the ILOM’s web interface, launch the java console, and mount an ISO file from my laptop to the machine. This is necessary because the… Read More »
I had the pleasure of rebuilding an Exadata rack for a customer a while back, and it provided a pretty good refresher in backup and recovery for me. As DBAs, we back up databases all the time, but the restores are performed much less frequently. In the case of this rack, there were several databases… Read More »
If you’ve run an exachk report, y0u may have seen the following message with regard to your databases: Status Type Message Status On Details FAIL Database Check Database parameter CLUSTER_INTERCONNECTS is NOT set to the recommended value db01:dbm011, db02:dbm012 View This check is commonly seen when a database is created on Exadata without using the custom… Read More »
There has recently been a lot of news about the exploit revealed in the bash shell. While the fix is very quick to implement, there are a couple of tricks that are required to install this update on an Exadata environment. According to Oracle support note #1405320.1, Exadata storage server versions 11.2.3.x.x and 12.1.1.x.x are susceptible… Read More »
I noticed something for the first time tonight when I was playing around in the Enkitec lab – something that I have been doing wrong for a while. When working in the lab, I often rely on the crsctl command to shut down the entire cluster stack for me. It’s really easy to use “crsctl… Read More »
We had a client that was running into a strange issue on their Exadata where new connections coming in through the SCAN were failing. After doing some troubleshooting, it was discovered that it was related to one of the SCAN listeners not properly accepting requests from new sessions. The VIP and listener were running, and… Read More »