1. Index

Index

Symbols  A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  

Symbols

  • $ORACLE_HOME/root.sh script 9.3

A

  • abnormal instance termination 3.2.2
  • ACCHK
    • Application Continuity Protection Check 6.5
  • ACMS
    • Atomic Controlfile to Memory Service 1.5.7
  • ACTIVE_INSTANCE_COUNT initialization parameter 3.7
  • Active Session History
  • active sessions 14.8.1
  • adding nodes to an existing cluster 10.1
  • adding Oracle RAC to nodes on Linux and UNIX 11.1
  • adding Oracle RAC to nodes on Windows 12.1
  • ADDM
    • global monitoring 14.7
    • see Automatic Database Diagnostic Monitor 14.9.2
  • ADDM for Oracle Real Application Clusters mode 14.7
  • administering
  • administering instances
    • with Server Management 3.1.1
  • administering Oracle Enterprise Manager jobs 3.13.3.1
  • administering services
    • Oracle Enterprise Manager 5.11
    • SRVCTL 5.11
  • administrative tools
    • overview and concepts 1.12.2
  • administrator-managed database 3.1
    • relocating services in 5.4.5
  • administrator-managed database instances
  • administrator-managed databases 1.7, 5.10.2.5
    • AVAILABLE instances for services 5.10.2.5
    • converting to policy-managed 3.8
    • PREFERRED instances for services 5.10.2.5
  • ADRCI
    • ADR Command-Line Interpreter B.2
  • Advanced Queuing
  • Advisor Central in Oracle Enterprise Manager 14.7
  • affinity 5.5
  • aggregates
  • alert administration
  • alert blackouts
  • alert logs B.3
  • ALTER SYSTEM ARCHIVE LOG CURRENT statement 3.1.1.3.1
  • ALTER SYSTEM ARCHIVE LOG statement 3.1.1.3.1
  • ALTER SYSTEM CHECKPOINT statement
  • ALTER SYSTEM KILL SESSION statement
    • terminating a session on a specific instance 3.5
  • ALTER SYSTEM QUIESCE RESTRICTED statement
    • quiescing a noncluster database 3.10
  • ALTER SYSTEM statement
  • ALTER SYSTEM SWITCH LOGFILE statement 3.1.1.3.1
  • Application Continuity 6, 6.4
    • auto session state consistency 6.6.6.1
    • commit outcome 6.4.1
    • concepts 6.4.1
    • configuring connections 6.6.2.3
    • configuring service attributes 5.11.3.2
    • database request 6.4.1
    • delaying reconnection 6.6.2.6
    • described 6.6.1
    • dynamic session state consistency 6.6.6.2
    • establishing initial state 6.6.2.5
    • introduction to 1.6
    • mutable functions 6.4.1
    • potential side effects 6.7
    • protection-level statistics 6.6.5
    • recoverable error 6.4.1
    • restoring state settings 6.6.2.5.1
    • restrictions 6.8
    • running without 6.6.2.8
    • session state consistency 6.4.1
    • static session state consistency 6.6.6.3
    • using for planned maintenance 6.6.2.7
  • Application Continuity Protection Check 6.5.1
  • applications
    • consolidating multiple in a single database 13.1.3
    • highly available 13.1
    • scalability 13.1.4
    • spanning XA transactions across Oracle RAC instances 5.4.1
    • using pre-created database sessions 5.3.7
  • ARCHIVE_LAG_TARGET initialization parameter 3.7.3
  • archived redo log files
    • applying in parallel 8.5.1
    • file format and destination 7.8
    • log sequence number 7.8
  • ARCHIVE LOG command
  • archive logs
    • destinations, converting to cluster database 15.1
  • archiver process
  • archiving mode
  • ASH reports 14.8.1
  • ASM_PREFERRED_READ_FAILURE_GROUPS initialization parameter 2.6.4, 3.7
  • asmlistener A.9.38, A.9.39
  • Atomic Controlfile to Memory Service (ACMS) 1.5.7
  • Automatic Database Diagnostic Monitor (ADDM) 1.12.3, 14.7, 14.9.2, 14.9.3.2, 14.9.5
    • analyzing AWR data 14.7
    • DBMS_ADDM PL/SQL package 14.7
    • DBMS_ADVISOR PL/SQL package 14.7
    • Global ADDM mode 14.7
    • Local ADDM mode 14.7
  • Automatic Diagnostic Repository (ADR) 13.4.1, 13.4.3, B.2
    • ADRCI command-line interpreter B.2
  • automatic load balancing
    • configuring RMAN channels for multiple instances 7.6
  • AUTOMATIC management policy 3.2.1
  • Automatic Performance Diagnostics (AWR)
    • monitor performance statistics 14.7
  • automatic segment space management (ASSM) 13.3.1
    • tablespace use in Oracle RAC 13.3.1
  • automatic undo management
    • tablespace use in Oracle RAC 13.3.1
  • automatic workload management
  • Automatic Workload Repository (AWR) 1.6, 5.6, 5.7, 14.7, 14.9, 14.9.3.2
  • AVAILABLE instances
  • Average Active Sessions chart
  • AWR
    • see Automatic Workload Repository (AWR) 14.9.3.2

