Monthly Archives: August 2010

linux, Oracle 10g, RAC, unix

Enabling Oracle RDBMS RAC features

Leave a comment

The determination of Oracle binary support for Real Application Clustering is made during installation on all supported platforms. Thus, an installation made for a single instance database will not support creation of RAC by default. However, you can modify the binaries to support these features after installation. This article details the steps to modify your Oracle binaries to support Oracle RAC.

1. Logon to your Oracle database server as the Oracle software owner.

2. Change directory to your ORACLE_HOME/rdbms/lib.

cd $ORACLE_HOME/rdbms/lib

3. Use make to recreate your Oracle binaries with the option rac_on

make -f ins_rdbms.mk rac_on

4. Change directory to your ORACLE_HOME/bin.

5. Execute the utility relink with option all, to recreate all binary files.

relink all

6. This completes altering your Oracle RDBMS binaries to support Oracle RAC features.

Larry J. Catt, OCP 9i, 10g
oracle@allcompute.com
www.allcompute.com

11g, installer, Oracle, windows, windows 7

Oracle installation of 10.2.0.4 for Windows 7 Error

Leave a comment

While I am not an OS expert, I can comment that Windows 7 has given us speed and reliability while eliminating the sluggish performance and over-bearing protection of Vista. In this series, I would like to discuss problems one may encounter while running Oracle products on a Windows 7 client and ways in which these problems can be over come. This article discusses the Error of incorrect operating system found while installing Oracle 10.2.0.4 on a Windows 7 machine and how to ignore this error.

1. After you have downloaded the 10204_vista_w2k8_x64_production_db software from Oracle website and attemtpted to install the software with the command setup, you will probably encounter the below error.

Starting Oracle Universal Installer…

Checking installer requirements…

Checking operating system version: must be 5.0, 5.1, 5.2 or 6.0 . Actual 6.1

Failed < <<< Exiting Oracle Universal Installer, log for this session can be found at C:\User s\Home\AppData\Local\Temp\OraInstall2010-08-03_11-57-13AM\installActions2010-08- 03_11-57-13AM.log Please press Enter to exit...

2. This type of error is typical for most software once a new operating system version is released. To bypass the error, first open a command prompt by entering: Start –> Run –> CMD and enter.

3. Navigate the to directory of your oracle installer.

C:\Users\Home>
C:\Users\Home>cd c:\software\10204_vista_w2k8_x64_production_db\database

c:\software\10204_vista_w2k8_x64_production_db\database>

4. Now execute the command: setup.exe -ignoresysprereqs

c:\software\10204_vista_w2k8_x64_production_db\database>setup.exe -ignoresysprereqs

5. If a warning screen appears, click Yes to install the software.

6. At the Welcome Screen, you can press Next to begin your installation.

That completes the installation of Oracle 10.2.0.4 RDBMS on a Window 7 machine.

Larry J. Catt, OCP 9i, 10g
oracle@allcompute.com
www.allcompute.com

linux, Oracle, Oracle 10g, RAC, unix

Manually initializing Oracle OCFS2 stack

Leave a comment

Oracle provides the file system OCFS2 to support Oracle RAC file storage. This file system provides for a locking mechanism which allows files to be accessed by multiple Oracle instances while avoiding corruption. The OSFS2 file system binaries must be started before any OCFS2 formatted mount points can be accessed. This article shows the error generated when the OCFS2 stack has not been started and how to resolve the problem.

General OS error:


[root@mylinux /]# mount /dev/mapper/MPATH10 /u02
mount.ocfs2: Unable to access cluster service while trying initialize cluster

Resolution:

1. Logon to your server as root.
2. Execute the OS layer command /etc/init.d/o2cb enable

[root@mylinux /]# /etc/init.d/o2cb enable
Loading filesystem “configfs”: OK
Mounting configfs filesystem at /sys/kernel/config: OK
Loading filesystem “ocfs2_dlmfs”: OK
Mounting ocfs2_dlmfs filesystem at /dlm: OK
[root@mylinux /]#

3. Execute the OS layer command /etc/init.d/o2cb start

[root@mylinux /]# /etc/init.d/o2cb start
Starting O2CB cluster ocfs2: OK
[root@mylinux /]#

4. Attempt to mount your ocfs2 storage device.

[root@mylinux /]# mount /dev/mapper/MPATH10 /u02
[root@mylinux /]#

5. This completes restarting OCFS2 binaries.

Larry J. Catt, OCP 9i, 10g
oracle@allcompute.com
www.allcompute.com