Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Switching Database from one WebLogic domain to another in Oracle SOA 12c(12.2.1.2)

Mudhu KrishnaJun 18 2025 — edited Jun 20 2025

Hi,

We are in the process of migrating our SOA Suite 12c(12.2.1.2) environments (UAT and STAGE) from an Amazon Linux 1(EOL version) to the Amazon Linux 2023 version. Below is the roadmap and the key steps were followed as part of this migration. We have followed the same folder structure while installing the SOA Suite 12c in the Amazon Linux 2023 version. Please suggests us that if this approach is correct or not. If this is not the right approach then guide us with proper road map. We are doing this activity first in UAT and later we will apply the same in PROD.

  • Database Cloning
    The DB team has created the temp DB(it is a copy of the existing DB) with a different Host but the other configs like port, SID/Service Name, username and password are same as existing DB.

    Temp DB: Its a copy of Existing DB with different Host.

    Perm DB: Its an existing DB which is already in use in the Amazon Linux 1 version. And associated with SOA Suite 12.2.1.2.

  • SOA Suite Installation
    Oracle SOA Suite 12.2.1.2 was freshly installed on the new Amazon Linux 2023 EC2 instances.

  • RCU Schema Re-creation
    Dropped an existing RCU schemas in the temp DB and re-created the new schemas with the same names as in perm DB.

  • New Domain Creation
    A new WebLogic domain was created/configured using the temp DB, all servers are started and all JCA, JMS resources were created as same as the existing UAT domain(running on Amazon Linux 1 instance). All SOA and OSB composites/services, MDS files were deployed to the servers.

  • Functional Testing
    End-to-end testing/validation of SOA and OSB services was successfully done against the temp DB setup.

  • Cut-Over Plan:
    1. Stopped all the servers(Admin and Managed Servers) in the old domain(which was running on Amazon Linux 1).

    2. Pointed the new domain to existing UAT DB(Perm DB which is currently running on Older Amazon Linux 1 version) by modifying the data sources in the admin console.

    3. Below security-related files were copied from the old UAT domain to the new UAT domain. We need to know whether this step is viable or not.

    $DOMAIN_HOME/config/fmwconfig/keystores.xml

    $DOMAIN_HOME/config/fmwconfig/jps-config.xml

    $DOMAIN_HOME/config/fmwconfig/jps-config-jse.xml

    $DOMAIN_HOME/config/fmwconfig/cwallet.sso

    $DOMAIN_HOME/config/fmwconfig/bootstrap/cwallet.sso

    4. Started all the servers in the new UAT domain.

  • Server Startup – Observations
    After switching to the perm DB from temp DB in the new UAT domain, All servers are came up successfully and all the SOA and OSB services are visible in the respective SOA and OSB servers. We can also see all the existing UAT domain SOA composite instances runtime data are also visible in the new UAT domain EM console. End-to-End testing yet to be done. However, during Admin Server startup, we are observing the following errors.

<Jun 16, 2025, 11:02:13,221 AM UTC> <oracle.sysman.eml.app.UIServices> WorkRunner:oracle.sysman.eml.app.UIServices <> <> <50e375e5-47c0-4ef3-bf03-9a44e30c0ba0-00000008> <1750071733221> <[severity-value: 8] [rid: 0:180] [partition-id: 0] [partition-name: DOMAIN] >

<Jun 16, 2025, 11:02:14,248 AM UTC> <oracle.sysman.eml.app.UIServices> WorkRunner:oracle.sysman.eml.app.UIServices <> <> <50e375e5-47c0-4ef3-bf03-9a44e30c0ba0-00000008> <1750071734248> <[severity-value: 8] [rid: 0:180] [partition-id: 0] [partition-name: DOMAIN] >

<Jun 16, 2025, 11:02:14,303 AM UTC> <oracle.sysman.eml.app.UIServices> WorkRunner:oracle.sysman.eml.app.UIServices <> <> <50e375e5-47c0-4ef3-bf03-9a44e30c0ba0-00000008> <1750071734303> <[severity-value: 8] [rid: 0:180] [partition-id: 0] [partition-name: DOMAIN] >

