Oracle9i Administrator's Guide -- Index

\\.\PhysicalDrivex, A-3

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

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:\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

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

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

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

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

HI_SHARED_MEMORY_ADDRESS parameter, 7-5

Hostname parameter, 4-3

hostname value, 4-3

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

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

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

naming conventions for multiple Oracle homes, 3-2

NET START command, 1-17

NOARCHIVELOG mode, 3-21

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

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

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

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

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

UNC, 1-3, 3-19

Universal Naming Convention, 1-3, 3-19

USER_DUMP_DEST parameter, 1-15, 4-13

viewing

password file, 3-17

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

Index

Symbols

A

B

C

D

E

F

G

H

I

L

M

N

O

P

R

S

T

U

V

W