Ravi Reddy

Tuesday, October 04, 2011

BPEL Example of Inserting to Array

I have the following XSD Element ,

Basically this structure stores the name and address (multiple values) , state , country and pincode etc ,
My requirement is to add the data to this element from a BPEL process ,

Create a simple BPEL process , and for the output select the above XSD element , in the BPEL

 

      
     
        
        
      
      
        
        
      
      
        
        
      
      
        
        
      
      
       
        
        
      
       
       
                
                    Near Dairy Circle
                    
                
                
                 
                    Next to Christ University
                    
                
                
                  
                    Bannerghata Road

How to start the VM in Single user mode in Oracle VM 2.2/3.0/XEN

Add the following line to the end of the file vm.cfg file ,

extra = 'single'

to the xen domU config file

After this start the VM using the command ,

xm create vm.cfg

This will start the VM in single user mode.

How to Run the Oracle VM 2.2 Images on Oracle VM 3.0 With out the Oracle VM Manager

I am having problems with the Oracle VM manager 3.0 as it needs 6GB machine to run in my home. Here is the procedure I followed to run the Oracle VM 2.2 images on Oracle VM 3.0.

1. You need to set the Bridged Networking on Oracle VM 3.0

open the file

vi /etc/xen/xend-config.sxp

Uncomment the following line , (Line no 163)

(network-script network-bridge)

And also ensure that you have the following line uncommented (line 178)

(vif-script vif-bridge)

After this restart the Oracle VM Server

Run the command ,

brctl show (This displays the following , )

bridge name bridge id STP enabled interfaces
bond0 8000.0021918b3e8a no pbond0

In the linux guest vm I have the following line ,

vfb = ['type=vnc,vncunused=1,vnclisten=0.0.0.0']
vif = ['type=netfront']

In the Windows Guest OS I have the following line ,

vif = ['bridge=bond0,mac=00:16:3E:26:BE:CE,type=ioemu']

Start the VM’s manually using the command

xm create vm.cfg

Sunday, July 31, 2011

Wants to Send SMS Reminder at a future data and only one

I want to fire a job at 9:59 AM on July-14-2011 , 7/14/2011 (MM/DD/YYYY)

echo /home/ias/Oracle/Middleware/jdk160_18/bin/java -cp /home/ias/JavaUtils Sms160By2 9198808XXXXX "\"Test 5"\" | at 9:59 AM 7/14/2011

Install VmWare ESXI Server from USB

1) Format the US Drive with fat32.
2) Get Syslinux, not the version 4, but an older version. Use 3.86 from http://www.kernel.org/pub/linux/utils/boot/syslinux/3.xx/
Version 4 can give you an error on boot, "invalid c32 image".
3) Run syslinux: syslinux.exe -m -f -a G: (G: being the drive letter).
4) Get the ESXi iso, VMware-VMvisor-Installer-4.1.0.update1-348481.x86_64.iso
5) Extract the iso, using the 7-Zip and copy contents to usb drive
6) Rename isolinux.cfg to syslinux.cfg
7) Modify the syslinux.cfg, add "ks=usb" after vmkboot.gz

For example ,

append vmkboot.gz ks=usb --- vmkernel.gz --- sys.vgz --- cim.vgz --- ienviron.vgz --- install.vgz

8) Create the ks.cfg file in the USB root directory with the following contents

vmaccepteula
rootpw Welcome1
autopart --firstdisk --overwritevmfs
install usb
network --bootproto=dhcp --device=vmnic0

9) Boot it from the USB and install the ESXi software

Sunday, July 24, 2011

Installing VMware ESXi on a USB Memory Stick

1.The first thing you’ll need is a spare USB memory stick. I used 1 8GB USB drive for this. But 4GB or 2GB is also sufficient for this.
2. The next step is to download ESXi from VMware here and burn if off onto CD.

3. Now insert the USB memory stick into a USB port which is able to be booted.
Though at this stage make sure that your server can boot from the CD/DVD drive.

4. Insert the CD containing the ESXi install into the servers CD/DVD drive and boot or restart the server.
Choose the default options.

5. At this stage you will see a list of all your storage devices connected to your VMware ESXi host – select your USB memory stick and press 'Enter'

6. Wait while the ESXi is written down to your USB flash drive – at this point you should see it flashing away

7. Once the installation has completed you will receive the screen below. At this point remove the ESXi installation CD from the servers CD/DVD drive and press ‘Enter’ to reboot the server.
IMPORTANT: Upon the server rebooting ensure that its boot priority order is set so that the USB port(s) are booted from first.

Your server should now be booting successfully off of the USB memory stick to VMware ESXi 4 – all you need to do now is configure it!

