OWB - How to change the password of the repository Owner (of OWBSYS) ?

> Data Integration Tool (ETL/ELT) > Oracle Warehouse Builder

1 - About

With OWB, when you change the password of the repository owner (of OWBSYS) in the database, you will then see that the OWB deployment hang. You can generate a script but when you start a deployment, it hangs to the steps for instance “Awaiting user action”.

3 - Solution

If you stop and start the control center services, you will have a credential error (as you can see below). The solution is to run the script set_repository_password.sql to set internally the new password for the OWB repository Owner.

4 - Example

C:\owb\owb\rtp\sql>sqlplus OWBREP/[email protected]
 
SQL*Plus: Release 10.2.0.3.0 - Production ON Mon Jan 4 14:56:44 2010
 
Copyright (c) 1982, 2006, Oracle.  ALL Rights Reserved.
 
 
Connected TO:
Oracle DATABASE 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
WITH the Partitioning, OLAP, DATA Mining AND REAL Application Testing options
 
SQL> @show_service
Available
 
PL/SQL PROCEDURE successfully completed.
 
SQL> @stop_service
NOT Available
 
PL/SQL PROCEDURE successfully completed.
 
SQL> @start_service
NOT available
Diagnostics:
service startup failure USING command "/opt/oracle/owb/owb/bin/unix/run_servic
.sh -manual 1 /opt/oracle/owb OWBREP_BIO HASBIODB01:1521:BIODB" reason ORA-295
2: Java CALL TERMINATED BY uncaught Java exception: java.io.IOException: servi
e early exit: code=255 : err=2010/01/04-14:57:01-CET [1AAA14A] java.sql.SQLExc
ption: ORA-01017: invalid username/password; logon denied
 
        at oracle.jdbc.driv
er.DatabaseError.throwSqlException(DatabaseError.java:112)
        at oracle.jdbc.driv
er.T2CConnection.checkError(T2CConnection.java:676)
        at oracle.jdbc.driver.T2CC
onnection.logon(T2CConnection.java:350)
        at oracle.jdbc.driver.PhysicalConnecti
ON.<init>(PhysicalConnection
 
PL/SQL PROCEDURE successfully completed.
 
SQL> @set_repository_password newpassword
 
PL/SQL PROCEDURE successfully completed.
 
 
Commit complete.
 
SQL> @start_service
Available
 
PL/SQL PROCEDURE successfully completed.

5 - Documentation / Reference

Advertising