Category Archives: Database

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

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

How To Change Oracle Apps System Passwords

Issue You need to change the SYSTEM, APPS, and Oracle Applications schema passwords.  Solution Run the linked Apps Change Passwords Script on an application tier.After changing the passwords, run Autoconfig on each of the Application Tier Nodes.

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

How To Move Online Redo Logs While Database Is Running

Issue You have online redo log files in the wrong place and want to move them. Solution Run the following SQL to locate the current redo log groups and their members: select l.group# group_number , l.status group_status , f.member group_member , f.status file_status from v$log l , v$logfile f where l.group# = f.group# order by […]

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