Sunday, February 15, 2015

Deinstall Oracle SOA 12c

Sometimes you might need to look for completeness when it is not found in your installation then we go for deinstall and re-install. Here Oracle Uninstller validates all memory checks then go for all products that installed as per the OracleInventory removal of SOA 12c.

For any Linux environments following command will works.
 
cd $ORACLE_HOME/oui/bin
./deinstall.sh


Above will take 4 steps then completes. You might need manual remove command... Before proceedging to the following step double check
 
$ rm -rf Oracle

Saturday, February 14, 2015

SOA Database Adapter experiment

Hey, Here I am going to create a Database user which can be used for demonstrate the database adapter.

 grant connect, resource to soademo identified by soademo;
create a table
 CREATE TABLE CREDITCARDINFO
(
SSN VARCHAR2(15) NOT NULL,
FIRST_NAME VARCHAR2(30),
LAST_NAME VARCHAR2(30),
CCNUMBER VARCHAR2(20) NOT NULL,
CREDITRATING NUMBER,
STATUS VARCHAR2(20) NOT NULL
);

create a Table using XE Apex tool
Insert records in to table
Now, lets do insert operation on the table that was created following records for testing purpose
 insert into CREDITCARDINFO VALUES (
    '111-11-1111',
    'Neena',
    'Kochhar',
    '1234-1234-1234-1234',
 '3'
 , 'VALID'
);

insert into CREDITCARDINFO VALUES (
    '222-22-2222',
    'Steven',
    'King',
    '5678-5678-5678-5678',
 '4'
 , 'VALID'
);

insert into CREDITCARDINFO VALUES (
    '333-33-3333',
    'Lex',
    'Devarakonda',
    '4321-4321-4321-4321',
 '5'
 , 'INVALID'
);

insert into CREDITCARDINFO VALUES (
    '444-44-4444',
    'Alexander',
    'Hunold',
    '8765-8765-8765-8765',
 '1'
 , 'VALID'
);


Now lets create a datasource that uses above created schema that is soademo.

Friday, February 13, 2015

Installing SOA 12c in Ubuntu

Most of the realtime environments would be on Unix or Linux environments. Just I wish to try all the pains and issues to see while learning this.

Installing SOA 12c quick start on Xubuntu 14

Before we install the SOA we need to have the efficient System setup. 40GB hard disk,
create 'wladmin' as a Unix user where we can perform installation.

  • Step 1. Install Oracle JDK

Default JDK is not available in XUbuntu. Oracle JDK latest version can be downloaded and installed from the Ubuntu repository. Make sure that your internet work on the system where you wish to install.  Here I am using a Oracle VirtualBox guest as Xubuntu, enabled NAT network adapter to have internet on my system.

You can use the below commands to install JDK-7 for WebLogic 12c installation this will work for regular Ubuntu and also for XUbuntu.

  1. sudo add-apt-repository ppa:webupd8team/java 
  2. sudo apt-get update 
  3. sudo apt-get install oracle-java7-installer
confirm the java version
 root@wladmin-VirtualBox:~# which java
/usr/bin/java
root@wladmin-VirtualBox:~# java -version
java version "1.7.0_76"
Java(TM) SE Runtime Environment (build 1.7.0_76-b13)
Java HotSpot(TM) Client VM (build 24.76-b04, mixed mode)


  • Step 2: Install FMW SOA 12c

Now lets do the installtion in latest version that is SOA 12c which is not certified Ubuntu or its cusins though generic installer work with a Warning message.

download SOA12c from Oracle.
Setup your tmp space min 4G
Unzip the downloaded file.


 sudo mount -t tmpfs -o size=4096M,mode=1777  overflow /tmp
 unzip fmw_12.1.3.0.0_soaqs_Disk1_1of1.zip
 
 java -jar fmw_12.1.3.0.0_soa_quickstart.jar

Plan your device space where you can install the SOA 12c then provide the path when installer is launched. Then we get the 'Welcome screen' asusual.



Oracle SOA 12c Installation Location

Preparation for installation


Oracle Fusion Middleware 12c SOA Quick Start installation summary

Here I've faced issue with CPU utilization hence I moved to another flavor of Ubuntu that is XUbuntu. The final Screen of installation of Oracle Fusion Middleware is as follows


Uncheck the JDeveloper  and go for the Finish