dbawiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
To install on CentOS, you have to trick the Oracle installer into thinking it is installing on Redhat.\\
Edit these files:\\
/etc/issue and /etc/redhat-release\\
and replace the CentOS with this line:\\
<code>
Red Hat Enterprise Linux Server release 5 (Tikanga)
</code>
==== From root on the machine: ====
=== Make sure the kernel version meets the minimum Oracle requirements ===
Required kernel version: 2.6.18
<code>
 uname -rm
</code>
=== Add or modify the following parameters in /etc/sysctl.conf ===
You could leave this alone and the installer will generate a fixup script which will modify those that need modifying.
<code>
  -  Minimum requirements for Oracle
fs.suid_dumpable = 1
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=4194304
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=1048586
</code>
Run
<code>
 /sbin/sysctl -a | grep <param-name>
</code>
to check the current value and
<code>
 /sbin/sysctp -p
</code>
to make the changes take effect.

=== The following lines have to be added to /etc/security/limits.conf ===
<code>
oracle              soft    nproc   2047
oracle              hard    nproc   16384
oracle              soft    nofile  4096
oracle              hard    nofile  65536
oracle              soft    stack   10240
</code>
=== Check required packages are installed ===
This is a list of the packages that must be installed for the Oracle installation to succeed
<code>
binutils-2.*
compat-libstdc++-33*
elfutils-libelf*
gcc-4.*
gcc-c++-4.*
glibc-2.*
glibc-common-2.*
glibc-devel-2.*
glibc-headers-2.*
ksh*
libaio-0.*
libaio-devel-0.*
libgomp-4.*
libgcc-4.*
libstdc++-4.*
libstdc++-devel-4.*
make-3.*
sysstat-7.*
unixODBC-2.*
unixODBC-devel-2.*
numactl-devel-*
</code>
At root prompt, type
<code>
 yum info <package_name>
</code>
or
<code>
 rpm -qa | grep <package_name>
</code>
to see whether it is installed, and
<code>
 yum -y install <package_name>
</code>
to install the package.

=== Create the software owner and groups ===
<code>
groupadd dba
groupadd oinstall
groupadd oper
useradd -m -g dba -G oinstall,oper oracle
mkdir -p /u01/app/oracle/product/11.2.0/db_1
chown -R oracle:oinstall /u01
chmod -R 775 /u01
passwd oracle
</code>
=== Ensure SELINUX is disabled in /etc/selinux/config ===
<code>
  -  This file controls the state of SELinux on the system.
  -  SELINUX= can take one of these three values:
  -    enforcing - SELinux security policy is enforced.
  -    permissive - SELinux prints warnings instead of enforcing.
  -    disabled - No SELinux policy is loaded.
SELINUX=disabled
  - 
</code>

==== Log in as oracle ====
=== Add the following to the .bash_profile ===
Although only the ORACLE_BASE (and temp dirs) is recommended, you can set the other variables if you know them and want them in the profile.

They will be set automatically when oraenv is called so after installation, you could just set the SID and call oraenv.
<code>
  -  Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export ORACLE_SID=RTPRD
export PATH=$ORACLE_HOME/bin:/usr/sbin:$PAT
</code>
Then log out and in again for the changes to take effect

=== Set the DISPLAY variable to allow the installer to display on your computer ===
Now this part can either work first time or can be tricky! See "Fixing X11 display issues" further down more more info.
<code>
 export DISPLAY=<your IP address>>0.0
</code>

==== getting xclock to work ====
if this doesn't work, forget trying to run the Oracle installer
<code>
 xclock
</code>

=== Make sure that X11 forwarding is enabled in PuTTY (or whatever you use) ===
In PuTTY, this setting is found in
<code>
 Connections:SSH:X11
</code>

<code>
 startx
</code>
If this doesn't work, is X installed?
yum search xorg-x11

yum info xorg-x11

