Tips & Tricks on Oracle Technology

Admin Tips

2024-10-24T19:39:00.000-07:00

To copy files from one linux box to the other linux box:

Using SCP -

To copy a file from B to A while logged into B:

scp /path/to/file username@a:/path/to/destination

To copy a file from B to A while logged into A:

scp username@b:/path/to/file /path/to/destination

Decrypt WebLogic Server Admin Password/SOA DB schema password

2021-11-24T22:13:00.001-08:00

recover database username and password of JDBC Connection pool – encrypted password resides in $DOMAIN_HOME/config/jdbc directory, in xml files
recover password of a keystore where we store SSL certificates
any encrypted password from config.xml located in $DOMAIN_HOME/config dir

Let’s roll:

NOTE: SerializedSystemIni.dat file exists in $DOMAIN_HOME/security directory.

1. Create a script decrypt_password.py in $DOMAIN_HOME/security directory and paste the following code into it:

from weblogic.security.internal import *
from weblogic.security.internal.encryption import *
encryptionService = SerializedSystemIni.getEncryptionService(".")
clearOrEncryptService = ClearOrEncryptedService(encryptionService)

# Take encrypt password from user
pwd = raw_input("Paste encrypted password ({AES}fk9EK...): ")

# Delete unnecessary escape characters
preppwd = pwd.replace("\\", "")

# Display password
print "Decrypted string is: " + clearOrEncryptService.decrypt(preppwd)

2. Set domain environment variables

source $DOMAIN_HOME/bin/setDomainEnv.sh

3. Get encrypted password, in this example from boot.properties file of AdminServer

#Username:
grep username $DOMAIN_HOME/servers/AdminServer/security/boot.properties | sed -e "s/^username=\(.*\)/\1/"

#Password:
grep password $DOMAIN_HOME/servers/AdminServer/security/boot.properties | sed -e "s/^password=\(.*\)/\1/"

Or for SOA schema, we can get the encrypted password from $DOMAIN_HOME/config/jdbc/SOADataSource-jdbc.xml

4. Navigate to $DOMAIN_HOME/security directory and run the following command to start decryption:

cd $DOMAIN_HOME/security

java weblogic.WLST decrypt_password.py


Initializing WebLogic Scripting Tool (WLST) ...

Welcome to WebLogic Server Administration Scripting Shell

Type help() for help on available commands

Please enter encrypted password (Eg. {AES}fk9EK...): {AES}jkIkkdh693dsyLt+DrKUfNcXryuHKLJD76*SXnPqnl5oo\=
Decrypted string is: welcome01

Decrypted value will be displayed on the screen.

Source: http://tinyurl.com/km92oto

Otherwise try oracle suggested steps, but this only works if you are logged on to the same server:

Document 2852454.1 (oracle.com)

2. Run WLST:

cd /u01/app/oracle/middleware/oracle_common/common/bin
./wlst.sh

3. Set the domain and decrypt the password:

domain = "COMPLETE PATH TO DOMAIN HOME"
service = weblogic.security.internal.SerializedSystemIni.getEncryptionService(domain)
encryption = weblogic.security.internal.encryption.ClearOrEncryptedService(service)
print encryption.decrypt("PASSWORD FROM ABOVE datasource xml file")

create and post message to AQ with XMLTYPE as the payload type.

2017-03-07T21:26:00.003-08:00

This post shows how to create an AQ with XMLTYPE as the payload type.
This is useful when the payload structure is not known or DB guys do not want to define objects and just go with XMLTYPE.
It can accept any xml request, which can then be consumed and transformed accordingly in SOA for further use.

I assume you already have privileges to create AQ. (If not then refer this post to grant privileges.)

--Queue Table
BEGIN
DBMS_AQADM.CREATE_QUEUE_TABLE( Queue_table => 'QT_SampleQueue', Queue_payload_type => 'SYS.XMLTYPE', Sort_list => 'ENQ_TIME', COMMENT => 'A sample queue table');
END;

--Queue
BEGIN
DBMS_AQADM.CREATE_QUEUE (
queue_name =>'SampleQueue',
queue_table=>'QT_SampleQueue');
END;

SELECT queue_table,type,object_type,recipients FROM USER_QUEUE_TABLES;

exec DBMS_AQADM.START_QUEUE('SampleQueue');

--Post request
DECLARE

queue_options DBMS_AQ.ENQUEUE_OPTIONS_T;
message_properties DBMS_AQ.MESSAGE_PROPERTIES_T;
message_id RAW(16);
message SYS.XMLType;

BEGIN

