Installing Required RPMs from DVD Before You Install Oracle Database 10g or 11g

I came across a forum post in which one of my co-workers, Avi Miller, explained how to install Oracle Enterprise Linux from DVD so that all software requirements are met when you fire up the Oracle Database 10g or 11g installer.

There are several ways to deal with the software preinstallation requirements for the Oracle Database. And, while it's not very difficult to install the required RPMs, it can be somewhat awkward to do so in the correct dependency order.

To simplify this task, Oracle provides the oracle-validated RPM, discussed here, here, and here previously on this blog. The Oracle® Database Installation Guide 11g Release 1 (11.1) for Linux also describes how to install the oracle-validated RPM if you have access to Unbreakable Linux Network (ULN)

If you're installing Oracle Enterprise Linux, to run Oracle Database 10g or 11g, following the steps Avi outlined will save you time. Especially if you don't have access to ULN.

  1. Follow the installation process as normal until you get to the first software selection screen (it lists a series of tasks that you can add support for, and has an option at the bottom: "Customize Later" and "Customize Now"
  2. Select the "Customize Now" option and click Next




  3. Select "Base System" in the left-hand list and then "System Tools" in the right hand list. Click the checkbox next to "System Tools", then click the "Optional Packages" button.






  4. ins4.png

  5. Scroll down and select the "oracle-validated" package and click "Close"


Avi continues: "You can now click "next" and continue the installation as normal. This also creates the oracle user/groups, sets up sysctl.conf, limits.conf, etc. It's fairly nifty." I followed these steps using the Oracle Enterprise Linux 5, Update 3 DVD I downloaded via edelivery.oracle.com, and it works like a breeze. Here's a final screen shot of the installer looking happy:

Comments:

Very nice tip! This makes the DB install soooo much easier.

Posted by Tyler on February 17, 2009 at 02:30 AM PST #

Great thanks! Will make installation a lot easier :) !

Posted by Peter on February 17, 2009 at 11:13 PM PST #

Very good!!! I don't find informations about package into Oracle Unbreakable for installation the Oracle Database 10g R2. Thanks Luciano - Brasil

Posted by Luciano Alvarenga on July 01, 2009 at 10:09 PM PDT #

Hi, I saw this blog only after installing the OEL 5 using CDs. Do we have this oracle validated packages on installation CDs also? Rgds, Thiru

Posted by thiru on September 09, 2009 at 12:12 AM PDT #

@Thiru: Yes, the oracle-validated is on the OEL 5 CD/DVD. See this blog entry: http://blogs.oracle.com/sergio/2008/10/installing_oraclevalidated_fro.html You can also use public-yum.oracle.com. Sergio

Posted by Sergio on September 09, 2009 at 06:20 AM PDT #

Thanks. Acutally I want to know what this oracle-validated packages does. Does it installs all the Oracle RDBMS required rpm packages? Thanks Thiru

Posted by thiru on September 13, 2009 at 05:55 PM PDT #

@Thiru, Search this blog for oracle-validated to see all the posts that have been written on it. Also, see the Oracle Database documentation on this topic: http://download.oracle.com/docs/cd/E11882_01/install.112/e10812/prelinux.htm#sthref55 Sergio

Posted by Sergio on September 13, 2009 at 10:02 PM PDT #

Hi Sergio, Thanks for all your helps. Even after installing the Oracle-Validated... from CD5 of Oracle 10g DB R2, still the following packages are missing. gnome-libs-1.4.1.2.90-44.1 pdksh-5.2.14-30.3 xscreensaver-4.18-5.rhel4.9 openmotif21-2.1.30-11.RHEL4.4 (optional) Please reply. Leo.

Posted by Leo on October 14, 2009 at 02:19 AM PDT #

@Leo, Can you describe what your objective was and the steps you followed in this forum: http://forums.oracle.com/forums/forum.jspa?forumID=822 It's going to be hard to diagnose this via blog comments. :-) Sergio

