Ravi Reddy

How to increase JVM Memory Size for JDeveloper 11g

2012-01-24T02:30:00.001-08:00

Open the file D:\fmw1115\Middleware\jdeveloper\ide\bin\ide.conf

and change the lines

AddVMOption -Xmx1024M
AddVMOption -Xms128M

Also open the file D:\fmw1115\Middleware\jdeveloper\jdev\bin\jdev.conf

and change the line

AddVMOption -XX:MaxPermSize=256M

20 Linux System Monitoring Tools Every SysAdmin Should Know

2012-01-19T01:41:00.001-08:00

Nice Artcile ,

http://www.cyberciti.biz/tips/top-linux-monitoring-tools.html

BSNL 3g Prepaid Data Card Recharge

2011-12-13T21:10:00.001-08:00

I used the site http://www.paytm.com/ , here Select Data Card Option and Select the Provider as BSNL and Select the Circle as Karnataka, after this enter the amount , you need to exactly put the amount that is required for the data card recharge,

You can find the details from this site ,

http://www.bsnl.in/service/3G/3G_files/3g.htm

If the value is shown as 100, then you need to put 103/-

For Karnataka for Rs.103/- you get the 225MB download ,

you can find exact amount from the URL ,

http://portal.bsnl.in/rc/aspxfiles/3GRechargeSelect.aspx , by giving your mobile number ,

To find the 3g usage

dial *123# from your phone

You can contact BSNL 3g data card call center using the number ,

Contact Number: 9448024365

http://www.bangaloretelecom.com/3gservices/3gservices.html

How to Add a Hard Disk Space to Oracle VM

2011-12-01T21:40:00.001-08:00

1. Create a 30GB file ,

dd if=/dev/zero of=fmw11g.img bs=1024k count=30000

2. Add the file /OVM/linuxvm/fmw11g.img
to the vm.cfg file , for example ,

disk = ['file:/OVM/linuxvm/System.img,xvda,w','file:/OVM/linuxvm/fmw11g.img,xvdb,w',]

3. Now start the VM by using the command ,
xm create vm.cfg

4. In the fdisk -l command , you should be able to see this file ,

For example ,

fdisk -l

Disk /dev/xvda: 12.8 GB, 12884901888 bytes
255 heads, 63 sectors/track, 1566 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

    Device Boot      Start         End      Blocks   Id System
/dev/xvda1   *           1          13      104391   83 Linux
/dev/xvda2              14        1264    10048657+ 83 Linux
/dev/xvda3            1265        1566     2425815   82 Linux swap / Solaris

Disk /dev/xvdb: 31.4 GB, 31457280000 bytes
255 heads, 63 sectors/track, 3824 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

5. using fdisk /dev/xvdb command create a partion and format that partition
using the command ,

mkfs.ext3 /dev/xvdb1

6. After this mount this file system by adding this entry to the /etc/fstab file ,
/dev/xvdb1 /fmw11g ext3 defaults 1 2

run the command , mount -a

Find out whether a Schema is Valid or Not

2011-11-25T02:24:00.001-08:00

Some times in SOA you need to find out whether the schema you have designed/developed is valid and conforms to XML schema standards etc.

For this you can use the JDK 1.6 tool xjc.exe to check ,

%JDK_HOME%\bin\xjc.exe <your-schema-file> and check whether you are getting errors or not.
When I ran the xjc command with the original schmea , I got the errors
parsing a schema...
[ERROR] sch-props-correct.2: A schema cannot contain two global components with the same name; this schema contains two occurrences of 'party,IdentificationType'.
line 45 of file:/D:/bugs-download/Bug12965191/restriction_example/restriction/schema-restriction/xsd/party/party.xsd
[ERROR] rcase-Recurse.2: There is not a complete functional mapping between the particles.
line 7 of file:/D:/bugs-download/Bug12965191/restriction_example/restriction/schema-restriction/xsd/local-party.xsd
[ERROR] derivation-ok-restriction.5.4.2: Error for type 'LocalPartyType7'. The particle of the type is not a valid restriction of the particle of the base.
line 7 of file:/D:/bugs-download/Bug12965191/restriction_example/restriction/schema-restriction/xsd/local-party.xsd
Failed to parse a schema.

The above error indicates that schema is not a valid schema.

How to set the SOA composite name

2011-11-23T01:25:00.001-08:00

By default no composite name is set when a SOA componenet gets executed.

XPath for Mediator components:
Use the the following XPath expression in an Assign value dialog when you define a routing rule.

med:setCompositeInstanceTitle(title string)

and use the following target tracking.compositeInstanceTitle.
Note: this property will not appear in the property selection dialog, but can be used though.

Java for BPEL components
Add an Embedded Java activity inside your process flow and add the following function to it:

setCompositeInstanceTitle(title string);
for example ,

In the java embeding add the following code ,

System.out.println("Hello, World 11 "+ new java.util.Date());
setCompositeInstanceTitle("Hello, World 11 "+ new java.util.Date());

Reference

http://docs.oracle.com/cd/E15523_01/integration.1111/e10226/soacompapp_mang.htm

For 10g use

System.out.println("Hello, World 11 "+ new java.util.Date());
setTitle("Hello, World 11 "+ new java.util.Date());

HTTP Proxy Server Settings for the SOA/Weblogic Server

2011-10-11T21:05:00.001-07:00

Set the following env variables before staring the SOA Server ,

On Unix

export JAVA_OPTIONS="-Dhttp.proxySet=true -Dhttp.proxyHost=www-proxy.us.oracle.com -Dhttp.proxyPort=80 -Dhttp.nonProxyHosts=localhost.localdomain|127.0.0.1|localhost|*.idc.oracle.com"

On Windows

On Unix

set JAVA_OPTIONS="-Dhttp.proxySet=true -Dhttp.proxyHost=www-proxy.us.oracle.com -Dhttp.proxyPort=80 -Dhttp.nonProxyHosts=localhost.localdomain|127.0.0.1|localhost|*.idc.oracle.com"

After this start the WebLogic Server.

BPEL Example of Inserting to Array

2011-10-04T21:04:00.001-07:00

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

2011-10-04T20:47:00.001-07:00

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

2011-10-04T20:45:00.001-07:00

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

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

2011-07-31T20:45:00.001-07:00

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

2011-07-31T20:37:00.001-07:00

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

Installing VMware ESXi on a USB Memory Stick

2011-07-24T21:36:00.001-07:00

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.

Sending SMS to Multiple People

2011-07-21T00:28:00.001-07:00

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.

Yum Configuration With OEL

2011-07-12T00:35:00.001-07:00

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

Parsing Railway’s PNR Data (JSON Parsing)

2011-07-10T20:04:00.001-07:00

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 );
                  
                }

            
           
        }
}

How to start the vncserver automatically

2011-07-06T23:34:00.001-07:00

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

XE On Linux

2011-07-05T05:06:00.001-07:00

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.

Adding Source Code to a Blog

2011-06-22T21:33:00.001-07:00

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

2011-06-22T04:47:00.001-07:00

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();
     }
}

How to Install multiple Linux Distributions in the same Machine

2011-06-20T04:15:00.001-07:00

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.

EEVaram Links

2011-06-19T03:58:00.001-07:00

Changing the SOA Suite database Username etc in 10g

2011-06-18T23:28:00.001-07:00

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 "incq128ad.idc.oracle.com 1521 db10gr2.idc.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 "incq128ad.idc.oracle.com 1521 db10gr2.idc.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.

How to Add Shared Folders in VmWare Player

2011-06-11T21:46:00.001-07:00

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.

Search Oracle Forums

2011-06-09T04:42:00.001-07:00

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

2011-06-09T04:15:00.001-07:00

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

2011-06-09T02:49:00.001-07:00

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

Create RAC Instance using Oracle VM

2011-06-07T19:50:00.001-07:00

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

Using SFTP with Oracle SOA

2011-05-05T03:04:00.001-07:00

Please refer to the URL

http://myexperienceswithsoa.blogspot.com/2011/04/using-sftp-with-oracle-soa.html

How to Redirect weblogic stdout to a log file

2011-04-21T22:08:00.001-07:00

By configuring one option in the Admin console of weblogic
Server -> Admin server (or the Managed Server) -> Logging -> General -> Advanced Settings -> Redirect stdout logging enabled

or using JAVA_OPTIONS -Dweblogic.log.RedirectStdoutToServerLogEnabled=true

How to apply WebLogic Private Patch

2011-03-31T02:07:00.001-07:00

Patch Identifier: HJ5X
Passcode: I23H9PRN

1) First download the patch using the Smart Update tool (BSU):
    a) Launch Smart Update (BSU) as follows:
        -cd <MW_HOME>/utils/bsu where MW_HOME is location of 10.3.3 Install
        -Enter "bsu.sh" (for Unix/Linux) or "bsu.cmd" (for Windows)
    b) Login using your "My Oracle Support" account and password.
    c) If the 'Target Installation' (on left menu) is not correct then:
        - From menu bar, go to 'File -> Target Installation -> Find Other BEA Home'
        - Then choose the BEA Home for WebLogic 10.3.3
    d) Go to 'Get Patches' tab
    e) From menu bar, choose Patches -> Retrieve Private
    f) Enter the following:
          Patch Identifier: HJ5X
          Passcode: I23H9PRN
    g) Choose option to check for patch conflicts
    h) Patch will then be downloaded. The information is downloaded to these two files:
         i. <MW_HOME>/utils/bsu/cache_dir/HJ5X.jar
        ii. <MW_HOME>/utils/bsu/cache_dir/patch-catalog.xml

2) Next install the patch. There are two options for installing patch:
Option 1: Install the patch using 'online mode' (this is the preferable option if you can run SmartUpdate Online, in the environment where you are applying patch)
Option 2: Apply the patch in 'offline mode' (use this option in environments where you can't run SmartUpdate online due to firewall restrictions)

Below are instructions for 'Option 1' and 'Option 2'

Instructions for Option 1 (Smart Update Online)
-------------------------------------------------------------------------
a) If you aren't already logged into SmartUpdate, then log in using steps 1a through 1c (above)
b) Go to 'Manage Patches' tab
c) You will see the Patch 1Y9I in the 'Downloaded Patches' window (at bottom of page)
d) Click the'Apply' button next to the patch and it will be installed.

Instructions for Option 2 (Smart Update Offline)
------------------------------------------------------------------------------
a) Copy the files (that you downloaded in step 1) to the WebLogic environment where you are applying the patch.
    For example, if you downloaded the patch to MW_HOME1 but want to apply it to MW_HOME2, then do the following:
      i. copy <MW_HOME1>/utils/bsu/cache_dir/HJ5X.jar to <MW_HOME2>/utils/bsu/cache_dir/HJ5X.jar
     ii. copy <MW_HOME1>/utils/bsu/cache_dir/patch-catalog.xml to <MW_HOME2>/utils/bsu/cache_dir/patch-catalog.xml
b) Go to your <MW_HOME2>\utils\bsu and launch bsu.cmd (or bsu.sh)
c) When prompted for your Support ID, click the 'Work Offline' button
d) You will see the Patch HJ5X in the 'Downloaded Patches' window (at bottom of page)
e) Click the'Apply' button next to the patch and it will be installed.

To check whether the patch has been applied or not , start the weblogic server you will see the entry as

<Version: WebLogic Server Temporary Patch for 9833357 Fri Aug 13 13:14:52 EDT 2010
WebLogic Server 10.3.3.0 Fri Apr 9 00:05:28 PDT 2010 1321401 >

Wi-Fi hotspot on Windows 7

2011-03-16T22:37:00.001-07:00

Use the Connectify for Windows Software on Windows 7 machine.

http://www.connectify.me/thanks.html?v=1.2.0.14599

How to enable JDBC SQL Statement Tracing in OC4J

2011-03-13T09:14:00.001-07:00

Take a backup of ojdbc14.jar and ojdbc14dms.jar files.

cd ORACLE_HOME\jdbc\lib

copy ojdbc14.jar ojdbc14.jar.org
copy ojdbc14dms.jar ojdbc14dms.jar.org

Replace the JDBC jar files with the JDBC log files
copy ojdbc14dms_g.jar ojdbc14dms.jar
copy ojdbc14_g.jar ojdbc14.jar

In the opmn.xml add the following values to the opmn.xml file
-Doracle.jdbc.Trace=true -Djava.util.logging.config.file=c:/temp/OracleLog.properties

For example ,

<process-type id="oc4j_soa" module-id="OC4J" status="enabled">
               <module-data>
                  <category id="start-parameters">
<data id="java-options" value=" -Doracle.jdbc.Trace=true -Djava.util.logging.config.file=c:/temp/OracleLog.properties   -Xrs -server -XX:MaxPermSize=128M -ms512M -mx1024M -XX:AppendRatio=3 -Djava.security.policy=$ORACLE_HOME/j2ee/oc4j_soa/config/java2.policy -Djava.awt.headless=true -Dhttp.webdir.enable=false -Doraesb.home=d:\soa1013\integration\esb -Dhttp.proxySet=false -Doc4j.userThreads=true -Doracle.mdb.fastUndeploy=60 -Doc4j.formauth.redirect=true -Djava.net.preferIPv4Stack=true -Dorabpel.home=d:\soa1013\bpel -Xbootclasspath^/p:d:\soa1013\bpel/lib/orabpel-boot.jar -Dhttp.proxySet=false"/>                  </category>
                  <category id="stop-parameters">

Sample OracleLog.properties file
==================================

#### Console Handler ######

#java.util.logging.ConsoleHandler.level = ALL
#java.util.logging.ConsoleHandler.formatter =
#java.util.logging.SimpleFormatter
#handlers = java.util.logging.ConsoleHandler

#### File Handler ######

oracle.jdbc.handlers=java.util.logging.FileHandler
java.util.logging.FileHandler.level=ALL
java.util.logging.FileHandler.pattern=c:/temp/jdbc.log
java.util.logging.FileHandler.count=1
java.util.logging.FileHandler.formatter=java.util.logging.SimpleFormatter

# Uncomment and/or change the levels for more detail
#oracle.jdbc.level = FINEST
#oracle.jdbc.connector.level = FINE
#oracle.jdbc.driver.level = FINEST
#oracle.jdbc.internal.level = FINEST
#oracle.jdbc.oci.level = FINE
#oracle.jdbc.oracore.level = FINE
#oracle.jdbc.pool.level = FINE
#oracle.jdbc.rowset.level = FINEST
#oracle.jdbc.util.level = FINEST
#oracle.jdbc.xa.level = FINE
#oracle.jdbc.xa.client.level = FINE
#oracle.jpub.level = FINE
#oracle.net.level = FINE
#oracle.sql.level = FINEST
#.level=CONFIG
#oracle.level=CONFIG
#oracle.jdbc.pool.level=CONFIG
#oracle.jdbc.util.level=CONFIG
#oracle.sql.level=CONFIG

#oracle.jdbc.driver.level=FINE

# This is the setting needed for sql debug
oracle.jdbc.driver.level=FINE
oracle.level=OFF

oracle.level=OFF
#oracle.jdbc.driver.level=CONFIG
#oracle.sql.level = FINEST

#set JAVA_OPTIONS=-Doracle.jdbc.Trace=true -Djava.util.logging.config.file=c:/temp/OracleLog.properties

How to use the JDBC Driver Tracing in Weblogic/SOA 11g to capture the sql statements issued by the JDBC Drivers

2011-03-12T09:01:00.001-08:00

Before starting the weblogic server set the following environment variables ,

On Windows

set EXT_PRE_CLASSPATH=C:\Oracle\Middleware\wlserver_10.3\server\ext\jdbc\oracle\11g\ojdbc6_g.jar
set JAVA_OPTIONS=-Doracle.jdbc.Trace=true -Djava.util.logging.config.file=c:/temp/OracleLog.properties

On Unix

set EXT_PRE_CLASSPATH=/home/oracle/Middleware/wlserver_10.3/server/ext/jdbc/oracle/11g/ojdbc6_g.jar
set JAVA_OPTIONS=-Doracle.jdbc.Trace=true -Djava.util.logging.config.file=/tmp/OracleLog.properties

