Editing Oracle 10g VE

This is just a listing of steps taken to create a fully functional
Oracle container.

== Create the container on the [[host system]] ==

 vzctl create 1001 --ostemplate centos-4-i386-default
 vzctl set 1001 --userpasswd root:password --save
 vzctl set 1001 --hostname ve-oracle.example.com --save
 vzctl set 1001 --ipadd 192.168.0.62 --save

== Reset resource limits ==

I decided to have max limits to avoid problems during installation.
Once the installation is
done and the system left running for some time, these limits can be
adjusted.

{{Note|setting the UBC limits to "unlimited" value like below can only be done
on a trusted single-container machine, and can create problems. For more info
about UBC, see [[Resource shortage]] and [[UBC]].}}

 vzctl set 1001 --kmemsize 2147483647:2147483647 --save
 vzctl set 1001 --lockedpages 2147483647:2147483647 --save
 vzctl set 1001 --privvmpages 2147483647:2147483647 --save
 vzctl set 1001 --shmpages 2147483647:2147483647 --save
 vzctl set 1001 --numproc 2147483647:2147483647 --save
 vzctl set 1001 --numtcpsock 2147483647:2147483647 --save
 vzctl set 1001 --numflock 2147483647:2147483647 --save
 vzctl set 1001 --numpty 2147483647:2147483647 --save
 vzctl set 1001 --numsiginfo 2147483647:2147483647 --save
 vzctl set 1001 --tcpsndbuf 2147483647:2147483647 --save
 vzctl set 1001 --tcprcvbuf 2147483647:2147483647 --save
 vzctl set 1001 --othersockbuf 2147483647:2147483647 --save
 vzctl set 1001 --dgramrcvbuf 2147483647:2147483647 --save
 vzctl set 1001 --numothersock 2147483647:2147483647 --save
 vzctl set 1001 --dcachesize 2147483647:2147483647 --save
 vzctl set 1001 --numfile 2147483647:2147483647 --save
 vzctl set 1001 --numiptent 2147483647:2147483647 --save

Or you can set these limits in your vz.conf file:

 # Primary parameters
 AVNUMPROC="unlimited:unlimited"
 NUMPROC="unlimited:unlimited"
 NUMTCPSOCK="unlimited:unlimited"
 NUMOTHERSOCK="unlimited:unlimited"
 VMGUARPAGES="unlimited:unlimited"
 
 # Secondary parameters
 KMEMSIZE="unlimited:unlimited"
 TCPSNDBUF="unlimited:unlimited"
 TCPRCVBUF="unlimited:unlimited"
 OTHERSOCKBUF="unlimited:unlimited"
 DGRAMRCVBUF="unlimited:unlimited"
 OOMGUARPAGES="unlimited:unlimited"
 
 # Auxiliary parameters
 LOCKEDPAGES="unlimited:unlimited"
 SHMPAGES="unlimited:unlimited"
 PRIVVMPAGES="unlimited:unlimited"
 NUMFILE="unlimited:unlimited"
 NUMFLOCK="unlimited:unlimited"
 NUMPTY="unlimited:unlimited"
 NUMSIGINFO="unlimited:unlimited"
 DCACHESIZE="unlimited:unlimited"

PHYSPAGES="unlimited:unlimited"
NUMIPTENT="unlimited:unlimited"

{{Inconsistent UBC warning}}

== Start the container ==
 vzctl start 1001

== Update <code>/etc/resolv.conf</code> on the container ==

Put the following into your container's /etc/resolv.conf:

 search example.com
 nameserver <ip address of your name server>

== Install Required Packages ==

 vzyum 1001 install binutils compat-db gcc gcc-c++ glibc \
  glibc-common libstdc++ libstdc++-devel gnome-libs make \
  pdksh sysstat libaio xscreensaver openmotif21 xorg-x11-xfs \
  usbutils urw-fonts shared-mime-info perl-libwww-perl \
  perl-XML-Parser perl-URI perl-HTML-Tagset perl-HTML-Parser \
  patch lvm2 intltool libIDL libart_lgpl libbonobo xterm \
  libcap libcroco libgnomecanvas libexif libgnomecups \
  libgnomeprint22 libsoup libwnck libxklavier

== Check the following rpms are installed on the container ==

 vzctl exec 1001 rpm -q binutils gcc gcc-c++ glibc gnome-libs \
  libstdc++ libstdc++-devel make pdksh sysstat xscreensaver libaio

