Oracle Fusion MiddlewareおよびOracle SOA SuiteドメインのJDBC接続の更新
Oracle Fusion MiddlewareおよびOracle SOA SuiteドメインのJDBC接続を更新するには、次のステップを実行します:
Oracle Fusion Middlewareドメイン構成ファイルの更新
この例では、次のようになります:
- 新しいホストは
new-target-db12c.example.com
です。 - 新しいサービス名は
PDB1_ORCLSOA.EXAMPLE.COM
です。
新しいターゲット・データベースを指すようにOracle Fusion Middlewareドメイン構成ファイルを更新するには:
/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
/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
/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
/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
/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
/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
/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
/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
Oracle SOA Suiteドメイン構成ファイルの更新
この例では、次のようになります:
- 新しいホストは
new-target-db12c.example.com
です。 - 新しいサービス名は
PDB2_ORCLSOA.EXAMPLE.COM
です。
新しいターゲット・データベースを指すようにOracle SOA Suiteドメイン構成ファイルを更新するには:
/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
/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
/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
/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
/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
/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
/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
/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
/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
/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
/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
/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
/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
/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