You need to change the SYSTEM, APPS, and Oracle Applications schema passwords.
Run the linked Apps Change Passwords Script on an application tier.After changing the passwords, run Autoconfig on each of the Application Tier Nodes.
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 l.group#
SQL> connect / as sysdba
SQL> alter database add logfile ('/path/to/new/redo_01_01.log','/path/to/new/redo_01_02.log') size 150M;
SQL> alter database add logfile ('/path/to/new/redo_02_01.log','/path/to/new/redo_02_02.log') size 150M;
SQL> alter system switch logfile;
SQL> alter database drop logfile group GROUP#;
The dropped log files should have automatically been deleted from the file system.
I am on call for work this week, and because I spend most of my on-call time at home, I have had a chance to play with setting up a new site. My postings have been rare as of late, and I will try to post more often. This blog will contain personal and technical posts, so feel free to subscribe if any of it interests you. I will copy some of the posts from the old forum to make the site a little more interesting than it is right now.