Change Default APPS password

on Sunday, March 8, 2009

1. Shutdown concurrent manager

2. Logon as sysadmin

3. Goto sysadmin-->security-->Oracle-->Register

4. Query for APP%

5. Change the APPLSY & APPS Password (Both the Password should be same)

6. Logon to TOAD as system/manager and run the command
1. Alter user APPS identified by >
1. Alter user APPLSYS identified by >
1. Commit


7. Edit startup and shutdown scripts in the following lines:
1. sh adstrtal.sh apps/<> -- Startup script
1. sh adstpall.sh apps/<>-- Shutdown script

8. Edit the following files (change the path according to your instance)
8. /applvis/testappl/admin/TEST_cctcal/out/templbac/wdbsvr.app -- Optional
8. /applvis/testappl/admin/TEST_cctcal/out/02111859/wdbsvr.app -- Optional
8. /applvis/testora/iAS/Apache/modplsql/cfg/wdbsvr.app

Find the word password and type the new password against the password field where the original value is APPS. There might be many password fields in these files. Do not change other password fields where the default password is not APPS.

9. Use vi command to open the aforementioned files
:set ic
/password – This will take the cursor to the first password fieldIf this password field has default value as APPS, change it. If this is not the field then press “n” to go to the next password field. Do this till you get the correct field. Save the file once the change is made.

There will be only one password field with default value as APPS in each of the files. So you need to make only one change per file. Restart all the services (bounce the DB & restart all services) Login to application and test whether you can enter into the forms.

No comments: