ORACLE TUTORIAL - RMAN backup commands

Oracle RMAN useful commands.

Oracle Tutorial - How to finde duplicate records in table

How to find duplicate records in Oracle Database step by step



For More detail please visit on my official website www.ocptechnology.com

Oracle Tutorial - How to add virtual column in oracle 11g

How to add Virtual column in ORACLE 11g step by step for more detail please visit on my official website www.ocptechnology.com

11g installation step by step in easy way

How to install ORACLE 11g step by step in simple way

for more detail please visit on my official website www.ocptechnology.com

Linux Tutorial - How to change HOSTNAME in LINUX step by step

How to change HOSTNAME step by step in LINUX for more detail please visit on my official website www.ocptechnology.com

ORACLE TUTORIAL - How to install ORACLE LINUX-7 installation

How to install ORACLE LINUX 7 step by step for more detail please visit on my official website www.ocptehcnology.com

Oracle Tutorial - How to configure wallet manager step by step

How to configure Oracle wallet step by step for more detail please visit on my official website www.ocptechnology.com

Oracle tutorial - How to rename a username/schema

Oracle tutorial step by step for more detail please visit on official website www.coptechnology.com

How to transport a tablespace from linux to

Hello Friends

Here a video, In this video i'm demonstrate you how to Transport a tablespace from LINUX to WINDOWS step by step.



For more detail please visit on my official website www.ocptechnology.com.

How to transport a tablespace from linux to

Hello Friends

Here a video, In this video i'm demonstrate you how to Transport a tablespace from LINUX to WINDOWS step by step.



For more detail please visit on my official website www.ocptechnology.com.

How to configure ASM step by step

How to configure Oracle ASM step by step.

How to install ORACLE 10g R2 on Linux 5.5For more detail click here and visit on my official website www.ocptechnology.com
Hello Friends Welcome in OCP Technology, Today I’m going to show you how to install oracle 10g_R2 (10.2.0.1) on Red Hat Linux 5.5. The installation similar to server installation, minimum requirement 1GB RAM and 2GB swap area, Firewall and selinux must be disabled, for more detail please visit on my  YouTube channel. I request to all viewer if want to learn more about ORACLE DATABASE and you want to get my new feature YouTube videos and New posts in your mail box so please subscribe my channel and my website also and please share it in your friends circle.

Important packages for Linux installation. 

• Editors
• GNOME Desktop Environment
• Text based internet
• Graphical internet
• Development Libraries
• Legacy software development
• Development tools
• Server configuration tools
• Administration tools
• Legacy software support
• Base
• X Window system
• System tools

Step1. Make a directory using bellow command.

#mkdir /u01

Step2. Unzip the Oracle Database downloaded file, using following command.

#unzip 10201_database_linux_x86_32 –d/u01

 After unzip you have a single directory which is containing installation file name is database.

Step3. Edit Hosts file using following command. It’s contain ip address and hostname of server machine.

#vi /etc/hosts

<ip address> <full name of server machine> <synonym name of machine>

For example

192.168.1.1       rhel5.localdomain       rhel5

Step4. Now edit sysctl.conf file where set kernel parameters, add below lines.

#vi /etc/sysctl.conf

kernel.sem=250 32000 250 250
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

save this file and run below command for applying current kernel parameters.

#/sbin/sysctl –p

Step5. Edit redhat-release file and change release version.

#vi /etc/redhat-release

Change the release from 5.5 to 4.5 in the release version.

Step6. Edit (‘/etc/security/limits.conf’) file, add all following lines in end of file.

*     soft  nproc       2047
*     hard  nproc       16384
*     soft  nofile      1024
*     hard  nofile      65536

Step7. Add bellow line in the (‘/etc/pam.d/login’) file.

 Session required pam_limits.so

Step8. Install all the below packages. Going in your DVD or ISO image using following command.

# cd /media/RHEL_5_x86_32/Server

Then run below command for installing .rpm file.

rpm -ivh compat-db-4.2.52-5.1.i386.rpm
 rpm –ivh compat-db-4*
 rpm –ivh gcc-4*
 rpm –ivh compat-gcc-34-3*
 rpm –ivh compat-libstdc++-33-3*
 rpm –ivh libaio-0*
 rpm –ivh glibc-2*
 rpm –ivh setarch-2*
 rpm -ivh compat-gcc-34-c3.4.6-4.i386.rpm
 rpm –ivh make-3*
 rpm -ivh libXp-1.0.0-8.i386.rpm
 rpm -ivh openmotif-2.3.0-0.3.el5.i386.rpm

#exit

Step9. Add new users and groups using following commands.

#groupadd dba
#groupadd oinstall
#groupadd oper
#useradd oracle
passwd oracle     (to set password for oracle user)
#usermod -g oinstall -G dba oracle
#chown -R oracle:oinstall /u01
#chmod -R 777 /u01

Step10. Now login in oracle user and add following line in (‘.bash_profile’)

#su – oracle

#oracle installation settings
  TMP=/tmp; export TMP
  TMPDIR=$TMP; export TMPDIR
  export ORACLE_BASE=/u01/app/oracle
  export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
  export ORACLE_TERM=xterm
  export PATH=$ORACLE_HOME/bin:$PATH
  export ORACLE_SID=orcl
  export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
  export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/rdbms/jlib
  if [$USER = “oracle” ]; then
  if [$SHELL = “/bin/ksh” ]; then
  ulimit –p  16384
  ulimit –n 65536
  else
  ulimit –u 16384 –n 65536
  fi
  fi

save it end reboot your pc then login as oracle user and following bellow commands.

$cd /u01/database/ (Enter)

$./runInstaller (Enter)

The oracle installation will begin at this point Follow the Graphical installation steps as as asked

Run both (2) the scripts in ROOT user terminal and then exit and enjoy, your database installation is completed.