message := sys.XMLType.createXML('<catalog>

   <book id="bk101">
      <author>Gambardella, Matthew</author>
      <title>XML Developer's Guide</title>
      <genre>Computer</genre>
      <price>44.95</price>
      <publish_date>2000-10-01</publish_date>
      <description>An in-depth look at creating applications 
      with XML.</description>

</book></catalog>');

DBMS_AQ.ENQUEUE( queue_name => 'SampleQueue',
enqueue_options => queue_options,
message_properties => message_properties,
payload => message,
msgid => message_id);
COMMIT;
END;

Generate a Unique ID to be used as Correlation for Asynchronous flows in SOA

2017-03-07T21:10:00.000-08:00

In case of asynchronous flow, sometimes we need a unique ID to track the flow across different system or different services. we can use the XSLT function oraext:generate-guid() to generate the ID.

In below example I am defining a variable as assigning the unique ID to it, and later restructuring.
you can also directly use it in a XSLT transformation.

<variables>
<variable name="correlationID" type="xsd:string">
<from>oraext:generate-guid()</from>
</variable>
</variables>

<assign name="Assign_ServiceRequestDetails">
<copy>
<from>concat(substring($correlationID,1,8),'-',substring($correlationID,9,4),'-',substring($correlationID,13,4),'-',substring($correlationID,17,4),'-',substring($correlationID,21))</from>
<to>$serviceRequest/ns14:CorrelationID</to>
</copy>
</assign>

After restructuring in assign:

This id can be use in all the subsequent bpel processes to track the flow.

WLST script to get coherence server status

2016-05-31T22:43:00.001-07:00

If coherence is installed on weblogic server, we can monitor the status of the coherence server using below WLST script. In this script I am passing connection details as a parameter, you can follow any other approach or simply provide details in "connect()" function.

save below script as getCoherenceHealth.py

#redirect wlst's own output to null, print lines in the script itself
redirect('/dev/null', 'false')

wlsuser = sys.argv[1]
wlspassword = sys.argv[2]
wlsurl = sys.argv[3]
#targetServer = sys.argv[4]

connect(wlsuser,wlspassword,wlsurl)

servers = cmo.getCoherenceServers()
domainRuntime()
stoppedServers = []

for server in servers:
try:
cd('/CoherenceServerLifeCycleRuntimes/' + server.getName())
currentState = cmo.getState()
if currentState == 'RUNNING':
print server.getName() + ': ' + 'RUNNING'
else:
print server.getName() + ': ' + 'DOWN (' + currentState + ')'

except WLSTException, e:
print server.getName() + ': ' + 'SHUTDOWN'
stoppedServers.append(server.getName())

disconnect()
#rm ./wlst.log
exit()

you can call this script by passing required arguments:

java -cp $WL_HOME/server/lib/weblogic.jar weblogic.WLST getCoherenceHealth.py $WebUSER $WebPass $WL_URL

Useful Excel functions for a SOA resource

2015-12-20T20:33:00.000-08:00

VLOOKUP Function:

One simple requirement for VLOOKUP function is to compare two sheet and find out the matching rows.

For example here we have two tables of Order ID’s and we want to match them (get matching and not matching ID’s).

We can copy both the list in same or to be more clear in different sheets.

On an available cell, we need to write the VLOOKUP function as below, So this lookups for a value in

an array range and if found returns a column of that matched row.

Range lookup = true – approx. match will be returned

Range lookup = false – exact match will be returned

range_lookup (optional)

A logical value that specifies whether you want VLOOKUP to find an exact match or an approximate match:

· TRUE assumes the first column in the table is sorted either numerically or alphabetically, and will then search for the closest value. This is the default method if you don't specify one.

· FALSE searches for the exact value in the first column.

So below function fulfils our purpose.

But there is one complexity, we don’t want to write this function for each cell, but rather drag it to reflect in all cell, but when we drag and copy cell it increases all cell values even the range.

But we want to keep range fixed:

=VLOOKUP(A3,Table2!A3:A18,1,FALSE)

To resolve this add a couple of $ as shown below and it will fix the values of range, you are good to drag now, it will only increase the lookup value.

=VLOOKUP(A2,Table2!$A$2:$A$17,1,FALSE)

To Split a cell:

Sometimes we need to split a cell to extract a value. For example here we need to get just the order Id and need to get rid of any extra text.

In this case our requirement is to just split it as fixed length, but we can do this for delimited values as well.

Select the whole column, go to the Data tab present in the top ribbon and select Text to columns.

Drag the arrows from left side to the position where you want to make the cut.

Finish the process and you are done.

BPEL correlation and Message Aggregation

2015-10-14T03:15:00.000-07:00

How does BPEL identify which response is for which request?

We all know that there are two major type of processing synchronous and asynchronous and for synchronous processing it uses same TCP connection or in simpler terms single port. So there is no need of correlation for synchronous process.

For Asynchronous processing, BPEL process will usually correlate message using "WS-Addressing", it’s something like web session cookies, which happens internally and we do not need to worry about correlating response messages.

WS-Addressing

The basic question every beginner has is how an asynchronous response gets mapped to the correct instance out of many waiting instances. The answer is, whenever asynchronous service is invoked, Oracle BPM adds a message UID in WS-Addressing headers that flows with SOAP packets, which are used internally by BPEL server to correlate the request/response.

So when does we need manual Correlation?

Below are the scenarios when we will require correlation:

When external web service doesn’t support WS-Addressing
When the message travels through several services and the response is solicited by the initial service from the last service directly. For example, Request path is A > B > C and response comes to A directly from C, i.e. C > A
When receiving unsolicited messages from another system.
When communicating via files, i.e. When BPEL instance is expecting messages from a third party.

What is correlation?

It is a BPEL technique called correlation set to match or correlate the messages based on content of the message.

It is a collection of properties used by the BPEL process service engine to allow custom correlation.

Before starting with our example we need to understand in which activities do we need correlation. Well the answer is quite self-explanatory, we need correlation whenever data is going out or coming in to the BPEL process, i.e.

Receive activity
Reply activity
Invoke activity
onMessage branch
onEvent branch

I will first give the scenario of our example:

you can download the sample from here.
we will have two receive activities in our BPEL process,
One receive will take input as Country Name and Language
Other receive will take input as Country Name and Capital.
The response will have Country Name, Language and Capital.

we will use Country Name to correlate both the incoming messages and form correct output based on both the input.
we will first initiate exposed web service with input Country Name and Language.
It will wait at the other receive activity to receive activity. once it receives the same country name as input for the other exposed service, the first instance will complete processing.

We can see our deployed process has two services, we will first initiate - CountryInput

Here we have given input as Austtralia and English (ignore the typo mistake)

we can see the instance is waiting at the other receive activity.

Let us initiate another request for the same CountryInput to be more clear on behavior.
Here i have given input as Finland and Finnish.

Again the instance is waiting at the other receive activity.

Now let us initiate our other service which is CapitalInput.

Let's try with giving a different Country, other than what we initiated earlier for which the instances are waiting. Here I have given India as country name, but no instance is waiting to receive India, so nothing the previous processes should continue waiting.

As we can see, nothing happened and it did not un pause the previous instances.

Now lets give the country Name as Austtralia, and capital as canbarra, remember for Austtralia, one instance is waiting, so initiating this request should unpause the waiting instance for country name Austtralia.

we can see this has unpaused the previous flow, Lets check the response to see if it has correctly mapped the country, capital and language or not

we can see from the response, the details are correctly mapped, So, we saw that it only unpaused the matching country name, the other instance with country name as finland is still waiting.

Lets unpause the flow for Finland also, here i have given input as Finland and Helsinki

We can see that it has unpaused correct instance and hence formed correct response.

Now let's start with the development of our example:
First create a bpel process with two receive activities, one taking input as country Name and Language and other taking input as country Name and Capital.

create a new application and new project and give a proper name.

Let us first create a schema for our input and outputs - Country.xsd

I have created 3 elements, for two receive and one response

<?xml version="1.0" encoding="windows-1252" ?>

<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"

xmlns="http://www.example.org"

targetNamespace="http://www.example.org"

elementFormDefault="qualified">

<xsd:element name="CountryInput">

<xsd:annotation>

<xsd:documentation>

A sample element

</xsd:documentation>

</xsd:annotation>

<xsd:complexType>

<xsd:sequence>

<xsd:element name="CountryName" type="xsd:string"/>

<xsd:element name="Language" type="xsd:string"/>

</xsd:sequence>

</xsd:complexType>

</xsd:element>

<xsd:element name="CapitalInput">

<xsd:complexType>

<xsd:sequence>

<xsd:element name="CountryName" type="xsd:string"/>

<xsd:element name="Capital" type="xsd:string"/>

</xsd:sequence>

</xsd:complexType>

</xsd:element>

<xsd:element name="Output">

<xsd:complexType>

<xsd:sequence>

<xsd:element name="CountryName" type="xsd:string"/>

<xsd:element name="Capital" type="xsd:string"/>

<xsd:element name="Language" type="xsd:string"/>

</xsd:sequence>

</xsd:complexType>

</xsd:element>

</xsd:schema>

Now lets start with our bpel process. drag and drop or add a new bpel process.

for the default receive we want to have Country Name and language as input, so i have selected the elements accordingly and made it asynchronous.

Let us add a webservice, this is for the second receive.

we will generate WSDL for this webservice from the schema, click on the gear button and browse for the CapitalInput element. so for this webservice the input will be Country Name and Capital. Make it a one way process, as we just want to provide input here.

Add a receive activity for the second webservice.

add an assign activity.

Map the output to both the input to get all data.

Now the basic structure is ready, let's start Correlating the requests, as i said before we will use CountryName to correlate requests.
click on correlation sets and add a new correlation set.

Add a new property and name it accordingly, give type as string as Country Name is string.

Now we will add property Aliases, i.e. we will add the country Name coming from both the inputs.
select the element and give query to reach to the field- CountryName,
or you can do this from the Structure Window of the JDeveloper, right click on the 'Property Aliases' and select 'Create Propery Alias'
Select the message type that you want to set to the correlation propery (already created)

similarly select the other input and give query for the other CountryName

Our CorrelationSet, property and property alias is done. we can now add these to our receive activities.

double click on the first receive activity, go to correlations and add the correlation set we just created.
set Initiate as Yes as we want an instance to be initiated for this receive.
When set to yes, correlation set is initiated with the values of the properties available in the message being transferred
When set to no, correlation set validates the value of the property available in the message

Similarly double click on the second receive activity, go to correlations and add the correlation set we just created.
set Initiate as No as we don't want an instance to be initiated for this receive.

Our development is done, we have correlated both the receive activities with Country Name property. Lets deploy.

I got error while compiling because of the namespace we gave in the query field.
When we create CorrelationSet, all the details goes to .wsdl file (if .wsdl file for the project is not present for ex. you are using messaging adapters then it will go to .jca file)
We can see that my query has namespace as ns2 which is not valid.

for our variable the valid namespace is ns1, i just changed the namespace to ns1 and deployed our composite.

Apparantly in 12C Oracle has fixed this and has provided an option to browse to the variable and get query, so in 12C we won't be facing this issue, but for now in 11g you will just have to be cleaver i guess...

SOA12C: Getting started – Hello World project OSB

2015-10-12T23:10:00.003-07:00

One of the major change in 12C is the integration of OSB IDE within Jdeveloper and hence development and testing of SOA as well as OSB can now be done from within Jdeveloper without the need of installing Eclipse & OSB.

In our previous post we did a Hello World project in SOA, If you have not done that, first do SOA part as in this example we will be calling SOA service, now let’s get started with OSB.

In this sample we will call the Hello World project we created in SOA through business service.

you can download this sample from here.

Let’s first create a new application for service bus:

Name your project accordingly:

We can see below project structure got created:

Lets create a folder structure for our service, create the folder structure as per your convension:

Now it’s time to create the business service, here we will call the Hello World SOAapplication we created in earlier post.

Drag HTTP Technology adapter from the component palette on to the external services tab in the composite.

Enter the service name and in the next step select Application server and browse to the wsdl of Hello World SOA application:

Select port and click next.

OK now our business service is ready, drag a Pipeline from resource palette to Pipelines/Split Joins section, name it accordingly:

Here we will browse to the wsdl which got imported to our local system.

Connect pipeline component to the external HelloWorldBS.

Now you are ready to test the service. Right click on proxy service and click on Run, this will open a test console. Give the input and check for the result.

This project will call SOA HelloWorld composite, you can see the SOA instance in em console.

Previous: SOA 12C - Get started Hello World in SOA

SOA12C: Getting started – Hello World project SOA

2015-10-12T19:13:00.003-07:00

In the previous post I showed the installationof Oracle SOA in windows 7 machine and to configure integrated domain.

So let’s start with our sample Hello World Project:
you can download this sample from here.

Create a new SOA application:

Enter the Application name and directory location, for the first time you will have to create myworks directory for ex. For my case below is the location I have specified for this project:

Create an empty composite and click on finish, we will add bpel on next stage, though you can add bpel now in this stage as well, won’t matter much.

OK, now add a BPEL process, either drag from component pallet or right click on components pane and select bpel process.

Select a synchronous bpel process template because for our Hello World example, we need to see the response. Leave the input and output as default, the default schema will do for this example

An exposed service and a bpel component will appear in our composite.

Open the bpel process, we will see that receive and reply operations are already present, this is because while creating our project we selected synchronous operation.

Now add an assign activity, in this assign we will concatenate string Hello to the incoming message:

Our project is ready, next thing is to deploy the composite to our integrated server.

This is giving error for port 7102 which is our SSL port, we need to disable this to avoid this error, go to Admin console(http://localhost:7101/console/)

Click on Click on Home -> Servers -> Deafultserver -> Configuration -> General

Uncheck SSL Listen Port Enabled

you can test from em console or from the web service url or from JDeveloper itself.

Here i have used em console to test the process, to test it from Jdeveloper go to

Application Servers -> IntegratedWeblogicServer->SOA->DefaultServer->default->HelloWorld[Default1.0]->helloworldbpelprocess_client_ep

right click on this wsdl and click on Test Web Service.

Now test your composite again, here i have tested it from em console:

Next - SOA12C Get started - Hello World in OSB

SOA 12C installation in Ubuntu

2015-10-12T19:02:00.001-07:00

In this post we will see step by step installation process on Ubuntu platform. If you want to see if for Windows, refer my other post.

First step: Install Oracle JDK,

you can use below commands to install JDK7:

Open terminal and run below commands:

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:

Second step: Install Soa Suite 12C

Download the Generic version of installable. From OTN downloads.

go to the downloaded directory, extract the installable and run below command:

java -jar fmw_12.1.3.0.0_soa_quickstart.jar

Follow below screens to complete installation:

Give appropriate oracle home location:

Once installed it will open Jdeveloper (as we have selected the checkbox to open it :) )

check for updates and install extensions:

Now you are ready to start development.
Follow my other post to create an integrated weblogic domain.
and get started with development with Hello World sample.

SOA 12C installation Part 2 - Create Integrated weblogic server default domain

2015-10-11T23:27:00.003-07:00

In this post, we see how to create Integrated weblogic server default domain.

This is the second post for the series SOA 12C step by step installation,

So before proceeding with this post you need to read first part.

To create the default domain, go to Window--> Application Server:

Right click on IntegratedWebLogicServer and click on Create Default Domain.

Enter the domain password and accept defaults.

This domain creation will take some time to finish.

Once you are done with installation and configuration, its time to Get started with 12C development.

SOA 12C installation Part 1 - step by step installation

2015-10-11T23:10:00.003-07:00

In this blog we will see how to install SOA Suite 12 C on windows 7.

If you want to see installation steps on Ubuntu platform, refer my other post.

Step 1:

The first step is downloading the SOA 12C installable from Oracle OTN. Enter your Oracle Technology Network account, if you don’t have one you’ll need to create an account.

It includes Oracle BPEL Process Manager, Oracle Human Workflow, Oracle Business Rules, Oracle Mediator, Oracle Service Bus, Technology Adapters Oracle Enterprise Scheduler, SOA Spring Component, Enterprise Manager Fusion Middleware Control, Oracle JDeveloper with SOA IDE extensions and an integrated WebLogic Server and Java DB.

http://www.oracle.com/technetwork/middleware/soasuite/downloads/index.html

Step 2:

While the SOA suite is being downloaded, we can check on JDK versions. A recent version of JDK is required, I am using jdk-7u79-windows-x64.exe , I actually tried with JDK 8 but it SOA didn’t support that version so I had to revert to JDK7. If you don’t have java installed, download and install from below location:

http://www.oracle.com/technetwork/java/javase/downloads/jdk7-downloads-1880260.html

Step 3:

Install Java and set your Java_HOME environment variable to the installed location, for example, I have installed Java at C:\Oracle\12C\jdk.1.7.0_79

Step 4:

Now it’s time to install SOA Suite, unzip the downloaded SOA suite and open command prompt as an administrator:

Step 5:

Navigate to the downloaded & extracted installable location and run:

C:\Oracle\12C\jdk1.7.0_79\bin\Java -jar fmw_12.1.3.0.0_soa_quickstart.jar

Or navigate to installed Java Home directory and execute :

Java –jar C:\Drive\Softwares\12C\Windows\fmw_12.1.3.0.0_soaqs_Disk1_1of1\ fmw_12.1.3.0.0_soa_quickstart.jar

Step 6:

Select your preferred location for Oracle Home:

Step 7:

Click on Install.

Step 8:

click on Finish.

This will start JDeveloper.

AQ and SOA - Part2 - Posting message to AQ queue from SOA

2015-10-07T21:44:00.001-07:00

In the first part we created an AQ queue and posted a sample message into the queue.
In this part we will develop a soa composite to post message into AQ queue.

Before we start creating SOA composite, we first need to configure server resource to access AQ from SOA. We will need a datasource which connects to the database and an AQ outbound connection pool which we will use in our project.
we will create a bpel with exposed webservice to post message to AQ.
In our previous post while object for the queue we gave employee_id, employee_number

create or replace type employee_type as object(

employee_id number,

employee_number varchar2(60),

employee_name varchar2(60)

);

Let’s create a new application for this example:

Create an empty soa project:

Now first we need to create a schema file, as we are going to expose our BPEL as a web service, we will need to enter our input there which will later on be inserted into AQ.

Click on New and select XML Schema:

As we have specified 3 parameters(employee id, employee number and employee name) while creating AQ, in our input schema also we will give these 3 inputs to make things simple.

So let’s create an incoming schema.

<?xml version="1.0" encoding="windows-1252" ?>

<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"

xmlns="http://www.example.org"

targetNamespace="http://www.example.org"

elementFormDefault="qualified">

<xsd:element name="Employee">

<xsd:annotation>

<xsd:documentation>

A sample element

</xsd:documentation>

</xsd:annotation>

<xsd:complexType>

<xsd:sequence>

<xsd:element name="EmployeeID" type="xsd:integer"/>

<xsd:element name="EmployeeNumber" type="xsd:string"/>

<xsd:element name="EmployeeName" type="xsd:string"/>

</xsd:sequence>

</xsd:complexType>

</xsd:element>

</xsd:schema>

Now create a new bpel process and expose it as a web service, we will create a one way bpel as we do not expect any response, this process will just put message into AQ Queue, we will select the input as the schema element we just created.

Next step is to configure AQ Adapter.

The JNDI name will be the connection pool name created in weblogic console, which will point to the data source which will ultimately point to the database in which our queue is present:

We will define our outgoing schema from the fields present in queue.

As we have created a single consumer queue hence our queue is appearing in single consumer section.

If we create a multi consumer queue then it will appear in multi consumer section. The only difference from SOA point of view will be, while creating AQ adapter connection we will have to give the subscriber name used while creating the queue as the consumer name, which will appear in our .jca file.

We can see 3 new files got added in our project, an outgoing schema has been generated as per the fields present in the AQ queue:

Now the only thing left is to connect the dots J

Add an invoke to AQ Adapter, create a variable, and create a transformation from input variable to AQ Adapter variable.

Our code is ready now, deploy and test. This process will post the message into AQ Queue.

You can check the posted message In the queue:

SELECT * FROM aq$employee_queue_table;

user_data field gives the actual message:

SELECT user_data FROM aq$employee_queue_table;

Previous: Creation of AQ queue

AQ and SOA - Part1 - Creation of AQ queue

2015-09-22T05:37:00.001-07:00

Oracle AQ is a database queuing system and is implemented in database tables. So the first thing we need is database access.

Requirements:

If you have the database schema/user details in which you are going to create the queue then skip below step, otherwise,

Create a user:

sqlplus sys@localhost:1521/xe as sysdba

create user AQ_SOA_USER identified by oracle;

Grant priviledge to create tables and queues:

grant create session, resource, AQ_ADMINISTRATOR_ROLE,AQ_USER_ROLE to AQ_SOA_USER;

grant execute on DBMS_AQADM to AQ_SOA_USER; -- enque/dequeue priviledge to the user

grant execute on DBMS_AQ to AQ_SOA_USER; -- to enable compilation of a PL/SQL procedure

once we have the user details, login to database using above user(AQ_SOA_USER), you can use SQLDeveloper/Jdeveloper or any other tool available.

Create Object

create or replace type employee_type as object(

employee_id number,

employee_number varchar2(60),

employee_name varchar2(60)

);

Create a queue table

begin

DBMS_AQADM.CREATE_QUEUE_TABLE (

queue_table => 'AQ_SOA_USER.employee_queue_table',

queue_payload_type => 'AQ_SOA_USER.employee_type');

end;

Create a queue

BEGIN

DBMS_AQADM.CREATE_QUEUE (

queue_name =>'AQ_SOA_USER.employee_queue',

queue_table=>'AQ_SOA_USER.employee_queue_table');

END;

SELECT queue_table,type,object_type,recipients FROM USER_QUEUE_TABLES;

Start the queue

exec DBMS_AQADM.START_QUEUE('AQ_SOA_USER.employee_queue');

Enqueue AQ queue with PL/SQL package

DECLARE

enqueue_options dbms_aq.enqueue_options_t;

message_properties dbms_aq.message_properties_t;

message_handle RAW(16);

message employee_type ;

message_id NUMBER;

BEGIN

message := employee_type (10, 'D1001', 'John');

enqueue_options.VISIBILITY := DBMS_AQ.ON_COMMIT;

enqueue_options.SEQUENCE_DEVIATION := null;

message_properties.EXPIRATION := DBMS_AQ.NEVER;

DBMS_AQ.ENQUEUE (

queue_name => 'employee_queue',

enqueue_options => enqueue_options,

message_properties => message_properties,

payload => message,

msgid => message_handle);

COMMIT;

END;

SELECT * FROM aq$employee_queue_table;

SELECT user_data FROM aq$employee_queue_table;

Script to drop a queue if required:

begin

dbms_aqadm.stop_queue('AQ_SOA_USER.employee_queue');

exception

when others then

if sqlcode = -24010 then null; else raise; end if;

end;

begin

dbms_aqadm.drop_queue(queue_name =>'AQ_SOA_USER.employee_queue');

exception

when others then

if sqlcode = -24010 then null; else raise; end if;

end;

begin

dbms_aqadm.drop_queue_table(

queue_table => 'AQ_SOA_USER.employee_queue_table'

);

exception

when others then

if sqlcode = -24002 then null; else raise; end if;

end;

Next - Posting message to AQ queue from SOA

ORA-01653: unable to extend table DEV_MDS.MDS_ATTRIBUTES by 1024 in tablespace

2015-06-24T19:55:00.001-07:00

Sometimes we get below error while deploying our bpel to server.
To solve this either contact your administrator requesting to extend the tablespace assigned to respective schema or if you have access of DB, perform below steps:

Problem:

ORA-01653: unable to extend table DEV_MDS.MDS_ATTRIBUTES by 1024 in tablespace DEV_MDS

How to fix:

C:\Users\admin>sqlplus sys/welcome1@XE as sysdba

SQL> alter tablespace DEV_MDS add datafile 'C:\ORACLEXE\ORADATA\XE\DEV_MDS2.DBF' size 1000M

Rotate log files

2015-06-20T01:15:00.001-07:00

By default, when you start a WebLogic Server instance in development mode, the server automatically renames (rotates) its local server log file as SERVER_NAME.log00001, where SERVER_NAME is the name of the server. For the remainder of the server session, log messages accumulate in SERVER_NAME.log until the file grows to a size of 500 kilobytes.
Each time the server log file reaches this size, the server renames the log file using the syntax SERVER_NAME.lognnnnn, and creates a new SERVER_NAME.log to store new messages. By default, the rotated log files are numbered in order of creation using the syntax SERVER_NAME.lognnnnn, where SERVER_NAME is the name configured for the log file. You can configure a server instance to include a time and date stamp in the file name of rotated log files.
By default, when you start a server instance in production mode, the server rotates its local log file whenever the file grows to 5000 kilobytes in size. It does not rotate the local server log file when you start the server. For more information about changing the mode in which a server starts, see Change to production mode.
You can change these default settings for log file rotation. For example, you can change the file size at which the server rotates the log file or you can configure a server to rotate log files based on a time interval. You can also specify the maximum number of rotated files that can accumulate. After the number of log files reaches this number, subsequent file rotations overwrite the oldest log file.
Note: WebLogic Server sets a threshold size limit of 500 MB before it forces a hard rotation to prevent excessive log file growth.

To set up log file rotation:

1. If you have not already done so, in the Change Center of the Administration Console, click Lock & Edit (see Use the Change Center).

2. In the left pane, expand Environment and select Servers.

3. In the Servers table, click the name of the server instance whose log files you want to configure for rotation.

4. Select Logging > General.

5. To move old messages to another file when the current log file reaches a specific size:

a. In the Rotation Type list box, choose By Size.

b. In the Rotation File Size field, enter the file size that triggers the server to move log messages to a separate file. After the log file reaches the specified size, the next time the server checks the file size it renames the current log file by appending a 5-digit integer; for example, SERVER_NAME.log00007. After the server renames the file, subsequent messages accumulate in a new file named SERVER_NAME.log.

c. If you want to limit the number of log files that the server creates to store old log messages, select the Limit Number of Retained Files check box. Then in the Files to Retain field, enter the maximum number of files. If the server receives additional log messages after reaching the capacity of the last log file, it overwrites the oldest log file.

6. If you want to move old messages to another file at specific time intervals:

a. In the Rotation Type list box, choose By Time.

b. In the Begin Rotation Time field, enter the start time.

Use the following format: hh:mm, where hh is the hour in a 24-hour format and mm is the minute. At the time that you specify, the server rotates the current log file. If the time that you specify is already past, the server rotates the log file at the next scheduled interval, as specified in Rotation Interval.

c. In the Rotation Interval field, enter the interval at which the server saves old messages to another file.

d. If you want to limit the number of log files that the server creates to store old log messages, select the Limit Number of Retained Log Files check box. Then in the Files to Retain field, enter the maximum number of files. If the server receives additional log messages after reaching the capacity of the last log file, it overwrites the oldest log file.

7. In the Log File Rotation Directory field, enter the directory location where the rotated log files will be stored.

Enter an absolute pathname or a pathname that is relative to the server's root directory. By default, the rotated files are stored in the same directory where the log file is stored.

For more information, see A Server's Root Directory.

8. To include a time and date stamp in the file name when the log file is rotated, in the File Name field, add java.text.SimpleDateFormat variables to the file name and surround each variable with percentage (%) characters.

For example, if you enter the following value in the File Name field: myserver_%yyyy%_%MM%_%dd%_%hh%_%mm%.log, the server's log file will be named myserver_yyyy_MM_dd_hh_mm.log.

When the server instance rotates the log file, the rotated file name contains the date stamp. For example, if the server instance rotates its local log file on 4 March, 2005 at 10:15 AM, the log file that contains the old log messages will be named myserver_2005_03_04_10_15.lognnnnn. (The current, in-use server log file retains the name myserver_yyyy_MM_dd_hh_mm.log.)

If you do not include a time and date stamp, the rotated log files are numbered in order of creation SERVER_NAME.lognnnnn, where SERVER_NAME is the name configured for the log file. For example: myserver.log00007.

9. To activate these changes, in the Change Center of the Administration Console, click Activate Changes.
Not all changes take effect immediately—some require a restart

call-template vs. apply-template

2015-06-19T23:42:00.001-07:00

call-template:

<xsl:call-template name="somename"/> is like calling a function in a traditional programming language.

we can define a function in XSLT like:

and then we can call this function using <xsl:call-template name="printname"/>,
for ex.:

apply-templates:

<xsl:apply-template> tag signals the XSLT processor to find the appropriate template to apply, based on the type and context of each selected node.
for example - below is our xml file:

and below is the xslt we are operating on above xml:

the output of this xslt will be:

or in html format:

Testing JSR-160 Runtime ... failed

2015-05-06T23:34:00.001-07:00

Sometimes when we configure Jdeveloper for first time to some server, we get below error:

Testing JSR-160 Runtime ... failed.
Cannot establish connection.
Testing JSR-160 DomainRuntime ... skipped.
Testing JSR-88 ... skipped.
Testing JSR-88-LOCAL ... skipped.
Testing JNDI ... skipped.
Testing JSR-160 Edit ... skipped.
Testing HTTP ... success.
Testing Server MBeans Model ... skipped.

One solution which you will find everywhere over internet is to remove any proxy in Jdeveloper, or have the same proxy as in browser:
Goto Tools -> Preferences in jdeveloper and type "proxy" in the search box, the proxy setting will appear. Uncheck the proxy checkbox , save the setting and restart Jdeveloper.

However in some cases this is not the issue, if above does not work do below:
update your host file and add:

Adminserver-IP Hostname

now test your connection, your test should be successful.
Let me know how it goes :)

