Tag 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