Posted by Sergio on October 18, 2009 at 10:54 PM PDT #

Hi Sergio, Thank you for sharing this information. I successfully installed OEL5 followed you recommendation to select "oracle-validate" package during the installation. I read some where that you reccomended to verify the results in this location : /etc/sysconfig/oracle-validated/results/orakernel.log In my case the oracle_validated directory did not created: [oracle@java-dev-1 sysconfig]$ ls -l oracle* lrwxrwxrwx 1 root root 24 Oct 12 11:22 oracleasm -> oracleasm-_dev_oracleasm -rw-r--r-- 1 root root 574 Mar 20 2009 oracleasm-_dev_oracleasm oracle-validated: total 40 -rw-r--r-- 1 root root 23 Oct 12 00:00 oracle-validated.conf -rw-r--r-- 1 root root 2854 Dec 22 2009 oracle-validated.params -rwxr-xr-x 1 root root 20000 Dec 22 2009 oracle-validated-verify Do you have any suggestion why ? Thanks Yoav

Posted by Yoav on October 13, 2010 at 07:09 PM PDT #

@Yoav: In more recent versions of the oracle-validated RPM, the log is here: /var/log/oracle-validated/results/orakernel.log Sergio

Posted by Sergio on October 13, 2010 at 10:28 PM PDT #

Hi Sergio, Thank you for your update. You was right the file was found at the location you mentioned. The installation guide http://download.oracle.com/docs/cd/E11882_01/install.112/e16763/install_overview.htm#BABDGCEH Mention that : "When it is installed, the Oracle Validated Configuration RPM does the following: Automatically installs any additional packages needed for installing Oracle Grid Infrastructure and Oracle Database " But /var/log/oracle-validated/results/orakernel.log files does not show any entry regarding installed RPM . Bellow is the output of orakernel.log Does it the same in your case ? Thanks Again Yoav vi orakernel.log Creating oracle user passed Verifying kernel parameters as per Oracle recommendations... Creating oracle user passed Verifying kernel parameters as per Oracle recommendations... fs.file-max 6815744 kernel.msgmni 2878 kernel.msgmax 65536 8192 kernel.msgmnb 65536 65536 kernel.sem 250 32000 100 142 kernel.shmmni 4096 kernel.shmall 4294967296 1073741824 kernel.shmmax 68719476736 4398046511104 kernel.sysrq 0 1 net.core.rmem_default 262144 net.core.rmem_max 4194304 net.core.wmem_default 262144 net.core.wmem_max 1048576 fs.aio-max-nr 3145728 net.ipv4.ip_local_port_range 9000 65500 vm.min_free_kbytes 51200 Setting kernel parameters as per oracle recommendations... Altered file /etc/sysctl.conf Original file backed up at /etc/sysctl.conf.orabackup Verifying & setting of kernel parameters passed Verifying oracle user OS limits as per Oracle recommendations... oracle soft nofile 131072 oracle hard nofile 131072 oracle soft nproc 131072 oracle hard nproc 131072 oracle soft core unlimited oracle hard core unlimited oracle soft memlock 50000000 oracle hard memlock 50000000 Setting oracle user OS limits as per Oracle recommendations... Altered file /etc/security/limits.conf Original file backed up at /etc/security/limits.conf.orabackup Verifying & setting of user limits passed /boot/grub/menu.lst not present.. .. Verifying of boot parameters failed. Verifying module parameters as per Oracle recommendations... No settings to be modified Verifying & setting of module parameters passed Verifying kernel boot parameters as per Oracle recommendations... Setting kernel boot parameters as per Oracle recommendations... Boot parameters will be effected on next reboot Altered file /boot/grub/grub.conf Original file backed up at /boot/grub/grub.conf.orabackup Altered Boot file /boot/grub/grub.conf and will be effected on next reboot

Posted by Yoav on October 15, 2010 at 10:12 PM PDT #

