OBIEE 11g Schemas Change

Uma Mahesh

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.

cesar.advincula.o

I got the same problem in the past, just get your old password,  I test it in Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production and OBIEE 11.1.1.7.1,

select dbms_metadata.get_ddl('USER', username)

from dba_users

where username ='DEV_BIPLATFORM';

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

      DEFAULT TABLESPACE "USERS"

      TEMPORARY TABLESPACE "TEMP";

alter user DEV_BIPLATFORM identified by whateverpass ACCOUNT UNLOCK;

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

Restart your OBIEE Services.

Kind Regards,

Uma Mahesh

Thanks for your suggestion,

but i don't have the old password, i've tried all the ways but i couldn't get it.

now i want to change the Schema password. and if i change the schema password where can i change the password in OBIEE 11g Enterprise Manager.

Please help me with that.

Thank you.

cesar.advincula.o

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.

Shams Abbasi

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

[Deleted User]

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.