OAS changing db schema password, breaking the system

Karthik-Oracle

Hi,

After changing ADB host,

1. DB-URL & Schema password (after WLST encrypt)are updated in these OAS volume files,

Path: $DOMAIN_HOME/config/jdbc
  bip_datasource-jdbc.xml
  BIPlatformDatasource-jdbc.xml
  LocalSvcTblDataSource-jdbc.xml
  mds-owsm-jdbc.xml
  opss-audit-jdbc.xml
  opss-auditview-jdbc.xml
  opss-datasource-jdbc.xml
  WLSSchemaDataSource-jdbc.xml
  XYZ-6667-jdbc.xml

XYZ-6667-jdbc.xml, is due to an additional data source that we have created for reports.

2. and just DB URL or DSN replacements in these,

Path: $DOMAIN_HOME/config/fmwconfig/
  biconfig/OBISCH/schedulerconfig.xml
  bienv/core/datasource.properties
  jps-config.xml
  jps-config-jse.xml

3. at last due to an issue, and as per suggestion in oracle documents, doing this also on WLST:

from $DOMAIN_HOME directory

dbPass = '***********'
modifyBootStrapCredential(jpsConfigFile='config/fmwconfig/jps-config.xml', username='OAS_OPSS', password=dbPass) 

Now after all these changes, when I am trying to start OAS,

getting this issue,

NMProcess: SEVERE: Failed to get environment variables value, error = oracle.bi.se
rvicelcm_v2.support.flyway.exception.UnsupportedDatabaseTypeException: Cannot conn
ect to provided datasource to obtain the database type.                           
NMProcess: java.lang.RuntimeException: oracle.bi.servicelcm_v2.support.flyway.exce
ption.UnsupportedDatabaseTypeException: Cannot connect to provided datasource to o
btain the database type.  

NMProcess: INFO: Initialising new ServiceLCM API object                           
Received error message from Node Manager Server: [Server start command for OBISCH 
server 'obisch1' failed due to: [Unexpected exception from Plugin: oracle.bi.servi
celcm_v2.support.flyway.exception.UnsupportedDatabaseTypeException: Cannot connect
 to provided datasource to obtain the database type.]. Please check Node Manager l
og and/or server 'obisch1' log for detailed information.]. Please check Node Manag
er log for details.                                                               
Failure to start one or more ManagedServers and or Components                     
                                                                                  
Fatal: Failed to start one or more Servers (return 3)  

Any suggestions on what else need to be updated.

Mallikarjuna Kuppauru-Oracle

Hi,

Did you ran the sync_midtier_db.sh script before restarting the services? Refer below MOS doc for process.

How To Change Your Oracle Analytics Connections When You Have Moved Your RCU Database To A New Host (Doc ID 2802991.1)

Regards,

Arjun

Mallikarjuna Kuppauru-Oracle

++Addition to above :

$DOMAIN_HOME/servers/bi_server1

mv tmp/ tmp_old

mv cache/ cache_old/

Do the same for OBIS1,OBIPS1...etc and then start the services using start.sh

Regards,

Arjun

Karthik-Oracle

Hey Mallikarjuna Kuppauru-Oracle

This seems a great solution. specific to the question.

I will try this, and update here.

Thanks.

Mallikarjuna Kuppauru-Oracle

Sure, Let me know if you need any help from my end.

Regards,

Arjun

Karthik-Oracle

Thanks Arjun, I thought to try this on Monday, but was not able to resist to fix it :-)

And happy to say, following this solved the issue, now OAS is running.

Thanks again.

Karthik-Oracle

One more suggestion needed.

On Source OAS, WLS console, Deployment are looking good.

But in cloned Target, Deployment screen looking like this with error's,

any more updates, to be done?

Mallikarjuna Kuppauru-Oracle

Hi,

Good to see your update as its worked. You can accept the answer and close the Thread.

Below is my suggestion for Above Screenshot-

Can you check below MOS doc -

WebLogic Administration Console Deployments Unable To Display With "Unexpected error encountered while obtaining monitoring information for applications" (Doc ID 2687658.1)

Regards,

Arjun

User_6A0VV

https://community.oracle.com/products/oracleanalytics/discussion/comment/49947#Comment_49947

Hi Mallikarjuna,

After executing the "modifyBootStrapCredential" commands, While running the sync_midtier_db.cmd script, it stuck with "Info: JPS initializing" status.

Any log where we can check the exact issue/status.

Warm regards,

Ashutosh