Posts

Deinstall Oracle SOA 12c

Image
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

SOA Database Adapter experiment

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

Installing SOA 12c in Ubuntu

Image
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. sudo add-apt-repository ppa:webupd8team/java  sudo apt-get update  sudo apt-get install oracle-java7-installer confirm the java version root@w...

Oracle SOA Platform Overview

Image
Introduction to Oracle SOA Administration  Latest version from Oracle we can see Oracle SOA 12c that is in the year 2014 or 2015. As every new release there are many challenges expected for the existing projects who already running with Oracle SOA 11g. For our learning purpose better exercise on 11g first then migrate to 12c would give more clearity on every component why we are using this way! Download Links: downloads.oracle.com You can download 3GB size .zip file for 12c which is more focused on cloud specific features. I like the one step to go - one file to download in 12c. Well most of the projects initiated with 11g and the stable version of Oracle SOA Suite is available as 11g. So, ready for any thing at the moment :) You can select previous version that is 11g from the download bottom link contains here select 11.1.1.7.0 SOA Practical environment for Development and Learning Labs ofm_rcu_linux_11.1.1.7.0_64_disk1_1of1.zip ofm_soa_generic_11.1...

SOA Domain Creation

Image
Directory structure after the SOA 12c installation got the following: SOA 12c directory structure Any fusion products you will get the Oracle_common , which contains common tools like repository creation utility.  OPatch - Upgrading SOA the every quarter, we get a new patch from the Oracle. Normally in WebLogic bsu command utility was inside the weblogic installation common, from WebLogic 12.1.3 onwards OPatch. Once you go for patching for SOA or FMW products 100% of patches will be effected only when the domain restarted. Note: You must have the downtime for patching in FMW/SOA12c. rda - work with Oracle Support for issues, It will collect the configurations of FMW products. In SOA 11g it is separate directory Oracle_SOA1/OPatch in SOA12c it is only soa folder when we have the patches for SOA it will be given To create SOA domain we have several paths where configuration wizard for WebLogic domain creation available. But, here I will create from SOA installation ...

Install Oracle XE and Execution of RCU

Image
Objective: The RCU schemas can be executed on Oracle XE or Oracle RAC Database. For experimenting purpose we can work on XE. Perform Install Oracle 10g/11g XE Create the SOA related database schemas RCU Install Oracle XE Do the following pre-requisite things: root@ubuntu:~# apt-get install libaio-dev Reading package lists... Done Building dependency tree Reading state information... Done The following extra packages will be installed: libaio1 The following NEW packages will be installed: libaio-dev libaio1 0 upgraded, 2 newly installed, 0 to remove and 48 not upgraded. Need to get 20.2 kB of archives. After this operation, 141 kB of additional disk space will be used. Do you want to continue? [Y/n] y Get:1 http://in.archive.ubuntu.com/ubuntu/ trusty/main libaio1 amd64 0.3.109-4 [6,364 B] Get:2 http://in.archive.ubuntu.com/ubuntu/ trusty/main libaio-dev amd64 0.3.109-4 [13.8 kB] Fetched 20.2 kB in 1s (19.9 kB/s) Selecting previously unselected package libaio1:amd64. (Re...