Friday, May 29, 2015

Exadata: NFS mounts unavailable after applying kernel update

I talk about testing suites a lot, so this one falls under the category of OS validation from My Oracle Support article "NFSv3 Exports Not Mounting After Exadata Node Upgrade From OL5.10 To OL6.6" from document ID 2006173.1 because applying Exadata patch 12.1.2.1.0 does upgrade the OS as well just in case you were not prepared for that.  This is where a testing (or validation) suite comes in handy because it could find that your system has changed in such a way, and then warn you when you do this in QA so you can start looking for problems proactively which may now affect you due to the change!

Thursday, May 28, 2015

R12.1.3 Payables: Error when adding bank account after patch

While you may upgrade to R12.1.3 and have no issues like those reported in this MOS document "ERROR PAGE ON ADDING AN EXISTING BANK ACCOUNT ON SUPPLIERS AND CUSTOMERS PAGE" via note ID 1908015.1, the details in the document show that this actually happens as a result of applying a patch to fix another issue so you could encounter this at pretty much any time!

Wednesday, May 27, 2015

Exadata: Cellsrv hangs after 12.1.1.1.1 upgrade

The good news from MOS article "Cellsrv is Hanging and RS Restarting with cellsrv RS-7445 After Upgrading to 12.1.1.1.1" in note 2013522.1 is that it may be confined to X2-2 cells, but there is always the chance that it will start to appear in other configurations as well!

Tuesday, May 26, 2015

R12.1.3 Payables: Payment Manager performance issue after upgrade

Post upgrade to R12.1.3, there is an issue in Payables which you can find from MOS in the note "Performance Problem In Payment Manager (Payment Dashboard Page) After Database Upgrade" by way of document ID 2014319.1 where it details how several different actions can take up to a minute!  First you must gather stats, then set or remove several database parameters, and bounce to make sure it takes effect so you should check out this note to see if you need to review the parameters and then take action if so!

Monday, May 25, 2015

Oracle Linux: Can openssl work with TLS 1.2 on OS 5.x?

In relation to my articles on POODLE and Heartbleed attacks with vectors on ssl, the My Oracle Support note "Oracle Linux 5.x: openssl could not work with TLS v1.2" located by document ID 1986516.1 may be of interest to you if you are still trying to make sure your environments are clear of these issues!

Sunday, May 24, 2015

Weekend Learning: Wait event "library cache lock" Reference

Not only does the document "WAITEVENT: "library cache lock" Reference Note" found via article ID 34578.1 have detailed instruction on what the wait columns mean, how to find blockers in this wait event, but also many tips for troubleshooting the wait event AND dozens of articles about the bugs you can find related to this as well!

Saturday, May 23, 2015

Weekend Learning: How ZFS calculates used space

If you are running an Exadata solution, or other Big Data type installations from Oracle, then you are probably familiar with the ZFS appliance but do you "Understanding How ZFS Calculates Used Space"?  Visit My Oracle Support note ID 1369456.1 to get all the details and find out how using the du and df commands do not get you accurate estimates on a ZFS platform!

Friday, May 22, 2015

Weekend Learning: Troubleshooting ORA-8103 "object no longer exists"

Tonight the article "OERR: ORA-8103 "object no longer exists" Master Note / Troubleshooting, Diagnostic and Solution" from MOS document 8103.1 is VERY extensive in all the different ways that this ORA message can come up, the different solution available, and MANY related notes that you can read as well to catch up on this topic!  The next time I get this error, maybe now I have a few more tools to try and identify or resolve it!!

Thursday, May 21, 2015

12.1.0.2: Upgrade failing due to edition problems

While the MOS article "Database Upgrade to 12.1.0.2 Fails with Error: “ORA-38802: edition does not exist”" has a pretty clear title, note ID 1995415.1 does not have a whole lot of details beyond the bug and that there is a patch associated to fixing this.  Well looking at the bug has the details we are looking for since it seems like several objects, especially ORA$BASE, have no edition information so the installer is crashing!

Wednesday, May 20, 2015

R12.1.3 Payables: PO lines are matching out of order

While it may seem like an innocent problem, your business may not enjoy the bug behind "PO Line Matching In Invoice The Lines Are Coming In Reverse Order" found on MOS via note ID 2007474.1 as they may want things to be matched on invoices in the correct order!  Visit the article to see what patch details are available to get this resolved!

Tuesday, May 19, 2015

Exadata: Synchronous I/O can cause disk corruption

Sure you might be saying to yourself, most I/O operations for Exadata are asynchronous and this only affects versions 12.1.1.1.2 and 12.1.2.1.1 of the Storage Server software so why is this a big deal?  Do you know for sure you will not be upgrading to one of these versions of software?  Do you think these versions are the only versions where this bug will crop up?  Does this make you wonder how to monitor your disks for this kind of thing?  Well the good news is that you can visit My Oracle Support document "Bug 20830449 - Disk corruption possible when a disk media error occurs while synchronous I/O is performed" for note ID 2009841.1 to find out which version of software has a patch available, and which one does not have the patch yet at this time!

Monday, May 18, 2015

R12.1.3 Receivables: Posting Execution Report does not generate after upgrade

Like most of you, I was intrigued after reading this MOS title "ARXGTR.rdf Posting Execution Report fails to regenerate" so I clicked on note ID 2010272.1 to find out this was the expected behavior after upgrading to R12.1.3 as the report is obsolete with another report taking its place.

Sunday, May 17, 2015

Weekend Learning: Procurement Accrual Accounting Analyzer

Check out document ID 1969667.1 on MOS "EBS Procurement Accrual Accounting Analyzer" and download this new analyzer to run it at least once so you can see if there are any outstanding issues that need fixing in your environment.  After you find out, then make sure to convert this into a concurrent request so you can keep on top of any issues that might popup before they become critical issues!

Saturday, May 16, 2015

Weekend Learning: 12c: Automatic Dynamic Statistics

Did you know that Oracle Database 12.1 introduces some new ways to sample dynamic statistics for query optimization?  You are probably familiar with setting this in the 11gR2 world but 12c allows us to set this at a more granular level so it can be done at a statement level and you can find all the details at "Automatic Dynamic Statistics" on My Oracle Support from note ID 2002108.1 to see what has to be enabled for this to work.

Friday, May 15, 2015

Weekend Learning: Customizing EBS logon behavior

Something that we take for granted is logging into the EBS application, but have you ever been curious about the how of it?  I never thought about it until I read the MOS article "How to Customize Logon Behavior" found by note ID 30860.1 and learned about the logon trigger which passes username and password information from the application server to the database!