B

  • background processes
  • background thread trace files B.1
  • backups
    • and converting to cluster database 15.1
    • server parameter file 3.6.3
  • bandwidth
  • best practices
    • deploying Oracle RAC for high availability 13.1.2
  • blackouts
  • block mode conversions
    • statistics for 14.6
  • blocks
    • associated with instance 8.3.1
  • buffer cache 1.5.6
    • instance recovery 8.3.1
  • buffer sizes
    • interprocess communication (IPC)
      • adjusting for Oracle RAC 14.3

C

  • cache coherency 14.9.3.1
  • Cache Fusion 1.5.6, 13.3.5
  • callouts
    • how they are run 6.2
  • capacity
  • cardinality 3.1
  • catclustdb.sql script 1.12.3
  • CDBs 1.10, 3.3
  • changing the configuration of all services 4.2.1
  • channels
    • configure one RMAN channel for each Oracle RAC instance 7.6.2
    • configuring during crosscheck or restore operations 7.5
    • configuring for RMAN 7.6
  • charts
  • checking the interconnect B.6
  • client connections with SCAN 3.1
  • client drivers
  • clients
    • application environments and FAN 5.3
    • integrated for FAN events 6.1.1
    • JDBC/OCI 5.3.2.2
    • JDBC-thin driver 5.3.2
  • client-side load balancing 5.1, 5.1.4
  • clone.pl 9.4
  • clone.pl script
    • cloning parameters 9.3
    • environment variables 9.3
  • cloning 1.2.4, 9
    • deployment phase 9.3
    • log files 9.4
    • parameters passed to the clone.pl script 9.3
    • preparation phase 9.2
    • running $ORACLE_HOME/root.sh script 9.3
  • cluster
    • definition of 1.1
  • cluster_database 13.4.1
  • CLUSTER_DATABASE_INSTANCES initialization parameter 3.7, 3.7.3
  • CLUSTER_DATABASE initialization parameter 3.7, 3.7.1
  • CLUSTER_INTERCONNECTS
  • CLUSTER_INTERCONNECTS initialization parameter 3.7, 3.11.1
  • cluster administrator 3.1
  • cluster cache coherency 14.1.1.2
  • cluster configuration policy 1.7.4
  • cluster configuration policy set 1.7.4
  • Cluster Database Performance page
  • cluster databases
  • clustered Oracle ASM
    • converting a noncluster Oracle ASM 2.6.5
  • cluster file system
    • archiving parameter settings 7.9.1.2
    • archiving scenario 7.9.1
    • restore 8.2.1
    • storage in Oracle RAC 2.1
  • Cluster Host Load Average page
  • cluster nodes name
    • in clone.pl script 9.3
  • clusters
    • consolidating multiple databases in 13.1.3
    • policy-managed 1.7.4
  • Cluster Verification Utility
    • overview and concepts 1.12.2
  • clusterware management solution 1.4
  • cold backups 3.10
  • comma-delimited lists with SRVCTL A.1
  • command-line interpreter
    • ADR Command-Line Interpreter (ADRCI) B.2
  • committed data
  • communication protocols
    • verifying settings for 14.2
  • compatibility
    • Oracle RAC and Oracle Database software 1.2.1
  • COMPATIBLE initialization parameter 3.7.1
  • configuring channels
    • during restore or crosscheck operations 7.5
  • configuring preferred mirror read disks in extended clusters 2.6.4
  • CONNECT command 3.1.1.3.1
  • connecting
  • connection load balancing
  • connection pools
  • connection tests 6.3.3
  • CONNECT SYS
  • consistent blocks 1.5.6
  • container databases
    • See: CDBs
  • CONTROL_FILES initialization parameter 3.7.1
  • converting a database from Oracle RAC One Node to Oracle RAC 4.2.2
  • converting an Oracle RAC database with one instance to Oracle RAC One Node 4.2.1
  • convert to cluster database
    • from single-instance to Oracle Real Application Clusters 15
    • post-conversion 15.3
    • to Oracle RAC from single-instance databases 15
  • convert to Oracle RAC database
    • from non-cluster system 15.2.1
  • corrupted data blocks B.2
  • CREATE PFILE
    • FROM MEMORY clause 3.6
  • CREATE PFILE statement 3.6.3
  • CREATE SPFILE
    • FROM MEMORY clause 3.6
  • creating
  • crosschecking on multiple nodes
    • RMAN backups 7.5
  • crosscheck operations
    • configuring channels during 7.5
  • CRS resources
    • management of 1.4
  • current blocks 1.5.6
  • CVU
    • See: Cluster Verification Utility

