Wednesday, March 3, 2010

Oracle 11gR2 RAC installation: Database installation

Login to first node as the oracle user and start the runInstaller

Configure your Oracle Support Account

Create and configure a database

Server class

It's a Rac installation

Test the SSH conectivity from previos screenshot.

SSH connectivity already estabilished

Advanced installation

Installing the Enterprise Edition

Options availables

Choose the right path

General purpose database installation

Global database name: RAC3

Character sets


Sample schemas, no thanks.

In the course of introducing Automatic Memory Management (AMM) in version 11g, Oracle performed a major change in the internal memory management on OS level. This affects the prerequisites for setting up a database. It is important to know that, prior to starting the Oracle instance, the underlying virtual file system has to be sized accordingly. The determining factor here is the value of the memory_max_target parameter. If not set explicitly it defaults to the memory_target parameter value.
The following error I got adding another database (for test my restore script) using dbca on the same RAC environment.
ORA-00845: MEMORY_TARGET not supported on this system
and on the alert log you could read the following warning message:
WARNING: You are trying to use the MEMORY_TARGET feature. This feature requires the /dev/shm file system to be mounted for at least 1795162112 bytes. /dev/shm is either not mounted or is mounted with available space less than this size. Please fix this so that MEMORY_TARGET can work as expected. Current available is 1795063808 and used is 2394198016 bytes. Ensure that the mount point is /dev/shm for this directory.memory_target needs larger /dev/shm
I will cover this problem in another post.
Setting now a high value of database memory arise the following error

So from runInstaller choose a suitable memory. In my case I choose 44%

No Grid Control is available

As database storage I choosed Automatic Storage Management

I'm not enabling automated backups

Select the existing disk groups for ASM

That's all.

No comments: