Wednesday, December 10, 2008
Oracle 11gR2 Installation on RHEL 4
Wednesday, December 10, 2008
Dataguard Adventures - Part I...!!!!!
Wednesday, December 10, 2008
Dataguard Adventures - Part II...!!!!!…
Wednesday, December 10, 2008
When ASM rebalancing stops...!!!!
Monday, December 8, 2008
Reducing Downtime during database movement and migrations
Oracle 11gR2 Installation on RHEL 4
Oracle released 11g Release 2 and I was just waiting to get my fingers on it…!!! So downloaded the software from OTN and installed it on Linux. As of now, the software is available only on Linux.
The installation screens are catchy, oracle has left those blue installation screens of OUI, so altogether new screens. Another thing that I noticed that installation took damn good time, the reason being moving between the screens took lots and lots of time. I was doing the installation on remote server using Xmanager, but I don’t think that could be the reason for slowness, already installed 10g lot of times on the server and it was damn good.
Another new thing is the software can be installed for single instance or RAC installation. There is an option to check the language during software installation. There is an option to create response file at the end of installation which can help in future installations. So my software download is complete…Let's get to real work…
Download Software
Download the following software from OTN
http://www.oracle.com/technology/software/products/database/index.html
Oracle Database 11g Release 2 (11.2.0.1.0) for Linuxx86
linux_11gR2_database_1of2.zip (1,285,396,902 bytes) (cksum -2237015228)
linux_11gR2_database_2of2.zip (995,359,177 bytes) (cksum - 2649514514)
Unpack Files
unzip linux_11gR2_database_1of2.zip
unzip linux_11gR2_database_2of2.zip
This will create a directory called database and extract both the zip files into it.
[root@oracle10g u02]# ls -rlt
total 2229520
drwxr-xr-x 8 oracle dba 4096 Aug 19 01:24 database
drwx------ 2 root root 16384 Sep 12 15:07 lost+found
-rw-r--r-- 1 oracle dba 1285396902 Sep 12 15:54 linux_11gR2_database_1of2.zip
-rw-r--r-- 1 oracle dba 995359177 Sep 12 15:57 linux_11gR2_database_2of2.zip
[root@oracle10g u02]#
Minimum hardware requirements:
32-bit (x86)
- x86 compatible CPU
- 1 GB RAM
64-bit (x86_64)
- x86_64 compatible CPU
- 1 GB RAM
32-bit (x86) Installations
Check your kernel version by running the following command:
uname -r
[root@oracle10g ~]# uname -r
2.6.9-89.0.0.0.1.ELsmp
The minimum Linux version required for 11gR2 is RHEL 4.0
Required package versions (or later):
- compat-libstdc++-33-3.2.3-61
- elfutils-libelf-0.125-3.el5
- elfutils-libelf-devel-0.125-3.el5
- glibc-2.5-12
- glibc-devel-2.5-12
- glibc-common-2.5-12
- gcc-4.1.1-52.el5
- gcc-c++-4.1.1-52.el5
- kernel-headers
- libgcc-4.1.1-52.el5
- libaio-0.3.106-3.2
- libaio-devel-0.3.106-3.2
- libstdc++-4.1.1-52.el5
- libstdc++-devel-4.1.1-52.el5
- unixODBC-2.2.11-7.1
- unixODBC-devel-2.2.11-7.1
- sysstat-7.0.0-3.el5
- binutils-2.17.50.0.6-2.el5
- make-3.81-1.1
Run the following command to check the RPMs.
rpm -q binutils-2.15.92.0.2 \
compat-libstdc++-33.2.3 \
elfutils-libelf-0.97 \
elfutils-libelf-devel-0.97 \
gcc-3.4.6 \
gcc-c++-3.4.6 \
glibc-2.3.4-2.41 \
glibc-common-2.3.4 \
glibc-devel-2.3.4 \
glibc-headers-2.3.4 \
libaio-devel-0.3.105 \
libaio-0.3.105 \
libgcc-3.4.6 \
libstdc++-3.4.6 \
libstdc++-devel-3.4.6 \
make-3.80 \
pdksh-5.2.14 \
sysstat-5.0.5 \
unixODBC-2.2.11 \
unixODBC-devel-2.2.11
Create the Oracle Groups and User Account
Next, create the Linux groups and user account that will be used to install and maintain the Oracle Database 11g Release 2 software. The user account will be called oracle, and the groups will be oinstall and dba. I usually use only dba group in my installations.Execute the following commands as root:
# /usr/sbin/groupadd dba
# /usr/sbin/useradd -m -g dba oracle
# id oracle
uid=501(oracle) gid=502(oinstall) groups=502(oinstall),503(dba)
Set the password on the oracle account:
passwd oracle
# passwd oracle
Changing password for user oracle.
New password:
Retype new password:
passwd: all authentication tokens updated successfully.
Configuring the Linux Kernel Parameters
Oracle Database 11g Release 2 requires the kernel parameter settings shown below. The values given are minimum, so if your system uses a larger value, don't change it. Linux allows modification of most kernel parameters while the system is up and running, so there's no need to reboot the system after making kernel parameter changes.
cat >> /etc/sysctl.conf <
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 6815744
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default=262144
net.core.wmem_default=262144
net.core.rmem_max=4194304
net.core.wmem_max=1048586
EOF
Setting shell limits for the oracle user
Oracle recommends setting limits on the number of processes and open files each Linux account may use. To make these changes, cut and paste the following commands as root:
cat >> /etc/security/limits.conf <> /etc/pam.d/login <Change the default profile for bash and ksh as well as the default login script for cshell.
cat >> /etc/profile <> /etc/csh.login <
Installation
Log into the oracle user. If you are using X emulation then set the DISPLAY environmental variable:
DISPLAY=
Start the Oracle Universal Installer (OUI) by issuing the following command in the database directory:
[root@oracle10g database]# pwd
/u02/database
[root@oracle10g database]# ./runInstaller
So this was about the basic installation on Oracle 10gR2. Will share my next experiences with the product soon….!!!
Cheers..!!!
--Rishi
hi thnks for all the information,can you please update is it possible that we can install 11g on redhat linux version 4i and will data from 9i can be migrated to 11g
ReplyDeletePlease guide!!!
Regards
deepak
Which version is 4i? If its RHEL 4 or any other clone of linux version 4, yes you can use it to install 11g.Yes you can do migration from 9i to 11g directly if the 9i version is 9.2.0.4 or higher.
ReplyDeleteThanks
Rishi
Hi Rishi,
ReplyDeleteNice 2 see U, I hv joined Wipro Infotech, here v hav oracle 10g RAC on HU-UNIX with service guard, NO- ASM!....but again nothing to do more..apart from monitoring... I m afraid of my future. where to go so that i can inhance my practical knowledge. Plz suggest.
Regards
Arun Kumar
09811267217
arunbharthry@gmail.com
arunbharthry@rediffmail.com
Thanks for such a informative site, found it very helpful keep updates see oracel connections about tech and consulting news.
ReplyDelete