D

  • database
    • administrative privilege
    • draining 6.3.3
    • services
    • SRVCTL object name A.9
  • database alert logs 13.4.3
  • database cloud 13.1.3.3
  • Database Configuration Assistant (DBCA)
    • adding and deleting instances in interactive mode
    • adding and deleting instances in silent mode
    • adding instances in interactive mode
    • adding instances in silent mode
    • cloning Oracle RAC instances 9.3
    • creating views for Oracle Real Application Clusters 14.5
    • Database Storage page 11.1.2.1, 12.1.1.1
    • deleting instances in interactive mode
    • deleting instances in silent mode
    • Instance Management page 11.1.2.1, 12.1.1.1
    • List of Cluster Databases page 11.1.2.1, 12.1.1.1
    • running the catclustdb.sql script 1.12.3
    • Welcome page 11.1.2.1
  • database deployment
  • database instances
  • database pools 13.1.3.3
  • database resource 3.1
  • Database Resource Manager 3.10
  • database role 3.2.1
  • databases
    • administrator managed 5.10.2.5
    • consolidating multiple in a cluster 13.1.3
    • controlling restarts 3.12
    • creating
      • Oracle RAC One Node 4.1
    • Oracle RAC One Node
      • services on 4.1
    • policy managed 3.1, 5.10.2.7
    • scalability 13.1.4
  • databases sessions
  • Database Storage page 11.1.2.1, 12.1.1.1
  • Database Throughput page
  • data-dependent routing 5.5
  • data dictionary
    • querying views 14.5
  • Data Recovery Advisor B.2
  • data security
  • data warehouse
    • deploying applications for in Oracle RAC 13.3.7
  • data warehouse systems 13.3.7
  • DB_BLOCK_SIZE initialization parameter 3.7.1
  • DB_DOMAIN initialization parameter 3.7.1
  • DB_FILES initialization parameter 3.7.1
  • DB_NAME initialization parameter 3.7, 3.7.1
  • DB_RECOVERY_FILE_DEST_SIZE initialization parameter 3.7.1
  • DB_RECOVERY_FILE_DEST initialization parameter 3.7.1, 8.6
  • DB_UNIQUE_NAME initialization parameter 3.7.1
  • DDL statements 13.3.2
  • default database service 1.2.3, 3.7, 5.11.1
  • degree of parallelism 13.3.7.1
  • deleting administrator-managed database instances 11.2.1, 12.2.1
  • dependencies
  • deploying
    • Oracle Real Application Clusters environments 1.12.1, 13
  • deprecated features
  • design
    • Oracle Real Application Clusters environments 1.12.1, 13
  • diagnosing problems for Oracle RAC B
  • diagnosing problems using ADR B.2
  • diskgroup
    • SRVCTL object name A.9
  • DISPATCHERS initialization parameter 3.7
    • specifying a service with 5.11.1
  • Distributed Transaction Processing (DTP) 13.3.4
    • See: DTP
  • distributed transactions 13.3.4
    • directing to a single instance in the cluster 5.4.2
    • services in Oracle RAC 5.4.1
    • XA transactions span instances 5.4.1
  • DML_LOCKS initialization parameter 3.7.1
  • draining database sessions 6.3.3
  • DTP 5.4
  • DTP service. 5.4.2
  • dynamic database services
    • description 1.6
  • Dynamic Database Services
  • dynamic performance views 14.9
  • dynamic resource allocation
  • dynamic session state consistency 6.6.6

E

  • e-commerce
    • applications in Oracle RAC 13.3.5
  • edition
  • ENCRYPTION_WALLET_LOCATION parameter 13.3.8.1
  • Enterprise Manager
  • environment variables
    • passed to the clone.pl script 9.3
    • setting with SRVCTL 3.1.1.1
  • evaluating block transfers 14.6
  • event notification
  • extended distance clusters 2.6.4
    • configuring preferred mirror read disks 2.6.4
    • Oracle ASM preferred mirror read 2.6.4
  • extending Oracle database home
  • external transaction managers

F

  • FAILOVER_RESTORE
  • failure
  • failure groups 2.6.4
  • FAN
    • See: Fast Application Notification (FAN)
  • Fast Application Notification (FAN) 6.1
    • and high availability events 6.1.2
    • callouts
    • events
      • enabling for JDBC 5.3.2.2
      • enabling for JDBC-thin clients 5.3.2
      • enabling for OCI 5.3.6
      • enabling for ODP.NET 5.3.9
      • enabling ODP.NET clients 5.3.10
    • HA events 5.3.1
    • how events are published 6.1.1
    • introduction 1.6
    • overview 6.1.1
    • parameters and matching database signatures 6.1.2
    • uses 6.1.1
  • Fast Connection Failover (FCF)
    • enabling JDBC-thin clients 5.3.2
    • enabling with thin and thick clients 5.3.2.2
    • introduction to 1.6
  • fault diagnosability B.2
  • FCF
    • See: Fast Connection Failover (FCF)
  • files
    • archived redo log files 7.8
    • redo log 7.8
  • FROM MEMORY clause
    • on CREATE PFILE or CREATE SPFILE 3.6

