TechPages

Steps to install Oracle 10g Client for Redhat Linux

2010-03-09T09:13:00.003-08:00

Steps to install Oracle 10g Client for Redhat Linux

Oracle Database 10g Release 2 is certified to run the base release of RHEL4 (Advanced Server and Enterprise Server) without updates.

Verifying Your Installation

Required kernel version: 2.6.5-7.97 (or later)

Check your kernel version by running the following command: uname -r

Other required package versions (or later):

binutils-2.15.90.0.1.1-32.5
gcc-3.3.3-43.24
gcc-c++-3.3.3-43.24
glibc-2.3.3-98.28
gnome-libs-1.4.1.7-671.1
libstdc++-3.3.3-43.24
libstdc++-devel-3.3.3-43.24
make-3.80-184.1
pdksh-5.2.14-780.1
sysstat-5.0.1-35.1
xscreensaver-4.16-2.6
libaio-0.3.98

Run the following command as root:

rpm -q binutils gcc gcc-c++ glibc gnome-libs libstdc++ libstdc++-devel make \
pdksh sysstat xscreensaver libaio

Configuring Linux for Oracle

Now that the Linux software is installed, you need to configure it for Oracle. This section walks through the steps required to configure Linux for Oracle Database 10g Release 2.

System Requirements

To check the amount of RAM and swap space available, run this:

grep MemTotal /proc/meminfo
grep SwapTotal /proc/meminfo

The minimum RAM required is 1024MB, and the minimum required swap space is 1GB. Swap space should be twice the amount of RAM for systems with 2GB of RAM or less and between one and two times the amount of RAM for systems with more than 2GB.

You also need 2.5GB of available disk space for the Oracle Database 10g Release 2 software and another 1.2GB for the database. The /tmp directory needs at least 400MB of free space. To check the available disk space on your system, run the following command:

df -h

Create the Oracle Groups and User Account

Create the Linux groups and user account that will be used to install and maintain the Oracle Database 10g Release 2 software. The user account will be called oracle, and the groups will be oinstall and dba. Execute the following commands as root:

/usr/sbin/groupadd oinstall
/usr/sbin/groupadd dba
/usr/sbin/useradd -m -g oinstall -G dba oracle
id oracle

Set the password on the oracle account:

passwd oracle
Changing password for user oracle.
New password:
Retype new password:

passwd: all authentication tokens updated successfully.
Create Directories

Create directories to store the Oracle Database 10g software and the database files.

Directories would normally be created as separate filesystems. Issue the following commands as root:

mkdir -p /u01/app/oracle
chown -R oracle:oinstall /u01/app/oracle
chmod -R 775 /u01/app/oracle

Configuring the Linux Kernel Parameters

Linux allows modification of most kernel parameters while the system is up and running. There's no need to reboot the system after making kernel parameter changes. Oracle Database 10gRelease 2 requires the kernel parameter settings shown below.

kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=262144
net.core.wmem_default=262144
net.core.rmem_max=262144
net.core.wmem_max=262144
cat >> /etc/sysctl.conf <
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=262144
net.core.wmem_default=262144
net.core.rmem_max=262144
net.core.wmem_max=262144
EOF

# /sbin/sysctl -p

net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
net.ipv4.conf.default.accept_source_route = 0
kernel.sysrq = 0
kernel.core_uses_pid = 1
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 262144
net.core.wmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_max = 262144

Run the following commands as root to verify your settings:

/sbin/sysctl -a | grep shm
/sbin/sysctl -a | grep sem
/sbin/sysctl -a | grep file-max
/sbin/sysctl -a | grep ip_local_port_range
/sbin/sysctl -a | grep rmem_default
/sbin/sysctl -a | grep rmem_max
/sbin/sysctl -a | grep wmem_default
/sbin/sysctl -a | grep wmem_max

Setting Shell Limits for the oracle User

Oracle recommends setting limits on the number of processes and open files each Linux account may use. To make these changes, cut and paste the following commands as root:

cat >> /etc/security/limits.conf <
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
EOF

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

For RHEL4,use the following:

