Skip to main content

Oracle 11g installation on rhel5

Oracle 11g installation on RHEL 5.


Oracle 11g requires at least 1GB RAM
#grep MemTotal   /proc/meminfo
MemTotal:          1027144 kb
#grep SwapTotal  /proc/meminfo
SwapTotal:          1052216 Kb

  • We need  at least 400MB free space in  /tmp
  • About 3.5GB free space for Oracle software
  • The kernel for Red Hat 5 should be 2.6.18 or newer
#uname –r
2.6.18-53.el5

1. Install some packages:


[root@chetan~]#yum -y install binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel
glibc glibc-common  glibc-devel gcc gcc-c++ libaio libaio-devel libgcc libstdc++ libstdc++-devel
 make sysstat  unixODBC unixODBC-devel 
2. Edit Kernel Parameter.
[root@chetan~]# vim /etc/sysctl.conf
# make it comment
#net.bridge.bridge-nf-call-ip6tables = 0
#net.bridge.bridge-nf-call-iptables = 0
#net.bridge.bridge-nf-call-arptables = 0
# add at the last line
net.ipv4.ip_local_port_range = 9000 65500
fs.file-max = 6815744
kernel.shmall = 10523004
kernel.shmmax = 6465333657
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.core.rmem_default=262144
net.core.wmem_default=262144
net.core.rmem_max=4194304
net.core.wmem_max=1048576
fs.aio-max-nr = 1048576
[root@chetan~]# sysctl –p
net.ipv4.ip_local_port_range = 9000 65500
fs.file-max = 6815744
kernel.shmall = 10523004
kernel.shmmax = 6465333657
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.core.rmem_default=262144
net.core.wmem_default=262144
net.core.rmem_max=4194304
net.core.wmem_max=1048576
fs.aio-max-nr = 1048576
3. Create a user for oracle.
[root@chetan~]# groupadd -g 200 oinstall 
[root@chetan ~]# groupadd -g 201 dba
[root@chetan ~]# useradd -u 440 -g oinstall -G dba -d /usr/oracle oracle 
[root@chetan ~]# vi /etc/pam.d/login
#add at the last line
session    required     pam_limits.so
[root@chetan ~]# vim /etc/security/limit.conf
# add at the last line
oracle   soft   nproc   2047
oracle   hard   nproc   16384
oracle   soft   nofile   1024
oracle   hard   nofile   65536
[root@chetan ~]# vim /etc/profile
# add at the last line
if [ $USER = "oracle" ]; then
      if [ $SHELL = "/bin/ksh" ]; then
           ulimit -p 16384
           ulimit -n 65536
      else
           ulimit -u 16384 -n 65536
      fi
fi
4.  Note: Access control does not allow opening X-windows from any server.
     We will use xhost command to disable this access control.
[root@chetan~]# xhost
Access control enabled,only authorized clients can connect
[root@chetan~]# xhost +
Access control disabled, clients can connect from any host
5. Switch to a user “oracle” and configure some settings.
[oracle@chetan ~]$ chmod 755 /usr/oracle
[oracle@chetan ~]$ mkdir /usr/oracle/app
[oracle@chetan ~]$ chmod 775 /usr/oracle/app
[oracle@chetan ~]$ mkdir /usr/oracle/oradata
[oracle@chetan ~]$ chmod 775 /usr/oracle/oradata 
[oracle@chetan ~]$ vi ~/.bash_profile
umask 022
export ORACLE_BASE=/usr/oracle/app
[oracle@chetan ~]$ mkdir tmp                  # create a temporary dir to installation purpose
[oracle@chetan ~]$ cd tmp
[oracle@chetan  tmp~]$ unzip linux_11gR2_database_1of2.zip
[oracle@chetan  tmp~]$ unzip linux_11gR2_database_2of2.zip
[oracle@chetan  tmp~]$ cd database
[oracle@chetan  database ~]$ ./runInstaller
1.Oracle Installer starts like follows. 



2.Select "Install database software only".
  
 3. For this example, select "Single Instance ***".

4. Select your language.
 5. Select which edition you install.