In the OracleLog.properties have the following entries ,

#### Console Handler ######

#java.util.logging.ConsoleHandler.level = ALL
#java.util.logging.ConsoleHandler.formatter =
#java.util.logging.SimpleFormatter
#handlers = java.util.logging.ConsoleHandler

#### File Handler ######

#oracle.jdbc.driver.level=FINE

# This is the setting needed for sql debug
oracle.jdbc.driver.level=FINE
oracle.level=OFF

TRACE_1: Public Enter: "DELETE FROM MDS_LABELS WHERE LABEL_NAME = ? AND LABEL_PARTITION_ID =?"
Mar 12, 2011 10:18:10 PM oracle.jdbc.driver.PhysicalConnection prepareStatement
TRACE_1: return: oracle.jdbc.driver.OraclePreparedStatementWrapper@1d56ac0
Mar 12, 2011 10:18:10 PM oracle.jdbc.driver.PhysicalConnection prepareStatement
TRACE_1: Exit
Mar 12, 2011 10:18:10 PM oracle.jdbc.driver.OracleStatement setPoolable
TRACE_1: Public Enter: true
Mar 12, 2011 10:18:10 PM oracle.jdbc.driver.OracleStatement setPoolable
TRACE_1: Exit
Mar 12, 2011 10:18:10 PM oracle.jdbc.driver.OraclePreparedStatement setString
TRACE_1: Public Enter: 1, "preDeployLabel_soa-infra"
Mar 12, 2011 10:18:10 PM oracle.jdbc.driver.OraclePreparedStatement setString
TRACE_1: Exit
Mar 12, 2011 10:18:10 PM oracle.jdbc.driver.OraclePreparedStatement setLong
TRACE_1: Public Enter: 2, 1
Mar 12, 2011 10:18:10 PM oracle.jdbc.driver.OraclePreparedStatement setLong
TRACE_1: Exit
Mar 12, 2011 10:18:10 PM oracle.jdbc.driver.OraclePreparedStatement executeUpdate
lTRACE_1: Public Enter:
Mar 12, 2011 10:18:10 PM oracle.jdbc.driver.OracleStatement doExecuteWithTimeout
CONFIG: SQL: DELETE FROM MDS_LABELS WHERE LABEL_NAME = ? AND LABEL_PARTITION_ID =?

The sql statement is "DELETE FROM MDS_LABELS WHERE LABEL_NAME = ? AND LABEL_PARTITION_ID =?"
The bind variales are "preDeployLabel_soa-infra" and 1.
Mar 12, 2011 10:18:10 PM oracle.jdbc.driver.OraclePreparedStatement setString
TRACE_1: Public Enter: 1, "preDeployLabel_soa-infra"
Mar 12, 2011 10:18:10 PM oracle.jdbc.driver.OraclePreparedStatement setLong
TRACE_1: Public Enter: 2, 1

The sql statement is "DELETE FROM MDS_LABELS WHERE LABEL_NAME = 'preDeployLabel_soa-infra' AND LABEL_PARTITION_ID =1"

Another example ,

TRACE_1: Public Enter: "SELECT PARTITION_ID FROM MDS_PARTITIONS WHERE PARTITION_NAME=?"

Mar 12, 2011 10:18:10 PM oracle.jdbc.driver.OraclePreparedStatement setString
TRACE_1: Public Enter: 1, "soa-infra"
Mar 12, 2011 10:18:10 PM oracle.jdbc.driver.OraclePreparedStatement setString

The sql statement is "SELECT PARTITION_ID FROM MDS_PARTITIONS WHERE PARTITION_NAME='soa-infra'

If you want only the sql statements with out bind variables use
oracle.jdbc.driver.level=CONFIG

This displays the sql statemnets as

CONFIG: 13EEB53C SQL: update MEDIATOR_CASE_INSTANCE set STATUS ='locked', LOCK_TIME =?, CONTAINER_ID =? where STATUS = 'ready' and rownum < ?
CONFIG: 466208C SQL: SELECT CASE_ID, CONTAINER_ID, MSG_ID, OPERATION, COMPONENT_DN, PRIORITY, LOCK_TIME, QNAME_LOCAL_PART, IS_EVENT, QNAME_NAMESPACE, CASE_INFO, SOURCE_URI, COMPONENT_STATUS, INSTANCE_CREATED, CREATION_DATE, STATUS, DUMMY1 FROM MEDIATOR_DEFERRED_MESSAGE WHERE (((STATUS = ?) AND (LOCK_TIME = ?)) AND (CONTAINER_ID = ?))

OPatch on Windows 7 fails with the error OPATCH_JAVA_ERROR: Wrong number of arguments

2011-03-05T06:41:00.001-08:00

"Opatch apply" went smooth till verify patch and then exit with following error description:

"OPATCH_JAVA_ERROR: Wrong number of arguments. VerifyPatch needs ORACLE_HOME, OUI location, patch location, patch I
Exception in thread "main" java.lang.Exception: Wrong number of arguments. VerifyPatch needs ORACLE_HOME, OUI location, patch location, patch ID and path to 'ar' command, no_inventory, OS_ID.

at opatch.VerifyPatch.main

Verification of the patch failed.
ERROR: OPatch failed as verification of the patch failed.

Even rolling back a patch is failing.

The OS_ID is retruning as "0" , that was the main reason why it is failing on Windows 7.

Please set the environment variable

set OPATCH_PLATFORM_ID=233 and run the opatch apply command.

How to use different JDBC drivers with SOA 10g

2011-03-04T04:33:00.001-08:00

Please refer to the following note for the certification information on the jdbc drivers with OAS 10.1.3.

JDBC Driver Support for Oracle Application Server (Fusion Middleware) (Doc ID 365120.1)

Couple of points ,

Please note that we can use only thin drivers. Please also note that replacing the shipped JDBC drivers with the new ones are not supported. We have to use the application library support
feature available in 10.1.3.x versions.

How to Use The Latest Thin JDBC Driver Across All Applications For a 10.1.3.x OAS Container (Doc ID 420303.1)

The procedure given below should help you in configuring the 11g JDBC thin drivers with OAS 10.1.3. Please also refer to the BUG 8726607 - 10.1.3.5 CERT WITH 11G JDBC DRIVERS : EXTRA STEPS TO NOTE 420303.1

1. Within each container, create the following directory to host the
shared library:

$OH/j2ee/<container>/shared-lib/oracle.jdbc/11.1.0.7
2. From the Oracle Database 11g installation, copy the following files
into the newly created directory above:

   $OH/rdbms/jlib/aqapi.jar
   $OH/jdbc/lib/ojdbc5.jar *
   $OH/oc4j/j2ee/home/lib/ojms-provider.jar

ojdbc5.jar is for application server installs using JDK 5 (the
default in 10.1.3). For installs configured to use JDK 6, copy
ojdbc6.jar instead.

3. Create the following oracle.jdbc shared-library entry in the
container $OH/j2ee/<container>/config/server.xml file with the version
attribute set to 11.1.0.7, and at the same time specify the new version
for the BPEL and ESB imported oracle.jdbc shared libraries.

- Make sure the oracle.jdbc library is defined before the oracle.bpel.common
and oracle.esb libraries.
- Replace "[$OH]" in the below example with the path to your Oracle Home
directory.

<application-server ?

   <shared-library name="oracle.jdbc" version="11.1.0.7">
     <code-source path="ojdbc5.jar"/>
     <code-source path="aqapi.jar"/>
     <code-source path="ojms-provider.jar"/>
      <code-source path="[$OH]/opmn/lib/ons.jar"/>
      <code-source path="[$OH]/jdbc/lib/ocrs12.jar"/>
    </shared-library>
    <shared-library name="oracle.bpel.common" ?>

      <import-shared-library name="oracle.jdbc"   min-version="11.1.0.7"/>

    </shared-library>
    <shared-library name="oracle.esb" ?>

      <import-shared-library name="oracle.jdbc" min-version="11.1.0.7"/>

    </shared-library>

</application-server>

4. Open the AppsAdapter, AqAdapter and DbAdapter config in these files:

$OH/j2ee/oc4j_soa/application-deployments/default/AppsAdapter/oc4j-ra.xml
$OH/j2ee/oc4j_soa/application-deployments/default/AqAdapter/oc4j-ra.xml
$OH/j2ee/oc4j_soa/application-deployments/default/DbAdapter/oc4j-ra.xml

Edit the config as below to specify the same minimum version of the
oracle.jdbc shared-library.

    <import-shared-library name="oracle.jdbc" min-version="11.1.0.7"/>

5. Restart the container

SOA Oracle Lite DB Tracing

2011-01-31T22:04:00.001-08:00

SOA Uses 10.2 POLite.

Please refer to the link for more debuginfo.

Set OLITE_SQL_TRACE=TRUE in c:\windows\polite.ini file ,

The sql trace info is written to c:\windows\system32\oldb_trc.txt

OLITE_SQL_TRACE

Generates the SQL statement text, compilation time, execution plan, and the bind value.

For example:

OLITE_SQL_TRACE = TRUE

SQL trace output is dumped to a trace file named oldb_trc.txt in the current working directory of the database process. For a database service on Windows, Windows NT or the Oracle Database Lite daemon for a Linux platform, the current working directory is specified by the wdir parameter during the database startup service or daemon. Applications that use an embedded connection to connect to the database contain a working directory. This working directory is the application working directory. To implement the tracing feature, the database process must contain permissions to create the trace file in the current working directory. The trace output is always included in the trace file. If the trace file does not exist, it is created automatically.

How to Install additional packages/upgrade OEL 5

2011-01-30T20:29:00.001-08:00

Download and Install Oracle Linux

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

Oracle Linux 4, Update 6 or Newer

# cd /etc/yum.repos.d
# mv Oracle-Base.repo Oracle-Base.repo.disabled
# wget http://public-yum.oracle.com/public-yum-el4.repo

Oracle Linux 5

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

Oracle VM 2

# cd /etc/yum.repos.d
# wget http://public-yum.oracle.com/public-yum-ovm2.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 update , yum install firefox

You can also use “system-config-packages” for this purpose.

How to setup iscsi target on OEL 5.5

2011-01-26T23:32:00.000-08:00

http://fedoraproject.org/wiki/Scsi-target-utils_Quickstart_Guide

RedHat have included an iSCSI daemon which is also installable using yum:

yum install iscsi-initiator-utils

To connect to the target, edit /etc/iscsi/initiatorname.iscsi and change InitiatorName to something you prefer (Remember! it must be in the IQN format, iqn.yyyy-mm.{reversed domain name}:an_easy_to_remember_lablel. I usually use iqn.2009-02.com.hamzahkhan:hostname_of_box). Next start up iSCSId:

/etc/init.d/iscsid start

and use iSCSI target descovery to find the targets on the server:

iscsiadm -m discovery -t st -p $SERVERS_IP

If all is well, it should output the names of all the targets that the initiator is allowed to connect to!

Next, we need to create the disk nodes. To do this, RedHat have provided a nice start up script. This script will login to all the targets that the iSCSI daemon knows about. We have already used the iscsiadm command to tell the iSCSI daemon which targets exist on the server, so using the script is all that is left:

/etc/init.d/iscsi start

On Windows 7 use this note ,

http://www.windowsnetworking.com/articles_tutorials/Connecting-Windows-7-iSCSI-SAN.html

How to Find out which java thread takes the maximum cpu time in windows

2011-01-24T20:14:00.001-08:00

On Error Resume Next
Const adVarChar = 200
Const MaxCharacters = 255
Set DataList = CreateObject("ADOR.Recordset")
DataList.Fields.Append "ProcessID", adVarChar, MaxCharacters
DataList.Fields.Append "ThreadID", adVarChar, MaxCharacters
DataList.Fields.Append "PercentUserTime", adVarChar, MaxCharacters
DataList.Fields.Append "PercentProcessorTime", adVarChar, MaxCharacters
DataList.Open
strComputer = "."
Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\cimv2")
Set colItems = objWMIService.ExecQuery("Select * from Win32_PerfFormattedData_PerfProc_Thread where IDProcess ="&WScript.Arguments.Item(0),,48)
For Each objItem in colItems
DataList.AddNew
DataList("ProcessID") = objItem.IDProcess
DataList("ThreadID") = objItem.IDThread
DataList("PercentUserTime") = objItem.PercentUserTime
DataList("PercentProcessorTime") = objItem.PercentProcessorTime
DataList.Update
Next
DataList.Sort = "PercentUserTime"
DataList.Reverse()
DataList.Reverse()
DataList.MoveFirst
Do Until DataList.EOF
Wscript.Echo DataList.Fields.Item("ProcessID") _
& vbTab & DataList.Fields.Item("ThreadID")_
& vbTab & Hex(DataList.Fields.Item("ThreadID"))_
& vbTab & DataList.Fields.Item("PercentUserTime")_
& vbTab & DataList.Fields.Item("PercentProcessorTime")
DataList.MoveNext
Loop
' Set WshShell = WScript.CreateObject("WScript.Shell")
'WshShell.Run "cmd /c C:\Oracle\Middleware\jdk160_18\bin\jstack.exe " &WScript.Arguments.Item(0)

Set objShell = WScript.CreateObject("WScript.Shell")
Set objExecObject = objShell.Exec("cmd /c C:\Oracle\Middleware\jdk160_18\bin\jstack.exe " &WScript.Arguments.Item(0))
Do While Not objExecObject.StdOut.AtEndOfStream
strText = objExecObject.StdOut.ReadLine()
Wscript.Echo strText
Loop

Find out the java process , but running the command , jps and run the vbscript using the command “cscript test1.vbs”

How to create Bootable Image in USB Drive

2011-01-13T01:01:00.001-08:00

Download MultiBootISOs-2.1.4.7.exe

Run MultiBootISOs-2.1.4.7.exe following the onscreen instructions
Select the ISO you want to Boot from the Menu and enjoy!
The best thing about this tool is that you can select multiple images in one USB drive

Please also refer to this URL for more details on this ,

http://www.pendrivelinux.com/boot-multiple-iso-from-usb-multiboot-usb/

How to create RAW Partions on linux (to be used for ASM and RAC)

2011-01-07T09:06:00.000-08:00

First create the HDD Partitions , ensure that you have 3 partions
say /dev/sdb1 , /dev/sdc1 and /dev/sdd1

run the command fdisk -l and verifiy them

1. Edit the /etc/sysconfig/rawdevices file, and add the following lines.

/dev/raw/raw1 /dev/sdb1
/dev/raw/raw2 /dev/sdc1
/dev/raw/raw3 /dev/sdd1

2. service rawdevices restart

3. raw -qa

4. Create the softlinks for the files

ln -s /dev/raw/raw1 /u01/oradata/ocr
ln -s /dev/raw/raw2 /u01/oradata/votingdisk
ln -s /dev/raw/raw3 /u01/oradata/asm1

5. Add the following lines in the "/etc/rc.local" file.

chown oracle:oinstall /dev/raw/raw1
chown oracle:oinstall /dev/raw/raw2
chown oracle:oinstall /dev/raw/raw3
chmod 600 /dev/raw/raw1
chmod 600 /dev/raw/raw2
chmod 600 /dev/raw/raw3

How to Clean up failed RAC Install on linux

2011-01-07T08:43:00.001-08:00

