Tuesday 15 May 2012

OUI-10009 Error while adding Node


OUI-10009: There are no new nodes to add to this installation

Ver - 10.2.0.5
Platform - RHEL

Issue : 

While adding a ASM node we receive the following error

cd $ASM_HOME/oui/bin

./addNodes.sh

OUI-10009: There are no new nodes to add to this installation

Solution :

 Add the ASM Software in the Silent Mode

./addNode.sh -silent "CLUSTER_NEW_NODES={coltdb02}" -logLevel trace -debug

Monday 14 May 2012

Oracle 11g Feature and Option Availability Matrix


The following table outlines the database features and options associated with each edition of
Oracle Database 11g.

FEATURE/OPTION
SE1
SE
EE
NOTES
HIGH AVAILABILITY

Oracle Data Guard Redo Apply
N
N
Y

Oracle Data Guard SQL Apply
N
N
Y

Oracle Data Guard—Snapshot Standby
N
N
Y

Oracle Active Data Guard
N
N
Y
Enterprise Option
(Active Data Guard)
Oracle Data Guard – Network Compression
N
N
Y
Enterprise Option (Advanced Compression Option)
Basic Standby Database (Manually managed)
Y
Y
Y

Rolling Upgrades – Patch Set, Database and O/S
N
N
Y

Fast-Start Fault Recovery
N
N
Y

Online index rebuild
N
N
Y

Online index-organized table reorganization
N
N
Y
via ALTER TABLE MOVE ONLINE
Online table redefinition
N
N
Y
via DBMS_REDEFINITI ON
Online system changes CPU, disk, memory
Y
Y
Y

Flashback Query
Y
Y
Y

Flashback Table
N
N
Y

Flashback Database
N
N
Y

Flashback Transaction
N
N
Y

Flashback Transaction Query
N
N
Y

Flashback Data Archive (“Oracle Total Recall”)
N
N
Y
Enterprise Option
Block Level Media Recovery
N
N
Y

Online Backup and Recovery
Y
Y
Y

Incremental Backup and Recovery
Y
Y
Y
EE only: fast incremental backups available via
change tracking
Unused Block Compression in Backups
N
N
Y

Parallel Backup and Recovery
N
N
Y

Default RMAN Compression (BZIP2)
Y
Y
Y

Fast RMAN Compression (ZLIB)
N
N
Y
Enterprise Option (Advanced Compression Option)
Point-in-time Tablespace Recovery
N
N
Y

Trial Recovery
N
N
Y

Oracle Fail Safe
Y
Y
Y
Windows only
Data Recovery Advisor
Y
Y
Y

Transaction Application Failover
Y
Y
Y

PERFORMANCE & SCALABILITY

Oracle Real Application Clusters
N
Y
Y
Enterprise Option, and included with SE
Oracle Clusterware
Y
Y
Y

Automatic Workload Management
N
Y
Y
Requires RAC
Support for Oracle Exadata Storage Server
N
N
Y

In-Memory Database Cache
N
N
Y
Enterprise Option
SECURITY




Oracle Advanced Security
N
N
Y
Enterprise Option
Oracle Label Security
N
N
Y
Enterprise Option
Data Masking Pack
N
N
Y
Enterprise Option
Encryption Toolkit
Y
Y
Y

Fine Grained Auditing
N
N
Y

Secure Application Role
N
N
Y

DEVELOPMENT PLATFORM

Java Support
Y
Y
Y

Database Web Services
Y
Y
Y

SQLJ
Y
Y
Y

JDBC Drivers
Y
Y
Y

XML Support in Database
Y
Y
Y
Includes Binary XML, XML Object- Relational, XML Index, XML Repository
XQuery
Y
Y
Y

Objects and Extensibility
Y
Y
Y

Regular Expressions
Y
Y
Y

PL/SQL Stored Procedures and Triggers
Y
Y
Y

PL/SQL Server Pages
Y
Y
Y

Java Server Pages
Y
Y
Y

Java Native Compilation
Y
Y
Y

PL/SQL Native Compilation
Y
Y
Y

PL/SQL Function Result Cache
N
N
Y

Client Side Query Cache
N
N
Y

Oracle Developer Tools for Visual Studio Net
Y
Y
Y
Windows Only
Microsoft Distributed Transaction Coordinator Support
Y
Y
Y
Windows Only
Active Directory Integration
Y
Y
Y
Windows Only
Native .NET Data Provider ODP.NET
Y
Y
Y
Windows Only
.NET Stored Procedures
Y
Y
Y
Windows Only
Globalization Support
Y
Y
Y

Application Express
Y
Y
Y

SQL*Plus
Y
Y
Y

SQL Developer
Y
Y
Y

MANAGEABILITY