G

  • GC_SERVER_PROCESSES initialization parameter
    • specifying the number of LMSn processes 13.1.3.2
  • GCS_SERVER_PROCESSES initialization parameter 3.7
  • GCS protocol 14.9.3.1
  • Generic server pool 3.1
  • GES
    • See: global cache and enqueue service (GES)
  • GLOBAL_TXN_PROCESSES initialization parameter 5.4.1
  • global cache and enqueue service (GES) 14.9.1
  • Global Cache Block Access Latency chart
  • Global Cache Service (GCS) 1.5.6, 3.7
  • Global Cache Service Process (LMS) 1.5.7
  • Global Cache Service Processes (LMSn)
  • Global Cache Service statistics 14.9.1, 14.9.3.1
  • GLOBAL clause
  • Global Enqueue Service (GES) 1.5.6
  • Global Enqueue Service Daemon (LMD) 1.5.7
  • Global Enqueue Service Monitor (LMON) 1.5.7
  • Global Enqueue Service statistics 14.9.1
  • global performance data
  • Global Resource Directory (GRD) 1.5.6
  • global service attributes
  • global services 5.12, 13.1.3.3
  • Global Transaction Process (GTX0-j) 1.5.7
  • goals
    • and the load balancing advisory 5.2.1
    • for load balancing advisory 5.2.2
  • GTX0-j
    • Global Transaction Process 1.5.7
  • GV$ 1.12.3
  • GV$SESSION 3.5
  • GV$ view 14.4

H

  • Hang Manager 1.9, 13.4
  • hash partitioning
    • with Oracle RAC 13.2
  • high availability
    • best practices 13.1.2
    • for Oracle RAC Databases 13.1
  • high availability framework
    • introduction to 1.6
  • home
    • SRVCTL object name A.9
  • HOST command 3.1.1.3.1

I

  • idempotence 6.9
  • idle wait class 14.8.1
  • IM column store
    • See: In-Memory Column Store
  • indexes
    • sequence-based 13.2
  • initialization parameters
    • CLUSTER_INTERCONNECTS 3.11.1, 14.3
      • recommendations for using 3.11.1
    • cluster database issues regarding 3.7
    • identical settings for on all instances 3.7.3
    • RECOVERY_PARALLELISM 8.5.2.1
    • settings for instances 3.6
    • specific to Oracle RAC 3.7
    • that must be identical on all instances 3.7.1
    • that must be unique on all instances 3.7.2
  • In-Memory Column Store
  • In-Memory FastStart 1.11
  • INST_ID column 14.4
  • installations
    • performing multiple simultaneous cluster 9
  • instance
    • SRVCTL object name A.9
  • INSTANCE_NAME initialization parameter 3.7.2
  • INSTANCE_NUMBER initialization parameter 3.7.2
  • INSTANCE_TYPE initialization parameter 3.7.1
  • instance discovery
    • Oracle Enterprise Manager Cloud Control 3.13.1
  • Instance Enqueue Process (LCK0) 1.5.7
  • Instance Management page 11.1.2.1, 12.1.1.1
  • INSTANCE NAME initialization parameter 3.7
  • INSTANCE option 3.1.1.3.1
  • instance recovery 3.2.2
  • instances
    • aggregated for service performance 14.1.1.3
    • cloning Oracle RAC 9.3
    • effect of SQL*Plus commands on 3.1.1.3.1
    • failure 8.3.2
    • initialization parameter settings 3.6
    • maximum number for Oracle RAC 1.1
    • memory structures 1.5.6
    • parallel processes 5.10.1.4
    • private interconnect usage B.6
    • recovery 3.2.2, 8.3.1
    • recovery, abnormal shutdown 3.2.2
    • recovery, multiple failures 8.3.2
    • Server Management 3.1.1
    • shutting down 3.2.2
    • starting and stopping 3.2
    • terminating session on 3.5
    • verifying 3.4
    • verifying running 3.4.2
  • instances failure
    • recovery from 8.3
  • instead of Statspack 1.12.3
  • interconnect
    • and performance 14.3
    • and the Oracle RAC architecture 1.1
    • defined 1.5.2
    • protocols for Oracle RAC 14.2
    • verifying settings for 14.2
  • interconnect bandwidth 14.2
  • interconnect block transfer rates 14.6
  • interconnects
    • alternatives to the private network 3.11
    • private B.6
  • interconnect settings
  • Interconnects page
    • monitoring clusterware with Oracle Enterprise Manager 14.1.1
    • monitoring Oracle Clusterware 14.1.1.2
  • interprocess communication (IPC)
    • buffer sizes
  • IPC protocol 14.2, 14.9.3.1

