Friday, December 19, 2014

11.2.0.3: Gather stats job hangs due to parallel processing

While I did not actually post describing our issue (this post actually mentions the problem though) when we upgraded our DB to 11.2.0.3 on Exadata we ran into some serious issues as soon as we fired up all of our Gather Schema Statistics reports because of the parallelism that was enabled for the process.  Enter MOS note "Dbms_Stats.Gather_Table_Stats For a Table is Hanging With the Wait Event "PX Deq: Execute Reply"" via document ID 1946632.1 which sounds exactly the type of situation we had with our nodes conflicting with each other due to the parallel processing that was enabled!  Did we patch to fix the issue?  Nope, what we did was actually use the report parameter that gave us control over how many parallel processes would get spawned and then ran everything in a single Gather Schema Statistics report since we were on Exadata and had processing power to spare!

Thursday, December 18, 2014

Restarting Windows services and v$transaction

I am sure you are thinking "come on, what do I care about restarting a Windows service" or "I thought this was an Oracle blog" right?  Just hang with me for a minute and it will all make sense!  While we are Oracle technologists foremost, sometimes we need to get additional skills to enhance our primary skills and this is a great example of that.  Today I found myself referencing documentation from Microsoft's Technet because we have a Windows service that keeps a connection open to our database so the software can call our database when needed, and this is keeping a transaction open.  Why is that a problem?  We need to make sure that nothing in v$transaction is older than x days due to our restoration plans, but every x days our monitoring tells us about the old transaction from the Windows service and we have to manually restart the service.  Well, HAD to after using the "net stop" and "net start" commands in a batch file so we can create a scheduled task that bounces this service every night.

Wednesday, December 17, 2014

R12: Reversal date has to be entered in WebADI journal that is not a reversal

Obviously the situation described in the title does not seem right, and the only reason it happens is because of a bug!  Document ID 1929245.1 on My Oracle Support directs you to the article "Your Reversal Date Must Be The Same As Or After Your Accounting Date Error" with all of the details on which patch you need for the BNE product depending on which R12 codeline you have installed.  Here is another testing scenario to add to our testing suite!

Tuesday, December 16, 2014

Configuring notifications in OEM Grid Control

Hot on the heels of my article the other day, about opatch not applying to a RAC instance correctly, is another DBA focused document but there is a reason for that!  How do we get better at Support?  Learning about the system, and what tools are available to help us be more proactive are some great ways to advance your skills!  The document "How To Configure Notification Rules in Enterprise Manager Grid Control" located in My Oracle Support via note ID 429422.1 fits in both of those buckets!  Not only do we learn about OEM, but we learn what is important from Oracle's perspective to monitor about our systems!

Monday, December 15, 2014

Weblogic timeout settings and ORA-24761 rolled back transactions

Today MOS note "Java.sql.SQLException: ORA-24761: Transaction Rolled Back" from document ID 1572916.1 teaches us about the timeout settings for Weblogic and how they can prompt "ORA-24761: transaction rolled back" errors surrounding development when SQL statements are developed to be long running statements.  When you are helping to support new things going into WebLogic, make sure you ask about this!

Sunday, December 14, 2014

Weekend Learning: RAC patching skipping database defined as ORACLE_HOME

In a continued effort to expand what I might know in a Support role, or what the term even means, I have been keeping my eyes open for nuggets of information that I can add to leverage in the future.  Tonight the My Oracle Support article "Why "opatch auto" not patching RAC database ORACLE_HOME?" via note ID 1479651.1 is one such type of nugget as I typically do not get to look at patching (opatch), ORACLE_HOME, or even GI (Grid Infrastructure) so this is another sneak under the covers of what is happening "at the database level".

Saturday, December 13, 2014

Weekend Learning: R12 GL: Setup and usage of budgets and controls

Are you going to R12, or would you just like to know more about GL budgets and their associated controls?  If you answered yes to either of those, head on over to MOS to read document "Budgets and Budgetary Control - Setup and Usage" found via note ID 1928941.1 for all the details!  I think this is a great whitepaper that has been put together that not only uses visuals by the way of screenshots, but has an actual business scenario included that helps walk us through the whole thing!

Friday, December 12, 2014

Weekend Learning: InfiniBand interfaces