Oracle SOA Suite 11g - Preferences

2014-12-17T19:49:00.000-08:00

BPEL preference properties are extensively used in many projects.

One use case would be, passing the endpoint location to inoke activity. So it’s a very important command which a developer should know.

In 10g we had a functionality to add preferences to bpel process and by adding below command in bpel.xml file we could pass the value as a variable to our bpel process. And there was also an option to change the value of preference from BPEL console which made it dynamic.

Coming to 11g we still have this functionality but things has changed a little and now we need to add preferences in composite.xml file for a particular bpel process i.e. under component tab of a particular bpel:

Code Snippet of composite.xml

<implementation.bpel src="BPELProcess1.bpel"/>

<property name="bpel.preference.myPref">anyValue</property>

</component>

Now we can use the function ora:getPreference(myPref) in our bpel process to retrieve the value of the preference.

Code Snippet of .bpel

……………

<copy>

<to variable="Manager" part="payload"

query="/client:processResponse/client:id"/>

</copy>

……

</assign>

Or if we define the preference value in composite.xml as some endpoint location, we can use that in invoke.

<invoke name="Invoke_ExecuteEligibility" partnerLink="EligibilityManagement"
    portType="ns8:EligibilityManagementPortType_v1" operation="ExecuteEligibility"
    inputVariable="executeEligibilityRequest" outputVariable="executeEligibilityResponse"
    bpelx:invokeAsDetail="no">
    <bpelx:toProperties>
        <bpelx:toProperty name="endpointURI"
            >ora:getPreference('myPref')</bpelx:toProperty>
    </bpelx:toProperties>
