Friday, November 21, 2014

RCU Creation for Oracle 12c MFT

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

Step by Step:

RCU file resides under your ORACLE_HOME\oracle_common\bin
ORACLE_HOME here is place where your SOA is installed

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.

2) Navigate to ORACLE_HOME\oracle_common\bin and run rcu.bat (for Windows)



3) This will open RCU welcome window as shown below, Click Next


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


5) DEV_MFT for MFT RCU is selected, Click Next. After this Prerequisite check window will appear, click Ok once complete



6) Choose Schema Password, Click Next


7) Click Next, Click OK on confirmation window, which will then create Tablespace




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



Once this is complete, Completion Summary page will appear showing status of the RCU run. Choose Close button, RCU run is completed successfully.

Now refer to my next blog which will talk about updating the existing Domain for MFT.

Thursday, November 20, 2014

Oracle 12c MFT Installation

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

This blog is in continuation of my last blog where Oracle Database 12c installation steps were shown.
Lets explore steps for Installing Oracle MFT.

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

1) If you have not yet downloaded the installation file, download it from Oracle site:
http://www.oracle.com/technetwork/middleware/mft/downloads/index.html

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

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

3) Open cmd in Administrator mode, and navigate to your Java jdk location and run the jar file


4) This will open Oracle Universal Installer,




5) Select Oracle Home, This is same home were SOA 12c is installed.


6) Now it will be simply Next -- Install -- Next -- Finish

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.

Installing Oracle Database 12c for SOA & MFT

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

Steps for Installation:

1) Download Oracle 12c from following location:
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/database12c-win64-download-1968077.html

2) There will be two files downloaded, unzip those files

3) Open command line, choose Run as Administrator


4) Now navigate to the location of Unzipped file and run Setup.exe




5) This will open the Universal installer


6) Follow the installation window, step wise as shown in below screen shots

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

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.

a) Uncheck the box and click Next


b) There will be Warning, just Click Yes and proceed


c) Select Skip software updates Radio button, click Next


d) As we will Create and will have to configure the database, choose the first option and click Next


e) Choose Desktop class and click Next


f) Choose Use Windows Built-in Account and click Next (You can even use the first option)


g) You will will again prompted with message box, Click Yes and Next


h) This is an important 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).

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


i) Click Next and then press Install


j) Click Next


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.


l) Click Next

m) And that's it.

Database 12c is all set and installed for use now.

Exploring MFT in 12c

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

To Start:
Before starting MFT installation, you need to have certain products already installed on your system.
Make sure you have following installed:
1) Java 7
2) SOA 12c along with Domain creation (Refer my blog on its installation)
3) Oracle Database (I have used Oracle 12c as Database)
4) RCU for MFT (This actually can be done after MFT installation also)

To cover the whole MFT installation to make it ready for use, I am going to write separate blogs which will contain steps for
1) Installing Oracle Database 12c
2) Installing MFT
3) Running RCU on Database for MFT
4) Updating your local development Domain for MFT

By covering above 4 steps you will ready with MFT.

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.

So, keep watching the space for my next blog entry.


Wednesday, November 19, 2014

Oracle 12c "Composite Lazy Loading" Feature

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

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.

Details:
Composite Lazy Loading can be configured at two levels - 1) Domain 2) Component Level

Lazy Loading at Domain Level:
This setting can be disabled/enabled from System MBean Browser in FMW EM console. Follow below steps:
1. Login to EM Console, right-click on the domain you want to tune and select System MBean Browser from the drop-down menu



2. In the System MBean Browser folder structure, navigate through: Application Defined MBeans --  oracle.as.soainfra.config -- Server: ServerName -- SoaInfraConfig -- soa-infra



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
false to disable it



4. Click Apply and restart the server for changes to take effect.

Lazy Loading at the Component level:
To enable/disable it at component level, you need to follow below steps:
1. Open composite.xml file
2.  Add the new property lazyLoading="false" to override the default behaviour at the domain level, as shown in screen shot



3. Redeploy your code

By default, composites will inherit the lazy loading setting from the domain level.

Friday, November 14, 2014

Installing Oracle 12c

Introduction:

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).
Note: This installation was carried out on WIndows 7 for Studio Edition version 12.1.3.0.0

Prerequisites to Kick-Start:

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

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: http://www.oracle.com/technetwork/middleware/soasuite/downloads/index.html?ssSourceSiteId=opn
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.

4) You should have enough RAM like 8GB or 16GB, 64 bit configured with good system specifications


Steps of Installation:

1) Type cmd in start menu and once it appears, right click and choose ‘Run as administrator’, as shown below


2) Once command prompt is opened, navigate to your Java Jdk, as shown below





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

4) Go back to Command prompt and type command as (make sure you are under Java\jdk\bin): java –jar
Below Screenshot explains the same


This will open Quick Start Installer for 12c with Welcome page



5) Click Next, it will ask you for Oracle Home location, i.e. the place where it will install


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

7) 4th step shows Installation Summary, i.e. what all feature it is going to Install. Simply click on Install button

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

9) Click Next and it will show you the final Page as below. Unckeck Start Jdeveloper and click Finish.

Word of Advice: 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

Steps for Local Domain Setup

1) If you Start Jdeveloper and then start the server, by default it creates your domain under hidden folder:
C:\Users\\AppData\Roaming\JDeveloper\system11.1.1.7.40.64.93\DefaultDomain

This will be a problem. I would recommend to have your domain in same place, where your Oracle Home is.

2) To do the same, set the System Environment Variable. Goto Environment Variable (Computer -Properties -Advanced system settings -Advanced -Environment Variables -System Variables)



Create folder like user_projects\domains under OracleWls_Home. In the Variable value give the same folder path value as OracleWls_Home\user_projects\domains
Once this is set, means now whenever you will start Jdeveloper server, it will by default create the domain under your Oracle Home

3) Save it and naviagte to open Jdeveloper. Your Jdeveloper will be under \jdeveloper\jdeveloper.exe

4) Once Jdeveloper is opened, Navigate to Window - Application Servers


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

Enter the password which you will be using for all Weblogic, EM operations.


6) Once done, click OK and you are all good to go.

7) Whenever you want to switch off/bring down your server, just right click on there server and choose Terminate



So, its all done. You are all set to explore SOA 12c. Go.. Go..Go