<Jun 16, 2025, 11:02:14,377 AM UTC> <oracle.sysman.eml.app.UIServices> WorkRunner:oracle.sysman.eml.app.UIServices <> <> <50e375e5-47c0-4ef3-bf03-9a44e30c0ba0-00000008> <1750071734377> <[severity-value: 8] [rid: 0:180] [partition-id: 0] [partition-name: DOMAIN] >

<Jun 16, 2025, 11:02:14,378 AM UTC> <oracle.sysman.eml.app.UIServices> WorkRunner:oracle.sysman.eml.app.UIServices <> <> <50e375e5-47c0-4ef3-bf03-9a44e30c0ba0-00000008> <1750071734378> <[severity-value: 8] [rid: 0:180] [partition-id: 0] [partition-name: DOMAIN] >

<Jun 16, 2025, 11:02:14,378 AM UTC> <oracle.sysman.eml.app.UIServices> WorkRunner:oracle.sysman.eml.app.UIServices <> <> <50e375e5-47c0-4ef3-bf03-9a44e30c0ba0-00000008> <1750071734378> <[severity-value: 8] [rid: 0:180] [partition-id: 0] [partition-name: DOMAIN] >

<Jun 16, 2025, 11:02:14,491 AM UTC> <oracle.sysman.eml.app.UIServices> WorkRunner:oracle.sysman.eml.app.UIServices <> <> <50e375e5-47c0-4ef3-bf03-9a44e30c0ba0-00000008> <1750071734491> <[severity-value: 8] [rid: 0:180] [partition-id: 0] [partition-name: DOMAIN] >

<Jun 16, 2025, 11:02:14,492 AM UTC> <oracle.sysman.eml.app.UIServices> WorkRunner:oracle.sysman.eml.app.UIServices <> <> <50e375e5-47c0-4ef3-bf03-9a44e30c0ba0-00000008> <1750071734492> <[severity-value: 8] [rid: 0:180] [partition-id: 0] [partition-name: DOMAIN] >

<Jun 16, 2025, 11:02:14,504 AM UTC> <oracle.sysman.eml.app.UIServices> WorkRunner:oracle.sysman.eml.app.UIServices <> <> <50e375e5-47c0-4ef3-bf03-9a44e30c0ba0-00000008> <1750071734504> <[severity-value: 8] [rid: 0:180] [partition-id: 0] [partition-name: DOMAIN] >

<Jun 16, 2025, 11:02:14,507 AM UTC> <oracle.sysman.eml.app.UIServices> WorkRunner:oracle.sysman.eml.app.UIServices <> <> <50e375e5-47c0-4ef3-bf03-9a44e30c0ba0-00000008> <1750071734507> <[severity-value: 8] [rid: 0:180] [partition-id: 0] [partition-name: DOMAIN] >

<Jun 16, 2025, 11:02:14,544 AM UTC> <oracle.sysman.eml.app.UIServices> WorkRunner:oracle.sysman.eml.app.UIServices <> <> <50e375e5-47c0-4ef3-bf03-9a44e30c0ba0-00000008> <1750071734544> <[severity-value: 8] [rid: 0:180] [partition-id: 0] [partition-name: DOMAIN] >

<Jun 16, 2025, 11:02:14,545 AM UTC> <oracle.sysman.eml.app.UIServices> WorkRunner:oracle.sysman.eml.app.UIServices <> <> <50e375e5-47c0-4ef3-bf03-9a44e30c0ba0-00000008> <1750071734545> <[severity-value: 8] [rid: 0:180] [partition-id: 0] [partition-name: DOMAIN] >

<Jun 16, 2025, 11:02:14,600 AM UTC> <oracle.sysman.eml.app.UIServices> WorkRunner:oracle.sysman.eml.app.UIServices <> <> <50e375e5-47c0-4ef3-bf03-9a44e30c0ba0-00000008> <1750071734600> <[severity-value: 8] [rid: 0:180] [partition-id: 0] [partition-name: DOMAIN] >