</invoke>

It’s a very good approach to pass end points to invoke through preferences, as later on we can define preferences in cfgplan.xml which will override the values present in composite.xml while deployment.

So a better approach would be to give for ex localhost as the endpoint location in composite.xml and use that preference in invoke or assign.

And give the actual endpoint location in configuration plan(cfgplan.xml) file. For ex.

Code Snippet of cfgplan.xml

</property>

</component>

To change the preference value from console:

To change to values from the prefences go to the ‘Enterprise Manager’ (http://localhost:7001/em).
On the left go to :
Farm_soa_domain > Weblogic Domain > soa_domain > right mouseclick and select ‘System MBean Browser’.

Navigate to Application Defined MBeans > oracle.soa.config > Server : soa_server1 > SCAComposite > your_project > SCAComposite.SCAComponent > your bpel_process.
Select the Attribute ‘Properties’.

Change the value of our preference and click apply.

Run the bpel again to see if the new value got used in the process.

"ora 01882 timezone region not found" in Jdeveloper 12c

2014-11-13T11:54:00.003-08:00

While creating Oracle XE 10g Database connection from Jdeveloper in ubuntu(or any other system) sometimes we get below error:

"ora 01882 timezone region not found"

Below are the solution:

1.) Open JEV_HOME/jdevbin/jdev/bin/jdev.conf