6. Specify base directory and files for Oracle. On this example, keep default and Proceed.
7. Specify directory for installation. On this example, keep default and Proceed.
8.Specify priviledged group. On this example, keep default and Proceed.
9. Checking settings runs automatically for requirements of installing Oracle. Generally, some packages requirements failed like follows, but it's noplobmen because most of them are higher version packages than requirements. Ignore them if the result is the same to the follows.
  
10.The summary is shown for configuration. Click "Finish" if it's OK all.
  
11. Installation starts.
12. Following screen is shown, then open a terminal and execute follwong commands by root user.



[root@chetan ~]#/usr/oracle/oraInventory/orainstRoot.sh 
Changing permissions of /usr/oracle/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.
Changing groupname of /usr/oracle/oraInventory to oinstall.
The execution of the script is complete.
[root@chetan ~]# /usr/oracle/app/product/11.2.0/dbhome_1/root.sh 
Running Oracle 11g root.sh script...
The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME= /usr/oracle/app/product/11.2.0/dbhome_1
Enter the full pathname of the local bin directory: [/usr/local/bin]:                  # Enter

    Copying dbhome to /usr/local/bin ...
    Copying oraenv to /usr/local/bin ...
    Copying coraenv to /usr/local/bin ...
Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
Finished product-specific root actions.


13.Installation completed. click 'close' button.



14. configure some setting for 'oracle' user.
[oracle@chetan~]#vi ~./bash_profile

# add at the last lone
export ORACLE_BASE=/usr/oracle/app
export ORACLE_SID= orcl
export ORACLE_HOME=/usr/oracle/app/oracle/product/11.2.0/dbhome_1/
export PATH=$PATH:$ORACLE_HOME/bin

[oracle@chetan ~]$ source ~/.bash_profile 
[oracle@chetan ~]$ rm -rf tmp
[oracle@chetan ~]$ sqlplus  /  as  sysdba

SQL>

Comments

Post a Comment

Popular posts from this blog

Docker Container Management from Cockpit

Cockpit can manage containers via docker. This functionality is present in the Cockpit docker package. Cockpit communicates with docker via its API via the /var/run/docker.sock unix socket. The docker API is root equivalent, and on a properly configured system, only root can access the docker API. If the currently logged in user is not root then Cockpit will try to escalate the user’s privileges via Polkit or sudo before connecting to the socket. Alternatively, we can create a docker Unix group. Anyone in that docker group can then access the docker API, and gain root privileges on the system. [root@rhel8 ~] #  yum install cockpit-docker    -y  Once the package installed then "containers" section would be added in the dashboard and we can manage the containers and images from the console. We can search or pull an image from docker hub just by searching with the keyword like nginx centos.   Once the Image downloaded we can start a contai
Post a Comment
Read more

Remote Systems Management With Cockpit

The cockpit is a Red Hat Enterprise Linux web-based interface designed for managing and monitoring your local system, as well as Linux servers located in your network environment. In RHEL 8 Cockpit is the default installation candidate we can just start the service and then can start the management of machines. For RHEL7 or Fedora based machines we can follow steps to install and configure the cockpit.  Following are the few features of cockpit.  Managing services Managing user accounts Managing and monitoring system services Configuring network interfaces and firewall Reviewing system logs Managing virtual machines Creating diagnostic reports Setting kernel dump configuration Configuring SELinux Updating software Managing system subscriptions Installation of cockpit package.  [root@rhel8 ~] #  dnf   install cockpit cockpit-dashboard  -y  We need to enable the socket.  [root@rhel8 ~] #  systemctl enable --now cockpit.socket If firewall is runnin
Post a Comment
Read more

Containers Without Docker on RHEL/Fedora

Docker is perfectly doing well with the containerization. Since docker uses the Server/Client architecture to run the containers. So, even if I am a client or developer who just wants to create a docker image from Dockerfile I need to start the docker daemon which of course generates some extra overhead on the machine.  Also, a daemon that needs to run on your system, and it needs to run with root privileges which might have certain security implications. Here now the solution is available where we do not need to start the daemon to create the containers. We can create the images and push them any of the repositories and images are fully compatible to run on any of the environment.  Podman is an open-source Linux tool for working with containers. That includes containers in registries such as docker.io and quay.io. let's start with the podman to manage the containers.  Install the package  [root@rhel8 ~] # dnf install podman -y  OR [root@rhel8 ~] # yum
1 comment
Read more