Uninstalling SOA 12c from Mac

Introduction:
I had written a post earlier on how to install SOA 12c on a Mac.  For trying my hands on uninstalling the same, I followed below steps.

Steps:
1. Open Terminal and Navigate to MW_Home/oui/bin

 2. Open you are on that location, give this command - sh deinstall.sh -deinstall

 3. This will open the Deinstaller

4. On Opening screen, Click Next

5. Next page will give the Summary of products which will be Deinstalled. Click on Deinstall

6. Next screen will show the progress on Deinstall. Once it shows 100% click on Finish

7. Last screen will be displayed showing Deinstall summary.

This is all about Deinstalling SOA 12c.

WLST for MFT

Introduction:
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.

Steps:
If I talk specifically about WLST for MFT,  to connect to the server you need to follow below steps.

1. Open WLS_Home\mft\common\bin (Below screen shot is my system location)

2. Open command prompt (Run as administrator), navigate till the WLS_Home\mft\common\bin

3. Once you are on that location, type - wlst.cmd (for Linux it is ./wlst.sh)

4. You will be on wlst prompt

WLST commonly used Commands:

1. For connecting to the server
connect("username","password","t3://hostname:port")

Example: connect("weblogic","welcome1","t3://localhost:7101")

2. For disconnecting from WLST
You can either use - disconnect () or exit ()

Some of WLST Commands for MFT:

Coming soon...

Undeploy SOA Composite : Workaround

Introduction:
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.

I did a workaround and got ride of the composite. Below steps will show how to achieve the same.

Note: This was done on Oracle 12c

Undeploy Steps:
1. Login to EM console and click on soa-infra, below screen shot shows BPEL processes.

2. On Right pane window, click on SOA Infrastructure -- Administration -- MDS Configuration

3. You will see MDS configuration page, just click on Export. This will download soa-infra_metadata.zip file

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

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.

6. Once the file is saved, Zip the file again. Keep the Zip file name same as before (soa-infra_metadata.zip)

7. Go back to EM Console and to the Same MDS Configuration window (SOA Infrastructure -- Administration -- MDS Configuration). You will see an Import option.

Choose the location and Import the file.

8. Restart Server and check EM. The project which you Deleted will disappear.

Installing SOA 12c on a Mac

Introduction:
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.

Pre requisites:
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

Steps:

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)

2) Once the file is downloaded, unzip the file. Open Terminal and Navigate to the directory containing the .jar files as shown below

Run Java -jar fmw_12.1.3.0.0_soa_quickstart.jar

3) This will bring up the installer, change the OS Group accordingly. I choose everyone. Click OK

 4) First page of the instller, Click Next

5) OracleWls_Home directory will be shown, you can choose your own directory. I went with the default one. Click Next

6) Click Install

7) Next

8) Installation is done, This is the last page. Make sure Start JDeveloper is Enabled and click on Finish

9) JDeveloper will start

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

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

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.

Oracle 12c MFT - Using PGP Decryption

Introduction:
This is in continuation of my last blog, Oracle 12c MFT - Using PGP Encryption, here we will understand on how to decrypt the file which was encrypted using PGP Encryption technique.

I would recommend you to go through my PGP Encyption blog to understand the process.

Steps:
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.

1) Goto MFT console Design Tab, and for Transfer, select add pre-processing actions.

2) Once window opens, select PGP Decryption for the drop down and Add to the list.
Select Decryption Alias. Click OK

And you are all done.

Oracle 12c MFT - Using PGP Encryption

Introduction:
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.

Lets learn now how to use PGP Encryption.

Steps:
Before using PGP Encryption, we need to create PGP Key using WLST command. Below are detailed steps on how to acheive the same.

1) Navigate to OracleWLS_Home\mft\common\bin
2) Once you are there, Run wlst.cmd

3) You are now on wlst prompt, Now connect to your server using following command
connect("username","password","t3://hostname:port")

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-
generateKeys('PGP', 'Password for the key','Location name where you want keys to get generated')

Note: I have created a seperate new directory under my local domain to contain all the Keys

This will create two keys - pub.asc (Public) and secret.asc (Private)

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.
Use below commands to do the same:
importCSFKey('PGP', 'PUBLIC', 'Alias Name', 'full location/pub.asc')
importCSFKey('PGP', 'PRIVATE', 'Alias Name', 'full location/secret.asc')

6) Now as your Key pairs are generated and imported successfully, Go back to MFT console. Now rest of the configuration will happen there.

7) Login to MFT console and navigate to administration Tab - Keystores.
Enter the same password which was used during Generating key in the PGP Keystore section. Save the changes

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.

Once a window opens, select PGP Encryption for the drop down and Add to the list.
Select Encryption Alias and the Armored section. Click OK

 And you are all set. You file will be Encrypted.

Oracle 12c MFT - Configuring sFTP Embed

Introduction:
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.

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.

Lets learn step by step on how to configure this.

Steps:
For configuring sFTP (SSH-FTP), we need to create SSH Keystore using WLST command. Below are detailed steps on how to acheive the same.

1) Navigate to OracleWLS_Home\mft\common\bin
2) Once you are there, Run wlst.cmd

3) You are now on wlst prompt, Now connect to your server using following command
connect("username","password","t3://hostname:port")

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
generateKeys('SSH','Password for the key','Key Name with full location')

Note: I have created a new directory under my local domain to contain all the Keys

5) Now you will have to import the key to the server and will also create an alias for the key.
Use below command to do the same:
importCSFKey('SSH', 'PRIVATE', 'Alias Name', 'Key Name with full location')

6) Now as your Key generation and import is done, Go back to MFT console. Now rest of the configuration will happen there.

7) Login to MFT console and navigate to administration Tab - Keystores.
Enter the same password which was used during Generating key in the SSH Keystore section. Save the changes

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

Save the changes, click on Start button

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

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.

Go ahead and try this awesome feature.

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)

SOA 12c Creating Derby Database Connection

Introduction:
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.


How to create connection:
The steps are quite simple.

1) You need to Open Database Navigator, as shown below

2) Create a new connection

3) Choose Java DB (Derby) from Connection Type drop down and give connection Name

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

5) Test the connection

6) Now you can see the connection in Jdeveloper. Its good to go now