J

  • Java-based tools and utilities
  • Java Database Connectivity (JDBC) clients
    • Oracle Notification Service usage 1.6
  • JDBC
    • enabling Fast Application Notification events for 5.3.2.2
  • JDBC/OCI 5.3.2.2
  • JDBC-thin clients
    • enabling for Fast Connection Failover (FCF) 5.3.2
  • JDBC-thin driver 5.3.2
  • job administration

K

  • keystore
  • KILL SESSION clause
    • on the ALTER SYSTEM statement 3.5

L

  • LCK0
    • Instance Enqueue Process 1.5.7
  • level thresholds
  • LICENSE_MAX_USERS initialization parameter 3.7.3
  • listener
    • SRVCTL object name A.9
  • listeners
  • List of Cluster Databases page 11.1.2.1, 12.1.1.1
  • LMD
    • Global Enqueue Service Daemon 1.5.7
  • LMON Global Enqueue Service Monitor 1.5.7
  • LMS
    • Global Cache Service Process 1.5.7
  • LMSn processes
  • LMS processes
  • load balancing 13.3.5
    • OCI runtime connection 5.3.7
    • server-side 5.1
  • load balancing advisory
    • and FAN events 5.2.3
    • configuring your environment for using 5.2.2
    • deployment 5.2.1
    • description of 5.2
    • events and FAN 6.1.1
    • introduction to 1.6
  • Load Balancing Advisory 5.10.2.8
  • LOCAL_NODE parameter
    • in clone.pl script 9.3
  • local archiving scenario
  • Local Area Network (LAN) 1.5.2
  • LOCAL clause
  • local file system
  • local instance
  • locally managed tablespaces 13.3.1
  • local node name
    • in clone.pl script 9.3
  • local temporary tablespace 1.4.3
  • LOG_ARCHIVE_FORMAT initialization parameter 3.7.3
  • LOG_ARCHIVE_FORMAT parameter 7.8
  • log files
  • logical transaction ID 6.9
  • log sequence numbers 7.8
  • LXTID 6.9

M

  • maintenance
  • mass deployment
  • media failures
    • recovery from 8.4
  • Memory Guard 3.9
  • memory pressure 3.9
  • memory structures
  • message request counters 14.6
  • migration
  • missing files B.2
  • mission critical systems
    • considerations for Oracle RAC 13.1.1
  • modified data
    • instance recovery 8.3.1
  • monitoring
    • archiver process 7.10
    • overview and concepts 1.12.3
    • performance of global cache block access 14.1.1.3
  • monitoring host load average 14.1.1.3
  • mount all non-running instances of an Oracle RAC database 3.2.1
  • multiple cluster interconnects 3.11
  • multiple databases in a cluster 3.11.1
  • multiple instances
    • starting from a single SQL*Plus session 3.2.4
    • starting from one node 3.2.4
  • multiple node failures 8.3.2
  • multiple public networks 1.5.4
  • multiplexed redo log files 2.4
  • multitenant container database
    • See: CDBs
  • mutable functions 6.6.3
  • mutables

N

  • net service name 3.1.1.3
  • network
    • restricting service registration 1.5.5, 5.10.4
    • SRVCTL object name A.9
  • Network Attached Storage (NAS) 1.5.2
  • network file system 2.3
    • See also: NFS
  • network resources 1.5.4
  • NFS
  • node
    • failure and VIP addresses 1.5.4
  • node affinity awareness 8.3.4
  • nodeapps
    • SRVCTL object name A.9
  • node discovery
    • Oracle Enterprise Manager Cloud Control 3.13.1
  • node evictions 14.1.1.1
  • nodes
    • affinity awareness 8.3.4
    • failure of 8.3.1
    • virtual IP addresses A.4
  • node VIPs 1.5.4
  • noncluster databases
  • noncluster Oracle ASM
    • converting to clustered Oracle ASM 2.6.5
  • non-transactional session state 6.6.6.3
  • noreplay keyword (terminating or disconnecting session) 6.6.2.10