@Yoav: Mine looks similar, see below. The required RPMs installed because of oracle-validated are not logged. oracle-valiated brings with it required RPMs through its dependencies. You can see the RPMs it depends on by running the command: yum deplist oracle-validated [root@localhost results]# cat orakernel.log Adding group oinstall with gid 54321 groupadd: group oinstall exists Adding group dba groupadd: group dba exists Adding user oracle with user id 54321, initial login group oinstall, supplementary group dba and home directory /home/oracle User oracle is already present uid=500(oracle) gid=501(oinstall) groups=501(oinstall),500(dba) Creating oracle user passed Verifying kernel parameters as per Oracle recommendations... fs.file-max 6815744 kernel.msgmni 2878 kernel.msgmax 8192 kernel.msgmnb 65536 kernel.sem 250 32000 100 142 kernel.shmmni 4096 kernel.shmall 1073741824 kernel.shmmax 4398046511104 kernel.sysrq 1 net.core.rmem_default 262144 net.core.rmem_max 4194304 net.core.wmem_default 262144 net.core.wmem_max 1048576 fs.aio-max-nr 3145728 net.ipv4.ip_local_port_range 9000 65500 vm.min_free_kbytes 51200 Setting kernel parameters as per oracle recommendations... Altered file /etc/sysctl.conf Original file backed up at /etc/sysctl.conf.orabackup Verifying & setting of kernel parameters passed Verifying oracle user OS limits as per Oracle recommendations... oracle soft nofile 131072 oracle hard nofile 131072 oracle soft nproc 131072 oracle hard nproc 131072 oracle soft core unlimited oracle hard core unlimited oracle soft memlock 50000000 oracle hard memlock 50000000 Setting oracle user OS limits as per Oracle recommendations... Altered file /etc/security/limits.conf Original file backed up at /etc/security/limits.conf.orabackup Verifying & setting of user limits passed Verifying kernel boot parameters as per Oracle recommendations... old boot params: kernel /vmlinuz-2.6.32-100.0.19.el5 ro root=LABEL=/, new boot params: kernel /vmlinuz-2.6.32-100.0.19.el5 ro root=LABEL=/ numa=off old boot params: kernel /vmlinuz-2.6.18-194.el5xen ro root=LABEL=/, new boot params: kernel /vmlinuz-2.6.18-194.el5xen ro root=LABEL=/ numa=off old boot params: kernel /vmlinuz-2.6.18-128.0.0.0.2.el5xen ro root=LABEL=/, new boot params: kernel /vmlinuz-2.6.18-128.0.0.0.2.el5xen ro root=LABEL=/ numa=off Setting kernel boot parameters as per Oracle recommendations... Boot parameters will be effected on next reboot Altered file /boot/grub/grub.conf Original file backed up at /boot/grub/grub.conf.orabackup Verifying & setting of boot parameters passed Verifying module parameters as per Oracle recommendations... No settings to be modified Verifying & setting of module parameters passed

Posted by Sergio on October 18, 2010 at 01:12 AM PDT #

Hi Sergio , thanks for the awesome post !

I have installed OEL 5.4 64BIT . Followed your instructions of Customizing the packages during installation from DVD itself. Selected all the 39 optional packages , including the "Oracle-validated" package under System Tools .
But , still i face the package requirement failed error while proceeding with the DB installation. Following are the package which still show as Failed :
libaio-devel-0.3.106
unixODBC-devel-2.2.11

Please advise me how to install these packages which are missing.

Thanks in advance for your help.

Regards,
Hari

Posted by Harikrishnan on September 23, 2012 at 09:55 AM PDT #

@Hari:

Looks like you are already discussing this on the OTN forum. If not, that's the best place to take questions like these.

https://forums.oracle.com/forums/thread.jspa?threadID=2443095

Sergio

Posted by Sergio on September 24, 2012 at 12:19 PM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

bocadmin_ww

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today