rm -rf /etc/oracle/*
rm -f /etc/init.d/init.cssd
rm -f /etc/init.d/init.crs
rm -f /etc/init.d/init.crsd
rm -f /etc/init.d/init.evmd
rm -f /etc/rc2.d/K96init.crs
rm -f /etc/rc2.d/S96init.crs
rm -f /etc/rc3.d/K96init.crs
rm -f /etc/rc3.d/S96init.crs
rm -f /etc/rc5.d/K96init.crs
rm -f /etc/rc5.d/S96init.crs
rm -Rf /etc/oracle/scls_scr
rm -f /etc/inittab.crs
cp -f --reply=yes /etc/inittab.orig /etc/inittab
rm -rf /u01/crs
rm -rf /u01/app/oracle
rm -f /etc/oraInst.loc
dd if=/dev/zero of=/dev/raw/raw1 bs=1M count=256000
dd if=/dev/zero of=/dev/raw/raw2 bs=1M count=256000

Migrate from VMWare Server to VirtualBox

2011-01-07T08:26:00.000-08:00

1.Important: From VMWare Server, start your virtual machines and uninstall VMWare toolbox!

2.Locate the main VMDK file you want converted. It's usually a XML file, or a binary
file with a XML header.

3.From the command line, CD to the location of that file. Say the VMWare disk image to convert is Root_Disk.vmdk.

4.Run the following command to convert to VDI:

C:\Program Files\Oracle\VirtualBox\VBoxManage clonehd --format vdi "c:\Virtual Machines\XP\Windows XP Professional.vmdk" "c:\Virtual Machines\XP\WinXP.vdi"

5.That's it! If you're in Linux, the VDI file will be created under ~/.VirtualBox/Harddisks/.

6.Add that to your media manager and create the virtual machine as you normally would.

How to use Wifi Tethering on Samsung Galaxy i5801

2011-01-01T23:32:00.001-08:00

1. First download the z4root apk file from z4root.1.3.0.apk

2. Download the file fw_bcm4329.bin from
http://dl.dropbox.com/u/1496809/fw_bcm4329.bin
3) Mount your sdcard
4) Create a directory named "android.tether" (without quotes)
5) Open this directory and copy fw_bcm4329.bin into it. (downloaded file)
6) Uninstall old versions of "wireless tether"
7) Install the latest 2.0.5 release of WiFi Tether from: http://code.google.com/p/android-wifi-tether/downloads/list

Clean up RAC 10g install

2010-12-25T19:49:00.000-08:00

Soa Suite 11gR1 (11.1.1.3.0) installation guide for Windows

2010-12-06T19:55:00.001-08:00

http://vtkrishn.wordpress.com/2010/09/25/soa-suite-11gr1-11-1-1-3-0-installation-guide-for-windows/

http://adfproject.googlecode.com/files/SOA_Installation_guide.doc

How to find the SOA Version

/home/ias/Oracle/Middleware/Oracle_SOA1/bin/soaversion.sh

*****************************************************************************
Oracle SOA Server version 11.1.1.3.0
          Build: 0
          Build time: Thu Apr 15 22:20:11 PDT 2010
          Build type: release
          Source tag: PCBPEL_11.1.1.3.0_GENERIC_100415.2045.2557

Oracle BAM Source Tag:ORABAM_11.1.1.3.0_GENERIC_100406.2108

Oracle BPM Source Tag: BPM_11.1.1.3.0_GENERIC_100415.1757.0684

Oracle Implementation-Version: Oracle Middleware 11.1.1 (ASKERNEL_11.1.1.3.0_
GENERIC_100411.1150, ADMINSERVER_11.1.1.3.0_GENERIC_100408.2100, J2EE
_11.1.1.3.0_GENERIC_100408.1504, JDEVADF_11.1.1.3.PS2_GENERIC_100408.
2356.5660, TOPLINK_11.1.1.3.0_GENERIC_100323.1800, ENTSEC_11.1.1.3.0_
GENERIC_100403.1733)

Reducing the PDF Page Size when printing

2010-11-11T04:06:00.001-08:00

Sometimes we need to print a pdf on a page that is lesser then A4 size. The main reason for this kind of printing is that size reduction. Carrying a A4 PAGE book is not that handy most of the times.

For this we need to reduce the size of the page while printing. Unfortunately in Acrobat PDF Reader this option is not present.

For this we can use the the PDF-XChange Viewer free edition.

Download the PDF-XChange Viewer from http://www.tracker-software.com/product/downloads/

Select File->Print option and Select the Page Scaling as => Custom Scale and Page Zoon as 75% and Select Auto-Center pages in sheets

Please refer to the screen below

After this you can cut the extra white space using a paper cutter.

How to attach a pdf file to an email from a shell script

2010-11-07T20:36:00.001-08:00

Write the following shell script ,

---
echo "Training Calendar on ` date +%d-%b-%Y` " > /tmp/mailmessage.txt
wget -O /tmp/blr.pdf "http://test.idc.oracle.com/test.pdf"
mutt -s "Training Calendar on ` date +%d-%b-%Y` " -a /tmp/trg_blr.pdf ravi.reddy@oracle.com < /tmp/mailmessage.txt
---

To change the from email address while using mutt
create a .muttrc in the users home directory if it doesnot exist, then enter the feild

set realname="ravi.reddy@oracle.com" this will change the name in the senders name .

How to Hide Username/Passwords in shell scripts

2010-09-15T02:43:00.001-07:00

Please refer to this article for more details on this.

I have lot of shell scripts where I have to store my username and passwords for accessing the data. This is a big security rish as my passwords are exposed.

I need some executable which can convert my shell script to exe so that it will be difficult for the people to get my password.

Download the sources from http://www.datsi.fi.upm.es/%7Efrosal/sources/shc-3.8.6.tgz

Extract the tar file

tar xvfz shc-3.8.6.tgz

Make the executable

cd shc-3.8.6
make

cp shc to /usr/bin directory

I have a shell script which fetches some password protected pages , here
there is no other option for me other then embedding the password as the wget does
not support encrypted passwords

for example ,

cat getcookie.sh

#!/bin/ksh
/usr/bin/wget --keep-session-cookies --save-cookies=/home/ias/cookie.txt -O /home/ias/dd.txt --input-file=/home/ias/urls.txt --http-user=xx.xxx@test.com --http-password=xxxxxxx > /dev/null
cat /home/ias/cookie.txt | grep test | cut --fields=7 > /home/ias/cookie.txt

with the shc script I can convert the shell script as executable so that the passwords are hidden
from the people who has access to my unix system.

Run the shc command

shc -f getcookie.sh

This creates the getcookie.sh.c and getcookie.sh.x where .c is the c source file and .x is the executable.

Now run the getcookie.sh.x executable and change the password from the original getcookie.sh script.

Please refer to the http://blogs.koolwal.net/2009/01/20/howto-encrypting-a-shell-script-on-a-linux-or-unix-based-system/
for more details on this.

How to Upgrade samsung galaxy firmware

2010-09-11T08:07:00.001-07:00

Actually many firmware are available for each area (Europe, Asia and America). Last firmware version are:

Europe: I5800XWJH2
Asia: I5801DDJG6
America: I5800LVIJG8

You can download the ODIN Multi Downloader from

http://download968.mediafire.com/skeyfniqhphg/gnzzbkix0nd/Odin4_03-Spica_ops.zip

Flashing with ODIN it's very simple (sorry for picture):

Before running this utility you need to set the samsung phone in the download firmware mode , for this press

Home+VolDown+Power and hold this for about 30 seconds to 1 minute

In the ODIN screen ,

1) Select "One Package"
2) Select OPS file for I5801 (apollo.ops)

Create apollo.ops file with the following contents ,

0,boot
1,Sbl
2,logo
3,efs
4,zImage
5,factoryfs
6,datafs
7,cache
8,
9,modem

3) In one package select the firmware that you want to flash. (I5801DDJG6.tar) Download the firmware from http://uploading.com/files/1314471a/I5801DDJG6.rar/

4) Start

In about five minutes your mobile will be upgrades.

Setup XMail Server on Windows

2010-09-07T03:07:00.001-07:00

Please refer to the link http://www.halfdone.com/Articles/XMailInstall/ for more details on this.

Here are the simplified steps to configure the XMail Server’s on Windows Machine

1. Download the XMail Server from http://www.xmailserver.org

2. Extract this to a directory say C:\xmail-1.27

3. Copy the exe’s and dll’s to C:\xmail-1.27\MailRoot\bin directory

4. Create the HKEY_LOCAL_MACHINE\SOFTWARE\GNU\XMAIL. Create the Sting (REG_SZ) values called MAIL_ROOT and MAIL_CMD_LINE. For the value of MAIL_ROOT put in the "MailRoot folder" location like C:\xmail-1.27\MailRoot. For MAIL_CMD_LINE you can leave it blank or put in "-Pl -Sl -Ql -Fl -Cl -Ll"

5. Here we are using the default domain , that is xmailserver.test , so no need to modify the configuration files.

6. Run xmcrypt.exe to create an encoded password. It's used in the format of XMCRYPT.EXE <password>.

xmcrypt.exe welcome1

1100161115041616120a1701

7. Open the file C:\xmail-1.27\MailRoot\ctrlaccounts.tab and enter the following values "admin" <tab> "120009060a080054"

8. User and alias creation

Check the domain

ctrlclnt -s localhost -u admin -p welcome1 domainlist "xmailserver.test"

Create two domain users

ctrlclnt -s localhost -u admin -p welcome1 useradd "xmailserver.test" test1 welcome1 U
ctrlclnt -s localhost -u admin -p welcome1 useradd "xmailserver.test" test2 welcome1 U

Check the users

ctrlclnt -s localhost -u admin -p welcome1 userlist "xmailserver.test"

Create aliases for these two users

ctrlclnt -s localhost -u admin -p welcome1 aliasadd "xmailserver.test" test1 ravi1
ctrlclnt -s localhost -u admin -p welcome1 aliasadd "xmailserver.test" test2 ravi2

Check the aliases for these users

ctrlclnt -s localhost -u admin -p welcome1 aliaslist

9. Set up the POP3 email server and SMTP Outgoing server from Thunderbird. For the POP3 accounts set the SMTP Server as the localhost:25

Iphone Links

2010-09-05T23:56:00.001-07:00

How to Put an iPhone Into DFU Mode
http://www.iclarified.com/entry/index.php?enid=1034

How to Unlock the iPhone 4, 3GS, 3G Using UltraSn0w
http://www.iclarified.com/entry/index.php?enid=4253
http://repo666.ultrasn0w.com/

Caching Apple's Signature Server
http://www.saurik.com/id/12

Tiny Umbrella Readme
http://dl.dropbox.com/u/7078752/ReadMe/ReadMe.rtf

http://www.iclarified.com/entry/index.php?enid=9194
How to Backup Your SHSH Blobs Using Firmware Umbrella [Windows]

http://www.iphoneheat.com/2010/07/save-iphone-4-shsh-blobs-for-ios-4-with-tinyumbrella-4-00-49/
Save iPhone 4 SHSH Blobs for iOS 4 with TinyUmbrella 4.00.49

http://wccftech.com/2010/08/15/downgrade-ios-402-ios-401-ios-40-jailbreaking-guide-iphone-4-3gs-3g-ipod-touch/
Downgrade from iOS 4.0.2 to iOS 4.0.1, iOS 4.0, Jailbreaking Guide for iPhone 4, 3GS, 3G and iPod Touch.

http://www.mobile-geeks.com/how-to-fix-different-sim-detected-error-on-iphone-4-after-jailbreak-5623/
How to Fix Different SIM Detected Error on iPhone 4 after Jailbreak/Unlock

hosts file C:\WINDOWS\system32\drivers\etc\hosts
74.208.105.171 gs.apple.com

How To Find & Copy iPhone/iPad ECID Using USBView
http://www.iphoneappsplanet.com/730/find-copy-iphoneipad-ecid-usbview.htm

How to find the Patch Set Version that has been applied on your Oracle_Home

2010-08-16T01:56:00.001-07:00

For the OAS 10g release you can run the following.

cd $ORACLE_HOME/j2ee/home

$ORACLE_HOME/jdk/bin/java -jar oc4j.jar -version
Oracle Containers for J2EE 10g (10.1.3.4.0) (build RELEASE.26167)

or you can also do

cd $ORACLE_HOME/inventory/ContentsXML

cat comps.xml | grep patchset

This shows the o/p as

cat comps.xml | grep patchset
<PATCHSET NAME="oracle.as.j2ee.patchset" VER="10.1.3.4.0" BUILD_NUMBER="0" RELEASE="Production" INV_LOC="PatchSets/oracle.as.j2ee.patchset/10.1.3.4.0/3/" XML_INV_LOC="PatchSets21/oracle.as.j2ee.patchset/10.1.3.4.0/" ACT_INST_VER="10.1.0.6.0" DEINST_VER="10.1.0.2.0" INSTALL_TIME="2009.Mar.17 09:21:56 IST">
      <INFO NAME="helpDir" VAL="PatchSets/oracle/as/j2ee/patchset/v10_1_3_4_0/help/"/>
      <INFO NAME="resourceClass" VAL="PatchSets.oracle.as.j2ee.patchset.v10_1_3_4_0.resources.CompRes"/>
      <REF NAME="oracle.as.j2ee.patchset" VER="10.1.3.4.0" HOME_IDX="5"/>

For the FMW 11g release perform the following

cd $ORACLE_HOME/inventory/ContentsXML

cat comps.xml | grep patchset

This shows the o/p as

For the DB you can issue the command ,

$ORACLE_HOME/bin/sqlplus and note down the version details for example ,

SQL*Plus: Release 10.2.0.4.0 - Production on Mon Aug 16 14:24:29 2010

or you can connect to the DB and find out the version details.

How to Install WebLogic Standalone Server

2010-08-03T21:52:00.001-07:00

1. Download the WebLogic stand alone zip file from the location ,

http://download.oracle.com/otn/nt/middleware/11g/wls1033_dev.zip

2. Extract this zip to a directory say C:\wlsdev

3. Set the following env variables

set JAVA_HOME=C:\jdk16
set MW_HOME=c:\wlsdev

4. Run the installation configuration script in the MW_HOME directory
(This step is required to be run only once. If you move the installation to
another location/machine, you need to rerun this step) configure.cmd
5. Create the domain using the script by running the utility

c:\wlsdev\wlserver\common\bin\config.cmd

6. Create a domain say testdomain in the directory
C:\wlsdev\user_projects\domains\testdomain

7. Start the WLS server by running the command

C:\wlsdev\user_projects\domains\testdomain\startWebLogic.cmd

How to find a file is 32bit or 64 bit on Windows

2010-07-02T05:35:00.001-07:00

Download the utility file.exe from
http://www.vowles-home.demon.co.uk/utils/file.zip

Now run the command

file pidgin-2.6.6.exe

pidgin-2.6.6.exe, DOS/Win, i386 32bit executable, GUI, PE format

file c:\wordpad.exe

c:\wordpad.exe, DOS/Win, x86-64 64bit executable, GUI, PE format

file c:\TeraCopyExt64.dll

c:\TeraCopyExt64.dll, DOS/Win, x86-64 64bit executable, dll, GUI, PE format

file c:\TeraCopyExt.dll

c:\TeraCopyExt.dll, DOS/Win, i386 32bit executable, GUI, PE Modifed

How to Configure Exchange Connector

2010-06-03T03:14:00.001-07:00

1. Try to get hold of a system where exchange and active directory are installed.

2. Install AD Connector on the OIM Server and provision a user (For testing purpose)

3. Install Microsoft Exchange connector on the OIM Server. Please note that you need the Remote Manager only when you are using the exchange server 2007. Otherwise you do not need to any thing on the OIM Server.

4. Create a IT Resource for Exchange and leave all the attributes as blank.

5. Run the “Exchange Mail Store Lookup Reconciliation” task , before running this task scheduler change the “AD IT resource” attribute to the AD Connector that you created in the step no:2.

6. This schedule task populates the “Lookup.ExchangeReconciliation.MailStore” lookup values. For example in my case it populated my mail box name as “celvpint0309-ADInstance~CN=Mailbox Store (MSBOX),CN=First Storage Group,CN=InformationStore,CN=MSBOX,CN=Servers,CN=First Administrative Group,CN=Administrative Groups,CN=MSExchange2003Org,CN=Microsoft Exchange,CN=Services,CN=Configuration,DC=vm,DC=oracle,DC=com”

7. Now provision the AD User to the Exchange System. Only mandatory fields are Email Alias Name and the mail store name.

8. Now log in to the AD Server machine and check the AD User. For the exchange user you will see more attributes in the AD User TAB.

How to use the ADAM Connector with OIM

2010-05-20T05:08:00.001-07:00

1. Download the ADAM Installer from the microsoft site ADAMSP1_x86_English.exe

2. Install the ADAM Executables

3. Click on the menu option Create ADAM Instance

4. Now open the ADAM ADSI Edit Program and connect to the ADAM Server

Use the port number as 50000 and the Naming Context as O=Oracle,c=in

5. Create a user under the directory tree “O=Oracle,c=in” with the username as Admin and set the password as Welcome1.

6. Add this user to the group “CN=Administrators,CN=Roles,O=Oracle,C=in”

7. Create an Organization Unit with the name say BDE

8. From the OIM Create a IT Resource and change the following values

AdminFQDN=CN=Admin,O=BDE,CN=BDE,DC=idc,DC=oracle,DC=com RootContext=o=BDE,cn=BDE,dc=idc,dc=oracle,dc=com AtMap ADGroup=AtMap.ADAMGroup
AtMap ADUser=AtMap.ADAM
isADAM=yes

9. Open the Lookup.ADReconciliation.Organization and add the Organization to the LOV “OU=BDE,O=Oracle,cn=India”

10. Create a user in OIM and provision this user to the ADAM Resource

Find out Zero Byte Files

2010-04-19T22:35:00.001-07:00

import java.io.*;
import java.util.*;

import java.util.zip.*;

public class FindZeroByteFiles {
public FindZeroByteFiles() {
}

    public static void main(String[] args) {
        FindZeroByteFiles findZeroByteFiles = new FindZeroByteFiles();
        File f1 = new File(args[0]);
traverse(f1);
    }
    public static void traverse(File f) {
          String s1 = f.getAbsolutePath();

if (f.isFile())
         {
            long i = filesize(s1)    ;
            if (i==0 ) {
                System.out.println(s1);
            }
         }

          if (f.isDirectory()) {
            String[] children = f.list();
            for (int i=0; i<children.length; i++) {
              traverse(new File(f, children[i]));
            }
          }
        }

    public static long filesize(String filename) {
        long i = 0;
        BufferedReader in = new BufferedReader(new InputStreamReader(System.in));
            File f = new File(filename);
          if(f.exists()){
           long file_size = f.length();
            // System.out.println("Size of the file : " + file_size);
               i = file_size;
           }
      return i;
    }
}

Run this program with the following arguments.

java -client -classpath C:\ravi FindZeroByteFiles d:\Test

Iphone BSNL 3g Testing

2010-03-25T18:17:00.001-07:00

You need to enter the following details manually for the BSNL 3g Setp

(Settings > General > Network > Cellular Data Network > Advanced >

And set the following entries

APN: gprssouth.cellone.in
U: +91(Mobile number)
P: +91(Mobile Number)

With the SpeedTest I got the results of 1.6MB download and
270KB Upload speed.

How to JailBreak and Unlock iphone

2010-03-25T09:13:00.001-07:00

I recently bought an iphone 3g in ebay. The phone came up AT&T sim card and locked.

The phone is having 3.1.2(7D11) firmware and 05.11.07 baseband.

I initially tried to use the blackra1n. I used the following article to
jailbreak and unlock my iphone 3g version. It is extremely easy to use this utility. You just need to connect your iphone to the computer and run the blackrain utility.

http://www.iphonedownloadblog.com/2009/11/03/tutorial-jailbreak-iphone-3-1-2-blackra1n/

But after unlocking I found various problems like GPS not working and ssh to the iphone is not working etc. I found that all these problems are due to some bugs in the blackra1n jail breaking code.

Because of these problems I decided to use some other jail broken solutions so that I can get back my GPS and other stuff that were broken with the blackra1n.

Here is the procedure that I followed for this.

First I downloaded the utility from the site
http://downloads.ih8sn0w.com/f0recast-1.1.exe

Connect your iphone to the computer and run this utility.

Here is the screen shot from that utility.

From here I found that I can use any jail broken utility so I decided
use redsn0w for this as this is from iphone dev team.

As my phone was already jailbroken I want to restore to the base settings.

I downloaded the 3.1.2 firmware from the location given below ( Please note that you need to check your firmware version from iphone using Settings-> General -> Version , my version is 3.1.2(7D11) and download the correct version only.

so I downloaded the corresponding the firmware version from the location

http://appldnld.apple.com.edgesuite.net/content.info.apple.com/iPhone/061-7468.20100202.pbnrt/iPhone1,2_3.1.3_7E18_Restore.ipsw

After downloading connect your iphone to the itunes and Press the Shift button and Click on Restore button , this will ask
for the iphone firmware file and here select the file iPhone1,2_3.1.3_7E18_Restore.ipsw.

iTunes will automatically put the iphone in the restore mode and reboots the iphone. After this operation iphone will be in the factory condition with locked. In this mode you will be only able to make emergency calls only. Do not get panic at thing point of time. We need to jailbreak this to get the iphone screen back.

Download redsnow 9.2 from the following link

http://xs1.iphwn.org/rs//redsn0w-win_0.9.2.zip

extract this file to a directory and copy the file iPhone1,2_3.1.3_7E18_Restore.ipsw to the same directory.

Now run the program redsn0w.exe and click on the browse button and select the iPhone1,2_3.1.3_7E18_Restore.ipsw
file.

Here is the screen shot for that ,

Now click on the next button and select the option's
Install Cydia etc.

After this follow the exact steps mentioned in the screen, You need to enter the iphone in to DFU mode and the redSn0w does the rest. If you are not a expert of iphone you may need to try this 3 or 4 times.

After this operation your phone is Jail Broken.

Now you need to unlock the phone. Please use the following link to unlock the phone using the blacksn0w.

Ensure that you have a wi-fi connection in your home before trying this. Enable the wi-fi connection on your iphone so that you can download the unlock utility using this wi-fi connection.

This is also extremely easy you , you can follow the url given below for more details on this.

http://www.aboutonlinetips.com/unlock-iphone-3g-3gs-os-3-1-2-using-blacksn0w-via-cydia/

Step 1 - Start ‘Cydia’ on your iPhone springboard.
Step 2 - Select ‘Manage’ tab at the bottom of your iPhone screen and then select ‘Sources’.
Step 3 - Select ‘Edit’ and then select ‘Add’. Now enter a url source. Type ‘http://blackra1n.com’ and select on ‘Add Source’. Once Cydia has added the source click on ‘Return to Cydia’ button.
Step 4 – Once the installation is completed. Search for ‘blacksn0w’ in Cydia and install it.
Step 5 - Reboot your iPhone. Your iPhone 3G or 3GS on 3.1.2 firmware will be unlocked automatically.

Disabling Windows 2003 Internet explorer security settings

2010-03-25T04:43:00.001-07:00

Windows Server 2003 shipped with security locked down by default. Part of this locking down is Internet Explorer Enhanced Security which is an extra layer of protection when surfing the internet using Internet Explorer (more information can be found by going here on a Windows Server 2003 [test] machine).

Click Start, put your mouse over Control Panel, and click Add/Remove Programs

Now click Add/Remove Windows Components

After a few seconds a window will pop-up. Click the check mark next to Internet Explorer Enhanced Security Configuration (to make it unchecked). If you'd like to only disable it for Administrators or only for Users you can click Details and do so.

Press Next, after this internet explorer will work in the same way that is used to work with Windows XP.

How to use Custom ringtones in iPhone

2010-03-22T00:36:00.001-07:00

1. Get access to the mp3 or wav file that you want to convert to a ringtone. In my example, I am looking for a rock drummer loop as a ringtone for my friend who is a monkey percussionist.

2. Drag the file into iTunes

3. Select the file in iTunes and then select Convert Selection to AAC in the Advanced menu.

4. Select your new AAC file and select Show in Finder in the File menu

5. In finder, select the file and select Get Info from the File menu and iPhone features

6. Change the file extension from .m4a to .m4r

7. Confirm when the dialog asks if you really want to make the change

8. Drag the new file back into iTunes. The original files will remain but the ringtone will disappear. (It is actually being moved to following location: ~/Music/iTunes/iTunes Music/Ringtones )

9. Connect your iPhone and select the Ringtone tab in iTunes. Select the new ringtone that has been created.

10. Now simply sync your iphone with iTunes.

11. Now you can select the Ringtone you wish.

How to find out the OIM code that gets executed when you click a link on the OIM WebConsole

2010-03-08T21:36:00.001-08:00

1. Most of the code is present in the file
C:\oim9102-Jboss\oim-server\xellerate\webapp\xlWebApp.war

2. Extract this file to a temporary directory

3. From the WebConsole note down the URL
i.e. http://localhost:8080/xlWebApp/AboutXl.do

4. Open the file tiles-defs.xml and look for the entry "AboutXl" in this file

From this we can find out that this is the JSP tjspAboutXlTiles.jsp that gets executed

5. Open the file struts-config.xml and look for the entry "tjspAboutXl"

Here you will find the entries as

<action type="com.thortech.xl.webclient.actions.tcAboutXlAction"
           name="AboutXlForm"
           scope="request"
                 path="/AboutXl" >
    <forward name="success" path="/pages/tjspAboutXl.jsp" />
    </action>
6. Open the com.thortech.xl.webclient.actions.tcAboutXlAction.class file and here you will find this is
calling some EJB code

if (localActionForward != null)
        return localActionForward;
      HttpSession localHttpSession = paramHttpServletRequest.getSession();
      tcAboutXlForm localtcAboutXlForm = (tcAboutXlForm)paramActionForm;
      Hashtable localHashtable = new Hashtable();
      tcHelpOperationsIntf localtcHelpOperationsIntf = getHelpOperIntf(paramHttpServletRequest.getSession(), null);
      localHashtable = (Hashtable)localtcHelpOperationsIntf.getHelpAbout();
      localtcAboutXlForm.setAboutXl(localHashtable);
      logger.debug(LoggerMessages.getMessage("LeftMethodDebug", "tcAboutXlAction/execute"));
      return paramActionMapping.findForward("success");
7. tcHelpOperationsIntf is the Interface and the corresponding class for this is
tcHelpOperationsBean.java file.

This is actual EJB code it is calling

public Map getHelpAbout()
    throws tcAPIException
{
    logger.debug(LoggerMessages.getMessage("EnteredMethodDebug", "tcHelpOperationsBean/getHelpAbout"));
    Hashtable localHashtable = new Hashtable();
    localHashtable.put("Version", "9.1.0.1865.28");
    localHashtable.put("Build", "1865.28");
    String str = "select xsd_value as build from xsd where xsd_code='XL_BUILD_NUMBER'";
....
..

How OIM find's out the Version Details

2010-03-08T19:23:00.001-08:00

OIM checks the version information from 3 places

1. It checks from the database by issuing the following query

select XSD_VALUE from XSD where XSD_CODE='XL_BUILD_NUMBER';

XSD_VALUE
--------------------------------------------------------------------------------
9.1.0.1866.25

2. OIM-HOME\config\Version.prop file , this file contains the following entries

#Wed Feb 17 21:14:42 PST 2010
build.number=9.1.0.1866.25
product.version=9.1.0.2

3. There is a third place where this information is hardcoded in the EJB code.

When you click on the OIM WebConsole Help->About this is the EJB code that gets executed. This class is present in the xlDataObjectBeans.jar file.

Check the file tcHelpOperationsBean.java in the com.thortech.xl.ejb.beansimpl package.

com.thortech.xl.ejb.beansimpl.tcHelpOperationsBean.class file contans the version info

public Map getHelpAbout()
    throws tcAPIException
{
    logger.debug(LoggerMessages.getMessage("EnteredMethodDebug", "tcHelpOperationsBean/getHelpAbout"));
    Hashtable localHashtable = new Hashtable();
    localHashtable.put("Version", "9.1.0.1866.25");
    localHashtable.put("Build", "1866.25");
    String str = "select xsd_value as build from xsd where xsd_code='XL_BUILD_NUMBER'";

....
..

OIM is accepting connections from local host only

2010-03-05T03:07:00.001-08:00

1. Open the file C:\oim9102-Jboss\jboss-4.2.3.GA\server\default\deploy\jboss-web.deployer\server.xml
2. Change the line
<Connector port="8080" address="${jboss.bind.address}"
to
<Connector port="8080" address="0.0.0.0"
After this restart the JBoss server

How to TRACE JDBC Statements from a JDBC Program

2010-02-26T23:06:00.001-08:00

1. Copy the jar file ojdbc14_g.jar in to the classpath. In the case of JBOSS application Server copy the file in to the directory D:\OIM9101-Jboss\jboss-4.2.3.GA\server\default\lib.

Please note that if there is a ojdbc14.jar you need to remove this file first.

2. Add the following java arguments to your java program

-Doracle.jdbc.Trace=true -Djava.util.logging.config.file=OracleLog.properties

If you are using JBOSS App Server then use the following

set JAVA_OPTS=%JAVA_OPTS% -Xms256m -Xmx1024m -XX:PermSize=128m -Doracle.jdbc.Trace=true -Djava.util.logging.config.file=OracleLog.properties

3. The OracleLog.properties file contains the following entries

#### Console Handler ######

#java.util.logging.ConsoleHandler.level = ALL
#java.util.logging.ConsoleHandler.formatter =
#java.util.logging.SimpleFormatter
#handlers = java.util.logging.ConsoleHandler

#### File Handler ######

oracle.jdbc.handlers=java.util.logging.FileHandler
java.util.logging.FileHandler.level=ALL
java.util.logging.FileHandler.pattern=jdbc.log
java.util.logging.FileHandler.count=1
java.util.logging.FileHandler.formatter=java.util.logging.SimpleFormatter

# Uncomment and/or change the levels for more detail
#oracle.jdbc.level = FINEST
#oracle.jdbc.connector.level = FINE
#oracle.jdbc.driver.level = FINEST
#oracle.jdbc.internal.level = FINEST
#oracle.jdbc.oci.level = FINE
#oracle.jdbc.oracore.level = FINE
#oracle.jdbc.pool.level = FINE
#oracle.jdbc.rowset.level = FINEST
#oracle.jdbc.util.level = FINEST
#oracle.jdbc.xa.level = FINE
#oracle.jdbc.xa.client.level = FINE
#oracle.jpub.level = FINE
#oracle.net.level = FINE
#oracle.sql.level = FINEST
#.level=CONFIG
#oracle.level=CONFIG
# This is the setting needed for sql debug
oracle.jdbc.driver.level=CONFIG
#oracle.jdbc.pool.level=CONFIG
#oracle.jdbc.util.level=CONFIG
#oracle.sql.level=CONFIG

#oracle.jdbc.driver.level=FINE

6. Run your JDBC Program , assuming you statement is

select pty_key , pty_value from pty where pty_keyword = :1

This is the Bind Parameter value

INFO: OraclePreparedStatement.setString(paramIndex=1, x=XL.MaxLoginAttempts)

Feb 27, 2010 12:00:41 PM oracle.jdbc.driver.PhysicalConnection getDefaultFixedString
INFO: PhysicalConnection.getDefaultFixedString() returning false
Feb 27, 2010 12:00:41 PM oracle.jdbc.driver.OraclePreparedStatement setString
INFO: OraclePreparedStatement.setString(paramIndex=1, x=XL.MaxLoginAttempts)
Feb 27, 2010 12:00:41 PM oracle.jdbc.driver.OracleStatement doExecuteWithTimeout
CONFIG: SQL: "select pty_key , pty_value from pty where pty_keyword = :1"
Feb 27, 2010 12:00:41 PM oracle.jdbc.driver.T4CPreparedStatement allocateTmpByteArray
SEVERE: oracle.jdbc.driver.T4CPreparedStatement.allocateTmpByteArray : Re-allocate byte array of size : 80
Feb 27, 2010 12:00:41 PM oracle.jdbc.driver.OracleResultSetImpl findColumn
INFO: OracleResultSetImpl.findColumn(columnName=pty_value)
Feb 27, 2010 12:00:41 PM oracle.jdbc.driver.OracleResultSetImpl getString
INFO: OracleResultSetImpl.getString(columnIndex=2)
Feb 27, 2010 12:00:41 PM oracle.jdbc.driver.OracleResultSetImpl close
INFO: OracleResultSetImpl.close()

How do you find whether a Java file is compiled with the debugging info or not

2009-12-04T05:42:00.001-08:00

Open the file using the JD-GUI utility
http://java.decompiler.free.fr/?q=jdgui
Click on a particular .class file , after this go to the menu option
Navigate -> Go to Line option
If this option is not grayed out then that particular jar file has the debug info included.
To find the line info you can also use the following
javap -l SearchJars
This will display LineNumberTable
LineNumberTable:
line 13: 0
line 14: 16
line 15: 27
If this comes up then that means the debugging info is included in to the class file.

Windows Mobile Programming Tips

2009-11-11T01:51:00.001-08:00

How to start the Windows Mobile Emulators from the command line.

"C:\Program Files\Microsoft Device Emulator\1.0\DeviceEmulator.exe" "C:\Program Files\Windows Mobile 6 SDK\PocketPC\Deviceemulation\0409\PPC_USA.BIN" /memsize 128 /s "d:\EmulatorState_prof.dess"

"C:\Program Files\Microsoft Device Emulator\1.0\DeviceEmulator.exe" "C:\Program Files\Windows Mobile 6 SDK\Smartphone\Deviceemulation\0409\SP_USA_GSM_QVGA_LS_VR.bin" /memsize 128 /s "d:\EmulatorState_std.dess"

How to use the same server session with the Terminal Server's

2009-11-02T20:49:00.001-08:00

1. First try to run the command mstsc /v:fmwbde
(If you are lucky you will be connected to the same session)
2. If you are not able to connect to the same session then run the command mstsc /v:fmwbde /admin
This will connect to the admin server console.
3. Open the terminal service manager and select a particulr session and try to connect to this session.

Deployment Management Links are not working On Weblogic 10. 3.1.0

2009-10-05T23:12:00.001-07:00

When trying to access the Deployment Management Links Export and Import are not working with the Weblogic 10.3.1.0 version. This fails with the following error
Either Your Session timed out or you are trying to access a page without logging in.
How ever this works fine on WebLogic 10.3.0.0 version.

There is some change in the functionality due to cross-site scripting vulnerability reasons. Please refer to the Note 866405.1 Applet/Javascript does not have access to JSESSIONID (httponly) cookie for more details on this.

For the Deployment Management Links to work you need to edit the file

C:\oim_server\xellerate\OIMApplications\WLXellerateFull.ear\xlWebApp.war\WEB-INF\weblogic.xml

and add the following entries

<session-descriptor>

<cookie-http-only>false</cookie-http-only>

</session-descriptor>

After the changes the weblogic.xml should look like this ,

<?xml version='1.0' encoding='UTF-8'?> <weblogic-web-app xmlns="http://www.bea.com/ns/weblogic/weblogic-web-app" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.bea.com/ns/weblogic/weblogic-web-app http://www.bea.com/ns/weblogic/weblogic-web-app/1.0/weblogic-web-app.xsd"> <security-role-assignment> <role-name>User</role-name> <principal-name>User</principal-name> </security-role-assignment> <jsp-descriptor> <encoding>UTF-8</encoding> </jsp-descriptor> <container-descriptor> <filter-dispatched-requests-enabled>false</filter-dispatched-requests-enabled> </container-descriptor> <session-descriptor> <cookie-http-only>false</cookie-http-only> </session-descriptor> </weblogic-web-app>

Restart the weblogic server after the above changes.

How to Install OIM On WebLogic

2009-09-04T00:34:00.001-07:00

1. Create the DB schemas

prepare_xl_db.bat DB102 c:\db10204 xladm_910_weblogic xladm_910_weblogic USERS C:\DB10204\ORADATA\DB102\ xladm_910_weblogic TEMP welcome1

DB102 DB Name
c:\db10204 => Oracle_Home
xladm_910_weblogic => DB Username
xladm_910_weblogic => DB Password
USERS => TABLESpace Name (if you want to use the existing one then use say USERS , otherwise give a new name)
C:\DB10204\ORADATA\DB102\ => Table Space Directory
xladm_910_weblogic => dbf file name
TEMP => temporary table space
welcome1 => sys password

2. Create a new domain with the weblogic (Just one Admin Server is more then enough for the OIM)

3. Start this domain

4. Install the OIM using the setup_server.exe

5. For starting the OIM Server you need to use the script
C:\oim91_wl\oim_server\xellerate\bin\xlStartServer.bat
You can not use the usual weblogic starting script for this.

6. After this install the client using setup_client.exe

7. Login to the Design console using the UN/PW : xelsysadm/welcome1

8. Login to the OIM Wen Console using http://rreddy.idc.oracle.com:7001/xlWebApp
with the UN/PW : xelsysadm/welcome1

Sorting the files on the drive (USB Drive)

2009-08-14T19:02:00.001-07:00

Sony music system in my car reads files in the order they are stored on the flash drive , which is very stupid in my opinion. Ideally it
should read the file in some alphabetical order or based on the last modified date. I found a program call DriveSort which reorganizes the files on a drive so they are in alphabetical order.

Download this program from the location http://www.anerty.net/software/file/DriveSort.php
and open the drive. After this sort the files and save the directory.

Please also refer to this URL for more details on this

http://www.murraymoffatt.com/software-problem-0010.html

Vncviewer clipboard operations like copy/cut+paste suddenly stops on linux

2009-07-27T07:25:00.001-07:00

Many times you must have observed that clipboard operations like copy/cut and paste suddenly stops workings with the vncviewer. The main reason for this there is a program called as vncconfig responsible for these clipboard transfers. Some times the program may get closed because of some bug in vnc or some other reasons like you closed that window.

To get those clipboard operations back you need to run the program "vncconfig &".

After this your clipboard actions should work fine with out any problems.

Set up environment for linux to install Oracle Software

2009-07-24T07:43:00.001-07:00

// Change sysctl.conf file to add the kernel parmeters

cat >> /etc/sysctl.conf << EOF
#This sets SEMMSL, SEMMNS, SEMOPM, SEMMNI
kernel.sem = 256 32000 100 142
kernel.shmmax = 4294967295
kernel.shmmni = 4096
kernel.shmall = 2097152
kernel.msgmnb = 65535
kernel.msgmni = 2878
fs.file-max = 206173
EOF

// Persist the sysctl.conf entries

sysctl –p

// Change the ulimit values

cat >> /etc/security/limits.conf << EOF
# Oracle Application Server settings
* soft nofile 2048
* hard nofile 65536
* soft nproc 2047
* hard nproc 16384
EOF

cat >> /etc/pam.d/login << EOF
session required /lib/security/pam_limits.so
EOF

cat >> /etc/profile << EOF
ulimit -u 16384 -n 65536
EOF

#### Oracle requirements for 11gR2 database ########
kernel.sem = 256 32000 100 142
kernel.shmmax = 4294967295
kernel.shmmni = 4096
kernel.shmall = 2097152
kernel.msgmnb = 65535
kernel.msgmni = 2878
fs.file-max = 6815744
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default=4194304
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=1048576
fs.aio-max-nr = 1048576

RPMs needed for 11gR2 Database

libaio-devel-0.3.106-3.2.i386.rpm
sysstat-7.0.2-3.SEL5_2.i386.rpm
unixODBC-devel-2.2.11-7.1.i386.rpm

local copy at \\disco1bdeapac\home\oracle\softwares\RPM112DB (oracle/oracle) windows browseable

How to Use Jmeter to do the LDAP/OID Load Testing

2009-07-18T20:34:00.001-07:00

1. Download the latest Jmeter version from http://jakarta.apache.org/jmeter/

2. Set the JDK 1.5 or JDK 1.6 in your path and run jmeter.bat/jmeter.sh batch file

3. Create a Thread Group with the following values

Set the number of Threads to 50 and the Loop Count to 10. This will send 500 requests to the server.

3. Under the Thread group create a Loop Controller , (This is required as we are doing the following operations in a sequence , Bind to the LDAP Server , Perform a Search against this LDAP Server and Perform another Search and Finally do a LDAP UnBind)

Right Click on the Thread Group and Add Logical Controller –> Loop Controller

4. Under the Loop Controller Add Sampler –> LDAP Extended Request and select the following options (Enter your LDAP Server details here)

Select the Radio Button –> Thread Bind , ServerName –> incq128ad.idc.oracle.com , Port –> 389 , Username –> cn=orcladmin and Password –> welcome123

5. Under the Loop Controller Add Sampler –> LDAP Extended Request and select the following options (Peform a search operation against this LDAP Server)

Select the Radio Button –> Search test , Search Base –> cn=TestGroup,cn=Groups,dc=idc,dc=oracle,dc=com , Search Filter –> (objectClass=*) , Scope –> Perform Subtree Search and Attributes as uniquemember

6. Add another LDAP Search for load testing

Under the Loop Controller Add Sampler –> LDAP Extended Request and select the following options (Peform a search operation against this LDAP Server)

Select the Radio Button –> Search test , Search Base –> cn=users, dc=idc,dc=oracle,dc=com, Search Filter –> (&(objectclass=person)(uid=ravi.reddy)), Scope –> Perform Subtree Search and Attributes as uid

7. Under the Loop Controller Add Sampler –> LDAP Extended Request and select the following options (We need to Unbind From the LDAP Server)

Select the Radio Button –> Thread UnBind

8. View the LoadTest results in Table and write the results output to file.

Under the ThreadGroup add the following

Listener –> View Results In a TABLE and enter the file name as /tmp/oidstresstest.log

9. This is how the JMeter project looks like after doing the above steps

10. Now run the Jmeter project by Pressing Control+R or the Menu option Control+R

11. Check the LDAP Log file for the requests from the Jmeter load test and also the file /tmp/oidstresstest.log.

How to use Jmeter to load test Portal Application

2009-07-18T09:27:00.001-07:00

1. Download the latest Jmeter version from http://jakarta.apache.org/jmeter/

2. Set the JDK 1.5 or JDK 1.6 in your path and run jmeter.bat batch file

3. Create a Thread Group with the following values

Set the number of Threads to 50 and the Loop Count to 10. This will send 500 requests to the server

4. Under the ThreadGroup create HTTP Cookie Manager with the following values

The CookieManager is required to pass the cookie values across the different page requests. Otherwise Jmeter ignores the cookie value.

In the cookie manager select the Check Bog Clear Cookies each iteration and set the Cookie Policy to Default.

5. Under the Thread group create a Loop Controller

Right Click on the Thread Group and Add Logical Controller –> Loop Controller

6. Under the Loop Controller Add Sampler –> HTTP Request HTTP Client

Set the Server Name as say incq128ad.idc.oracle.com and Port as 7784 enter the Path as /portal/page?_pageid=33,1&_dad=portal&_schema=PORTAL&_mode=16 Select the CheckBox “Follow Redirects”

7. Under HTTP Request HTTP Client add the HTTP Authorization Manager

Add the Portal username and password in this example I used orcladmin and welcome1.

8. Add another Portal Page for testing

Under the Loop Controller Add Sampler –> HTTP Request HTTP Client

9. Add another SSO Protected Page for testing

Under the Loop Controller Add Sampler –> HTTP Request HTTP Client

Use the following values shown below

10. This is how the JMeter project looks like after doing the above steps

11. Now run the Jmeter project by Pressing Control+R or the Menu option Control+R

12. Check the access_log file for the requests from the Jmeter load test

SSH Setup for RAC

2009-06-10T22:06:00.001-07:00

On the incq128ad machine(linux#1)

mkdir -p ~/.ssh
chmod 700 ~/.ssh

/usr/bin/ssh-keygen -t rsa

/usr/bin/ssh-keygen -t dsa

touch ~/.ssh/authorized_keys

On the ipbde machine(linux#2)

mkdir -p ~/.ssh
chmod 700 ~/.ssh

/usr/bin/ssh-keygen -t rsa

/usr/bin/ssh-keygen -t dsa

touch ~/.ssh/authorized_keys

On the incq128ad machine(linux#1)

ssh incq128ad cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
ssh incq128ad cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys
ssh ipbde cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
ssh ipbde cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys

scp ~/.ssh/authorized_keys ipbde:.ssh/authorized_keys

On the incq128ad machine(linux#1)

cd $HOME
chmod 755 .
chmod 700 .ssh
cd $HOME/.ssh
chmod 600 authorized_keys

On the ipbde machine(linux#2)

cd $HOME
chmod 755 .
chmod 700 .ssh
cd $HOME/.ssh
chmod 600 authorized_keys

On both the machines run the following

ssh incq128ad hostname
ssh ipbde hostname

How to read a SSO protected page

2009-05-13T23:57:00.001-07:00

You can use wget to get the SSO protected page using the following command

wget --debug --http-user=oc4jadmin --http-password=welcome1 -O dd.txt http://incq128ad.idc.oracle.com:7777/private/dd.txt"

You can use the following code to get the SSO protected page. Download the following jar files
commons-logging.jar , httpcore-4.0.jar , commons-codec-1.3.jar , httpclient-4.0-beta2.jar and
httpmime-4.0-beta2.jar

Run the java program with the following options

d:\jdev10gmin\jdk\bin\javaw.exe -client -classpath D:\jdev10gmin\jdev\mywork\Testing\HTTPClient\classes;E:\ias10134\webservices\lib\commons-logging.jar;D:\httpcomponents-core-4.0\lib\httpcore-4.0.jar;D:\commons-codec-1.3\commons-codec-1.3.jar;D:\httpcomponents-client-4.0-beta2\lib\httpclient-4.0-beta2.jar;D:\httpcomponents-client-4.0-beta2\lib\httpmime-4.0-beta2.jar httpclient.ClientAuthentication1

package httpclient;

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

import java.io.InputStreamReader;

import java.util.List;

import org.apache.http.Header;
import org.apache.http.HttpEntity;
import org.apache.http.HttpResponse;
import org.apache.http.auth.AuthScope;
import org.apache.http.auth.UsernamePasswordCredentials;
import org.apache.http.client.HttpClient;
import org.apache.http.client.methods.HttpGet;
import org.apache.http.cookie.Cookie;
import org.apache.http.impl.client.DefaultHttpClient;

/**
* A simple example that uses HttpClient to execute an HTTP request against
* a target site that requires user authentication.
*/
public class ClientAuthentication1 {

