OBIA Schema Password Change

BPradhan

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

MKKrishna

Please find the info on application changes. Just collected info from different sites which might be useful.

DEV_DW (Oracle Business Analytics Warehouse Schema) -- Change in BIACM/ODI Topology

DEV_SDS_EBS_12_2 (Oracle EBS 12.2 SDS Schema) -- Change in BIACM/ODI Topology

DEV_BIPLATFORM (Business Intelligence Platform Schema) - Pls. check below link

DEV_MDS (Metadata Services Schema)  - Pls. check below link

https://www.datavail.com/blog/mds-or-biplatform-schema-password-change-considerations/

DEV_BIA_ODIREPO (Oracle Data Integration Master and Work Repository Schema)

https://docs.oracle.com/cd/E21764_01/integrate.1111/e12643/admin_reps.htm#ODIDG161

https://www.slideshare.net/alooa2/odi-password-recovery

DEV_BIACOMP

Installing Oracle BI Applications 11.1.1.7.1 – Troubleshooting and Frequently Asked Questions (Doc ID 1589540.1)

BPradhan

Thank You Krishna. I will check all the links.

Regards

BPradhan

Charles M

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

1. Navigate to: Home Page > Domain Configurations > Services > JDBC > Data Sources
2. By default, you will see two data sources: bip_datasource, mds_owsm

                i. bip_datasource is set to your own <PREFIX>_BIPLATFORM and mds_owsm is set to <PREFIX>_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

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

Thanks a lot Charles.

Regards

BPradhan