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!

Wednesday, September 30, 2015

Learning more about Primary Keys

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

Unable to communicate with ASM mirror copy if Exadata Storage Server is offline

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

SQL Developer hits Java GC limit while exporting

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

Weekend Learning: Setting up, monitoring, and tuning parallelism

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

Weekend Learning: Reviewing Purchasing workflow activity

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

12c: DB patch 12 known issues

Did you know that the latest patch for has known issues already?  While article "Oracle Quarterly Database Patch 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

R12.1.3 Receivables: Autoinvoice gives error "The web server returned an error"

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

R12.1.3 Concurrent: Copying previous request all items are not copied

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

Payables: Transaction Objects Diagnostics Program

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

Weekend Learning: OEM 12c FAQ for Exadata Virtualized Database Machine

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

Weekend Learning: Advanced replication scripts

Do you want to learn more about scripting?  Want to learn "Different ways of Advanced replication" from MOS document 1354324.1?  Of course you do!

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

Purging: How do you reduce the size of GL_IMPORT_REFERENCES?

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

Patches for SQL Plan Management issues

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 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!