OWB 10g R2 â€“ Changing the repositories password disables the Control Center
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:
- Installing Oracle Grid Control 10 release 2 on SuSE 9.3 ES
- AMIS Knowledge Center Session on Spring Framework
- Knowledge Center on Web & Java
- PL/SQL Source Code Control inside the database – After Compile trigger for automatic archiving
- Improvements in Oracle SCM Check Out and Check In mechanism (better Oracle Designer Source Code Control)