O

  • object creation and deletion 13.3.2
  • objects
    • creation of and effect on performance 13.3.2
  • OCI
    • runtime connection load balancing 5.3.7
    • session pooling 5.3.7
    • session pools
      • optimizing 5.3.7
      • runtime connection load balancing 5.3.7
      • service metrics 5.3.7
  • OCRDUMP utility 14.3
  • ODP.NET
    • and Fast Connection Failover 5.3.9
    • load balancing advisory events 5.3.10
  • OLTP environments 13.2
  • online database relocation
    • relocation feature 4.3
  • online recovery 8.3.1
  • online transaction processing (OLTP)
    • applications in Oracle RAC 13.3.5
  • ons
    • SRVCTL object name A.9
  • ONS
    • See: Oracle Notification Service
  • optimal execution plans 13.3.7.1
  • Oracle ACFS 1.5.1
  • Oracle ASM
    • disk group management 2.6.3
    • listener A.9.38, A.9.39
    • see Oracle Automatic Storage Management (Oracle ASM) 2.1
  • Oracle Automatic Storage Management (Oracle ASM) 2
    • archiving scenario 7.9.1
    • converting noncluster Oracle ASM to clustered Oracle ASM 2.6.5
    • installation 1.2.3
    • instances
      • administering with SRVCTL 2.6.6
    • Oracle ASM preferred read failure groups 2.6.4
    • preferred mirror read disks 2.6.4
    • preferred read disks 3.7
    • storage solution 2.1
  • Oracle Call Interface
    • See: OCI
  • Oracle Cluster Registry (OCR) 3.1.1.1, 14.3
  • Oracle Clusterware
    • cloning 1.2.4
    • controlling database restarts 3.12
    • control policies
      • AUTOMATIC 3.12
      • MANUAL 3.12
      • using SRVCTL to display and change 3.12
    • described 1.4
    • introduction 1.4
    • introduction and concepts of 1
    • managing Oracle processes 1.4
  • Oracle Database
  • Oracle Database QoS Management 1.8
  • Oracle Database Quality of Service Management
    • See: Oracle Database QoS Management
  • Oracle Database Upgrade Assistant 15
  • Oracle Enterprise Manager
    • adding database instances to nodes
    • alert administration 3.13.3.2
    • alert blackouts 3.13.3.3
    • Automatic Database Diagnostic Monitor (ADDM) 14.7
    • Average Active Sessions chart 14.1.1.3
    • Cluster Database Home page 14.1.1.1
    • Cluster Database page 14.1.1
    • Cluster Database Performance page
      • performance statistics for an Oracle RAC database 14.1.1.3
    • configuring to recognize changes in database management 3.8
    • Database Throughput charts 14.1.1.3
    • deleting database instances from nodes 11.2.1, 12.2.1
    • Global Cache Block Access Latency chart 14.1.1.3
    • Interconnects page 14.1.1.2
    • job administration 3.13.3.1
    • monitoring load values for available nodes 14.1.1.3
    • overview and concepts 1.12.2
    • Top Activity drill down menu 14.1.1.3
    • using the Interconnects page to monitor Oracle Clusterware 14.1.1
    • using to administer Oracle RAC 3.1.1.2
    • using to administer services 5.11.2
    • using to back up the server parameter file 3.6.3
    • using to create DTP services 5.4.4
    • using to monitor Oracle Clusterware 14.1.1
    • using to monitor Oracle RAC 14.1.1
    • using to monitor Oracle RAC environments 1.12.3
    • using to restore SPFILE 8.2.3
    • using to schedule Automatic Workload Repository actions 5.8
    • using to set up a fast recovery area 8.6
    • using to start or stop a database 3.2
    • using with RMAN 7.4
  • Oracle Enterprise Manager Cloud Control
  • Oracle Flex Clusters 1.4.1
  • Oracle GoldenGate 5.10.1.5
  • Oracle Grid Infrastructure 1.1
  • Oracle home
  • Oracle homes
    • cloning
      • on Linux and UNIX 10.2
    • local
      • cloning on Windows 10.4
    • shared
      • cloning on Linux and UNIX 10.3
      • cloning on Windows 10.4
  • Oracle Interface Configuration (OIFCFG) 14.3
  • Oracle Managed Files 3.1
  • Oracle Maximum Availability Architecture (MAA) 13.1.1
  • Oracle Multitenant 1.10
  • Oracle Net
    • listeners 1.4
  • Oracle Net connection failover 5.1.2
  • Oracle Net Services
  • Oracle Notification Service 1.4
    • Java client
    • SRVCTL object name A.9
    • used by FAN 1.6
  • Oracle Notification Services
  • Oracle processes
    • managed by Oracle Clusterware 1.4
  • Oracle RAC
    • adding administrator-managed database instances 11.1.2.1, 12.1.1
    • adding policy-managed database instances 11.1, 12.1
    • adding to nodes in a cluster on Linux and UNIX 11.1
    • adding to nodes in a cluster on Windows 12.1
    • administrative privilege
    • and e-commerce 13.3.5
    • background processes
    • benefits of cloning 9.1
    • cloning 9
      • size of the binaries 9.1
    • converting database from 4.2
    • converting database to 4.2
    • converting from non-cluster system 15.2.1
    • converting single instance to Oracle RAC One Node 4.2.1
    • copying the Oracle RAC home 9.2
    • databases
      • converting from single-instance Oracle databases 15
      • quiescing 3.10
    • deploying clone 9.3
    • diagnosing performance problems 14.8.1
    • diagnosing problems for B
    • IM column store 1.11
    • installation overview 1.2
    • overview of administration 1
    • removing on Windows 12.2.2
    • removing the software from Linux and UNIX 11.2.2
    • security considerations 13.3.8
    • shutting down instances 3.2.2
    • software components 1.5.6
    • storage options
      • IBM GPFS 1.5.1
      • network file system (NFS) 1.5.1
      • Oracle Automatic Storage Management (Oracle ASM) 1.5.1
      • Oracle Automatic Storage Management Cluster File System (Oracle ACFS) 1.5.1
      • Oracle OCFS2 1.5.1
      • volume manager 1.5.1
    • using a fast recovery area in 8.6
  • Oracle RAC One Node 4
    • converting database from 4.2
    • converting database to 4.2
    • converting to Oracle RAC 4.2.2
    • creating databases 4.1
    • database
      • services on 4.1
    • online database relocation 4.3
    • relocating to another node 4.3
  • Oracle RAC One Node database 13.4.2
  • Oracle RAC Sharding 5.5
  • Oracle Real Application Clusters
    • See: Oracle RAC
  • Oracle Real Application Clusters One Node
    • See: Oracle RAC One Node
  • Oracle Resource Manager
  • Oracle Services
  • Oracle Services for Microsoft Transaction Server
  • Oracle Universal Installer
    • database installation 1.2.2
    • Oracle Real Application Clusters installation 1.2.2
  • Oracle XA 5.10.2.10
  • oradebug ipc command B.6
  • OraMTS
    • See: Oracle Services for Microsoft Transaction Server
    • external transaction manager 5.4.1
  • orapwd file 3.8
  • outages
    • unplanned 6.2

