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
Sunday, July 31, 2011
Install VmWare ESXI Server from USB
1) Format the US Drive with fat32.
2) Get Syslinux, not the version 4, but an older version. Use 3.86 from http://www.kernel.org/pub/linux/utils/boot/syslinux/3.xx/
Version 4 can give you an error on boot, "invalid c32 image".
3) Run syslinux: syslinux.exe -m -f -a G: (G: being the drive letter).
4) Get the ESXi iso, VMware-VMvisor-Installer-4.1.0.update1-348481.x86_64.iso
5) Extract the iso, using the 7-Zip and copy contents to usb drive
6) Rename isolinux.cfg to syslinux.cfg
7) Modify the syslinux.cfg, add "ks=usb" after vmkboot.gz
For example ,
append vmkboot.gz ks=usb --- vmkernel.gz --- sys.vgz --- cim.vgz --- ienviron.vgz --- install.vgz
8) Create the ks.cfg file in the USB root directory with the following contents
vmaccepteula
rootpw Welcome1
autopart --firstdisk --overwritevmfs
install usb
network --bootproto=dhcp --device=vmnic0
9) Boot it from the USB and install the ESXi software
Sunday, July 24, 2011
Installing VMware ESXi on a USB Memory Stick
1.The first thing you’ll need is a spare USB memory stick. I used 1 8GB USB drive for this. But 4GB or 2GB is also sufficient for this.
2. The next step is to download ESXi from VMware here and burn if off onto CD.
3. Now insert the USB memory stick into a USB port which is able to be booted.
Though at this stage make sure that your server can boot from the CD/DVD drive.
4. Insert the CD containing the ESXi install into the servers CD/DVD drive and boot or restart the server.
Choose the default options.
5. At this stage you will see a list of all your storage devices connected to your VMware ESXi host – select your USB memory stick and press 'Enter'
6. Wait while the ESXi is written down to your USB flash drive – at this point you should see it flashing away
7. Once the installation has completed you will receive the screen below. At this point remove the ESXi installation CD from the servers CD/DVD drive and press ‘Enter’ to reboot the server.
IMPORTANT: Upon the server rebooting ensure that its boot priority order is set so that the USB port(s) are booted from first.
Your server should now be booting successfully off of the USB memory stick to VMware ESXi 4 – all you need to do now is configure it!
After this you have to create a VMFS file system that can be used as a data store ,
For this you need to create a VMFS file system. First run the command ,
fdisk -l
Disk /dev/disks/t10.ATA_____WDC_WD10EARS2D00Y5B1__________________________WD2DWCAV5H240740: 1000.2 GB, 1000204886016 bytes
255 heads, 63 sectors/track, 121601 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Device Boot Start End Blocks Id System
/dev/disks/t10.ATA_____WDC_WD10EARS2D00Y5B1__________________________WD2DWCAV5H240740p1 * 1 13 102400 7 HPFS/NTFS
Partition 1 does not end on cylinder boundary
/dev/disks/t10.ATA_____WDC_WD10EARS2D00Y5B1__________________________WD2DWCAV5H240740p2 13 19123 153497600 7 HPFS/NTFS
/dev/disks/t10.ATA_____WDC_WD10EARS2D00Y5B1__________________________WD2DWCAV5H240740p3 19123 31871 102400000 7 HPFS/NTFS
...
/dev/disks/t10.ATA_____WDC_WD10EARS2D00Y5B1__________________________WD2DWCAV5H240740p8 39573 51731 97659146 83 Linux
And run the command
fdisk /dev/disks/t10.ATA_____WDC_WD10EARS2D00Y5B1__________________________WD2DWCAV5H240740
and create a partion , and specify the format type as "fb". This is for the VMFS file system.
In the fdisk , type "t". It will ask you for partition number. This is where that first fdisk is useful. You need to know what the new partition number is.
It will be one more than the last number on fdisk. Type this number in
You will now be prompted for the hex code for the partition type. You can also type "L" for a list of codes. The code you want is "fb". So type "fb" in the space. This will return that the partition has been changed to fb (unknown).
Now run the command to create the VMFS file system ,
vmkfstools -C vmfs3 -S storage1 /vmfs/devices/disks/vml.0100000000202020202057442d574341563548323430373430574443205744:9
Checking if remote hosts are using this device as a valid file system. This may take a few seconds...
Creating vmfs3 file system on "t10.ATA_____WDC_WD10EARS2D00Y5B1__________________________WD2DWCAV5H240740:9" with blockSize 1048576 and volume label "storage1".
Successfully created new volume: 4e2c8868-54253438-de36-001aa0c2472f
If you do not specify the VMFS file system , while creating the vmfs file system you may get the error as ,
vmkfstools -C vmfs3 -S storage1 /vmfs/devices/disks/vml.0100000000202020202057442d574341563548323430373430574443205744:9
Checking if remote hosts are using this device as a valid file system. This may take a few seconds...
Creating vmfs3 file system on "t10.ATA_____WDC_WD10EARS2D00Y5B1__________________________WD2DWCAV5H240740:9" with blockSize 1048576 and volume label "storage1".vmkfstools -C vmfs3 -S storage1 /vmfs/devices/disks/vml.0100000000202020202057442d574341563548323430373430574443205744:9
/vmfs/devices/disks/vml.0100000000202020202057442d574341563548323430373430574443205744:9: Permission denied. (Have you set the partition type to 0xfb?)
Error: Permission denied
Now in the VMWare VSphere Client you can see the datastore.
Thursday, July 21, 2011
Sending SMS to Multiple People
Sending SMS to Multiple People
I used the following code available at
https://sourceforge.net/projects/servalivecheck/
I have a file say sms.txt with the following entries I want to send an SMS to all the people in this file.
Sms.lst has the following entries
Ravi,9198808XXXXX
Naveen,919663XXXXX
In Unix create an shell script with the following entries
cat dd.sh
#!/bin/bash
for x in `awk -F',' '{ print $2 }' sms.lst`
do
/home/ias/Oracle/Middleware/jdk160_18/bin/java -cp /home/ias/JavaUtils Sms160By2 $x "\" We are playing Cricket on this Saturday "\"
Done
On Windows run the following batch file ,
for /F "tokens=2* delims=," %i in (sms.lst) do java -cp . Sms160By2 %i "We are playing Cricket on this Saturday"
This sends the SMS to all the people in the group.
Tuesday, July 12, 2011
Yum Configuration With OEL
Refer to the URL , http://public-yum.oracle.com/ for more details on this.
1.Download and Install Oracle Linux
2. Download and copy the appropriate yum configuration file in place, by running the following commands as root:
Oracle Linux 5
# cd /etc/yum.repos.d
# wget http://public-yum.oracle.com/public-yum-el5.repo
Enable the appropriate repository by editing the yum configuration file
Open the yum configuration file in a text editor
Locate the section in the file for the repository you plan to update from, e.g. [el4_u6_base]
Change enabled=0 to enabled=1
Begin using yum, for example:
yum list
yum install firefox
After this install the oracle-validated package this will install the necessary packages and sets the kernel parameters
and also creates oracle user etc.
yum install oracle-validated
Sunday, July 10, 2011
Parsing Railway’s PNR Data (JSON Parsing)
Here I am using a Service from the following URL ,
http://pnrapi.appspot.com/<pnr-number>
for example ,
http://pnrapi.appspot.com/1416780219
This gives the data in the following format ,
{'status': 'OK', 'data': {'passenger': [{'status': 'G3 , 45', 'seat_number': 'W/L 15,CK'}],
'from': 'SC', 'alight': 'YPR', 'pnr_number': '1416780219', 'train_number': '*12735',
'to': 'YPR', 'board': 'SC', 'train_name': 'YPR GARIB RATH',
'travel_date': {'date': '26-6-2011', 'timestamp': 1309046400}, 'class': '3A'}}
you need to have the following jar files in the classpath ,
D:\fmw1114\Middleware\jdk160_21\bin\javaw.exe -client -classpath C:\JDeveloper\mywork\Application5\Project1\classes;D:\commons-httpclient-3.1\commons-io-2.0.1.jar;D:\commons-httpclient-3.1\json-lib-2.4-jdk15.jar;D:\commons-httpclient-3.1\commons-httpclient-3.1.jar;D:\commons-httpclient-3.1\commons-lang-2.6.jar;D:\commons-httpclient-3.1\commons-logging-1.1.1.jar;D:\commons-httpclient-3.1\commons-logging-adapters-1.1.1.jar;D:\commons-httpclient-3.1\commons-logging-api-1.1.1.jar;D:\commons-httpclient-3.1\commons-logging-tests.jar;D:\commons-httpclient-3.1\ezmorph-1.0.6.jar;D:\commons-httpclient-3.1\commons-collections-3.2.1.jar;D:\commons-httpclient-3.1\commons-beanutils-1.8.3.jar;D:\commons-httpclient-3.1\commons-beanutils-bean-collections-1.8.3.jar;D:\commons-httpclient-3.1\commons-beanutils-core-1.8.3.jar project1.ParsePNR
package project1;
import java.io.BufferedReader;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.net.URL;
import net.sf.json.JSONArray;
import net.sf.json.JSONObject;
import net.sf.json.JSONSerializer;
import org.apache.commons.io.IOUtils;
public class ParsePNR {
public ParsePNR() {
super();
}
public static void main(String[] args) throws Exception {
// InputStream is =
// ParsingJSON.class.getResourceAsStream( "c:\\sample-json.txt");
// String jsonTxt = IOUtils.toString( is );
/*
String test = "\"status\" : \"OK\",\n" +
"\"data\" : { \n" +
" \"train_name\" : \"ERNAKULAM EXP\",\n" +
" \"train_number\" : \"*12677\",\n" +
" \"from\" : \"SBC\",\n" +
" \"to\" : \"CBE\",\n" +
" \"alight\" : \"CBE\",\n" +
" \"board\" : \"SBC\",\n" +
" \"class\" : \"2S\",\n" +
" \"travel_date\" : \"2- 6-2011\"\n" +
" \"passenger\" : [ { \"seat_number\" : \"D8 , 31,GN\", \"status\" : \"CNF\" },\n" +
" { \"seat_number\" : \"D8 , 32,GN\", \"status\" : \"CNF\" } ]\n" +
" }";
// Sample Data (1 passenger)
{'status': 'OK', 'data': {'passenger': [{'status': 'G3 , 45', 'seat_number': 'W/L 15,CK'}], 'from': 'SC', 'alight': 'YPR', 'pnr_number': '1416780219', 'train_number': '*12735', 'to': 'YPR', 'board': 'SC', 'train_name': 'YPR GARIB RATH', 'travel_date': {'date': '26-6-2011', 'timestamp': 1309046400}, 'class': '3A'}}
// Sample Data (2 passenger)
{'status': 'OK', 'data': {'passenger': [{'status': 'G3 , 45', 'seat_number': 'W/L 15,CK'},{'status': 'G3 , 46', 'seat_number': 'W/L 16,CK'}], 'from': 'SC', 'alight': 'YPR', 'pnr_number': '1416780219', 'train_number': '*12735', 'to': 'YPR', 'board': 'SC', 'train_name': 'YPR GARIB RATH', 'travel_date': {'date': '26-6-2011', 'timestamp': 1309046400}, 'class': '3A'}}
Replace the class with class1 as class is a reserved word in java.
*/
String pnr="";
if (args.length == 0 )
pnr = "1416780219";
else
pnr = args[0];
System.setProperty("http.proxyHost", "www-proxy.us.oracle.com");
System.setProperty("http.proxyPort", "80");
System.setProperty("http.nonProxyHosts","*.us.oracle.com|*.oraclecorp.com|*.idc.oracle.com|*.uk.oracle.com|localhost");
URL url = new URL("http://pnrapi.appspot.com/"+pnr);
// Read all the text returned by the server
BufferedReader in = new BufferedReader(new InputStreamReader(url.openStream()));
String str="";
String line;
while ((line = in.readLine()) != null) {
// str is one line of text; readLine() strips the newline character(s)
str= str.concat(line );
// System.out.println(line);
System.out.println(str);
}
in.close();
str= str.replace("'class':","'class1':");
/*String jsonTxt ="{'status': 'OK', 'data': {'passenger': [{'status': 'G3 , 45', 'seat_number': 'W/L 15,CK'},{'status': 'G3 , 46', 'seat_number': 'W/L 16,CK'}], " +
"'from': 'SC', 'alight': 'YPR', 'pnr_number': '1416780219', " +
"'train_number': '*12735', 'to': 'YPR', 'board': 'SC', " +
"'train_name': 'YPR GARIB RATH', 'travel_date': {'date': '26-6-2011', 'timestamp': 1309046400}, " +
"'class1': '3A'}}"; */
String jsonTxt = str;
JSONObject json = (JSONObject) JSONSerializer.toJSON( jsonTxt );
String status = json.getString( "status" );
if (status.compareToIgnoreCase("INVALID") == 0) {
System.out.println("Status is "+status);
System.exit(0);
}
JSONObject data = json.getJSONObject("data");
String train_name = data.getString("train_name");
String train_number = data.getString("train_number");
String class_d = data.getString("class1");
String from = data.getString("from");
String alight = data.getString("alight");
JSONObject travel_date = data.getJSONObject("travel_date");
String date = travel_date.getString("date");
System.out.printf( "status: %s\n", status );
System.out.printf( "Train number : %s Tain Name : %s \n", train_number, train_name );
System.out.printf( "From : %s To : %s Date Of Travel : %s Class : %s\n", from, alight , date , class_d );
JSONArray passenger = data.getJSONArray("passenger");
int i1=0;
for (Object o : passenger) {
i1++;
JSONObject passengerDetails = (JSONObject) o;
String status_p = passengerDetails.getString("status");
String seat_number = passengerDetails.getString("seat_number");
System.out.printf( "Passenger : %d Current Status : %s Previous Staus : %s\n", i1, status_p, seat_number );
}
}
}
Wednesday, July 06, 2011
How to start the vncserver automatically
Open the file
vi .vnc/xstartup
and add the line
exec gnome-session &
and remove the line that starts with "twm"
chkconfig --level 3 vncserver on
chkconfig --level 5 vncserver on
Add the following line in /etc/sysconfig/vncservers
VNCSERVERS="1:root"
service vncserver start
Tuesday, July 05, 2011
XE On Linux
Oracle is installed to: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle
To start XE
/etc/init.d/oracle-xe start
To stop XE
/etc/init.d/oracle-xe stop
export PATH=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin:$PATH
export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
export ORACLE_SID=XE
sqlplus "/ as sysdba"
If you want to use Oracle XE as your database, you have to set the RCU_JDBC_TRIM_BLOCKS environment variable to TRUE *prior* to running RCU. As a reminder as to support level, when running RCU against XE you will receive a warning stating that the database version is not supported by Oracle.
Subscribe to:
Posts (Atom)