Oracle Change Management Pack
N
N
Y
Enterprise Option
Oracle Configuration Management Pack
N
N
Y
Enterprise Option
Oracle Diagnostic Pack
N
N
Y
Enterprise Option
Oracle Tuning Pack
N
N
Y
Enterprise Option
Oracle Provisioning and Patch Automation Pack
N
N
Y
Enterprise Option
Fast, Lightweight Server Install
Y
Y
Y

Easy Client Install
Y
Y
Y

Oracle Enterprise Manager Database Control
Y
Y
Y

Automatic Memory management
Y
Y
Y

Automatic Storage management
Y
Y
Y

Automatic Undo management
Y
Y
Y

Automatic Statistics management
Y
Y
Y

Server Managed Backup and Recover (RMAN)
Y
Y
Y

Automatic Backup/Recovery to Flash Recovery Area
Y
Y
Y

Duplexed Backup Sets
N
N
Y

Server-Generated Alerts
Y
Y
Y

End-to-End Application Testing
Y
Y
Y

Database Resource Manager
N
N
Y

SQL Plan Management
N
N
Y

Resumable Space Allocation
Y
Y
Y

VLDB, DATA WAREHOUSING, BUSINESS INTELLIGENCE

Oracle Partitioning
N
N
Y
Enterprise option
Oracle OLAP
N
N
Y
Enterprise option
Oracle Data Mining
N
N
Y
Enterprise option
Direct Load Data Compression
N
N
Y

OLTP Compression
N
N
Y
Enterprise Option (Advanced Compression Option)
SQL Analytics Functions
Y
Y
Y

Bitmapped index and Bitmapped Join Index
N
N
Y

Function-Based Index
Y
Y
Y

Parallel Query/DML
N
N
Y

Parallel Statistics Gathering
N
N
Y

Parallel Index Build/Scans
N
N
Y

Parallel Data Pump Export/Import
N
N
Y
SE Non-Parallel Data
Pump only
Data Pump Compression
N
N
Y
Enterprise Option (Advanced Compression Option)
Export Transportable Tablespace, including Cross-Platform
N
N
Y

Import Transportable Tablespace
Y
Y
Y

Star Query Transformation
Y
Y
Y
SE B-Tree Indexes
Only
Sample Scan
Y
Y
Y

Summary Management – Materialized View Creation and Refresh
Y
Y
Y

Summary Management Materialized View Query Rewrite
N
N
Y

Direct Path Load API
Y
Y
Y

External Tables
Y
Y
Y

SQL Model
Y
Y
Y

Synchronous Change Data Capture
Y
Y
Y

Asynchronous Change Data Capture
N
N
Y

Query Rewrite Cache
N
N
Y

INTEGRATON

Oracle Streams
Y
Y
Y
SE1/SE no Asynchronous Capture from Log File (Online Redo or Archive)
Oracle Streams Advanced Queuing
Y
Y
Y

Messaging Gateway
N
N
Y

Basic Replication
Y
Y
Y
Read only and updateable materialized views. Also single master for updateable MVs and multi-tier MVs.
Advanced replication
N
N
Y
Multi-Master
Replication
Distributed Queries/Transactions
Y
Y
Y

Job Scheduler
Y
Y
Y

External Procedures
Y
Y
Y

Generic Connectivity
Y
Y
Y

Transparent Gateways
Y
Y
Y
Licensed separately for SE/EE
NETWORKING

Connection Pooling
Y
Y
Y

Oracle Connection manager
N
N
Y

Infiniband Support
N
N
Y

CONTENT

Oracle Spatial
N
N
Y
Enterprise Option
Semantic Technologies (RDF/OWL)
N
N
Y
Requires Spatial, Advanced Compression and Partitioning Options
Oracle Locator
Y
Y
Y

Oracle Workspace manager
Y
Y
Y

Medial Images (DICOM)
Y
Y
Y

Multimedia
Y
Y
Y

Oracle Text
Y
Y
Y

SecureFiles
Y
Y
Y
Compression, deduplication are part of an Enterprise Option (Advanced Compression
Option). Encryption is part of an Enterprise Option (Advanced Security Option)
ADDITIONAL DATABASE FEATURES

Database Event Triggers
Y
Y
Y

Drop Column
Y
Y
Y

Rename Column, Constraint
Y
Y
Y

Virtual Column
Y
Y
Y
Use of virtual columns as primary keys or foreign keys require EE and Oracle Partitioning Option
Invisible Indexes
Y
Y
Y

Index-Organized Tables
Y
Y
Y

Instead-of Triggers
Y
Y
Y

LOB (Large Object) Support
Y
Y
Y

LogMiner
Y
Y
Y

Multiple Block Size Support
Y
Y
Y

Temporary Table
Y
Y
Y