Could you provide a bit more information about what you mean by metadata? Are you referring to the DB schemas created with the RCU?
Yes, exactly. Thanks!
As far as I'm aware,11g to 12c upgrade is done out of place where 12c is installed on a new server and RCU is run as part of this process (described here - in the powerpoint). As such, the schemas aren't supposed to be shared.
You'll need to run the RCU to create new schemas and then run the config.bat/sh utility to configure your 12c instance to use the newly created schemas.
Are you sharing the same schema in this database?
When i pointed my OBIEE 11g to new BIPLATFORM and MDS Schemas
I created schema on different database using RCU
Went to EM changed the TNS Entry of Scheduler
In console changed the Connection Pools for data sources to point to new schema and restarted the services.
You can try doing this if you want. But try at your own risk and make sure you have proper backups
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.
After Restart all the services started smoothly?
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>ServicesData 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>ConfigurationConnection PoolSave 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.
Thanks to these forums we learn something new everyday . Let me know how it goes