Boa tarde,
A Oracle repetiu hoje, 01/09/2009, a dose e liberou para o download a versão do 11g R2 (11.2.0.1) somente para linux 32 bits e 64 bits. A documentação no site da OTN ainda não atualizada, mas em breve o R2 vai estar disponível para todos os outros S.O, assim como o seu antecessor 11gR1.
Para os que gostam, podem fazer o download no link
http://www.oracle.com/technology/software/products/database/oracle11g/112010_linuxsoft.html
Ficamos no aguardo para das versões para Solaris/HP-UX/AIX e Windows para download.
Uma das coisas que me chamou a atenção foi o “Enabling of online application upgrades”.
“Oracle Database 11g Release 2’s edition based redefinition feature lets you upgrade applications while users remain connected to their business applications.”
O online upgrade no 11g R1 era apenas para patches específicos, isso frustrou muitos DBA’s, agora é anunciado o “Zero Downtime Patching for Oracle Clusterware and Oracle RAC”
“The patching of Oracle Clusterware and Oracle Real Application Clusters can now be completed without taking the entire cluster down. Patchsets are now installed as out-of-place upgrades to the Oracle Grid infrastructure for a cluster software (Oracle Clusterware and Automatic Storage Management) and Oracle Database.”
Now you can reduce your unplanned downtime of clustered databases and applications running in a cluster.
Segue abaixo a listagem das features inclusas no 11g R2
SQL
* Attribute Extraction of Requested Attributes Only of DICOM metadata.
PL/SQL and XML
# Support WITH HOLD Option for CURSOR DECLARATION in Pro*C.
# JDBC Support for Time Zone Patching.
# OCI Support for 8-Byte Integer Bind/Define.
# Pro*C Support for 8-Byte Native Numeric Host Variable for INSERT and FETCH.
# Pro*COBOL Support for 8-Byte Native Numeric Host Variable for INSERT and FETCH
# Binary XML Enhancements.
# Oracle XML DB Repository Performance Improvements and Guidelines.
# XMLIndex Enhancements. · XMLType Partitioning.
# JDBC Support for SecureFile Zero-Copy LOB I/O and LOB Prefetching.
ASM
# ASM Cluster File System (ACFS)
# ASM Dynamic Volume Manager (DVM)
# ASM FS Snapshot
# Enterprise Manager Integration for ASM File Access Control.
# Oracle Cluster Registry (OCR) and Voting Disk on ASM.
# ASM Optimal Disk Placement.
# ASMCMD Command Extensions
# Automatic Storage Management (ASM) File Access Control.
COMPRESSION
# New Columnar Table Compression .
CLUSTERING
# Agent Development Framework
# Out-of-Place Oracle Clusterware Upgrade
# Cluster Time Service
# Configuration Assistant Support for Removing Oracle RAC Installations.
# Configuration Assistants Support New Oracle RAC Features.
# Downgrading Database Configured With DBControl.
# Enhanced Cluster Verification Utility.
# Enterprise Manager Provisioning for Oracle Clusterware and Oracle Real Application Clusters
# Enterprise Manager Support for Grid Plug and Play.
# Enterprise Manager Support for Oracle Restart.
# Enterprise Manager-Based Clusterware Resource Management.
# Grid Plug and Play (GPnP).
# Improved Clusterware Resource Modeling.
# Integration of Cluster Verification Utility (CVU) and Oracle Universal Installer (OUI).
# Java API for Oracle RAC FAN High Availability Events.
# Oracle Cluster Registry (OCR) Enhancements.
# Faster relocation of services on node failure.
# Oracle Clusterware now supports up to 5 copies of the OCR for improved availability of the cluster.
# OCR can now be stored in Automatic Storage Management (ASM).
# Oracle Restart Integration with Oracle Universal Installer.
# Oracle Universal Installer Support for Removing Oracle RAC Installations.
# OUI Support for Out-of-Place Oracle Clusterware Upgrade.
# Patch Application with DBControl.
# Policy-Based Cluster and Capacity Management.
# Role-Separated Management – Role-separated management for Oracle Clusterware allows certain administrative
# Server Control (SRVCTL) Enhancements.
# Server Control (SRVCTL) Enhancements to Support Grid Plug and Play.
# SRVCTL Support for Single-Instance Database in a Cluster.
# UCP Integration with Oracle Data Guard.
# UCP Integration with Oracle Real Application Clusters.
# Universal Connection Pool (UCP) for JDBC.
# Zero Downtime Patching for Oracle Clusterware and Oracle RAC. (11gR2
# Database QoS Management Support.
# Database Quality of Service (QoS) Management Server
# Enterprise Manager QoS Management Integration.
PERFORMANCE
# Segment Creation on Demand
# System-Managed Indexes for List Partitioning Tables.
# Zero-Size Unusable Indexes and Index Partitions
AVAILABILITY
# Automatic Block Repair
# Backup to Amazon Simple Storage Service (S3) Using OSB Cloud Computing.
# DUPLICATE Without Connection to Target Database.
# Enhanced Tablespace Point-In-Time Recovery (TSPITR).
# New DUPLICATE Options: (NO REDO, UNDO TABLESPACE
# New SET NEWNAME Clauses and Format Options
# Tablespace Checks in DUPLICATE.
# New Oracle Streams Features (XStream In and XStream In)
SECURITY
# Tablespace Master Key Re-Key
MANAGEABILITY
# Enterprise Manager Support Workbench for ASM.
# New Gateway Support
# EMCA Supports New Oracle RAC Configuration for EM.
# SQL monitoring
# Automatic Patching of Time Stamp with Time Zone Data.
# Prevent Data Loss for Time Zone with Local Time Zone Data Type.
# Enterprise Manager Integration with ASM Optimal Disk Placement.
# Enterprise Manager Support for ASM Cluster File System (ACFS).
BI and DW
# Allow Virtual Columns in the Primary Key or Foreign Key for Reference Partitioning.
# Analytic Functions 2.0.
# EXECUTE Privilege for DIRECTORY Objects.
# In-Memory Parallel Query.
# Minimal Effort Parallel Execution – Auto Degree of Parallelism (DOP) and Queuing.
# Preprocessing Data for ORACLE_LOADER Access Driver in External Tables.
# Recursive WITH Clause.
# Significant Performance Improvement of On-Commit Fast Refresh.
ORACLE WAREHOUSE BUILDER
# Advanced Find Support in Mapping Editor.
# Copy and Paste of Operators and Attributes in Mapping Editor.
# Current Configuration Dropdown Box in Design Center Toolbar.
# Editor Menu Experts.
# Expression Editing in Operator Edit Dialog.
# Foldering and Spotlighting.
# Fusion Client Platform Integration.
# Grouping and Spotlighting of Objects in Mapping Editor.
# Guided Assistance.
# Improved Management of Locations Registered in Multiple Control Centers.
# Improved User Interface for Managing Locations.
# Key Lookup Operator Enhancements.
# Mapping Debugger Enhancements.
# Metadata Import from COBOL Copybooks.
# OMB*Plus Activity Type.
# Operator References Included in Generated PL/SQL Code.
# Quick Mapper.
# Repository Browser Changes.
# Simplified Oracle Warehouse Builder Repository Upgrades.
# Subquery in Join Operator.
# Support for Extracting Data From Tables Containing LONG Data Type.
# Table Functions.
DATA GUARD
# Compressed Table Support in Logical Standby Databases and Oracle LogMiner.
# Configurable Real-Time Query Apply Lag Limit.
# Integrated Support for Application Failover in a Data Guard Configuration.
# Support Up to 30 Standby Databases.
ORACLE SECURE FILES
# LZO Support for SecureFiles
# SecureFiles Archive Manager.
OTHER FEATURES
# Improved data compression.
# SQL Developer is installed with the database server software
# Improvements to Oracle Scheduler
# Data Pump Legacy Mode.
# Complete IPv6 Support for JDBC Thin Clients.
# Complete IPv6 Support for JVM and Java Debuggers.
# IPv6 Support in Oracle Database.
# Enhanced Spatial Support
DESUPPORTED FEATURES
# Oracle export utility (exp). Imp is still supported for backwards compatibility.
# ISQLPlus
fonte: http://oraclenz.com/2009/09/02/finally-oracle-11gr2-is-here/
Forte Abraço,
Rodrigo Mufalani