    public static void main(String[] args) throws Exception {
        DefaultHttpClient httpclient = new DefaultHttpClient();
        httpclient.getCredentialsProvider().setCredentials(
        new AuthScope("incq128ad.idc.oracle.com", 7777),
        new UsernamePasswordCredentials("orcladmin", "welcome1"));
        HttpGet httpget = new HttpGet("http://incq128ad.idc.oracle.com:7777/private/dd.txt");
        System.out.println("executing request \n" + httpget.getRequestLine());
        HttpResponse response = httpclient.execute(httpget);
        HttpEntity entity = response.getEntity();
        List<Cookie> cookies = httpclient.getCookieStore().getCookies();
            if (cookies.isEmpty()) {
              System.out.println("None");
            } else {
              for (int i = 0; i < cookies.size(); i++) {
                System.out.println("- " + cookies.get(i).toString());
              }
            }
        System.out.println("----------------------------------------");
        System.out.println(response.getStatusLine());
        InputStream in = entity.getContent();
        InputStreamReader inputstreamreader =
            new InputStreamReader(in);
        BufferedReader bufferedreader =
            new BufferedReader(inputstreamreader);
        System.out.println("--------- URL Contents -----------------");
        String line;
        while ((line = bufferedreader.readLine())
                  != null) {
            System.out.println(line);
        }
        bufferedreader.close();
        inputstreamreader.close();
                   in.close();
        System.out.println("----------------------------------------");
        if (entity != null) {
            System.out.println("Response content length: " + entity.getContentLength());
        }
        if (entity != null) {
            entity.consumeContent();
        }

        // When HttpClient instance is no longer needed,
        // shut down the connection manager to ensure
        // immediate deallocation of all system resources
        httpclient.getConnectionManager().shutdown();
    }
}