add below line anywhere in the file:
AddVMOption -Duser.timezone="+05:30"

(UTC +5:30 is India's timezone, {works for me :)}If this does not work, google your time zone and try adding that)

2.) Right click on the project you have created and go to Project Properties->Run/Debug/Profile > Default (Configuration) > Edit > Launch Settings > Java Options — Set the value here to ” -Duser.timezone=”+05:30″ ” [ Do not use double quotes ]

Please note that sometimes UTC(Coordinated Universal Time) also works fine. i.e. -Duser.timezone=”UTC″

www.bookgraber.com

2014-02-04T00:01:00.002-08:00

www.bookgraber.com
We have created a website to encourage people to share and read books.
Please share your views on this website and the idea behind this.

afterall, reading is not expensive :)

How to run RDA for SOA

2013-06-28T05:23:00.000-07:00

refer here for basics of RDA and steps for running it for Weblogic.

below are the steps for running RDA for SOA:

/opt/app/aia/Middleware/Oracle_SOA1/rda/rda

[user@<host> rda]$ ./rda.sh -S SOA

-------------------------------------------------------------------------------

S370SOA: Collects Oracle SOA Suite Information

-------------------------------------------------------------------------------

Should RDA analyze Oracle SOA Suite 11g (Y/N)?

Hit 'Return' to accept the default (Y)

