As you might already know, EM12c introduces the ability to create reports using BI Publisher. You should also be aware of the fact that the Information Publisher option (the ‘out of box’ reports that have been in Enterprise Manager since release 10) might not be there in a next major release of EM.
Oracle Learning Library just released an instruction video, showing the configuration of BI Publisher and the BIP Security setup.
Upgraded production to 184.108.40.206 a few nights ago. The primary is 3-node RAC and the standby is 2-node RAC. Notice that one of the threads was not transmitting redo to the standby. Saw this repeatedly in the alert log:
Error 1033 received logging on to the standby
Turns out this was a problem of my own making. In $ORACLE_HOME/dbs, I had the following:
Is this a good time to be a DBA? My biased opinion is that any time is a good time to be a DBA. The US Bureau of Labor Statistics released an outlook indicating that DBA positions are expected to increase 15% between 2012 and 2022.
Now comes this article that says about 50% of DBAs are expected to leave the market in the next 10 years.
Oracle will be releasing Oracle 12cR2 in the first half of 2016. See Metalink Note 742060.1 for the current release schedule. The Oracle 220.127.116.11 patchset is not on the list but there is a chance it will be out before 12cR2. We’ll have to wait and see I guess. Now for the burning question…do I … Continue reading »
I am working on upgrading all of our production databases to the Oracle 18.104.22.168 version. My company’s most important database serves a custom, in-house developed application so we have the luxury (and sometime the curse) of having complete control over the application source code. If I discover a version-specific issue with a their party application, I file a trouble ticket with the vendor to get the issue fixed. But for our own application, I often have to diagnose the problem and determine how to get the issue fixed.