Installing Oracle on Linux

-
Please find the below steps :
====================

1-> Download Putty and install on your windows desktop 
2-> Download xming software and install on your windows 
3-> Now you have make sure to have communication from your windows to virtual host 
      eg: if you are using Oracle VM  make sure you use virtual host interface 
4-> Make sure you download the oracle software 
5-> Now login to the linux host and update the /etc/host file with the below entries as below 

Hosts File:
The "/etc/hosts" file must contain a fully qualified name for the server.
<IP-address>  <fully-qualified-machine-name>  <machine-name>
 [root@ora11g ~]# cat /etc/hosts
 127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
192.168.56.102 ora11g.oracle.com ora11g

 6-> update the below kernel parameters 

Oracle recommends the following minimum parameter settings.

fs.suid_dumpable = 1
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
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

7-> Now define the security limits for the oracle user 
Add the following lines to the "/etc/security/limits.conf" file.
 oracle              soft    nproc   16384
oracle              hard    nproc   16384
oracle              soft    nofile  4096
oracle              hard    nofile  65536
oracle              soft    stack   10240

8-> Create the new groups and users.
groupadd -g 501 oinstall
groupadd -g 502 dba
groupadd -g 503 oper
groupadd -g 504 asmadmin
groupadd -g 506 asmdba
groupadd -g 505 asmoper
useradd -u 502 -g oinstall -G dba,asmdba,oper oracle
passwd oracle

9-> Amend the "/etc/security/limits.d/90-nproc.conf" file as described below. See MOS
 Note [ID 1487773.1]
# Change this
*          soft    nproc    1024
# To this
* - nproc 16384

10-> disable selinux and also disable firewall 
[root@ora11g ~]# vi /etc/selinux/config
[root@ora11g ~]# cat /etc/selinux/config
SELINUXTYPE=permissive

[root@ora11g ~]# service iptables stop
iptables: Setting chains to policy ACCEPT: nat mangle filte[  OK  ]
iptables: Flushing firewall rules:                         [  OK  ]
iptables: Unloading modules:                               [  OK  ]
[root@ora11g ~]# chconfig iptables off
-bash: chconfig: command not found
[root@ora11g ~]# chkconfig iptables off
[root@ora11g ~]#

11-> Now restart the linux server , before this go to the file "/boot/grub/grub.conf  and update the below entries with selinux=0

eg: 
        root (hd0,0)
        kernel /vmlinuz-4.1.12-61.1.28.el6uek.x86_64 ro root=/dev/mapper/vg_ora11g-lv_root rd_NO_LUKS LANG=en_US.UTF-8 rd_LVM_LV=vg_ora11g/lv_swap rd_NO_MD SYSFONT=latarcyrheb-sun16 crashkernel=1024M  KEYBOARDTYPE=pc KEYTABLE=us rd_LVM_LV=vg_ora11g/lv_root rd_NO_DM rhgb quiet selinux=0
 
12: Now using winscp copy the software to the linux server 

13-> Now  click on Xming and then open putty session and enable x11 settings and then launch putty session, 

Also execute xhost + 

14-> create directories 

mkdir -p /u01/app/oracle/product/11.2.0/db_1
chown -R oracle:oinstall /u01
chmod -R 775 /u01 

15-> Define the oracle bash profile 
Login as the oracle user and add the following lines at the end of the ".bash_profile" file.
# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_HOSTNAME=ora11g.oracle.com; export ORACLE_HOSTNAME
ORACLE_UNQNAME=TEST; export ORACLE_UNQNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0.4/db_1; export ORACLE_HOME
ORACLE_SID=TEST; export ORACLE_SID
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/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

Thanks,
Satya

Comments

Post a Comment

Popular posts from this blog

How to make CRS and ASM not to restart after server reboot

-
I have noticed that server rebooting is taking lot of time on a VM machine for every reboot, so I have decided to auto start of the crs and ASM service During this phase I have noticed an attribute called auto_start when I try to execute the below command crsctl stat res -p This AUTO_START attribute is there for several resources like ora.ASM ,ora.crs,ora.DATA_DG it has got 2 options restore(0) , never(2) and always (1) always (1)  Causes the resource to restart when the node restarts regardless of the resource’s state when the node stopped -restore (0)  Does not start the resource at restart time if it was in an offline state, such as STATE=OFFLINE, TARGET=OFFLINE, when the node stopped. The resource is restored to its state when the node went down. The resource is started only if it was online before and not otherwise. -never (2)  Oracle Clusterware never restarts the resource regardless of the resource’s state when the node is stopped. So I have dec...
Read more

How to repair ASM disk header

-
Image
What is ASM disk header corruption? ASM disk header corruption is a loss or damage to the disk header which contains the metadata essential for the operation and availability of an ASM disk group in Oracle. Imagine that you have an ASM disk corruption in any of the ASM diskgroups that have critical business data and the diskgroup has been configured as "EXTERNAL" redundancy, meaning that if one disk is inaccessible the whole diskgroup will be unavailable. Now what? Is your only option to restore it from backup by recreating the diskgroup or are there any other faster ways to recover the data? Here you need to find out whether it’s a complete loss of data in the ASM disk or is it just a header corruption. Hopefully for you, this is just a header corruption. Because, yes, there is a way out!  Below find the steps to restore from the ASM header corruption. Most of the data in the ASM disk header is of interest to that disk only. However, some information in the ASM disk header ...
Read more

How to replace ASM failed disk?

-
Oracle Automatic Storage Management (ASM) was introduced in Oracle 10g. ASM provides advance storage management features such as DISK I/O re-balancing, volume management and easy database file name management. It also can provide MIRRORING of data for high availability and redundancy in the event of a disk failure (Mirroring is optional). ASM guarantees that data extents (table,index row data etc.) in one disk are mirrored in another disk (normal redundancy) and in two disks (high redundancy). A few times I have faced ASM disk failures when redundancy (mirroring) was enabled and none of them resulted in an issue for an end user. ASM automatically detects the disk failure and services Oracle SQL requests by retrieving information from the mirrored (other) disk. Such a failure is handled gracefully and entirely managed by Oracle. I am very impressed by the fault tolerance capability in ASM. But soon the Oracle DBA must work with the system administrator to replaced the failed disk. If t...
Read more