After this you have to create a VMFS file system that can be used as a data store ,

For this you need to create a VMFS file system. First run the command ,

fdisk -l

Disk /dev/disks/t10.ATA_____WDC_WD10EARS2D00Y5B1__________________________WD2DWCAV5H240740: 1000.2 GB, 1000204886016 bytes
255 heads, 63 sectors/track, 121601 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

                                                                                  Device Boot      Start         End      Blocks Id System
/dev/disks/t10.ATA_____WDC_WD10EARS2D00Y5B1__________________________WD2DWCAV5H240740p1   *         1        13    102400    7 HPFS/NTFS
Partition 1 does not end on cylinder boundary
/dev/disks/t10.ATA_____WDC_WD10EARS2D00Y5B1__________________________WD2DWCAV5H240740p2            13     19123 153497600    7 HPFS/NTFS
/dev/disks/t10.ATA_____WDC_WD10EARS2D00Y5B1__________________________WD2DWCAV5H240740p3         19123     31871 102400000    7 HPFS/NTFS
...
/dev/disks/t10.ATA_____WDC_WD10EARS2D00Y5B1__________________________WD2DWCAV5H240740p8         39573     51731 97659146   83 Linux

And run the command
fdisk /dev/disks/t10.ATA_____WDC_WD10EARS2D00Y5B1__________________________WD2DWCAV5H240740

and create a partion , and specify the format type as "fb". This is for the VMFS file system.

In the fdisk , type "t". It will ask you for partition number. This is where that first fdisk is useful. You need to know what the new partition number is.
It will be one more than the last number on fdisk. Type this number in

You will now be prompted for the hex code for the partition type. You can also type "L" for a list of codes. The code you want is "fb". So type "fb" in the space. This will return that the partition has been changed to fb (unknown).

Now run the command to create the VMFS file system ,

vmkfstools -C vmfs3 -S storage1 /vmfs/devices/disks/vml.0100000000202020202057442d574341563548323430373430574443205744:9
Checking if remote hosts are using this device as a valid file system. This may take a few seconds...
Creating vmfs3 file system on "t10.ATA_____WDC_WD10EARS2D00Y5B1__________________________WD2DWCAV5H240740:9" with blockSize 1048576 and volume label "storage1".
Successfully created new volume: 4e2c8868-54253438-de36-001aa0c2472f

If you do not specify the VMFS file system , while creating the vmfs file system you may get the error as ,

vmkfstools -C vmfs3 -S storage1 /vmfs/devices/disks/vml.0100000000202020202057442d574341563548323430373430574443205744:9
Checking if remote hosts are using this device as a valid file system. This may take a few seconds...
Creating vmfs3 file system on "t10.ATA_____WDC_WD10EARS2D00Y5B1__________________________WD2DWCAV5H240740:9" with blockSize 1048576 and volume label "storage1".vmkfstools -C vmfs3 -S storage1 /vmfs/devices/disks/vml.0100000000202020202057442d574341563548323430373430574443205744:9
/vmfs/devices/disks/vml.0100000000202020202057442d574341563548323430373430574443205744:9: Permission denied. (Have you set the partition type to 0xfb?)
Error: Permission denied

Now in the VMWare VSphere Client you can see the datastore.

Thursday, July 21, 2011

Sending SMS to Multiple People

Sending SMS to Multiple People

I used the following code available at

https://sourceforge.net/projects/servalivecheck/

I have a file say sms.txt with the following entries I want to send an SMS to all the people in this file.

Sms.lst has the following entries

Ravi,9198808XXXXX

Naveen,919663XXXXX

In Unix create an shell script with the following entries

cat dd.sh

#!/bin/bash

for x in `awk -F',' '{ print $2 }' sms.lst`

/home/ias/Oracle/Middleware/jdk160_18/bin/java -cp /home/ias/JavaUtils Sms160By2 $x "\" We are playing Cricket on this Saturday "\"

Done

On Windows run the following batch file ,

for /F "tokens=2* delims=," %i in (sms.lst) do java -cp . Sms160By2 %i "We are playing Cricket on this Saturday"

This sends the SMS to all the people in the group.

Tuesday, July 12, 2011

Yum Configuration With OEL

Refer to the URL , http://public-yum.oracle.com/ for more details on this.

1.Download and Install Oracle Linux

2. Download and copy the appropriate yum configuration file in place, by running the following commands as root:

Oracle Linux 5

# cd /etc/yum.repos.d
# wget http://public-yum.oracle.com/public-yum-el5.repo

Enable the appropriate repository by editing the yum configuration file

    Open the yum configuration file in a text editor
    Locate the section in the file for the repository you plan to update from, e.g. [el4_u6_base]
    Change enabled=0 to enabled=1

