Categories
OAS changing db schema password, breaking the system
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.
Best Answers
-
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
1 -
++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
1
Answers
-
Hey Mallikarjuna Kuppauru-Oracle
This seems a great solution. specific to the question.
I will try this, and update here.
Thanks.
0 -
Sure, Let me know if you need any help from my end.
Regards,
Arjun
1 -
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.
1 -
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?
0 -
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
0 -
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
0
