tag:blogger.com,1999:blog-16244363884611726432024-03-14T09:27:02.070+05:30Abhishek Saurabh @ SOA-Treasure UnleashedTechnical posts containing information and solutions on Oracle Fusion Middleware 12c/11g/10g, AIA, Oracle BPEL PM, Mediator, OSB, MFT, ESB, OWSM, Business Rules, JDeveloper, Oracle Weblogic, Oracle Application Server etc..etc..Abhishek Saurabhhttp://www.blogger.com/profile/17557091703885116383noreply@blogger.comBlogger118125tag:blogger.com,1999:blog-1624436388461172643.post-59942178699504473892015-01-27T15:24:00.000+05:302015-01-27T15:29:29.369+05:30SOA 12c: Rename MFT Source, Target, Transfer<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Introduction:</b><br />
Guess, what if we have created a MFT Source or Target or Transfer and we have been asked to change its name. This post is quick and easy solution (with little bit of hacking) to achieve the same, so instead of redeveloping MFT components you can just rename it without changing its functionalities.<br />
<br />
<b>Prerequisites:</b><br />
You should know what is MFT source, Target, Transfer and how it is created.<br />
<br />
<b>Steps:</b><br />
For purpose of showing this case, I have created Sample Source, Target and Transfer.<br />
Sample Source name: T1; Sample Target:TestTargt; Sample Transfer: testtransfer<br />
<b><br /></b>
<b><br /></b>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-6hh0KV6w3P8/VMdcBJGmrTI/AAAAAAAAFO0/pOmh0ORN6B8/s1600/Capture1.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-6hh0KV6w3P8/VMdcBJGmrTI/AAAAAAAAFO0/pOmh0ORN6B8/s1600/Capture1.JPG" height="195" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-OC7z7LXpojc/VMdcC2rW_GI/AAAAAAAAFQE/P2QG7BVw9K0/s1600/Capture2.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://2.bp.blogspot.com/-OC7z7LXpojc/VMdcC2rW_GI/AAAAAAAAFQE/P2QG7BVw9K0/s1600/Capture2.JPG" height="163" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-kt18cNbZj-k/VMdcCsM0NsI/AAAAAAAAFPM/-Ymbzz1GLso/s1600/Capture3.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-kt18cNbZj-k/VMdcCsM0NsI/AAAAAAAAFPM/-Ymbzz1GLso/s1600/Capture3.JPG" height="143" width="320" /></a></div>
<br />
Now suppose all my components are ready and at last minute I found some mistake while defining names.<br />
Don't worry, you can easily rectify it. Here I am going to rename Source name T1 to Source1, Just follow below steps:<br />
<br />
1) Export transfer file, just click on export (present on transfer window on right hand side)<br />
2) Once you export the file, you will see a file - [TransferName]_export.zip downloaded.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-46ApTCTt4oA/VMdcC_2iTFI/AAAAAAAAFPQ/CbRYiR49i9w/s1600/Capture4.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://1.bp.blogspot.com/-46ApTCTt4oA/VMdcC_2iTFI/AAAAAAAAFPQ/CbRYiR49i9w/s1600/Capture4.JPG" /></a></div>
<br />
3) Right click on that file and open the zip using Windows Explorer, as shown below. (Note - with normal Winzip or any other tool it will not work)<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-O7x1SNkQuew/VMdcDTUvJVI/AAAAAAAAFPc/4bC5GVXh2ew/s1600/Capture5.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://2.bp.blogspot.com/-O7x1SNkQuew/VMdcDTUvJVI/AAAAAAAAFPc/4bC5GVXh2ew/s1600/Capture5.JPG" height="85" width="320" /></a></div>
<br />
4) A new folder will open containing mft folder. mft folder will contain 3 more directories as shown below<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-R-hVc6h8Rc4/VMdcD7f79HI/AAAAAAAAFPg/-XKNbVL9Zzw/s1600/Capture6.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://2.bp.blogspot.com/-R-hVc6h8Rc4/VMdcD7f79HI/AAAAAAAAFPg/-XKNbVL9Zzw/s1600/Capture6.JPG" height="171" width="320" /></a></div>
<br />
5) Navigate to source folder, you will see an XML file there. Open that file (you can copy that file to different location, edit and then replace the file under mft/source folder).<br />
<br />
As shown below, Source name is T1<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-gbYg8kffX-E/VMdcEqXB77I/AAAAAAAAFPo/galgBy3Rv-E/s1600/Capture7.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-gbYg8kffX-E/VMdcEqXB77I/AAAAAAAAFPo/galgBy3Rv-E/s1600/Capture7.JPG" height="57" width="320" /></a></div>
<br />
6) Edit the name to Source1, save and copy it back to mft/source<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-gJlgEx87tSc/VMdcE5VbugI/AAAAAAAAFPs/m5JAGkmUsW0/s1600/Capture8.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://1.bp.blogspot.com/-gJlgEx87tSc/VMdcE5VbugI/AAAAAAAAFPs/m5JAGkmUsW0/s1600/Capture8.JPG" height="57" width="320" /></a></div>
<br />
7) Once file is copied, close the zip folder<br />
<br />
8) Now go back to MFT console, Administration Tab and Import the zip file.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-rt8QgfDp9vY/VMdcBgzb7VI/AAAAAAAAFO8/Pk_N83nutUk/s1600/Capture10.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://2.bp.blogspot.com/-rt8QgfDp9vY/VMdcBgzb7VI/AAAAAAAAFO8/Pk_N83nutUk/s1600/Capture10.JPG" height="79" width="320" /></a></div>
<br />
9) Once Import is done, go back to Design Tab of MFT console, refresh the Designer palette. You can see new Source name (Source1) appearing there in place of T1<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-OLEvu3jxo_I/VMdcBNvYbvI/AAAAAAAAFO4/-5pAyEET8vs/s1600/Capture11.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://1.bp.blogspot.com/-OLEvu3jxo_I/VMdcBNvYbvI/AAAAAAAAFO4/-5pAyEET8vs/s1600/Capture11.JPG" /></a></div>
<br />
10) Same source name will automatically appear under Transfer as well<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-5EF2Mk_aqPc/VMdcBweGzLI/AAAAAAAAFPA/WBAE3j3Bxzs/s1600/Capture12.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-5EF2Mk_aqPc/VMdcBweGzLI/AAAAAAAAFPA/WBAE3j3Bxzs/s1600/Capture12.JPG" height="147" width="320" /></a></div>
<br />
So you are all set, just deploy and test.<br />
<br />
For renaming Target or Tansfers, follow same steps.<br />
For Targets, navigate to mft/target folder and make changes, and for transfer follow mft/transfer.</div>
Abhishek Saurabhhttp://www.blogger.com/profile/17557091703885116383noreply@blogger.com4tag:blogger.com,1999:blog-1624436388461172643.post-5606643730697513362014-12-28T11:22:00.001+05:302014-12-28T11:22:45.915+05:30Uninstalling SOA 12c from Mac<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Introduction:</b><br />
I had written a post earlier on how to <a href="http://abhishek-soablog.blogspot.in/2014/11/installing-soa-12c-on-mac.html" target="_blank">install SOA 12c on a Mac</a>. For trying my hands on uninstalling the same, I followed below steps.<br />
<br />
<b>Steps:</b><br />
1. Open Terminal and Navigate to MW_Home/oui/bin<br />
<b><br /></b>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-lR7Yf7mvEZg/VJ-Xd-izvuI/AAAAAAAAFNg/clIUItfmqjk/s1600/1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://2.bp.blogspot.com/-lR7Yf7mvEZg/VJ-Xd-izvuI/AAAAAAAAFNg/clIUItfmqjk/s1600/1.png" height="86" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
2. Open you are on that location, give this command - sh deinstall.sh -deinstall<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-S_WtjqpEOpI/VJ-Xe3nV95I/AAAAAAAAFNs/HZ4i7uNkqeY/s1600/2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-S_WtjqpEOpI/VJ-Xe3nV95I/AAAAAAAAFNs/HZ4i7uNkqeY/s1600/2.png" height="75" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
3. This will open the Deinstaller<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-vb2HGisuOyY/VJ-XeSP4OSI/AAAAAAAAFNk/kZBVFUre288/s1600/3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-vb2HGisuOyY/VJ-XeSP4OSI/AAAAAAAAFNk/kZBVFUre288/s1600/3.png" height="189" width="320" /></a></div>
<br />
4. On Opening screen, Click Next<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-kCmZkxqvkPo/VJ-XheLY0RI/AAAAAAAAFN4/l9ev9DjL-js/s1600/4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-kCmZkxqvkPo/VJ-XheLY0RI/AAAAAAAAFN4/l9ev9DjL-js/s1600/4.png" height="252" width="320" /></a></div>
<br />
5. Next page will give the Summary of products which will be Deinstalled. Click on Deinstall<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-946soM-PHgo/VJ-Xkbwk6WI/AAAAAAAAFOA/netlXK1WZgw/s1600/5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-946soM-PHgo/VJ-Xkbwk6WI/AAAAAAAAFOA/netlXK1WZgw/s1600/5.png" height="250" width="320" /></a></div>
<br />
6. Next screen will show the progress on Deinstall. Once it shows 100% click on Finish<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-IvH007dLs-4/VJ-Xkq8C5pI/AAAAAAAAFOE/4iJwxksVp68/s1600/6.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://4.bp.blogspot.com/-IvH007dLs-4/VJ-Xkq8C5pI/AAAAAAAAFOE/4iJwxksVp68/s1600/6.png" height="249" width="320" /></a></div>
<b><br /></b>
7. Last screen will be displayed showing Deinstall summary.<br />
<br />
This is all about Deinstalling SOA 12c.</div>
Abhishek Saurabhhttp://www.blogger.com/profile/17557091703885116383noreply@blogger.com7tag:blogger.com,1999:blog-1624436388461172643.post-87981174588006400072014-12-24T19:22:00.000+05:302014-12-24T19:22:00.372+05:30WLST for MFT<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Introduction:</b><br />
I have been using WLST (WebLogic Scripting Tool) for MFT a lot, so wanted to dedicate some of the post specifically for that. These are pretty simple ones but can help many.<br />
<br />
<b>Steps:</b><br />
If I talk specifically about WLST for MFT, to connect to the server you need to follow below steps.<br />
<br />
1. Open WLS_Home\mft\common\bin (Below screen shot is my system location)<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-4VVbW5WQUVI/VJrCW0UkPcI/AAAAAAAAFNQ/rJQCGXK65DI/s1600/8.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-4VVbW5WQUVI/VJrCW0UkPcI/AAAAAAAAFNQ/rJQCGXK65DI/s1600/8.jpg" height="256" width="320" /></a></div>
<br />
2. Open command prompt (Run as administrator), navigate till the WLS_Home\mft\common\bin<br />
<br />
3. Once you are on that location, type - wlst.cmd (for Linux it is ./wlst.sh)<br />
<br />
4. You will be on wlst prompt<br />
<br />
<b>WLST commonly used Commands:</b><br />
<b><br /></b>
1. For connecting to the server<br />
connect("username","password","t3://hostname:port")<br />
<br />
Example: connect("weblogic","welcome1","t3://localhost:7101")<br />
<br />
2. For disconnecting from WLST<br />
You can either use - disconnect () or exit ()<br />
<br />
<b>Some of WLST Commands for MFT:</b><br />
<b><br /></b>
Coming soon...</div>
Abhishek Saurabhhttp://www.blogger.com/profile/17557091703885116383noreply@blogger.com1tag:blogger.com,1999:blog-1624436388461172643.post-53242692247674788942014-12-24T18:56:00.000+05:302014-12-24T18:57:40.847+05:30Undeploy SOA Composite : Workaround<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Introduction:</b><br />
Recently I was trying to undeploy a BPEL process from EM console, by following normal process i.e. Right clicking on Process name -- SOA Deployment -- Undeploy, but it was throwing error and not allowing me to do so.<br />
<br />
I did a workaround and got ride of the composite. Below steps will show how to achieve the same.<br />
<br />
<b>Note:</b> This was done on Oracle 12c<br />
<br />
<b>Undeploy Steps:</b><br />
1. Login to EM console and click on soa-infra, below screen shot shows BPEL processes.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-aDHI_C4y3kM/VJq78OnDjNI/AAAAAAAAFMc/t_utauSLstw/s1600/1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://4.bp.blogspot.com/-aDHI_C4y3kM/VJq78OnDjNI/AAAAAAAAFMc/t_utauSLstw/s1600/1.jpg" /></a></div>
<br />
2. On Right pane window, click on SOA Infrastructure -- Administration -- MDS Configuration<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-denLbFImZFk/VJq775X-tnI/AAAAAAAAFMg/b5E6vzmpqyk/s1600/2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://4.bp.blogspot.com/-denLbFImZFk/VJq775X-tnI/AAAAAAAAFMg/b5E6vzmpqyk/s1600/2.jpg" height="320" width="231" /></a></div>
<br />
3. You will see MDS configuration page, just click on Export. This will download soa-infra_metadata.zip file<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-kVLb37lZkGg/VJq80obsycI/AAAAAAAAFNA/te4-bskikGk/s1600/6.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://4.bp.blogspot.com/-kVLb37lZkGg/VJq80obsycI/AAAAAAAAFNA/te4-bskikGk/s1600/6.jpg" height="94" width="320" /></a></div>
<br />
4. Unzip the file, you will see a folder deployed-composites, and under that a file deployed-composites.xml as shown in below screen shot<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-AOf2q39Q9ew/VJq78L-OkrI/AAAAAAAAFMY/RfeJiXXIEYs/s1600/3.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-AOf2q39Q9ew/VJq78L-OkrI/AAAAAAAAFMY/RfeJiXXIEYs/s1600/3.jpg" height="135" width="320" /></a></div>
<br />
5. Open the file, select the composite which you want to delete (every composite entry it starts with composite-series). Remove composite-series entry for that composite and Save the file.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-n21UOf0Mjek/VJq78_Ew5YI/AAAAAAAAFMk/zEtZojBQk6c/s1600/4.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://1.bp.blogspot.com/-n21UOf0Mjek/VJq78_Ew5YI/AAAAAAAAFMk/zEtZojBQk6c/s1600/4.jpg" height="87" width="320" /></a></div>
<br />
6. Once the file is saved, Zip the file again. Keep the Zip file name same as before (soa-infra_metadata.zip)<br />
<br />
7. Go back to EM Console and to the Same MDS Configuration window (SOA Infrastructure -- Administration -- MDS Configuration). You will see an Import option.<br />
<br />
Choose the location and Import the file.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-wEppIlvkd7c/VJq7837fpbI/AAAAAAAAFMo/kq4NuRHlLX0/s1600/5.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://4.bp.blogspot.com/-wEppIlvkd7c/VJq7837fpbI/AAAAAAAAFMo/kq4NuRHlLX0/s1600/5.jpg" height="48" width="320" /></a></div>
<br />
8. Restart Server and check EM. The project which you Deleted will disappear.</div>
Abhishek Saurabhhttp://www.blogger.com/profile/17557091703885116383noreply@blogger.com0tag:blogger.com,1999:blog-1624436388461172643.post-42760223724355162572014-11-27T04:08:00.001+05:302014-11-27T04:09:12.853+05:30Installing SOA 12c on a Mac<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Introduction:</b><br />
Having SOA installed on Windows 7 and working on it since long, I thought of trying my hands on my Mac running OS Yosemite. I have successfully installed SOA 12c on my Mac. Oracle has made it simpler to install SOA 12c for Mac, I still remember how I struggled while installing 11g.<br />
<br />
<b>Pre requisites:</b><br />
1) You need to have Java 7 (jre-7u71-macosx-x64.dmg) installed on your Mac. Steps for installing Java can be found on https://www.java.com/en/download/help/mac_install.xml<br />
<br />
<b>Steps:</b><br />
<br />
1) Download SOA 12c from Oracle site (http://www.oracle.com/technetwork/middleware/soasuite/downloads/index.html) for Mac (fmw_12.1.3.0.0_soaqs_Disk1_1of1.zip)<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-J7-S7tGxK2Q/VHZR-gfoQVI/AAAAAAAAFLo/mgYlQvx7bUk/s1600/14.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://4.bp.blogspot.com/-J7-S7tGxK2Q/VHZR-gfoQVI/AAAAAAAAFLo/mgYlQvx7bUk/s1600/14.png" height="297" width="320" /></a></div>
<br />
2) Once the file is downloaded, unzip the file. Open Terminal and Navigate to the directory containing the .jar files as shown below<br />
<br />
Run Java -jar fmw_12.1.3.0.0_soa_quickstart.jar<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-OZQ2OiN0yy8/VHZQ1l5LQjI/AAAAAAAAFKQ/PWWrviAOeEw/s1600/Screen%2BShot%2B2014-11-24%2Bat%2B12.11.31%2Bam.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://1.bp.blogspot.com/-OZQ2OiN0yy8/VHZQ1l5LQjI/AAAAAAAAFKQ/PWWrviAOeEw/s1600/Screen%2BShot%2B2014-11-24%2Bat%2B12.11.31%2Bam.png" height="147" width="320" /></a></div>
<br />
3) This will bring up the installer, change the OS Group accordingly. I choose everyone. Click OK<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-byTDFsGRLdg/VHZQ-t05nfI/AAAAAAAAFKo/YwBwGO5WkWg/s1600/3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://1.bp.blogspot.com/-byTDFsGRLdg/VHZQ-t05nfI/AAAAAAAAFKo/YwBwGO5WkWg/s1600/3.png" height="211" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-rttAD1WIVMw/VHZQ-z3ChNI/AAAAAAAAFKs/nDBsgUaditY/s1600/4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-rttAD1WIVMw/VHZQ-z3ChNI/AAAAAAAAFKs/nDBsgUaditY/s1600/4.png" height="189" width="320" /></a></div>
4) First page of the instller, Click Next<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-vYAQR8SUxWM/VHZQ_oAc-II/AAAAAAAAFKw/54NTQbOBjMc/s1600/5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://2.bp.blogspot.com/-vYAQR8SUxWM/VHZQ_oAc-II/AAAAAAAAFKw/54NTQbOBjMc/s1600/5.png" height="250" width="320" /></a></div>
<br />
5) OracleWls_Home directory will be shown, you can choose your own directory. I went with the default one. Click Next<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-dHhF4H_mRPs/VHZQ_7_O1pI/AAAAAAAAFK4/PHX89wlX-tU/s1600/7.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://4.bp.blogspot.com/-dHhF4H_mRPs/VHZQ_7_O1pI/AAAAAAAAFK4/PHX89wlX-tU/s1600/7.png" height="251" width="320" /></a></div>
<br />
6) Click Install<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-mA6cIuxNZ3o/VHZRAGwhWtI/AAAAAAAAFK8/wTlfruZUkhk/s1600/8.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://2.bp.blogspot.com/-mA6cIuxNZ3o/VHZRAGwhWtI/AAAAAAAAFK8/wTlfruZUkhk/s1600/8.png" height="251" width="320" /></a></div>
<br />
7) Next<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-KSscoZXq0Gk/VHZRAc5w9eI/AAAAAAAAFLE/sMijGkXbqzQ/s1600/9.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://2.bp.blogspot.com/-KSscoZXq0Gk/VHZRAc5w9eI/AAAAAAAAFLE/sMijGkXbqzQ/s1600/9.png" height="253" width="320" /></a></div>
<br />
8) Installation is done, This is the last page. Make sure Start JDeveloper is Enabled and click on Finish<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-cePYSZPxoUQ/VHZQ9wRTvhI/AAAAAAAAFKc/oilPRjv8PyU/s1600/10.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-cePYSZPxoUQ/VHZQ9wRTvhI/AAAAAAAAFKc/oilPRjv8PyU/s1600/10.png" height="250" width="320" /></a></div>
<br />
9) JDeveloper will start<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-Hga25IBdb0g/VHZQ974n6ZI/AAAAAAAAFKY/O7nYP0B_7Gs/s1600/11.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-Hga25IBdb0g/VHZQ974n6ZI/AAAAAAAAFKY/O7nYP0B_7Gs/s1600/11.png" height="146" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-yfN0smnTL7Q/VHZQ93EPnVI/AAAAAAAAFKg/ETNewvty9k0/s1600/12.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://2.bp.blogspot.com/-yfN0smnTL7Q/VHZQ93EPnVI/AAAAAAAAFKg/ETNewvty9k0/s1600/12.png" height="280" width="320" /></a></div>
<br />
10) After start you will see Application Server navigator, where the domain as Unconfigured. Configured the domain either by doing right click on the IntegratedWeblogicServer or by navigating to Run menu as shown in the screen shot below<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-tLWBbRd9vSc/VHZUZFS7R6I/AAAAAAAAFL0/fwoBmGNeGtQ/s1600/15.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-tLWBbRd9vSc/VHZUZFS7R6I/AAAAAAAAFL0/fwoBmGNeGtQ/s1600/15.png" height="91" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-RXT_5bK14Ns/VHZQ-kTvj8I/AAAAAAAAFLc/1dsNt939eT4/s1600/13.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://2.bp.blogspot.com/-RXT_5bK14Ns/VHZQ-kTvj8I/AAAAAAAAFLc/1dsNt939eT4/s1600/13.png" height="320" width="193" /></a></div>
<br />
11) Upon its first time start, a window will open where you will be setting up the password for your local Weblogic. Click OK once done<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-dferkUYkrZU/VHZV0KcSPTI/AAAAAAAAFMA/YnZI1KzVLrg/s1600/16.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-dferkUYkrZU/VHZV0KcSPTI/AAAAAAAAFMA/YnZI1KzVLrg/s1600/16.png" height="268" width="320" /></a></div>
<br />
<br />
Thats it. It will take few minutes to configure and start the server. Once started you can access EM using http://localhost:7101/em on your safari.</div>
Abhishek Saurabhhttp://www.blogger.com/profile/17557091703885116383noreply@blogger.com12tag:blogger.com,1999:blog-1624436388461172643.post-20653590082737599982014-11-25T17:47:00.003+05:302014-11-25T17:47:57.260+05:30Oracle 12c MFT - Using PGP Decryption <div dir="ltr" style="text-align: left;" trbidi="on">
<b>Introduction:</b><br />
This is in continuation of my last blog, <a href="http://abhishek-soablog.blogspot.fi/2014/11/oracle-12c-mft-using-pgp-encryption.html" target="_blank">Oracle 12c MFT - Using PGP Encryption</a>, here we will understand on how to decrypt the file which was encrypted using PGP Encryption technique.<br />
<br />
I would recommend you to go through my <a href="http://abhishek-soablog.blogspot.fi/2014/11/oracle-12c-mft-using-pgp-encryption.html" target="_blank">PGP Encyption blog</a> to understand the process.<br />
<br />
<b>Steps:</b><br />
Once the Keys are available (created and imported during Encryption), doing Decryption will be quite simple. We will be using Private Key for decrypting the file.<br />
<br />
1) Goto MFT console Design Tab, and for Transfer, select add pre-processing actions.<br />
<br />
2) Once window opens, select PGP Decryption for the drop down and Add to the list.<br />
Select Decryption Alias. Click OK<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-GWixk9QKQtA/VHRzSi2-TMI/AAAAAAAAFKA/9SoaDWOLEe4/s1600/18.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://4.bp.blogspot.com/-GWixk9QKQtA/VHRzSi2-TMI/AAAAAAAAFKA/9SoaDWOLEe4/s1600/18.png" height="38" width="320" /></a></div>
<br />
<br />
And you are all done.</div>
Abhishek Saurabhhttp://www.blogger.com/profile/17557091703885116383noreply@blogger.com0tag:blogger.com,1999:blog-1624436388461172643.post-63366807579486382172014-11-25T17:36:00.001+05:302014-11-25T17:41:26.573+05:30Oracle 12c MFT - Using PGP Encryption <div dir="ltr" style="text-align: left;" trbidi="on">
<b>Introduction:</b><br />
While creating Transfers in MFT, we have came across various pre-processing actions, such as Compress, decompress, PGP Encryption and PGP Decryption. These operations will be done for securing Files which is getting transferred from Source to Target.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-rWJddAp1b9o/VHRXlJk0FgI/AAAAAAAAFIs/u8soeIi8Miw/s1600/12.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://1.bp.blogspot.com/-rWJddAp1b9o/VHRXlJk0FgI/AAAAAAAAFIs/u8soeIi8Miw/s1600/12.png" /></a></div>
<br />
Lets learn now how to use PGP Encryption.<br />
<br />
<b>Steps:</b><br />
Before using PGP Encryption, we need to create PGP Key using WLST command. Below are detailed steps on how to acheive the same.<br />
<br />
1) Navigate to OracleWLS_Home\mft\common\bin<br />
2) Once you are there, Run wlst.cmd<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-hErL0Gaerto/VHRY173NRLI/AAAAAAAAFJE/v59Kk02E-fY/s1600/13.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-hErL0Gaerto/VHRY173NRLI/AAAAAAAAFJE/v59Kk02E-fY/s1600/13.png" height="158" width="320" /></a></div>
<br />
3) You are now on wlst prompt, Now connect to your server using following command<br />
connect("username","password","t3://hostname:port")<br />
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-SPDYjVeLSbs/VHRYiMnsKDI/AAAAAAAAFI8/8yR_ArEgvw8/s1600/3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://2.bp.blogspot.com/-SPDYjVeLSbs/VHRYiMnsKDI/AAAAAAAAFI8/8yR_ArEgvw8/s1600/3.png" height="81" width="320" /></a></div>
<br />
4) Above prompt shows that you are now connected to server. Now we will have to generate the PGP Key to create a password-protected PGP key pair. Fire the wlst command for generating Key, as-<br />
generateKeys('PGP', 'Password for the key','Location name where you want keys to get generated')<br />
<br />
Note: I have created a seperate new directory under my local domain to contain all the Keys<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-UmfUMMLTGl8/VHReO3irydI/AAAAAAAAFJU/1OvmaefmbzY/s1600/14.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://4.bp.blogspot.com/-UmfUMMLTGl8/VHReO3irydI/AAAAAAAAFJU/1OvmaefmbzY/s1600/14.png" height="53" width="320" /></a></div>
<br />
This will create two keys - pub.asc (Public) and secret.asc (Private)<br />
<br />
5) Now you will have to import the PGP key pair to the server and will also create an alias for both Public and Private keys.<br />
Use below commands to do the same:<br />
importCSFKey('PGP', 'PUBLIC', 'Alias Name', 'full location/pub.asc')<br />
importCSFKey('PGP', 'PRIVATE', 'Alias Name', 'full location/secret.asc')<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-Rz3UpRENGyE/VHRvSorXeGI/AAAAAAAAFJk/NMR3wOp8UcA/s1600/15.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-Rz3UpRENGyE/VHRvSorXeGI/AAAAAAAAFJk/NMR3wOp8UcA/s1600/15.png" height="67" width="320" /></a></div>
<br />
6) Now as your Key pairs are generated and imported successfully, Go back to MFT console. Now rest of the configuration will happen there.<br />
<br />
7) Login to MFT console and navigate to administration Tab - Keystores.<br />
Enter the same password which was used during Generating key in the PGP Keystore section. Save the changes<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-i4-r2n58g10/VHRvip0ZKiI/AAAAAAAAFJs/ptOdze04bBE/s1600/16.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://2.bp.blogspot.com/-i4-r2n58g10/VHRvip0ZKiI/AAAAAAAAFJs/ptOdze04bBE/s1600/16.png" height="79" width="320" /></a></div>
<br />
8) Now you are all good to use this setup in creating Transfers. Goto MFT console Design Tab, and for Transfer, select add pre-processing actions.<br />
<br />
Once a window opens, select PGP Encryption for the drop down and Add to the list.<br />
Select Encryption Alias and the Armored section. Click OK<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-5po6GGRiGGo/VHRwacWSPjI/AAAAAAAAFJ0/Sqg-wVbLAU0/s1600/17.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-5po6GGRiGGo/VHRwacWSPjI/AAAAAAAAFJ0/Sqg-wVbLAU0/s1600/17.png" height="283" width="320" /></a></div>
<br />
And you are all set. You file will be Encrypted.</div>
Abhishek Saurabhhttp://www.blogger.com/profile/17557091703885116383noreply@blogger.com2tag:blogger.com,1999:blog-1624436388461172643.post-11108243509682538492014-11-25T15:33:00.001+05:302014-11-25T17:32:45.780+05:30Oracle 12c MFT - Configuring sFTP Embed<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Introduction:</b><br />
Oracle 12c MFT includes built-in sFTP (SSH-FTP) server, known as sFTP Embedded. You can see this in MFT console drop down when you configure Source.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-_yFnSLuvvaM/VHRNQYVidqI/AAAAAAAAFHQ/TAxai-PiT6A/s1600/1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://1.bp.blogspot.com/-_yFnSLuvvaM/VHRNQYVidqI/AAAAAAAAFHQ/TAxai-PiT6A/s1600/1.png" /></a></div>
<br />
<br />
sFTP Embed has its own file system directories for sending and receiving files. By default, this is disabled, we need to configure it before using it.<br />
<br />
Lets learn step by step on how to configure this.<br />
<br />
<b>Steps:</b><br />
For configuring sFTP (SSH-FTP), we need to create SSH Keystore using WLST command. Below are detailed steps on how to acheive the same.<br />
<br />
1) Navigate to OracleWLS_Home\mft\common\bin<br />
2) Once you are there, Run wlst.cmd<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-bKQgKeZbiak/VHRNf-nT1DI/AAAAAAAAFHY/mPb_bZmMSA4/s1600/2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://1.bp.blogspot.com/-bKQgKeZbiak/VHRNf-nT1DI/AAAAAAAAFHY/mPb_bZmMSA4/s1600/2.png" height="158" width="320" /></a></div>
<br />
3) You are now on wlst prompt, Now connect to your server using following command<br />
connect("username","password","t3://hostname:port")<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-1o_Zh_Ejz_s/VHROyo6FzoI/AAAAAAAAFHs/OYVu0ZzA3hU/s1600/3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://2.bp.blogspot.com/-1o_Zh_Ejz_s/VHROyo6FzoI/AAAAAAAAFHs/OYVu0ZzA3hU/s1600/3.png" height="81" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
4) Above prompt shows that you are now connected to server. Now we will have to generate the Key to create a password-protected private SSH key. The key type is RSA and the key size is 1024 bits. Fire the wlst command for generating Key, as<br />
generateKeys('SSH','Password for the key','Key Name with full location')<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-qkqjMVesjJ0/VHRQKq9oucI/AAAAAAAAFH0/yj0y3wqI6VI/s1600/5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-qkqjMVesjJ0/VHRQKq9oucI/AAAAAAAAFH0/yj0y3wqI6VI/s1600/5.png" height="38" width="320" /></a></div>
<br />
Note: I have created a new directory under my local domain to contain all the Keys<br />
<br />
5) Now you will have to import the key to the server and will also create an alias for the key.<br />
Use below command to do the same:<br />
importCSFKey('SSH', 'PRIVATE', 'Alias Name', 'Key Name with full location')<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-9XxyFtFnc0A/VHRRVtJX4mI/AAAAAAAAFH8/hOOAo8LNdKE/s1600/6.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://4.bp.blogspot.com/-9XxyFtFnc0A/VHRRVtJX4mI/AAAAAAAAFH8/hOOAo8LNdKE/s1600/6.png" height="48" width="320" /></a></div>
<br />
6) Now as your Key generation and import is done, Go back to MFT console. Now rest of the configuration will happen there.<br />
<br />
7) Login to MFT console and navigate to administration Tab - Keystores.<br />
Enter the same password which was used during Generating key in the SSH Keystore section. Save the changes<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-vwOpEBwLF98/VHRSQrrgJbI/AAAAAAAAFII/vxtzqgEMAe4/s1600/7.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://1.bp.blogspot.com/-vwOpEBwLF98/VHRSQrrgJbI/AAAAAAAAFII/vxtzqgEMAe4/s1600/7.png" height="90" width="320" /></a></div>
<br />
8) Click on Embedded servers and go to the sFTP tab. Check the Enabled button, Choose Authentication Type as Password and Host Key Alias (the same alias which was created at the time of importing the key to the server).<br />
<br />
Save the changes, click on Start button<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-0T-nECg2HGU/VHRSQvFIxDI/AAAAAAAAFIc/VDnjrJ2u4Ro/s1600/8.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-0T-nECg2HGU/VHRSQvFIxDI/AAAAAAAAFIc/VDnjrJ2u4Ro/s1600/8.png" height="96" width="320" /></a></div>
<br />
9) Now your sFTP Embed server is up and running, this by default runs on Port 7522. You can check the same in the Ports section (You can change the port, but I would recommend to keep this as it is.)<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-jcRjgrAxCp8/VHRSRHxEq0I/AAAAAAAAFIM/I0BTBjqQDbg/s1600/9.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://2.bp.blogspot.com/-jcRjgrAxCp8/VHRSRHxEq0I/AAAAAAAAFIM/I0BTBjqQDbg/s1600/9.png" height="68" width="320" /></a></div>
<br />
10) So now you are all set to use sFTP Embedded feature of Oracle 12c MFT. You can even connect to the sFTP location using any client like WinScp.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-0W2m4YZUK5Q/VHRSQpisdHI/AAAAAAAAFIE/ivwBI2ZHXgM/s1600/10.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-0W2m4YZUK5Q/VHRSQpisdHI/AAAAAAAAFIE/ivwBI2ZHXgM/s1600/10.png" height="215" width="320" /></a></div>
<br />
Go ahead and try this awesome feature.<br />
<br />
Note: The default root directory location for this is OracleWLS_Home/user_projects/domains/your -Default Domain/mft/ftp_root (This can be changed and configured from MFT console, I would prefer to use the same path)</div>
Abhishek Saurabhhttp://www.blogger.com/profile/17557091703885116383noreply@blogger.com1tag:blogger.com,1999:blog-1624436388461172643.post-60631932099401657442014-11-24T15:15:00.001+05:302014-11-26T20:01:01.567+05:30SOA 12c Creating Derby Database Connection<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Introduction:</b><br />
JavaDB (Derby) is used to run SOA Suite repository on that is used for the integrated server. It is a development database that allows one to start development with SOA Suite without the need to run RCU.<br />
<b><br /></b>
<b><br /></b>
<b>How to create connection:</b><br />
The steps are quite simple.<br />
<br />
1) You need to Open Database Navigator, as shown below<br />
<span style="background-color: #fff9ee; color: #222222; font-family: Georgia, Utopia, 'Palatino Linotype', Palatino, serif; font-size: 15px; line-height: 21.5599994659424px;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-0FBSjZvUMlo/VHL7rpZu5zI/AAAAAAAAFGk/acpMnZ4W-DU/s1600/48.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://1.bp.blogspot.com/-0FBSjZvUMlo/VHL7rpZu5zI/AAAAAAAAFGk/acpMnZ4W-DU/s1600/48.png" height="170" width="320" /></a></div>
<br />
<br />
2) Create a new connection<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-l0tUKnpunRA/VHL7ruRIxhI/AAAAAAAAFGo/oUckwscZENk/s1600/49.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://1.bp.blogspot.com/-l0tUKnpunRA/VHL7ruRIxhI/AAAAAAAAFGo/oUckwscZENk/s1600/49.png" /></a></div>
<br />
3) Choose Java DB (Derby) from Connection Type drop down and give connection Name<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-6nnSD2VGYEc/VHL7rkA7K3I/AAAAAAAAFGs/9cmR4kR5B7I/s1600/50.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://2.bp.blogspot.com/-6nnSD2VGYEc/VHL7rkA7K3I/AAAAAAAAFGs/9cmR4kR5B7I/s1600/50.png" height="306" width="320" /></a></div>
<br />
4) Automatically all details will be filled up, but you need to choose the Library. Click on the glass search window and choose Java DB JDBC Driver. Click Ok<br />
<span style="background-color: #fff9ee; color: #222222; font-family: Georgia, Utopia, 'Palatino Linotype', Palatino, serif; font-size: 15px; line-height: 21.5599994659424px;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-6mrWwk7eenA/VHL6TYMuOZI/AAAAAAAAFGY/dFLNa10nPhg/s1600/51.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://2.bp.blogspot.com/-6mrWwk7eenA/VHL6TYMuOZI/AAAAAAAAFGY/dFLNa10nPhg/s1600/51.png" height="293" width="320" /></a></div>
<br />
5) Test the connection<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-XC9aH_UofeA/VHL59yWviaI/AAAAAAAAFGA/il6SCrEvCyE/s1600/52.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://2.bp.blogspot.com/-XC9aH_UofeA/VHL59yWviaI/AAAAAAAAFGA/il6SCrEvCyE/s1600/52.png" height="306" width="320" /></a></div>
<br />
6) Now you can see the connection in Jdeveloper. Its good to go now<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-DxkwFDFLxh8/VHL86s42nvI/AAAAAAAAFG8/ST-PnEaJzuo/s1600/53.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://2.bp.blogspot.com/-DxkwFDFLxh8/VHL86s42nvI/AAAAAAAAFG8/ST-PnEaJzuo/s1600/53.png" /></a></div>
<br />
<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
</div>
Abhishek Saurabhhttp://www.blogger.com/profile/17557091703885116383noreply@blogger.com1tag:blogger.com,1999:blog-1624436388461172643.post-21690197445456035932014-11-21T19:18:00.001+05:302014-11-21T19:29:56.093+05:30Updating SOA 12c Domain for MFT<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Introduction:</b><br />
This is the last step required for MFT. After this is complete you can go ahead and use MFT.<br />
<br />
<b>Prerequisites:</b><br />
You should complete steps specified earlier such as SOA 12c Installation with Default local server setup, Database Installation, MFT Installation and RCU creation.<br />
<br />
<b>Steps for Updating Domain:</b><br />
<br />
1) Open cmd for Administrator and navigate to ORACLE_HOME\oracle_common\common\bin, as shown below.<br />
<br />
Note: ORACLE_HOME is the location where your SOA12c is installed.<br />
<br />
2) You need to set JVM argument as -<br />
<br />
SET CONFIG_JVM_ARGS=-Dcom.oracle.cie.config.showProfile=true<br />
<br />
3) Then run config.cmd<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-B6n_Jk5_7tg/VG8-kwHh4JI/AAAAAAAAFEY/wxnLzH-IPdg/s1600/21.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://4.bp.blogspot.com/-B6n_Jk5_7tg/VG8-kwHh4JI/AAAAAAAAFEY/wxnLzH-IPdg/s1600/21.png" height="48" width="320" /></a></div>
<br />
4) This will open Wizard, as you have already a domain setup (your local SOA server), we will update the existing domain for MFT. Make sure the Domain location is your local server location. Choose Next<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-N_F4k96dwT0/VG8-k-LhtHI/AAAAAAAAFEc/8icemayPnnc/s1600/22.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://2.bp.blogspot.com/-N_F4k96dwT0/VG8-k-LhtHI/AAAAAAAAFEc/8icemayPnnc/s1600/22.png" height="239" width="320" /></a></div>
<br />
5) Choose the check boxes as shown below for MFT, click Next<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-8oxynuYZ9W0/VG8-k_-iyBI/AAAAAAAAFFg/JCfL3jwfIE8/s1600/23.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://4.bp.blogspot.com/-8oxynuYZ9W0/VG8-k_-iyBI/AAAAAAAAFFg/JCfL3jwfIE8/s1600/23.png" height="238" width="320" /></a></div>
<br />
6) Here choose AutoConfiguration option as RCU<br />
Vendor: Oracle<br />
DBMS/Service: This will be the SID which you had used during Database installation time. IN my case this was orcl.<br />
Give Hostname, Port, User name and password<br />
Schema Owner: It should be the Schema which was created during RCU creation. In my case it was DEV_STB and then provide schema password.<br />
<br />
Once this is done press Get RCU Configuration. Once it is all OK, Click Next<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-psNk6Yvv1eE/VG8-lUFppMI/AAAAAAAAFEg/r7SeW4nGbks/s1600/24.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://2.bp.blogspot.com/-psNk6Yvv1eE/VG8-lUFppMI/AAAAAAAAFEg/r7SeW4nGbks/s1600/24.png" height="241" width="320" /></a></div>
<br />
7) Choose MFT specific check boxes as specified in screen shot, Click Next<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-58MWASeF33M/VG8-lnp32kI/AAAAAAAAFEo/Mif1DiN1o4k/s1600/25.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-58MWASeF33M/VG8-lnp32kI/AAAAAAAAFEo/Mif1DiN1o4k/s1600/25.png" height="241" width="320" /></a></div>
<br />
8) Choose as per the Screen shot below, Click Next<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-31TyDL5X4Os/VG8-l9_4foI/AAAAAAAAFEs/0j1rDNu2EDw/s1600/26.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-31TyDL5X4Os/VG8-l9_4foI/AAAAAAAAFEs/0j1rDNu2EDw/s1600/26.png" height="238" width="320" /></a></div>
<br />
9) Leave this page as it is and Click Next<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-4wlXI2xgSSM/VG8-mBLUH8I/AAAAAAAAFE0/X2uikhOi-eg/s1600/27.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-4wlXI2xgSSM/VG8-mBLUH8I/AAAAAAAAFE0/X2uikhOi-eg/s1600/27.png" height="240" width="320" /></a></div>
<br />
10) Now click Update on the summary page<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-HzVSBgGC3LU/VG8-matqN-I/AAAAAAAAFE4/lRFwhYJ48ic/s1600/28.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://1.bp.blogspot.com/-HzVSBgGC3LU/VG8-matqN-I/AAAAAAAAFE4/lRFwhYJ48ic/s1600/28.png" height="242" width="320" /></a></div>
<br />
11) This will update the existing domain, and shows its progress, Click Next once done<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-lT3n0ZtBFmM/VG8-ml4UbbI/AAAAAAAAFFA/udatwf-8x9M/s1600/29.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://2.bp.blogspot.com/-lT3n0ZtBFmM/VG8-ml4UbbI/AAAAAAAAFFA/udatwf-8x9M/s1600/29.png" height="241" width="320" /></a></div>
<br />
12) Thats all, click Finish.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-wN9RXDRHzos/VG8-mwXppdI/AAAAAAAAFFE/DG67c71VIzM/s1600/30.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://4.bp.blogspot.com/-wN9RXDRHzos/VG8-mwXppdI/AAAAAAAAFFE/DG67c71VIzM/s1600/30.png" height="238" width="320" /></a></div>
<br />
<br />
So that's it. You are all good to use MFT.<br />
<br />
You can open MFT Console using URL: http://hostname:port/mftconsole<br />
You can change Hostname & port according to your environment setup. By default for local system port will be 7101<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-3dGDpu4FmQI/VG9FVKZNQZI/AAAAAAAAFFw/fdLPTxompDk/s1600/31.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://4.bp.blogspot.com/-3dGDpu4FmQI/VG9FVKZNQZI/AAAAAAAAFFw/fdLPTxompDk/s1600/31.png" height="101" width="320" /></a></div>
<br />
<br />
<br /></div>
Abhishek Saurabhhttp://www.blogger.com/profile/17557091703885116383noreply@blogger.com0tag:blogger.com,1999:blog-1624436388461172643.post-59151194311946690822014-11-21T18:46:00.000+05:302014-12-12T15:04:15.473+05:30RCU Creation for Oracle 12c MFT<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Introduction:</b><br />
This is continuation of my previous blog which is about MFT installation. We have already covered Database 12c installation and MFT installation, now lets focus on RCU creation for MFT.<br />
<br />
<b>Step by Step:</b><br />
<br />
RCU file resides under your ORACLE_HOME<oracle_home>\oracle_common\bin</oracle_home><br />
ORACLE_HOME here is place where your SOA is installed<br />
<br />
1) To start with, first of all you will have to set your Java Jdk Home and Oracle Home (Oracle Database home). I have configured it based on the plave where I had installed Java and Database, as shown in below screen shot.<br />
<br />
2) Navigate to ORACLE_HOME\oracle_common\bin and run rcu.bat (for Windows)<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-eoG3R0MD0nY/VG84E3LnN_I/AAAAAAAAFC4/kelG_gbToSA/s1600/1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-eoG3R0MD0nY/VG84E3LnN_I/AAAAAAAAFC4/kelG_gbToSA/s1600/1.png" height="60" width="320" /></a></div>
<br />
3) This will open RCU welcome window as shown below, Click Next<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-ihNLfAF46B0/VG84FpbXIBI/AAAAAAAAFDE/_alMx2SZSWw/s1600/2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://4.bp.blogspot.com/-ihNLfAF46B0/VG84FpbXIBI/AAAAAAAAFDE/_alMx2SZSWw/s1600/2.png" height="238" width="320" /></a></div>
<br />
4) This window you will have to provide your database details, like port, SID, sys username and its password (which you have given during Database installation). Choose Role as Sysdba and click Next<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-9obm_wwtKAQ/VG84FvGpB7I/AAAAAAAAFDI/nZuaN3evUwk/s1600/3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://1.bp.blogspot.com/-9obm_wwtKAQ/VG84FvGpB7I/AAAAAAAAFDI/nZuaN3evUwk/s1600/3.png" height="240" width="320" /></a></div>
<br />
5) DEV_MFT for MFT RCU is selected, Click Next. After this Prerequisite check window will appear, click Ok once complete<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-9ge6jfw8P8w/VG84F0-8-oI/AAAAAAAAFD4/s6-OG1MICnU/s1600/4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://2.bp.blogspot.com/-9ge6jfw8P8w/VG84F0-8-oI/AAAAAAAAFD4/s6-OG1MICnU/s1600/4.png" height="235" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-OfMghZ6vTOQ/VG84GCcz5rI/AAAAAAAAFDM/4yLGMH9lrf8/s1600/5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://2.bp.blogspot.com/-OfMghZ6vTOQ/VG84GCcz5rI/AAAAAAAAFDM/4yLGMH9lrf8/s1600/5.png" height="115" width="320" /></a></div>
<br />
6) Choose Schema Password, Click Next<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-9YUtfoxNicM/VG84GYVOzlI/AAAAAAAAFDQ/ebmOyPD1C2k/s1600/6.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-9YUtfoxNicM/VG84GYVOzlI/AAAAAAAAFDQ/ebmOyPD1C2k/s1600/6.png" height="237" width="320" /></a></div>
<br />
7) Click Next, Click OK on confirmation window, which will then create Tablespace<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-r89287V6g9M/VG84Gqx_XMI/AAAAAAAAFDo/k-J_xcNX7ZA/s1600/7.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://4.bp.blogspot.com/-r89287V6g9M/VG84Gqx_XMI/AAAAAAAAFDo/k-J_xcNX7ZA/s1600/7.png" height="240" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-IvHLIzkeHNc/VG84G0LCVhI/AAAAAAAAFDY/QNe351Qa62k/s1600/8.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://1.bp.blogspot.com/-IvHLIzkeHNc/VG84G0LCVhI/AAAAAAAAFDY/QNe351Qa62k/s1600/8.png" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-VhzF7VGl5uw/VG84HIZ65_I/AAAAAAAAFDg/Y1LBhtyGfw4/s1600/9.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://1.bp.blogspot.com/-VhzF7VGl5uw/VG84HIZ65_I/AAAAAAAAFDg/Y1LBhtyGfw4/s1600/9.png" height="117" width="320" /></a></div>
<br />
8) Once Summary is displayed, verify the details (keep a screen shot of this window, it will be required during MFT Domain creation), and Click on Create<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-CtIqkPZ9NfI/VG84E4UphWI/AAAAAAAAFDA/6Xo4Au314oI/s1600/10.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://4.bp.blogspot.com/-CtIqkPZ9NfI/VG84E4UphWI/AAAAAAAAFDA/6Xo4Au314oI/s1600/10.png" height="240" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-0G577l-mwMQ/VG84E5ZkyuI/AAAAAAAAFC8/0i7o13pplFM/s1600/11.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://4.bp.blogspot.com/-0G577l-mwMQ/VG84E5ZkyuI/AAAAAAAAFC8/0i7o13pplFM/s1600/11.png" height="128" width="320" /></a></div>
<br />
Once this is complete, Completion Summary page will appear showing status of the RCU run. Choose Close button, RCU run is completed successfully.<br />
<br />
Now refer to my next blog which will talk about updating the existing Domain for MFT.<br />
<br /></div>
Abhishek Saurabhhttp://www.blogger.com/profile/17557091703885116383noreply@blogger.com0tag:blogger.com,1999:blog-1624436388461172643.post-35634986141401689832014-11-20T20:31:00.000+05:302014-12-12T13:12:22.438+05:30Oracle 12c MFT Installation<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Introduction:</b><br />
Oracle MFT is new featured product which is used for File transfers. You can transfer files, Encrypt/Decrypt, Compress/Decompress, Schedule, Archive and do much more.<br />
<br />
This blog is in continuation of my last blog where Oracle Database 12c installation steps were shown.<br />
Lets explore steps for Installing Oracle MFT.<br />
<br />
<b>Installation Steps:</b><br />
We will be installing MFT for local SOA 12c setup i.e. local server domain which got created as a result of local SOA 12c installation along with JDeveloper. Before proceeding make sure that your local domain is Stopped and close Jdeveloper.<br />
<br />
1) If you have not yet downloaded the installation file, download it from Oracle site:<br />
http://www.oracle.com/technetwork/middleware/mft/downloads/index.html<br />
<br />
2) It will download fmw_12.1.3.0.0_mft_Disk1_1of1.zip file, Unzip this file, it will contain a jar file with name fmw_12.1.3.0.0_mft.jar<br />
<br />
<b>Caution</b>: If your Jdeveloper is already open and SOA server is running, it is recommended to Stop SOA Server and close JDeveloper before going for MFT Installation.<br />
<br />
3) Open cmd in Administrator mode, and navigate to your Java jdk location and run the jar file<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-oxgUIiR1Qsg/VG38spzir0I/AAAAAAAAFCQ/ayHeU59immk/s1600/41.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://1.bp.blogspot.com/-oxgUIiR1Qsg/VG38spzir0I/AAAAAAAAFCQ/ayHeU59immk/s1600/41.JPG" height="43" width="400" /></a></div>
<br />
4) This will open Oracle Universal Installer, <br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-5cryguzQyKE/VG4BbQZR2xI/AAAAAAAAFCY/kmyfvConVfg/s1600/42.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://1.bp.blogspot.com/-5cryguzQyKE/VG4BbQZR2xI/AAAAAAAAFCY/kmyfvConVfg/s1600/42.png" height="206" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-uk6t7YWr5oI/VG4BdXhGFoI/AAAAAAAAFCk/kO8Yy2SSbvI/s1600/43.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://4.bp.blogspot.com/-uk6t7YWr5oI/VG4BdXhGFoI/AAAAAAAAFCk/kO8Yy2SSbvI/s1600/43.png" height="249" width="320" /></a></div>
<br />
<br />
5) Select Oracle Home, This is same home were SOA 12c is installed.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-0fGzExWXmcE/VG4BdepoOiI/AAAAAAAAFCg/mOhX0fB8lY8/s1600/44.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-0fGzExWXmcE/VG4BdepoOiI/AAAAAAAAFCg/mOhX0fB8lY8/s1600/44.png" height="250" width="320" /></a></div>
<br />
6) Now it will be simply Next -- Install -- Next -- Finish<br />
<br />
Now MFT is installed, you can start your Jdeveloper but wait there are many more things to do. It is not yet ready for use. Lets go for RCU installation.</div>
Abhishek Saurabhhttp://www.blogger.com/profile/17557091703885116383noreply@blogger.com0tag:blogger.com,1999:blog-1624436388461172643.post-18970528069449520512014-11-20T19:46:00.000+05:302014-11-20T19:48:11.449+05:30Installing Oracle Database 12c for SOA & MFT<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Introduction:</b><br />
This is with reference to my last post of Installation of MFT, for which Oracle Database is required. This blog aims at explaining the steps for Installation Oracle Database 12c, which will be used by Oracle MFT later.<br />
<br />
Steps for Installation:<br />
<br />
1) Download Oracle 12c from following location:<br />
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/database12c-win64-download-1968077.html<br />
<br />
2) There will be two files downloaded, unzip those files<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-kvE_TxjJVN0/VG3t96NFnEI/AAAAAAAAE_0/ppVJ0omTy0w/s1600/21.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-kvE_TxjJVN0/VG3t96NFnEI/AAAAAAAAE_0/ppVJ0omTy0w/s1600/21.png" height="43" width="400" /></a></div>
3) Open command line, choose Run as Administrator<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-M3CMNvCj1zo/VG3uJlLj3NI/AAAAAAAAE_8/yLOeCBMz1bo/s1600/1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-M3CMNvCj1zo/VG3uJlLj3NI/AAAAAAAAE_8/yLOeCBMz1bo/s1600/1.png" /></a></div>
<br />
<br />
4) Now navigate to the location of Unzipped file and run Setup.exe<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-z-daMHwacm4/VG3xAQ74sxI/AAAAAAAAFAI/gf4Yqle0q_g/s1600/22.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://4.bp.blogspot.com/-z-daMHwacm4/VG3xAQ74sxI/AAAAAAAAFAI/gf4Yqle0q_g/s1600/22.png" height="43" width="400" /></a></div>
<br />
<br />
<br />
5) This will open the Universal installer<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-P4oFqzr8U60/VG34Ero9RPI/AAAAAAAAFCE/A_F66QlX7ak/s1600/23.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-P4oFqzr8U60/VG34Ero9RPI/AAAAAAAAFCE/A_F66QlX7ak/s1600/23.png" height="181" width="320" /></a></div>
<br />
6) Follow the installation window, step wise as shown in below screen shots<br />
<br />
(Note: I was running this for my learning purpose, so I have tried skipping some of the steps which were recommended by Oracle. But as it was for my local system, I choose quick and dirty way. Its your choice, you can go by the recommended steps)<br />
<br />
Below are some quick and dirty steps of its installation, don't worry this will not impact running of your Database, anyhow this is done for learning purpose.<br />
<br />
a) Uncheck the box and click Next<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-1RLqsJuZPLo/VG3yqW6NeDI/AAAAAAAAFAU/EV2Kt4136tU/s1600/24.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-1RLqsJuZPLo/VG3yqW6NeDI/AAAAAAAAFAU/EV2Kt4136tU/s1600/24.png" height="237" width="320" /></a></div>
<br />
b) There will be Warning, just Click Yes and proceed<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-3-rTrvo8bxs/VG3yutGSWPI/AAAAAAAAFAc/LSiZjq1XbR4/s1600/25.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://1.bp.blogspot.com/-3-rTrvo8bxs/VG3yutGSWPI/AAAAAAAAFAc/LSiZjq1XbR4/s1600/25.png" height="174" width="320" /></a></div>
<br />
c) Select Skip software updates Radio button, click Next<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-y4aCOr5RJGo/VG3y066DVzI/AAAAAAAAFAk/pArMox-Sc4A/s1600/26.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://4.bp.blogspot.com/-y4aCOr5RJGo/VG3y066DVzI/AAAAAAAAFAk/pArMox-Sc4A/s1600/26.png" height="238" width="320" /></a></div>
<br />
d) As we will Create and will have to configure the database, choose the first option and click Next<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-vZJIwxkg6QQ/VG3y42uXOEI/AAAAAAAAFAs/0_fkgJ-3GZ8/s1600/27.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://4.bp.blogspot.com/-vZJIwxkg6QQ/VG3y42uXOEI/AAAAAAAAFAs/0_fkgJ-3GZ8/s1600/27.png" height="238" width="320" /></a></div>
<br />
e) Choose Desktop class and click Next<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-3_MNHi60YwI/VG3y-3T-zXI/AAAAAAAAFB0/HQy8xXIVTmo/s1600/28.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://4.bp.blogspot.com/-3_MNHi60YwI/VG3y-3T-zXI/AAAAAAAAFB0/HQy8xXIVTmo/s1600/28.png" height="239" width="320" /></a></div>
<br />
f) Choose Use Windows Built-in Account and click Next (You can even use the first option)<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-NRAqgV_4Bic/VG3y_B8o40I/AAAAAAAAFA4/WAstpzywClE/s1600/29.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-NRAqgV_4Bic/VG3y_B8o40I/AAAAAAAAFA4/WAstpzywClE/s1600/29.png" height="237" width="320" /></a></div>
<br />
g) You will will again prompted with message box, Click Yes and Next<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-izl24DLWtAU/VG3y-7uXL5I/AAAAAAAAFA0/ojLDRnjqqqE/s1600/30.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-izl24DLWtAU/VG3y-7uXL5I/AAAAAAAAFA0/ojLDRnjqqqE/s1600/30.png" height="149" width="320" /></a></div>
<br />
h) This is an <b>important </b>page, you need to do some changes here. By default Oracle base, edition, character set will be different. I have selected my own folder in Oracle base (once you provide this, automatically Software location and Database file location will get updated).<br />
<br />
As my Database usage is going to be minimal, I selected Personal Edition (which takes less space), and Character set as AL32UTF8. Choose proper SID name and its password. (Password should be as per Oracle standard, but I have given my own short password, there will be a warning message coming but you can neglect it). Click Next<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-ABuY3wX-vnc/VG3y_TGv9FI/AAAAAAAAFA8/_B4qV60lBbM/s1600/31.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://4.bp.blogspot.com/-ABuY3wX-vnc/VG3y_TGv9FI/AAAAAAAAFA8/_B4qV60lBbM/s1600/31.png" height="211" width="320" /></a></div>
<br />
i) Click Next and then press Install<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-pk--ENKB4PQ/VG3y_gpO_bI/AAAAAAAAFBA/JMuok78jwTc/s1600/32.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-pk--ENKB4PQ/VG3y_gpO_bI/AAAAAAAAFBA/JMuok78jwTc/s1600/32.png" height="186" width="320" /></a></div>
<br />
j) Click Next<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-UnNHpmDU7a4/VG3y_mwSpBI/AAAAAAAAFBE/q6kGSvbhqJE/s1600/33.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://4.bp.blogspot.com/-UnNHpmDU7a4/VG3y_mwSpBI/AAAAAAAAFBE/q6kGSvbhqJE/s1600/33.png" height="238" width="320" /></a></div>
<br />
k) Click Next, here once you click Next Password Management screen will appear. You can either just press Ok or press the Password Management button to set passwords for some of the Schemas like sys, system, scott etc. Its your choice after all.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-hiiqmY4-STA/VG3y__J5ZuI/AAAAAAAAFBI/htxEZP23mjA/s1600/34.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://4.bp.blogspot.com/-hiiqmY4-STA/VG3y__J5ZuI/AAAAAAAAFBI/htxEZP23mjA/s1600/34.png" height="224" width="320" /></a></div>
<br />
l) Click Next<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-X1zwDJJI_Js/VG3zAPEGeZI/AAAAAAAAFBM/76ZzwsjPUzM/s1600/36.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-X1zwDJJI_Js/VG3zAPEGeZI/AAAAAAAAFBM/76ZzwsjPUzM/s1600/36.png" height="239" width="320" /></a></div>
<br />
m) And that's it.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-Mr3ZHBcYGXE/VG3zAZEzNxI/AAAAAAAAFBQ/A8WY9PEC2LY/s1600/37.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-Mr3ZHBcYGXE/VG3zAZEzNxI/AAAAAAAAFBQ/A8WY9PEC2LY/s1600/37.png" height="239" width="320" /></a></div>
<br />
Database 12c is all set and installed for use now.<br />
<div>
<br /></div>
</div>
Abhishek Saurabhhttp://www.blogger.com/profile/17557091703885116383noreply@blogger.com0tag:blogger.com,1999:blog-1624436388461172643.post-50238874453079064292014-11-20T18:53:00.001+05:302014-11-24T02:22:10.358+05:30Exploring MFT in 12c<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Introduction:</b><br />
I have been doing some good amount of work on Oracle 12c new product MFT - 'Managed File Transfer' recently. Let me share the experiences with you all. I will start giving details on its installation and then will share some good posts on its working<br />
<br />
<b>To Start:</b><br />
Before starting MFT installation, you need to have certain products already installed on your system.<br />
Make sure you have following installed:<br />
1) Java 7<br />
2) SOA 12c along with Domain creation (Refer my blog on its installation)<br />
3) Oracle Database (I have used Oracle 12c as Database)<br />
4) RCU for MFT (This actually can be done after MFT installation also)<br />
<br />
To cover the whole MFT installation to make it ready for use, I am going to write separate blogs which will contain steps for<br />
1) <a href="http://abhishek-soablog.blogspot.no/2014/11/installing-oracle-database-12c-for-soa.html" target="_blank">Installing Oracle Database 12c</a><br />
2) <a href="http://abhishek-soablog.blogspot.no/2014/11/oracle-12c-mft-installation.html" target="_blank">Installing MFT</a><br />
3) <a href="http://abhishek-soablog.blogspot.no/2014/11/rcu-creation-for-oracle-12c-mft.html" target="_blank">Running RCU on Database for MFT</a><br />
4) <a href="http://abhishek-soablog.blogspot.no/2014/11/updating-soa-12c-domain-for-mft.html" target="_blank">Updating your local development Domain for MFT</a><br />
<br />
By covering above 4 steps you will ready with MFT.<br />
<br />
You can also go for creation of seperate domain for SOA and MFT, although it is not required, but you can learn on how to setup the environment. This will be optional step.<br />
<br />
So, keep watching the space for my next blog entry.<br />
<br />
<br /></div>
Abhishek Saurabhhttp://www.blogger.com/profile/17557091703885116383noreply@blogger.com0tag:blogger.com,1999:blog-1624436388461172643.post-81173715878351502072014-11-19T20:13:00.001+05:302014-11-19T20:14:18.861+05:30Oracle 12c "Composite Lazy Loading" Feature<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Introduction:</b><br />
I had struggled in the past till 11g, where I had seen Server start up taking time when I have more numbers of composites deployed on the server.<br />
<br />
With SOA 12c, Oracle has introduced a new feature known as 'Composite Lazy loading'. This is one of the nice features, in which any server initialization tasks such as loading components and resources like WSDLs and XSDs, are loaded later at first-request time when they are needed, which means that server will only create in-memory java models and MBeans. It improves server startup time when there is a large number of composites deployed on it.<br />
<br />
<b>Details:</b><br />
Composite Lazy Loading can be configured at two levels - 1) Domain 2) Component Level<br />
<br />
<u>Lazy Loading at Domain Level:</u><br />
This setting can be disabled/enabled from System MBean Browser in FMW EM console. Follow below steps:<br />
1. Login to EM Console, right-click on the domain you want to tune and select System MBean Browser from the drop-down menu<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-n6F5p7IfQrg/VGyrFVVBh8I/AAAAAAAAE_M/z_q5iQL5ZRQ/s1600/13.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://1.bp.blogspot.com/-n6F5p7IfQrg/VGyrFVVBh8I/AAAAAAAAE_M/z_q5iQL5ZRQ/s1600/13.png" height="320" width="185" /></a></div>
<br />
<br />
2. In the System MBean Browser folder structure, navigate through: Application Defined MBeans -- oracle.as.soainfra.config -- Server: ServerName -- SoaInfraConfig -- soa-infra<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-aWg_7h8V3r0/VGyrpm-6ZBI/AAAAAAAAE_U/N3HIxGQuLCg/s1600/14.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://1.bp.blogspot.com/-aWg_7h8V3r0/VGyrpm-6ZBI/AAAAAAAAE_U/N3HIxGQuLCg/s1600/14.png" height="320" width="172" /></a></div>
<br />
<br />
3. When you click on soa-infra, its attributes will be listed in on the right. Look for the CompositeLazyLoading attribute and click on it. You can set the value to true to enable it or<br />
false to disable it<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-nNAa0x95uYM/VGyr2Tcda7I/AAAAAAAAE_c/g7eH2n7_1CI/s1600/15.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-nNAa0x95uYM/VGyr2Tcda7I/AAAAAAAAE_c/g7eH2n7_1CI/s1600/15.png" height="133" width="320" /></a></div>
<br />
<br />
4. Click Apply and restart the server for changes to take effect.<br />
<br />
<u>Lazy Loading at the Component level:</u><br />
To enable/disable it at component level, you need to follow below steps:<br />
1. Open composite.xml file<br />
2. Add the new property lazyLoading="false" to override the default behaviour at the domain level, as shown in screen shot<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-rLu-fdip2O4/VGysQx1yRKI/AAAAAAAAE_k/gt70MinLq8I/s1600/16.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://2.bp.blogspot.com/-rLu-fdip2O4/VGysQx1yRKI/AAAAAAAAE_k/gt70MinLq8I/s1600/16.png" height="136" width="320" /></a></div>
<br />
<br />
3. Redeploy your code<br />
<br />
By default, composites will inherit the lazy loading setting from the domain level.</div>
Abhishek Saurabhhttp://www.blogger.com/profile/17557091703885116383noreply@blogger.com0tag:blogger.com,1999:blog-1624436388461172643.post-7088495778625246822014-11-14T20:13:00.001+05:302014-12-12T12:22:48.085+05:30Installing Oracle 12c<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal">
<b><span style="font-family: Calibri, sans-serif; font-size: 11pt; line-height: 115%;">Introduction:</span></b><span style="color: #333333; font-family: "Trebuchet MS","sans-serif"; font-size: 10.0pt; line-height: 115%;"><br /></span><br />
In continuation to my last blog posted on 6th Oct 2014 on Oracle 12c, this article will detail the steps of installation which will bundle JDeveloper, Weblogic, SOA, OSB, Java DB (Derby).<br />
Note: This installation was carried out on WIndows 7 for Studio Edition version 12.1.3.0.0<br />
<span style="background-attachment: initial; background-clip: initial; background-color: #eeeecc; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial;"><span style="font-family: Calibri, sans-serif;"><span style="font-size: 15px; line-height: 16.8666667938232px;"><br /></span></span>
</span><b><span style="font-family: Calibri, sans-serif; font-size: 11pt; line-height: 115%;">Prerequisites to Kick-Start:</span></b><span style="color: #333333; font-family: "Trebuchet MS","sans-serif"; font-size: 10.0pt; line-height: 115%;"><span style="background: #EEEECC;"><br /></span></span><br />
<div class="MsoNormal">
1) JAVA 7: You need Java 7 installed on
your system. I would recommend to use Java 7 for now, with Java 8 we did faced
some installation issues. If it is not installed yet, you can refer to below
link to get hold of the software (File name: jdk-7u67-windows-x64.exe): http://www.oracle.com/technetwork/java/javase/downloads/index.html<br />
<br />
2) SOA 12c: You need to have the software for SOA 12c (fmw_12.1.3.0.0_soaqs_Disk1_1of1.zip)
installation. You can download this from below location: <a href="http://www.oracle.com/technetwork/middleware/soasuite/downloads/index.html?ssSourceSiteId=opn"><span style="color: black; text-decoration: none; text-underline: none;">http://www.oracle.com/technetwork/middleware/soasuite/downloads/index.html?ssSourceSiteId=opn</span></a><o:p></o:p></div>
<div class="MsoNormal">
3) Database: This is OPTIONAL. Oracle
12c comes along with default Java DB (Derby) as Database. So this is not
required. I had to explore SOA 12c and MFT, hence I have gone for Derby and
local 12c Database. Choice is yours. You can download this from Oracle site,
two files will be downloaded i.e. winx64_12c_database_1of2.zip and winx64_12c_database_2of2.zip.<o:p></o:p></div>
<br />
<div class="MsoNormal">
4) You should have enough RAM like 8GB
or 16GB, 64 bit configured with good system specifications<o:p></o:p></div>
</div>
<div class="MsoNormal">
<span style="background: #EEEECC; color: #333333; font-family: "Trebuchet MS","sans-serif"; font-size: 10.0pt; line-height: 115%;"><br /></span></div>
<br />
<div class="MsoNormal">
<div class="MsoNormal">
<b>Steps of Installation:<o:p></o:p></b></div>
<span style="text-indent: -18pt;"><br /></span>
<span style="text-indent: -18pt;">1) Type cmd in start menu and once it
appears, right click and choose ‘Run as administrator’, as shown below</span><br />
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -18.0pt;">
<o:p></o:p></div>
</div>
<div class="MsoNormal">
<span style="background-color: #eeeecc; color: #333333; font-family: 'Trebuchet MS', sans-serif; font-size: 10pt; line-height: 115%;"><br /></span></div>
<div class="MsoNormal">
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-KlLpWlE3YbM/VGYFxvRGPLI/AAAAAAAAEcs/sTpDrXZFRCo/s1600/1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://2.bp.blogspot.com/-KlLpWlE3YbM/VGYFxvRGPLI/AAAAAAAAEcs/sTpDrXZFRCo/s1600/1.png" height="92" width="320" /></a></div>
<br />
2) <span style="text-indent: -18pt;">Once command prompt is opened, navigate
to your Java Jdk, as shown below</span><br />
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -18.0pt;">
<o:p></o:p></div>
<span style="background: rgb(238, 238, 204); color: #333333; font-family: 'Trebuchet MS', sans-serif; font-size: 10pt; line-height: 115%; text-indent: -18pt;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-iHemtDcizq8/VGYJ1YLJJEI/AAAAAAAAEdA/0XaLeTMy0Ws/s1600/2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-iHemtDcizq8/VGYJ1YLJJEI/AAAAAAAAEdA/0XaLeTMy0Ws/s1600/2.png" height="88" width="400" /></a></div>
<span style="background: rgb(238, 238, 204); color: #333333; font-family: 'Trebuchet MS', sans-serif; font-size: 10pt; line-height: 115%; text-indent: -18pt;"><br /></span>
<br />
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -18.0pt;">
<span style="background: #EEEECC; color: #333333; font-family: "Trebuchet MS","sans-serif"; font-size: 10.0pt; line-height: 115%;"><o:p></o:p></span></div>
<br />
3) <span style="text-indent: -18pt;">Navigate to the folder where your SOA
setup is. Extract the zip file, Copy the folder location, this will be handy
while giving command for installation</span><br />
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -18.0pt;">
<o:p></o:p></div>
<br />
4) <span style="text-indent: -18pt;">Go
back to Command prompt and type command as (make sure you are under
Java\jdk\bin): java –jar</span><br />
<span style="text-indent: -18pt;">Below Screenshot explains the same</span><br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-H5hMZqDvdYk/VGYKN8C9bMI/AAAAAAAAEdI/RpmTuZ7AiJ4/s1600/3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-H5hMZqDvdYk/VGYKN8C9bMI/AAAAAAAAEdI/RpmTuZ7AiJ4/s1600/3.png" height="45" width="400" /></a></div>
<div class="MsoListParagraphCxSpLast">
<span style="background: #EEEECC; color: #333333; font-family: "Trebuchet MS","sans-serif"; font-size: 10.0pt; line-height: 115%;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
This will open Quick Start Installer for 12c with Welcome page</div>
<div class="MsoListParagraphCxSpLast">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-sJsBY5OAWf8/VGYKy2eipzI/AAAAAAAAEdQ/kguP1v86jk4/s1600/4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-sJsBY5OAWf8/VGYKy2eipzI/AAAAAAAAEdQ/kguP1v86jk4/s1600/4.png" height="125" width="200" /></a></div>
<div class="MsoListParagraphCxSpLast">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-a8UH1wiVylc/VGYK6oW3QLI/AAAAAAAAEdY/SYcGam3JhCA/s1600/5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://1.bp.blogspot.com/-a8UH1wiVylc/VGYK6oW3QLI/AAAAAAAAEdY/SYcGam3JhCA/s1600/5.png" height="308" width="400" /></a></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Calibri, sans-serif; font-size: 11pt; line-height: 115%;"><br /></span>
<span style="font-family: Calibri, sans-serif; font-size: 11pt; line-height: 115%;">5) Click Next, it will ask you for Oracle Home location, i.e. the place where it will install</span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Calibri, sans-serif; font-size: 11pt; line-height: 115%;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-Eh_w867r4tE/VGYLJyZjg-I/AAAAAAAAEdg/tzOeh8c8oBY/s1600/6.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-Eh_w867r4tE/VGYLJyZjg-I/AAAAAAAAEdg/tzOeh8c8oBY/s1600/6.png" height="312" width="400" /></a></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Calibri, sans-serif; font-size: 11pt; line-height: 115%;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Calibri, sans-serif; font-size: 11pt; line-height: 115%;">6) If you follow the above screen shot Left hand panel, 3rd step is for checking Prerequisites, where it will check for operating system certifications and Java versions. Simply click next once it passes these checks</span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Calibri, sans-serif; font-size: 11pt; line-height: 115%;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Calibri, sans-serif; font-size: 11pt; line-height: 115%;">7) 4th step shows Installation Summary, i.e. what all feature it is going to Install. Simply click on <b>Install </b>button</span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Calibri, sans-serif; font-size: 11pt; line-height: 115%;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Calibri, sans-serif; font-size: 11pt; line-height: 115%;">8) 5th Step shows Installation Progress, where it will prepare, copy libraries and will run the setup. Once this completes it will show you success as</span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-Gj1WcW6jWk4/VGYMo7Ig3DI/AAAAAAAAEds/EX4EbZgByP4/s1600/7.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-Gj1WcW6jWk4/VGYMo7Ig3DI/AAAAAAAAEds/EX4EbZgByP4/s1600/7.png" height="239" width="320" /></a></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Calibri, sans-serif; font-size: 11pt; line-height: 115%;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Calibri, sans-serif; font-size: 11pt; line-height: 115%;">9) Click Next and it will show you the final Page as below. Unckeck Start Jdeveloper and click Finish.</span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-OVF7fD1laaA/VGYMz5TdSBI/AAAAAAAAEd0/liPxtB7hWUU/s1600/8.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-OVF7fD1laaA/VGYMz5TdSBI/AAAAAAAAEd0/liPxtB7hWUU/s1600/8.png" height="216" width="320" /></a></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Calibri, sans-serif; font-size: 11pt; line-height: 115%;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Calibri, sans-serif; font-size: 11pt; line-height: 115%;"><u>Word of Advice:</u> On the final page if you see below, there is a check box for Starting Jdeveloper. I would recommend to uncheck that for a moment. We will start it once configurations are done</span><br />
<span style="font-family: Calibri, sans-serif; font-size: 11pt; line-height: 115%;"><br /></span>
<span style="font-family: Calibri, sans-serif; font-size: 11pt; line-height: 115%;"><b>Steps for Local Domain Setup</b></span></div>
<div class="MsoListParagraphCxSpLast">
<b><span style="background: rgb(238, 238, 204); color: #333333; font-family: "Trebuchet MS","sans-serif"; font-size: 10pt; line-height: 15.3333320617676px;"><br /></span></b></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
1) If you Start Jdeveloper and then
start the server, by default it creates your domain under hidden folder:<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
C:\Users\<your username="">\AppData\Roaming\JDeveloper\system11.1.1.7.40.64.93\DefaultDomain<o:p></o:p></your></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
This will be a problem. I would
recommend to have your domain in same place, where your Oracle Home is.<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoListParagraphCxSpLast">
</div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
2) To do the same, set the System
Environment Variable. Goto Environment Variable (Computer -Properties -Advanced
system settings -Advanced -Environment Variables -System Variables)<o:p></o:p></div>
<div class="MsoListParagraphCxSpLast">
<span style="background-attachment: initial; background-clip: initial; background-color: #eeeecc; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #333333; font-family: Trebuchet MS, sans-serif; font-size: xx-small; line-height: 15.3333320617676px;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-0pB_M9c00ck/VGYQNdDSFNI/AAAAAAAAEeA/ztv_HesEqwY/s1600/9.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://2.bp.blogspot.com/-0pB_M9c00ck/VGYQNdDSFNI/AAAAAAAAEeA/ztv_HesEqwY/s1600/9.png" height="138" width="320" /></a></div>
<div class="MsoListParagraphCxSpLast">
<span style="background-attachment: initial; background-clip: initial; background-color: #eeeecc; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #333333; font-family: Trebuchet MS, sans-serif; font-size: xx-small; line-height: 15.3333320617676px;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="background-attachment: initial; background-clip: initial; background-color: #eeeecc; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #333333; font-family: Trebuchet MS, sans-serif; font-size: xx-small; line-height: 15.3333320617676px;"><br /></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Create folder like user_projects\domains under OracleWls_Home. In the Variable value give the same folder path value as OracleWls_Home<oracle_home>\user_projects\domains<o:p></o:p></oracle_home></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Once this is set, means now whenever
you will start Jdeveloper server, it will by default create the domain under
your Oracle Home<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
3) Save it and naviagte to open
Jdeveloper. Your Jdeveloper will be
under <oracle_home>\jdeveloper\jdeveloper.exe<o:p></o:p></oracle_home></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoListParagraphCxSpLast">
</div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
4) Once Jdeveloper is opened, Navigate
to Window - Application Servers<o:p></o:p></div>
<div class="MsoListParagraphCxSpLast">
<span style="background-color: #eeeecc; color: #333333; font-family: 'Trebuchet MS', sans-serif; font-size: x-small; line-height: 15.3333320617676px;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-6TDcYakeFQM/VGYScdd_emI/AAAAAAAAEeM/0brG089jQVs/s1600/10.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://2.bp.blogspot.com/-6TDcYakeFQM/VGYScdd_emI/AAAAAAAAEeM/0brG089jQVs/s1600/10.png" height="39" width="320" /></a></div>
<div class="MsoListParagraphCxSpLast">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
5) It will open a Tab on left hand
side, right click on IntegratedWeblogicServer and start the server. It will by
default create the domain. For first time set up it will ask you to enter
weblogic details<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoListParagraphCxSpLast">
</div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Enter the password which you will be
using for all Weblogic, EM operations.<o:p></o:p></div>
<div class="MsoListParagraphCxSpLast">
<span style="color: #333333; font-family: Trebuchet MS, sans-serif; font-size: x-small;"><span style="background-color: #eeeecc; line-height: 15.3333320617676px;"><br /></span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-BzoFOEnyDDg/VGYTBbpfMvI/AAAAAAAAEeU/J6F8XPnILeI/s1600/11.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://2.bp.blogspot.com/-BzoFOEnyDDg/VGYTBbpfMvI/AAAAAAAAEeU/J6F8XPnILeI/s1600/11.png" height="269" width="320" /></a></div>
<div class="MsoListParagraphCxSpLast">
<span style="color: #333333; font-family: Trebuchet MS, sans-serif; font-size: x-small;"><span style="background-color: #eeeecc; line-height: 15.3333320617676px;"><br /></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
6) Once done, click OK and you are all
good to go.<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
<div class="MsoListParagraphCxSpLast">
</div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
7) Whenever you want to switch
off/bring down your server, just right click on there server and choose
Terminate<o:p></o:p></div>
<div class="MsoListParagraphCxSpLast">
<span style="color: #333333; font-family: Trebuchet MS, sans-serif; font-size: x-small;"><span style="background-color: #eeeecc; line-height: 15.3333320617676px;"><br /></span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-cUOVKDUaD00/VGYTvKhi4TI/AAAAAAAAEec/GjFEMAe_cC8/s1600/12.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://2.bp.blogspot.com/-cUOVKDUaD00/VGYTvKhi4TI/AAAAAAAAEec/GjFEMAe_cC8/s1600/12.png" /></a></div>
<div class="MsoListParagraphCxSpLast">
<span style="color: #333333; font-family: Trebuchet MS, sans-serif; font-size: x-small;"><span style="background-color: #eeeecc; line-height: 15.3333320617676px;"><br /></span></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Calibri, sans-serif; font-size: 11pt; line-height: 115%;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Calibri, sans-serif; font-size: 11pt; line-height: 115%;">So, its all done. You are all set to explore SOA 12c. Go.. Go..Go</span></div>
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -18.0pt;">
<span style="background: #EEEECC; color: #333333; font-family: "Trebuchet MS","sans-serif"; font-size: 10.0pt; line-height: 115%;"><o:p></o:p></span></div>
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -18.0pt;">
<o:p></o:p></div>
</div>
</div>
Abhishek Saurabhhttp://www.blogger.com/profile/17557091703885116383noreply@blogger.com0tag:blogger.com,1999:blog-1624436388461172643.post-39428054158703105302014-10-31T20:05:00.001+05:302014-10-31T20:23:24.589+05:30Oracle SOA 12c- What's New in store for Developers<div dir="ltr" style="text-align: left;" trbidi="on">
I had been researching for quite a sometime on Oracle SOA 12c and have found some cool features for Developers in terms of development ease, user experience, integration, performance, management, mobile, cloud and many more. Here is the compilation of the same.<br />
<br />
<b>Note</b>: As there are many features, to make this blog to the point and readable, I have just presented features summary. Details of each feature will be published in my subsequent blogs later.<br />
<br />
<b><u>Single Installer:</u> </b>Oracle Suite 12c comes as single installer for developers. It’s one single package which include JDeveloper, a integrated Weblogic service with SOA Suite (including OSB), JavaDB (Database) and the Enterprise Manager. In JDeveloper, the WebLogic Integrated Server is pre-configured with SOA Suite components runtime and JavaDB.<br />
<div>
<br /></div>
<div>
<b><u>No Eclipse:</u> </b>For OSB development we need not have to use Eclipse IDE anymore, we can develop OSB application in Jdeveloper itself. OSB development now also uses similar terminology and layout as the SOA Suite SCA composite application development.</div>
<div>
<br />
Just like OSB, even for OEP (Oracle Event Processing), we do not have to use Eclipse anymore. The new version is not just a simple port to JDeveloper, it has gotta major face lift.<br />
<br />
<b><u>New DB connection Types:</u></b> SOA Suite 12c adds two new Database connection types when creating Database connections.<br />
a. JavaDB - JavaDB (Derby) is used to run SOA Suite repository on that is used for the integrated server. It is a development database that allows one to start development with SOA Suite without the need to run RCU. Java Derby database, which is file based and that makes it really fast.<br />
<br />
b. JDE World - JDE World connection you have easy access to the data in the JD Edwards database.<br />
<br />
<b><u>New Technology Adapters: </u></b><br />
a. Coherence Adapter<br />
b. Salesforce cloud Adapter<br />
c. REST Adapter<br />
d. MFT<br />
e. LDAP<br />
f. Healthcare<br />
g. MSMQ<br />
h. JDE World<br />
i. SAP<br />
j. UMS (SMS support)<br />
<br />
<b><u>Support for Maven:</u></b> Like ANT for deployment, now Oracle 12c supports Maven explicitly. Whenever an Application or Project is created, automatically pom.xml gets created which can be used for deployments using Maven.<br />
<br />
<b><u>JDeveloper Debugging and Testing:</u></b> One of the most useful improvements made to JDeveloper is the inclusion of a debugger. With the help of debugger we can debug our code before deploying it, this saves lot of development efforts. It allows you to set breakpoints within a SOA composite, BPEL process or OSB.<br />
<br />
<b><u>Improved Test suite: </u></b>The SOA Suite test framework has also been improved, with the ability to run the tests within JDeveloper with detailed reports of every test run, instead of having to perform the testing from within Enterprise Manager Fusion Middleware Control.<br />
<br />
<b><u>Improved XSLT Mapper: </u></b>In this release I can see much better support for complex stylesheets with multiple templates, user defined functions (also recursive functions). I can also see a better functioning of XSLT when we switch between Design and Source mode, which was an issue till 11g.<br />
<br />
<b><u>New Xquery Mapper:</u></b> In this release Xquery mapper is newly introduced which provide XQuery support. BPEL has a dedicated activity to use XQuery in your BPEL code for transformations. The XQuery mapper has support for XPath 2.0 and user defined functions. The mapper is really user friendly and it’s made consistent with the XSLT mapper interface. The mapper also has an integrated Test framework and is build for reuse in both SOA & OSB.<br />
<br />
<b><u>Translate Activity: </u></b> New Activity in 12c which is used for Native to XML and XML to Native transformations.<br />
<br />
<b><u>MDS goes Graphical:</u></b> Now with 12c, you can publish, search and consume files from MDS and OER. Its quite user friendly.<br />
<br />
<b><u>Templates for SOA:</u></b> By using SOA Templates, you can start developing a composite application and can easily add reusable components or activities to an existing composite application. You can create and apply templates at three levels within a composite application, these are:<br />
a. Project Template<br />
b. Component Template<br />
c. Custom Activity Template<br />
<br />
Note: More details of it will be publish in my subsequent blogs<br />
<br />
<b><u>Templates for OSB: </u></b>Oracle Service Bus templates are also supported in Oracle SOA Suite 12c. They are similar to SOA Suite SCA composite templates but with minor differences. OSB templates are created at the pipeline level and can be either linked or unlined.<br />
<br />
<b><u>OSB - MDS support: </u></b>Now MDS support is provided for OSB in 12c, unlike 11g.<br />
<br />
<b><u>BPEL Sub-process:</u></b> Sub-process is new introduction in this release which provides a mechanism for reusing BPEL code within a BPEL process. A BPEL sub-process can be described as a unit of encapsulated logic that can be called zero to many times within a BPEL process.<br />
There are two types of sub-processes.<br />
a. Inline subprocess<br />
b. Standalone subprocess<br />
<br />
<b><u>Managed File Transfer (MFT) 12c:</u></b> MFT is a simple and secure End-to-End Managed File Gateway. It is used for transferring files between a source and one or more targets. It integrates with (s)FTP, File, B2B, ODI, Healthcare and SOA, B2B and web services. MFT runs as an application on WebLogic 12c and has a lightweight Web based Design Time interface to easily build, edit and deploy end-to-end transfers and a Run Time interface to monitor running / failed transfer instances. It runs on its own managed server.<br />
<br />
<b><u>Enterprise Service Scheduler (ESS):</u></b> ESS is out of box scheduler which comes as a new feature of 12c (only supports weblogic and oracle DB in 12c). ESS is part of the SOA Suite license and with it you can create & schedule jobs through the EM. By using this we can schedule the services. It is automatically installed as part of SOA Suite (optional), Service Bus (optional) and MFT (mandatory).<br />
<br />
<b><u>Resequencing in OSB:</u></b> Resequencing functionality was in 11g Mediator, now this feature is introduced in OSB as well with 12c release. Now with the help of this feature we will be able to process the request message in proper sequence.<br />
<br />
<b><u>Better BAM in 12c</u></b><br />
<br />
<b><u>Auto Purge functionality:</u></b> In 12c Auto purge of SOA DB is enabled by default for new installations. Purging of the SOA DB can now be scheduled through EM Console.<br />
<br />
<b><u>EM Console:</u></b> In 12c EM console is also enhanced with its features. A lot have been modified like Search option, Flow view etc.<br />
<br />
<br /></div>
</div>
Abhishek Saurabhhttp://www.blogger.com/profile/17557091703885116383noreply@blogger.com1tag:blogger.com,1999:blog-1624436388461172643.post-3091441602432183482014-10-06T19:14:00.000+05:302014-10-06T19:16:52.345+05:30Welcome to Oracle SOA 12c<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Introduction:</b><br />
New version from Oracle (SOA 12c) was out few months back - Lets explore it with me. Oracle SOA 12c comes with loads of new good features and enhancements.<br />
<br />
<b>Prerequisites to Kick-Start:</b><br />
Lets start with prerequisites which is needed for learning 12c. This section gives required links, all in one place, so that you don't have to wonder places to gather information.<br />
<br />
First of all, you need to check your system requirement, if all ok, then you need to have JDK 7 for 12c. Upgrade it, if not yet done.<br />
<br />
<u>Link for checking your system requirements:</u><br />
http://www.oracle.com/technetwork/middleware/ias/downloads/fusion-certification-100350.html<br />
<br />
Once you open the link, there are xls files which contains Certification Matrix. Check that out for reference<br />
<br />
<u>Link for JDK 7 download:</u><br />
http://www.oracle.com/technetwork/java/javase/downloads/index.html<br />
<br />
(Note: Detailed step for installing it will be presented in another follow up blog entry)<br />
<br />
Once JDK is downloaded, go for SOA 12c download. Keep both ready, so that we can install it altogether.<br />
<br />
<u>Link for SOA 12c download:</u><br />
http://www.oracle.com/technetwork/middleware/soasuite/downloads/index.html?ssSourceSiteId=opn<br />
<u><br /></u>
With Oracle Suite 12c its all easy. All your installation, a sample Hello world, deploy and test will happen with in 30 mins only, its fast. Oracle SOA 12c use Java Derby database, which is file based and that makes it really fast. With 12c, it is now a single installer for developers - means your JDeveloper (IDE), Weblogic, Database and SOA is now integrated, no need to install it separately.<br />
<br />
(Note: Detailed step for installing it will be presented in another follow up blog entry)</div>
Abhishek Saurabhhttp://www.blogger.com/profile/17557091703885116383noreply@blogger.com1tag:blogger.com,1999:blog-1624436388461172643.post-45500857401412414212013-02-28T21:54:00.004+05:302013-02-28T21:57:10.482+05:30States meaning for Instances<div dir="ltr" style="text-align: left;" trbidi="on">
This is an enhanced version of my own blog dated <b>08-Aug-2008, BPEL: Purging Instances-1</b>, which suggests about various States stored in Dehydration store. Earlier information was for SOA 10g interface States stored in Cube_instances, This blog is about the same but for <b>SOA 11g</b>.<br />
<div>
<br /></div>
<div>
<b><span style="color: #0b5394;">Problem:</span> </b>To know the meaning of States stored under CUBE_INSTANCE table of SOA_INFRA Schema</div>
<div>
<br /></div>
<div>
<b><span style="color: #0b5394;">Explanation:</span></b></div>
<div>
<br /></div>
<div>
<b>Value</b>: 0</div>
<div>
<b>Meaning</b>: Initiated</div>
<div>
<b>Description</b>: for an instance that has just been newly created</div>
<div>
<br /></div>
<div>
<b>Value</b>: 1</div>
<div>
<div>
<b>Meaning</b>: Open & Running</div>
<div>
<b>Description</b>: for an instance that has been created and has active activities executing</div>
</div>
<div>
<br /></div>
<div>
<b>Value</b>: 2</div>
<div>
<div>
<b>Meaning</b>: Open & Suspended</div>
<div>
<b>Description</b>: for an instance that is unavailable & is in suspended state. No action can be taken for this instance until the instance has returned to the running state</div>
</div>
<div>
<br /></div>
<div>
<b>Value</b>: 3</div>
<div>
<div>
<b>Meaning</b>: Open & Faulted</div>
<div>
<b>Description</b>: for an instance that has an activity that has thrown an exception. When an activity throws an exception, the instance is flagged as being in an exception state until the exception is properly caught and handled</div>
</div>
<div>
<br /></div>
<div>
<b>Value</b>: 4</div>
<div>
<div>
<b>Meaning</b>: Open & Pending</div>
<div>
<b>Description</b>: for an instance that is in mid of cancellation. An instance is said to be pending cancellation state - it may happen that the process is quite big & complicated that the entire cancellation process may takes anywhere from seconds/minutes/days. An instance may not be acted upon during this time</div>
</div>
<div>
<br /></div>
<div>
Value: 5</div>
<div>
<div>
Meaning: Closed & Completed</div>
<div>
Description: for an instance that has been completed i.e. All activities belonging to this instance have also been completed</div>
</div>
<div>
<br /></div>
<div>
<b>Value</b>: 6</div>
<div>
<div>
<b>Meaning</b>: Closed & Faulted</div>
<div>
<b>Description</b>: for an instance that has an activity that has thrown an exception while the instance is being cancelled</div>
</div>
<div>
<br /></div>
<div>
<b>Value</b>: 7</div>
<div>
<div>
<b>Meaning</b>: Closed & Cancelled</div>
<div>
<b>Description</b>: for an instance that has been cancelled. All activities belonging to this instance have also been cancelled</div>
</div>
<div>
<br /></div>
<div>
<b>Value</b>: 8</div>
<div>
<div>
<b>Meaning</b>: Closed & Aborted</div>
<div>
<b>Description</b>: for an instance that has been aborted due to administrative control. All activities belonging to this instance are also moved to the aborted state</div>
</div>
<div>
<br /></div>
<div>
<b>Value</b>: 9</div>
<div>
<div>
<b>Meaning</b>: Closed & Stale</div>
<div>
<b>Description</b>: for an instance who's process has been changed since the process was last accessed. No actions may be performed on the instance. All activities that belong to this instance are also moved to the stale state</div>
</div>
<div>
<br /></div>
<div>
<b>Value</b>: 10</div>
<div>
<div>
<b>Meaning</b>: Non Recoverable</div>
<div>
<b>Description</b>: for an instance that has failed and is marked as non recoverable</div>
</div>
<div>
<br /></div>
</div>
Abhishek Saurabhhttp://www.blogger.com/profile/17557091703885116383noreply@blogger.com3tag:blogger.com,1999:blog-1624436388461172643.post-57676398744682751262013-02-27T22:13:00.005+05:302013-02-27T22:15:53.473+05:30<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="color: #0b5394;"><b><i>And here I come with more exciting knowledge and learnings.</i></b></span><br />
<b><i><span style="color: #0b5394;"><br /></span>
<span style="color: #0b5394;">Apologies for not being there for quite a few months. During this period I have gathered lot of experiences on Oracle Fusion products and its implementation which I will sharing to you all, watch out the space.</span></i></b><br />
<b><i><span style="color: #0b5394;"><br /></span>
<span style="color: #0b5394;">And yes, although I am late, as always I wish all my blog readers a very happy and prosperous New Year 2013.</span></i></b></div>
Abhishek Saurabhhttp://www.blogger.com/profile/17557091703885116383noreply@blogger.com1tag:blogger.com,1999:blog-1624436388461172643.post-38965095564066021522011-01-28T19:08:00.003+05:302011-01-28T19:33:26.761+05:30Connecting to SQL Server using SQL Developer<span style="font-weight:bold;">Problem:</span><br />Need to connect to SQL Server Database using SQL Developer<br /><br /><span style="font-weight:bold;">Solution: </span><br />This is an option available under SQL Developer which will allow us to connect to Third-Party Database systems. If we configure our SQL Developer, we can connect to SQL Server database.<br /><br />Below mentioned are the steps which will ensure SQL server connectivity:<br />1) You need to have a Jar file in place for SQL server.<br />2) Download jTDS SQL Server driver - an open source JDBC driver from:-'http://sourceforge.net/projects/jtds/' to your local drive.<br />3) Unzip the folder<br />4) Open SQL Developer<br />5) Goto Tools -> Preferences -> Database -> Third Party JDBC Drivers<br />6) Click 'Add Entry', navigate to the unzipped folder<br />7) Select jtds-1.2.5.jar and click OK<br />8) Now goto the connections window and create a new connection<br />9) Give some connection name, enter proper username and password<br />10)Select 'SQLServer' Tab<br />11)Enter proper Hostname and leave Port as 1433 (Default). Change the port number only if it is running on running on some different port.<br />12)Click on Retrive Database button to fetch the Database name you want to connect<br />13) Test the connection<br />14) SUCCESS, Save the connection and press the connect button<br /><br />It works!!!Abhishek Saurabhhttp://www.blogger.com/profile/17557091703885116383noreply@blogger.com13tag:blogger.com,1999:blog-1624436388461172643.post-34166709156248445182011-01-16T15:30:00.009+05:302011-01-16T18:32:12.040+05:30Handling Large Payload Files<span style="font-weight:bold;">Problem:</span><br />Want to create a BPEL process to read, transform and translate a large payload file (e.g. size 1GB)?<br /><br /><span style="font-weight:bold;">Thoughts:</span><br />Reading and traversing large payload file was always a problem in SOA 10g. Supposedly Maximum limit for such operations are for less than 7MB files in 10g. <br />Solution to such problems are answered in 11g where you can read and transform huge payload files.<br /><br /><span style="font-weight:bold;">Solution:</span><br />Suppose you have a CSV file incoming from source directory which you want to transform to a Fixed length file. Keep the source and the destination schema (XSD) ready. Also prepare the Transformation file (XSL) and keep it handy.<br />For accomplishing this, you will only be using one File Adapter which will take care of your read, transform and write - so all the three operations takes place under single I/O interaction.<br /><br />Follow the steps below for making it possible:<br />1) Drag and drop a file adapter in the external references swim lane. (For e.g. Give name as FileMove.)<br />2) Select Synchronous File Read<br />3) Give any dummy value for File physical path and File Name. It will be changed manually later.<br />4) Select Native format translation is not required (Opaque Schema)<br />5) Outbound File Adapter is now configured, click on Finish<br />6) Open the relevant .jca file (in this case FileMove_file.jca)<br />7) Ensure that className should be <br /> "oracle.tip.adapter.file.outbound.FileIoInteractionSpec"<br />8) Add extra parameters as shown in below file:<br /> <adapter-config name="FileMove" adapter="File Adapter"<br /> xmlns="http://platform.integration.oracle/blocks/adapter/fw/metadata"><br /> <connection-factory location="eis/FileAdapter" adapterRef=""/><br /> <endpoint-interaction portType="FileMove_ptt" operation="FileMove"><br /> <interaction-spec<br /> className="oracle.tip.adapter.file.outbound.FileIoInteractionSpec"><br /> <property name="SourcePhysicalDirectory" value="testDir1"/><br /> <property name="SourceFileName" value="test1"/><br /> <property name="SourceSchema" value="xsd/source-csv.xsd"/><br /> <property name="SourceSchemaRoot value="Root-Element"/><br /> <property name="SourceType" value="native"/><br /> <property name="TargetPhysicalDirectory" value="testDir2"/><br /> <property name="TargetFileName" value="test2"/><br /> <property name="TargetSchema" value="xsd/destination-fixedLength.xsd"/><br /> <property name="TargetSchemaRoot value="Root-Element"/><br /> <property name="TargetType" value="native"/><br /> <property name="Xsl value="xsl/SourceToDestination.xsl"/><br /> <property name="Type" value="MOVE"/><br /> </interaction-spec><br /> </endpoint-interaction><br /> </adapter-config><br />9) Save the file and deploy the process.<br /><br /><span style="font-weight:bold;">Note:</span><br />This will works only if all the records in the data file are of the same type.Abhishek Saurabhhttp://www.blogger.com/profile/17557091703885116383noreply@blogger.com4tag:blogger.com,1999:blog-1624436388461172643.post-79030566151228138682011-01-16T15:01:00.003+05:302011-01-16T15:14:25.985+05:30Exporting ESB Metadata<span style="font-weight:bold;">Requirement:</span><br />Exporting entire ESB metadata<br /><br /><span style="font-weight:bold;">Solution:</span><br />Follow the steps below to achieve the result:<br />1) Login to SOA Server (10g) from backend viz. using Putty, and set your environment.<br />2) Navigate to <SOA_HOME>/integration/esb/bin<br />3) Run the export.sh command to export entire ESB metadata like:<br /> ./export.sh ESBmetadata.zip<br />4) You will see a output message as:<br /><br /> Setting Protocol = http<br /> Dec 29, 2010 11:14:16 AM oracle.tip.esb.lifecycle.HttpHandler logInfo<br /> INFO: Exporting metadata from the server [host=oradev,port=7777,user=oc4jadmin] to<br /> file "/u01/app/oracle/product/10g/OracleAS_3/integration/esb/bin/ESBmetadata.zip"<br /> Dec 29, 2010 11:14:16 AM oracle.tip.esb.lifecycle.HttpHandler main<br /> INFO: Export completed successfully!!!<br /><br /><span style="font-weight:bold;">Note:</span><br />Steps shown above are done on SOA Server 10g running on Linux environment.Abhishek Saurabhhttp://www.blogger.com/profile/17557091703885116383noreply@blogger.com1tag:blogger.com,1999:blog-1624436388461172643.post-873831392764014512011-01-03T17:21:00.006+05:302011-01-03T17:43:19.330+05:30ORABPEL Spying-Part2<span style="font-weight:bold;">Requirement:</span><br />To get all BPEL instances and their duration that run longer than '<span style="font-style:italic;">n</span>' seconds<br /><br /><span style="font-weight:bold;">Solution:</span><br />SELECT <br />process_id, creation_date, <br />SUBSTR(modify_date-creation_date,12) Duration, <br />SUBSTR(REGEXP_SUBSTR(title, '[^ ]+', 1, 2), 2) InstanceId<br />FROM <br />cube_instance<br />WHERE <br />TO_CHAR(creation_date, 'YYYY-MM-DD HH24') >= '<Date_value>'<br />AND <br />TO_CHAR(creation_date, 'YYYY-MM-DD HH24') <= '<Date_value>'<br />AND <br />(modify_date-creation_date) > '0 0:0:<span style="font-style:italic;">n</span>.0'<br />AND <br />process_id IN ('<Name of Process>')<br />ORDER BY <br />modify_date DESC<br /><br /><span style="font-weight:bold;">Example:</span><br />Here <span style="font-style:italic;">n</span>=45 seconds<br /><br />SELECT <br />process_id, creation_date, <br />SUBSTR(modify_date-creation_date,12) Duration, <br />SUBSTR(REGEXP_SUBSTR(title, '[^ ]+', 1, 2), 2) InstanceId<br />FROM <br />cube_instance<br />WHERE <br />TO_CHAR(creation_date, 'YYYY-MM-DD HH24') >= '2010-10-12 15'<br />AND <br />TO_CHAR(creation_date, 'YYYY-MM-DD HH24') <= '2011-01-01 21'<br />AND <br />(modify_date-creation_date) > '0 0:0:45.0'<br />AND <br />process_id IN ('TestProjectBPEL')<br />ORDER BY <br />modify_date DESCAbhishek Saurabhhttp://www.blogger.com/profile/17557091703885116383noreply@blogger.com1tag:blogger.com,1999:blog-1624436388461172643.post-66098591547806923702011-01-03T17:00:00.007+05:302011-01-03T17:37:54.607+05:30ORABPEL Spying-Part1<span style="font-weight:bold;">Requirement:</span><br />Want to get the information on currently running processes - Shortest and Longest running instances on server?<br /><br /><span style="font-weight:bold;">Solution:</span><br />Below query will give you the desired result:<br /><br />SELECT * FROM (<br /> SELECT <br /> bpel_process_name AS "ProcessName", <br /> TO_CHAR(MIN(creation_date),'YYYY-MM-DD HH:MI') AS "EarliestDate",<br /> COUNT(*) AS "TotalRunningProcesses",<br /> TO_NUMBER(SUBSTR(MIN(sysdate-creation_date), 1, <br /> INSTR(MIN(sysdate-creation_date), ' '))) AS "ShortestRunning (Days)",<br /> SUBSTR(MIN(sysdate-creation_date),<br /> INSTR(min(sysdate-creation_date),' ')+1,8) AS "ShortestRunning (Hours)",<br /> TO_NUMBER(SUBSTR(MAX(sysdate-creation_date), 1, <br /> INSTR(MAX(sysdate-creation_date), ' '))) AS "LongestRunning (Days)",<br /> SUBSTR(max(sysdate-creation_date),<br /> INSTR(MAX(sysdate-creation_date),' ')+1,8) AS "LongestRunning (Hours)" <br /> FROM ORABPEL.bpel_process_instances <br /> WHERE state = 1<br /> GROUP BY bpel_process_name<br /> ORDER BY "EarliestDate" DESC<br />)<br /><br />NOTE: Query for Oracle BPEL Process Manager 10g (10.1.3.x)Abhishek Saurabhhttp://www.blogger.com/profile/17557091703885116383noreply@blogger.com4