Begin using yum, for example:

yum list

yum install firefox

After this install the oracle-validated package this will install the necessary packages and sets the kernel parameters
and also creates oracle user etc.

yum install oracle-validated

Sunday, July 10, 2011

Parsing Railway’s PNR Data (JSON Parsing)

Here I am using a Service from the following URL ,

http://pnrapi.appspot.com/<pnr-number>

for example ,

http://pnrapi.appspot.com/1416780219

This gives the data in the following format ,

{'status': 'OK', 'data': {'passenger': [{'status': 'G3 , 45', 'seat_number': 'W/L 15,CK'}],
'from': 'SC', 'alight': 'YPR', 'pnr_number': '1416780219', 'train_number': '*12735',
'to': 'YPR', 'board': 'SC', 'train_name': 'YPR GARIB RATH',
'travel_date': {'date': '26-6-2011', 'timestamp': 1309046400}, 'class': '3A'}}

you need to have the following jar files in the classpath ,

D:\fmw1114\Middleware\jdk160_21\bin\javaw.exe -client -classpath C:\JDeveloper\mywork\Application5\Project1\classes;D:\commons-httpclient-3.1\commons-io-2.0.1.jar;D:\commons-httpclient-3.1\json-lib-2.4-jdk15.jar;D:\commons-httpclient-3.1\commons-httpclient-3.1.jar;D:\commons-httpclient-3.1\commons-lang-2.6.jar;D:\commons-httpclient-3.1\commons-logging-1.1.1.jar;D:\commons-httpclient-3.1\commons-logging-adapters-1.1.1.jar;D:\commons-httpclient-3.1\commons-logging-api-1.1.1.jar;D:\commons-httpclient-3.1\commons-logging-tests.jar;D:\commons-httpclient-3.1\ezmorph-1.0.6.jar;D:\commons-httpclient-3.1\commons-collections-3.2.1.jar;D:\commons-httpclient-3.1\commons-beanutils-1.8.3.jar;D:\commons-httpclient-3.1\commons-beanutils-bean-collections-1.8.3.jar;D:\commons-httpclient-3.1\commons-beanutils-core-1.8.3.jar project1.ParsePNR


package project1;

import java.io.BufferedReader;
import java.io.InputStream;

import java.io.InputStreamReader;

import java.net.URL;

import net.sf.json.JSONArray;
import net.sf.json.JSONObject;
import net.sf.json.JSONSerializer;
import org.apache.commons.io.IOUtils;


public class ParsePNR {
    public ParsePNR() {
        super();
    }

