1. Administering Oracle SOA Suite and Oracle Business Process Management Suite
  2. Migrating from a Non-Container Database (Non-CDB) to a Container Database (CDB)
  3. Updating JDBC Connections for the Oracle Fusion Middleware and Oracle SOA Suite Domains

Updating JDBC Connections for the Oracle Fusion Middleware and Oracle SOA Suite Domains

To update JDBC connections for Oracle Fusion Middleware and Oracle SOA Suite domains, complete the following steps:

Update Oracle Fusion Middleware Domain Configuration Files

In this example:

  • The new host is new-target-db12c.example.com.
  • The new service name is PDB1_ORCLSOA.EXAMPLE.COM.

To update Oracle Fusion Middleware domain configuration files to point to the new target database:

  1. Update /u01/oracle/middleware/domains/fmw_domain/config/fmwconfig/jps-config.xml:
    sed -i "s|soa-host01.example.com:1521/ORCLSOA.EXAMPLE.COM|new-target-db12c.example.com:1521/PDB1_ORCLSOA.EXAMPLE.COM|Ig" jps-config.xml
  2. Update /u01/oracle/middleware/domains/fmw_domain/config/fmwconfig/jps-config-jse.xml:
    sed -i "s|soa-host01.example.com:1521/ORCLSOA.EXAMPLE.COM|new-target-db12c.example.com:1521/PDB1_ORCLSOA.EXAMPLE.COM|Ig" jps-config-jse.xml
  3. Update /u01/oracle/middleware/domains/fmw_domain/config/jdbc/LocalSvcTblDataSource-jdbc.xml:
    sed -i "s|soa-host01.example.com:1521/ORCLSOA.EXAMPLE.COM|new-target-db12c.example.com:1521/PDB1_ORCLSOA.EXAMPLE.COM|Ig" LocalSvcTblDataSource-jdbc.xml
  4. Update /u01/oracle/middleware/domains/fmw_domain/config/jdbc/mds-owsm-jdbc.xml:
    sed -i "s|soa-host01.example.com:1521/ORCLSOA.EXAMPLE.COM|new-target-db12c.example.com:1521/PDB1_ORCLSOA.EXAMPLE.COM|Ig" mds-owsm-jdbc.xml
  5. Update /u01/oracle/middleware/domains/fmw_domain/config/jdbc/opss-audit-jdbc.xml:
    sed -i "s|soa-host01.example.com:1521/ORCLSOA.EXAMPLE.COM|new-target-db12c.example.com:1521/PDB1_ORCLSOA.EXAMPLE.COM|Ig" opss-audit-jdbc.xml
  6. Update /u01/oracle/middleware/domains/fmw_domain/config/jdbc/opss-auditview-jdbc.xml:
    sed -i "s|soa-host01.example.com:1521/ORCLSOA.EXAMPLE.COM|new-target-db12c.example.com:1521/PDB1_ORCLSOA.EXAMPLE.COM|Ig" opss-auditview-jdbc.xml
  7. Update /u01/oracle/middleware/domains/fmw_domain/config/jdbc/opss-datasource-jdbc.xml:
    sed -i "s|soa-host01.example.com:1521/ORCLSOA.EXAMPLE.COM|new-target-db12c.example.com:1521/PDB1_ORCLSOA.EXAMPLE.COM|Ig" opss-datasource-jdbc.xml
  8. Update /u01/oracle/middleware/domains/fmw_domain/config/jdbc/WLSSchemaDataSource-jdbc.xml:
    sed -i "s|soa-host01.example.com:1521/ORCLSOA.EXAMPLE.COM|new-target-db12c.example.com:1521/PDB1_ORCLSOA.EXAMPLE.COM|Ig" WLSSchemaDataSource-jdbc.xml

Update Oracle SOA Suite Domain Configuration Files

In this example:

  • The new host is new-target-db12c.example.com.
  • The new service name is PDB2_ORCLSOA.EXAMPLE.COM.