cat >> /etc/profile <
if [ \$USER = "oracle" ]; then
if [ \$SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
umask 022
fi
EOF

cat >> /etc/csh.login <
if ( \$USER == "oracle" ) then
limit maxproc 16384
limit descriptors 65536
umask 022
endif
EOF

Steps for Installing Oracle:

Oracle Database 10gRelease 2 can be downloaded from OTN. Use the graphical login to log in as oracle. Create a directory to contain the Oracle Database 10g Release 2 distribution:

mkdir 10gR2_db

To download Oracle Database 10g Release 2 from OTNHere

.Click on the 10201_database_linux32.zip link, and save the file in the directory you created for this purpose (10gR2_db),if you have not already logged in to OTN, you may be prompted to do so at this point.

Unzip and extract the file
cd 10gR2_db
unzip 10201_client_linux32.zip

Install the Software and Create a Database , Log in using the oracle account.

Change directory to the location where you extracted the Oracle Database 10g Release 2 software.

Ex:
$ cd $HOME/10gR2_db
Change directory to Disk1.
Ex:
$ cd database
Start the Oracle Universal Installer.
$ ./runInstaller

Select Installation Method

Oracle Home Location: /u01/app/oracle/product/10.2.0/db_1
Installation Type: Custom Installation – Select all package to install.
Global Database Name: Google
Click on Next

Specify Inventory Directory and Credentials

Inventory Directory: /u01/app/oracle/oraInventory
Operating System group name: oinstall
Click on Next

Summary

A summary of the products being installed is presented.
Click on Install.

Configuration Assistants

The Oracle Net, Oracle Database, and iSQL*Plus configuration assistants will run automatically

Execute Configuration Scripts

At the end of the installation, a pop up window will appear indicating scripts that need to be run as root. Login as root and run the indicated scripts.
Click on OK when finished.

Congratulations! Your new Oracle Database 10g Release 2 database is up and ready for use.

Steps to Access Server Database through Client

First step is to start lsnrctl listener for accessing server from the client. Start the server database before accessing from the client.

Starting and Stopping the Listener

The listener accepts connection requests from clients and creates connections to the database once the credentials have been authenticated. Before you can use OEM or iSQL*Plus, the listener must be up.

$ lsnrctl start
$ lsnrctl stop

Starting and Stopping the Database

The easiest way to start and stop the database is from the OEM Console. To do that from the command line, use SQL*Plus while logged in as oracle, as follows:

Startup:

$ sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on Sun Nov 27 15:39:27 2005
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter user-name: / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 285212672 bytes
Fixed Size 1218968 bytes
Variable Size 96470632 bytes
Database Buffers 180355072 bytes
Redo Buffers 7168000 bytes
Database mounted.
Database opened.
SQL> exit

Steps to Connect access Server through Client

/sqlplus username/password@//server_name:1521/database_name
You should be now presented with an SQL prompt where you can execute sql commands to your database:
SQL*Plus: Release 10.2.0.2.0 - Production on Tue Jul 18 15:21:53 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.

Steps to install Oracle 10g Server in Redhat Linux

2010-03-09T08:38:00.005-08:00

Steps to Install Oracle 10g Server in Redhat Linux

Oracle Database 10gRelease 2 is certified to run the base release of RHEL4

Required kernel version: 2.6.5-7.97 (or later)
Check your kernel version by running the following command: uname -r

Other required package versions (or later):

binutils-2.15.90.0.1.1-32.5
gcc-3.3.3-43.24
gcc-c++-3.3.3-43.24
glibc-2.3.3-98.28
gnome-libs-1.4.1.7-671.1
libstdc++-3.3.3-43.24 libstdc++-devel-3.3.3-43.24 make-3.80-184.1 pdksh-5.2.14-780.1 sysstat-5.0.1-35.1 xscreensaver-4.16-2.6
libaio-0.3.98

Run the following command as root

rpm -q binutils gcc gcc-c++ glibc gnome-libs libstdc++ libstdc++-devel make \ pdksh sysstat xscreensaver libaio

Configuring Linux for Oracle

Verifying System Requirements

To check the amount of RAM and swap space available, run this:

grep MemTotal /proc/meminfo
grep SwapTotal /proc/meminfo

df -h

Filesystem Size Used Avail Use% Mounted on /dev/sda3 6.8G 1.3G 5.2G 20% / /dev/sda1 99M 17M 77M 18% /boot

Create the Oracle Groups and User Account

    /usr/sbin/groupadd oinstall
    /usr/sbin/groupadd dba
    /usr/sbin/useradd -m -g oinstall -G dba oracle
    id oracle
Set the password on the oracle account:
       passwd oracle
Changing password for user oracle.
    New password:
    Retype new password:
    passwd: all authentication tokens updated successfully.

Create Directories

Now create directories to store the Oracle Database 10gRelease 2 software and the database files.

The following assumes that the directories are being created in the root filesystem. This is done for the sake of simplicity and is not recommended as a general practice.

These directories would normally be created as separate filesystems.

Issue the following commands as root:

    mkdir -p /u01/app/oracle
    chown -R oracle:oinstall /u01/app/oracle
    chmod -R 775 /u01/app/oracle

Configuring the Linux Kernel Parameters

The Linux kernel is a wonderful thing. Unlike most other *NIX systems, Linux allows modification of most kernel parameters while the system is up and running. There's no need to reboot the system after making kernel parameter changes.

    kernel.shmall = 2097152
    kernel.shmmax = 536870912
    kernel.shmmni = 4096
    kernel.sem = 250 32000 100 128
    fs.file-max = 65536
    net.ipv4.ip_local_port_range = 1024 65000
    net.core.rmem_default=262144
    net.core.wmem_default=262144
    net.core.rmem_max=262144
    net.core.wmem_max=262144

If you're following along and have just installed Linux, the kernel parameters will all be at their default values and you can just cut and paste the following commands while logged in as root.

    cat >> /etc/sysctl.conf <
    kernel.shmall = 2097152
    kernel.shmmax = 536870912
    kernel.shmmni = 4096
    kernel.sem = 250 32000 100 128
    fs.file-max = 65536
    net.ipv4.ip_local_port_range = 1024 65000
    net.core.rmem_default=262144
    net.core.wmem_default=262144
    net.core.rmem_max=262144
    net.core.wmem_max=262144
    EOF

# /sbin/sysctl -p
    net.ipv4.ip_forward = 0
    net.ipv4.conf.default.rp_filter = 1
    net.ipv4.conf.default.accept_source_route = 0
    kernel.sysrq = 0
    kernel.core_uses_pid = 1
    kernel.shmall = 2097152
    kernel.shmmax = 536870912
    kernel.shmmni = 4096
    kernel.sem = 250 32000 100 128
    fs.file-max = 65536
    net.ipv4.ip_local_port_range = 1024 65000
    net.core.rmem_default = 262144
    net.core.wmem_default = 262144
    net.core.rmem_max = 262144
    net.core.wmem_max = 262144
Run the following commands as root to verify your settings:
    /sbin/sysctl -a | grep shm
    /sbin/sysctl -a | grep sem
    /sbin/sysctl -a | grep file-max
    /sbin/sysctl -a | grep ip_local_port_range
    /sbin/sysctl -a | grep rmem_default
    /sbin/sysctl -a | grep rmem_max
    /sbin/sysctl -a | grep wmem_default
    /sbin/sysctl -a | grep wmem_max

Setting Shell Limits for the oracle User

Oracle recommends setting limits on the number of processes and open files each Linux account may use. To make these changes, cut and paste the following commands as root:

    cat >> /etc/security/limits.conf <
    oracle soft nproc 2047
    oracle hard nproc 16384
    oracle soft nofile 1024
    oracle hard nofile 65536
    EOF

    cat >> /etc/pam.d/login <
    session required /lib/security/pam_limits.so
    EOF
For RHEL4, use the following:
    cat >> /etc/profile <
    if [ \$USER = "oracle" ]; then
     if [ \$SHELL = "/bin/ksh" ]; then
     ulimit -p 16384
     ulimit -n 65536
     else
     ulimit -u 16384 -n 65536
     fi
     umask 022
    fi
    EOF

    cat >> /etc/csh.login <
    if ( \$USER == "oracle" ) then
    limit maxproc 16384
    limit descriptors 65536
    umask 022
    endif
    EOF

Steps for Installing Oracle:

Oracle Database 10g Release 2 can be downloaded from OTN. Oracle offers a development and testing license free of charge. However, no support is provided and the license does not permit production use. A full description of the license agreement is available on OTN.

The easiest way to make the Oracle Database 10g Release 2 distribution media available on your server is to download them directly to the server.

Use the graphical login to log in as oracle.

Create a directory to contain the Oracle Database 10g Release 2 distribution:

mkdir 10gR2_db

To download Oracle Database 10g Release 2 from Here

Fill out the Eligibility Export Restrictions page, and read the OTN License agreement. If you agree with the restrictions and the license agreement, click on I Accept.

Click on the 10201_database_linux32.zip link, and save the file in the directory you created for this purpose (10gR2_db),if you have not already logged in to OTN, you may be prompted to do so at this point.

Unzip and extract the file:

cd 10gR2_db
unzip 10201_database_linux32.zip

Install the Software and Create a Database , Log in using the oracle account.

Change directory to the location where you extracted the Oracle Database 10g Release 2 software.

Ex:
    $ cd $HOME/10gR2_db
Change directory to Disk1.
Ex:
    $ cd database
Start the Oracle Universal Installer.
    $ ./runInstaller

1.Select Installation Method

Select Basic Installation

Oracle Home Location: /u01/app/oracle/product/10.2.0/db_1

Installation Type: Enterprise Edition (1.3GB)

UNIX DBA Group: oinstall

Make sure Create Starter Database is checked

Global Database Name: demo1

Enter the Database Password and Confirm Password

Click on Next

Specify Inventory Directory and Credentials

Inventory Directory: /u01/app/oracle/oraInventory

Operating System group name: oinstall

Click on Next

Product-specific Prerequisite Checks

If you've been following the steps in this guide, all the checks should pass without difficulty. If one or more checks fail, correct the problem before proceeding.

Click on Next

Summary

A summary of the products being installed is presented.

Click on Install.

Configuration Assistants

The Oracle Net, Oracle Database, and iSQL*Plus configuration assistants will run automatically

Execute Configuration Scripts

At the end of the installation, a pop up window will appear indicating scripts that need to be run as root. Login as root and run the indicated scripts.

Click on OK when finished.

End of Installation

Make note of the URLs presented in the summary, and click on Exit when ready.

Congratulations! Your new Oracle Database 10g Release 2 database is up and ready for use.

Accessing the Database Using iSQL*Plus
iSQL*Plus is a Web-based version of the venerable SQL*Plus interactive tool for accessing databases. To use iSQL*Plus, click on the iSQL*Plus link in the Related Links section of the OEM console or point your browser to the iSQL*Plus URL provided during installation.

Ex:
http://ds1.orademo.org:5560/isqlplus (You may have to use the IP address instead of the host name if your database server not configured in your DNS.)

User Name: SYSTEM
Password:

Click on .

Enter SQL commands in the Workspace box, and click on Execute

Starting and Stopping iSQL*Plus:
$ isqlplusctl start
$ isqlplusctl stop
Starting and Stopping the Listener:

$ lsnrctl start
$ lsnrctl stop

Starting and Stopping the Database:

The easiest way to start and stop the database is from the OEM Console. To do that from the command line, use SQL*Plus while logged in as oracle, as follows:

Startup:

    $ sqlplus
    SQL*Plus: Release 10.2.0.1.0 - Production on Sun Nov 27 15:39:27 2005
    Copyright (c) 1982, 2005, Oracle. All rights reserved.
    Enter user-name: / as sysdba
    Connected to an idle instance.
    SQL> startup
    ORACLE instance started.
    Total System Global Area 285212672 bytes
    Fixed Size                  1218968 bytes
    Variable Size              96470632 bytes
    Database Buffers          180355072 bytes
    Redo Buffers                7168000 bytes
    Database mounted.
    Database opened.
SQL> exit
Shutdown:
$ sqlplus
    SQL*Plus: Release 10.2.0.1.0 - Production on Sun Nov 27 15:40:29 2005
    Copyright (c) 1982, 2005, Oracle. All rights reserved.
    Enter user-name: / as sysdba
    Connected to:
    Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
    With the Partitioning, OLAP and Data Mining options
SQL> shutdown immediate
    Database closed.
    Database dismounted.
    ORACLE instance shut down.
SQL> exit

Steps to install Oracle 9i in Redhat Linux

2010-03-09T06:10:00.000-08:00

Steps to Install Oracle 9i in Red hat Linux

Hardware and Software Requirements to install Oracle

Hardware Requirement

    CPU              PII or K6RAM
    RAM             512 MB
    HDD space   3.5 GB
    Swap space   1GB or RAMx2

Software Requirement

Oracle requires a minimal version of the kernel and JRE software:
    Parameter       Required        Sufficient (tested)
    ---------------------------------------------------
    Kernel 2.4.7                  later is fine
    JRE                 1.1.8v3              1.1.8v3

First of all before installing oracle in redhat check whether all development packages are installed by the following command

rpm -q gcc cpp compat-libstdc++ glibc-devel glibc-kernheaders binutils

Install the following RPM

su -root
rpm -ivh binutils-2.13.90.0.18-9.i386.rpm \
cpp-3.2.2-5.i386.rpm \
gcc-3.2.2-5.i386.rpm \
glibc-devel-2.3.2-5.i386.rpm \
glibc-kernelheaders-2.4-8.10.i386.rpm

Download oracle 9i Here

For Oracle9i (9.2.0) One step procedure (uses less disk space and is faster):

zcat lnx_920_disk1.cpio.gz | cpio -idmv
zcat lnx_920_disk2.cpio.gz | cpio -idmv
zcat lnx_920_disk3.cpio.gz | cpio -idmv

Now you should have 3 directories containing installation files

Disk 1

Disk 2

Disk 3

Setting Swap Space

In order to perform a typical Oracle 9i installation and to create a simple prototype database, Oracle says that you need a minimum of 512MB of RAM for the Oracle9i (9.0.1) Server, and the amount of disk space (swap space) should be equal to twice the amount of RAM or at least 400 MB, whichever is greater.

I tried to test the limits on an older PC with 256 MB of RAM and with 600 MB of swap space. I was able to install Oracle 9i (9.0.1 & 9.2.0) and Oracle's default database without any problems. But when I used less swap space on this PC (256MB RAM), I was runnig out of memory. So I definitely recommend to use more RAM and/or more swap space as specified in the Oracle installation guide.

NOTE: If you do not have enough swap space or RAM during the Oracle installation, in particular during the database creation, your Oracle server (Linux) will temporarily become unresponsive to any events for several minutes.

To check the memory, run:

grep MemTotal /proc/meminfo

To check the swap space, run:

cat /proc/swaps

You can also add temporary swap space by creating a temporary swap file instead of using a raw device. Here is the procedure:

su -root
dd if=/dev/zero of=tmpswap bs=1k count=900000
chmod 600 tmpswap
mkswap tmpswap
swapon tmpswap

To disable the temporary swap space execute the following commands:

su -root
swapoff tmpswap
rm tmpswap

Setting Shared Memory

For Oracle 9i (9.2.0) installation I had to increase the maximum shared memory size on my Linux server for all Red Hat versions. The Oracle Database Configuration Assistant displayed the following error message on my server:

ORA-27123 : unable to attach to shared memory segment

I temporarily increased the shmmax setting for the kernel by executing the following command:

$ su -root
# cat /proc/sys/kernel/shmmax
33554432
# echo ' expr 1024 \ * 1024 \ * 1024 ' > /proc/sys/kernel/shmmax
# cat /proc/sys/kernel/shmmax
1073741824

Checking /tmp Space

The Oracle Universal Installer requires up to 400 MB of free space in the /tmp directory.

To check the space in /tmp, run:

$ df /tmp

If you do not have enough space in the /tmp directory, you can temporarily create a tmp directory in another filesystem. Here is how you can do this:

su -root
mkdir / /tmp
chown root.root //tmp
chmod 1777 //tmp
export TEMP = / #used by Oracle
export TMPDIR = / # used by Linux Programs like the linker “ld”
When you are done with your Oracle installation, shutdown Oracle and remove the temporary directory:
su -root
rmdir /AnotherFilesystem>/tmp
unset TEMP
unset TMPDIR

Creating Oracle User Accounts

su – root
groupadd dba
groupadd oinstall
useradd -c “ Oracle Software Owner “ -g oinstall -G dba oracle
passwd oracle

Creating Oracle Directories

In this example, make sure that the /u01 filesystem is large enough. If /u01 is not on a separate filesystem, then make sure the root filesystem "/" has enough space.

su -root
mkdir -p /u01/app/oracle/product/9.2.0
chown -R oracle.oinstall /u01
mkdir /var/opt/oracle
chown oracle.dba /var/opt/oracle
chmod 755 /var/opt/oracle

Setting Oracle Environment

Set the following Oracle environment variable before you start runInstaller

As the Oracle user execute the following commands:

#set the LD_ASSUME_KERNEL environment variable only for Red Hat 9
export LD_ASSUME_KERNEL = 2.4.1 # for RH 9
# Oracle Environment
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/Product/9.2.0
export ORACLE_SID=test
export TNS_ADMIN=$ORACLE_HOME/network/admin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib:/usr/local/lib
export PATH=$ORACLE_HOME/bin

Starting runInstaller

Step 1: Allow “oracleserver” to display X information to your desktop

xhost +oracleserver

Step 2: Open a new window and login to the Oracle server "oracleserver" as root. This window will be used for mounting and unmounting the Oracle CDs.

oracleserver: $ su -root

oracleserver:root# mount /mnt/cdrom

Step 3: From the console of your Oracle server "oracleserver" where you will run runInstaller, execute the following commands:

oracleserver:$ su -oracle

oracleserver:oracle$ export DISPLAY = yourdesktop:0.0

Step 4: Now execute runInstaller as "oracle". Do not cd to /mnt/cdrom !!

oracleserver:oracle$ /mnt/cdrom/runInstaller

Startup and Shutdown of the Oracle 9i Database

sqlplus /nolog
connect / as sysdba
startup
shutdown immediate

To Start the Listener

cd $ORACLE_HOME/bin/lsncrtl start

The lsnrctl utility manages the Oracle listener processes. The Oracle listener process is required for database applications to access the database through SQL *Net or Net 8. lsnrctl requires entries in the listener.ora file that specify the port for that listener.

The listener.ora file is the configuration file for the network listener. It resides on the server and defines the network listener address, the SID for the database for which it listens, and other optional parameters for tracing and logging.

The following commands are used to manage the listener:

start : Starts the listener with the name specified, otherwise LISTENER will be used. For Windows systems, the listener can also be started and stopped from the Control Panel.

stop : Stops the listener. For Windows systems, the listener can also be started and stopped from the Control Panel.

status : Provides status information about the listener, including start date, uptime, and trace level.

services : Displays each service available, along with the connection history.

version : Displays the version information of the listener.

reload : Forces a read of the configuration file in order for new settings to take effect without stopping and starting the listener.

RRB Model Question Papers with Solved Answers

2010-03-09T05:33:00.000-08:00

RAILWAY RECRUITMENT BOARDS

MINISTRY OF RAILWAYS invites applications for the below post and filled application should be submitted on or before 17th March 2010 before 5.30 PM

1. commercial Apprentice

2. Traffic Apprentice

3. Enquiry cum Reservation Clerk

4. Goods Guard

5. Junior Accounts Assistant cum Typist

6. Sr. Clerk cum Typist

Find the collection of model question papers with Solved Answers

Model Question Paper 1

Model Question Paper 2

ModelQuestion Paper 3

Model Question Paper 4

Model Question Paper 5

Model Question Paper 6
Model Question Paper 7
Model Question Paper 8
Model Question Paper 9
Model Question Paper 10
Model Question Paper 11
For more information visitHere

Better Indexing for Blogger blog - Sitemap Problem

2010-03-08T06:22:00.000-08:00

Google indexing is more important for displaying your WebPages in Google search results. We can achieve that by submitting our sitemap to Google webmaster tool. Usually we will submit atom.xml or rss feeds as sitemap.

Like this

http://yourblogname.blogspot.com/atom.xml or

http://yourblogname.blogspot.com/feeds/posts/default

But above sitemap has some problems check below link, it will help you solve blogger blog sitemap problem. I tried the same for my blog and website it is working fine. Now Google is indexing more pages from my website.

Blogger blog indexing technique

Online Bill Payment - Pay Electricity, Phone, Insurance, Gas, Other bills Online

2010-03-08T05:59:00.000-08:00

Visa Bill Pay

Visa Bill Pay is FREE Online bill payment service. Visa Bill Pay is a simple, convenient and secure way to pay bills with your Visa credit/debit card.

It is a very simple way to pay electricity, phone, insurance, gas, and other bills online. Once you

Registered then you will receive reminders of your next bill.

http://www.visa.com/visabillpay/main.jsp

How to Connect Google Adsense to Google Analytics

2010-03-03T08:51:00.000-08:00

Google Webmasters and Google Analytics are very good tools from Google. Here we will see how to connect your adsense account with Google analytics. Below demo explains in detail.

Difference between Web Server and Application Server

2010-03-02T07:10:00.000-08:00

Web Server	Application Server
Web Server handles only http protocol.	Application server handles all protocols (ftp/tcp/ip) including http protocol.
Web Server mainly deals with request, response i.e. fetch static content from some location.	Application server handles request and response including business logic. Mainly for dynamic content. I.e. Application server = web server + EJBContainer.
Fetching HTML content, images, send a redirect, files which are physically present at the server location.	E.g. Servlet,JSP Applications ,EJB
Apache	Websphere, Tomcat Application server, BEA Web logic.

Java XML APIs

2010-03-01T07:37:00.000-08:00

XML files are most important for java project. So some interfaces are needed to access xml configuration files from java project. Here I listed some XML APIs which is used for java and xml communication. You can use below urls to get in-depth knowledge about java – xml communications. Below APIs will be useful for different scenarios I mean depend upon your requirements.

Below urls are explains the java xml API’s with example programs.

DOM (Document Object Model)

Dom Tutorial

Java XML Examples

Sax (Simple API for XML)

XML Beans

Java XPath API

Java Architecture for XML binding

Jaxb

How to rename your iPod

2010-03-01T03:27:00.000-08:00

1) Select the iPod on the left side of the iTunes window under devices
2) Click on the iPod's name under devices. The iPod's name would be highlighted.
3) Type your desired name and press Enter.