<Jun 16, 2025, 11:02:14,601 AM UTC> <oracle.sysman.eml.app.UIServices> WorkRunner:oracle.sysman.eml.app.UIServices <> <> <50e375e5-47c0-4ef3-bf03-9a44e30c0ba0-00000008> <1750071734601> <[severity-value: 8] [rid: 0:180] [partition-id: 0] [partition-name: DOMAIN] >

<Jun 16, 2025, 11:02:14,607 AM UTC> <oracle.sysman.eml.app.UIServices> WorkRunner:oracle.sysman.eml.app.UIServices <> <> <50e375e5-47c0-4ef3-bf03-9a44e30c0ba0-00000008> <1750071734607> <[severity-value: 8] [rid: 0:180] [partition-id: 0] [partition-name: DOMAIN] >

<Jun 16, 2025, 11:02:14,646 AM UTC> <oracle.sysman.eml.app.UIServices> WorkRunner:oracle.sysman.eml.app.UIServices <> <> <50e375e5-47c0-4ef3-bf03-9a44e30c0ba0-00000008> <1750071734646> <[severity-value: 8] [rid: 0:180] [partition-id: 0] [partition-name: DOMAIN] >

<Jun 16, 2025, 11:02:14,717 AM UTC> <oracle.sysman.eml.app.UIServices> WorkRunner:oracle.sysman.eml.app.UIServices <> <> <50e375e5-47c0-4ef3-bf03-9a44e30c0ba0-00000008> <1750071734717> <[severity-value: 8] [rid: 0:180] [partition-id: 0] [partition-name: DOMAIN] >

<Jun 16, 2025, 11:02:14,775 AM UTC> <oracle.sysman.eml.app.UIServices> WorkRunner:oracle.sysman.eml.app.UIServices <> <> <50e375e5-47c0-4ef3-bf03-9a44e30c0ba0-00000008> <1750071734775> <[severity-value: 8] [rid: 0:180] [partition-id: 0] [partition-name: DOMAIN] >

<Jun 16, 2025, 11:02:14,776 AM UTC> <oracle.sysman.eml.app.UIServices> WorkRunner:oracle.sysman.eml.app.UIServices <> <> <50e375e5-47c0-4ef3-bf03-9a44e30c0ba0-00000008> <1750071734776> <[severity-value: 8] [rid: 0:180] [partition-id: 0] [partition-name: DOMAIN] >

<Jun 16, 2025, 11:02:14,777 AM UTC> <oracle.sysman.eml.app.UIServices> WorkRunner:oracle.sysman.eml.app.UIServices <> <> <50e375e5-47c0-4ef3-bf03-9a44e30c0ba0-00000008> <1750071734777> <[severity-value: 8] [rid: 0:180] [partition-id: 0] [partition-name: DOMAIN] >

<Jun 16, 2025, 11:02:14,785 AM UTC> <oracle.sysman.eml.app.UIServices> WorkRunner:oracle.sysman.eml.app.UIServices <> <> <50e375e5-47c0-4ef3-bf03-9a44e30c0ba0-00000008> <1750071734785> <[severity-value: 8] [rid: 0:180] [partition-id: 0] [partition-name: DOMAIN] >

<Jun 16, 2025, 11:02:14,786 AM UTC> <oracle.sysman.eml.app.UIServices> WorkRunner:oracle.sysman.eml.app.UIServices <> <> <50e375e5-47c0-4ef3-bf03-9a44e30c0ba0-00000008> <1750071734786> <[severity-value: 8] [rid: 0:180] [partition-id: 0] [partition-name: DOMAIN] >

<Jun 16, 2025, 11:02:14,790 AM UTC> <oracle.sysman.eml.app.UIServices> WorkRunner:oracle.sysman.eml.app.UIServices <> <> <50e375e5-47c0-4ef3-bf03-9a44e30c0ba0-00000008> <1750071734790> <[severity-value: 8] [rid: 0:180] [partition-id: 0] [partition-name: DOMAIN] >

