ReadSoft: How to change the password for the APPS schema in ProcessIT

Summary

Support Article

To change the password for the Oracle APPS schema in PROCESSIT, follow these steps:

1. Log on to the ProcessIT database as the APPS user or a user that has DBA privileges.
2. Run the following query, where <new password> is the desired new password:
        ALTER USER apps IDENTIFIED BY <newpassword>;
3. Log on to the WebLogic Server Console, and in the Domain Configurations section under
4. JDBC, click the D4_DB_APPS data source.
5. Click the Connection Pool tab, and then click Lock & Edit to allow editing if necessary.
6. Type the new password in the applicable fields, click Save, and then click Activate Changes.
7. Click the Control tab, and then click Lock & Edit to allow editing if necessary.
8. Select the AdminServer(admin) check box, click Shutdown, and then click Yes to confirm.
9. Select the AdminServer(admin) check box, click Start, and then click Yes to confirm.
10. Log on to the Application Server Control Console (located by default at http://processit:7777/em), and in the All Application Servers section, click oc4j_soa.
11. Click the Administration tab, and then click the Go to Task icon   in the JDBC Resources row.
12. In the Connection Pools section, click the D4_DB_APPS_POOL link, type the new password, and then click Apply.

Keywords: database, password, security