== Add Oracle User/Group ==

 vzctl exec 1001 /usr/sbin/groupadd oinstall
 vzctl exec 1001 /usr/sbin/groupadd dba
 vzctl exec 1001 /usr/sbin/useradd -m -g oinstall -G dba oracle
 vzctl exec 1001 id oracle

== Set Password for the Oracle user ==

 vzctl exec 1001 passwd oracle

== Create Directories for Oracle Home/Data and the download directory ==

 vzctl exec 1001 mkdir /home/oracle/10gR2_db
 vzctl exec 1001 mkdir -p /u01/app/oracle/product/10.2.0/db_1
 vzctl exec 1001 mkdir /u01/app/oracle/oradata
 vzctl exec 1001 chown -R oracle:oinstall /u01/app/oracle /home/oracle/10gR2_db
 vzctl exec 1001 chmod -R 775 /u01/app/oracle /home/oracle/10gR2_db
 vzctl exec 1001 ln -s /usr/lib/libstdc++.so.6.0.3 /usr/lib/libstdc++.so.5

== Put these values in /etc/sysctl.conf on the HN ==

Put these values in /etc/sysctl.conf on the HN:

 kernel.shmall = 2097152
 kernel.shmmax = 536870912
 kernel.shmmni = 4096
 kernel.sem = 250 32000 100 128
 fs.file-max = 65536
 net.ipv4.ip_local_port_range = 1024 65000
 net.core.rmem_default=262144
 net.core.wmem_default=262144
 net.core.rmem_max=262144
 net.core.wmem_max=262144

Then execute on the HN the following command:
 
 /sbin/sysctl -p


At this point the container is ready for Oracle installation.
We take a backup of the container at this point in case we need to rebuild the
system or do a clean Oracle install.

== Shutdown the container and take a backup ==

 vzctl stop 1001
 cd /u01/backups
 tar czpvf ve-1001-preOracle.tar.gz /vz/private/1001/ /etc/vz/conf/1001.conf

== Start the container again ==

 vzctl start 1001

== Put oracle distro into the container ==

Copy the downloaded Oracle zip file to the container and change its
ownership to "oracle" on the container.

 cp /u01/software/10201_database_linux32.zip /vz/private/1001/home/oracle/10gR2_db/
 vzctl exec 1001 chown oracle:oinstall /home/oracle/10gR2_db/10201_database_linux32.zip

== Start installation ==

Now login as oracle on the ve-1001, and run the following commands:

 cd /home/oracle/10gR2_db
 unzip 10201_database_linux32.zip
 cd database/
 export ORACLE_BASE=/u01/app/oracle
 export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
 export DISPLAY=192.168.0.149:0

Make sure you can run xterm, then:

 ./runInstaller

'''When prompted to run scripts as root. Login as root and execute'''

 export DISPLAY=192.168.0.149:0
 /u01/app/oracle/oraInventory/orainstRoot.sh
 /u01/app/oracle/product/10.2.0/db_1/root.sh

'''Update oracle's profile with the following'''

 cd
 vi /home/oracle/.bashrc
 export ORACLE_BASE=/u01/app/oracle
 export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
 export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
 export PATH=$ORACLE_HOME/bin:$PATH
 export ORACLE_SID=orcl


'''Delete installation files (optional)'''

 cd /home/oracle/10gR2_db
 rm -rf database

'''Time to take another backup of the container on the [[hardware node]].''' 

This backup will allow you to restore the container to the point where no
database has yet been created.

 vzctl stop 1001
 cd /u01/backups
 tar czpvf ve-1001-postOracleSoftware.tar.gz \
   /vz/private/1001/ /etc/vz/conf/1001.conf


Start the container 

 vzctl start 1001

'''Login as oracle and create the database'''

 export DISPLAY=192.168.0.149:0
 dbca


'''Create listener'''

 netca

'''Now take another backup on the HN node'''

 vzctl stop 1001
 cd /u01/backups
 tar czpvf ve-1001-postOracleDatabase.tar.gz \
   /vz/private/1001/ /etc/vz/conf/1001.conf

== Oracle Help ==

* [http://www.orafaq.com/forum Ask questions on the Oracle Forum]
* [http://www.orawiki.com/ Oracle Wiki]

[[Category:HOWTO]]