<Jun 16, 2025, 11:02:14,800 AM UTC> <oracle.sysman.eml.app.UIServices> WorkRunner:oracle.sysman.eml.app.UIServices <> <> <50e375e5-47c0-4ef3-bf03-9a44e30c0ba0-00000008> <1750071734800> <[severity-value: 8] [rid: 0:180] [partition-id: 0] [partition-name: DOMAIN] >

<Jun 16, 2025, 11:02:14,801 AM UTC> <oracle.sysman.eml.app.UIServices> WorkRunner:oracle.sysman.eml.app.UIServices <> <> <50e375e5-47c0-4ef3-bf03-9a44e30c0ba0-00000008> <1750071734801> <[severity-value: 8] [rid: 0:180] [partition-id: 0] [partition-name: DOMAIN] >

<Jun 16, 2025, 11:02:14,807 AM UTC> <oracle.sysman.eml.app.UIServices> WorkRunner:oracle.sysman.eml.app.UIServices <> <> <50e375e5-47c0-4ef3-bf03-9a44e30c0ba0-00000008> <1750071734807> <[severity-value: 8] [rid: 0:180] [partition-id: 0] [partition-name: DOMAIN] >

<Jun 16, 2025, 11:02:14,811 AM UTC> <oracle.sysman.eml.app.UIServices> WorkRunner:oracle.sysman.eml.app.UIServices <> <> <50e375e5-47c0-4ef3-bf03-9a44e30c0ba0-00000008> <1750071734811> <[severity-value: 8] [rid: 0:180] [partition-id: 0] [partition-name: DOMAIN] >

<Jun 16, 2025, 11:02:14,824 AM UTC> <oracle.sysman.eml.app.UIServices> WorkRunner:oracle.sysman.eml.app.UIServices <> <> <50e375e5-47c0-4ef3-bf03-9a44e30c0ba0-00000008> <1750071734824> <[severity-value: 8] [rid: 0:180] [partition-id: 0] [partition-name: DOMAIN] >

<Jun 16, 2025, 11:02:14,825 AM UTC> <oracle.sysman.eml.app.UIServices> WorkRunner:oracle.sysman.eml.app.UIServices <> <> <50e375e5-47c0-4ef3-bf03-9a44e30c0ba0-00000008> <1750071734825> <[severity-value: 8] [rid: 0:180] [partition-id: 0] [partition-name: DOMAIN] >

Other Errors/Warnings:

Jun 17, 2025, 1:19:32,654 PM UTC> <Warning> <oracle.sysman.emInternalSDK.sdkas.general.pojo.model.discovery.plugin.FMWDiscPluginInfoProvider> <aec1wlg12cA002S> <AdminServer> <[ACTIVE] ExecuteThread: '64' for queue: 'weblogic.kernel.Default (self-tuning)'> <WEXAdminUser> <> <50e375e5-47c0-4ef3-bf03-9a44e30c0ba0-00001234> <1750166372654> <[severity-value: 16] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000000> <Target: /Domain_stgaws12c/stgaws12c/AdminServer/Project$ManageTransactionConsumer was downgraded to j2ee_application from oracle_soa_osb_project>

Jun 17, 2025, 1:19:32,655 PM UTC> <Warning> <oracle.sysman.emInternalSDK.sdkas.general.pojo.model.discovery.plugin.FMWDiscPluginInfoProvider> <aec1wlg12cA002S> <AdminServer> <[ACTIVE] ExecuteThread: '64' for queue: 'weblogic.kernel.Default (self-tuning)'> <WEXAdminUser> <> <50e375e5-47c0-4ef3-bf03-9a44e30c0ba0-00001234> <1750166372655> <[severity-value: 16] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000000> <Target: /Domain_stgaws12c/stgaws12c/AdminServer/Project$ManageTransactionConsumer was not discovered>

