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


Security


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: