Table of Contents
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”.
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.