How to move the domains across the machines in WebLogic

2009-04-13T23:28:00.001-07:00

I have a domain with the name test_domain on my Windows machine , here I have one managed server with some applications deployed.

I would like to move this domain from this machine to the other machine.

On Windows machine use the command pack.cmd to create the domain template

pack.cmd -domain=E:\bea\user_projects\domains\test_domain -template=C:\bea\user_templates\test_domain.jar -template_name="My WebLogic Test Domain"

Now move the test_domain.jar to the linux machine.

On the linux machine run the unpack.sh command to create the domain

unpack.sh -template=/home/ias/test_domain.jar -domain=/home/ias/bea/user_projects/domains/test_domain

After this go to the directory and run the command ,
cd /home/ias/bea/user_projects/domains/test_domain/bin
startWebLogic.sh
startManagedWebLogic.sh test http://localhost:7001

How to print the folder list that are available on a USB Drive

2009-04-13T22:47:00.001-07:00

I am using the Sony MP3 player that can play from a USB drive, I have a difficulty in printing the folder list that are sorted on a last modifed date. This is how I generated the list

1. Use the program filelist ,

Download this from http://www.jam-software.com/filelist/filelist_readme_en.txt

2. filelist g:\ > dd.txt

3. type dd.txt | cut --delimiter=, --fields=2 > dd1.txt

