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!

Thursday, May 14, 2015

PeopleSoft application server does not distribute load evenly

While I do not cover PeopleSoft often, it is in our environment so I need to pay attention to the issues with it, and tonight I found the document "E-AS: Application server load not distributing evenly" on My Oracle Support via note ID 644361.1 which details under what conditions the application server loads will not get distributed due to the algorithm used by the platform.

Wednesday, May 13, 2015

R12.1.3 Purchasing: Accrual report does not provide output after upgrading

I harp on getting testing suites up and running all the time, and MOS document "AP And PO Accrual Report Did Not Generate Output After Upgrade" from note ID 2003582.1 is a perfect example of why since this would have been a simple item to notice if the report was plugged into a test suite.  Visit the document to find out what patch is required to get the report working!

Tuesday, May 12, 2015

Hyperion: Calc Manager is displaying dialog while running ruleset

While I do not focus on Hyperion a whole lot on the blog, tonight I want to share with you article "Calc Manager Run Time Prompt Dialog Displays When Running A Ruleset" on My Oracle Support found via document ID 2006615.1 when there are multiple business rules and "Merge Variables" enabled.

Monday, May 11, 2015

Payables R12: Cannot remove last payment from payment instruction

In terms of verifying patches, I am going to verify the patch associated from note "R12: Payables/Payments: Error: You may not remove the last payment from a payment instruction. Consider terminating the payment instruction instead." via document ID 2007497.1 so I can make sure we do not suffer from something like this in our own system!