Index
A
B
C
D
E
F
G
H
I
L
M
N
O
P
R
S
T
U
V
W
A
- acquiring rollback segments, 5-5
- ACTIVE_INSTANCE_COUNT parameter, 9-6
- ADD LOGFILE clause
- thread required, 5-7
- adding a file, 5-8
- allocation
- rollback segments, 5-5
- ALTER DATABASE DISABLE THREAD statement, 5-7
- ALTER DATABASE statement
- DISABLE clause, 5-7
- THREAD clause, 5-7
- thread of redo, 5-7
- ALTER ROLLBACK SEGMENT statement, 5-5
- architecture
- Optimal Flexible Architecture (OFA), 3-6, 4-2
- Oracle Enterprise Manager, 7-5
- Server Management, 7-2
- SRVCTL Utility on UNIX, 7-3
- archive logs
- destinations, conversion to multi-instance, 10-3
- ARCHIVELOG mode, 5-3
- ASCII file
- for UNIX raw volume names, 2-10
- automatic undo management, 8-8
- rollback segments, 5-4
B
- backups
- after creating new databases, 5-17
- before database creation, 5-9
- conversion to multi-instance, 10-3
C
- client load balancing
- configuring, 9-9
- description of, 9-8, 9-9
- clustdb.sql script, 5-16
- cluster database
- reasons to convert to, 10-2
- clustered file systems
- as required by Oracle Managed Files, 1-6
- Communication Daemon, defined, 7-2
- components, 9-11
- concurrency
- maximum number of instances, 5-2
- Configuration Assistant, 7-7
- configuration raw device, 2-2
- configuration type
- Customized, 3-4
- configurations
- change in redo log, 5-8
- configuring
- clients
- client load balancing, 9-9
- connect-time failover, 9-9
- primary and secondary instances, 9-7
- global database name, 4-9
- high availability, 9-1 to 9-11
- primary and secondary instances, 9-6
- listeners
- primary and secondary instances, 9-8
- Oracle Enterprise Manager, 7-10, 7-11
- Oracle Parallel Server Management, 7-1
- Oracle Performance Manager, 7-10
- primary and secondary instances, 9-6
- shared disks, 2-1
- SID Prefix, 3-7, 3-9
- connecting
- Real Application Clusters database, 9-11
- connection load balancing, 8-8, 8-9
- connect-time failover
- configuring, 9-9
- described, 9-8, 9-9
- GLOBAL_DBNAME parameter in listener.ora file, 8-12
- Console
- setup, 7-5
- contention
- SYSTEM tablespace, 5-4
- control files, 1-5, 2-2
- creating, 5-3
- described, 8-7
- log history, 5-2
- raw devices, 2-6
- CREATE CONTROLFILE statement, 5-3
- changing database options, 5-3
- CREATE DATABASE, 5-2
- creating threads, 5-6
- MAXDATAFILES clause, 5-3
- MAXINSTANCES clause, 5-2
- MAXLOGFILES clause, 5-2
- MAXLOGHISTORY clause, 5-2
- MAXLOGMEMBERS clause, 5-2
- CREATE PUBLIC ROLLBACK SEGMENT statement, 5-5
- CREATE ROLLBACK SEGMENT statement, 5-5
- creating
- initdb_name.ora file, 5-14
- initialization parameter files, 5-14
- initsid.ora file, 5-14
- new redo log groups, 5-7
- Oracle Enterprise Manager repository, 7-7
- password files, 5-15
- preferred credentials, 7-8
- raw devices on UNIX, 2-7
- raw devices on Windows, 2-12
- Real Application Clusters database
- backing up the new database, 5-17
- initdb_name.ora file, 5-14
- initsid.ora file, 5-14
- ORACLE_SID environment variable, 5-12
- OracleServicesid service, 5-13
- oratab file, 5-12, 8-4
- password files, 5-15
- with Oracle Database Configuration Assistant, 3-6, 4-2, 4-3
- Real Application Clusters database with manual methods, 5-8
- rollback segments, 5-4, 5-5
- server parameter files, 6-7
- threads, 5-6
- crtsrv batch file, 5-13
- Customized
- configuration type, description of, 3-4
- configuration type, using, 3-5
- CWMLITE tablespace
- raw devices, 2-6
- cwmlite1
- identifying on UNIX, 2-9
D
- data dictionary
- views, 5-5
- Data Warehousing
- description of configuration type, 3-4
- database
- archiving mode, 5-7
- configurations, types, 3-4
- number of instances, 5-2
- rollback segments, 5-4
- database directory, A-4
- datafiles, 1-5, 2-2
- described, 8-5
- raw devices, 2-5
- db_name.conf file
- service discovery, B-3
- DBA Studio
- limitations, 7-12
- DBA_ROLLBACK_SEGS view
- public rollback segments, 5-5
- DBCA_RAW_CONFIG
- environment variable, 3-2
- DBMS_LIBCACHE Package, xxx
- DBMS_LIBCACHE package, 9-9
- dbs directory, A-3
- default user names
- expiration of, xxx
- deleting databases
- with the DBCA, 4-17
- devices
- minimum configuration requirements, 2-2
- directory structure, A-1 to A-5, B-1
- UNIX, A-2
- Windows, A-4
- DISABLE THREAD clause, 5-7
- disabling
- the archive history, 5-3
- threads, 5-7
- dropping redo log files
- manual archiving, 5-7
- restrictions, 5-8
- DRSYS tablespace
- description, 8-6
- raw device, 2-6
E
- Edit User Preferences dialog box, 7-9
- environment variable
- for raw devices, 2-11
- UNIX, 3-2
- errors
- messages, rollback segment, 5-5
- Oracle Enterprise Manager discovery, B-2
- EXAMPLE tablespace
- raw devices, 2-6
- example1
- identifying on UNIX, 2-9
- exclusive mode
- media recovery, 5-2
- Export utility, 10-4
F
- FAILOVER parameter, 9-10
- FAILOVER_MODE parameter, 9-2
- for Transparent Application Failover, 9-2
- features, new, xxviii
- files
- dropping, 5-7, 5-8
- renaming, 5-8
G
- General Purpose
- description of configuration type, 3-4
- global database name, 4-9
- Global Services Daemon (GSD), 5-11
- global V$ view tables, 7-1
- GLOBAL_DBNAME parameter, 8-11
- groups
- MAXLOGFILES, 5-2
- redo log files, 5-2, 5-8
- GSD, defined, 7-2
H
- hardware requirements, 1-6
- high availability
- configuring, 9-1 to 9-11
- primary and secondary instances, 9-6
- Transparent Application Failover, 9-2
- host.equiv file, 2-12
I
- Import utility, 10-5
- INDX tablespace
- described, 8-5
- raw device, 2-6
- initdb_name.ora file
- ACTIVE_INSTANCE_COUNT parameter, 9-6
- creating, 5-14
- initialization parameter files
- creating for database creation, 5-14
- editing before database creation, 5-15
- for instances, 6-2
- initsid.ora file
- creating, 5-14
- installation
- directory structure, A-1 to A-5, B-1
- ldap.ora file, 8-12
- listener.ora file, 8-10
- overview, 1-3, 1-5
- pre-installation, 2-12
- processing of the DBCA, 3-6
- repository database, 7-7
- requirements, hardware, 1-5, 1-6
- requirements, hardware requirements, 1-6
- requirements, software, 1-5
- software requirements, 1-6
- tnsnames.ora file, 8-13
- verifying raw devices, 4-3
- installing
- Oracle Enterprise Manager, 7-7
- with Oracle Universal Installer, 3-2
- Instance Management, xxix
- INSTANCE_ROLE
- for Transparent Application Failover, 9-2
- use of in secondary instance connections, 9-8
- instances
- adding instances, 5-2
- initialization parameter files, 6-2
- maximum number, 5-2
- recovery, 5-2
- recovery, starting another instance, 5-2
- SID Prefix, 3-7, 3-9
- thread number, 5-6
- Instances Logon dialog box, 7-11
- interconnects
- supported for Real Application Clusters, 1-7
L
- ldap.ora file, 8-12
- creating, 8-12
- default configuration, 8-12
- library cache
- warming, xxx, 9-9
- listener.ora file, 8-10
- default configuration, 8-10
- Oracle Enterprise Manager service discovery, B-3
- Server Management requirements, 7-4
- sid_DESC parameter, B-4
- sid_LIST_listener_name parameter, 5-18, 7-4, B-4
- listeners
- GLOBAL_DBNAME parameter, 8-11
- listener.ora file, 8-10
- LOAD_BALANCE parameter, 9-10
- log history, 5-2
- log switches
- adding or dropping files, 5-8
M
- manual archiving
- dropping a redo log file, 5-7
- MAXDATAFILES clause, 5-3
- MAXDATAFILES parameter, 5-3
- MAXINSTANCES clause, 5-2
- changing, 5-3
- MAXINSTANCES parameter, 5-3
- MAXLOGFILES clause, 5-2, 5-3
- MAXLOGFILES parameter, 5-3
- MAXLOGHISTORY clause, 5-2
- changing, 5-3
- MAXLOGHISTORY parameter, 5-3
- MAXLOGMEMBERS clause, 5-2, 5-3
- MAXLOGMEMBERS parameter, 5-3
- media recovery
- log history, 5-2
- member
- MAXLOGMEMBERS, 5-2
- migrating
- Real Application Clusters issues, 4-20
- single instance to Real Application Clusters, 10-2
- to Real Application Clusters with raw devices, 10-6
- to Real Application Clusters with shared file systems, 10-6
- multi-instance database
- reasons not to convert to, 10-2
- requirements, 10-2
- multiple Oracle homes
- UNIX, 4-21
- Windows, 4-21
- multiplexed redo log files
- total number of files, 5-2
N
- network configuration files
- ldap.ora.ora, 8-12
- listener.ora, 7-4, 8-10
- Oracle Enterprise Manager service discovery, B-3
- sqlnet.ora, 5-18, 8-17
- testing, 9-11
- tnsnames.ora, 5-18, 8-13
- Oracle Enterprise Manager service discovery, B-4
- network directory, A-2, A-4
- new features, xxviii
- nmiconf.log file, B-6
O
- OPS_INSTANCE entry, B-5
- OPS_INSTANCE entry in services.ora file, B-5
- Optimal Flexible Architecture (OFA), 3-6, 4-2
- Oracle Cluster Setup Wizard, xxviii
- Oracle Database Configuration Assistant
- control files, 8-7
- creating Real Application Clusters database
- after installation, 4-3
- during installation, 3-6, 4-2
- datafiles, 8-5
- deleting databases with, 4-17
- deleting Real Application Clusters databases, 4-17
- initialization parameter files, 8-8
- new features, xxix
- processing during installation, 3-6
- raw devices for, 2-3
- redo log files, 8-7
- rollback segments, 8-8
- shared server configuration, 8-8
- tablespaces, 8-5
- troubleshooting, 4-5
- using, 4-2
- Oracle Enterprise Manager
- architecture, 7-5
- Configuration Assistant, 7-7
- configuring, 7-10, 7-11
- repository, 7-7
- described, 7-2
- GSD, 7-2
- installing repository database, 7-7
- nmiconf.log file, B-6
- oratab file requirements, 5-12
- preferred credentials, 7-8
- repository database
- configuring, 7-7
- Server Management
- Communication Daemon, 7-2
- service discovery, B-2
- services.ora file, B-5
- setup scenarios, 7-5
- sid_LIST_listener_name parameter in listener.ora file, 5-18, 7-4
- solving service discovery failures, B-2
- specifying preferred credentials, 7-8
- SYSDBA privilege, 7-10
- SYSOPER privilege, 7-10
- TOOLS tablespace, 2-6
- understanding discovery failures, B-2
- Oracle Intelligent Agent, 1-4
- Oracle Managed Files
- requirements for using, 1-6
- Oracle Parallel Server Management
- configuring, 7-1
- Oracle Performance Manager
- accessing Oracle Parallel Server charts, 7-11
- configuring, 7-10
- Databases folder, 7-12
- Parallel Server Instance folder, 7-11
- Oracle Universal Installer, 3-2
- for Real Application Clusters, 3-1
- new features, xxix
- overview of processing, 1-3
- starting, 3-2
- ORACLE_PSRV environment variable, B-6
- ORACLE_SID
- environment variable, 5-12
- OracleCMService service, 4-20
- OracleServicesid service, 5-13
- ORAPWD utility, 5-16
- orapwsid file, 5-15
P
- parameters
- database creation, 5-2
- initialization, 6-1
- password files, 5-15
- Performance Manager
- overview of, 1-4
- preconfigured database installation types, 3-5
- preferred credentials, 7-8
- creating an operating system account, 7-9
- database, 7-8
- nodes, 7-8
- pre-installation, 2-12
- raw device creation, 2-3 to 2-13
- preinstallation
- on UNIX, 2-11
- primary and secondary instances
- client configuration, 9-7
- connecting to secondary instances, 9-8
- initdb_name.ora file configuration, 9-7
- listener configuration, 9-8
- overview, 9-6
- private rollback segments, 5-5
- creating, 5-5
- private threads, 5-7
- public rollback segments, 5-5
- bringing online, 5-6
- creating, 5-5
- owner, 5-5
- specifying, 5-6
- using by default, 5-5
- PUBLIC threads, 5-7
- pwdsid.ora file, 5-15
R
- RAC_DATABASE entry, B-5
- RAC_DATABASE entry in services.ora file, B-5
- raw devices, 2-2
- configuration raw device, 2-2
- configuring, 2-7
- control files, 2-6
- creating
- on UNIX, 2-7
- on Windows, 2-12
- datafiles, 2-5
- DRSYS tablespace, 2-6
- environment variable, 2-11
- EXAMPLE tablespace, 2-6
- identifying on UNIX
- control1 database object, 2-9
- control2 database object, 2-9
- drsys1 database object, 2-9
- indx1 database object, 2-9
- redo thread_number database object, 2-9, 2-10
- system1 database object, 2-9
- temp1 database object, 2-9
- tools1 database object, 2-9
- users1 database object, 2-9
- identifying on Windows
- db_name_control1 symbolic link, 2-13
- db_name_control1 symbolic link, 8-7
- db_name_control2 symbolic link, 2-13, 8-7
- db_name_cwmlite1, 2-13
- db_name_drsys1 symbolic link, 2-13, 8-6
- db_name_indx1 symbolic link, 2-13, 8-6
- db_name_rbs1 symbolic link, 8-6
- db_name_redo thread_number symbolic link, 2-13
- db_name_redothread_number symbolic link, 8-7
- db_name_spfile1 symbolic link, 2-13, 8-6
- db_name_system1 symbolic link, 2-13, 8-6
- db_name_temp1 symbolic link, 2-13, 8-6
- db_name_tools1 symbolic link, 2-13, 8-6
- db_name_users1 symbolic link, 2-13, 8-6
- identifying on Windows, srvcfg, 2-13
- identifying on Windows, undotbs1 and undotbs2 symbolic links, 2-13, 8-6
- INDX tablespace, 2-6
- new requirements, xxviii
- redo log files, 2-6
- server parameter files, 2-5
- setting up, 2-3 to 2-13
- srvcfg, 2-6
- SYSTEM tablespace, 2-5
- TEMP tablespace, 2-5
- TOOLS tablespace, 2-6
- UNDOTBS tablespace, 2-5
- USERS tablespace, 2-5
- verification, 4-3
- raw devices CWMLITE tablespace, 2-6
- raw volumes
- on UNIX, configuring, 2-7
- RBS tablespace
- description, 8-5
- Real Application Clusters
- components, 1-2
- databases, backing up, 5-17
- databases, creating
- with manual methods, 5-8
- databases, deleting, 4-17
- databases, password files, 5-15
- hardware requirements, 1-6
- installation requirements, 1-5
- installed components of, 1-5
- overview, 1-1, 4-1, 8-1
- pre-installation, 2-12
- raw device setup, 2-3 to 2-13
- reasons to convert to, 10-2
- software requirements, 1-6
- recovery
- archive history, 5-2
- instance, 5-2
- starting another instance, 5-2
- redo log files, 1-5, 2-2
- described, 8-7
- identifying on UNIX, 2-9
- raw devices, 2-6
- reconfiguring, 5-8
- redo log groups, creating, 5-7
- registry
- PM\db_name key, B-3
- repository database
- installing, 7-7
- requirements
- for installing Real Application Clusters, 1-5
- tablespace sizes, 2-5
- restrictions
- changing the redo log, 5-8
- .rhosts file, 2-12
- rollback segments, 5-4
- contention, 5-4
- described, 8-8
- ID number, 5-5
- multiple, 5-4
- name, 5-5
- public, 5-6
- public versus private, 5-6
- specifying, 5-5
- tablespace, 5-4, 5-5
- ROLLBACK_SEGMENTS parameter
- private and public segments, 5-5, 5-6
- root, 2-11
S
- segments
- ID number, 5-5
- server configuration
- raw device for, 2-2
- Server Management
- architecture, 7-2
- GSD process, 7-2
- node requirements, 7-4
- Oracle Enterprise Manager, 7-2
- overview of, 1-4
- requirements, 7-4
- SIDs, 7-4
- server parameter files, 1-5, 2-2, 6-1, 6-2
- creating, 6-7
- raw devices, 2-5
- service discovery
- db_name.conf file, B-3
- errors, B-2
- listener.ora file, B-3
- nmiconf.log file, B-6
- on UNIX, B-3
- on Windows NT, B-3
- PM\db_name registry key, B-3
- services.ora file, B-5
- sid_LIST_listener_name parameter, B-4
- tnsnames.ora file, B-4
- understanding, B-2
- services
- OracleCMService, 4-20
- services.ora file, B-5
- shared disk storage subsystem, 2-2
- shared disks
- configuring, 2-1
- shared server
- configuring, 8-8
- connection load balancing, 8-8, 8-9
- dispatchers, 8-8
- shutting down a Server database
- with SYSDBA privilege, 7-10
- with SYSOPER privilege, 7-10
- sid Prefix, 3-7, 3-9
- sid_DESC parameter, B-4
- sid_LIST_listener_name parameter, 5-18, 7-4
- Software Only
- configuration type, description of, 3-4
- software requirements, 1-6
- spfile1
- identifying on UNIX, 2-9
- sqlnet.ora file, 5-18, 8-17
- default configuration, 8-17
- srvcfg
- raw devices, 2-6
- srvcfg raw device
- identifying, 2-13
- SRVCTL Utility, 1-4, 5-11, 7-2
- architecture on UNIX, 7-3
- srvm\admin directory, A-4
- SRVM_SHARED_CONFIG
- environment variable, 3-2
- srvm/admin directory, A-3
- startup
- during instance recovery, 5-2
- rollback segments, 5-5
- SYSDBA privilege, 7-10
- SYSOPER privilege, 7-10
- SYSDBA privilege, 7-10
- SYSDBA privilege, granting, 7-9
- SYSOPER privilege, 7-10
- SYSOPER privilege, granting, 7-9
- SYSTEM tablespace, 5-4
- description, 8-5
- raw device, 2-5
T
- tablespaces
- control files, 2-6
- CWMLITE, 2-6, 8-6
- DRSYS, 2-6, 8-6
- EXAMPLE, 2-6, 8-6
- expanding for large sorts, 8-5
- INDX, 2-6, 8-5
- RBS, 8-5
- recommended sizes of, 2-5
- rollback segment, 5-4, 5-5
- server parameter file, 2-5
- server parameter file (SPFILE), 8-5
- srvcfg, 2-6
- SYSTEM, 2-5, 5-4, 8-5
- TEMP, 2-5, 8-5
- TOOLS, 2-6, 8-6
- undo tablespaces for automatic undo management, 8-5
- USERS, 2-5, 8-5
- tablespaces UNDOTBS, 2-5
- TAF
- configuring, 9-2
- GLOBAL_DBNAME parameter in listener.ora file, 8-12
- overview, 9-2
- pre-establishing a connection, 9-4
- retrying a connection, 9-4
- with client load balancing, 9-3
- with connect-time failover, 9-3
- TEMP tablespace
- described, 8-5
- raw device, 2-5
- Template Management, xxix
- testing the network, 9-11
- THREAD clause, 5-7
- disabling a thread, 5-7
- when required, 5-7
- THREAD parameter, 5-6
- threads
- associated with an instance, 5-6
- changing from public to private, 5-7
- creating, 5-6
- disabled, 5-7
- disabling, 5-7
- public, 5-6, 5-7
- tnsnames.ora file, 5-18, 8-13
- default configuration, 8-13
- FAILOVER parameter, 9-10
- FAILOVER_MODE, 9-2
- LOAD_BALANCE parameter, 9-10
- service discovery, B-4
- TOOLS tablespace
- described, 8-6
- raw device, 2-6
- Transaction Processing
- description of configuration type, 3-4
- Transmission Control Protocol/Interconnect Protocol (TCP/IP)
- for Real Application Clusters, 1-7
- Transparent Application Failover
- configuring, 9-2
- GLOBAL_DBNAME parameter in listener.ora file, 8-12
- overview, 9-2
- pre-establishing a connection, 9-4
- retrying a connection, 9-4
- with client load balancing, 9-3
- with connect-time failover, 9-3
- troubleshooting
- Oracle Database Configuration Assistant, 4-5
- service discovery, B-2
U
- UNDOTBS tablespace
- raw devices, 2-5
- undotbs1
- identifying on UNIX, 2-9
- UNIX
- raw volume names ASCII file, 2-10
- raw volumes, configuring, 2-7
- upgrading
- Real Application Clusters issues, 4-20
- user
- PUBLIC, 5-5
- User Datagram Protocol (UDP)
- for Real Application Clusters, 1-7
- user names
- default, expiration of, xxx
- USERS tablespace
- described, 8-5
- raw device, 2-5
V
- V$SESSION table, 9-6
- Veritas Volume Manager
- during installation, 2-5
- Virtual Interface Architecture (VIA)
- for Real Application Clusters, 1-7
- volumes
- Veritas Volume Manager, use of during installation, 2-5
W
- warming the cache, xxx, 9-9