<Jun 19, 2025, 10:25:33,979 AM UTC> <Warning> <oracle.sysman.emSDK.view.errPopup.ErrorPopupUtil> <aec1wlg12cA002S> <AdminServer> <[ACTIVE] ExecuteThread: '39' for queue: 'weblogic.kernel.Default (self-tuning)'> <WEXAdminUser> <> <4d2120c0-5d5a-4ee8-a9cc-6bae5f6464a9-00000147> <1750328733979> <[severity-value: 16] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000000> < java.lang.IllegalStateException: Response already committed at weblogic.servlet.internal.ServletResponseImpl.objectIfCommitted(ServletResponseImpl.java:1866) at weblogic.servlet.internal.ServletResponseImpl.sendRedirect(ServletResponseImpl.java:961) at weblogic.servlet.internal.ServletResponseImpl.sendRedirect(ServletResponseImpl.java:956) at javax.servlet.http.HttpServletResponseWrapper.sendRedirect(HttpServletResponseWrapper.java:176) at oracle.sysman.eml.app.EMResponseWrapper.sendRedirect(EMResponseWrapper.java:80) at javax.servlet.http.HttpServletResponseWrapper.sendRedirect(HttpServletResponseWrapper.java:176) at com.sun.faces.context.ExternalContextImpl.redirect(ExternalContextImpl.java:678) at javax.faces.context.ExternalContextWrapper.redirect(ExternalContextWrapper.java:578) at javax.faces.context.ExternalContextWrapper.redirect(ExternalContextWrapper.java:578) at javax.faces.context.ExternalContextWrapper.redirect(ExternalContextWrapper.java:578) at oracle.adfinternal.view.faces.config.rich.DetectRedirect.redirect(DetectRedirect.java:66) at javax.faces.context.ExternalContextWrapper.redirect(ExternalContextWrapper.java:578) at oracle.sysman.core.model.targetauth.AppServerLogin.redirect(AppServerLogin.java:2435) at oracle.sysman.core.model.targetauth.AppServerLogin.initializeData(AppServerLogin.java:499) at oracle.sysman.core.model.util.ModelUtil$EMObjectResetter.initOrResetEMObject(ModelUtil.java:236) at oracle.sysman.core.model.util.ModelUtil$EMObjectResetter.access$000(ModelUtil.java:200) at oracle.sysman.core.model.util.ModelUtil.initializeMBEMObjects(ModelUtil.java:151) at oracle.sysman.core.model.util.ModelUtil.initializeAllEMObjects(ModelUtil.java:128) at oracle.sysman.core.model.util.ModelUtil.initializeAllEMObjects(ModelUtil.java:104) at oracle.sysman.emSDK.adfext.ctlr.EMPagePhaseListener.doPrePrepareModel(EMPagePhaseListener.java:975) at oracle.sysman.emSDK.adfext.ctlr.EMPagePhaseListener.beforePhase(EMPagePhaseListener.java:868) at oracle.adfinternal.controller.lifecycle.ADFLifecycleImpl$PagePhaseListenerWrapper.beforePhase(ADFLifecycleImpl.java:559) at oracle.adfinternal.controller.lifecycle.LifecycleImpl.internalDispatchBeforeEvent(LifecycleImpl.java:104) at oracle.adfinternal.controller.lifecycle.LifecycleImpl.executePhase(LifecycleImpl.java:195) at oracle.adfinternal.controller.faces.lifecycle.ADFPhaseListener.startPageLifecycle(ADFPhaseListener.java:204) at oracle.adfinternal.controller.faces.lifecycle.ADFPhaseListener$1.after(ADFPhaseListener.java:370) at oracle.adfinternal.controller.faces.lifecycle.ADFPhaseListener.afterPhase(ADFPhaseListener.java:89) at oracle.adfinternal.controller.faces.lifecycle.ADFLifecyclePhaseListener.afterPhase(ADFLifecyclePhaseListener.java:53) at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._executeAfterPhaseLogic(LifecycleImpl.java:459) at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._executePhase(LifecycleImpl.java:381) at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:227) at javax.faces.webapp.FacesServlet.service(FacesServlet.java:650) at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:286) at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:260) at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:137)

Comments
Post Details
Added on Jun 18 2025
2 comments
78 views