P

  • PARALLEL_EXECUTION_MESSAGE_SIZE initialization parameter 3.7.1
  • PARALLEL_FORCE_LOCAL initialization parameter 5.10.1.4
  • parallel execution 13.3.7.2
  • parallelism
  • parallel processes 5.10.1.4
  • parallel recovery 8.5.2.1
  • parameter file
  • parameter file search order 3.6.2
  • parameters
    • DB_RECOVERY_FILE_DEST 8.6
    • that must be identical on all instances 3.7.1
    • that must be unique on all instances 3.7.2
  • password file-based authentication 4.3
  • PDBs 1.10, 3.3
  • performance 14.1.1.3
    • aggregates by services 14.1.1.3
    • comprehensive global data 14.7
    • monitoring activity by wait events, services, and instances 14.1.1.3
    • monitoring database throughput 14.1.1.3
    • monitoring global cache block access 14.1.1.3
    • monitoring potential problems in the database 14.1.1.3
    • primary components affecting 14.2
    • service aggregates by instances 14.1.1.3
    • service aggregates by waits 14.1.1.3
    • using ADDM 1.12.3
  • performance evaluation
    • overview and concepts 1.12.4
  • performance statistics 14.9.5
  • PFILE
    • using with Oracle RAC 3.6
  • phases
    • cloning deployment 9.3
    • cloning preparation 9.2
  • planned maintenance
    • draining database sessions 6.3.3
    • managing 6.3.1
    • using Application Continuity 6.6.2.7
  • pluggable database
    • See: PDBs
  • PMON background process 3.5
  • policy-managed clusters 1.7.4
  • policy-managed database 3.1
  • policy-managed database instances
  • policy-managed databases 1.7, 3.1, 3.7.2, 5.10.2.7
  • policy set 1.7.4
  • PREFERRED instances
  • preferred read disks
    • Oracle ASM in an Oracle RAC extended distance cluster 2.6.4
  • private clouds 13.1.3.3
  • private interconnect B.6
    • determining usage B.6
  • private network
    • alternative interconnect 3.11
    • IP address 14.3
  • processes
  • public and private interfaces
    • shown in Oracle Enterprise Manager 14.1.1.2
  • public network

Q

  • query optimizer 13.3.7.1
  • queue tables 5.10.1.5
  • quiesce database
    • in Oracle Real Application Clusters 3.10
  • quiesced databases 3.10
  • quiescing
    • noncluster database 3.10