How to import CDs into iTunes

2010-03-01T03:13:00.000-08:00

How to find your iPod serial number

2010-03-01T03:07:00.000-08:00

You can find your iPod serial number in the following ways

On the back of iPod - inscribed on the back metal case towards the bottom
iPod About screen - Select Settings -> About or Settings -> General -> About
iTunes - Connect the iPod to the computer and select the iPod on the left side of the iTunes window under devices
On barcode label that is affixed in original iPod packaging
iPod's invoice or receipt

KFC Restaurant in Chennai

2010-03-01T01:56:00.000-08:00

KFC (Kentucky Fried Chicken) is a chain of food restaurant know for their fried chicken. It was founded by Colonel Harland Sanders in 1952 and stretches worldwide with more than 13,000 restaurants in more than 80 countries. KFC indian menus are burger, toasted chicken, zinger chicken, chicken bucket of variety buckets, hot wings, veg wings, krusher and desserts. Find the nearest KFC Restaurant Here

KFC Restaurant in Citi Centre
Chennai CitiCentre,
RK Salai, Chennai-600004
KFC Restaurant in Poonamallee High Road
AMPA Center One,
Unit # 1, Ground Floor,
#1, Nelson Manickam Road,
Ponamalee High Road Junction,
Chennai-29
KFC Restaurant in AnnaNagar
Second Avenue,
Anna Nagar,
Chennai-600040
KFC Restaurant in Numgambakkam
KFC, Swastik Complex 81,
Palimar Restaurants, Ground Flr & First Flr,
Nungambakkam High Road,
Chennai-600034
KFC Restaurant in Spencer Plaza
S-117, Planet Yumm Food court,
2nd floor, Spencer plaza phase 3,
769, Anna Salai,
Chennai – 600002

