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

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”.

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.

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.

Documentation / Reference


Powered by ComboStrap