    public static void main(String[] args) throws Exception {
         //   InputStream is =
          //          ParsingJSON.class.getResourceAsStream( "c:\\sample-json.txt");
            // String jsonTxt = IOUtils.toString( is );
/*
    String test = "\"status\" : \"OK\",\n" + 
    "\"data\" : { \n" + 
    "          \"train_name\" : \"ERNAKULAM EXP\",\n" + 
    "          \"train_number\" : \"*12677\",\n" + 
    "          \"from\" : \"SBC\",\n" + 
    "          \"to\" : \"CBE\",\n" + 
    "          \"alight\" : \"CBE\",\n" + 
    "          \"board\" : \"SBC\",\n" + 
    "          \"class\" : \"2S\",\n" + 
    "          \"travel_date\" : \"2- 6-2011\"\n" + 
    "          \"passenger\" : [ { \"seat_number\" : \"D8  , 31,GN\", \"status\" : \"CNF\" },\n" + 
    "                          { \"seat_number\" : \"D8  , 32,GN\", \"status\" : \"CNF\" } ]\n" + 
    "         }";

// Sample Data (1 passenger)
{'status': 'OK', 'data': {'passenger': [{'status': 'G3  , 45', 'seat_number': 'W/L   15,CK'}], 'from': 'SC', 'alight': 'YPR', 'pnr_number': '1416780219', 'train_number': '*12735', 'to': 'YPR', 'board': 'SC', 'train_name': 'YPR GARIB RATH', 'travel_date': {'date': '26-6-2011', 'timestamp': 1309046400}, 'class': '3A'}}


// Sample Data (2 passenger)
{'status': 'OK', 'data': {'passenger': [{'status': 'G3  , 45', 'seat_number': 'W/L   15,CK'},{'status': 'G3  , 46', 'seat_number': 'W/L   16,CK'}], 'from': 'SC', 'alight': 'YPR', 'pnr_number': '1416780219', 'train_number': '*12735', 'to': 'YPR', 'board': 'SC', 'train_name': 'YPR GARIB RATH', 'travel_date': {'date': '26-6-2011', 'timestamp': 1309046400}, 'class': '3A'}}

Replace the class with class1 as class is a reserved word in java.

  */
        String pnr="";
        if (args.length == 0 )
            pnr = "1416780219";
        else
            pnr = args[0];
                System.setProperty("http.proxyHost", "www-proxy.us.oracle.com");
        System.setProperty("http.proxyPort", "80");
        System.setProperty("http.nonProxyHosts","*.us.oracle.com|*.oraclecorp.com|*.idc.oracle.com|*.uk.oracle.com|localhost");

            URL url = new URL("http://pnrapi.appspot.com/"+pnr);
            // Read all the text returned by the server
            BufferedReader in = new BufferedReader(new InputStreamReader(url.openStream()));
            String str="";
            String line;
            while ((line = in.readLine()) != null) {
               // str is one line of text; readLine() strips the newline character(s)
              str= str.concat(line );
             //  System.out.println(line);
             System.out.println(str);
            }
            in.close();
      str=   str.replace("'class':","'class1':");
             /*String jsonTxt ="{'status': 'OK', 'data': {'passenger': [{'status': 'G3  , 45', 'seat_number': 'W/L   15,CK'},{'status': 'G3  , 46', 'seat_number': 'W/L   16,CK'}], " +
                "'from': 'SC', 'alight': 'YPR', 'pnr_number': '1416780219', " +
                "'train_number': '*12735', 'to': 'YPR', 'board': 'SC', " +
                "'train_name': 'YPR GARIB RATH', 'travel_date': {'date': '26-6-2011', 'timestamp': 1309046400}, " +
                "'class1': '3A'}}"; */
           String  jsonTxt = str;
            JSONObject json = (JSONObject) JSONSerializer.toJSON( jsonTxt );
            String status = json.getString( "status" );
            if (status.compareToIgnoreCase("INVALID") == 0) {
                
                System.out.println("Status is "+status);
                System.exit(0);
                
            }
            JSONObject data = json.getJSONObject("data");
            String train_name = data.getString("train_name");
            String train_number = data.getString("train_number");
            String class_d = data.getString("class1");
            String from = data.getString("from");
            String alight = data.getString("alight");
          
            
            JSONObject travel_date = data.getJSONObject("travel_date");
           String date = travel_date.getString("date");
          
            
            
            
            System.out.printf( "status: %s\n", status );
           
            System.out.printf( "Train number : %s  Tain Name : %s \n", train_number, train_name );
            System.out.printf( "From : %s To : %s Date Of Travel : %s Class : %s\n", from, alight , date , class_d   );
            
            JSONArray passenger = data.getJSONArray("passenger");
           int i1=0;
                for (Object o : passenger) {
                    i1++;
                    JSONObject passengerDetails = (JSONObject) o;
                    String status_p = passengerDetails.getString("status");
                    String seat_number = passengerDetails.getString("seat_number");
                   
                    System.out.printf( "Passenger : %d Current Status : %s  Previous Staus : %s\n", i1,  status_p, seat_number );
                  
                }

            
           
        }
}

Wednesday, July 06, 2011

How to start the vncserver automatically

Open the file

vi .vnc/xstartup

and add the line

exec gnome-session &

and remove the line that starts with "twm"

chkconfig --level 3 vncserver on
chkconfig --level 5 vncserver on

Add the following line in /etc/sysconfig/vncservers

VNCSERVERS="1:root"

service vncserver start

Tuesday, July 05, 2011

XE On Linux

Oracle is installed to: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle

To start XE

/etc/init.d/oracle-xe start

To stop XE

/etc/init.d/oracle-xe stop

export PATH=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin:$PATH
export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
export ORACLE_SID=XE

sqlplus "/ as sysdba"

If you want to use Oracle XE as your database, you have to set the RCU_JDBC_TRIM_BLOCKS environment variable to TRUE *prior* to running RCU. As a reminder as to support level, when running RCU against XE you will receive a warning stating that the database version is not supported by Oracle.

Wednesday, June 22, 2011

Adding Source Code to a Blog

http://codeshode.blogspot.com/2010/06/format-my-source-code-for-blogging.html

Copy the following Code

Copy the following code and paste it into your Blogger Template just above the </head> tag

<link href='http://alexgorbatchev.com/pub/sh/current/styles/shCore.css' rel='stylesheet' type='text/css'/>

<link href='http://alexgorbatchev.com/pub/sh/current/styles/shThemeDefault.css' rel='stylesheet' type='text/css'/>

<script src='http://alexgorbatchev.com/pub/sh/current/scripts/shCore.js' type='text/javascript'></script>

