We’ve had issues in the past patching the Oracle Homes on our Exadata nodes due to the fact that they were defined as part of a RAC cluster. We don’t use RAC, so we have made sure we don’t encounter such problems in the past by unlinking them as described in the documentation. However I …
OPatch 12.2.0.1.9 change in behaviour patching RAC nodes Read More »
We have noticed a change in the behavior of READ ANY TABLE auditing in 12.2. The following initial setup is performed as SYS: SQL> AUDIT 2 SELECT ANY TABLE; Audit succeeded. SQL> SQL> AUDIT 2 READ ANY TABLE; Audit succeeded. SQL> SQL> CREATE USER tst_table_owner IDENTIFIED BY tst_table_owner 2 ACCOUNT LOCK; User TST_TABLE_OWNER created. SQL> …
I thought it would be useful to have a consolidated list of issues we have run into, some of which I have already blogged about, some of which I haven’t. I will try to keep this page up-to-date moving forwards. Note we are not really using 12cR2 extensively, we have just upgraded OEM Repository and …
We have just noticed a difference in behavior in 12cR2 with regards to image copies being marked as obsolete after the backup is updated past the drop of a datafile. I won’t describe the feature itself, if necessary you can read up at oracle-base or the Oracle documentation. First review output from the testcase on …
12cR2 Incrementally Updated Backups and dropped datafiles Read More »
AWR Warehouse is tightly integrated with Enterprise Manager, both the database which acts as the repository plus any databases that will contribute to it need to be discovered as targets within OEM before they can be used. If you are already using OEM to manage your databases (and you should be), this means that configuration …
Migrating AWR Warehouse Repository to a new OEM Target Read More »
Unfortunately AWR Warehouse and Data Guard do not work together seamlessly, however by understanding some of the implementation details, and following some simple steps you can help to mitigate most problems that may be encountered. It is not possible to add an instance to AWRW when it is in standby mode, worse still if you …
Continuing the investigation, I wanted to check the effect of deleting one of the two data guard instances from AWRW; remember I have updated the mapping table such that both DGA and DGA both map to the same DBID. We can check from load metadata and AWR itself which snapshots have been loaded SQL> SELECT …
Update 2016-04-26: this is new bug 25954054 – WRH$_SGASTAT_U BECOMING UNUSABLE STATE IN UPGRADED DB. After upgrading our OMR and AWRW instances from 12.1 to 12.2, our monitoring revealed that index SYS.WRH$_SGASTAT_U was becoming unusable at regular intervals. The first couple of times, we just rebuilt it in the hope that the problem would just …
Index WRH$_SGASTAT_U has status UNUSABLE after upgrade to 12.2 Read More »
After a brief interlude I wanted to follow up on something I noticed on John Hallas’s blog. He mentioned that specifying a shared location for the extract metadata did not work, and was waiting on a fix for bug number 21826657. I checked that this bug should be fixed in db plugins version 13.2.2 and …
Note, in preparing next entry, I reviewed the results from previous entries and found that although extracts were being transferred successfully they had all failed to load; I should have noticed they had status 4 (IMPORT_FAILED), in the load metadata table. Reviewing dbms_scheduler_job_run_details of the load task revealed the following error: “move error: ORA-20105: Unable …