Are you running InfiniBand devices with your Oracle infrastructure?  Do you want to know a bit more about it, and problems that can arise?  Of course you do!  Look no further than My Oracle Support note "InfiniBand IPoIB Interfaces Down and IBSTAT Reports HCA Ports in INITIALIZING State" via document ID 1950483.1 which sounds a LOT like an issue we had with InfiniBand interfaces a few months ago, so I wonder if this is based off of our case!  Have you ever used the ibstat command?  Do you monitor /var/log/messages for potential issues?

Thursday, December 11, 2014

R12.2: Invalid PA objects after upgrade

From the title of MOS article "Invalid Objects after Upgrading to 12.2" in document ID 1953062.1 I thought that I would find a large list of objects or even important objects that were preventing an upgrade, but instead there are 2 tables prefaced with PA which are at issue here that do not seem to be holding up your upgrade at all.  Sure, if you want to use your system post upgrade you will have problems because of them being invalid, but it should be found in a TEST instance way before you hit PROD so it does not seem that horrible of a thing.  Read the article and follow the instructions to get the required patch from the Oracle Payroll team as it appears they have it locked down at the moment.

Wednesday, December 10, 2014

11gR2: Issue with ORACLE.EXE on Windows BP 9 & 10

In fresh off the presses information, it does not come fresher than this!  Visit My Oracle Support document "ORACLE.EXE MEMORY LEAK ON 11204 WHEN PATCH BUNDLE 9 OR PATCH BUNDLE 10 HAS BEEN APPLIED" which was released today via article ID 1952786.1 and is very similar to an older article where Windows BP 28 was actually rescinded for 11.2.0.3!  If you are running Oracle 11.2.0.4 on Windows, you need to bookmark this note and check back often for updates/solutions because the cause is not known yet!

Tuesday, December 9, 2014

EM12c: Reports not running due to special character in password

I have told you about my adventures with passwords before, but today is a new type of issue!  Instead of the EBS application, the MOS document "EM 12c: Enterprise Manager 12c Cloud Control BIP Reports do not Execute if the User Login Password has a Special Character (like $)" found via note ID 1951651.1 is about encountering error messages when trying to view BI Publisher reports if the account has a special character in the password for the account.  Is that because special characters are not allowed?  Nope, they are perfectly valid characters but do not interact well with BI Publisher report output files!!

Monday, December 8, 2014

POODLE and Oracle Linux

Now you might be saying "hey you already showed us this document" but not only has it been updated in the last week, it has some new tools for our toolbox!  Revisit MOS article "ALERT - Mitigating the SSLv3 “POODLE” Vulnerability in Oracle Linux (CVE-2014-3566)" via note ID 1940202.1 and find out how to use command line checks to verify what SSL versions are being used!  Why is this useful?  Well what if you wanted to make one file that dials out to all your servers just to gather data about them?  It would be nice to know if they were potentially vulnerable to something like this, right?  Now you can if you run these commands!

Of course this also has detailed steps, patches, and setups required to turn off SSL for many different types of software!

Sunday, December 7, 2014

Weekend Learning: Block corruption in pre-12c DB versions

Out of a lot of error messages out there, I would think that the "ORA-01578: ORACLE data block corrupted" error is likely the most feared out there for DBAs (of course behind ORA-00600).  Do you want to find out more?  Read the long article "Handling Oracle Block Corruptions in Oracle7/8/8i/9i/10g/11g" on My Oracle Support via note ID 28814.1 to get all the details which also includes a lot of datafile related tables and errors that go into the alert log which are all potential candidates for proactive alerts going forward!

Saturday, December 6, 2014

Weekend Learning: R12 A/R Patching - Information Center

Do you want to stay up to date for A/R patching related information on EBS R12?  Then look no further than the MOS note "Information Center: R12 Critical, Rollup and Recommended Patches for Oracle Receivables (AR)" found through document ID 1433375.2 for all of the details you need!

Friday, December 5, 2014

Weekend Learning: PeopleTools and PeopleSoft lifetime support

Have you ever wondered what the official Oracle support timeline is for PeopleTools and what versions are supported on the various PeopleSoft line of applications?  If so, look no further than the My Oracle Support article "Lifetime Support Summary for PeopleSoft Releases" found at note ID 1348959.1 for the complete details!  Based on the title, I thought this article would tell me the support timeline for PeopleSoft applications as well, but it did not seem to have those details, so if you find it from this document please let me know how you found it!