R

  • reader nodes 1.4.2
  • rebalancing
    • workloads 5.6
  • RECOVER command 3.1.1.3.1
  • recovery
  • RECOVERY_PARALLELISM parameter 8.5.2.1
  • redo log files
    • instance recovery 8.3.1
    • log sequence number 7.8
    • using 2.4
  • redo log groups 2.4
  • redo logs
    • format and destination specifications 7.8
  • redo thread 3.1
  • reducing contention 13.2
  • regions 13.1.3.3
  • REMOTE_LOGIN_PASSWORDFILE initialization parameter 3.7.1
  • remote Oracle Notification Service subscription 5.3.2.1
  • Remote Slave Monitor (RSMN) 1.5.7
  • replicated databases
    • and global services 5.12
  • request boundaries 6.4.2, 6.4.2.2
  • resource contention 14.1.1.3
  • resource manager 5.6
  • resource profiles
  • resources
  • resources held by the session 3.5
  • restore scenarios
  • restore scheme
    • cluster file system 8.2.1
    • local file system 8.2.2
  • RESULT_CACHE_MAX_SIZE initialization parameter 3.7, 3.7.1
  • result cache 3.7
  • RMAN
    • CONFIGURE command 7.3
    • configuring channels 7.5
    • configuring channels to use automatic load balancing 7.6
    • configuring one channel for each instance 7.6.2
    • configuring snapshot control file locations 7.3
    • crosschecking on multiple nodes 7.5
    • local archiving scenario 7.9.2
    • restore scenarios 8.2
    • using to create SPFILE backups 3.6.3
  • RMSn
    • Oracle RAC management processes 1.5.7
  • rolling back
    • instance recovery 8.3.1
  • root.sh script
    • $ORACLE_HOME 9.3
  • RSMN
    • Remote Slave Monitor 1.5.7
  • runtime connection load balancing
  • Runtime Connection Load Balancing 5.10.2.8

S

T

  • tablespaces
    • automatic segment space management (ASSM) in Oracle RAC 13.3.1
    • automatic undo management in Oracle RAC 13.3.1
    • locally managed 13.3.1
    • use in Oracle RAC 13.3.1
  • TCP/IP 1.5.3
  • TCP network ports
    • Windows Firewall considerations 13.3.8.2
  • terminating a session on a specific instance 3.5
  • THREAD initialization parameter 3.7
  • threads
    • multiple application 5.3.7
  • timed statistics 14.6
  • tnsnames.ora file 3.7
  • Top Activity drill down menu
    • on the Cluster Database Performance page 14.1.1.3
  • Top Cluster Events 14.8.2
  • Top Cluster Events, ASH report 14.8.2
  • Top Remote Instance 14.8.3
  • Top Remote Instance, ASH report 14.8.3
  • TRACE_ENABLED initialization parameter 3.7.3
  • trace files B.1
    • for background processes B.1
    • managing B.1
    • sidalrt.log B.3
  • trace logs 13.4.3
  • tracing
    • enabling Java-based tools and utilities B.4
    • SRVM_TRACE environment variable B.4
    • writing to log files B.4
  • transactional TAF 5.3.8
  • transaction failover 6.9
  • Transaction Guard 6.9
    • configuring JDBC-thin clients 5.3.4, 5.3.5
    • configuring OCI clients 5.3.8
    • configuring service attributes 5.11.3.2
    • configuring services for 6.9.2
    • introduction to 1.6
    • transaction history table 6.9.1
  • transaction history table 6.9.1
  • transaction idempotence 6.9
  • transactions
  • Transparent Application Continuity 6.4.2, 6.4.2.1
  • transparent application failover (TAF)
  • Transparent Data Encryption
    • specifying the ENCRYPTION_WALLET_LOCATION parameter 13.3.8.1
    • with encrypted keystores and obfuscated keystores 13.3.8.1
  • tuning

U

  • UNDO_MANAGEMENT initialization parameter 3.7.1
  • UNDO_RETENTION initialization parameter 3.7.3
  • UNDO_TABLESPACE parameter 3.7.2
  • undo tablespace 3.1
  • upgrades
    • changing management policy for 3.12
  • User Datagram Protocol (UDP) B.6
  • user process trace files B.1

V

  • V$ 1.12.3
  • V$CLUSTER_INTERCONNECTS 14.2, B.6
  • V$CONFIGURED_INTERCONNECTS 14.2
  • V$ view 14.4
  • valid node checking 1.5.5, 5.10.4
  • vendor clusterware 1.1
  • verification
    • data files, online files 2.2
  • versions
    • compatibility for Oracle RAC and Oracle Database software 1.2.1
  • views
    • creating for Oracle Real Application Clusters 14.5
    • dynamic performance
      • for performance monitoring 14.4
      • GV$ 14.4
    • for performance monitoring 14.4
    • GV$SESSION 3.5
    • instance-specific 14.4
  • VIP
    • SRVCTL object name A.9
  • VIPs
  • Virtual Internet Protocol (VIP) address 1.1
  • virtual IP address
    • requirements A.4
  • VNCR
    • See: valid node checking
  • volume
    • SRVCTL object name A.9

W

X