Spencer Plaza- Ph 1,
Chennai-600002

KFC Restaurant in Porur
Site # 1/445, Ground Floor,
Mount Poonamallee Road,
Chennai
KFC Restaurant in Adyar
Site # 21, Ground & First Floor,
3rd Cross Street,
Kasturibai Nagar, Adyar,
Chennai – 600020
KFC Restaurant in Taramani
Ascendas IT Park,
Taramani, Chennai -600113

Lucidor - An e-book Reader

2010-03-01T00:15:00.000-08:00

Lucidor is the application used for reading and handling e-books. It supports e-books in the EPUB file format, and catalogs in the OPDS format.It runs on the Windows, Linux and Mac OS platforms.

Other features include,

Convert web feeds into e-books
Search and download e-books from internet
Organize collection of e-books in local bookcase

Lucidor can be downloaded and installed from http://www.lucidor .org/lucidor/download.html

CAT Results 2010

2010-02-28T22:46:00.000-08:00

The Common Admission Test (CAT) is an all-India test conducted by the Indian Institutes of Management (IIMs) as an entrance exam for the management programmes of its seven business schools.

CAT result has been announced for the year 2010 Click here CAT 2010 Results
Get your Score Card Here and know what is the next step
Next Step Process after getting your score Card
After the test, by the second week of January next year, the IIMs declare exam scores and put up a list of candidates who are eligible for the next stage of a group discussion and an individual interview. The scores are relative and are calculated on a percentile basis for individual sections as well as for the total. Candidates invited for the next stage usually possess total scores that are in excess of 99 percentile and, more importantly, also possess balanced high scores across all the individual sections.