<script src='http://alexgorbatchev.com/pub/sh/current/scripts/shBrushCpp.js' type='text/javascript'></script>

<script src='http://alexgorbatchev.com/pub/sh/current/scripts/shBrushCSharp.js' type='text/javascript'></script>

<script src='http://alexgorbatchev.com/pub/sh/current/scripts/shBrushCss.js' type='text/javascript'></script>

<script src='http://alexgorbatchev.com/pub/sh/current/scripts/shBrushJava.js' type='text/javascript'></script>

<script src='http://alexgorbatchev.com/pub/sh/current/scripts/shBrushJScript.js' type='text/javascript'></script>

<script src='http://alexgorbatchev.com/pub/sh/current/scripts/shBrushPhp.js' type='text/javascript'></script>

<script src='http://alexgorbatchev.com/pub/sh/current/scripts/shBrushPython.js' type='text/javascript'></script>

<script src='http://alexgorbatchev.com/pub/sh/current/scripts/shBrushRuby.js' type='text/javascript'></script>

<script src='http://alexgorbatchev.com/pub/sh/current/scripts/shBrushSql.js' type='text/javascript'></script>

<script src='http://alexgorbatchev.com/pub/sh/current/scripts/shBrushVb.js' type='text/javascript'></script>

<script src='http://alexgorbatchev.com/pub/sh/current/scripts/shBrushXml.js' type='text/javascript'></script>

<script src='http://alexgorbatchev.com/pub/sh/current/scripts/shBrushPerl.js' type='text/javascript'></script>

<script language='javascript'>

SyntaxHighlighter.config.bloggerMode = true;

SyntaxHighlighter.config.clipboardSwf = 'http://alexgorbatchev.com/pub/sh/current/scripts/clipboard.swf';

SyntaxHighlighter.all();

</script>

Save the template
Then you can start creating code blocks in your existing or new Blog entries.
There are 2 ways to add a code block using syntaxhighlighter

Add the following cdoe ,

<pre class="brush: java">
// Comment
public class Testing
{
public Testing() {
}
public void Method()
{
/* Another Comment
on multiple lines */
int x = 9;
}
}
</pre>

How to use AQ with WebLogic Server

Create the jmsuser user for accessing the AQ

sqlplus SYS/manager1@ORCL AS SYSDBA

grant connect,resource,aq_administrator_role to jmsuser identified by jmsuser;
grant select on sys.DBA_PENDING_TRANSACTIONS to jmsuser;
grant execute on sys.dbms_aqadm to jmsuser;
grant execute on sys.dbms_aq to jmsuser;
grant execute on sys.dbms_aqin to jmsuser;
grant execute on sys.dbms_aqjms to jmsuser;
exec dbms_aqadm.grant_system_privilege('ENQUEUE_ANY','jmsuser');
exec dbms_aqadm.grant_system_privilege('DEQUEUE_ANY','jmsuser');

package webserv1;

import java.util.Hashtable;

import javax.jms.Message;
import javax.jms.Queue;
import javax.jms.QueueConnection;
import javax.jms.QueueConnectionFactory;
import javax.jms.QueueReceiver;
import javax.jms.QueueSender;
import javax.jms.QueueSession;
import javax.jms.Session;
import javax.jms.TextMessage;

import javax.naming.Context;
import javax.naming.InitialContext;

public class SendMsgQueue {
    public SendMsgQueue() {
    }

    public static void main(String argv[]) throws Exception {
    
         Hashtable env = new Hashtable(); 
         //  Standalone OC4J connection details 
         env.put(Context.INITIAL_CONTEXT_FACTORY, "weblogic.jndi.WLInitialContextFactory"); 
         env.put(Context.SECURITY_PRINCIPAL, "weblogic"); 
         env.put(Context.SECURITY_CREDENTIALS, "welcome1"); 
         env.put(Context.PROVIDER_URL, "t3://localhost:7001");
         // env.put(Context.PROVIDER_URL, "t3://ceiacb5.us.oracle.com:7001");
         InitialContext context = new InitialContext(env);
         
         
          // The producer and consumer need to get a connection factory and use it to set up
          // a connection and a session
          
          QueueConnectionFactory connFactory =           (QueueConnectionFactory) context.lookup("AQJMS_XAConnectionFactory");
          QueueConnection conn = connFactory.createQueueConnection();
          // This session is not transacted, and it uses automatic message acknowledgement
          QueueSession session = conn.createQueueSession(false, Session.AUTO_ACKNOWLEDGE);
          Queue q = (Queue) context.lookup("jms/JMSDEMO_QUEUE1");
          // Sender
          QueueSender sender = session.createSender(q);
          // Text message
          TextMessage msg = session.createTextMessage();
          msg.setText("Hello Test123");
          System.out.println("Sending the message: "+msg.getText());
          sender.send(msg);
         
          session.close();
          conn.close();
       }
}

