Sunday, August 30, 2015

Weekend Learning: Frequent CHECK TIMED OUT listener status on Windows

Want to learn something about RAC configurations?  What about on Windows OS?  Well article "RAC: Frequent CHECK TIMED OUT status of listener and DB resources" from MOS document ID 1608197.1 tells us why these timeouts occur on the Windows platform and how to resolve them as well!

Saturday, August 29, 2015

Weekend Learning: Top 5 database/performance RAC issues

If you are running Oracle RAC, check out MOS note "Top 5 Database and/or Instance Performance Issues in RAC Environment" from document ID 1373500.1 to bone up on a few new things this weekend!

Friday, August 28, 2015

Restrictions in place when transacting across a DB link

Did you know that there is a listing of what you cannot do across database links?  MOS document "Database Links Restrictions in Distributed Environment" from note ID 883328.1 has all of the details including some other MOS notes that go more in-depth for some of the restrictions!

Thursday, August 27, 2015

How to tell if AWR data takes up too much space in SYSAUX tablespace

Are you looking for ways to reduce space in your environment?  Check out My Oracle Support note 287679.1 for the article "How to Address Issues Where AWR Data Uses Significant Space in the SYSAUX Tablespace" so you can validate your settings and find out if there are ways to eliminate extra data including orphaned records!

Wednesday, August 26, 2015

Oracle Linux: No buffer space available

Have you upgraded to Oracle Linux 6.5 with UEK3 yet?  If you have, do you know if you will be encountering an issue with the OS running out of resources?  Make sure you read the details in document "Oracle Linux: ORA-27301:OS Failure Message: No Buffer Space Available" from note 2041723.1 because there are simple changes which can help you avoid this happening in the future!

Tuesday, August 25, 2015

PeopleSoft: COBOL processes error out with unicode database

Greeting Earthlings!  Sorry for the absence the last few days, but Thursday my PC was hit with something nasty and I wasn't able to fix it until just last night so I took a few night off from the blog!

Now that I have my PC repaired, how about we explore the My Oracle Support article "E-COB: COBOL Processes and Remote Calls Error Out & Have Zero-byte Log files Generated on a Unicode PeopleSoft database" from document ID 1629233.1 to learn something new about cloning PeopleSoft on Windows and how non-unicode and unicode databases might differ in this type of environment?

Wednesday, August 19, 2015

Hyperion EPM: Reporting And Analysis Framework Service not starting completely

If your Search Service in Hyperion EPM is not working, start with MOS document "EPM Reporting And Analysis Framework Service Does Not Start Completely" with note ID 1626173.1 to find out how you can diagnose and resolve this problem by removing data from what appears to be an interim type of table!

Tuesday, August 18, 2015

ASM: ORA-600 due to corruption in ASM staleness registry

Lately ASM has been a popular topic, and document 2028222.1 on My Oracle Support continues that recent tradition with article "(DB30) Bug 20904530 - During ASM disk resync ORA-600 [kfdsBlk_verCb] occurs due to corruption in ASM staleness registry" which can teach us about how ASM corruption can be verified, fixed, and repaired!

Monday, August 17, 2015

Best of COLLABORATE 15: Me!

A few weeks ago I let you all know about getting selected for the Best of COLLABORATE 15 webinar series for OAUG, but I must tell you that I was kind of nervous with my previous (only) webinar experience being not that great!  This morning I woke up early, got to work really early, made sure nothing was pending so I could rehearse my presentation one last time (part of Tim Hall's presentation tips) so that at 7:45 I was ready for the webinar prep to begin but due to technical difficulties on the organizer's part they did not get online until around 7:55 so the prep was really rushed!  Fortunately, I have had to deal with a few issues while presenting so this really did not throw me for a loop and I was off and running!  Until I got to about slide 3 or 4 that is.  Unfortunately I got stopped by one of the organizers to let me know that the screen had went dead because it seems the person that started the webinar for us left and that caused my presentation to stop sharing out to the participants!  This lead to a few minutes while I scrambled to get my e-mail back open, log back into the webinar, then have to reshare and figure out where I was in the presentation.  It was only a few minutes, but it made me feel rushed through the whole presentation like I had to keep talking and talking without taking a breath, and I am thinking that showed through, but I really hope it did not!  Probably does not help a whole lot that I have felt like I am coming down with a fever the last few days and my throat was sore when I woke up this morning, but I had drank enough fluids this morning so I could get through the session without having to stop and drink at all.

Overall, I think I would score myself around 8.5-9 out of 10 for the webinar because I was able to get through the difficulties and run through all of my information so I feel like the people that joined were able to really get something out of the 50 minutes (even if nobody asked questions afterwards).  I am looking forward to getting into another webinar so I can take the lessons I learned previously and combine it with a chance to run through a presentation without any technical difficulties at all!

Sunday, August 16, 2015

Weekend Learning: Upgrading to Oracle Database 12c R1 using DB Upgrade Assistant

Of course I, and this blog, am focused on applications and Support/Operation of those applications, but sometimes we need to step into the shoes of our DBAs to learn something new which we can later apply to our discipline!  MOS document "Complete Checklist for Upgrading to Oracle Database 12c Release 1 using DBUA" is that kind of knowledge which you can find via article ID 1516557.1 to get some more details about files, objects, and other steps/scripts which you could find useful down the road!

Saturday, August 15, 2015

Weekend Learning: PeopleTools Process Scheduler - Information Center

Do you have PeopleSoft in your environment at work?  How much do you know about it and PeopleTools?  Could you learn something from MOS document "Information Center: Overview PeopleTools Process Scheduler" found at note ID 1344628.2?  Soak up the how-to's, videos, and troubleshooting tips after you favorite this page!

Friday, August 14, 2015

R12 Purchasing: Requisitions can be locked by other users

Before reading My Oracle Support article "Line #### Of Requisition ### Currently Locked By Another User When Attempting Autocreate a Purchase Order." from note ID 1998470.1 I did not know that requisitions could be locked by other users except when there were true database locks going on in the system!  Check out the reasons behind this, and how it could have been prevented!

Thursday, August 13, 2015

R12 Assets: Invoice does not transfer from one ledger

The funny thing about reading MOS posts is that sometimes I am reminded of an issue at work and "Invoice Can Not be Transfered to FA" from note ID 2040971.1 is one of those times as I have seen this issue crop up but maybe this will help us resolve it!  I will keep you updated as to my success with this!

Wednesday, August 12, 2015

Purging failed transactions from an Oracle DB

From time to time you may find yourself in a situation where a database which connects to your Oracle database loses the connection, but your database thinks that it is still connected and you can leverage MOS document "How to Purge a Distributed Transaction from a Database" from article ID 159377.1 to investigate the tables DBA_2PC_PENDING and DBA_2PC_NEIGHBORS with how to nuke off the sessions as well!

Tuesday, August 11, 2015

R12 Payables: Finding where "Submit Positive Pay Program Immediately" gets stored in the system

If you have ever wondered "Where Is The Information Stored When User Checks "Submit Positive Pay Program Immediately" During Running Of The Record Print Status Program." My Oracle Support tries to answer that question in article ID 2043169.1 which is actually a more complex answer than just yes or no so take a moment to learn something about this process in Payables and a bit more about tables IBY_PAYMENTS_ALL and IBY_PAY_INSTRUCTIONS_ALL!