Facebook's News Feed Patent

2010-02-28T21:09:00.000-08:00

Facebook was awarded a major patent for “Dynamically providing a news feed about a user of a social network”.

On2 VP7 Codec Free Download

2010-02-28T20:52:00.000-08:00

Achieve high quality video at low data rates as low as 20kbps, and play back 720p HD on 1.5GHz Pentium M and 1080p HD on 2.5GHz Pentium M. The Codecs have gained wide adoption in major applications like Adobe's Flash Player, Skype, Viewpoint Media Player, AIM Triton, The Sims 2 from Electronic Arts, and the Move Networks media player

Important features include

Golden Frames
Packet loss recovery
Video conferencing
Golden quality
Real Time quality
Leave real enough alone
Decoder complexity
Simplified entropy logic
Flexible decode implementation

Click here to download: On2 VP7 Download

Lenevo's IdeaPad S10-3t - A Netbook-Tablet Hybrid

2010-02-28T20:28:00.000-08:00

The IdeaPad is a notebook computer that combines the features of the tablet computer. Some of the interesting tablet features are

Rotating touch-screen - Turn into a tablet to its basic netbook functionality
10.1 inch touch-screen
Zoom in and out of text, photos by pinching and widening the fingers
The netbook has a built-in camera, two USB ports, runs Windows 7 and has a four-hour battery life
Application Quick Notes allows you to take hand drawn notes on a virtual note pad, incorporating different colors and video and organizing them according to date