> N

[user@<host> rda]$ ./rda.sh -S SOA

-------------------------------------------------------------------------------

S370SOA: Collects Oracle SOA Suite Information

-------------------------------------------------------------------------------

Should RDA analyze Oracle SOA Suite 11g (Y/N)?

Hit 'Return' to accept the default (N)

> Y

Is SOA installed in an Oracle home other than '/opt/app/oracle' (Y/N)?

Hit 'Return' to accept the default (N)

> Y

Enter the SOA Oracle home to be analyzed

> /opt/app/aia/Middleware/Oracle_SOA1

Should RDA analyze Oracle WebLogic Server domain (Y/N)?

Hit 'Return' to accept the default (Y)

Enter the Oracle WebLogic Server domain home to be used for data analysis

Hit 'Return' to accept the default

(/opt/app/aia/Middleware/user_projects/domains/svt_aia_domain)

Oracle WebLogic Server list:

1 AdminServer

2 ucsvtaiams1

3 ucsvtaiams3

* All servers

Enter the number corresponding to the server directory name, or * to select

all servers, or . to terminate the list

> *

Enter an Oracle User ID (userid only) to view DBA_ and SOA related tables.

Hit 'Return' to accept the default (system)

> UCM_soainfra

Is 'UCM_soainfra' a SYSDBA user (will connect as SYSDBA) (Y/N)?

Hit 'Return' to accept the default (N)

> N

Is an alternative JDK used other than

'/opt/app/aia/Middleware/Oracle_SOA1/jdk' (Y/N)?

Hit 'Return' to accept the default (N)

> Y

Enter the location of the JDK used for Oracle SOA Suite

Hit 'Return' to accept the default (/opt/app/aia/Middleware/Oracle_SOA1/jdk)

> /opt/app/aia/jrockit-jdk1.6.0_31-R28.2.3-4.1.0

[user@<host> rda]$

-rw-r----- 1 user aia 14K Jun 25 16:01 setup.cfg

[user@<host> rda]$ ./rda.sh

-------------------------------------------------------------------------------

RDA Data Collection Started 25-Jun-2013 16:02:08

