Search This Blog

Friday, April 13, 2018

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
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 -->

<parameters version="11.1.1.000" xmlns="http://xmlns.oracle.com/mds/config">
<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 -->

<parameters version="11.1.1.000" xmlns="http://xmlns.oracle.com/mds/config">
<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 -->

<parameters version="11.1.1.000" xmlns="http://xmlns.oracle.com/mds/config">
<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 -->

<parameters version="11.1.1.000" xmlns="http://xmlns.oracle.com/mds/config">
<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

No comments: