OBIEE 12c - Change to point to new repository database

Yes, exactly.  Thanks!

Joel Acha config.cmd/sh did not work.  This can only setup/create for new BI domain. 

rmoff  It's different schema (prefix).  Would that make difference?

Thank you Shams.  Yeah, I tried that today.  Used RCU to create new schema in new database.  Changed all connection pools to use the new schema and database.  Unfortunately, after stop and restart the services, I could not log into BI any more...even with weblogic username.  Not exactly sure what went worng  :-(   Switched the connections back to old database/schema, everything is working again.

Hi Shams,

Yes, after the restart, all services came up.  The only thing is I couldn't log into BI anymore.  Couldn't access online RPD neither.

I just got some instructions from Oracle support.  It looks like I need to run some sync command after pointing to the new RCU database.  I haven't tried it yet, but it looks promising.  Here's what Oracle provided.

a) Take a backup of user_projects directory which is present inside ORACLE HOME.

b) First stop all the servers and BI services except Admin Server using below command from location <ORACLE HOME>\user_projects\domains\<domain_name>\bitools\bin

      stop.cmd –i bi_server1,obis1,obiccs1,obips1,obijh1,obisch1   

c) Then login into Admin Console using URL http://hostname:port/console and navigate to following location Domain Structure<domain_name>ServicesData Sources

d) Then click on “Lock & Edit” under “Change Center” and then click on each of the data sources in the list and change database connection details and password in <Selected Data Source>ConfigurationConnection PoolSave the changes.

e) Once all the data sources connection string and credential information is reentered and saved then click on “Activate Changes” under “Change Center”,

this will ask you to restart Admin Server so stop Admin Server from Console and now start only Admin Server and Managed Serverusing below command from location <ORACLE HOME>\user_projects\domains\<domain_name>\bitools\bin

        start.cmd –I AdminServer,bi_server1

f) Once Admin and Managed Server is started then login into Admin Console and validate connectivity of BIPLATFOR Schema through 

Domain Structure > <domain_name> > Services > Data Sources > biplatform_datasource > Monitoring > Testing > Select Server from the list by clicking on Radio Button > Test Data Source.

g) Now execute command sync_midtier_db.cmd from following location DOMAIN_HOME\bitools\bin 

Information on command sync_midtier_db.cmd:

This command synchronizes connection details to the mid-tier database ensuring that BI components can access the mid-tier database when connection details (including credentials) are changed.

PLEASE NOTE:  BIPLATFORM :There is no validation, you must validate connectivity after updating Datasource connection pools in Weblogic Admin console(as mentioned in step (f)) or WLST before synchronizing.

h) Once connection details to the mi-tier database is synchronized then restart you complete OBIEE 12c Stack by stopping current running Servers and then Starting the server/services.

Sean