EM12c: How to fix BI Publisher 11.1.1.6.0 report error that shows invalid username/password error?

Issue: With EM12cR2, 11.1.1.6.0 BI Publisher is installed and integrated successfully. However, on accessing any report via BI Publisher as sysman user. It shows following error:

Parameter name: targettype weblogic.common.resourcepool.ResourceDeadException: 0: Could not connect to 'oracle.jdbc.OracleDriver'. The returned message is: ORA-01017: invalid username/password; logon denied It is likely that the login or password is not valid. It is also possible that something else is invalid in the configuration or that the database is not available.

Following error is seen in BIP managed server's log file(BIP.out):
2013-Jan-31 12:26:28EMReposAuthenticatorHelper: Following SQLException occurred.
SQLException code=28009 error msg: ORA-28009: connection as SYS should be as SYSDBA or SYSOPER

Problem verification:
When trying to connect EM repository as mgmt_view user via sqlplus. It works fine.

%$ORACLE_HOME/bin/sqlplus mgmt_view/<passwd>@<emrep>
SQL*Plus: Release 11.2.0.3.0 Production on Fri Feb 1 10:06:48 2013
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


Apparently, at some point along with other EM repos users, mgmt_view user password got modified using sqlplus. Which is the not supported way of modifying mgmt_view user passwd.

Action:
On OMS machine, execute the following command:
% $ORACLE_HOME/bin/emctl config oms -change_view_user_pwd -sysman_pwd <sysman_pwd> -user_pwd <user_pwd>
Oracle Enterprise Manager Cloud Control 12c Release 2
Copyright (c) 1996, 2012 Oracle Corporation.  All rights reserved.
Successfully changed password. You must restart the BI Publisher Enterprise Managed Server in order for BI Publisher to function correctly.


Restart the BIP server using weblogic console and restart oms using emctl commands:
% $ORACLE_HOME/bin/emctl stop oms

% $ORACLE_HOME/bin/emctl start oms

EM12c: How to install and integrate BI Publisher with OEM?

Note: With Enterprise Manager 12c Cloud Control Release 2 (12.1.0.2.0), Only BI EE 11.1.1.6.0, is supported while With Enterprise Manager 12c Cloud Control Release 1 (12.1.0.1.0), Only BI EE 11.1.1.5.0, is supported for use .
[BI Publisher 11.1.1.5.0 or 11.1.1.6.0 can be downloaded from http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/bus-intelligence-11g-165436.html]

BI Publisher installation and integration with EM is a two step process.
1. Do a software only install of BI Publisher
Install BIP using runInstaller binary and ensure to do software only install.

2. Integrate BIP with EM 12c
a. goto GCDomain dir. Take backup of this dir.
b. Goto $OMS_HOME i.e. $MIDDLEWARE_HOME/oms/bin directory
c. run configureBIP
Provide 'sys', 'Admin Server user' and 'Node Manager' password.

On demand demo/screenwatch of entire install and integration process can be accessed from here

EM12c: How to change the password for Weblogic Admin server and Nodemanager when existing password is known and register it with emctl commands?

[Caution: If you have already configured BI Publisher, make sure to change this password with BIP as well, else it can break BIP reports.]

One can change admin server and nodemanager password from weblogic console but to ensure that emctl acknowledges this password, there are additional steps.

1. Goto admin server console of EM_GC(GCDomain) domain
https://<hostname.doaminname>:<port>/console

2. Login to Admin server console as user weblogic and its password

3. Go to Security Realms->myrealm->Users and Groups->weblogic->Passwords

4. Provide the new password and save it

5. To change the nodemanager password, follow given steps:

In case of multiple OMS Setup, steps a and b need to be executed only on the OMS server where Admin server is running.

    a.Go to GCDomain->Security(In the right section) ->Advanced

    b.Enter the new password in the "NodeManager Password" and "Confirm NodeManager Password" fields

6.Click on 'Activate Changes' in the left section

7.Stop the OMS
$<OMS_HOME>/bin/emctl stop oms -all

Stop the Agent on OMS Host
$<AGENT_HOME>/bin/emctl stop agent

8. Modify the boot.properties file of the Admin Server
($DOMAIN_HOME/servers/EMGC_ADMINSERVER/security/boot.properties):
In the above file you will see encrypted values for username and password properties. Change the password value to the new password set(clear text).
After modifying the file, it should look like:
==============================================
username={AES}pyu0QhTe6+Xpk+OjEw7vy55OudlxwDXrftY7Pbm95qA=
password=<new_passwd_in_cleartext>
==============================================

9. Modify the boot.properties file of the Managed Server
($DOMAIN_HOME/servers/EMGC_OMS1/data/nodemanager/boot.properties):
(In case of multiple OMS Setup this step need to be performed on each OMS server)
In the above file you will see encrypted values for username and password properties. Change the password value to the new password set(clear text).
After modifying the file, it should look like:
================================================
TrustKeyStore=DemoTrust
username={AES}pyu0QhTe6+Xpk+OjEw7vy55OudlxwDXrftY7Pbm95qA=
password=<new_password_in_clear_text>
================================================

10.Edit the nm_password.properties file under
<gc_inst>/user_projects/domains/GCDomain/config/nodemanager/nm_password.properties
(In case of multiple OMS Setup, this step need to be performed on each OMS server)

Change
================================================
hashed=Qg8bEYV0uA7xJiPclZO0YY1e5rk\=
================================================
to
================================================
password=<new_nodemanager_password>
username=nodemanager
================================================

11.Run following command to save the new passwords to EM Credential store
$<OMS_ORACLE_HOME>/bin/emctl secure create_admin_creds_wallet -admin_pwd <weblogic_pwd> -nodemgr_pwd <node_manager_pwd>


12.Start the OMS
$<OMS_ORACLE_HOME>/bin/emctl start oms