SOA Street

How to check File encoding and change the file encoding in Linux

2026-02-02T00:30:00.001-08:00

While reading and writing file and specially while supporting multiple characters set it is important to know what file encoding is used in order to read the data correctly. SOA Suite Adapter for reading file re

How to create JMS Queue / Topic in Weblogic 12c / 11g

2026-02-02T00:30:00.000-08:00

In this post I have tried to listed down all required steps to create JMS Queue which can be utilized for reliably transfer the data between two systems. Here is the steps by step process on how to create a JMS Queue in Weblogic 12c / 11g.

In order to complete below steps you must have created your JMS Server and JMSModule. If this is not done please go through the previous post on How to create JMS Server and JMS Module to complete the require steps.

Go to weblogic console and login to the domain
Go to domain Structure ->Services -> Messaging ->JMS Module
It will show you the list of all available module on the right pane of the window. Select "UserJMSModule" from the JMS Modules table.
This will land up in "Configuration" tab under "UserJMSModule"
Click New in Summary of resource table and select Queue and click next
Enter the name of the queue as UserQ and JNDI name as eis/UserQ. and leave the template as none. This can be any values you want. Click on Next

Now Select the subDeployment as "UserSubDeployment" which we created in previous steps.and click on finish
You should be getting a Message JMS Queue is created successfully.

Now you are ready to use this queue for storing the messages.

How to Install TypeScript on your machine using Nodejs Manager

2017-11-06T07:41:00.000-08:00

What is TypeScript ?

Type script is type superset of JavaScript that compiles to plain JavaScript.

Installation

To install TypeScript using node manager CLI, you will have to setup nodejs Manager. For this you can follow the previous post "How to install Nodejs".
After completing the Nodejs installation you can go to command prompt /Powershell on windows and type below command to install the typescript
npm install -g typescript
You might also end up finding below error if you are using proxy Server in your network for the internet connection.
In this case you might want to setup the proxy setting for the npm.

npm config set proxy http://:@:
npm config set https-proxy http://:@:

You have to replace , , , with the values specific to your proxy server credentials

How to Install node js on your machine

2017-11-06T07:30:00.000-08:00

If you are web developer and / or Mobile App developer, you will surely come across node js. Here in this post I have tried to described list of step to setup node js on your windows machine.

Please follow the step to complete the installation.

