Wednesday, October 21, 2015

ASM: After disk comes online resync takes excessive amount of time

If you want to learn a bit more about ASM, especially if you have Exadata because it is affected as well, check out MOS article "ASM disk resync takes long time after disk online" from document ID 2061405.1 including the object GV$ASM_OPERATION which if you investigate on your system maybe you could develop alerts based on it!

Tuesday, October 20, 2015

Oracle EBS R12.2.5 has been released!

From Steven Chan's blog comes news about the release of EBS 12.2.5 which is a cumulative release update pack so can be applied to any R12.2 release without needing to go to any other releases.  There are multiple resources for you available on this article, but just as important are some questions asked and answered as well so make sure you click on the comments link!

Sunday, October 18, 2015

Weekend Learning: Oracle Payables - Information Center

I posted this last year in a batch of different Payables documents, but it bears reposting because it is such a great wealth of knowledge about Payables all in one spot so don't miss out on adding MOS document ID 1417598.2 to your bookmarks for the "Information Center: Oracle Payables" article!!

P.S.  I may have taken another unintended break and found out how it is easier to break a routine, than get into one, but I'm looking to start up another streak of nightly posting right NOW!  :}  Thanks for the continued viewership through this time of not so many posts, I hope to give you a lot of good information in the weeks to come so make sure you keep coming back here every day.

Sunday, October 4, 2015

Weekend Learning: Problem with granting privileges due to EBS R12.2 Edition Based-Redefinition

Even though the MOS article "Granting Privileges On An Object May Cause Invalidations" from note ID 1987947.1 sounds innocent enough, if you read the details it appears there is a potentially critical issue if you need to immediately change privileges on the current running version of code in R12.2!

Thursday, October 1, 2015

ALERT: DB corruption after 12c upgrade for compressed tables during recovery

Did you compress tables on 11g before going to 12c?  If so, you need to check out My Oracle Support article "ALERT Bug 21682261 Corruption during Recovery after upgrading to 12c for Compressed Tables" from document ID 2058461.1 because you can run into corrupted tables if you need to recover them!  This is the worst possible news for a database because it violates all of the ACID principles and if you get to the recovery stage you already have your data in question!