Exadata X5-2 and X4-8B racks are delivered with the “Enhanced” PDU metering units connected via the Cisco switch. Although the documentation says they should have static addresses, they don’t. You need to configure them manually using serial console connection, this is described in my earlier post here.
However if you forget to exit the serial console connection to the PDU and then try to login using SSH later you’ll get the following message:
login as: (more...)
A colleague of mine asked recently if we had any <evil term alert>best practices</evil term alert> for BI Publisher, the latest and greatest reporting tool we use within Enterprise Manager (the old tool, Information Publisher, is of course also still supported but this post is relevant to BI Publisher). As you would well know if you’ve been following my posts or heard me presenting at conferences, <evil term alert>best practices</evil term alert> is a term (more...)
Originally posted on TH TECHNOLOGY
I am honored to be a finalist in the Oracle Database Developer Choice Awards, in the Oracle Application Express category. I am most impressed with my fellow finalists – amazing devotion to helping the APEX community – and humbled to be included in such a crowd. Congratulations to all! Please…
It’s getting harder and harder to find time for writing. Anyway, this post stays from a long time in my draft so, I think is time to finish and post it. That one is the last one from the optimizer statistics series. For now, of course :) After describing the horror around the way that […]
Good new features announced, such as finding Flash Cache and Flash Log statistics on AWR, automatic ASM data redundancy check even shutting down a storage server by pressing the power button or through ILOM, preventing Flash Cache population in cell to cell rebalance, disabling SSH on Storage Servers and running CellCLI commands from Compute Nodes via new ExaCLI utility.
Find details in the MOS
So this started with a not so innocent tweet from Jeff Smith: @GuillaumeSL i’m betting @KentGraziano could answer your question right away — Jeff Smith (@thatjeffsmith) September 14, 2015 //platform.twitter.com/widgets.js Well, I sort of answered at least part of the question (eventually), but along the way the topic of using super types and sub types […]
ORDIM – The Oracle Multimedia component might be in INVALID state after the database upgrade to 12c. While I was testing the upgrade on test server, received below errors after the catctl.pl completion.
Serial Phase #:69 Files: 1 Use of uninitialized value $gsRTInclusion in concatenation (.) or string at catctl.pl line 1500.
Phases [0-73] End Time:[2015_08_08 08:06:45]
Grand Total Time: 4848s
*** WARNING: ERRORS FOUND DURING UPGRADE ***
Monitoring database servers for hardware failures in Exadata used to be an issue. We have CELLCLI for storage servers where we can make many administration tasks and set SMTP configuration to receive e-mail for hardware failures. For the DB servers we were able to configure SMTP Client on database server's ILOMs for email alerts but it was not a straightforward and easy configuration as we do in
One of the areas I’ve been exploring recently is the setup and use of the Middleware Diagnostics Advisor, more commonly known as MDA. MDA is an advisor in EM12c that analyzes the entire stack and provides diagnostic findings by identifying root causes for any problems it discovers. It correlates and analyzes the input and offers advice on how to resolve the problem. For example, it can help you identify that slow SQL statements or a (more...)
The goal of this blog is not to analyze the reasons behind working of Oracle optimize as every database implementation is unique. The main objective is to understand what happens when Oracle optimizer chooses Index Fast Full Scan over Unique Scan. Significantly more occurrences of this behavior was observed after upgrading to Oracle12c.
As per Oracle documentation, An index fast full scan reads the index blocks in unsorted order, as they exist on disk. This scan does not (more...)
Our team was tasked to unpartion all partition tables.
Import: Release 22.214.171.124.0 has PARTITION_OPTIONS=DEPARTITION but we are on Release 10.2.0.4.0
The first step was to find all schemas with partition tables.
select owner, table_name, partitioning_type, subpartitioning_type, partition_count, status
from dba_part_tables where owner not in ('SYS','SYSTEM')
and (owner,table_name) not in (
select owner,mview_name table_name
where owner not in ('SYS','SYSTEM')
order by 1,2
NOTE: SQL (more...)
The Oracle Database 12c Certified Master upgrade exam was recently released and those who wish to take this upgrade exam can do so on October 9th in Utrecht, The Netherlands. Hope to see you soon ;-)-Harald
In the August 2015 issue of the NoCOUG Journal, we asked Stéphane Faroult why it is so hard to get SQL performance right the first time. His answer implies that SQL itself and the way it is taught are the problems.(read more
Yup, moving on one more time. Hopefully for the last time. I’m leaving Sierra-Cedar Inc. for a position as Sr. Director with Oracle's HCM Center of Excellence team.
As an enterprise software guy, I see the evolution of SaaS and Cloud as the significant drivers of change in the field. I want to be involved, I want to contribute in a meaningful way, I want to learn more, and I want to be at the (more...)