Friday, May 25, 2012

Oracle 11gR2 Installation Tips (Linux x86_64)


1. Create a listener prior the database creation , since dbca would not continue as in 10g
2. In order to use the new MEMORY_TARGET feature you must have the /dev/shm at least the same amount.
    as root :
    mount -t tmpfs shmfs -o size=your_size_in_bytes /dev/shm
    and this line to /etc/fstab
    shmfs /dev/shm tmpfs size=your_size_in_bytes 0


i. The parameter STATISTICS_LEVEL must be set to TYPICAL
ii. The parameter MEMORY_MAX_SIZE controls the maximum value you can set for  MEMORY_TARGET. If you do not set a value for this parameter, it defaults to MEMORY_TARGET.
iii. If you set the parameters SGA_TARGET and PGA_TARGET, Oracle will consider the values as the minimum values for SGA and PGA.
iv. If you do not set the parameters SGA_TARGET and PGA_TARGET (or set them to zero), no minimum value is considered by Oracle for the SGA and PGA. When the instance starts, it assigns 60 percent to SGA and 40 percent to the PGA.
v. When MEMORY_TARGET is configured, the following components are auto tuned: DB BUFFER CACHE, SHARED POOL, JAVA POOL, LARGE POOL and STREAMS POOL. software release

1. Starting with Oracle Database 11g Release 2 (, all the 32-bit packages, except for gcc-32bit-4.3, listed in the following table are no longer required for installing a database on Linux x86-64. Only the 64-bit packages are required.

Oracle® Database Installation Guide 11g Release 2 (11.2) for Linux