Dear Readers,
My name is Franz Devantier, creator of this blog. I am an Oracle Certified
Professional (OCP DBA 11g) Security DBA.
I will be sharing with you the basic duties of an Oracle DBA, and also
some of the undocumented, and not so well known tasks.
I will make a deal with you: If you refer me to a company that needs
database support, from a few hours per week to full time, and I am able to sign
a contract with them.
Then I will give you 10% of the monthly
contract or deal price every month. When
the contract ends, and we re-sign the contract, I will again give you 10% of
the monthly contract price. This will go
on until the company no longer employs or contracts me or my agents to look
after their databases.
I can do this, because that 10% is my
marketing budget. When we re-sign the
contract, in the future, it may depend on you giving the thumbs up again, and
that is worth 10% of the monthly contract price, to be given to you as
commission.
Oracle Database Preinstallation – Part 4
Kernel Requirements
For
Oracle Database Server 11.2, there are the following kernel requirements
Linux
x86
Linux x86
|
Kernel
|
On
Oracle Linux 4 and red Hat Enterprise Linux 4
|
2.6.9
or later
|
On
Asianux Server 3, Oracle Linux 5, and Red Hat Enterprise Linux 5
|
2.6.18
or later
|
On
SUSE Linux Enterprise Server 10
|
2.6.16.21
|
On
SUSE Linux Enterprise Server 11
|
2.6.27.19
|
Linux
x86-64
Linux x86-64
|
Kernel
|
On
Oracle Linux 4 and Red Hat Enterprise Linux 4
|
2.6.9
or later
|
On
Oracle Linux 5 Update 5
|
2.6.32-100.0.19
or later
|
On
Oracle Linux 5 Update 2
|
2.6.18
or later (with Red Hat Compatible Kernel)
|
On
Oracle Linux 6
|
2.6.32-100.28.5.el6.x86_64
or later
|
On
Oracle Linux 6
|
2.6.32-71.el6.x86_64 or later
(with Red Hat Compatible Kernel)
|
On
Red Hat Enterprise Linux 5 Update 5 with the Oracle Unbreakable Enterprise
Kernel for Linux
|
2.6.32
or later
|
On Red Hat Enterprise Linux 6 with
the Oracle Unbreakable Enterprise Kernel for Linux
|
2.6.32-100.28.5.el6.x86_64
or later
|
On
Red Hat Enterprise Linux 6
|
2.6.32-71.el6.x86_64 or later
|
On Asianux Server 3, Oracle Linux
5 Update 2, and Red Hat Enterprise Linux 5 Update 2
|
2.6.18
or later
|
On SUSE Linux Enterprise Server 10
|
2.6.16.21
or later
|
On SUSE Linux Enterprise Server 11
|
2.6.27.19
or later
|
IBM: Linux on System z
IBM: Linux on System z
|
Kernel
|
On
Red Hat Enterprise Linux 4
|
2.6.9 or later
|
On
Red Hat Enterprise Linux 5
|
2.6.18 or later
|
On
SUSE Linux Enterprise Server 10
|
2.6.16.60 or later
|
On
SUSE Linux Enterprise Server 11
|
2.6.32.12 or later
|
To
determine if the required kernel is installed, enter the following command:
$
uname -r
You
could expect output similar to the below, which was run from a shell on an
Oracle Linux 5 system:
2.6.18-128.el5PAE
You
see that the Kernel version is “2.6.18” and that the errata level is “-128.el5PAE”
If
your kernel version is not up to specifications, then you will have to contact
the operating system vendor, for further information about obtaining and
installing the correct Kernel updates.
Package Requirements
The
following are the list of packages required for Oracle Database 11g Release 2 (11.2):
We
are just going to look at the package requirements for Oracle Linux
x86_64. If you are using a different
Operating system, then you can look in the Oracle Installation Guides for the
appropriate information.
Oracle
recommends that you install your Linux operating system with the default
software packages, which are also known as RPM’s. It is best not to customize the RPM’s during
a default Operating System installation.
If you use the default installation, then most of the RPM’s or packages
that you will need to install Oracle will already be installed. One of the big things with packages is the
package dependencies. Installing a
package with multiple package dependencies, who may also have dependencies, is
something that you want to minimize if possible.
Sometimes
you get to an installation and the operating system is already installed, and
not a default installation. Also if you
want to use LDAP, or you want to run certain scripts, for example: odisrvreg,
oidca, or schemasync; then you can install the Korn shell RPM for the Linux distribution.
Below
is a list of packages for Oracle Linux x86_64.
You must make sure that all these packages or RPM’s, and all of their
prerequisites are properly installed. If
you can only find a later version of a package then that is generally ok, unless
there are specific dependencies to other packeages.
I am looking at x86_64, because it just makes sense to migrate to
a 64 bit environment.
Starting with Oracle 11.2.0.2, all the 32 bit packages with the
exception of “gcc-32bit-4.3” are no longer required, but only the 64-bit RPM’s. However if your database is a release prior
to 11.2.0.2, then you will need to
install both the 32 bit packages, and the 64 bit packages.
Oracle Database Package Requirements for Linux x86-64
Operating System
|
Package RPM –
requirement
|
Oracle Linux 4, red Hat Enterprise Linux 4
|
The
following packages (or later versions) must be installed:
|
binutils-2.15.92.0.2
|
|
compat-libstdc++-33-3.2.3
|
|
compat-libstdc++-33-3.2.3
(32 bit)
|
|
elfutils-libelf-0.97
|
|
elfutils-libelf-devel-0.97
|
|
expat-1.95.7
|
|
gcc-3.4.6
|
|
gcc-c++-3.4.6
|
|
glibc-2.3.4-2.41
|
|
glibc-2.3.4-2.41
(32 bit)
|
|
glibc-common-2.3.4
|
|
glibc-devel-2.3.4
|
|
glibc-headers-2.3.4
|
|
libaio-0.3.105
|
|
libaio-0.3.105
(32 bit)
|
|
libaio-devel-0.3.105
|
|
libaio-devel-0.3.105
(32 bit)
|
|
libgcc-3.4.6
|
|
libgcc-3.4.6
(32-bit)
|
|
libstdc++-3.4.6
|
|
libstdc++-3.4.6
(32 bit)
|
|
libstdc++-devel
3.4.6
|
|
make-3.80
|
|
numactl-0.6.4.x86_64
|
|
pdksh-5.2.14
|
|
sysstat-5.0.5
|
|
Operating System
|
Package RPM –
requirement
|
Asianux
Server 3, Oracle Linux 5, and Red Hat Enterprise Linux 5
|
The
following packages (or later versions) must be installed:
|
binutils-2.17.50.0.6
|
|
compat-libstdc++-33-3.2.3
|
|
compat-libstdc++-33-3.2.3
(32 bit)
|
|
elfutils-libelf-0.125
|
|
elfutils-libelf-devel-0.125
|
|
gcc-4.1.2
|
|
gcc-c++-4.1.2
|
|
glibc-2.5-24
|
|
glibc-2.5-24
(32 bit)
|
|
glibc-common-2.5
|
|
glibc-devel-2.5
|
|
glibc-devel-2.5
(32 bit)
|
|
glibc-headers-2.5
|
|
ksh-20060214
|
|
libaio-0.3.106
|
|
libaio-0.3.106
(32 bit)
|
|
libaio-devel-0.3.106
|
|
libaio-devel-0.3.106
(32 bit)
|
|
libgcc-4.1.2
|
|
libgcc-4.1.2
(32 bit)
|
|
libstdc++-4.1.2
|
|
libstdc++-4.1.2
(32 bit)
|
|
libstdc++-devel
4.1.2
|
|
make-3.81
|
|
sysstat-7.0.2
|
|
Operating System
|
Package RPM –
requirement
|
Oracle
Linux 6 and Red Hat Enterprise Linux 6
|
The
following packages (or later versions) must be installed:
|
binutils-2.20.51.0.2-5.11.el6
(x86_64)
|
|
compat-libcap1-1.10-1
(x86_64)
|
|
compat-libstdc++-33-3.2.3-69.el6
(x86_64)
|
|
compat-libstdc++-33-3.2.3-69.el6.i686
|
|
gcc-4.4.4-13.el6
(x86_64)
|
|
gcc-c++-4.4.4-13.el6
(x86_64)
|
|
glibc-2.12-1.7.el6
(i686)
|
|
glibc-2.12-1.7.el6
(x86_64)
|
|
glibc-devel-2.12-1.7.el6
(x86_64)
|
|
glibc-devel-2.12-1.7.el6.i686
|
|
ksh
|
|
libgcc-4.4.4-13.el6
(i686)
|
|
libgcc-4.4.4-13.el6
(x86_64)
|
|
libstdc++-4.4.4-13.el6
(x86_64)
|
|
libstdc++-4.4.4-13.el6.i686
|
|
libstdc++-devel-4.4.4-13.el6
(x86_64)
|
|
libstdc++-devel-4.4.4-13.el6.i686
|
|
libaio-0.3.107-10.el6
(x86_64)
|
|
libaio-0.3.107-10.el6.i686
|
|
libaio-devel-0.3.107-10.el6
(x86_64)
|
|
libaio-devel-0.3.107-10.el6.i686
|
|
make-3.81-19.el6
|
|
sysstat-9.0.4-11.el6
(x86_64)
|
Rpm, stands for RedHat Package Manager. However rpm has been adopted by other Linux
distributions as well. RPM packages have
the .rpm extension. In Linux you need to
be logged in as the root user, in order to install the rpm packages.
To install a software package you use the -i option,
which tell the package manager to install the software.
$ rpm –i software-1.2.3.rpm
If the software is already installed on the operating
system, and you just want to upgrade it, then you will use the -U switch.
$ rmp -U software-1.2.3.rpm
Executable programs that are installed with rpm, usually
go into /bin, /usr/bin, /usr/X11/bin, or /usr/X11R6/bin
Usually you can run the program by simply typing it in
your shell, so you don’t need to know where the program is installed, but only
the program name. The program may get
added to your menu.
If you get a failed dependency error, then rpm also
spools out a list of dependencies. You
will need to first download and install or upgrade these packages, before you
can try the one which failed again. It
is also possible to install the package without the dependencies, although this
is not recommended.
$ rpm –i software-1.2.3.rpm --nodeps
You can also install the package like this:
$ rpm -ivh software-1.2.3.rpm
. i = install
. v = verbose
. h = print hash marks as the package archive is unpacked
To remove or erase software that you previously installed
with rpm you use the -e switch
$ rpm -e software-1.2.3
Notice that you can leave the extension out, and even the
version information if you like, or don’t know it.
$ rpm -e software
If you remove software with the rm command, then rpm will
not remove the software from its database, which could lead to problems.
You can query the rpm database to see what software is
there, for example:
$ rpm -q software
This will either confirm that the software is not
installed, or return the version numbers.
You can generate a list of all the packages installed on
your system with the -qa switch, you
will probably want to pipe this to “less”, so that you can examine the output.
$ rpm -qa | less
The -qa switch is also very useful for helping you to
find packages with specific letters in them, for example:
$ rpm -qa |grep soft
Remember to look on the Linux distribution media first
for the package, before downloading it from the Linux vendor’s web site.
Franz Devantier,
Need a database health check?
devantierf@gmail.com
Classifieds