-------------------------------------------------------------------------------

Processing Initialization module ...

Processing OCM module ...

Processing CFG module ...

Processing PERF module ...

Processing OS module ...

Processing PROF module ...

Processing NET module ...

Processing Oracle WebLogic Server module ...

Processing WREQ module ...

Enter 'weblogic' user password:

Please re-enter it to confirm:

Processing SOA module ...

Enter UCM_SOAINFRA@aiasvt1-orasvip.rr.in.xyz.com.au:1521::UC1ASVT user password:

Please re-enter it to confirm:

Processing RDSP module ...

Processing LOAD module ...

Processing End module ...

-------------------------------------------------------------------------------

RDA Data Collection Ended 25-Jun-2013 16:19:28

-------------------------------------------------------------------------------

You can review the reports by transferring the contents of the

/opt/app/aia/Middleware/Oracle_SOA1/rda/rda/output directory to a location

where you have web-browser access. Then, point your browser at this file to

display the reports:

RDA__start.htm

Based on your server configuration, some possible alternative approaches are:

- If your client computer with a browser has access to a web shared

directory, copy the /opt/app/aia/Middleware/Oracle_SOA1/rda/rda/output

directory to the web shared directory and visit this URL:

http://machine:port/web_shared_directory/RDA__start.htm

- If your client computer with a browser has FTP access to the server

computer with the /opt/app/aia/Middleware/Oracle_SOA1/rda/rda/output

directory, visit this URL:

ftp://user@<host>.in.xyz.com.au//opt/app/aia/Middleware/Oracle_SOA1/rda/rda/output/RDA__start.htm

If this file was generated to assist in resolving a Service Request, please

send /opt/app/aia/Middleware/Oracle_SOA1/rda/rda/output/RDA.RDA_<host>.zip

to Oracle Support by uploading the file via My Oracle Support. If ftp'ing the

file, please be sure to ftp in BINARY format.

How to run RDA for weblogic

2013-06-28T05:20:00.002-07:00

RDA for weblogic

-----------------------

RDA is shipped with Oracle Fusion Middleware 11g. You will find it in two places

MW_HOME/ORACLE_SOA/rda
MW_HOME/oracle_common/rda

RDA has two phases, setup and run. Setup needs to done one time, In which RDA will ask several Questions.

It will store those answers in setup.cfg file in the same directory from where you are running rda.

Once setup is done, subsequent runs will use the information in setup.cfg

KM note 1352181.1 describes all questions asked for the SOA module.

Running RDA for weblogic Server:

Go to your domain home/bin directory and set:

. ./setDomainEnv.sh

Go to MW_HOME/oracle_common/rda

Here first time you need to run:

Use the following RDA command for setup - no security filter:

Unix:

rda.sh -S -p WebLogicServer

MS Windows:

rda.cmd -S -p WebLogicServer

OR:

Use the following RDA command for setup - with security filter (removes information such as hostnames, ip addresses)

Unix:

rda.sh -S -p WebLogicServer-Security

MS Windows:

rda.cmd -S -p WebLogicServer-Security

------------------------------------------------------------------------------------------------

[user@<host> rda]$ ./rda.sh -S -p WebLogicServer

-------------------------------------------------------------------------------

S000INI: Initializes the Data Collection

-------------------------------------------------------------------------------

RDA uses the output file prefix to identify all files belonging to the same

data collection. The prefix must start with a letter and must contain only

alphanumeric characters.

Enter the prefix to be used for all the generated files

Hit 'Return' to accept the default (RDA)

> Weblogic

Enter the directory used for all the files to be generated

Hit 'Return' to accept the default

(/opt/app/aia/Middleware/oracle_common/rda/rda/output)

Do you want to keep report packages from previous runs (Y/N)?

Hit 'Return' to accept the default (N)

Is a fresh collection performed as the default action (Y/N)?

Hit 'Return' to accept the default (Y)

Enter the Oracle home to be used for data analysis

Hit 'Return' to accept the default (/opt/app/oracle/product/11.2.0/client_1)

Enter the network domain name for this server

Hit 'Return' to accept the default (in.xyz.com.au)

-------------------------------------------------------------------------------

S010CFG: Collects Key Configuration Information

-------------------------------------------------------------------------------

S090OCM: Set up the Configuration Manager Interface

-------------------------------------------------------------------------------

S909RDSP: Produces the Remote Data Collection Reports

-------------------------------------------------------------------------------

S919LOAD: Produces the External Collection Reports

-------------------------------------------------------------------------------

S999END: Finalizes the Data Collection

-------------------------------------------------------------------------------

S100OS: Collects the Operating System Information

-------------------------------------------------------------------------------

S105PROF: Collects the User Profile

-------------------------------------------------------------------------------

S110PERF: Collects Performance Information

-------------------------------------------------------------------------------

Can ADDM, AWR, and ASH be used (Y/N)?

Hit 'Return' to accept the default (Y)

-------------------------------------------------------------------------------

S120NET: Collects Network Information

-------------------------------------------------------------------------------

Do you want RDA to perform the network ping tests (Y/N)?

Hit 'Return' to accept the default (N)

-------------------------------------------------------------------------------

S301WLS: Collects Oracle WebLogic Server Information

-------------------------------------------------------------------------------

Enter the location of the directory where the domains to analyze are located

(For example in UNIX, <BEA Home>/user_projects/domains or <Middleware

Home>/user_projects/domains)

Hit 'Return' to accept the default

(/opt/app/aia/Middleware/user_projects/domains)

For a successful WLS connection, ensure that the domain Admin Server is up and

running.

Data Collection Type:

1 Collect for a single server (offline mode)

2 Collect for a single server (using WLS connection)

3 Collect for multiple servers (using WLS connection)

Enter the item number

Hit 'Return' to accept the default (1)

> 1

Oracle WebLogic Server list for 'svt_aia_domain' Domain:

1 AdminServer

2 ucsvtaiams1

3 ucsvtaiams3

Enter the number corresponding to the selected server name

> 1

-------------------------------------------------------------------------------

S301WREQ: Handles the Oracle WebLogic Server Collection Requests

-------------------------------------------------------------------------------

S990FLTR: Controls Report Content Filtering

-------------------------------------------------------------------------------

[user@<host> rda]$

-rw-r----- 1 user aia 9.2K Jun 25 16:30 setup.cfg

[user@<host> rda]$ ./rda.sh

-------------------------------------------------------------------------------

RDA Data Collection Started 25-Jun-2013 16:30:35

-------------------------------------------------------------------------------

Processing Initialization module ...

Processing OCM module ...

Processing PERF module ...

Processing CFG module ...

Processing OS module ...

Processing PROF module ...

Processing NET module ...

Processing Oracle WebLogic Server module ...

Processing WREQ module ...

Processing RDSP module ...

Processing LOAD module ...

Processing End module ...

-------------------------------------------------------------------------------

