How to a copy a file from MDS to the local file system and transferring the file Back to MDS using command line
How to a copy a file from MDS to the local file system and transferring the file Back to MDS using command line
For SOA 12.2.1.3 (on windows) , use this classpath
java -cp d:\soa1213\oracle_common\modules\oracle.mds_12.1.3\mdsrt.jar;d:\soa1213\oracle_common\BC4J\jlib\commons-cli-1.0.jar;d:\soa1213\oracle_common\modules\clients\com.oracle.webservices.fmw.client_12.1.3.jar;d:\soa1213\oracle_common\modules\oracle.adf.share.ca_12.1.3\adf-share-base.jar;d:\soa1213\oracle_common\modules\oracle.adf.share_12.1.3\adflogginghandler.jar;d:\soa1213\oracle_common\modules\oracle.ucp_12.1.0.jar;d:\soa1213\oracle_common\modules\oracle.jdbc_12.1.0\ojdbc7dms.jar;d:\soa1213\oracle_common\modules\clients\com.oracle.webservices.fmw.client_12.1.3.jar;d:\soa1213\oracle_common\modules\oracle.xmlef_12.1.3\xmlef.jar;d:\soa1213\oracle_common\jlib\share.jar;d:\soa1213\oracle_common\modules\javax.management.j2ee_1.2.0.0.jar oracle.mds.tools.transfer.MDSTransferTool /soa/configuration/default/bpel-config.xml --paramfile param_from_mds.xml
This copies the file /soa/configuration/default/bpel-config.xml from the "soa-infra" partion
Sample o/p
Apr 13, 2018 10:09:20 AM oracle.mds
NOTIFICATION: MDS-10013: transfer operation started.
Apr 13, 2018 10:09:21 AM oracle.mds
NOTIFICATION: MDS-10014: transfer is completed. Total number of documents successfully processed : 1, total number of documents failed : 0.
Transfer completed.
cat param_from_mds.xml
++
<!-- Transfer documents from DB MetadataStore to a directory -->
<source-store>
<metadata-store class-name="oracle.mds.persistence.stores.db.DBMetadataStore">
<property name="jdbc-userid" value="DEV1117_MDS"/>
<property name="jdbc-password" value="Welcome1"/>
<property name="jdbc-url" value="jdbc:oracle:thin:@localhost:1521:orcl"/>
<property name="partition-name" value="soa-infra"/>
</metadata-store>
</source-store>
<target-dir value="C:/temp"/>
</parameters>
<!-- Transfer documents from DB MetadataStore to a directory -->
++
This copies the file /soa/configuration/default/bpel-config.xml from MDS to the file system c:\temp
cat param_to_mds.xml
++
<!-- Transfer documents from a directory to DB MetadataStore -->
<source-dir value="C:/Temp"/>
<target-store>
<metadata-store class-name="oracle.mds.persistence.stores.db.DBMetadataStore">
<property name="jdbc-userid" value="DEV1117_MDS"/>
<property name="jdbc-password" value="Welcome1"/>
<property name="jdbc-url" value="jdbc:oracle:thin:@localhost:1521:orcl"/>
<property name="partition-name" value="soa-infra"/>
</metadata-store>
</target-store> </parameters>
++
This copies the file /soa/configuration/default/bpel-config.xml from c:\temp\ to the MDS.
For SOA 12.2.1.3 (on linux) , use this classpath
java -cp /fmw11g/soa12213/oracle_common/modules/oracle.mds/mdsrt.jar:/fmw11g/soa12213/oracle_common/modules/com.oracle.jrf.mt.tenant.api.jar:/fmw11g/soa12213/soa/soa/modules/commons-cli-1.1.jar:/fmw11g/soa12213/oracle_common/modules/clients/com.oracle.webservices.fmw.client.jar:/fmw11g/soa12213/oracle_common/modules/oracle.adf.share.ca/adf-share-base.jar:/fmw11g/soa12213/oracle_common/modules/oracle.adf.share/adflogginghandler.jar:/fmw11g/soa12213/oracle_common/modules/oracle.ucp.jar:/fmw11g/soa12213/oracle_common/modules/oracle.jdbc/ojdbc8.jar:/fmw11g/soa12213/oracle_common/modules/oracle.xmlef/xmlef.jar:/fmw11g/soa12213/oracle_common/modules/oracle.bali.share/share.jar:/fmw11g/soa12213/oracle_common/modules/javax.management.j2ee.jar oracle.mds.tools.transfer.MDSTransferTool /soa/configuration/default/bpel-config.xml --paramfile param_from_mds.xml
on Windows use this 12.2.1.3
c:\temp>java -cp D:\bpm12213\oracle_common\modules\oracle.mds\mdsrt.jar;D:\bpm12213\soa\soa\modules\commons-cli-1.1.jar;D:\bpm12213\oracle_common\modules\clients\com.oracle.webservices.fmw.client.jar;D:\bpm12213\oracle_common\modules\oracle.adf.share.ca\adf-share-base.jar;D:\bpm12213\oracle_common\modules\oracle.adf.share\adflogginghandler.jar;D:\bpm12213\oracle_common\modules\oracle.ucp.jar;D:\bpm12213\oracle_common\modules\oracle.jdbc\ojdbc8.jar;D:\bpm12213\oracle_common\modules\oracle.xmlef\xmlef.jar;D:\bpm12213\oracle_common\modules\oracle.bali.share\share.jar;D:\bpm12213\oracle_common\modules\javax.management.j2ee.jar oracle.mds.tools.transfer.MDSTransferTool /soa/configuration/default/bpel-config.xml --paramfile param_from_mds.xml
cat param_from_mds_oim.xml
++
<!-- Transfer documents from DB MetadataStore to a directory -->
<source-store>
<metadata-store class-name="oracle.mds.persistence.stores.db.DBMetadataStore">
<property name="jdbc-userid" value="OIM_MDS"/>
<property name="jdbc-password" value="Welcome1"/>
<property name="jdbc-url" value="jdbc:oracle:thin:@localhost:1521:orcl"/>
<property name="partition-name" value="oim"/>
</metadata-store>
</source-store>
<target-dir value="/tmp"/>
</parameters>
++
cat param_to_mds.xml
++
<!-- Transfer documents from a directory to DB MetadataStore -->
<source-dir value="C:/Temp"/>
<target-store>
<metadata-store class-name="oracle.mds.persistence.stores.db.DBMetadataStore">
<property name="jdbc-userid" value="DEV1117_MDS"/>
<property name="jdbc-password" value="Welcome1"/>
<property name="jdbc-url" value="jdbc:oracle:thin:@localhost:1521:orcl"/>
<property name="partition-name" value="soa-infra"/>
</metadata-store>
</target-store> </parameters>
++
For Fmw 11.1.1.7 and 11.1.1.9 use this classpath (Windows)
java -cp D:\fmw1117\oracle_common\modules\oracle.mds_11.1.1\mdsrt.jar;D:\fmw1117\oracle_common\soa\modules\commons-cli-1.1.jar;D:\fmw1117\oracle_common\modules\oracle.webservices_11.1.1\oracle.webservices.standalone.client.jar;D:\fmw1117\oracle_common\modules\oracle.adf.share.ca_11.1.1\adf-share-base.jar;D:\fmw1117\oracle_common\modules\oracle.adf.share_11.1.1\adflogginghandler.jar;D:\fmw1117\oracle_common\modules\oracle.ucp_11.1.0.jar;D:\fmw1117\oracle_common\modules\oracle.jdbc_11.1.1\ojdbc6dms.jar;D:\fmw1117\oracle_common\modules\oracle.xmlef_11.1.1\xmlef.jar;D:\fmw1117\Oracle_SOA1\jlib\share.jar;D:\fmw1117\oracle_common\modules\javax.management.j2ee.jar oracle.mds.tools.transfer.MDSTransferTool /soa/configuration/default/bpel-config.xml --paramfile param_from_mds.xml
For Fmw 11.1.1.7 and 11.1.1.9 use this classpath (Linux)
java -cp /fmw11g/fmw1117/Middleware/oracle_common/modules/oracle.mds_11.1.1/mdsrt.jar:/fmw11g/fmw1117/Middleware/oracle_common/soa/modules/commons-cli-1.1.jar:/fmw11g/fmw1117/Middleware/oracle_common/modules/oracle.webservices_11.1.1/oracle.webservices.standalone.client.jar:/fmw11g/fmw1117/Middleware/oracle_common/modules/oracle.adf.share.ca_11.1.1/adf-share-base.jar:/fmw11g/fmw1117/Middleware/oracle_common/modules/oracle.adf.share_11.1.1/adflogginghandler.jar:/fmw11g/fmw1117/Middleware/oracle_common/modules/oracle.ucp_11.1.0.jar:/fmw11g/fmw1117/Middleware/oracle_common/modules/oracle.jdbc_11.1.1/ojdbc6dms.jar:/fmw11g/fmw1117/Middleware/oracle_common/modules/oracle.xmlef_11.1.1/xmlef.jar:/fmw11g/fmw1117/Middleware/Oracle_SOA1/jlib/share.jar:/fmw11g/fmw1117/Middleware/oracle_common/modules/javax.management.j2ee.jar oracle.mds.tools.transfer.MDSTransferTool /soa/configuration/default/bpel-config.xml --paramfile param_from_mds.xml
References :
To Make Changes In oim-config.xml When OIM 11g Server(s) Are Unavailable (Doc ID 1378007.1)
Tags: Publish
April 12, 2018 at 04:03PM
Open in Evernote