Category Archives: Oracle

AD Patch Worker Hangs on XDOLoader Process

Have you run an e-Business Suite R12 patch that slowed down or hung at the Java Loader steps for no apparent reason? I first encountered this issue in January, and finding a workable solution took several hours of research. No Oracle Support notes pointed directly to the issue at the time, although several more recent […]

<span class="entry-utility-prep entry-utility-prep-cat-links">Posted in</span> Applications, Linux, Oracle | <span class="entry-utility-prep entry-utility-prep-tag-links">Tagged</span> , , , , , , , , | 3 Comments

Oracle Log and Trace File Cleanup

UPDATE: Several script bugs brought to my attention by a comment posted below have been fixed. The script should now be compatible with Linux and Solaris. Please let me know if any additional bugs are identified. Every running Oracle installation has several directories and files that need to be rotated and/or purged. Surprisingly, or not, […]

<span class="entry-utility-prep entry-utility-prep-cat-links">Posted in</span> Database, Oracle | <span class="entry-utility-prep entry-utility-prep-tag-links">Tagged</span> , , , , , , , , , | 26 Comments

Copy Tables From DB2 to Oracle – The Free Way

Part of a recent project I was working on involved the decommissioning of an old DB2 database on an IBM z/OS mainframe. As part of the decommissioning process, the business wanted to keep the data available for potential audit reporting. The Oracle Migration Workbench for DB2 sounded like the best option, but it turned out […]

<span class="entry-utility-prep entry-utility-prep-cat-links">Posted in</span> Oracle | <span class="entry-utility-prep entry-utility-prep-tag-links">Tagged</span> , , , , , | 1 Comment

Solaris 10 + IPMP + Oracle RAC

I recently installed a 2-node RAC cluster using the following configuration: Operating System: Solaris 10 (SPARC-64) Oracle Clusterware: 11.1.0.6 Oracle ASM: 11.1.0.6 Oracle RDBMS: 10.2.0.3 Because the servers had 4 network interface cards, I asked the system administrators to configure IPMP on the Virtual IP and Private Interconnect interfaces. The Clusterware, ASM, and RDBMS installations […]

<span class="entry-utility-prep entry-utility-prep-cat-links">Posted in</span> Database, Oracle | <span class="entry-utility-prep entry-utility-prep-tag-links">Tagged</span> , , , , , , | 1 Comment

Spinning Forms Processes

Do you happen to have f60webmx processes that run for days or hours on end, consuming up to 100% of your forms tier CPUs? I do, and I decided to do something about it. The following script will kill forms processes that hog the CPU past a defined time limit. I have set the process […]

<span class="entry-utility-prep entry-utility-prep-cat-links">Posted in</span> Applications, Oracle | Leave a comment