Hearty welcome my Friends !!!!!

Welcome to the world of Oracle !
i hope this site may help to improve your Oracle skills !
@@@@@ Happy New Year @@@@@

Neeli's photo

The Future of world Oracle @

The Future of world Oracle @

The Oracle Apps Dba @ Neeli's Web Site is an effort to make available information and services to improve the skills of Oracle DBA and Applications DBA. This site is dedicated to providing DBA related information concerning Oracle and Oracle Applications databases.
We try to make available topics related to installations, upgrades, and general database management. This site contains Installation notes , SQL scripts, DBA utilities and general tips that have been created supporting real world Oracle and Oracle Applications environments.

Email Id : NeeliRaghava@gmail.com

How to Install 10g Database on Oracle Enterprise Linux
Oracle 10g Database Creation steps :
Quick Installation Guide Used 10g Release 2 (10.2) for Linux x86
First check for the installation guide from the Oracle web site www.otn.oracle.com

Now download the latest version of the Quick installation guide.
Note: it is according to the processor compatibility
ie., 32 bit or 64 bit.

• Get the Oracle 10g software from www.metalink.oracle.com or www.otn.oracle.com  

• See whether the software is Certified by Oracle Corporation.

Download the software which contains 2 zip files
give the location for download.
Checking the Hardware Requirements

• The system must meet the following minimum hardware requirements:

• At least 1024 MB of physical RAM

• The following table shows the relationship between the available RAM and the required Swap space.

• The Swap Size to be double the RAM or equal to the RAM ,

400 MB of disk space in the /tmp directory

• To ensure that the system meets these requirements, follow these steps:

To determine the physical RAM size, enter the following command:

     grep MemTotal /proc/meminfo
 

Checking for software requirements
operating systems : Red Hat Enterprise Linux 4.0
Kernel Version : 2.6.9-5.EL

Ø    Packages to be installed
 

binutils-2.15.92.0.2-13.EL4

compat-db-4.1.25-9

compat-libstdc++-296-2.96- 132.7.2

control-center-2.8.0-12

gcc-3.4.3-22.1.EL4

gcc-c++-3.4.3-22.1.EL44

glibc-2.3.4-2.9

glibc-common-2.3.4-2.9

gnome-libs-1.4.1.2.90-44.1

libstdc++-3.4.3-22.1

libstdc++-devel-3.4.3-22.1

make-3.80-5

pdksh-5.2.14-30

xscreensaver-4.18-5.rhel4.2

setarch-1.6-1

• Command to verify version of the operating systems

        cat /etc/issue

• Command to verify version of the Kernel is installed

        uname -r

• To query the packages are installed

        rpm -qa < packagename >

• Configuring Kernel parameters :

First of all login as a root user then only you can set the kernel values :

• set the kernel parameter values

• type the command as

change the directory to /proc/sys/kernel
where we have to set the sem, shmmax, shmmni, shmmin values

• see all the above values correct or not .

echo 250 32000 100 128  > sem
echo  value >  shmmax (Half the size of physical memory (in bytes))
echo 4096  >  shmmni
echo 2097152  >  shmall
echo 1024 65000 >  /proc/sys/net/ipv4/ip_local_port_range
echo 1048576  > /proc/sys/net/core/rmem_default
echo 1048576  >  /proc/sys/net/core/rmem_max
echo 262144  >  /proc/sys/net/core/wmem_default
echo 262144  >  /proc/sys/net/core/wmem_max

• set the ulimit values

ulimit -n 65536

• set the socket value

echo 65536 > /proc/sys/fs/file-max

• set the process limit by

ulimit -u 16384
To set Kernel parameter values permanant:

• For making the values of Kernel parameters permanantly we must go to the specified location in /etc/sysctl.conf.

type command as :
cd /etc
then type ls
where we get the file sysctl.conf
in that edit and set the values of shmmax shmmin shmmni shmall
After that Login as root user

• Add the root user as using

syntax:
useradd -g  dba  -d  /d01/oracle  -p welcome  username
or
we can add the user in GUI -
go to Applications ->system settings -> users and groups
in that give the username and password
and set the group as dba.

Open the file and export the variables :
export ORACLE_BASE=/d01/oracle
export ORACLE_HOME=/d01/oracle/10.2.0.4
export ORACLE_SID=name
export LD_ASSUME_KERNEL=2.4.19
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$ORACLE_HOME/bin:$PATH
After setting the environment variable
run the environment variable
In the mount point create a directory by name or give any name
like ' stage1'

• Download the software to this stage1 location & unzip all the files .

• After unzipping all the files we have run the runInstaller which is there in the database

• Before that we have to run the xhost + from the root user

for the GUI .

Now we can run the runInstaller from the database as

./runInstaller   
 A pop-up window will be displayed follow the steps...  
(In the last window run the script from root user as    /d01/oracle/10.2.0.4/root.sh ) 
 the installation process Completed...
@@@@@@@@@@@ THANK YOU@@@@@@@@@@@@