Hands On Video:

Karthik Calling Karthik Movie Trailer

2010-02-28T19:58:00.000-08:00

Lunascape Free Download

2010-02-27T22:43:00.000-08:00

Lunascape is a new Web browser with 3 renders. It can perform like IE, Firefox or Safari according to your requirements.

This browser’s most innovative feature is the ability to switch rendering engines on the fly. Yes Lets users switch among Trident (behind Internet Explorer), Gecko (behind Firefox) and Web Kit (behind Google Chrome and Safari) -- on the fly. Browser Skins also you can easily change to your wish. So all major browsers rolled into one.

Download Lunascape

How to Create jar file Using Eclipse-- Failed to load Main-Class manifest attribute from jar File

2010-02-24T06:40:00.000-08:00

Here we will see how to create jar file from eclipse. And we will see how to solve
Main-Class manifest attribute from jar File problem. Following steps you need

to follow to create jar file using eclipse java IDE.

Method 1: Jar files creation using eclipse.

Step 1:

Right click on configured java project (select java project)

Step 2:

Right Click Export.

Step 3:

Click java and select jar file.

Step 4:

Click next and choose the project (from select the resources to export).

Step 5:

Give the jar file name from (select the export destination) and click next.

Step 6:

Select the Main class à Click Finish.

Method 2:

