Oracle 10g RAC Database with Grid Infrastructure 11.2 on Oracle Enterprise Linux 6U1 64Bit

Yes I know, it’s not supported and looks a bit crazy. But as I was using Linux 6 already with my RAC Database (see other blogs) and had to do some tests with an Oracle 10g database I tried to run it on the same environment. Another point is that I’m uncertain about the support for Linux 6. Due to the certification matrix it says: “Linux 5 Update 4 or greater” – but isn’t Linux 6 greater than Linux 5U4? Okay – nevertheless I’ll give it a trial:

To install any Oracle 10g database version on Linux 6 64 bit some additional 32 bit packages are required:

  • For the relink of some oracle executables:
  • For the univeral installer to run properly:

Luckily all those packages are available with the actual Linux 6 distribution.

Now we need to install first because there is no full installable Oracle 10g version other than this. As expected the universal installer fails with the message that the OS is not supported. So it’s necessary to avoid any kind of preinstallation checks with the option “-IgnoreSysPrereqs”.

% runInstaller -IgnoreSysPrereqs

With this little trick the installation works very smoothly. Both nodes were found and the software was installed on both nodes automatically.

Now it’s time to install patch and – oh wonder – the universal installer accepts the linux 6 and runs without any complains. And as the Oracle documentation says the installer accepts the 11g clusterware as well and all software is installed automatically on both nodes.

Create Database

Before we can start dbca to install the database there is one restriction which has to be resolved: to run a pre 11g database with grid infrastructure 11g the nodes have to be pinned to the crs (see “RAC: Frequently Asked Questions [ID 220970.1]”). The command has to be executed as root in the grid environment.

# olsnodes -t -n
asterix 1       Unpinned
obelix  2       Unpinned
# crsctl pin css -n asterix obelix
CRS-4664: Node asterix successfully pinned.
CRS-4664: Node obelix successfully pinned.

After pinning the nodes the database configuration assistant (dbca) recognizes that this is a RAC installation and asks for the nodes as well as for the ASM infrastructure. The whole configuration process runs without any problem.

Unfortunately it looks as if the scan listener cannot be used with Oracle 10g. So for the client connection the vip addresses seem to be the only way to use load balancing and failover (maybe someone can give me some hints how to make it work with the scan addresses).

The databases (10g and 11g) are both running fine in my test environment. If you want to share some experiences or give me some hints please comment with this blog.


About Carajandb

I'm an Oracle professional for more than 20 years and founder of CarajanDB. As you can see because of the layout of my blog one of my hobbys is Kiting - and esp. Indoorkiting.
Gallery | This entry was posted in Oracle, Oracle(E). Bookmark the permalink.

5 Responses to Oracle 10g RAC Database with Grid Infrastructure 11.2 on Oracle Enterprise Linux 6U1 64Bit

  1. hello says:

    why java_pool_size is 24mb (default) in 10g? How it is calculate??

  2. Carajandb says:

    I don’t know excatly but my guess is that this is the minimum size to run a java procedure. But it’s definitively not sufficient if you really want to use Java in the database.

  3. Pacho Chalas says:

    I need install 10g database over 11g grid, but rac options in my binaries 10.2 doesn’t show.

    • Carajandb says:

      Hi Pacho
      Are you able to install the software on both nodes or do you miss the option for grid while installing it? I had similar issues that the second node was not shown up during installation but nevertheless the software was correctly installed on both nodes.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s