Changing the Schema Password for Oracle Platform Security Services

To change the schema password for Oracle Platform Security Services:

1. Connect to the database using SQL*Plus. Connect as a user with SYSDBA privileges.
2. Issue the following command:

   
   SQL> ALTER USER schema IDENTIFIED BY new_password;
   COMMIT;
   

   Be sure to issue the commit command before proceeding to step 3.

   For SQL Server, issue the following command:

   ALTER LOGIN user WITH PASSWORD = new_password;

3. Run the WLST command modifyBootStrapCredential to update the JPS configuration file.
   1. Invoke WLST from the following directory:

      
      ORACLE_HOME/oracle_common/common/bin/wlst.sh
      

   2. Specify the full path to the JPS configuration file in the modifyBootStrapCredentials command. For example:

      
      modifyBootStrapCredential(jpsConfigFile='C:/Oracle/Middleware/user_projects/domains/EPMSystem/config/fmwconfig/jps-config.xml',username='VBC_OPSS',password='password1')
      

      At this point, the Administration Server can be started, however, the log file will show an exception.

   3. When you change the Repository schema password, you must change the password for the corresponding Repository data source, using either Weblogic Console or Oracle Enterprise Manager Fusion Middleware Control. Log in to Oracle Enterprise Manager Fusion Middleware Control (for example, http://WebLogicAdminServerHost:7001/em) using WebLogic administrator credentials.

      1. From the WebLogic Domain menu, select JDBC Data Sources.
      2. Edit each of the following five data sources and update the password:
         1. LocalSvcTblDataSource
         2. opss-audit-DBDS
         3. opss-audit-viewDS
         4. opss-data-source
         5. WLSSchemaDataSource
      3. Select the JDBC Data Source Name:
         1. Click the Configuration tab, then the Connection Pool tab.
         2. For Password, enter the new password and confirm.
         3. Select "Test Database Connection" to verify the update.
         4. Click Save.
         5. Update all the five data sources.
         6. Select Activate Changes.
         7. Restart Weblogic Adminisgtration Server.
         8. Start EPM Services.