Monday, September 7, 2009

Oracle database 11gR2 Installation (Linux x86)

The installation guide from Oracle documentation is quite comprehensive already, here are just some add-ons.

You can find the documentation here: http://www.oracle.com/pls/db112/homepage

Looking at the kernel parameters, even Oracle already said these are minimum required values, but I guess still some engineers just do "copy & paste". Be aware "shmmax" now is the minimum value in 11gR2 documentation, instead of 2GB in 10gR2/11gR1.

Kernel parameters in 11gR1 (only different parameter values are highlighted here)

fs.file-max = 512 * PROCESSES
kernel.shmmax = 2147483648
kernel.shmmni = 4096
net.ipv4.ip_local_port_range = 1024 65000
net.core.wmem_max = 262144


Kernel parameters in 11gR2

fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmmax = 536870912
net.ipv4.ip_local_port_range = 9000 65500
net.core.wmem_max = 1048586



Another changes is the OFA name for $ORACLE_HOME, in 9i, Oracle has recommend below similar name for Oracle database home directory:
"/u01/app/oracle/product/9.2.0"

In 10g, because ASM home has been introduced, suggested Oracle home directory becomes: "/u01/app/oracle/product/10.2.0/db_1"

I just did a test with 11gR2, the default suggested Oracle Home directory is "/u01/app/oracle/product/11.2.0/dbhome_1"

Remark: to get Oracle suggested OFA directory, before installation, only set ORACLE_HOME and ORACLE_SID environment values.

Below example shows the default installed options for Enterprise edition:

[oracle@vmxdb02 stage]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Sun Sep 6 10:22:23 2009

Copyright (c) 1982, 2009, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production



SQL> select comp_name, version, status from dba_registry;

COMP_NAME VERSION STATUS
-------------------------------------------------- -------------------- ----------
OWB 11.2.0.1.0 VALID
Oracle Application Express 3.2.1.00.10 VALID
Oracle Enterprise Manager 11.2.0.1.0 VALID
OLAP Catalog 11.2.0.1.0 VALID
Spatial 11.2.0.1.0 VALID
Oracle Multimedia 11.2.0.1.0 VALID
Oracle XML Database 11.2.0.1.0 VALID
Oracle Text 11.2.0.1.0 VALID
Oracle Expression Filter 11.2.0.1.0 VALID
Oracle Rules Manager 11.2.0.1.0 VALID
Oracle Workspace Manager 11.2.0.1.0 VALID

COMP_NAME VERSION STATUS
-------------------------------------------------- -------------------- ----------
Oracle Database Catalog Views 11.2.0.1.0 VALID
Oracle Database Packages and Types 11.2.0.1.0 VALID
JServer JAVA Virtual Machine 11.2.0.1.0 VALID
Oracle XDK 11.2.0.1.0 VALID
Oracle Database Java Packages 11.2.0.1.0 VALID
OLAP Analytic Workspace 11.2.0.1.0 VALID
Oracle OLAP API 11.2.0.1.0 VALID

18 rows selected.

SQL> select * from v$option order by 2
2 /

PARAMETER VALUE
---------------------------------------- ----------
Real Application Clusters FALSE
Oracle Database Vault FALSE
Oracle Label Security FALSE
Automatic Storage Management FALSE
Partitioning TRUE
Objects TRUE
Advanced replication TRUE
Bit-mapped indexes TRUE
Connection multiplexing TRUE
Connection pooling TRUE
Database queuing TRUE

PARAMETER VALUE
---------------------------------------- ----------
Incremental backup and recovery TRUE
Instead-of triggers TRUE
Parallel backup and recovery TRUE
Parallel execution TRUE
Parallel load TRUE
Point-in-time tablespace recovery TRUE
Fine-grained access control TRUE
Proxy authentication/authorization TRUE
Change Data Capture TRUE
Plan Stability TRUE
Online Index Build TRUE

PARAMETER VALUE
---------------------------------------- ----------
Coalesce Index TRUE
Managed Standby TRUE
Materialized view rewrite TRUE
Materialized view warehouse refresh TRUE
Database resource manager TRUE
Spatial TRUE
Export transportable tablespaces TRUE
Transparent Application Failover TRUE
Fast-Start Fault Recovery TRUE
Sample Scan TRUE
Duplexed backups TRUE

PARAMETER VALUE
---------------------------------------- ----------
Java TRUE
OLAP Window Functions TRUE
Block Media Recovery TRUE
Fine-grained Auditing TRUE
Application Role TRUE
Enterprise User Security TRUE
Oracle Data Guard TRUE
OLAP TRUE
Basic Compression TRUE
Join index TRUE
Trial Recovery TRUE

PARAMETER VALUE
---------------------------------------- ----------
Data Mining TRUE
Online Redefinition TRUE
Streams Capture TRUE
File Mapping TRUE
Block Change Tracking TRUE
Flashback Table TRUE
Flashback Database TRUE
Transparent Data Encryption TRUE
Backup Encryption TRUE
Unused Block Compression TRUE
Result Cache TRUE

PARAMETER VALUE
---------------------------------------- ----------
SQL Plan Management TRUE
SecureFiles Encryption TRUE
Real Application Testing TRUE
Flashback Data Archive TRUE
DICOM TRUE
Active Data Guard TRUE
Server Flash Cache TRUE
Advanced Compression TRUE
XStream TRUE
Deferred Segment Creation TRUE

65 rows selected.