Friday, November 20, 2015

R12.1.3: Internal Concurrent Manager does not manage processes correctly after CPU patches applied

Regardless if you have already applied the CPU patch which causes this or not, you need to prepare for the potential to encounter the "Concurrent Managers Are Not Going Down Properly After Appling Patch 16735285 in R12(12.1.3)" issue reported in MOS document ID 2063862.1 after any change so make sure you add this to your test cases immediately!  You could also have another take away by finding out more about the Concurrent Managers by looking up the package FND_CONC_RAC_UTILS reported in the error message to see if there are other procedures that maybe you could utilize in the future!!

Thursday, November 19, 2015

12c: CRS processes restart periodically on cluster nodes

From MOS note ID 2074515.1 we find the article "CRS Processes Periodically Restart In Some Cluster Nodes in" which may be very important to keep an eye out for this showing up in your alert/trace files because it is caused by several slow ASM I/Os in a row!

Wednesday, November 18, 2015

R12.1.3 Receivables: Cannot Close period with unposted adjustment

If you have had to deal with Closing a period in A/P or A/R, you are probably very cognizant about unposted transactions holding up the process!  The article "Unable to Close the Period Due to Unposted Adjustment" on My Oracle Support in document ID 2077446.1 gives us yet another reason how a transaction can be in such an incorrect state so it requires an SR to get a datafix, but with the script and information provided we can build a proactive alert against that situation!

Tuesday, November 17, 2015

12c: Error ORA-01467 received when using Extended Data Types

With a bug still being worked on by development, there is a workaround listed in MOS document "ORA-01467 In Oracle 12c when max_string_size is Extended Data Types used" via note ID 2022269.1 with a way to convert your query so the sort path is reduced.  If Extended Data Types for 12c is new to you, this would be a great time to learn and find out what My Oracle Support can tell you about the feature!

Monday, November 16, 2015

11gR2: Bug causes RMAN to remove spfile during database upgrade

The title of MOS document "Upgrade Of Database From To Caused RMAN Duplication To Error On Spfile" from article ID 1951266.1 tells us about a bug which needs to be avoided during 11gR2 upgrades with either a workaround or one-off patch.

Sunday, November 15, 2015

Weekend Learning: FREE Online R12.1 and R12.2 EBS training from Oracle

The other night I said you needed to bookmark a My Oracle Support article, but tonight I REALLY mean it as you NEED to add "Oracle E-Business Suite Release 12.1 and 12.2 Transfer of Information (TOI) Online Training" from note 807319.1 to your bookmarks because there is an incredible list of free training from Oracle on several versions of R12 including the brand new R12.2.5!!

Saturday, November 14, 2015

Weekend Learning: iProcurement Catalog Enhancement Requests

An item you will definitely want to bookmark in My Oracle Support is "iProcurement Enhancement Request - Catalog Shopping" in note ID 1452878.1 for 11.5.7 to 12.1.3 versions of EBS which you can refer back to when a problem crops up so you can see if there are workarounds or patches that can be applied!

Friday, November 13, 2015

Weekend Learning: PeopleSoft webcast archive and scheduled recordings

Ever wanted to know more about Oracle PeopleSoft applications?  Look no further than the "PeopleSoft Enterprise Advisor Webcast Schedule and Archived Recordings" page on My Oracle Support via note ID 1456265.1 for several years of archived webcasts in addition to current upcoming events too!

Thursday, November 12, 2015

R12.1.3 Payables: Performance issue with Period Close

MOS article ID 1408983.1 for "Performance issue with the Payables Period Close" reports that this can take up to 30-45 minutes to run due to a combination of wrong table in the query and lack of index so make sure you check the version you have of the files for this and patch if needed!

Wednesday, November 11, 2015

Oracle Cloud: DaaS customers need to patch due to excessive I/O

Tonight we get an article from MOS entitled "ALERT: Customers with Database as a Service instances must apply a critical patch as soon as possible" from document ID 2068023.1 which is important because specific disk volumes can grow to 90%, prevent backups from running, and a negative I/O performance issue can occur!

Tuesday, November 10, 2015

Goldengate GGSCI does not respond to commands

Getting more hands-on with Oracle GoldenGate lately I have been keeping an eye open for those types of issues on My Oracle Support, and article "Goldengate GGSCI Commands Do Not Respond" via note ID 2076372.1 strikes me as odd that an NFS mount is getting locked to prevent GGSCI from responding!  Check out the associated article about NFS setup too, just to make sure you have everything setup correctly!

Monday, November 9, 2015

R12.2.4: Application Tech Stack - Forms error with AWT-EventQueue-2 Java.lang.IllegalStateException messages

So much for trying to restart my posting streak right before a vacation huh?  Let's see how many days I get this time!

Trying to stay on top of recent R12.2.4 and R12.2.5 changes, My Oracle Support document "Random Forms Error "Exception In Thread "AWT-EventQueue-2" Java.lang.IllegalStateException: Applet'" from note ID 2075992.1 comes an issue where the wrong version of the $FND_TOP/html/oafcoreR122.js file is installed and needs updating so Internet Explorer 11 users can consistently access the application without errors.

Monday, November 2, 2015

Sunday, November 1, 2015

Weekend Learning: Oracle GoldenGate Director Management Pack - Master Note

Do you have to use GoldenGate?  Would you like to know more about it?  How about changing your configuration to install Director?  Check out My Oracle Support document ID 1307305.1 for "Master Note Oracle GoldenGate Management Pack - Director" and learn something about Director this weekend!

Wednesday, October 21, 2015

ASM: After disk comes online resync takes excessive amount of time

If you want to learn a bit more about ASM, especially if you have Exadata because it is affected as well, check out MOS article "ASM disk resync takes long time after disk online" from document ID 2061405.1 including the object GV$ASM_OPERATION which if you investigate on your system maybe you could develop alerts based on it!