4. After this generate the line numbers

type dd1.txt | uniq | nl > dd2.txt

3. Remove the characters like g:\ and “ etc

5. Now open the file in Excel or Word and Print the file

Beautify the XML Data

2009-04-06T05:44:00.001-07:00

Use the following tool to beautify the XML.

http://www.thedeveloperday.com/tools/beautyXML/

My OWSM Notes

2009-03-25T04:51:00.001-07:00

1. The login username password is : admin/oracle
The URL is http://localhost:7779/ccore/

UN/PW : admin/oracle

2. The log file's you can find under the directory
E:\soa\j2ee\oc4j_soa\log
The important log file is "ccore.log"

3. For the OWSM Log levels check the note
Note 726219.1 How To Change Log Level for Oracle Web Services Manager (OWSM) ?

4. How to install OWSM on Windows/Unix

First run the irca.bat or irca.sh on the existing database
E:\10.1.3.1.0\install\soa_schemas\irca

For the upgrade you need to run upgrade_10131_10134_oracle.sql in the orabpel schema
and run the script upgrade_10133_10134_oracle.sql in oraesb schema.

Printing Problems from IE7

2009-03-19T01:33:00.001-07:00

I was having the small font problem printing from in IE7

Please see KB article http://support.microsoft.com/kb/932538/en-us
Scroll down to the section "More Information" edit registry as specified. But you manually have to add the key. It worked for me without installing any hotfix.

Or;
Copy paste and save the following text to a .reg file and run it.
---
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer\Main\FeatureControl\FEATURE_STF_Scale_Min]
"iexplore.exe"=dword:00000064
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer\Main\FeatureControl\FEATURE_STF_Scale_Min]
"outlook.exe"=dword:00000064
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer\Main\FeatureControl\FEATURE_STF_Scale_Min]
"WinMail.exe"=dword:00000064
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer\Main\FeatureControl\FEATURE_STF_Scale_Min]
"Msimn.exe"=dword:00000064

How to Configure network card (Nvidia Palit MB ) on Linux

2009-03-11T20:57:00.001-07:00

