OBIEE 11g Schemas Change

Question

Hi Guys,

I have OBIEE 11g installed in our production server,

DEV_BIPLATFORM and MDS Schema password expired today,

nobody knows this password.

DBA can alter the password, but i don't know where to change this password in OBIEE

Please guide me through this problem.

Thanks in Advance,

Uma Maheswara Rao A.

[Deleted User] · Answer

You will also need to update all settings in WLS:

Obviously also all RPD connection pools if you pull in the BIPLATFORM and MDS schemas.

Plus: All BIP JDBC sources pointing to these schemas.

Shams Abbasi · Answer

You Should go with what Cesar's is saying.

Although if you really cant do that and you want to change the password.

1. Then ask DBA to change the password.

2. Get the latest password.

3. Login to Enterprise Manager and go to Business Inteligence -> coreapplications

4. Lock and Edit

5. Deployment Tab -> Scheduler and change the password there and click apply (Dont Restart Yet)

6. Logout and go to console

7. Lock and Edit

8. Services -> Datasources

9. Select Each of the data source go to connection pool and change the password for the datsources.

10. Restart Admin server, BI Server and opmnctl (to be on safer side)

Note: These are the basic places where the data sources are being used. If your Environment are using them in other places also you have to change the password their as well.

Let me know if that helps

cesar.advincula.o · Answer

Hello, what i tried to mean that you don't have to KNOW the old password, you just have to GET the old password.

1. For that reason, first, get the OLD encrypted password  with

select dbms_metadata.get_ddl('USER', username)

from dba_users

where username ='DEV_BIPLATFORM';

A sample of the result:

CREATE USER "DEV_BIPLATFORM" IDENTIFIED BY VALUES 'S:790331FA0F2F48912CB53C4AE3846218E5E414142729B6FE6CDEF0E6CEA5;208D03B41AFB1471'

DEFAULT TABLESPACE "USERS"

TEMPORARY TABLESPACE "TEMP";

Save in a notepad or whatever text editor, encrypted password  ( S:790331FA0F2F48912CB53C4AE3846218E5E414142729B6FE6CDEF0E6CEA5;208D03B41AFB1471), because you will use in the step 3.

2. change your DEV_BIPLATFORM password, because your password is expired

alter user DEV_BIPLATFORM identified by whateverpass ACCOUNT UNLOCK;

3. change again the password with your OLD PASSWORD

alter user DEV_BIPLATFORM identified by values 'S:790331FA0F2F48912CB53C4AE3846218E5E414142729B6FE6CDEF0E6CEA5;208D03B41AFB1471';

4. Restart your BI Services.