Omnipresent IT Solutions Pvt Ltd

Sunday, July 26, 2009

Oracle Database 11g installation On Fedora 11

1.Download Software

http://www.oracle.com/technology/software/products/database/index.html

2.Unpack Files

unzip filename.zip

3.Pre installation tasks

      1.Following lines should be appended to the "/etc/sysctl.conf" file. 
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=4194304
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=262144


2.Run the command to change the current kernel parameters:
/sbin/sysctl -p

3.Add the following lines to the /etc/security/limits.conf file:

oracle              soft    nproc   2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
4.Add the following line to the /etc/pam.d/login file, if it does not already exist:
session    required     /lib/security/pam_limits.so
session required pam_limits.so
5.Disable firewall

6.Disable secure linux by editing the /etc/selinux/config file
SELINUX=disabled

7.Install the following packages:

su -c 'yum install binutils glibc glibc-common libgcc libstdc++ make elfutils-libelf
elfutils-libelf-devel glibc-devel gcc gcc-c++ libstdc++-devel unixODBC unixODBC-devel
libaio libaio-devel sysstat compat-libstdc++-33'


8.Create new groups and users:

groupadd oinstall
groupadd dba
groupadd oper
groupadd asmadmin

useradd -g oinstall -G dba,oper,asmadmin oracle
passwd oracle
9.Create the directories in which the Oracle software will be installed:

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


10. Edit /etc/hosts

File must contain a fully qualified name for the server:
    
Example: 127.0.0.1 acerfedora localhost

11.Login as root and issue the following command:

xhost + "machine_name"
12.Edit the /etc/redhat-release file replacing the current release information (Fedora release 11 (Leonidas)) with the following:
redhat release 5

12.Reboot your system and login as oracle user

4.Installation


Start the Oracle Universal Installer (OUI) by issuing the following command in the database directory:
./runInstaller

1.Enter password
2. Continue

3. Check user verified for network
4. Note down paths

6.Click password management and unlock accounts you need 7. Installation succesfull



5.Post Installation

1.Edit the /etc/redhat-release file restoring the original release information:
Fedora release 11 (Leonidas)
2.Edit the /etc/oratab file setting the restart flag for each instance to 'Y':
DB11G:/u01/app/oracle/product/11.1.0/db_1:Y

3.Edit /home/oracle/.bash_profile file and ass the following at end of file
# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR

ORACLE_HOSTNAME="machinename"; export ORACLE_HOSTNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.1.0/"db_2"; export ORACLE_HOME
ORACLE_SID=orcl; 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
Note: Verify parameters with your own values






1 comment:

Anonymous said...

Live for nothing die for something...