How to install Oracle 11g R2 in RHEL 7 GUI Mode

how to install oracle 11g in Rhel7 linux GUI
step.1.Create a directory and copy file.
# mkdir /u01/
#linux.x64_11gR2_database_1of7.zip
#linux.x64_11gR2_database_2of7.zip
step.2.unzip the oracle 11g software.
#unzip linux.x64_11gR2_database_1of7.zip 
#unzip linux.x64_11gR2_database_2of7.zip 
Now you have a single Database folder which is have runInstaller file.
Step.3.Edit Hosts File
In the Hosts file you have to fully specify your hostname and your machine IP address.
#vi /etc/hosts
For Example.
<ip address >  <full name of machine >   <short name of your machine>
After update this file press Esc then shif+: then wq  then Enter.
Start configuration to install Oracle 11g R2
Step 4.
Edit /etc/sysctl.conf file and add below parameter in end of this file.
#vi /etc/sysctl.conf
 fs.aio-max-nr = 1048576
 fs.file-max = 6815744
 kernel.shmall = 2097152
 kernel.shmmax = 536870912
 kernel.shmmni = 4096
 # semaphores: semmsl, semmns, semopm, semmni
 kernel.sem = 250 32000 100 128
 net.ipv4.ip_local_port_range = 9000 65500
 net.core.rmem_default=262144
 net.core.rmem_max=4194304
 net.core.wmem_default=262144
 net.core.wmem_max=1048586
After that run below command for applying changes of sysctl file.
#/sbin/sysctl -p
Now Edit /etc/security/limits.conf and add following lines in end of this file.
#vi /etc/security/limits.conf
oracle              soft nproc 2047
oracle              hard nproc 16384
oracle              soft nofile 4096
oracle              hard nofile 65536
oracle              soft stack 10240

Step 5.
Now Edit /etc/pam.d/login file and end following parameter
#vi /etc/pam.d/login
session    required   pam_limits.so
Step 6.
Now install required packages for configuring Oracle Database for installing these rmp using YUM server for yum server configuration see my yum server configuration post.
yum install binutils -y
yum install compat-libstdc++-33 -y
yum install compat-libstdc++-33.i686 -y
yum install gcc -y
yum install gcc-c++ -y
yum install glibc -y
yum install glibc.i686 -y
yum install glibc-devel -y
yum install glibc-devel.i686 -y
yum install ksh -y
yum install libgcc -y
yum install libgcc.i686 -y
yum install libstdc++ -y
yum install libstdc++.i686 -y
yum install libstdc++-devel -y
yum install libstdc++-devel.i686 -y
yum install libaio -y
yum install libaio.i686 -y
yum install libaio-devel -y
yum install libaio-devel.i686 -y
yum install libXext -y
yum install libXext.i686 -y
yum install libXtst -y
yum install libXtst.i686 -y
yum install libX11 -y
yum install libX11.i686 -y
yum install libXau -y
yum install libXau.i686 -y
yum install libxcb -y
yum install libxcb.i686 -y
yum install libXi -y
yum install libXi.i686 -y
yum install make -y
yum install sysstat -y
yum install unixODBC -y
yum install unixODBC-devel -y
yum install zlib-devel -y
yum install elfutils-libelf-devel -y
Now add some group and add a user for Oracle installation.
groupadd -g 54321 oinstall
groupadd -g 54322 dba
groupadd -g 54323 oper


useradd -g oinstall -G dba,oper oracle
passwd oracle
Step 8.
Now create a Directory and change  directory permissions
mkdir -p /u01/app/oracle/product/11.2.0.4/db_1
chown -R oracle:oinstall /u01/
chmod -R 775 /u01/
Step 9.
Now set selinux=permissive
#vi /etc/selinux/config
Step 10.
Now make firewall disabled using setup command. Following below steps.
 #systemctl disable firewalld

Step 11.
Now connect you oracle user using su command then open .bash_profile command and add following command in end of file.
#su – oracle
$vi .bash_profile
# Oracle Settings
 TMP=/tmp; export TMP
 TMPDIR=$TMP;
 export TMPDIR
 ORACLE_HOSTNAME='hostname'
 ORACLE_UNQNAME=db11g; export ORACLE_UNQNAME
 ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
 ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/db_1; export ORACLE_HOME
 ORACLE_SID=db11g; 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
if [ $USER = "oracle" ]; then
 if [ $SHELL = "/bin/ksh" ]; then
 ulimit -p 16384
 ulimit -n 65536
 else
 ulimit -u 16384 -n 65536
 fi
 fi
Step 12.
Now reboot your pc and login with Oracle user and follow below steps.
$cd /u01/database
$./runInstaller


/u01/app/oraInventory/orainstRoot.sh

/u01/app/oracle/product/11.2.0/dbhome_1/root.sh

Comments

Post a Comment

Popular posts from this blog

MySQL Point in Time Recovery: How To Configure And How Does it Work?

Image
 MySQL Point in Time Recovery: How To Configure And How Does it Work? The point-in-time recovery allows you to restore a MySQL database to a specific time in the past. The point-in-time recovery relies on two key components: Full backup: This serves as the foundation for recovery, providing the starting state of the database. Binary logs: These binary log files record all changes made to the database, allowing you to replay those changes to a desired point. If you don’t have a full backup or binary logs enabled, you cannot carry the point-in-time recovery. We’ll illustrate how to perform the point-in-time recovery in MySQL to recover a database to a specific point in time. Checking binar log status:- We need login to mysql server and run given below command:- show global variables like 'log_bin' ; Show output for enable mysql-bin log. Creating a new sample database & taking a full backup:- We are going to login in mysql databse and creating new database and table.given ...
Read more

MySQL Replication Switchover: Step-by-Step Guide

Image
 MySQL Replication Switchover: Step-by-Step Guide MySQL replication is a powerful feature that allows you to create redundant copies of your database for improved availability and scalability. In certain scenarios, it becomes necessary to switch the roles of the master and slave servers in a replication setup. This article will guide you through the process of performing a MySQL replication switchover, ensuring a smooth transition without any data loss. Let’s dive into the step-by-step instructions. I have tow node one is master node and another is slave node.Given below details:- Current Master: 192.168.70.10 Current Slave : 192.168.70.11 Verifying the Replication:- Before initiating the switchover, it’s important to verify that replication is functioning correctly on the current Slave server (192.168.70.11). Execute the following queries to ensure the replication status: mysql> show slave status\G This command displays the slave’s status, including information such as replicat...
Read more

Mysql Commercial Mysqlbackup:How to take Differential or Incremental Backup and resotre using mysqlbackup utility in mysql 8.0.37 enterprise edition

Image
Mysql Commercial Mysqlbackup:How to take Differential or Incremental Backup and resotre using mysqlbackup utility in mysql 8.0.37 enterprise edition Incremental vs Differential Backup:- The main difference between incremental and differential backups is how they save space and time by storing only changed files. However, the effectiveness of incremental backups is very different from differential backups. Before we dive into the differences between Incremental and Differential backups let’s review Full Backups.  Are you still using Full Backups? In its simplest form, a full backup is the starting point for both Incremental and Differential backup strategies. A full backup, of course, backs up all the data on a partition or disk by copying all disk sectors with data to the backup image file.  A full backup is time-consuming and requires a lot of space, it’s usually used as part of a backup plan with long intervals, like once a week or a month. During this time, if anything goes...
Read more