Category Archives: Database
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, […]
I recently installed a 2-node RAC cluster using the following configuration: Operating System: Solaris 10 (SPARC-64) Oracle Clusterware: 22.214.171.124 Oracle ASM: 126.96.36.199 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 […]
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.
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 […]