To update Oracle SOA Suite domain configuration files to point to the new target database:

  1. Update /u01/oracle/middleware/domains/soa_domain/config/fmwconfig/jps-config.xml:
    sed -i "s|soa-host01.example.com:1521/ORCLSOA.EXAMPLE.COM|new-target-db12c.example.com:1521/PDB2_ORCLSOA.EXAMPLE.COM|Ig" jps-config.xml
  2. Update /u01/oracle/middleware/domains/soa_domain/config/fmwconfig/jps-config-jse.xml:
    sed -i "s|soa-host01.example.com:1521/ORCLSOA.EXAMPLE.COM|new-target-db12c.example.com:1521/PDB2_ORCLSOA.EXAMPLE.COM|Ig" jps-config-jse.xml
  3. Update /u01/oracle/middleware/domains/soa_domain/config/jdbc/LocalSvcTblDataSource-jdbc.xml:
    sed -i "s|soa-host01.example.com:1521/ORCLSOA.EXAMPLE.COM|new-target-db12c.example.com:1521/PDB2_ORCLSOA.EXAMPLE.COM|Ig" LocalSvcTblDataSource-jdbc.xml
  4. Update /u01/oracle/middleware/domains/soa_domain/config/jdbc/mds-owsm-jdbc.xml:
    sed -i "s|soa-host01.example.com:1521/ORCLSOA.EXAMPLE.COM|new-target-db12c.example.com:1521/PDB2_ORCLSOA.EXAMPLE.COM|Ig" mds-owsm-jdbc.xml
  5. Update /u01/oracle/middleware/domains/soa_domain/config/jdbc/SOADataSource-jdbc.xml:
    sed -i "s|soa-host01.example.com:1521/ORCLSOA.EXAMPLE.COM|new-target-db12c.example.com:1521/PDB2_ORCLSOA.EXAMPLE.COM|Ig" SOADataSource-jdbc.xml
  6. Update /u01/oracle/middleware/domains/soa_domain/config/jdbc/SOALocalTxDataSource-jdbc.xml:
    sed -i "s|soa-host01.example.com:1521/ORCLSOA.EXAMPLE.COM|new-target-db12c.example.com:1521/PDB2_ORCLSOA.EXAMPLE.COM|Ig" SOALocalTxDataSource-jdbc.xml
  7. Update /u01/oracle/middleware/domains/soa_domain/config/jdbc/mds-soa-jdbc.xml:
    sed -i "s|soa-host01.example.com:1521/ORCLSOA.EXAMPLE.COM|new-target-db12c.example.com:1521/PDB2_ORCLSOA.EXAMPLE.COM|Ig" mds-soa-jdbc.xml
  8. Update /u01/oracle/middleware/domains/soa_domain/config/jdbc/opss-audit-jdbc.xml:
    sed -i "s|soa-host01.example.com:1521/ORCLSOA.EXAMPLE.COM|new-target-db12c.example.com:1521/PDB2_ORCLSOA.EXAMPLE.COM|Ig" opss-audit-jdbc.xml
  9. Update /u01/oracle/middleware/domains/soa_domain/config/jdbc/opss-auditview-jdbc.xml:
    sed -i "s|soa-host01.example.com:1521/ORCLSOA.EXAMPLE.COM|new-target-db12c.example.com:1521/PDB2_ORCLSOA.EXAMPLE.COM|Ig" opss-auditview-jdbc.xml
  10. Update /u01/oracle/middleware/domains/soa_domain/config/jdbc/opss-datasource-jdbc.xml:
    sed -i "s|soa-host01.example.com:1521/ORCLSOA.EXAMPLE.COM|new-target-db12c.example.com:1521/PDB2_ORCLSOA.EXAMPLE.COM|Ig" opss-datasource-jdbc.xml
  11. Update /u01/oracle/middleware/domains/soa_domain/config/jdbc/OraSDPMDataSource-jdbc.xml:
    sed -i "s|soa-host01.example.com:1521/ORCLSOA.EXAMPLE.COM|new-target-db12c.example.com:1521/PDB2_ORCLSOA.EXAMPLE.COM|Ig" OraSDPMDataSource-jdbc.xml
  12. Update /u01/oracle/middleware/domains/soa_domain/config/jdbc/EDNDataSource-jdbc.xml:
    sed -i "s|soa-host01.example.com:1521/ORCLSOA.EXAMPLE.COM|new-target-db12c.example.com:1521/PDB2_ORCLSOA.EXAMPLE.COM|Ig" EDNDataSource-jdbc.xml
  13. Update /u01/oracle/middleware/domains/soa_domain/config/jdbc/EDNLocalTxDataSource-jdbc.xml:
    sed -i "s|soa-host01.example.com:1521/ORCLSOA.EXAMPLE.COM|new-target-db12c.example.com:1521/PDB2_ORCLSOA.EXAMPLE.COM|Ig" EDNLocalTxDataSource-jdbc.xml
  14. Update /u01/oracle/middleware/domains/soa_domain/config/jdbc/WLSSchemaDataSource-jdbc.xml:
    sed -i "s|soa-host01.example.com:1521/ORCLSOA.EXAMPLE.COM|new-target-db12c.example.com:1521/PDB2_ORCLSOA.EXAMPLE.COM|Ig" WLSSchemaDataSource-jdbc.xml