If you change the password of the repository owner in Oracle Warehouse Builder 10g Release 2, the Control Center Service will fail to start. It is unusual that Oracle stores the Control Centers password in the database. When you alter the repositories password, Oracle should have arranged for the Control Centers password to be changed automatically as well.
What is a Control Center Service? It is the component that enables you to register locations and deploy from the Control Center Manager, and the ability to execute ETL mappings and process flows.
Should you decide to change the repositories password, donâ€™t forget to execute the following scripts:
- If the Control Center is currently running you need to stop it by running the script: <owb home>/owb/rtp/sql/stop_service.sql
- To change the password in the Control Center execute the script:
<owb home>/owb/rtp/sql/set_repository_password.sql. When running the script youâ€™re prompted with the following prompt in SQL*Plus: â€œEnter value for 1:â€.All you need to enter is the new password.
- Finally restart the Control Center by running the script: