Thursday, October 1, 2015
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!
Wednesday, September 30, 2015
How much do you know about Primary Keys? Do you know why they exist? Ric Van Dyke is here to tell us and you might be surprised to know what he thinks Primary Keys should be too! Also, read the comments and see if you agree with some of the conversation going on there and maybe even pick up a few additional ideas too!
Tuesday, September 29, 2015
Tonight the MOS document "(DB32) Bug 20217875 - When using normal redundancy Oracle is unable to perform I/O to an ASM mirror copy when an Exadata Storage Server is offline" from note 2057731.1 seems straightforward BUT shows how complicated ASM and Storage Servers are with even more reasons to be constantly monitoring these components!
Monday, September 28, 2015
Hello everybody, I do live! I may have taken a week off post wedding and honeymoon, but I am back now and tonight I ease into things with a rather simple issue from My Oracle Support article "GC Overhead Limit Exceeded Message In SQL Developer When Running A Query" via note ID 1634930.1 which has a deceiving title because this happens when exporting instead, but is still worth a read anyways.
Saturday, September 19, 2015
Do not miss out on the MOS document "Setup, Monitor, And Tune Parallelism In The Database" this weekend via document ID 1549214.1 to get the scoop on what default parallelism is, parameter settings which influence this, best practices, AND a health check script which can help you determine if there is anything off in your system!
Friday, September 18, 2015
Tonight the My Oracle Support article "Reviewing the Workflow Activity for an In Process or Pre-Approved Purchasing Document [Video]" from note ID 1231023.1 presents different ways to get the data from behind the scenes for workflow by either an Analyzer, a Diagnostic, scripts, or through the application!
Thursday, September 17, 2015
Did you know that the latest patch for 18.104.22.168 has known issues already? While article "Oracle Quarterly Database Patch 22.214.171.124.12 Known Issues" found on My Oracle Support by document ID 2052715.1 has a very small issue, it makes me curious going forward about how we find these known issues bug reports in the future for other DB patches as well!
Wednesday, September 16, 2015
Tonight with this MOS article "Autoinvoice Import Errors with The web server returned an error" from document ID 2053754.1 it is important to notice that this affects the Autoinvoice Import (RAXTRX) AND Master (RAXMTR) programs with an unknown cause so it could happen at any time in your environment at a time you could not afford to bounce Apache services!
Tuesday, September 15, 2015
On the R12.1.3 version of EBS did you know that "When Copying A Request Set From A Previous Run, The Delivery Options And Parameters Are Not Copied"? I learned this from MOS document ID 2055893.1 and now I need to check out if we have the indicated patch so we can avoid this problem in the future, and add this kind of testing condition to our testing suites!
Monday, September 14, 2015
Have you ever been in a situation where you needed to gather more information about a problem you are having with Payables? Then check out the My Oracle Support document "R12: How To Run The Transaction Objects Diagnostics Program in Oracle Payables?" from note ID 558196.1 in order to add this program to your toolbox when you find yourself in such a situation!
Sunday, September 13, 2015
If you are running a virtualized Exadata installation, and using OEM to monitor your systems, do not miss out on document ID 1967758.1 for the MOS article "Oracle Enterprise Manager 12c Exadata Management and Virtualized Exadata Database Machine FAQ" which details what versions are compatible with each other and how you need to be configuring the agent too!
Saturday, September 12, 2015
Friday, September 11, 2015
R12.2.3 Procurement: No backend server available for connection error message due to performance issue
If you are on EBS R12.2.3 or planning on going to it, make sure you add into your testing suite the issue detailed in article "Performance When Searching Items To Receive In iProcurement: No Backend Server Available For Connection" which note ID 2054046.1 tells us is due to an incorrect index and what patches are available to resolve the issue.
Thursday, September 10, 2015
Tonight we focus on purging and reducing the size of your EBS footprint by helping to find out "Can You Purge GL_IMPORT_REFERENCES ?" from MOS document 96204.1 with information about the table GL_ARCHIVE_REFERENCES included as well with reference to the General Ledger User's Guide if you needed to find it too!
Wednesday, September 9, 2015
Did you know there are patches which you can apply to limit potential problems with SQL Plan Management? Check out MOS note 2035898.1 for the document "Patches to Consider for 126.96.36.199 to Avoid Problems with SQL Plan Management (SPM)" which is directed at 12c, but has links for patches that can be applied to 11gR2 as well!