Program for Receving the Message

package webserv1;

import java.util.Hashtable;

import javax.jms.Message;
import javax.jms.Queue;
import javax.jms.QueueConnection;
import javax.jms.QueueConnectionFactory;
import javax.jms.QueueReceiver;
import javax.jms.QueueSender;
import javax.jms.QueueSession;
import javax.jms.Session;
import javax.jms.TextMessage;

import javax.naming.Context;
import javax.naming.InitialContext;

public class RecvMsgQueue {
    public RecvMsgQueue() {
        super();
    }

  public static void main(String argv[]) throws Exception {
  
       Hashtable env = new Hashtable(); 
       //  Standalone OC4J connection details 
       env.put(Context.INITIAL_CONTEXT_FACTORY, "weblogic.jndi.WLInitialContextFactory"); 
       env.put(Context.SECURITY_PRINCIPAL, "weblogic"); 
       env.put(Context.SECURITY_CREDENTIALS, "welcome1"); 
      env.put(Context.PROVIDER_URL, "t3://localhost:7001"); 
   // env.put(Context.PROVIDER_URL, "t3://ceiacb5.us.oracle.com:7001"); 
       InitialContext context = new InitialContext(env);
         
        // The producer and consumer need to get a connection factory and use it to set up
        // a connection and a session
        
      //  QueueConnectionFactory connFactory = (QueueConnectionFactory) context.lookup("jms/oc4jQueueConnFactory");
      QueueConnectionFactory connFactory =(QueueConnectionFactory) context.lookup("AQJMS_XAConnectionFactory");
    
      
        QueueConnection conn = connFactory.createQueueConnection();
        // This session is not transacted, and it uses automatic message acknowledgement
        QueueSession session = conn.createQueueSession(false, Session.AUTO_ACKNOWLEDGE);
       
       Queue q = (Queue) context.lookup("jms/JMSDEMO_QUEUE1");
     //   Queue q = (Queue) context.lookup("jms/oc4jQueue");
      /*  // Sender
        QueueSender sender = session.createSender(q);
        // Text message
        TextMessage msg = session.createTextMessage();
        msg.setText("Hello there!");
        System.out.println("Sending the message: "+msg.getText());
        sender.send(msg);
        
       */ 
        // Receiver
        QueueReceiver receiver = session.createReceiver(q);
        conn.start();
        Message m = receiver.receive();
        if(m instanceof TextMessage) {
           TextMessage txt = (TextMessage) m;
           System.out.println("Message Received: "+txt.getText());
        }
        session.close();
        conn.close();
     }
}

Monday, June 20, 2011

How to Install multiple Linux Distributions in the same Machine

My requirement is to have the following OS's in my computer.

Windows 7
Redhat Linux 4
Oracle Enterprise Linux 5

First install Windows 7.

