Change Default APPS password

Change Default APPS password

• Shutdown concurrent manager
• logon as sysadmin
• goto sysadmin-->security-->Oracle-->Register
• Query for APP%
• Change the APPLSY & APPS Password (Both the Password should be same)
• Logon to TOAD as system/manager
• Run the command

Code :

Alter user APPS identified by <> 

(this password should be identical as in step 5) 

Alter user APPLSYS identified by <> 

(this password should be identical as in step 5)
Commit;

• Edit startup and shutdown scripts (e.g. test_start.sh & test_stop.sh) in the following lines:

Code :

sh adstrtal.sh apps/<> -- Startup script

sh adstpall.sh apps/<>-- Shutdown script

• Edit the following files (change the path according to your instance) – See step 10 to find the editing instructions.

Code :

/applvis/testappl/admin/TEST_cctcal/out/templbac/wdbsvr.app 

-- Optional

/applvis/testappl/admin/TEST_cctcal/out/02111859/wdbsvr.app

-- Optional

/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.
Note: There might be many password fields in these files. Do not change other password fields where the default password is not APPS.

• Use vi command to open the aforementioned files

Code :

:set ic

/password – This will take the cursor 

to the first password field 

If 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.

Important: 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)[/quote]

• Login to application and test whether you can enter into the forms.

Regards,

Sukhwinder Singh

..