<code>
yum groupinstall "X Window System"
</code>
or
<code>
yum whatprovides "xclock"
</code>
vi /etc/ssh/sshd_config
Make sure these settings are uncommented and set
<code>
X11Forwarding yes
X11DisplayOffset 10
</code>
<code>
[[oracle@459287-tbscgebl database]]$ ./runInstaller
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB.   Actual 1423 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 2047 MB    Passed
Checking monitor: must be configured to display at least 256 colors
    >>> Could not execute auto check for display colors using command /usr/bin/xdpyinfo. Check if the DISPLAY variable is set.    Failed <<<<

Some requirement checks failed. You must fulfill these requirements before

continuing with the installation,

Continue? (y/n) [[n]]

[[oracle@459285-tbscgebl database]]$ ./runInstaller
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB.   Actual 1814 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 2047 MB    Passed
Checking monitor: must be configured to display at least 256 colors.    Actual 16777216    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2012-11-30_04-10-30PM. Please wait ...Error in CreateOUIProcess(): 13
> Permission denied
</code>
means TMP is set to a directory with bad permissions, create a tmp subdirectory under oracle's own account and use that
<code>
cd
mkdir tmp
export TMP=$HOME/tmp
</code>



Copy/download the Oracle software to the server
<code>
mkdir downloads
cd downloads
unzip linux.x64_11gR2_database_1of2.zip
unzip linux.x64_11gR2_database_2of2.zip
</code>
Now we should have a single directory called 'database' owned by oracle

<code>
[[oracle@esra database]]$ ./runInstaller
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB.   Actual 34549 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 1972 MB    Passed
Checking monitor: must be configured to display at least 256 colors
    >>> Could not execute auto check for display colors using command /usr/bin/xdpyinfo. Check if the DISPLAY variable is set.    Failed <<<<

Some requirement checks failed. You must fulfill these requirements before

continuing with the installation,

Continue? (y/n) [[n]]

User Selected: No

Exiting Oracle Universal Installer, log for this session can be found at /tmp/OraInstall2013-09-29_08-21-39PM/installActions2013-09-29_08-21-39PM.log
</code>
If you see this, you are probably running the installer from an account that does not have the authority to start an X session.\\
Did you "su - oracle" from a root session?\\
exit your oracle session going back to root, type:
<code>
xhost +
</code>
then "su - oracle" again. Works wonders.

==== References ====
  *  [[http://aruljohn.com/info/x11forwarding|Xming and Putty]]
  *  [[http://www.gilandre.net/cgi-bin/wiki.cgi/X11PuttyProxy|All about those X11 magic cookies]]
  *  [[http://www.unixwiz.net/techtips/ssh-agent-forwarding.html|An Illustrated Guide to SSH Agent Forwarding (a very nice explanation of how it works - with pictures)]]
  *  [[http://www.gearhack.com/Forums/DisplayComments.php?file=Computer/Linux/Troubleshooting._X_connection_to_localhost.10.0_broken_.explicit_kill_or_server_shutdown..|Troubleshooting: X connection to localhost:10.0 broken (explicit kill or server shutdown).]]
  *  [[https://forums.oracle.com/forums/thread.jspa?threadID=956882|Thread: Can't open display , while upgrading Database ]]
  *  [[http://tobeimpact.blogspot.be/2011/02/failed-could-not-execute-auto-check-for.html|Could not execute auto check for display colors using command /usr/X11R6/bin/xdpyinfo. Check if the DISPLAY variable is set.]]
  *  [[http://www.linuxquestions.org/questions/linux-software-2/installing-xhost-on-rh-879680/|Is xorg-x11-server-utils installed?]]
  *  [[http://apps2fusion.com/apps/installation-mainmenu-51/27-virtual-machine/451-install-rpm-oracle-enterprise-linux-5|How to setup yum repository in repos.d]]
  *  [[http://www.oracle-base.com/articles/11g/oracle-db-11gr2-installation-on-oracle-linux-5.php|ORACLE-BASE version of 11g Release 2 (11.2) Installation On Oracle Linux 5]]