Below link help you create jar file using command mode.

Create jar file using command mode

How to redirect the Shell Program output to file and Screen in Unix

2010-02-24T02:31:00.000-08:00

Tee Unix Command to redirect the shell output to file and Screen

The tee utility will copy standard input to standard output, making a copy in zero or more files.
For more information "man tee"
Sample
#!/bin/sh
test="welcome to the world of linux"
echo $test | test Sample.txt // Here output will be redirected to Screen and Sample.txt
Enroll your comments if you find it is useful.

Summary of Unix VI Commands

2010-02-22T21:43:00.000-08:00

VI Editor is one of the most powerful Screen-Oriented editor in Unix OS. VI Commands to do basic operations

Operations
i for "insert"
a for "append"
c for "change"
d for "delete"
p for "put"
y for "yank,"
Command to Save and Abandon Changes
                                      save changes   abandonchanges
Exit                                :wq                    :q!
Do not exit                     :w                       :e!
Forcing changes
                                      saving changes
Exit                                :wq!
Do not exit                      :w!
Cursor Movement
h -->left, one space.
j -->down, one line.
k -->up, one line.
l-->right, one space.
0-->Move to beginning of line.
$-->Move to end of line
0 -> Beginning of the file
$ -> End of file
The w or W command moves the cursor forward one word at a time
2w moves forward two words
Move backward by word, use the b or B command
5B moves back five words
Editing Text
cc -- to change the entire line
cw - to the end of a word
c2b - back two words.
c$ - to the end of line.
c0- to the beginning of line.
r - replace a single character
dw - delete a word
. -> it is used to repeat the same operation, what you are doing
u -> undo
U -> undo all the changes in a single line
A ->Append text to end of current line.
I ->Insert text at beginning of line.
o ->Open blank line below cursor for text.
O-> Open blank line above cursor for text.
s-> Delete character at cursor and substitute text.
S-> Delete line and substitute text.
R-> Overstrike existing characters with new characters
J ->joins the line the cursor is on with the line below.
p or P -> Place text from buffer
Scrolling the Screen
ctrl + F Scroll forward one screen.
ctrl +B Scroll backward one screen.
ctrl + D Scroll forward half screen (down).
ctrl +U Scroll backward half screen (up).
Movement Within a Screen
H -- Move to home - top line on screen.
M -- Move to middle line on screen.
L -- Move to last line on screen.
nH --Move to n lines below top line.
nL--Move to n lines above last line.
Movement by Text Blocks
e -- Move to end of word.
E -- Move to end of word (ignore punctuation).
( -- Move to beginning of current sentence.
) -- Move to beginning of next sentence.
{ -- Move to beginning of current paragraph.
} -- Move to beginning of next paragraph.
[[ --Move to beginning of current section.
]]--Move to beginning of next section.
Movement by Searches
/Pattern --> search for the pattern in unix
?Pattern --> to search the pattern in backward
n --> to search the next occurence of the pattern search
N --> Repeat search for the pattern in Opposite direction.
Recover VI file
Use the -r option with a file name to recover the edited buffer.
For example, to recover the edited buffer of the file practice after a system crash, enter:
$ vi -r practice
Display Line Number
set nu or set number --> to display line number
set nonumber --> to hide or clear line number

Unix Commands to lookup system information

2010-02-22T20:13:00.000-08:00

Unix Commands to look for system Information

uname -a : display system information such as Name and Version of OS, machine identification number and Licensed level of OS.
ifconfig -a : display ipaddress and ethernet card information for Solaris and Linux OS
nslookup -all : display ipaddress and port information set for HPUX OS
Who: Display information about the list of user logged on and their login time.
Last: List of all logged in users
Free: Display free and used memory.
finger: Display information about the list of user logged on and their name and their login time

Wget - Command line downloader in Linux OS

2010-02-22T09:42:00.000-08:00

Wget is a free utility for non-interactive download of files from the Web. It supports HTTP, HTTPS, and FTP protocols, as well as retrieval through HTTP proxies.

It is one of the fastest mode of downloading files in linux operating system.

Syntax: wget URL

Download OpenOffice for linux through command mode

wget http://download.services.openoffice.org/files/stable/3.2.0/OOo_3.2.0_LinuxIntel_install_wJRE_en-US.tar.gz

Download in Background

wget -b http://download.services.openoffice.org/files/stable/3.2.0/OOo_3.2.0_LinuxIntel_install_wJRE_en-US.tar.gz