1. Go to the website https://nodejs.org.
Click on Recommanded for most user version of node js. Here in this case 8.9.0. This can be different based on when you are doing your setup and in popup window select Save file.
After download execute the installer.
Select Next & Accept the terms and condition
Provide the installation directory
Keep the default selection as node manger also need to be part of installation here.
To start the installation click on Install (This will required your user to have administrator rights.
After successful installation it should show the completion screen as below. Click Finish to complete and exit the installation.

How to Create / Configure / Maintain JMS Server & Module in Weblogic 11g / 12c

2015-08-06T01:00:00.000-07:00

In this post here i have tried to put across step by step process to create JMS Server , JMS Module etc to complete required full configuration for Weblogic JMS server for 12c. Steps will remain same for weblogic 11g as well.

Login to Weblogic console and go to Domain Structure -> Services -> Messaging
Select JMS Server
Create a new JMS Server page will open, enter below details

Name : Name of JMS Server
Persistent Store : Provide the name of Persistent Store. This is covered in other post previously. Click here to go to the How to create Persistent store

Click Next
On the next screen select Target. It should be the server where you want to create this JMS Server.
Click Finish
Now we have JMS Server and we need to add JMS Module
Go to Domain Structure -> Services -> Messaging -> Select JMS Module
Click on New button to create new JMS Module
Enter required information in create new JMS page

Name : UserJMSModule
Descriptor : UserJMSModule
Location in Domain : leave it blank to create it at default location and click Next

On the next page select appropriate target server where you want to deploy this JMS Module and select Next
In the next window leave the check box "Would you like to add resources to this JMS system module?" unchecked and click finish

Message should be displayed as "The JMS module was created successfully".
Under settings for UserJMSModule go to subdeployment tab and click New
Provide the name of subdeployment as "UserSubDeployment" and click next
Select the previously created "UserJMSServer" and click on finish and message should be displayed as "Subdeployment created successfully"
Click on Activate the changes to make the changes available for use in the domain.

How to Create Persistent Store in Weblogic 12c / 11g - Oracle fusion Middleware

2015-08-05T09:15:00.002-07:00

Persistent store is used to store messages. Persistent store can be of type File or it can be of type Database. So basically this will decide where your message are going to store within persistent store.

Here are steps to create persistent store.
Go to weblogic console and login
Go to Domain Structure ->Services -> Persistent Stores
It will display summary of Persistent Stores.
Click on New and select "Create JDBC Store"
Create new JDBC Store page will be displayed Enter below information

Name : Provide the name of Persistent Store
Target : specify the server to which it should be targeted.
Data Source : Name of data source
Prefix is optional.

Click on OK
Activate the changes

Similar process should be followed for File based Persistent store but there will not Data source as no database is involved there.

Disable Case Sensitive Group Names in Human Task

2014-10-28T12:12:00.001-07:00

Group Names in Human Task are case sensitive by default. However usernames are not. So While working with Human task you can use an case while specifying username but it may result into invalid group name / group not found issue if Group Name used is not using exact case.

You can disable case sensitivity of Group Name for Human Task by setting up caseSensitiveGroups Property in MBean Browser. Here are the steps.

Right-click soa-infra, and select Administration > System Mbean Browser.
The System MBean Browser is displayed on the right side of the page.
Expand Application Defined MBeans > oracle.as.soainfra.config > Server: server_name > WorkflowIdentityConfig > human-workflow > WorkflowIdentityConfig.PropertyType > caseSensitiveGroups.
Click the Operations tab.
Click setValue.
In the Value field, enter false.
Click Invoke.

Exception in thread “main” java.net.MalformedURLException: Unsupported protocol: t3

2014-07-14T20:40:00.001-07:00

Unsupported protocol : t3 error will come when you are trying to connect to weblogic server through your Java code using t3 URL. For this you need to include weblogic Network protocol library to the project classpath.

Add below two jar file to your project's build path :

wlclient.jar
wljmxclient.jar

Or Simply add

wlfullclient.jar

Using Deployment Configuration Plan to change location for locally imported WSDL

2014-05-14T08:14:00.001-07:00

There few software product available in market which exposes various functionalities as web service, however while directly providing that WSDL url in Web service adapter is not working. This requires you to import that concrete wsdl file in your local SOA Project and use that WSDL file to create WS Adapter to call the Service. However there other approaches are also there where you use Abstract WSDL file during design time and replace the binding during runtime. But here this post include detail only related replacing the binding details in locally stored concrete WSDL file.

While moving this application from one environment (dev) to other (test), you need to change the Service location which is available in local WSDL file so that web service can be called on correct environment.

Here are the steps you need follow to create a configuration plan which does that job at the time of deployment for you. Here we are assuming that you have you composite application already available where you have imported one concrete wsdl file and you have used it to create web service adapter.

In Application Navigator, go to your composite.xml file. Right click and generate configuration plan.

In Generated Configuration plan find the below entry.
<reference name="ExternalService">
         
         <binding type="ws">
            <attribute name="port">
               <replace>http://www.abc123.com/update/#wsdl.endpoint(Update/UpdateSoap)</replace>
            </attribute>
            <attribute name="location">
               <replace>ExternalService.wsdl</replace>
            </attribute>
            <property name="weblogic.wsee.wsat.transaction.flowOption">
               <replace>WSDLDriven</replace>
            </property>
         </binding>
      </reference>
Update the location attribute value with actual corresponding url applicable for target environment.. Updated values are highlighted in bold.

<reference name="ExternalService">
         
         <binding type="ws">
            <attribute name="port">
               <replace>http://www.abc123.com/update/#wsdl.endpoint(Update/UpdateSoap)</replace>
            </attribute>
            <attribute name="location">
               <replace>http://somehostname:8001/someServiceurl?WSDL</replace>
            </attribute>
            <property name="weblogic.wsee.wsat.transaction.flowOption">
               <replace>WSDLDriven</replace>
            </property>
         </binding>
      </reference>

Deploy the code to server using the created configuration plan and values for the service will be modified as per the config plan.

Configure Boot Identity / boot.properties file for Weblogic Managed Server Start

2014-02-06T06:05:00.000-08:00

On Fresh installation of Weblogic,While starting the managed Servers for the first time it will ask for the username / password. To avoid entering username and password on every restart of WebLogic Managed Server, store the boot identity in boot.properties file. After storing username and password to this file, it will automatically pick the details from this file and start the managed server without prompting for username/password.

Below are steps to be completed to configure username/password in boot.properties file.

1. Brows to Middleware/user_projects/domains/soa_domain/servers/soa_server1/security

2. edit boot.properties file

Unix : vi boot.properties

3. Add following entries into boot.properties file & save the file.

username:weblogic
password:password1

4. Now Start the Managed Server using below command & it will not prompt for username/password.

./startManagedWebLogic.sh soa_server1 http://127.0.0.1:7001

5. Again browse to boot.properties file at
Middleware/user_projects/domains/soa_domain/servers/soa_server1/security. Now while looking at the content of boot.properites file you will find the username and password is automatically encrypted for security.

Note : if you do not find security folder to place this file. Just create the folder and paste the boot.properties file there.

Using / Running / Setting JDeveloper 11.1.1.6 to use 64 bit and 32 bit JVM / JDK

2013-11-29T11:21:00.001-08:00

Tired of memory issues while working with JDeveloper because you are running on 32 bit JVM. Switch you JDeveloper to point to 64 bit JVM.This will allow you to use multi Gig memory usage while working with JDeveloper IDE.

Prerequisites: 64 bit Machine, 64 bit OS and 64 bit Jdk Installation. JAVA_HOME should be set to appropriate 64 bit jdk installation directory for example

JAVA_HOME = C:\Program Files\Java\jdk1.6.0_23
So your JAVA_HOME=C:\Program Files\Java\jdk1.6.0_23

JDeveloper's Settings:

C:\Oracle\Middleware\jdeveloper\ide\bin\ide.conf

AddVMOption -Xmx4192M
AddVMOption -Xms512M

Above setting will allows to user 4 GB of RAM.

2. C:\Oracle\Middleware\jdeveloper\jdev\bin\jdev.conf

Point JDeveloper to use 64 bit Java Version

SetJavaHome C:\Program Files\Java\jdk1.6.0_23
AddVMOption -XX:MaxPermSize=1024M

Namespace prefix "oraext" qualifying cannot be resolved while Designing BPEL processes in Oracle SOA Suite 11g

2013-05-11T04:50:00.001-07:00

SOA Developers mainly encounters this issue while using Oracle Extension functions in the Assign or Transform activities.

This error occurs when namespace is not defined in your BPEL process. check two points here.
1. Is namespace : http://www.oracle.com/XSL/Transform/java/oracle.tip.pc.services.functions.ExtFunc is already defined in BPEL process or not ? if not, Define it as below.
xmlns:oraext="http://www.oracle.com/XSL/Transform/java/oracle.tip.pc.services.functions.ExtFunc"

2. If namespace is already defined in the BPEL process then you need verify the prefix value here.for example below is the entry found in BPEL process.
xmlns:ns4="http://www.oracle.com/XSL/Transform/java/oracle.tip.pc.services.functions.ExtFunc"

here you need rename the prefix values "ns4" to "oraext". OR

modify the function name prefix in Transformation with "ns4"

Generate Webservice / deploy / redeploy buttons not visible in Oracle E Business Suite (EBS)

2013-03-08T02:11:00.003-08:00

Oracle E-Business Suite Integrated SOA Gateway (ISG) provides robust communication and Infrastructure for Integration with E-Business Suite (EBS) Applications. Oracle E-Business Suite Integrated SOA Gateway is build on top of Oracle Fusion Middleware & Service Oriented Architecture (SOA) technology.

As a Integration Architect / Designer you will require to route your integration requests through Integrated SOA gateway to EBS for more standardize Integratiion approch. Oracle provide all Integration Interfaces detail at common location that is Integration Repository. You can create web service for supported Interface types using Integration repository. However to generate web services for respective Interface type you have to have appropriate roles and responsibilities assigned to your user.

Integrated SOA Gateway implements Role Based Access Control security for secure access to Interfaces.There are 3 different roles to provide different access to Integrated SOA Gateway.

Integration Repository Administrator
System Integration Developer
System Integration Analyst

Below table show each role and access to the features for respective roles. This roles have to be manually assigned to each user when required except for SYSADMIN.

This is most common issue while performing EBS Integration. You have to follow below steps for assigning appropriate role to the user and then user should be able see Generate WSDL button or SOA provider section is web services are already generated.

Option 1 :

user SYSADMIN user which is by default having appropriate roles assigned and you should be able to see Generate WSDL buttion.

Option 2:
Get the appropriate role assigned by requesting your system administrator. Below are the steps system Administrator need to follow to assign correct role for the user. So that user can have access to Generate WSDL / deploy / redeploy access.

1. Log into Oracle Applications using sysadmin/.
2. Select the User Management responsibility in the Navigator.
3. Click the Users link from the navigation menu to open the User Maintenance window.
4. Locate the user trying to use.
5. Assign the role and select the "Irep Administrator" role.
6. Bounce the middle tier because after assigning roles they don't take affect unless the cache is cleared and bounce middle tier.
7. Now log in as the user and access the " Integrated SOA Gateway" responsibility ->Integration Repository and should see the Generate WSDL button

How to write & Configuring JSON web service for Apache Axis2

2012-05-22T02:28:00.001-07:00

Recently I was working on one of the project where there was requirement of implementing the Axis2 Web service with JSON support. Here I have used Apache Tomcat 7.0 Web Server for configuration. During initial phase I have gone through the documentation provided on Apache site for JSON Support and thought it would be easy to implement as we can write any POJO service first and that SOAP Service can be exposed as JSON Web Service.However it was not so simple as there were issues in the library used ie. Jettison. This library requires patch to support functionality.

JSON stands for Java Script Object Notation. And it is data exchange format similar to XML. JSON is very light weight and becoming popular these days.It defines data in key value pair as we are doing in case of Properties file however here we maintain parent child relationship as well. You can find more information on this on JSON website.

As this article is written on how to configure JSON with Apache Axis2 on Tomcat 7.0. Below details cover only technical information on how to configure JSON and writing JSON Web Service.

For this article I am using Tomcat version 7.0.26 and it has been installed Red hat 5.6.Axis2 is installed and configure as explain in Apache's Axis2 Website.

Tomcat Installation directory is : /usr/share/apache-tomcat-7.0.26/
Axis2 Installation directory : /usr/share/apache-tomcat-7.0.26/webapps

JSON Configuration changes on Tomcat 7.0

Download Dynamic Response Handler and copy it to /usr/share/apache-tomcat-7.0.26/webapps/axis2/WEB-INF/modules
\Go to /usr/share/apache-tomcat-7.0.26/webapps/axis2/WEB-INF/lib and rename jettison-1.0-RC2.jar Using below command mv jettison-1.0-RC2.jar jettison-1.0-RC2.jar.bak
Provide update jettison jar file. Copy patched jettison-1.2-patched.jar to /usr/share/apache-tomcat-7.0.26/webapps/axis2/WEB-INF/lib location & restart tomcat
Modify axi2.xml at location /usr/share/apache-tomcat-7.0.26/webapps/axis2/WEB-INF/conf Add following Message Formatters and Message Builders.
```
&lt;messageFormatter contentType="application/json" 

                          class="org.apache.axis2.json.JSONMessageFormatter"/>

         &lt;messageFormatter contentType="application/json/badgerfish"

                          class="org.apache.axis2.json.JSONBadgerfishMessageFormatter"/>

        &lt;!--&lt;messageFormatter contentType="text/javascript" 

                         class="org.apache.axis2.json.JSONMessageFormatter"/> -->
```
```
&lt;messageBuilder contentType="application/json"
                                 class="org.apache.axis2.json.JSONOMBuilder"/>
  &lt;messageBuilder contentType="application/json/badgerfish"
                                 class="org.apache.axis2.json.JSONBadgerfishOMBuilder"/>
  &lt;!--&lt;messageBuilder contentType="text/javascript"    
        class="org.apache.axis2.json.JSONOMBuilder"/>-->
```
5. When we are performing conversion from XML to JSON and viceversa. There are two convention that we follow. which are mentioned above.

- Mapped Convention

- Badgerfish Convention

Below is the example on how xml can be converted to JSON string for both the conventions which taken from Apache website

XML If we use the namespace mapping as http://foo.com -> foo
```
&lt;xsl:root xmlns:xsl="http://foo.com">&lt;data>my json string&lt;/data>&lt;/xsl:root>
```
Equivalent JSON (Mapped Convention)
```
{"foo.root":{"data":"my json string"}}
```
Equivalent JSON (Badgerfish Convention)
```
{"xsl:root":{"@xmlns":{"xsl":"http://foo.com"},"data":{"$":"my json string"}}}
```
Now you can simple develop your any web service application and can communicate with that service using JSON.

6. You can simply create Hello World application to echo request message. and call that HelloWorld service as below get the response in JSON format.

Mapped Convention : Http://localhost:8080/axis2/services/HelloWorldService/echoMethod/response=application/json

Badgerfish Convention: Http://localhost:8080/axis2/services/HelloWorldService/echoMethod/response=application/json/
7. And while sending a request to JSON service content-type should be set to application/json.

I have not included the steps here to create POJO Service, this is very well documented on Apache website.

Reference sites :
http://jettison.codehaus.org/
http://axis.apache.org/axis2/java/core/docs/json_support.html
http://www.marcusschiesser.de/2009/01/building-a-json-web-service-with-java-and-axis2/

Why Oracle Service Bus 11g ? Key Benefits and Advantages

2011-10-06T09:03:00.000-07:00

This blog covers key benefits and advantages we can achieve with the implementation of Oracle Service Bus 11g. Actually I have been asked by Client to list down the capabilities they will get with the Oracle Service Bus 11g Implementation and this is what they got from me and lead to this blog finally.

1. Service Virtualization :

A core principle of SOA is to ensure that any service consumer can access any service provider - and from any platform. This has been considered as key principle in OSB and it provides robust way of Vitalizing the Service. It’s a great value add in SOA Architecture.

2. Loose Coupling

                     OSB provides loose coupling by mediating between Service provided and Consumer. Without mediation Service consumer and provider will create dependency to each other. A change in single side provider/consumer will lead to the change dependent consumer/provider respectively. OSB bridges the gap of transport, message format, security technology etc.

3. Location Transparency

                     It’s a strategy to hide physical location of actual physical location of service endpoints from the Service Consumer. All Service consumers should know only single logical machine & port name for each service. This allows for greater flexibility when managing your services. You can add, move, prioritize and remove service endpoints as needed without needing to recompile your service consumer again.

4. Seamless Connectivity

                     While newer applications may expose services over standard, easily consumable interfaces such as SOAP, an overwhelming majority of the services available in enterprises are still locked in legacy systems, from mainframes to custom applications. The first task of an OSB is to ensure that all these existing assets can be easily accessed and integrated. An OSB offers rich and comprehensive connectivity options to standard interfaces (SOAP, messaging, etc.) and also to packaged applications and legacy systems via adapters such Siebel Adapter, Peoplesoft Adapter etc.

5. Routing

                     After having a seamless connectivity next task is that data and messages need to flow reliably. OSB offers efficient, secure and reliable transport options. OSB also provides advance routing facilities to determine where the data needs to go. Such routing can be done based on headers, content or other external rules.

6. Performance

                      OSB is stateless & light weight; hence provide the excellent performance result under stress conditions as well.

7. Transformation

                       Oracle Service Bus provides run time transformation capability and support industry standard for middleware :XML, XSLT, XQuery & XPath.

8. Support for Event Driven Architecture

                       Oracle Service Bus support Oracle’s latest Event Driven Architecture.

9. Security & Policy

                        OSB provides centralized way of implementing the Security for Integration which results into highest level of standardization and control on security issues. Security is best enforced using policy driven framework because it allows to implement security details outside of the Application & easy to maintain. This makes it complete pluggable component & highly Agile which can be changed without modifying the actual application as per the organization policy’s and compliance.

10. Service Polling

                       Oracle Service Bus supports service polling. This allows to OSB to automatically detect live service and remove others from the list. This has a significant impact in performance.

11. Load balancing & Failover

                       Oracle Service Bus supports multiple load balancing algorithms to load balance between endpoints. It automatically detects a failover and removes it from Load balanced urls.

12. Service Throttling

                       Service throttling is a new feature in Oracle Service Bus which allows to restrict the load for particular service. This has great value when it comes to Service up time.

13. Monitoring

                       Oracle Service Bus provides two way monitoring.
Proactive Monitoring: Here Integrator can monitor the dashboard and check the performance of the service bus which can help to tune the server effectively. Tracking the server performance over time can help to plan capacity planning well in advance.

Reactive Monitoring: Here OSB will monitor the Server and look for specific conditions to occur and it will automatically sends the Alert to users, Admin etc. Alert can be in the form of Email, JMS, SMS etc.

14. Message Validation

                       Oracle Service Bus support normal data level value check validation as well as Schematron Validation.

15. Value Added Feature

                  a. Support for Domain Value Map

                  b. Support for Cross Reference

                  c. Support for Package application Adapters

                  d. Support for Advance message formats such as SWIFT and FIX in financial Service Domain.

Decrease / Increase / Resize tablespace in Oracle Database

2011-10-05T09:41:00.000-07:00

Below is the list of commands you can use to increase / decrease / Resize your tablespace in Oracle Database. I run this commands in Oracle 11g database however these should also run fine in other versions of Oracle as well.

Adding more tablespace
Alter tablespace add datafile 'datafile_location_where_file_will_be_added_without_file_name' size 1G;

Checking size of datafiles
Select name, bytes from v$datafile;

Decreasing Tablespace
Say your datafile is of size of 10 gb and you want to decrease it by 6 GB you can use below command.
Alter database datafile 'complete_path_to_datafile_goes_here' resize 4G;

Above command may not work it space is already utilized and data is alredy there in the file. Oracle may throw appropriate error message like below.

ORA-03297: file contains used data beyond requested RESIZE value

ORA-12516, TNS:listener could not find available handler with matching protocol stack

2011-07-29T08:56:00.000-07:00

In one of my SOA project, we are running SOA Suite 11g - 11.1.1.4 on Weblogic 11g Cluster in Bladframe machine. Backend used here for SOA Schema database is Oracle 11g RAC database.

After couple of weeks of successfully execution in developement environment we hit this issue of ORA-12516, TNS:listener. This error generally means there is no connection available to the database.We need to configure the database to allow more connection.

As suggested by Oracle, we should have number of processes setting to 200 for SOA Suite 11g. This setting is already in place and still we hit the ORA-12516, TNS:listener-issue. This happens mostly because of wrong Data sources connection settings, which allows to exapand its connection pool to hundreds of connections.

Even while restarting the weblogic server you will not be able to get the weblogic server in running mode , because all data sources will fail while trying to connect to database and you server state will go to Admin mode because of this.

Solution to ORA-12516, TNS:listener Error

Loging to one of the database node using sqlplus as sys or system (basically sysdba role required)
Increase the number processes and sessions by executing below commands

ALTER SYSTEM SET PROCESSES=400 SCOPE=SPFILE;
ALTER SYSTEM SET SESSIONS=400 SCOPE=SPFILE;

Bounce the database again to take these changes

SHUTDOWN IMMEDIATE;
STARTUP;

To Verify the settings are updated properly; execute below sql commands

SHOW PARAMETERS PROCESSES;
SHOW PARAMETERS SESSIONS;

If you are using Oracle RAC database you may want to perform these steps again on another node.

Installing Oracle XE 11g Database on Redhat 5.6 / Linux 64 bit

2011-07-14T09:41:00.000-07:00

Recently Oracle has announced the Beta release of Oracle Express Edition (XE) 11g. Below is the step by step process for the installation of Oracle XE 11g database on Linux x86-64 machine.

Installation of Oracle XE 11g is pretty straight forward process and all step by step installation steps are included here in this tutorial. All XE version of oracle are very easy to install and configure while you are in development mode.

Oracle XE 11g Installation steps :

You can download the most recent version of Oracle XE 11g database by refering the details on http://www.oracle.com/technetwork/database/express-edition/overview/index.html.
This installation will require minimum of 1.5 GB of RAM, so please make sure you have required space available on your machine.
Swap space required is 2 GB or twice the size of RAM. Whichever is less.

To check current you can run command swapon -s on shell.

And to start the installation it requires root permission on linux box.
execute the below command to install the Oracle XE 11g
Oracle does not provide a way to install Oracle XE 11g on particular directory. It will install it directly on root /u01 but if you want to install this on directory of your choice use my post Hacker's choice.
rpm -ivh oracle-xe-11.2.0-0.5.x86_64.rpm below is the command with output
rpm -ivh oracle-xe-11.2.0-0.5.x86_64.rpm
Preparing... ########################################### [100%]
1:oracle-xe ########################################### [100%]
Executing post-install steps...

You must run '/etc/init.d/oracle-xe configure' as the root user to configure the database.
Execute below command to configure Oracle XE 11g database.
```
$ /etc/init.d/oracle-xe configure
```
It will ask for HTTP Port , database listener port, and password for the database which will be used for SYS and SYSTEM. Below is the complete installation output.
--> /etc/init.d/oracle-xe configure

Oracle Database 11g Express Edition Configuration
-------------------------------------------------
This will configure on-boot properties of Oracle Database 11g Express
Edition. The following questions will determine whether the database should
be starting upon system boot, the ports it will use, and the passwords that
will be used for database accounts. Press to accept the defaults.
Ctrl-C will abort.

Specify the HTTP port that will be used for Oracle Application Express [8080]:

Specify a port that will be used for the database listener [1521]:

Specify a password to be used for database accounts. Note that the same
password will be used for SYS and SYSTEM. Oracle recommends the use of
different passwords for each database account. This can be done after
initial configuration:
Confirm the password:

Do you want Oracle Database 11g Express Edition to be started on boot (y/n) [y]:

Starting Oracle Net Listener...Done
Configuring database...Done
Starting Oracle Database 11g Express Edition instance...Done
Installation completed successfully.
Now start the Oracle XE 11g database by using below command
--> /etc/init.d/oracle-xe start

If you want to stop command is --> /etc/init.d/oracle-xe stop

Uninstalling the Oracle XE 11g #

--> rpm -qa | grep oracle

--> rpm -e oracle-xe

Hacker's Choice - How to Install Oracle 11g XE on Specified Targeted Directory

2011-07-14T05:02:00.000-07:00

If you are installing Oracle 11g XE on Linux machine, it is getting installed by default on root (/). And it does not provide a way to change.

Oracle is not providing a way to specify the destination directory / user defined directory for Oracle XE 11g Database. So here is the hack for how to install Oracle XE database on directory of your choice.

create a symbolic link with the name /u01 in root directory which point to /app/oracle.
For Oracle XE 11g use below commands
--> cd /
--> ln -s / u01

Same trick works for Oracle XE 10g as well.

And .... yeah enough you are done. Go ahead with your normal installation and it will be installed to /app/oracle.

How to enable GUI while connecting to Remote Redhat / Linux machine using Putty

2011-07-14T02:45:00.000-07:00

Hi, This post cover details about how we can enable GUI interfacing using Xserver while connecting to Remote Redhat 5.6 / Linux Machine using Putty on Windows based local machine.

First all of you need to install Xserver in your local box. Here is the download location for Windows. Here Xserver will be installed using Xming.
Location : http://sourceforge.net/projects/xming.

After downloading install the Xming server in your localbox and run it with option ":0 -clipboard -multiwindow -ac". To do this, right click the short cut of Xming -> go to properties -> and in target its should look similar to this "C:\Program Files\Xming\Xming.exe" :0 -clipboard -multiwindow -ac (here double quates are part of the string itself), depending on the location of Xming installation path may change.

On Redhat / Linux machine has feature called X11Forwarding, depending on the value of this parameter it enables or disables the display of graphics on the server.

On Redhat / Linux machine
For example,

login on Linux/BSD system called myserver.mydomain.com
Open /etc/ssh/sshd_config file using text editor:

# vi /etc/ssh/sshd_config

Find out parameter X11Forwarding and set it to yes:

X11Forwarding yes
Save file & exit shell prompt

Restart sshd service under Debian Linux:

# /etc/init.d/ssh restart
Alternatively, if you are using Fedora / Red Hat Linux restart sshd:
# /etc/init.d/sshd restart

Client Side Setting on Windows Machine
For connecting to Redhat Linux box I am using the most popular SSH client putty. Below are the steps to configure putty on Windows machine.

Run the putty.exe
provide Host Name (or you can use IP address of host machine as well
Select SSH as Connection Type
Port should be 22 default
Enter again the same name as you entered in Hostname in to Saved Session Input box.
In Connection Category, Find out the Connection Tree. In SSH, expand it and you will see "Enable X11 Forwarding"..
Enable X11 Forwarding by selecting the check box
X Display location should be set to localhost:0
Save this entire information as a session by click on Save button
Now start the Xming Server on location machine
Now connect to the Redhat / Linux Machine using saved session from putty
And to verify that Graphics are enable use this command xclock &
You should be able to new graphical window coming up.

Now you are all set to roll, you can execute and run any GUI based application from the Redhat / Linux box and it will get displayed on you local machine. Makes your life much easier :) cheers

Purging / Deleting / Limiting Database Growth in SOA Schema in SOA Suite 11g

2011-07-04T12:14:00.000-07:00

This post is about how to control the SOA database schema and its growth while running SOA Suite 11g. All the instructions given here are specifically for SOA Suite 11g version 11.1.1.4. From this version onward there are new scripts provided by Oracle and only updated scripts should be used as this version has schema and table structure changes.

There are basically three ways to delete/purge the SOA Schema database.

Using Enterprise Manager console -> Delete with options
Deleting large number of instances using purge script
Partitioning component database table

Using Enterprise Manager Console : Here, first option, using Enterprise Manager console is ok for small amount of instances where you want to remove one or two thousand instances . For large number of instances it will throw Time out error.There is a option provided in EM console for increasing the timeout period but still its not enough for large amount of data.

Deleting Large Number Of Instances Using Purge Script : This is very useful and straight forward process to clean up SOA database schema. In real world , server are receiving millions of requests in a day and keeping these all data as instances in SOA Suite database schema is very costly. It can affect a performance of the server up to some extent. After few days or month probably you will start receiving table space errors as allotted all the table sapce is already been used by the instances created within SOA database schema. For this reason you need to plan your tablesapce accordingly and generally it should be in between 50 GB - 80 GB in loaded server. And still it requires regular purging for data on the SOA database.

Below is the process for purging / deleting the composite instances from SOA Database schema.

1. First of all you will required Repository creation utility for 11.1.1.4. This installable contain the all required purging script provided by oracle to purge the database schema. You can find the purge script at location RCU_HOME/rcu/integration/soainfra/sql/soa_purge.

Note : this script can not run with Microsoft SQL Server and IBM DB2 Database.

2. In SQL*Plus, connect to the database AS SYSDBA:

3. Execute the following SQL commands:
GRANT EXECUTE ON DBMS_LOCK to dev_soainfra;
GRANT CREATE ANY JOB TO dev_soainfra;

4. RCU_HOME/rcu/integration/soainfra/sql/soa_purge/soa_purge_scripts.sql

5. execute SET SERVEROUTPUT ON on SQL prompt

6. execute below SQL block and description of each variable is given below

min_creation_date : minimum date when instance was created
max_creation_date : Maximum date when instance was created
batch_size :Batch size used to loop the purge. The default value is 20000.
max_runtime :Expiration at which the purge script exits the loop. The default value is 60. This value is specified in minutes.
retention_period :Retention period is only used by the BPEL process service engine only (in addition to using the creation time parameter). The default value is null
purge_partitioned_component : Users can invoke the same purge to delete partitioned data. The default value is false

DECLARE

   MAX_CREATION_DATE timestamp;

   MIN_CREATION_DATE timestamp;

   batch_size integer;

   max_runtime integer;

   retention_period timestamp;

BEGIN

   MIN_CREATION_DATE := to_timestamp('2011-06-23','YYYY-MM-DD');

   MAX_CREATION_DATE := to_timestamp('2011-07-03','YYYY-MM-DD');

    max_runtime := 15;

    retention_period := to_timestamp('2011-07-04','YYYY-MM-DD');

   batch_size := 5000;

     soa.delete_instances(

     min_creation_date => MIN_CREATION_DATE,

     max_creation_date => MAX_CREATION_DATE,

     batch_size => batch_size,

     max_runtime => max_runtime,

     retention_period => retention_period,

     purge_partitioned_component => false);

  END;

Here is very important to note that this script provided is able to delete instances from database schema however it will not free up the memory of that table / tablespace.

For freeing up the memory you can try this option below on tables.

alter table enable row movement.
alter table shrink space;

Tutorial 3 : How to Install Oracle SOA Suite 11g -11.1.1.3 Part III - Running Repository Creation Utility

2010-12-31T00:48:00.000-08:00

In this tutorial I am going to cover Schema creation in Oracle XE database which is required as a starting step before installing the SOA Suite 11g.

Here in this tutorial we are going to Run Repository Creation Utility provided by Oracle for SOA Suite 11g ( Version 11.1..1.3 ).

Go to the folder where you have downloaded the Repository Creation Utility version 11.1.1.3 ( c:\SOAInstallables as per tutorial I)

Double click the rcu.bat in folder structure similar to ofm_rcu_win_11.1.1.3.0_disk1_1of1\rcuHome\BIN\ and you should see below screen sequence.

1. Welcome Screen

2. As we want to create requred schema for installation select create.

3. Provide the required details

Note : username used here is SYS, this should be the user with SYSDBA role

4. Select the Components for which you want to generated schema tables.

5. Here you can choose to provide single username / password for all schema component or also you do have flexibility to provide username/password for individual components. For development environment use single username/password for all components.

6. This screen will allow you to choose different tables spaces for the components. kept it defult and press next.

7. Summary of all installation is generated at the last. Click close the finish the process.

Upgrade Weblogic Server 10.3.2.0 to Weblogic Server 11g (10.3.3.0)

2010-12-01T23:06:00.000-08:00

Here in this tutorial we are going to upgrade Oracle Weblogic Server 10.3.2.0 to Weblogic Server 11g i.e. 10.3.3 Version. This is very simple are pretty straight forward process.

If you are upgrading SOA Suite 11g 11.1.1.2 to SOA Suite 11.1.1.3 they you may required this to upgrade you Weblogic Server 10.3.2.0.

Go to the Program Files and Weblogic Installation and select Smart Update.

This is gona ask you for username and password for Oracle Support as shown in below screen shot. Provide the required information and login,

Now you should able to see Smart Update Wizard Screen as shown below, go to the Maintanance Packs and select Update.

As shown in below screen select release 10.3.2.0 and in right you should be able to see Weblogic Platform (10.3.3.0) in Upgrade options. Click OK

This will start Oracle Installer for Weblogic server 10.3.3.0 as shown in below screen. Click Next

Uncheck if you dont want to receive any update from oracle

Select the location where you want to download the installation files.

Here in below screen you need to specify in which directories you want to install the upgrade. Click Next to start installation process

After successful installation/upgrade you should be able to see below screen.

That's it. you done with the upgrade.

Tutorial 2 : How to Install Oracle SOA Suite 11g (11.1.1.3) Part II - Installing Oracle XE Database

2010-12-01T06:08:00.000-08:00

In this tutorial, I am going to cover installation for the Oracle database required for SOA Suite 11g. For developement purpose we are going to use Oracle Express edition of Database i.e. Oracle XE database. This tutorial and screen shots taken all are for Windows operation system but process is more or less similar in other operation systems as well.

This tutorial has to be followed properly and Oracle XE database has to be installed and configured perfectly. For successfull installation of SOA Suite 11g, this Oracle XE database has to be up and running before proceeding further for other tutorials.

If you have not download yet, Get the latest copy from Oracle website at http://www.oracle.com/technetwork/database/express-edition/downloads/index.html and save it to c:\SOAInstallables (This is the same director which we have created in first tutorial of How to Install Oracle SOA Suite 11g.

When you download the Oracle XE database make sure you download the Universal Installer

Note : When you are running Repository creation utility for creating schema in database before installing SOA Suite 11g, you will see warning that the database you are using is too old. you can safely ignore this warning as it applies for production environment.

As you are installing the Oracle XE as database server for SOA Suite 11g installation, It is important to know that what is the version when we say we are using Oracle XE Database. Database version for Oracle XE is 10.2.0.1 and SOA Suite 11g Installation requires actually 10.2.0.4 or higher or 11.1.0.7 or higher. And that is the reason we are getting the warning while running the Repository Creation Utility before installing SOA Suite 11g. Oracle XE is very good choice for small footprint database in SOA Suite 11g development environment.

Ok, Now you are ready to start with the installation of Oracle XE database for seting up SOA Suite 11g development environment.

Step 1 : Go to c:\SOAInstallables directory and click on OracleXEUniv.exe and It will start the Installation wizard as below. Click Next to proceed

Step 2: As shown in below screen shot select "I accept" and click Next

Step 3 : Specify the location where you want to install Oracle 10g Express Edition server and click next.

Step 4 : specify the password for the SYS and SYSTEM
user account for this database

Step 5 : Reviw the setting and click on Install

Step 6 : Wizard will start installing and copying files

Step 7 : Click on Finish

Step 8 : Go to this URL http://127.0.0.1:8080/apex/ and login using SYS and password you have specified for the SYS and SYSTEM user accounts while creating database. You will be able to see four icons

Administration
Object browser
SQL
Utilities

You won't need Oracle client here, all can be done from this User Interface.

Tutorial 1 : How to Install Oracle SOA Suite 11g (11.1.1.3) Part I

2010-12-01T06:07:00.000-08:00

Oracle SOA Suite 11g is consists of multiple oracle products and hence it requires to install and configure each of those products in particular sequence to make it work.

Here in this tutorial, I am going to list all the products you will require to install for Oracle SOA Suite 11g (11.1.1.3) and what are the requirement for those products to work correctly. And in next subsequent tutorials I am going to cover each product installation one by one. Below is the list of Tutorials and I am going update this post as and when I am ready with subsequent product installation tutorials.

Tutorial 2 : Installing Oracle 10g Express Edition database
Tutorial 3 : Creating repository using Repository Creation Utility ( version 11.1.1.3)

Memory Requirements :

To install Oracle SOA Suite 11g, you will required atleast total around 12 GB of memory space including installable files, else you may need to seperate out your installation of SOA Server, Weblogic Server, JDeveloper and Database server separately on different machines.

Download Installable Files :
Download all below files and store it at particular location on local machine say c:\SOAInstallables
Go to the http://www.oracle.com/technetwork/middleware/soasuite/downloads/index.html and download required software.

We are going to install SOA Suite 11g (11.1.1.3) and all the products needs to be install for setting up SOA Suite 11g (11.1.1.3) are listed at http://www.oracle.com/technetwork/middleware/soasuite/downloads/index.html.

Database
If you don't already have an Oracle database installed, choose Oracle Express Edition for a small footprint database. (Oracle XE is suitable for development only. Ignore the warning during installation about the database version as that pertains to production installations.)
WebLogic Server
Download WebLogic Server 10.3.3.from the FMW download page, in the Runtime Software section
Repository Creation Utility
Download RCU 11.1.1.3.0 from the FMW download page, in the Required Additional Software section.
SOA Suite & Patch
Download SOA Suite 11.1.1.2.0 from the FMW download page, in the Runtime Software section.
Download SOA Suite 11.1.1.3.0 (patch) from the FMW download page, in the Runtime Software section.
JDeveloper
Download JDeveloper 11.1.1.3.0 from the FMW download page. Look for JDeveloper and Application Development Framework in the Required Addition Software section.
SOA Extension for JDeveloper
Install the SOA Extension using the JDeveloper Update Center. From the JDeveloper menu choose Help > Check for Updates. In the Update Wizard, select Search Update Centers and ensure Oracle Fusion Middleware Products is checked ( screenshot). Then ensure that Oracle SOA Composite Editor is checked ( screenshot, your version may not match the screenshot exactly). The SOA Extension is approximately 200 MB.

Overall process installation map will be something similar to below.

Image from Oracle.com