Index
A
B
C
D
E
F
G
H
I
L
M
N
O
P
R
S
T
U
V
W
Symbols
- \\.\PhysicalDrivex, A-3
A
- Advanced Replication support
- data dictionary
- tables, 2-14
- initialization parameter requirements, 2-14
- tablespace requirements, 2-13, 2-14
- alert files, 4-13
- for monitoring a database, 4-2
- using, 4-13
- alert view, 4-4
- ALTER DATABASE ARCHIVELOG command, 3-21
- ARCHIVE LOG LIST command, 3-21
- ARCHIVELOG mode, 3-21
- archiving mode
- custom database, 3-20
- starter database, 3-20
- archiving procedures, 3-21
- for redo log files, 3-20
- specifying an archive destination, 3-21
- UNC not allowed, 1-3, 3-19
- audit trail
- managing, 4-12
- AUDIT_FILE_DEST parameter, 4-13, 7-4
- AUDIT_TRAIL parameter, 4-11
- auditing, 4-11
- authentication
- using a password file, 3-15
- auto-starting
- Oracle Services, 3-8
B
- BACKGROUND_DUMP_DEST parameter, 1-15
- using with trace files, 4-13
- backup
- databases, 1-21
- OCOPY file types, 6-4
- stopping services to perform cold backups, 6-3
- backup and recovery tools
- OCOPY, 6-3
- Recovery Manager (RMAN.EXE), 6-2
- selecting, 6-2
- third-party backup and recovery vendors, 6-3
- block size, maximum, 7-6
- blocks per file, maximum, 7-6
C
- C:\ORANT, defined, xviii
- C:\ORAWIN95, defined, xviii
- chart view, 4-4
- cold backups, performing, 6-3
- COMPATIBLE_NO_RECOVERY parameter, 7-5
- configuration responsibilities
- Oracle Audio Data, 2-3
- Oracle interMedia Text, 2-4
- Oracle Spatial, 2-7
- configuration tasks
- Oracle Spatial, 2-8
- CONNECT /AS SYSDBA
- using, 3-10
- CONNECT/AS SYSDBA
- using, 3-20
- connecting
- to a database, 3-10, 3-20
- control files
- additional backslashes in r. 8.0.4, 1-3, 3-20
- CONTROL_FILES parameter, 1-15
- copy modes, for OCOPY, 6-4
- CORE_DUMP_DEST parameter, 7-5
- CPU_COUNT parameter, 7-5
- CREATE DATABASE command, 1-16
- custom database
- archiving mode, 3-20
D
- data dictionary
- Advanced Replication tables, 2-14
- database backup and recovery tools
- OCOPY, 6-3
- Recovery Manager (RMAN), 6-2
- third-party vendors, 6-3
- database files
- deleting, 1-13
- database monitoring
- using Performance Monitor, 4-2
- with alert files, 4-13
- with Event Viewer, 4-9
- with trace files, 4-13
- databases
- backing up, 1-21
- connecting to, 3-10, 3-20
- creating, 7-1
- Creating a Database Manually, 1-10
- deleting, 1-13
- exporting, 1-12
- importing, 1-18
- maximum size possible, 7-7
- monitoring, 4-2
- naming conventions, 1-2
- Oracle Database Configuration Assistant, 1-4
- password encryption, 3-18
- shutting down, 3-9, 3-11
- starting, 3-9
- DB_FILES parameter, 1-15
- DB_NAME parameter, 1-15
- DB_WRITER_PROCESSES parameter, 7-5
- DBLINK_ENCRYPT_LOGIN parameter, 3-18
- dedicated server mode
- disabling, 2-9
- enabling, 2-9
- deleting
- password file, 3-18
- disk definition, A-2
E
- encrypting, database passwords, 3-18
- error messages
- ORA-01102, 1-2
- Event Viewer, 4-2
- 34 ID, 4-11
- auditing, 4-11
- blue (informational) icon, 4-10
- for monitoring a database, 4-2
- IDs other than 34, 4-11
- managing, 4-12
- reading, 4-10
- red (stop sign) icon, 4-10
- using, 4-9
- yellow (exclamation point) icon, 4-10
- Export Utility
- databases, 1-12
- interactive mode, 1-12
- parameter mode, 1-12
- extended partition
- creating, A-7
- defined, A-2
- extents
- maximum number per database, 7-7
F
- file names
- normalizing when using Recovery Manager, 6-2
- file sizes
- maximum possible, 7-6
- files
- alert, 4-13
- maximum number per database, 7-6
- maximum size possible, 7-6
- trace, 4-13
G
- generic documentation references
- auditing capabilities, 4-11
- block size parameter, 7-6
- calculating index size, 7-6
- controlling archiving modes, 3-20
- CREATE DATABASE, 1-16
- custom database archiving mode, 3-20
- location of initialization parameter file, 7-2
- LOG_ARCHIVE_FORMAT, 3-21
- managing the Event Viewer, 4-12
- MAXDATAFILES, 1-15
- maximum number of data files, 1-15
- maximum number of extents, 7-7
- memory usage, 5-4
- Oracle Managed Files, 1-17
- password utility, 3-15
- redo log files, 3-22
- starter database archiving mode, 3-20
- Windows NT-specific archiving procedures, 3-21
- Windows NT-specific audit trail availability, 4-10
- Windows NT-specific audit trail facility, 4-10
- Windows NT-specific automatic database startup after reboot, 3-8
- Windows NT-specific database creation procedures, 1-4
- Windows NT-specific initialization parameter file, 7-2
- Windows NT-specific instance startup file names, 3-10
- Windows NT-specific parameter file name and location, 7-2
- Windows NT-specific password file name and location, 3-15
- Windows NT-specific trace file names, 4-13
H
- HI_SHARED_MEMORY_ADDRESS parameter, 7-5
- Hostname parameter, 4-3
- hostname value, 4-3
I
- Import Utility
- databases, 1-18
- interactive mode, 1-18
- parameter mode, 1-18
- index size, calculating, 7-6
- initialization parameter file
- defined, 7-2
- editing, 7-2
- location, 7-2
- using PFILE option for database startup, 3-10
- using the default file for database startup, 3-10
- initialization parameter requirements
- Advanced Replication Support, 2-14
- initialization parameters
- COMPATIBLE_NO_RECOVERY, 7-5
- CORE_DUMP_DEST, 7-5
- CPU_COUNT, 7-5
- DB_WRITER_PROCESSES, 7-5
- HI_SHARED_MEMORY_ADDRESS, 7-5
- LARGE_POOL_SIZE, 7-5
- LOG_BUFFER, 7-5
- ORACLE_TRACE_COLLECTION_PATH, 7-5
- ORACLE_TRACE_FACILITY_NAME, 7-5
- ORACLE_TRACE_FACILITY_PATH, 7-5
- SHARED_MEMORY_ADDRESS, 7-5
- SPIN_COUNT, 7-5
- INSTANCE_NAME parameter, 1-15
- instances
- creating, 1-23
- defined, 3-4
- modifying, 1-26
- running multiple instances, 3-14
- starting, 1-25
- stopping, 1-25
- interactive mode
- Export Utility, 1-12
- Import Utility, 1-18
- internal read/write batch size, 5-17
L
- LARGE_POOL_SIZE parameter, 7-5
- Legato Storage Manager
- adding BIN directory to PATH, 6-7
- Japanese version, 6-7
- settings for multiple tape devices, 6-7
- listener
- OracleHOME_NAMETNSListener service, 3-5
- OracleHOME_NAMETNSListenerLSNR service, 3-5
- log view, 4-5
- LOG_ARCHIVE_DEST_n parameter, 1-3, 3-19, 3-21
- LOG_ARCHIVE_FORMAT parameter, 3-21
- LOG_ARCHIVE_START parameter, 3-21
- LOG_BUFFER parameter, 7-5
- logical partitions
- creating, A-8
M
- mapped drives, 1-3, 3-19
- MAXDATAFILES, 1-15
- Maximum, 7-7
- monitoring
- alert files, 4-2
- Event Viewer, 4-2
- Management Pack, 4-2
- Oracle9i Objects, 4-5
- Performance Monitor, 4-2
- trace files, 4-2
- multiple instances, running, 3-14
- multiple Oracle homes
- service naming conventions, 3-2, 3-4
- multi-threaded server
- configuring with Oracle Database Configuration Assistant, 2-9
- disabling, 2-9
- enabling, 2-9
N
- naming conventions for multiple Oracle homes, 3-2
- NET START command, 1-17
- NOARCHIVELOG mode, 3-21
O
- OCOPY
- backup file types, 6-4
- capabilities, 6-3
- copy modes, 6-4
- recovery file types, 6-6
- syntax for backing up files, 6-5
- syntax for recovering files, 6-6
- OLTP
- importing a sample schema, 1-8
- OPERF.LOG file, 4-8
- viewing Performance Monitor status, 4-8
- ORA_ENCRYPT_LOGIN parameter, 3-18
- ORA_SHUTDOWN parameter, 3-12
- ORA_SID_AUTOSTART parameter, 3-11
- ORA_SID_PFILE parameter, 3-11
- ORA_SID_SHUTDOWN parameter, 3-12
- ORA_SID_SHUTDOWN_TIMEOUT parameter, 3-13
- ORA_SID_SHUTDOWNTYPE parameter, 3-13
- ORA-00256 error, 1-3, 3-19, 3-20
- ORA-09291 error, 1-3, 3-19
- Oracle Audio Data
- configuration responsibilities, 2-3
- Oracle Connection Manager
- OracleHOME_NAMECManService service, 3-5
- Oracle database
- sample OLTP schema, 1-8
- sample Warehousing schema, 1-8
- Oracle Database Configuration Assistant
- deleting databases, 1-10
- importing a sample OLTP schema, 1-8
- importing a sample Warehousing schema, 1-8
- Oracle Enterprise Manager
- Backup Wizard, 6-2
- Management Pack, 4-2
- Oracle interMedia Text
- configuration responsibilities, 2-4
- Oracle Services
- auto-starting, 3-8
- naming conventions for multiple Oracle homes, 3-2
- OracleAgent, 3-4
- OracleServiceSID, 3-4
- OracleTNSListener, 3-4
- shutting down a database by stopping a service, 3-11
- starting, 3-5
- stopping, 3-6
- Oracle Spatial
- configuration responsibilities, 2-7
- configuration tasks, 2-8
- ORACLE_BASE
- explained, xviii
- ORACLE_HOME
- explained, xviii
- ORACLE_SID parameter, 1-19, 3-4, 3-14
- ORACLE_TRACE_COLLECTION_PATH parameter, 7-5
- ORACLE_TRACE_FACILITY_NAME parameter, 7-5
- ORACLE_TRACE_FACILITY_PATH parameter, 7-5
- Oracle9i Buffer Cache, 4-7
- Oracle9i Data Dictionary Cache, 4-7
- Oracle9i Data Files object, 4-7
- Oracle9i database
- connecting to, 3-10, 3-20
- password encryption, 3-18
- selecting a backup and recovery tool, 6-2
- shutting down, 3-9, 3-11
- shutting down a database with a service, 3-12
- specifications, 7-6
- starting, 3-9
- Oracle9i database backup and recovery tools
- OCOPY, 6-3
- Recovery Manager (RMAN.EXE), 6-2
- third-party vendors, 6-3
- Oracle9i Free List, 4-8
- Oracle9i Library Cache, 4-7
- Oracle9i Objects, monitoring, 4-5
- Oracle9i Redo Log Buffer, 4-7
- Oracle9i Sorts, 4-8
- OracleAgent, defined, 3-4
- OracleHOME_NAMEClientCache, 3-5
- OracleHOME_NAMECManService service, 3-5
- OracleHOME_NAMETNSListener service, 3-5
- OracleHOME_NAMETNSListenerLSNR service, 3-5
- OracleServiceSID, 3-4
- starting the database, 3-11
- stopping the database, 3-11
- OracleTNSListener
- defined, 3-4
- ORADEBUG
- debugging utility, 3-23
- starting, 3-23
- ORADIM
- creating an instance, 1-23
- modifying an instance, 1-26
- moving or copying password files, 3-17
- starting an instance, 1-25
- stopping an instance, 1-25
- ORAPWD
- creating password files, 3-15
- OSD-04018 error, 1-3, 3-19
P
- parameter mode
- Export Utility, 1-12
- Import Utility, 1-18
- partitions
- extended, A-2
- logical partition, A-4
- physical disk, A-3
- raw, A-2
- password file
- authenticating database administrators, 3-15
- creating, 3-15
- deleting, 3-18
- hiding, 3-15
- viewing, 3-17
- passwords
- encryption, 3-18
- Performance Monitor, 4-2
- accessing, 4-4
- alert view, 4-4
- chart view, 4-4
- for monitoring a database, 4-2
- Hostname parameter, 4-3
- log view, 4-5
- monitoring Oracle9i Objects, 4-5
- OPERF.LOG, 4-8
- Oracle9i Buffer Cache, 4-7
- Oracle9i Data Dictionary Cache, 4-7
- Oracle9i Data Files, 4-7
- Oracle9i Free List, 4-8
- Oracle9i Library Cache, 4-7
- Oracle9i Redo Log Buffer, 4-7
- password, 4-3
- registry information, 4-3
- Report View, 4-5
- troubleshooting information, 4-8
- username parameter, 4-3
- using, 4-2
- viewing OPERF.LOG file status, 4-8
- Performance Pack, monitoring a database, 4-2
- PFILE option, 3-10
- PhysicalDrive, A-3
- PWDSID.ORA file, 3-15
R
- raw partition
- defined, A-2
- logical partition, A-4
- overview, A-2
- physical disk, A-3
- recovering, an Oracle9i database, 6-2
- recovery file types, OCOPY, 6-6
- Recovery Manager
- capabilities, 6-2
- overview, 6-2
- redo log files
- archiving, 3-20
- REGEDT32 command, 1-19
- registry
- Hostname, 4-3
- ORA_SHUTDOWN, 3-12
- ORA_SID_AUTOSTART, 3-11
- ORA_SID_PFILE, 3-11
- ORA_SID_SHUTDOWN, 3-12
- ORA_SID_SHUTDOWN_TIMEOUT, 3-13
- ORA_SID_SHUTDOWNTYPE, 3-13
- password value, 4-3
- update ORACLE_SID, 1-19
- Username, 4-3
- remote computers, accessing database files, 3-19
- REMOTE_LOGIN_PASSWORDFILE parameter, 3-15
- Report View, 4-5
S
- schemas
- importing an OLTP sample schema, 1-8
- importing an Warehousing sample schema, 1-8
- SERVICE_NAME parameter, 1-15
- services, 3-2
- auto-starting, 3-8
- OracleAgent, 3-4
- OracleHOME_NAMEClientCache, 3-5
- OracleServiceSID, 3-4
- OracleTNSListener, 3-4
- shutting down a database by stopping a service, 3-11
- starting, 1-16, 3-5
- stopping, 3-6
- SET ORACLE_SID=SID, 3-14
- shadow process memory, 7-7
- shared server mode, 2-10
- SHARED_MEMORY_ADDRESS parameter, 7-5
- SHUTDOWN command
- options, 3-10
- using, 3-10
- shutting down
- databases, 3-9, 3-11
- specifying an archiving file format, 3-21
- SPIN_COUNT parameter, 7-5
- SQL*Plus
- running multiple instances, 3-14
- shutting down the database, 3-9
- starting, 3-9
- starting the database, 3-9
- using ORADEBUG, 3-23
- starter database
- archiving mode, 3-20
- starting
- databases, 3-9
- Oracle Services, 3-5
- Performance Monitor, 4-4
- SQL*Plus, 3-9
- STARTUP command, 3-10
- stopping, Oracle Services, 3-6
- symbolic links
- creating, A-9
- syntax
- for backing up files with OCOPY, 6-5
- for recovering files with OCOPY, 6-6
- system identifier
- defined, 3-4
T
- tablespaces
- Advanced Replication support, 2-13, 2-14
- third-party backup and recovery vendors, 6-3
- trace files, 4-13
- creating with ORADEBUG, 3-23
- for monitoring a database, 4-2
- using, 4-13
- using BACKGROUND_DUMP_DEST parameter, 4-13
- using USER_DUMP_DEST, 4-13
- troubleshooting
- with ORADEBUG, 3-23
- tuning Windows NT Server operating system, 5-2
U
- UNC, 1-3, 3-19
- Universal Naming Convention, 1-3, 3-19
- USER_DUMP_DEST parameter, 1-15, 4-13
V
- viewing
- password file, 3-17
W
- Warehousing
- importing a sample schema, 1-8
- Windows NT tuning
- applying latest service packs, 5-10
- closing unnecessary foreground applications, 5-17
- configuring server to be an application server, 5-4
- disable unnecessary services, 5-6
- multiple striped volumes for sequential and random access, 5-16
- overview, 5-2
- reducing priority of foreground applications on sever, 5-3
- removing unused network protocols, 5-7
- resetting the network protocol bind order, 5-8
- screen savers, 5-17
- spanning server virtual memory paging file across physical volumes, 5-16
- startup folder, 5-17
- using hardware and operating system striping, 5-11
- virtual DOS machines, 5-17
- wizards
- Oracle Enterprise Manager Backup Wizard, 6-2