OBIA Schema Password Change

Question

Hi All

We have an OBIA setup, version 11.1.1.10.2 that has the following components:

Weblogic 10.3.6

OBIEE 11.1.1.9

ODI 11.1.1.9

1] Users in the Datawarehouse Database (12.1 Oracle Database):

DEV_DW (Oracle Business Analytics Warehouse Schema)

DEV_SDS_EBS_12_2 (Oracle EBS 12.2 SDS Schema)

2] Users in the Metadata Service Database (12.1 Oracle Database):

DEV_BIA_ODIREPO (Oracle Data Integration Master and Work Repository Schema)

DEV_BIACOMP (Oracle Business Intelligence Applications Components Schema)

DEV_BIPLATFORM (Business Intelligence Platform Schema)

DEV_MDS (Metadata Services Schema)

These passwords will expire, and on the database side we need to change them, which is fine. But for each schema, what actions need to be taken from the application side ?

I see there is MOS Doc ID 1997293.1, but not sure what exactly is to be done (for each schema).

Regards

BPradhan

BPradhan · Answer

Thanks a lot Charles.

Regards

BPradhan

Charles M · Answer

Hi - I will also be doing this in another week, or so. But, only for MDS and BIPLATFORM accounts. I am at almost the exact same version as you (all but 11.1.1.10.2). I have created a document based on these notes: OBIEE: Where can I Find Information About BIPLATFORM And MDS Schema? (Doc ID 1579577.1) How To Update OBIEE 11g Configuration When The Repository (RCU) Schemas Have Changed (Doc ID 1307835.1) OBIEE 11g Agents Are Disabled Automatically (Doc ID 2042288.1) OBIA 11g: How to Change BI Applications System Account Passwords (Doc ID 1613764.1 ) I also looked at: https://docs.oracle.com/middleware/11119/core/ASADM/repos.htm#ASADM260 http://docs.oracle.com/cd/E28280_01/core.1111/e10105/meta.htm#ASADM438 Based on all of this I came up with (yet to be tried out, but my best guess): 1. Change the password of MDS and BIPLATFORM schema ALTER USER {xyz}_BIPLATFORM IDENTIFIED BY (yourpassword); ALTER USER {xyz}_MDS IDENTIFIED BY (yourpassword); 2. Unlock both the accounts ALTER USER {xyz}_BIPLATFORM ACCOUNT UNLOCK; ALTER USER {xyz}_MDS ACCOUNT UNLOCK; 3. Update configuation in Oracle Weblogic Server Administration Console * Navigate to: Home Page > Domain Configurations > Services > JDBC > Data Sources * By default, you will see two data sources: bip_datasource, mds_owsm i. bip_datasource is set to your own _BIPLATFORM and mds_owsm is set to _MDS c. Under each "Connect Pool" setting of each data source, you can modify database schema name, password or JDBC URL 4. Update the New Passwords for MDS and BIPLATFORM schemas in FMW EM * MDS i. Open the EM page ii. On the menu on the left, expand “WebLogic Domain” iii. Right-click “bifoundation_domain iv. On the pop-up menu select “JDBC Data Sources v. Click “mds-owsm” vi. Select the “Connection Pool” tab vii. Set the password and hit “Apply” b. BIPLATFORM i. Open the EM page ii. Expand “Business intelligence” menu on the left iii. Click the “Deployment” tab iv. Click the “Scheduler” tab under deployment v. Click “Lock and Edit Configuration” button vi. Set the password and hit “Apply” vii. Click the “Activate Changes” button 5. Restart your OBI services Hope this helps. Regards, Charles

BPradhan · Answer

Thank You Krishna. I will check all the links.

Regards

BPradhan