When upgrading databases, my preferred method of late has been the autoupgrade tool. Autoupgrade gives DBAs the ability to upgrade databases in batches, automatically performing prechecks, postchecks, and custom database tasks during the upgrade process. Autoupgrade can be downloaded from MOS note #2485457.1, and tests shown here used the most current version at the time… Read More »
By default on an Oracle RAC installation, the listeners are configured to allow any database to register with them. There is no security out of the box to determine which databases may register. While this makes it easy to create new databases without worrying about listener registration, this can cause potential problems in a real environment.… 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 »
Oracle has released the much-anticipated version of cellsrv compatible with Oracle Database 12.1.0.1 (patch #16980054). Before thinking about upgrading, read MOS note #1571789.1 carefully. Unless you are planning to run database 12c on your Exadata, it would be advisable to continue down the 11.2 branch of the cellsrv software, which currently has a latest version… Read More »
Today, Oracle announced the Exadata X4-2 model. The X4 has some considerable improvements, namely: 12-core Intel Xeon e5-2697 CPUs, up from the 8-core models found in the X3-2 (hello, database licenses!) 256GB RAM per database server, upgradeable to 512GB 96GB RAM per storage server 800GB Sun Flash F80 cards – 3.2TB of storage per cell… Read More »
I heard a strange report from a client late last week – they weren’t getting any smart scans on their Exadata – a data warehouse, no less (and we checked to see if cell_offload_processing was set to true). Queries would run normally, but for some reason, the “cell physical IO interconnect bytes returned by smart… Read More »
One of the things that I’ve touched on before that tends to bother me – role separated grid infrastructure installations – gave me another reason to show my dislike a few weeks ago. While working on a system that was being upgraded from 11.2.0.2 to 11.2.0.3, we ran into a strange issue. After upgrading from… Read More »