As you know being a Software Test Engineer we should have great love for Database. and If you wish to use database checkpoint you should know how to setup oracle so that you can use Database checkpoints. here are the steps that can help you to install Oracle 10g R2 on Linux 5.4 Machine
1. Step 1 Install Linux 5.4 (we are not going to discuss how to install Linux in this session)
2. Right Click on Desktop and Open Terminal
vi /etc/hosts
press i
172.16.0.101 lab3 localdomain lab3
press ESC
:wq
3. Set Karnal Parameters
vi /etc/sysctl.conf
press i
#kernel.shmall = 2097152
#kernel.shmmax = 2147483648
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
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.rmem_max=262144
net.core.wmem_default=262144
net.core.wmem_max=262144
press ESC
:wq
4. Enter Security Limits for Oracle user
vi /etc/security/limits.conf
press i
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
press ESC
:wq
5. Verify that Firewall is disabled
vi /etc/selinux/config
press i
SELINUX=disabled
press ESC
:wq
6. Install the Required RPM's using RedHat Media
rpm -Uvh setarch-2*
rpm -Uvh make-3*
rpm -Uvh glibc-2*
rpm -Uvh libaio-0*
rpm -Uvh compat-libstdc++-33-3*
rpm -Uvh compat-gcc-34-3*
rpm -Uvh compat-gcc-34-c++-3*
rpm -Uvh gcc-4*
rpm -Uvh libXp-1*
rpm -Uvh openmotif-2*
rpm -Uvh compat-db-4*
7. Create new Groups and Users
groupadd oinstall
groupadd dba
groupadd oper
useradd -g oinstall -G dba oracle
passwd oracle
*Set password for oracle user
8.Create the directories in which the Oracle software will be installed:
to perform step 8 user must be login as root so
go to terminal and write su - root
write the following commands
mkdir -p /u01/app/oracle/product/10.2.0/db_1
chown -R oracle.oinstall /u01
9. Make Xhost Entry
xhost +lab3
// lab3 is my machine name
10. Change Release number (10g R2 can't be installed on 5.4 so change version of installed media
vi /etc/redhat-release
press i
Redhat-4
press ESC
:wq
11. Switch user to Oracle to enter bash_profile file
# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOME
ORACLE_SID=TSH1; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
press esc
:wq
12. System is ready so install Oracle (Always from Oracle user)
go to media file where installer is exist
execute command
./runInstaller
press enter
1. Step 1 Install Linux 5.4 (we are not going to discuss how to install Linux in this session)
2. Right Click on Desktop and Open Terminal
vi /etc/hosts
press i
172.16.0.101 lab3 localdomain lab3
press ESC
:wq
3. Set Karnal Parameters
vi /etc/sysctl.conf
press i
#kernel.shmall = 2097152
#kernel.shmmax = 2147483648
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
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.rmem_max=262144
net.core.wmem_default=262144
net.core.wmem_max=262144
press ESC
:wq
4. Enter Security Limits for Oracle user
vi /etc/security/limits.conf
press i
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
press ESC
:wq
5. Verify that Firewall is disabled
vi /etc/selinux/config
press i
SELINUX=disabled
press ESC
:wq
6. Install the Required RPM's using RedHat Media
rpm -Uvh setarch-2*
rpm -Uvh make-3*
rpm -Uvh glibc-2*
rpm -Uvh libaio-0*
rpm -Uvh compat-libstdc++-33-3*
rpm -Uvh compat-gcc-34-3*
rpm -Uvh compat-gcc-34-c++-3*
rpm -Uvh gcc-4*
rpm -Uvh libXp-1*
rpm -Uvh openmotif-2*
rpm -Uvh compat-db-4*
7. Create new Groups and Users
groupadd oinstall
groupadd dba
groupadd oper
useradd -g oinstall -G dba oracle
passwd oracle
*Set password for oracle user
8.Create the directories in which the Oracle software will be installed:
to perform step 8 user must be login as root so
go to terminal and write su - root
write the following commands
mkdir -p /u01/app/oracle/product/10.2.0/db_1
chown -R oracle.oinstall /u01
9. Make Xhost Entry
xhost +lab3
// lab3 is my machine name
10. Change Release number (10g R2 can't be installed on 5.4 so change version of installed media
vi /etc/redhat-release
press i
Redhat-4
press ESC
:wq
11. Switch user to Oracle to enter bash_profile file
# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOME
ORACLE_SID=TSH1; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
press esc
:wq
12. System is ready so install Oracle (Always from Oracle user)
go to media file where installer is exist
execute command
./runInstaller
press enter
2 comments:
A very good detailed and easy to understand guide, my friend was in need of something like this and I gave him this link and me and him are very thankful to you sharing a such a nice article.
Arthur Lawrence also provides Oracle Consulting and Oracle Services in USA.
Thanks for the great tutorial. It is nice to go through the process at a high level.
Oracle Remote Database Administration
Post a Comment