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.
No comments:
Post a Comment