Using Windows 7 Disk Manager, create 3 partitions
say
hda5 => 50 GB (For RedHat Linux)
hda6 => 6 GB (For the Swap , we can use the same Swap for other linux install also)
hda7 => 50GB ((For Oracle Linux)

Now this install Redhat Linux 5 , select the root(/) partition as hda5
and swap as hda6. In the install screen please select the option to install the grub.

Now install Oracle Linux 5 , here select the root(/) partition as hda7
and swap as hda6.

In the install do not choose to install the grub option as you already have grub installed
by the first install.

Now Boot the machine in to Redhat Linux and mount the hda7 partition.

mount /dev/hda7 /test

Find out the files under the directory /test/boot directory ,

ls vm* init*

initrd-2.6.18-194.el5.img vmlinuz-2.6.18-194.el5
initrd-2.6.18-194.el5PAE.img vmlinuz-2.6.18-194.el5PAE

Now edit the /etc/grub.cong file and add the following entries

title Enterprise Linux (2.6.18-194.el5PAE)
        root (hd0,7)
        kernel /boot/vmlinuz-2.6.18-194.el5PAE ro root=LABEL=/ rhgb quiet
        initrd /boot/initrd-2.6.18-194.el5PAE.img
title Enterprise Linux-base (2.6.18-194.el5)
        root (hd0,7)
        kernel /boot/vmlinuz-2.6.18-194.el5 ro root=LABEL=/ rhgb quiet
        initrd /boot/initrd-2.6.18-194.el5.img

After this restart the machine and now you will see OEL , Windows 7 and Redhat in the grub boot screen.

Saturday, June 18, 2011

Changing the SOA Suite database Username etc in 10g

SOA 10g by default installs to orabpel and oraesb user. In a testing environment you may want to create more then one SOA 10g instance in one db. This procedure explains how to do that

1. First run the irca to create the necessary schemas.

./irca.sh all "xxxx.xxx.oracle.com 1521 xxx.xxx.oracle.com" welcome1 -overwrite ORABPEL welcome1 ORAESB welcome1 ORAWSM welcome1

Then run irca gaian with a different username's for example ORABPEL_OracleAS_3 , ORAESB_OracleAS_3 and ORAWSM_OracleAS_3.

./irca.sh all "xxx.xxx.oracle.com 1521 xxx.xxx.oracle.com" welcome1 -overwrite ORABPEL_OracleAS_3 welcome1 ORAESB_OracleAS_3 welcome1 ORAWSM_OracleAS_3 welcome1

2. Install the SOA Suite normally. SOA Suite 10g by default install in the orabpel and oraesb schema's only.

3. Now open the ${SOA_HOME}\j2ee\home\config\data-sources.xml file ,

and change the username and password etc for the data-sources. You can also use the EM Application Server control
for this purpose.

4. From the ${SOA_HOME}\bpel\install\extensions directory, copy the following files to ${SOA_HOME}\bpel\domains\default\deploy:

bpel_TaskActionHandler_1.0.jar
bpel_TaskManager_1.0.jar

5. Connect to the oraesb schema and run the following sql script ,

SQL> spool params.sql
SQL> SELECT 'INSERT INTO esb_parameter VALUES (''' || param_name || ''', ''' || param_value || ''');' FROM esb_parameter;
SQL> spool off
SQL> quit

Take the params.sql file and run it against the schema ORAESB_OracleAS_3.

6. Now apply the latest SOA 10g patch set ,
and run the schema upgrade scripts on the new schemans i.e ORABPEL_OracleAS_3 , ORAESB_OracleAS_3

If your SOA Suite is 10.1.3.3 or later, you will have to also run an additional script that updates the BPEL schema. This is documented in the install guides for each version, but in summary, the script is:

${SOA_HOME}\bpel\system\database\scripts\upgrade_10131_10135_oracle.sql

7. For OWSM open the file ,
${SOA_HOME}\owsm\bin\install_properties

Scroll down to the section that contains the install.db.* properties. After backing up the existing settings, modify them for your environment:

    install.db.type=oracle
    install.db.driver.type=thin
    install.db.host=localhost
    install.db.port=1521
    install.db.name=xe
    install.db.userid=oraowsm_OracleAS_1
    install.db.password=oraowsm

8. Run the command ,

${SOA_HOME}\owsm\bin\wsmadmin.bat install

9. Restart all the oc4j containers and check whether every thing is working fine or not.

Saturday, June 11, 2011

How to Add Shared Folders in VmWare Player

First Install the VMWare tools on the Guest OS.

With out the vmware tools the sharing feature may not work.

Launch VMWare Player. Confirm that the virtual machine that you want to modify the settings for it powered off, then right click it and click "Edit VM."

Click the "Options" tab on the top of the window, then click the "Shared Folders" category below.

Click the radio button labeled "Enabled." And add the directories you want to share.

Thursday, June 09, 2011

Search Oracle Forums

http://myforums.oracle.com/jive3/forum.jspa?forumID=3150 (integration_ww@oracle.com)
http://myforums.oracle.com/jive3/forum.jspa?forumID=3209 (helpwls_ww@oracle.com)
http://myforums.oracle.com/jive3/forum.jspa?forumID=3213 OC4J (helpj2ee_us@oracle.com)
http://myforums.oracle.com/jive3/forum.jspa?forumID=3208 Oracle Application Server (helpias_us@oracle.com)

SOA PS3 Purging Scripts With the Debug Option

spool soainfra_purge_n2_output3.txt
set serveroutput on
set pages 1000
ALTER PROCEDURE debug_purge COMPILE PLSQL_CCFLAGS = 'debug_on:TRUE' REUSE SETTINGS;
ALTER PROCEDURE log_info COMPILE PLSQL_CCFLAGS = 'debug_on:TRUE' REUSE SETTINGS;

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-02-01 10:00:00','YYYY-MM-DD HH24:MI:SS');
MAX_CREATION_DATE := to_timestamp('2011-07-08 09:00:00','YYYY-MM-DD HH24:MI:SS');
max_runtime := 60;
   retention_period := to_timestamp('2011-07-08','YYYY-MM-DD');
    --batch_size := 10000;
    batch_size := 100000;
      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;
   /

ALTER PROCEDURE debug_purge COMPILE PLSQL_CCFLAGS = 'debug_on:false' REUSE SETTINGS;
ALTER PROCEDURE log_info COMPILE PLSQL_CCFLAGS = 'debug_on:false' REUSE SETTINGS;
spool off

How to add swap space in linux

http://www.thegeekstuff.com/2010/08/how-to-add-swap-space/

dd if=/dev/zero of=/extraswap bs=1M count=512
mkswap /extraswap
cp /etc/fstab /etc/fstab.mybackup
Add this line at the end of the file
/extraswap none swap sw 0 0
or
swapon /extraswap

Verify whether the newly created swap area is available for your use.
swapon -s

Tuesday, June 07, 2011

Create RAC Instance using Oracle VM

First Install the Oracle VM Server on a new machine.

On Some other linux machine (or an vmware instance) install the Oracle VM manager.

Extract the Oracle VM manager zip file and mount the iso file on a unix machine.
Install the Oracle VM manager by running the command ,
sh runInstaller.sh

The Oracle VM manager asks a series of questions like db connect info etc
after this it will install Oracle XE and OC4J etc. If you have an existing DB you can use that
database instead of XE.

On the Oracle VM Server , create a HDD partion say about 100GB in /dev/sdb6
(ensure that you have atleast you have 80GB partition else the RAC install will fail)

and run the following commands to create the storage repository ,

mkfs.ext3 /dev/sdb6
/opt/ovs-agent-2.3/utils/repos.py -n /dev/sdb6
/opt/ovs-agent-2.3/utils/repos.py -i
/opt/ovs-agent-2.3/utils/repos.py -l
/opt/ovs-agent-2.3/utils/repos.py -r 90ab429e-a00f-488d-9680-91dd878e3f48

Output of the above commands ,

[root@oraclevm ~]# /opt/ovs-agent-2.3/utils/repos.py -n /dev/sdb6
[ NEW ] 90ab429e-a00f-488d-9680-91dd878e3f48 => /dev/sdb6
[root@oraclevm ~]# /opt/ovs-agent-2.3/utils/repos.py -i
*** Storage repositories initialized.
[root@oraclevm ~]# /opt/ovs-agent-2.3/utils/repos.py -l
[ ] 90ab429e-a00f-488d-9680-91dd878e3f48 => /dev/sdb6
[root@oraclevm ~]# /opt/ovs-agent-2.3/utils/repos.py -r 90ab429e-a00f-488d-9680-91dd878e3f48
[ R ] 90ab429e-a00f-488d-9680-91dd878e3f48 => /dev/sdb6

In the VM manager create a server pool and assign the Oracle VM Server to this pool.

Copy the RAC Vmware template file to /OVS/seed_pool and extract the file ,

After this run the following commands ,

# cd /OVS/seed_pool
# unzip -q /tmp/OVM_EL5U5_X86_11107RAC_PVM.zip
# tar xzf OVM_EL5U5_X86_11107RAC_PVM.tgz (or X86_64 for the 64-bit version)
(You may now delete the ZIP & TGZ files)
This will create the following, e.g.on 32bit:
/OVS/seed_pool/OVM_EL5U5_X86_11107RAC_PVM (or X86_64 for the 64-bit version)
|- System.img (OS image file)
|- Oracle11107RAC_x86-xvdb.img (database software image file)
|- vm.cfg (VM configuration file)
|- README
|- These PDF documents
|- lsinventory-sample.crs-32bit lsinventory-sample.rac-asm-32bit (or 64bit)

Now create 5 shared disks i.e say ASM1 to ASM5 each of 2GB.

Import the template using Oracle VM manager

Create 2 Virtual Machines using the imported template

Add the shared disks in the exact same order to both VMs.

Power ON both virtual machines

Complete the boot interview questions like private IP , public IP , VIP IP and hostnames etc.
For the private IP use 10.10.10.201 ,

If you have only one network card then use eth0:1 for the private interface.

Now Install Oracle RAC
First login as root user , (password is ovsroot) and run the command ,
cd /u01/clone/buildcluster.sh

This will install the RAC software.

For the command line tools , please download the following rpm’s

wget http://public-yum.oracle.com/repo/EnterpriseLinux/EL5/oracle_addons/x86_64/ovmcli-2.2-9.el5.noarch.rpm

wget http://public-yum.oracle.com/repo/EnterpriseLinux/EL5/addons/x86_64/python-ZSI-2.1-a1.el5.noarch.rpm

Run the command to configure the ovm client

ovm config

run the command ,

ovm -u admin -p welcome1 vm ls
Name    Size(MB) Mem VCPUs Status Server_Pool
fmwrac1 29086    1400 1     Running oraclevm1_test
fmwrac2 29086    1400 1     Running oraclevm1_test

Search This Blog