1. Download version 1.25 of Linux nForce Drivers (http://www.nvidia.com/object/linux_nforce_archive.html) from archive (I don't know why they have version 1.23 in Unix drivers page)
2. Unzip and install RPM for RHEL5_U1
3. Copy and replace forcedeth.ko from /lib/modules/2.6.18-53.el5/kernel/drivers/net to /lib/modules/2.6.18-92.1.18.el5/kernel/drivers/net/ (make a backup just in case)
4. Add the following lines to /etc/modprobe.conf (replace eth0 for whatever is yours)
alias eth0 forcedeth
options forcedeth msi=0 msix=0 dma_64bit=0
5. Remove module if loaded
rmmod forcedeth
6. Install module
insmod /lib/modules/2.6.18-92.1.18.el5/kernel/drivers/net/forcedeth.ko msi=0 msix=0 dma_64bit=0
(you may reboot as well but this is faster for testing)
you should get something like this by dmesg
eth0: forcedeth.c: subsystem: 01019:2145 bound to 0000:00:0f.0
7. Configure ifcfg-eth0 (or whatever)
TYPE=Ethernet
DEVICE=eth0
BOOTPROTO=dhcp
HWADDR=00:XX:XX:XX:XX:XX
If you don't know your MAC then forget about that line and do ifconfig eth0 up

How to Find out whether you are using 64 bit JDK or 32 bit JDK

2009-02-19T22:06:00.001-08:00

Write this sample java program

import java.util.Enumeration;
import java.util.Properties;

public class Class1 {
public Class1() {
}

    public static void main(String[] args) {
        Class1 class1 = new Class1();
        Properties p = System.getProperties();
        Enumeration keys = p.keys();
        while (keys.hasMoreElements()) {
          String key = (String)keys.nextElement();
          String value = (String)p.get(key);
          System.out.println(key + ": " + value);
        }

}
}

Run the program

and check for the propert sun.arch.data.model if this shows 32 then you are running in a 32 bit JVM. If this shows 64 bit then you are in 64 bit JVM.

For the 64 bit you run the java using the following option $ORACLE_HOME/jdk/bin/java –d64

This shows sun.arch.data.model: 64

Resolving ClassNotFound Exceptions

2009-02-19T20:25:00.001-08:00

When you are running a Java program or compiling a java program you got a class not found error, going through all the JAR files for finding this particular class file is quite tedious.

The program given below can help you to search inside the jar and/or zip files and tells you whether the file you are looking for is present or not.

Code Example

Below you will find the code example, how you use it and what result you can expect out of it.

SearchJars.java

  package mypackage7;

  import java.util.zip.*;
  import java.io.*;
  import java.util.*;

  public class SearchJars {

    static String s3;
    static String s4 ="";
    static int i1 = 0;
    static int i2 = 0;

    public static void main(String args[]) {
      if (args.length != 2) throw new IllegalArgumentException("Wrong Number of Args !! java SearchJars Direcory_Name filename ");
        File f1 = new File(args[0]);
      s3 = args[1];
      traverse(f1);
      System.out.println("\n\n============== Results ============================");
      System.out.println("Searced  "+ i1  +" Files  in "+ args[0] +" And Found "+i2 +" Entries. "); 
      System.out.println(s4);
    }


    public static void traverse(File f) {
      String s1 = f.getAbsolutePath();

      if (s1.toUpperCase().indexOf(".JAR") != -1 || s1.toUpperCase().indexOf(".ZIP") != -1 ) {
        System.out.println("Searching "+ s1 +"  ....."); 
        i1++;
        try {
          ZipFile zf = new ZipFile(s1);
          for (Enumeration entries = zf.entries(); entries.hasMoreElements();) {
            String s2 = ((ZipEntry)entries.nextElement()).getName();
            if (s2.indexOf(s3) != -1 ) {
              System.out.println("Found  "+s2 + " In " +s1);
              i2++;
              s4 = s4 + "Found  "+s2 + " In " +s1 + "\n";
            }
          }
        } catch (IOException e) {}
      }

      if (f.isDirectory()) {
        String[] children = f.list();
        for (int i=0; i<children.length; i++) {
          traverse(new File(f, children[i]));
        }
      }
    }
  }

Program Usage

java.exe mypackage7.SearchJars D:\oracle\jdev1012\BC4J\jlib DateConvertor

Program Output

  Searching D:\oracle\jdev1012\BC4J\jlib\adfjclient.jar  ..... 
  Found  oracle/jbo/uicli/jui/DateConvertor.class In D:\oracle\jdev1012\BC4J\jlib\adfjclient.jar 
  Searching D:\oracle\jdev1012\BC4J\jlib\adfmejb.jar  ..... 
  Searching D:\oracle\jdev1012\BC4J\jlib\adftags.jar  ..... 
  Searching D:\oracle\jdev1012\BC4J\jlib\bc4jdatum.jar  ..... 

  ============== Results ============================ 
  Searced  4 Files  in D:\oracle\jdev1012\BC4J\jlib And Found 1 Entries.  
  Found  oracle/jbo/uicli/jui/DateConvertor.class In D:\oracle\jdev1012\BC4J\jlib\adfjclient.jar

Best Freeware Software

2009-02-18T20:32:00.001-08:00

For the Folder Sizes http://www.jam-software.com/freeware/index.shtml (TreeSize Free)

For the English Dictionary WORDWEB FREE* VERSION http://wordweb.info/free/

Take a backup of the original DVD’s DVD Shrink http://www.dvdshrink.org/

Best Java Decompiler JD-Gui http://java.decompiler.free.fr/

Ftp Utility FileZilla http://filezilla-project.org/

Free RAR/Unzip utility http://www.tugzip.com/

File Editor NotePad Plus http://notepad-plus.sourceforge.net/uk/site.htm

Free Download Manager http://www.freedownloadmanager.org/

Ipod Backup Utlity

http://www.getsharepod.com

CPU Information CPU-Z

How to Send/Browse Messages to AQ via OC4J in a Standalone Java program

2009-02-13T00:58:00.001-08:00

Set up your queues and AQ resource adapter etc using the following article.

http://rreddy.blogspot.com/2009/02/how-to-use-simple-mdb-with-oracle.html

The only difference with the Servlet and the standalone code with the connection factories and the queues JNDI lookup’s.

<resource-ref-mapping location="TEST_AQ/QueueCF" name="CommonConnectionFactory">

For the standalone java program we use the ConnectionFactory as java:comp/resource/TEST_AQ/QueueConnectionFactories/QueueCF

This can be found from the file oc4j-ra.xml file

For the queue we use the JNDI location for the Queue as

<message-destination-ref-mapping name="TestQueue" location="TEST_AQ/MyQueue/Queues/MYQUEUE" />

But for the standalone java client we use the java:comp/resource/TEST_AQ/Queues/MYQUEUE
Example to Send a Message to JMS

package mdbaq;
import java.io.*;

import java.net.URL;

import java.util.Date;

import java.util.Hashtable;

import javax.servlet.*;
import javax.servlet.http.*;
import javax.jms.* ;
import javax.jms.Queue;
import javax.naming.*;

public class SendJMS {
public SendJMS() {
}

    public static void main(String[] args) {
        SendJMS sendJMS = new SendJMS();
        Queue queue=null;
        QueueSession queueSession=null;
        QueueSender queueSender=null;
        Context jndiContext = null;
        QueueConnectionFactory queueConnectionFactory = null;
        QueueConnection queueConnection = null;

try {

                  Hashtable env = new Hashtable();
                  // Standalone OC4J connection details
                  env.put(Context.INITIAL_CONTEXT_FACTORY, "oracle.j2ee.rmi.RMIInitialContextFactory");
                  env.put(Context.SECURITY_PRINCIPAL, "oc4jadmin");
                  env.put(Context.SECURITY_CREDENTIALS, "welcome1");
                  env.put(Context.PROVIDER_URL, "ormi://localhost:23791");
                  jndiContext = new InitialContext(env);

} catch (NamingException e)
{ System.out.println("Exception occurred: " + e.toString()); }

            try {
             //   queueConnectionFactory = (QueueConnectionFactory) jndiContext.lookup("jms/qcf");
        queueConnectionFactory = (QueueConnectionFactory) jndiContext.lookup("java:comp/resource/TEST_AQ/QueueConnectionFactories/QueueCF");
         //       queue = (Queue)jndiContext.lookup("jms/demoQueue");
                 queue = (Queue)jndiContext.lookup("java:comp/resource/TEST_AQ/Queues/MYQUEUE");
            queueConnection = queueConnectionFactory.createQueueConnection();
            queueSession= queueConnection.createQueueSession(true,Session.AUTO_ACKNOWLEDGE);
            queueSender = queueSession.createSender(queue);
            queueConnection.start();
            } catch (Exception e) {
            System.out.println("Exception occurred: " + e.toString());
            e.printStackTrace();
            }

try {

        TextMessage message = queueSession.createTextMessage();
        message.setText("Test "+new Date());
        queueSender.send(message);
        queueSession.commit();
        } catch (JMSException e) {
        System.out.println("Exception occurred: " +e.toString());
            e.printStackTrace();
        }

System.out.println( " Message Sent .....");

}

Example For Browsing the message

package mdbaq;

import java.util.Enumeration;

import java.util.Hashtable;

import javax.naming.InitialContext;
import javax.jms.Queue;
import javax.jms.Session;
import javax.jms.Message;
import javax.jms.QueueSession;
import javax.jms.QueueBrowser;
import javax.jms.QueueConnection;
import javax.jms.QueueConnectionFactory;

import javax.jms.TextMessage;

import javax.naming.Context;

public class Browser
{
    public static void main(String[] args) throws Exception
    {
       // get the initial context
        Hashtable env = new Hashtable();
        // Standalone OC4J connection details
        env.put(Context.INITIAL_CONTEXT_FACTORY, "oracle.j2ee.rmi.RMIInitialContextFactory");
        env.put(Context.SECURITY_PRINCIPAL, "oc4jadmin");
        env.put(Context.SECURITY_CREDENTIALS, "welcome1");
        env.put(Context.PROVIDER_URL, "ormi://localhost:23791");
       InitialContext ctx = new InitialContext(env);
       // lookup the queue object
      // Queue queue = (Queue) ctx.lookup("jms/demoQueue");
       Queue queue = (Queue) ctx.lookup("java:comp/resource/TEST_AQ/Queues/MYQUEUE");
       // lookup the queue connection factory
       QueueConnectionFactory connFactory =
       //(QueueConnectionFactory) ctx.lookup("jms/qcf");
      // (QueueConnectionFactory) ctx.lookup("java:comp/resource/TEST_AQ/QueueConnectionFactories/QueueCF");
       (QueueConnectionFactory) ctx.lookup("java:comp/resource/TEST_AQ/QueueConnectionFactories/QueueCF");
       // create a queue connection
       QueueConnection queueConn = connFactory.createQueueConnection();
       // create a queue session
       QueueSession queueSession = queueConn.createQueueSession(false,
           Session.AUTO_ACKNOWLEDGE);
       // create a queue browser
       QueueBrowser queueBrowser = queueSession.createBrowser(queue);
       // start the connection
       queueConn.start();
       // browse the messages
       Enumeration e = queueBrowser.getEnumeration();
       int numMsgs = 0;
       // count number of messages
       while (e.hasMoreElements()) {
          Message message = (Message) e.nextElement();
         TextMessage msg = (TextMessage) message;
           System.out.println(msg.getText());
          numMsgs++;
       }
       System.out.println(queue + " has " + numMsgs + " messages");
       // close the queue connection
       queueConn.close();
    }
}

Run the Java program using the following option

java -classpath D:\MDB-AQ\classes;D:\temp2\jms.jar;D:\temp2\jta.jar;D:\temp2\pcl.jar;D:\temp2\aqapi13.jar;D:\temp2\ojdbc14.jar;D:\temp2\connector.jar;D:\temp2\jazncore.jar; D:\temp2\dms.jar;D:\temp2\bcel.jar;D:\temp2\mail.jar;D:\temp2\oc4j-internal.jar;D:\temp2\oc4jclient.jar;D:\temp2\adminclient.jar mdbaq.Browser

How to view AQ Queues via OC4J with the hermes tool

2009-02-13T00:48:00.001-08:00

For the OC4J memory based JMS queues you can use the link below.

Hermes Configuration for OC4J memory based JMS

This article explains how to view AQ based queues with hermes.

Set up your queues and AQ resource adapter etc using the following article.

http://rreddy.blogspot.com/2009/02/how-to-use-simple-mdb-with-oracle.html

From an OC4J install copy all these files to a temp directory

adminclient.jar
aqapi13.jar
bcel.jar
connector.jar
dms.jar
javax77.jar
jazncore.jar
jms.jar
jndi.jar
jta.jar
oc4j-internal.jar
oc4jclient.jar
ojdbc14.jar
optic.jar
pcl.jar

From the Hermes Tool create a classpath using the following ,

Create a session using the following entries

The important entries are

binding ==>> java:comp/resource/TEST_AQ/QueueConnectionFactories/QueueCF

This can be found from the file oc4j-ra.xml file \

<connector-factory location="TEST_AQ/QueueCF" connector-name="TEST_AQ">
<config-property name="jndiLocation" value="QueueConnectionFactories/QCF"/>

For the MDB we use the ConnectionFactory as TEST_AQ/QueueCF but for the hemes tool we need to use this as QueueConnectionFactories/QCF.

destination domain==> java:comp/resource/TEST_AQ/Queues/MYQUEUE For the MDB we use this as TEST_AQ/MyQueue/Queues/MYQUEUE but for the hermes tool we need use TEST_AQ/Queues/MYQUEUE.

After this send a message to the AQ using the script

DECLARE
enqueue_options dbms_aq.enqueue_options_t;
message_properties dbms_aq.message_properties_t;
message_handle RAW(16);
Message SYS.AQ$_JMS_TEXT_MESSAGE;
BEGIN
Message := Sys.Aq$_Jms_Text_Message.Construct;
Message.Set_Text(to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
dbms_aq.enqueue(queue_name => 'MYQUEUE',
enqueue_options => enqueue_options,
message_properties => message_properties,
payload => message,
msgid => message_handle);
COMMIT;
END;

How to Get the HTTP request and responses with OC4J/OAS

2009-02-04T23:31:00.001-08:00

For the Stand alone oc4j use the following

java -Doracle.oc4j.trace.finest=com.evermind.server.http -Dhttp.request.debug=true -jar oc4j.jar

09/02/05 12:58:22 FINE: EvermindHttpServletRequest.init GET /j2ee/test.jsp HTTP/1.1
Accept: image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-shockwave-flash, applicat
ion/vnd.ms-powerpoint, application/vnd.ms-excel, application/msword, application/xaml+xml, applicati
on/vnd.ms-xpsdocument, application/x-ms-xbap, application/x-ms-application, application/x-silverligh
t, */*
Accept-Language: en-us
UA-CPU: x86
Accept-Encoding: gzip, deflate
User-Agent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Mozilla/4.0 (compatible; MSIE 6.0; Wi
ndows NT 5.1; SV1) ; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; FDM; .NET CLR 3.0
.04506.648; .NET CLR 3.5.21022)
Host: indl224ad.idc.oracle.com:8888
Connection: Keep-Alive
Cookie: JSESSIONID=2009-02-05 12:58:22.734 NOTIFICATION J2EE JSP-0008 Unable to dispatch JSP Page : Exception:java.io.
FileNotFoundException: C:\oc4j10134\j2ee\home\default-web-app\j2ee\test.jsp (The system cannot find
the path specified)
09/02/05 12:58:22 FINEST: EvermindHttpServletResponse.commit *********** RESPONSE ************
09/02/05 12:58:22 FINEST: EvermindHttpServletResponse.commit HTTP/1.1 404 Not Found
Date: Thu, 05 Feb 2009 07:28:22 GMT
Server: Oracle Containers for J2EE
Connection: Keep-Alive
Keep-Alive: timeout=15, max=100
Content-Type: text/html; charset=UTF-8
Transfer-Encoding: chunked

09/02/05 12:58:22 FINEST: EvermindHttpServletResponse.commit *********** RESPONSE DONE ************

For the OAS add the following in the opmn.xml file

-Doracle.oc4j.trace.finest=com.evermind.server.http -Dajp.debug=true -Dhttp.request.debug=true

How to use mod_security module with HTTP Server to check the request and response headers

You can also use mod_security module to check the requests and responses.

Add the following at the end of the httpd.conf

On linux

LoadModule security_module libexec/mod_security.so

On Windows

LoadModule security_module modules/ApacheModuleSecurity.dll
AddModule mod_security.c

<IfModule mod_security.c>
    # Turn the filtering engine On or Off
     SecFilterEngine On
     # Make sure that URL encoding is valid
     SecFilterCheckURLEncoding On
     # Unicode encoding check
     SecFilterCheckUnicodeEncoding Off
     # Only allow bytes from this range
     SecFilterForceByteRange 0 255
     # Only log suspicious requests
     SecAuditEngine On
     # The name of the audit log file
     SecAuditLog logs/audit_log
     # Debug level set to a minimum
     SecFilterDebugLog logs/modsec_debug_log
     SecFilterDebugLevel 0
</IfModule>

and restart the HTTP Server.

Now check the audit_log file in $ORACLE_HOME/Apache/Apache/log directory.

========================================
UNIQUE_ID: Qw2LjJhFqD0AABvSLj8
Request: 152.69.168.191 - - [25/Aug/2005:14:42:57 +0530] "GET
/test_opencursor/Controller?recordID=2&counter=1 HTTP/1.1" 200 5
Handler: oc4j-handler
----------------------------------------
GET /test_opencursor/Controller?recordID=2&counter=1 HTTP/1.1
Accept: image/gif, image/x-xbitmap, image/jpeg, image/pjpeg,
application/x-shockwave-flash, application/vnd.ms-excel,
application/vnd.ms-powerpoint, application/msword, */*
Accept-Encoding: gzip, deflate
Accept-Language: en-us
Connection: keep-alive
Host: localhost
User-Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.1.4322)
Oracle-ECID: 1124961164:152.69.168.61:7122:0:1,0
HTTP/1.1 200 OK
Set-Cookie:
JSESSIONID=9845a83dce5dad8a271451048cb9a5fc0cb23f83960.e3uMb3eObheLe34SchaNaNu
Na41ynknvrkLOlQzNp65In0; Path=/test_opencursor
Cache-Control: private
Keep-Alive: timeout=15, max=100
Connection: Keep-Alive
Transfer-Encoding: chunked
Content-Type: application/octet-stream
========================================

This gives the request and response.

How to use a Simple MDB with Oracle Database provider in 10. 1.3

2009-02-03T02:34:00.001-08:00

1. Create the following entries in the data-sources.xml file

<managed-data-source connection-pool-name="AQ Connection Pool"
jndi-name="jdbc/aq"
name="AQ Connection Pool"/>
<connection-pool name="AQ Connection Pool">
<connection-factory
factory-class="oracle.jdbc.pool.OracleDataSource"
user="jmsuser" password="jmsuser"
url="jdbc:oracle:thin:@incq128ad:1521:ias1012"/>
</connection-pool>

2. Login to sql*plus and create the AQ objects

CONNECT system/manager;
DROP USER jmsuser CASCADE ;
GRANT CONNECT, RESOURCE,AQ_ADMINISTRATOR_ROLE TO jmsuser IDENTIFIED BY jmsuser ;
CONNECT jmsuser/jmsuser;
BEGIN
dbms_aqadm.create_queue_table ( queue_table=> 'TEST', queue_payload_type=> 'SYS.AQ$_JMS_TEXT_MESSAGE', sort_list=> '', comment=> '', multiple_consumers=> FALSE, message_grouping=> DBMS_AQADM.NONE, non_repudiation => DBMS_AQADM.NONE, storage_clause=> '', compatible=> '8.1', primary_instance=> '0', secondary_instance=> '0');
COMMIT;
END;
BEGIN
dbms_aqadm.create_queue(queue_name=> 'MYQUEUE', queue_table=> 'TEST', queue_type=> DBMS_AQADM.NORMAL_QUEUE, max_retries=> '5', retry_delay=> '0', retention_time=> '0', comment=> '');
COMMIT;
END;
BEGIN
dbms_aqadm.start_queue('JMSUSER.MYQUEUE', TRUE, TRUE);
COMMIT;
END;

3. Test whether the enqueing and dequing is working fine or not
Open a sqlplus window and login as jmsuser and run the following sql.

enque.sql
---------
DECLARE
enqueue_options dbms_aq.enqueue_options_t;
message_properties dbms_aq.message_properties_t;
message_handle RAW(16);
Message SYS.AQ$_JMS_TEXT_MESSAGE;
BEGIN
Message := Sys.Aq$_Jms_Text_Message.Construct;
Message.Set_Text(to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
dbms_aq.enqueue(queue_name => 'MYQUEUE',
enqueue_options => enqueue_options,
message_properties => message_properties,
payload => message,
msgid => message_handle);
COMMIT;
END;

Open another sqlplus window and login as jmsuser and run the following sql.

deque.sql
---------
set serveroutput on;
declare
deqopt dbms_aq.dequeue_options_t;
mprop dbms_aq.message_properties_t;
msgid RAW(16);
payload SYS.AQ$_JMS_TEXT_MESSAGE;
begin
deqopt.navigation := DBMS_AQ.FIRST_MESSAGE;
--deqopt.wait := 1;
dbms_aq.dequeue(
queue_name => 'MYQUEUE',
dequeue_options => deqopt,
message_properties => mprop,
payload => payload,
msgid => msgid );
commit;
dbms_output.put_line('The Message Sent to the Queue is: ' || payload.TEXT_VC);
end;

Now you should see the message in the sql*plus window as
The Message Sent to the Queue is: 13/03/2008 17:48:34
4. Start the oc4j container and access the EM Application Server Control
Go to the Administration TAB
Click on the Database Persistence link.

5. In this screen click on the deploy Button
Give the "Resource Adapter Module Name" as : TEST_AQ
And select the Radio Button
"Add a new resource provider to be used by this connector" Give the "Resource Provider Name" as TEST_AQ and
select the "Datasource JNDI Location" as jdbc/aq.

This will add the following values to the application.xml file

<resource-provider name="TEST_AQ" class="oracle.jms.OjmsContext">
<description></description>
<property name="datasource" value="jdbc/aq" />
</resource-provider>

Restart the oc4j container after this.

6. Now click on this Resource Adapter
and select the TAB
Connection Factory and select the QueueConnectionFactory
TEST_AQ/QueueCF
7. Now Click On "Administrated Objects" TAB and enter the following value

Choose the ObjectClass as oracle.j2ee.ra.jms.generic.AdminObjectQueueImpl
Give the JNDI Location as TEST_AQ/MyQueue and resourceProviderName as
TEST_AQ.

Software Requirements/Prerequisites

8. From the JDeveloper Create a Message driven and change the OnMessage Method

package mdbaq; import javax.ejb.EJBException; import javax.ejb.MessageDrivenBean; import javax.ejb.MessageDrivenContext; import javax.jms.JMSException; import javax.jms.Message; import javax.jms.MessageListener; import javax.jms.TextMessage; public class MessageDrivenEJBBean implements MessageDrivenBean, MessageListener { private MessageDrivenContext _context; public void ejbCreate() { } public void setMessageDrivenContext(MessageDrivenContext context) throws EJBException { _context = context; } public void ejbRemove() throws EJBException { } public void onMessage(Message message) { System.out.println("Received message: " + message); TextMessage msg = null; try { if (message instanceof TextMessage) { msg = (TextMessage) message; System.out.println("MESSAGE BEAN: Message received: " + msg.getText()); } else { System.out.println("Message of wrong type: " + message.getClass().getName()); } } catch (JMSException e) { e.printStackTrace(); } catch (Throwable te) { te.printStackTrace(); } } }

9. Open the ejb-jar.xml and have the following entries

<?xml version = '1.0' encoding = 'windows-1252'?> <ejb-jar xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/ejb-jar_2_1.xsd" version="2.1" xmlns="http://java.sun.com/xml/ns/j2ee"> <enterprise-beans> <message-driven> <description>Message Driven Bean</description> <display-name>MessageDrivenEJB</display-name> <ejb-name>MessageDrivenEJB</ejb-name> <ejb-class>mdbaq.MessageDrivenEJBBean</ejb-class> <messaging-type>javax.jms.MessageListener</messaging-type> <transaction-type>Container</transaction-type> <message-destination-type> javax.jms.Queue </message-destination-type> </message-driven> </enterprise-beans> <assembly-descriptor/> </ejb-jar>

Open the orion-ejb-jar.xml file

<?xml version = '1.0' encoding = 'windows-1252'?> <orion-ejb-jar xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="http://xmlns.oracle.com/oracleas/schema/orion-ejb-jar-10_0.xsd" schema-major-version="10" schema-minor-version="0"> <enterprise-beans> <message-driven-deployment name="MessageDrivenEJB" connection-factory-location="TEST_AQ/QueueCF" destination-location="TEST_AQ/MyQueue/Queues/MYQUEUE"/> </enterprise-beans> </orion-ejb-jar>

11. Create a simple Servlet to send the message to the Queue

package mdbaq;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.jms.* ;
import javax.jms.Queue;
import javax.naming.*;
import java.util.* ;
public class HelloWorld extends HttpServlet {
Queue queue;
QueueSession queueSession;
QueueSender queueSender;
Context jndiContext = null;
QueueConnectionFactory queueConnectionFactory = null;
QueueConnection queueConnection = null;
public void doGet(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException {
res.setContentType("text/html");
PrintWriter out = res.getWriter();
out.println("<HTML>");
out.println("<HEAD><TITLE>Hello MDB </TITLE></HEAD>");
out.println("<BODY>");
try {
TextMessage message = queueSession.createTextMessage();
message.setText(req.getParameter("subject"));
queueSender.send(message);
queueSession.commit();
} catch (JMSException e) { System.out.println("Exception occurred: " +e.toString());}
out.println("<H3> " + req.getParameter("subject") +" Message Sent .....</H3>");
out.println("</BODY></HTML>");
}
public void init(ServletConfig config) throws ServletException
{
super.init(config);
try {
jndiContext = new InitialContext();
queueConnectionFactory = (QueueConnectionFactory) jndiContext.lookup("CommonConnectionFactory");
queue = (Queue)jndiContext.lookup("TestQueue");
} catch (NamingException e)
{ System.out.println("Exception occurred: " + e.toString()); }
try {
queueConnection = queueConnectionFactory.createQueueConnection("jmsuser","jmsuser");
queueSession= queueConnection.createQueueSession(true,Session.AUTO_ACKNOWLEDGE);
queueSender = queueSession.createSender(queue);
queueConnection.start();
} catch (JMSException e) {System.out.println("Exception occurred: " + e.toString());}
}
}

12. The web.xml
Add the following entries to the web.xml file

<resource-ref> <res-ref-name>CommonConnectionFactory</res-ref-name> <res-type>javax.jms.QueueConnectionFactory</res-type> <res-auth>Container</res-auth> <res-sharing-scope>Shareable</res-sharing-scope> </resource-ref> <message-destination-ref> <description></description> <message-destination-ref-name>TestQueue</message-destination-ref-name> <message-destination-type>javax.jms.Queue</message-destination-type> <message-destination-usage>Produces</message-destination-usage> <message-destination-link>TestQueue</message-destination-link> </message-destination-ref> <welcome-file-list> <welcome-file>index.html</welcome-file> </welcome-file-list>

<?xml version="1.0"?> <orion-web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="http://xmlns.oracle.com/oracleas/schema/orion-web-10_0.xsd" deployment-version="10.1.3.3.0" deployment-time="1205407531953" jsp-cache-directory="./persistence" jsp-cache-tlds="standard" temporary-directory="./temp" servlet-webdir="/servlet/" context-root="/aq" schema-major-version="10" schema-minor-version="0" > <resource-ref-mapping location="TEST_AQ/QueueCF" name="CommonConnectionFactory"> </resource-ref-mapping> <message-destination-ref-mapping name="TestQueue" location="TEST_AQ/MyQueue/Queues/MYQUEUE" /> <web-app> </web-app> </orion-web-app>

14. Create a simple index.html to invoke the Servlet that sends the message to the AQ.

<html> <head> </head> <body> <form action="helloworld"> <b>Subject: </b><input type="text" name="subject"><br> <input type="submit" value="Log"> </form> </body> </html>

Configuring the Sample Code

use Jdeveloper to open the project

Running the Sample Code

Run the URL http://indl224ad.idc.oracle.com:8888/aq/helloworld?subject=test123

Sample Code Output

08/03/13 18:50:44 Received message: oracle.j2ee.ra.jms.generic.TextMessageWrapper@bb5e2d
08/03/13 18:50:44 MESSAGE BEAN: Message received: test123

Ravi Reddy Test Blog

2009-02-01T06:48:00.001-08:00

Ravi	Reddy
Test	123

Unix/Windows Scripts to Run a Task for "n" number of times

2009-01-20T20:59:00.000-08:00

Windows Script
test.bat
FOR /L %%G IN (1,1,20) DO (
echo Ruuning ---> %%G Time
java -jar admin_client.jar deployer:oc4j:opmn://cehpcb5.us.oracle.com:37005/IAM01 oc4jadmin manager1 -undeploy IAM
java -jar admin_client.jar deployer:oc4j:opmn://cehpcb5.us.oracle.com:37005/IAM01 oc4jadmin manager1 -deploy -file D:\bugs-download\Bug7252754\iam.ear -deploymentName IAM -bindAllWebApps
)

Unix Script

#!/bin/ksh
num=6
while [ $num -lt 20 ]
echo =========== Running for $num on `date` =============
do
opmnctl shutdown
opmnctl startall
opmnctl status
/refresh/jwc1013/product/jwc1013/jdk/bin/java -jar $ORACLE_HOME/j2ee/home/admin_client.jar deployer:oc4j:opmn://cehpcb5.us.oracle.com:35005/IAM oc4jadmin manager1 -undeploy IAM
/refresh/jwc1013/product/jwc1013/jdk/bin/java -jar $ORACLE_HOME/j2ee/home/admin_client.jar deployer:oc4j:opmn://cehpcb5.us.oracle.com:35005/IAM oc4jadmin manager1 -deploy -file $ORACLE_HOME/j2ee/home/iam2.ear -deploymentName IAM -bindAllWebApps
let num+=1
done

Script which runs a task 100 times and after every 5 iterations it will restart the oc4j conatiner.

#!/bin/ksh
num=0
while [ $num -lt 100 ]
do
echo =========== Running for $num on `date` =============
i1=$(expr $num % 5)
if [ $i1 -lt 1 ] ;
then
echo ======== Starting and Stopping OAS ===========
/home/ias/ias10131/opmn/bin/opmnctl shutdown
/home/ias/ias10131/opmn/bin/opmnctl startall
fi
/home/ias/ias10131/jdk/bin/java -jar $ORACLE_HOME/j2ee/home/admin_client.jar deployer:oc4j:opmn://ipbde.idc.oracle.com:6005/IAM oc4jadmin welcome1 -undeploy IAM
/home/ias/ias10131/jdk/bin/java -jar $ORACLE_HOME/j2ee/home/admin_client.jar deployer:oc4j:opmn://ipbde.idc.oracle.com:6005/IAM oc4jadmin welcome1 -deploy -file /home/ias/ias10131/iam.ear -deploymentName IAM -bindAllWebApps
let num+=1
done

Using jdb with OC4J

2009-01-15T04:29:00.001-08:00

I have a Customer who has an application which prints java.lang.NullPoinerException and no stack trace associated with this.
For example take this JSP Code (test.jsp)

<%@page import="java.util.*" %>
<%@page import="java.sql.*" %>
<%@page import="javax.sql.*" %>
<%@page import="javax.naming.*" %>
<%@page import="oracle.jdbc.pool.*" %>
<HTML>
<HEAD>
<TITLE>JSP Example</TITLE>
</HEAD>
<BODY BGCOLOR="#ffffcc">
<CENTER>
<%
try {
String p1=null;
out.println(p1.indexOf("123"));
}
catch (Exception e1)
{
System.out.println(e1.toString());
}
%>
</CENTER>
</BODY>
</HTML>

When you run this program this only prints 09/01/15 17:58:15 java.lang.NullPointerException
and you have no idea from where this exception is coming from.
You can use JDB to find out from where this exception is coming from
Run the OC4J with the following option
java -Xdebug -Xrunjdwp:transport=dt_socket,server=y,suspend=n,address=10444 -jar oc4j.jar

Now open another command prompt
run the jdb command with the following option
jdb -connect com.sun.jdi.SocketAttach:port=10444
At the jdb prompt enter the follwoing command
catch java.lang.NullPointerException
Now run your Application , when the NPE exception comes up the jdb displays the following info
Exception occurred: java.lang.NullPointerException (to be caught at: _t1._jspService(), line=58 bci=144)"thread=HTTPThreadGroup-8", _t1._jspService(), line=56 bci=135
HTTPThreadGroup-8[1]
Now type the command
where
to get the stack that is causing this problem
This will display the following stack
HTTPThreadGroup-8[1]HTTPThreadGroup-8[1] where [1] _t1._jspService (_t1.java:56) [2] com.orionserver.http.OrionHttpJspPage.service (OrionHttpJspPage.java:59) [3] oracle.jsp.runtimev2.JspPageTable.service (JspPageTable.java:462) [4] oracle.jsp.runtimev2.JspServlet.internalService (JspServlet.java:594) [5] oracle.jsp.runtimev2.JspServlet.service (JspServlet.java:518) [6] javax.servlet.http.HttpServlet.service (HttpServlet.java:856) [7] com.evermind.server.http.ServletRequestDispatcher.invoke (ServletRequestDispatcher.java:713) [8] com.evermind.server.http.ServletRequestDispatcher.forwardInternal (ServletRequestDispatcher.java:370) [9] com.evermind.server.http.HttpRequestHandler.doProcessRequest (HttpRequestHandler.java:871) [10] com.evermind.server.http.HttpRequestHandler.processRequest (HttpRequestHandler.java:453) [11] com.evermind.server.http.HttpRequestHandler.serveOneRequest (HttpRequestHandler.java:221) [12] com.evermind.server.http.HttpRequestHandler.run (HttpRequestHandler.java:122) [13] com.evermind.server.http.HttpRequestHandler.run (HttpRequestHandler.java:111) [14] oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run (ServerSocketReadHandler.java:260) [15] oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket (ServerSocketAcceptHandler.java:239) [16] oracle.oc4j.network.ServerSocketAcceptHandler.access$700 (ServerSocketAcceptHandler.java:34) [17] oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run (ServerSocketAcceptHandler.java:880) [18] com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run (ReleasableResourcePooledExecutor.java:303) [19] java.lang.Thread.run (Thread.java:595)HTTPThreadGroup-8[1]
Now we know that we got the exception from t1.jsp.

After this run the command
run to proceede further.

How to run a Simple JMX-Groovy Example with OC4J

2009-01-14T23:16:00.000-08:00

This note explains how to run a simple JMX script using the groovy scripting language.
Software Requirements/Prerequisites
Download groovy software from http://dist.groovy.codehaus.org/distributions/groovy-binary-1.5.6.zip
Extract this to a directory say D:\groovy-1.5.6
Configuring the Sample Code
Make sure following startup options are set when either starting the OC4J standalone or the Oracle Application Server:
com.sun.management.jmxremote
com.sun.management.jmxremote.port=9004
com.sun.management.jmxremote.authenticate=false
com.sun.management.jmxremote.ssl=false
If you are using OAS , then please set these parameters in the configuration file $ORACLE_HOME/opmn/config/opmn.xml, for example:
<category id="start-parameters">
<data id="java-options" value="-server -XX:MaxPermSize=128M -ms512M -mx1024M -XX:AppendRatio=3 -Djava.security.policy=$ORACLE_HOME/j2ee/home/config/java2.policy -Djava.awt.headless=true -Dhttp.webdir.enable=false -Dcom.sun.management.jmxremote -Dcom.sun.management.jmxremote.port=9004 -Dcom.sun.management.jmxremote.authenticate=false -Dcom.sun.management.jmxremote.ssl=false "/>

For OC4J standalone the startup command would look like:
java -Dcom.sun.management.jmxremote -Dcom.sun.management.jmxremote.port=9004 -Dcom.sun.management.jmxremote.authenticate=false -Dcom.sun.management.jmxremote.ssl=false -jar oc4j.jar
Running the Sample Code
Copy and Paste the sample code (see below) in a text file and save this file as say test.groovy

Set the following environment variables:
set ORACLE_HOME=c:\oc4j10133
set GROOVY_HOME=D:\groovy-1.5.6
set classpath=%GROOVY_HOME%\lib\commons-cli-1.0.jar;%GROOVY_HOME%\lib\groovy-1.5.6.jar;%ORACLE_HOME%\j2ee\home\admin_client.jar;%ORACLE_HOME%\j2ee\home\oc4jclient.jar;%GROOVY_HOME%\lib\asm-2.2.jar;%GROOVY_HOME%\lib\antlr-2.7.6.jar

Run the example using the command:
java -classpath %CLASSPATH% groovy.lang.GroovyShell test.groovy
Sample Code
import javax.management.remote.*
import oracle.oc4j.admin.jmx.remote.api.JMXConnectorConstant
import javax.management.remote.JMXConnectorFactory as JmxFactory
def serverUrl = new JMXServiceURL('service:jmx:rmi://localhost:23791')
def serverPath = 'oc4j:j2eeType=J2EEServer,name=standalone'
def jvmPath = 'oc4j:j2eeType=JVM,name=single,J2EEServer=standalone'
def provider = 'oracle.oc4j.admin.jmx.remote'
def credentials = [ (JMXConnectorConstant.CREDENTIALS_LOGIN_KEY): 'oc4jadmin'
, (JMXConnectorConstant.CREDENTIALS_PASSWORD_KEY): 'welcome1']
def env = [ (JMXConnectorFactory.PROTOCOL_PROVIDER_PACKAGES): provider
, (JMXConnector.CREDENTIALS): credentials ]
def server = JmxFactory.connect(serverUrl, env).mBeanServerConnection
def serverInfo = new GroovyMBean(server, serverPath)
def jvmInfo = new GroovyMBean(server, jvmPath)
println """Connected to $serverInfo.node. \
Server started ${new Date(serverInfo.startTime)}.
OC4J version: $serverInfo.serverVersion from $serverInfo.serverVendor
JVM version: $jvmInfo.javaVersion from $jvmInfo.javaVendor
Memory usage: $jvmInfo.freeMemory bytes free, \
$jvmInfo.totalMemory bytes total
"""
def query = new javax.management.ObjectName('oc4j:*')
String[] allNames = server.queryNames(query, null)
def dests = allNames.findAll{ name ->
name.contains('j2eeType=JMSDestinationResource')
}.collect{ new GroovyMBean(server, it) }
println "Found ${dests.size()} JMS destinations. Listing ..."
dests.each{ d -> println "$d.name: $d.location" }

Sample Code Output
This is the expected output from the above groovy script
Connected to localhost.idc.oracle.com. Server started Tue Jul 22 12:32:55 IST 2008.
OC4J version: 10.1.3.3.0 from Oracle Corp.
JVM version: 1.5.0_15 from Sun Microsystems Inc.
Memory usage: 3657056 bytes free, 20709376 bytes total
Found 8 JMS destinations. Listing ...
jms/queues/ErrorQueue: jms/queues/ErrorQueue
jms/PSSPBasicInfo: jms/PSSPBasicInfo
jms/myTopic: jms/myTopic
Demo Queue: jms/demoQueue
jms/queues/ReceiveQueue: jms/queues/ReceiveQueue
Demo Topic: jms/demoTopic
jms/Oc4jJmsExceptionQueue: jms/Oc4jJmsExceptionQueue
jms/RAExceptionQueue: jms/RAExceptionQueue

How to run a Simple JMX-Groovy Example with OC4J

2009-01-14T23:14:00.000-08:00

For OC4J standalone the startup command would look like:
java -Dcom.sun.management.jmxremote -Dcom.sun.management.jmxremote.port=9004 -Dcom.sun.management.jmxremote.authenticate=false -Dcom.sun.management.jmxremote.ssl=false -jar oc4j.jar
Running the Sample Code
Copy and Paste the sample code (see below) in a text file and save this file as say test.groovy
Set the following environment variables:
set ORACLE_HOME=c:\oc4j10133set GROOVY_HOME=D:\groovy-1.5.6set classpath=%GROOVY_HOME%\lib\commons-cli-1.0.jar;%GROOVY_HOME%\lib\groovy-1.5.6.jar;%ORACLE_HOME%\j2ee\home\admin_client.jar;%ORACLE_HOME%\j2ee\home\oc4jclient.jar;%GROOVY_HOME%\lib\asm-2.2.jar;%GROOVY_HOME%\lib\antlr-2.7.6.jar
Run the example using the command:
java -classpath %CLASSPATH% groovy.lang.GroovyShell test.groovy

Opatch for the Application Server

2008-12-18T21:21:00.000-08:00

1. Download this using the Patch Number 6880880
2. For AS 10.1.3 and 10.1.2 download the OPatch 10.1.0.X version.
For DB 10.1.X download Opatch 10.1.0.X version
For DB 10.2.X download Opatch 10.2.0.X version
For DB 11g download Opatch 11.0.X version.
3. After this run the command
unzip -d $ORACLE_HOME p6880880_101000_LINUX.zip
4. Now issue opatch lsinventory

For the customised Inventory location use the following /home/ias/infra101202/OPatch/opatch lsinventory -detail -invPtrLoc /etc/oraInst.loc

If you want to apply a patch meant for a different Platform use the command

export OPATCH_PLATFORM_ID=0 and then opatch apply

Update Redhat4 Linux System via yum with the local repository

2008-12-11T06:50:00.001-08:00

This small write up explains how to upgrade the RedHat linux system from one releaseto another one. For example you have RedHat linux 4 Update 2 installed and now youwant to update this to the latest one for example 7.
You can use the yum to do this on a local RPM repository.
1. Download the related rpm files
Set the http_proxy as we need to download some files from the internet.
export http_proxy=http://www-proxy.us.oracle.com/
wget wget http://iasbde.us.oracle.com/ohs_scripts/yum-2.0.7-1.noarch.rpm

2. Install these RPM's by using the command
rpm -ivh yum-2.0.7-1.noarch.rpm

3. Download the latest the RedHat linux version 4 from kernel.us.oracle.com
http://kernel.us.oracle.com/osinstall/RedHat/RHEL4/i386/AS/U7/RHEL4.7-i386-AS-DVD.iso
4. mount this ISO image
mount -o loop -t iso9660 RHEL4.7-i386-AS-DVD.iso /mnt/test

5. Copy all the RPM's to a local directory mkdir /home/localrpmscp /mnt/test/RedHat/RPMS/* /home/localrpms

6. Create the necessary header and other related files for the yum
cd /home/localrpms
yum-arch .

7. Open the /etc/yum.conf fileand change the entries of baseurl toi.e.from#baseurl=http://mirror.dulug.duke.edu/pub/yum-repository/redhat/updates/$releasever/tobaseurl=file:///home/RPMS
Modified yum.conf file
[main]cachedir=/var/cache/yumdebuglevel=2logfile=/var/log/yum.logpkgpolicy=newestdistroverpkg=redhat-releasetolerant=1exactarch=1
[base]name=Red Hat Linux $releasever - $basearch - Basebaseurl=file:///home/RPMS
[updates]name=Red Hat Linux $releasever - Updates#baseurl=http://mirror.dulug.duke.edu/pub/yum-repository/redhat/updates/$releasever/baseurl=file:///home/RPMS

8. yum update
Once the update is complete, you will need to reboot the system. It should automatically boot into the new kernel. If this does not happen, then you will need to update the /boot/grub/grub.conf file. The line 'default=0' means the first kernel listing. After yum completes, the new kernel should be the first listed.
If you have not installed previous iAS products, you will also want toperform the following so that all the packages needed are present.
# yum install gnome-libs
# yum install gnome-libs-devel
'yum update' or 'yum install ' to add additional or missing packages.

How to set a classpatch for all the .jar files in a directory

2008-10-16T02:13:00.001-07:00

On UNIX
C=.; for i in *.jar; do C=$C:$i; done
echo $C
java -cp $C org.jgroups.demos.Draw

On Windows