RDA Data Collection Ended 25-Jun-2013 16:31:25

-------------------------------------------------------------------------------

You can review the reports by transferring the contents of the

/opt/app/aia/Middleware/oracle_common/rda/rda/output directory to a location

where you have web-browser access. Then, point your browser at this file to

display the reports:

Weblogic__start.htm

Based on your server configuration, some possible alternative approaches are:

- If your client computer with a browser has access to a web shared

directory, copy the /opt/app/aia/Middleware/oracle_common/rda/rda/output

directory to the web shared directory and visit this URL:

http://machine:port/web_shared_directory/Weblogic__start.htm

- If your client computer with a browser has FTP access to the server

computer with the /opt/app/aia/Middleware/oracle_common/rda/rda/output

directory, visit this URL:

ftp://user@<host>//opt/app/aia/Middleware/oracle_common/rda/rda/output/Weblogic__start.htm

If this file was generated to assist in resolving a Service Request, please

send

/opt/app/aia/Middleware/oracle_common/rda/rda/output/RDA.Weblogic_<host>.zip

to Oracle Support by uploading the file via My Oracle Support. If ftp'ing the

file, please be sure to ftp in BINARY format.

[user@<host> rda]$

Delete Messages from JMS Queue in weblogic using WLST

2013-02-26T21:37:00.000-08:00

Set classpaths required for WLST from MW_HOME/wlserver_10.3/server/bin/

. ./setWLSEnv.sh

start WLST by typing

java weblogic.WLST

connect('weblogic', 'welcome1', 't3://localhost:7001')

serverRuntime()

cd('/JMSRuntime/<TargetServerName>.jms/JMSServers/<JMSServerName>/Destinations/<JMSModuleName>!<QueueName>')

{ex.- wls:/fmw_domain/serverRuntime>cd('/JMSRuntime/AdminServer.jms/JMSServers/JMSServer1/Destinations/SystemModule1!Queue1')

}

cmo.deleteMessages('')

{This command delete all messaged in queue and will return the number of messages deleted.}

If you want to delete a particular message from the queue, use below command:

cmo.deleteMessages("JMSMessageID IN('ID:<126965.1361894150054.0>')")

Results will be:
1
It will delete a message having id ID:<126965.1361894150054.0>

here is the message ID which we can get from "summary of JMS Message" from Admin Console.

How to deploy DVM using JAVA Code:

2012-01-16T19:42:00.000-08:00

Generally we migrate DVM’s from one env. to other env. using ESB console. But when there is a lot of DVM’s it becomes difficult and time taking process to migrate using ESB console.

We can use Java code to migrate all the DVM’s to a server at a time.

Set JAVA HOME and CLASSPATH

export CLASSPATH=$ORACLE_HOME/integration/esb/lib/commons-logging.jar:

$ORACLE_HOME/integration/esb/lib/commons-codec-1.3.jar:

$ AIAHOME/Infrastructure/install/lib/commons-httpclient-3.1.jar

export JAVA_HOME=$ORACLE_HOME/jdk

or we can keep these jar files in a folder and set CLASSPATH according to that.

commons-httpclient-3.1.jar- this jar file comes with AIA installation, if only SOA is installed we need to download this jar.

2.)Place all the DVM files to be migrated inside home/Migration/DVM/

3.)Create ImportDVM.properties file inside /home/ Migration which contains the connection details of the server.

hostname=<host name of the server>

port=<port no of the server>

username=oc4jadmin

password=welcome1

dvm=home/Migration/DVM/DVM1.xml, home/Migration/DVM/DVM2.xml, home/Migration/DVM/DVM3.xml, home/Migration/DVM/DVM4.xml

4.)create ImportDVM.java file inside /home/ Migration

import java.io.ByteArrayOutputStream;
import java.io.File;
import java.io.InputStream;
import java.util.Properties;
import java.util.StringTokenizer;
import org.apache.commons.httpclient.HttpClient;
import org.apache.commons.httpclient.methods.GetMethod;
import org.apache.commons.httpclient.methods.PostMethod;
import org.apache.commons.httpclient.methods.multipart.FilePart;
import org.apache.commons.httpclient.methods.multipart.MultipartRequestEntity;
import org.apache.commons.httpclient.methods.multipart.Part;
import org.apache.commons.httpclient.methods.multipart.StringPart;

public class ImportDVM {
public static void main(String[] args) {
Properties props = new Properties();
try {
InputStream in = Class.forName("ImportDVM").getResourceAsStream("ImportDVM.properties"); // Properties file to define your dynamic parameters
props.load(in);
String esbHost = props.getProperty("hostname");
int esbPort = Integer.parseInt(props.getProperty("port"));
String username = props.getProperty("username");
String password = props.getProperty("password");
String fileLocation = props.getProperty("dvm"); //dvm file location
StringTokenizer st = new StringTokenizer(fileLocation, ",");
while (st.hasMoreTokens()) {
String dvm = st.nextToken();
importDVM(esbHost, esbPort, username, password, dvm);
}
} catch (Exception ex) {
ex.printStackTrace();
}
}
public static void importDVM(String esbHost, int esbPort, String username, String password, String fileLocation) {
try {
InputStream is = null;
HttpClient client = new HttpClient();
int responseCode = 0;
client.getHttpConnectionManager().getParams().setConnectionTimeout(90000);

// Authenticate
String authUrl = "http://"+esbHost+":"+esbPort+"/esb/j_security_check?j_username="+username+"&j_password="+password;
GetMethod auth = new GetMethod(authUrl);
responseCode = client.executeMethod(auth);

// ImportDVM
File targetFile = new File(fileLocation);
PostMethod post = new PostMethod("http://"+esbHost+":"+esbPort+"/esb/esbConfiguration/executeCommand?action=ImportDVM");
post.setRequestHeader("User-Agent", "ESB Client/1.0");
//StringPart s1 = new StringPart("importType","map");
//StringPart s2 = new StringPart("importMode","overwrite");
//FilePart f1 = new FilePart(targetFile.getName(), targetFile);
Part[] parts = {new StringPart("importType","map"), new StringPart("importMode","overwrite"), new FilePart(targetFile.getName(), targetFile)};
System.out.println(Part.getLengthOfParts(parts));
post.setRequestEntity(new MultipartRequestEntity(parts, post.getParams()));
responseCode = client.executeMethod(post);
System.out.println("Response code: " + responseCode);
is = post.getResponseBodyAsStream();
ByteArrayOutputStream baos = new ByteArrayOutputStream();
int c;
while ((c = is.read()) != -1) {
baos.write((char)c);
}
byte[] responseBody = baos.toByteArray();
post.releaseConnection();
String response = new String(responseBody);
System.out.println(response);
} catch (Exception e) {
e.printStackTrace();
}
}
}

compile the java file as:

javac ImportDVM.java

run ImportDVM.java

java ImportDVM