Friday, November 21, 2014

Weekend Learning: Maximum open cursors with JDBC 12.1.0.2

Were you aware that "overuse" of the OracleDatabaseMetaData.getTables method in JDBC 12.1.0.2 causes an ORA-01000 error to happen?  "ORA-01000: Maximum Open Cursors Exceeded With OracleDatabaseMetaData.getTables In JDBC 12.1.0.2" in My Oracle Support via document ID 1939417.1 tells the whole (but short) story and which version of the driver has this issue fixed.

Thursday, November 20, 2014

COLLABORATE 15: Accepted!!!

A few months ago I wrote about submitting abstracts for OAUG's COLLABORATE 15 conference and today I received notification for one of my abstracts being accepted!!  Now the clock is ticking for me to flesh out my presentation and start work on the whitepaper, but I have a whole three months to get it done so I will be seeing you in April at the Mandalay Bay!  Get in on the early bird pricing for the conference and the hotels as well!

Wednesday, November 19, 2014

Assets: Journal entry creation generates ERROR in posting

I know a lot of my posts recently are focused on R12.1.3, but not tonight!  Were you aware of this MOS article "FAPOST Create Journal Entries Ends with ERROR occurred in posting routine" found by note ID 1672917.1?  It appears to be a problem with consolidated retirement issues and a one-off fix was generated so you may need to be applying this some day when you encounter the issue on 11.5.10.2 and after!

Tuesday, November 18, 2014

R12.1.3: Workflow error after RPC2

In My Oracle Support document "You Have Encountered An Error In The Worklist Notifications" from note ID 1946243.1 we learn that after applying Recommended Patch Collection 2 (and the prerequisites) an error message including "OANullDBTransactionImpl cannot be cast" is encountered.  What is the problem here?  It seems that this is related to a browser issue, so plan ahead now for when you have to apply RPC2.

Monday, November 17, 2014

Customizing different heap sizes for multiple WebLogic servers

Were you aware that it is possible to give different servers in your WebLogic domain different heap size values?  I did not know that either until I read MOS document "How to Customize Different Heap Sizes for Different Servers in a WebLogic Domain" found via note ID 1924617.1 for how to change the JVM heap to be the same for all servers in the domain and also how to specify different JVM memory values between Admin and the managed servers in the domain.

Sunday, November 16, 2014

Weekend Learning: Complex ATG application design

Being in a Support type role, it probably is not necessary to understand ATG application design but I can tell you that after reading this article from the Oracle Customer Experience blog there are some things which make a lot more sense.  If you had ever wondered about how different pieces are designed to fit together or want to get a few pointers to help shape the integration between your own parts of the application then give the article a once over.

Saturday, November 15, 2014

Weekend Learning: Inside Cary Millsap's learning

Earlier this year, Cary posted a really great article about how he learned so much about "Oracle" and I recommend that you read it (and take it to heart) if you are just getting started with Oracle technology.  While I am of course nowhere near where Cary is, I think it is very interesting how his path mirrors how my path went because of how much he was in the field and in Support that is my entire life every day.  What is pretty different is how he saw the application causing the majority of the problems while a lot of what I see is the database having problems or not understanding the interaction between the two.  Also do yourself a favor and follow each and every blogger Cary listed, all of them you can find on my blog roll, because it is important to practice continuous learning!

I learned a new book to read from reading his article, with a few other takeaways too.  What did you take away from this?

Friday, November 14, 2014

Weekend Learning: JDBC driver cursor leak on 11.2.0.4

Do you know how sometimes you can stumble across a solution for a problem, when you are not even looking for it?  Well let me introduce you to My Oracle Support document "Cursor Leak After Upgrading to JDBC Driver 11.2.0.4" via note ID 1939530.1 and ask if you have been having problem with "middleware" or "web services" after upgrading to 11.2.0.4?  We are not on 11.2.0.4 YET, but on 11.2.0.3 we have had some issues with memory leaks so this type of issue could be the next condition we encounter so now I am aware of it and can potentially start looking for it when we start upgrading (and testing).  Luckily we have not had the ORA-01000 errors indicated in this article, but forewarned is forearmed.

Thursday, November 13, 2014

Hinting the RESULT_CACHE in 12c

Tonight, we learn from a recent article by Christian Antognini about having a new undocumented parameter for the RESULT_CACHE hint!  While the obvious lessons (the RESULT_CACHE hint, the undocumented parameter) are in front of us, what is less obvious is examining in our own environments the table he investigates: v$result_cache_objects.  Will it solve a problem for you tomorrow?  Not very likely, but we need to keep adding to our toolboxes no?  A few years ago I would not be using v$sqlarea, v$session_longops, or any number of specific v$ objects if it was not for encountering them in one off instances but then revisiting them and learning from what they did or did not tell me.

Wednesday, November 12, 2014

Hyperion: Level 0 Members of alternate hierarchy cannot be selected

Were you aware that on Hyperion Planning 11.1.2.1 the Level 0 Members of the alternate hierarchy cannot be accessed with SmartView via Member Selection?  Visit MOS note "Unable To Access Level 0 Members Of Alternate Hierarchy Through Member Selection Using Smart View" via document ID 1625343.1 to find out why this is expected, and what the resolution will be for it.

Tuesday, November 11, 2014

Magical Mystery Event Tour: Part 3

Continuing the series of posts on mysterious wait events comes another today from 12c which appeared and then disappeared all by itself.  Our friend tonight is "acknowledge over PGA limit" and the wait event does not show up in the new version of the Description of Wait Events for 12c.  Sure, the wait event SOUNDS straightforward but if it was AND common OR easily replication why does it not get an entry in the wait event listing?

When I find out more about this wait event, I will post a new article!

Monday, November 10, 2014

Learn more about JVMs by tuning with JVM Diagnostics

I think we have all been there.  Garbage Collection (GC) for Java Virtual Machines are chewing up your server processing power and once they are done with the server they need to be rebooted.  Instead of a perpetual "throw memory at it" type of solution, take a gander at this post from Oracle.  Were you aware that the JVMD (Java Virtual Machine Diagnostics) tool was part of Oracle Enterprise Manager which is licensed with several other Management Packs?  Is this already in your environment, licensed, and just sitting there gathering dust?  What if you cannot use the tool?  Read the post anyways, and learn about things like "Eden space" or different algorithms to use for your GC!

Sunday, November 9, 2014

Weekend Learning: 32/64-bit OS, Internet Explorer and Excel checks

Capping our weekend learning comes some very simple version check information for the OS, Internet Explorer and Excel.  Visit My Oracle Support document "How To Check To See If IE Or Excel Is Running In 32-bit Or 64-bit Mode?" via article ID 1321637.1 to see how to check this information.  Will it be something you use tomorrow?  Probably not, but would you rather know how to check this when the time comes?  I think so!

Saturday, November 8, 2014

Weekend Learning: Fixed Assets News Index

Did you know that the monthly FA newsletter stopped in November 2013?  Did you know that those newsletters have been archived via MOS article "Oracle Fixed Assets Product News Index" in note ID 155511.1?  Did you ALSO know that going forward the FA newsletter has been rolled into the Oracle EBS blog as one of the categories of posts?  Visit the referenced MOS article and get up to speed on everything!

Friday, November 7, 2014

Weekend Learning: R12 Release Content Documents

Did you know there is an article on My Oracle Support that collates the release documentation for the different modules of the R12 EBS application?  I did not know that either!  Go to note ID 1302189.1 and bookmark the article "R12.1 / R12.2 : Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Documents" which was just updated a few days ago.