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”.
Articles Related
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/pwd@ORCL
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.