Oracle9i Database Administrator's Guide -- Index

\\.\PhysicalDrivex, A-2

Advanced Replication support

data dictionary tables, 2-14

initialization parameter requirements, 2-13

tablespace requirements, 2-13, 2-14

alert files, 4-13

monitoring a database, 4-2

using, 4-13

ALTER DATABASE ARCHIVELOG command, 3-21

ARCHIVELOG mode, 3-21

archiving mode

controlling, 3-20

custom database, 3-20

starter database, 3-20

archiving procedures, 3-22

for redo log files, 3-20

specifying an archive destination, 3-22

UNC not allowed, 3-20

audit trail

managing, 4-12

AUDIT_FILE_DEST, 4-13

AUDIT_FILE_DEST parameter, 7-5

authentication

using a password file, 3-15

auto-starting

Oracle Services, 3-7

BACKGROUND_DUMP_DEST, 4-13

backup

databases, 1-26

OCOPY file types, 6-5

stopping services to perform cold backups, 6-4

backup and recovery tools

selecting, 6-2

block size

maximum, 7-7

parameter, 7-7

blocks for each file, maximum, 7-7

cold backups, performing, 6-4

commands

ALTER DATABASE ARCHIVELOG, 3-21

ARCHIVE LOG LIST, 3-21

CREATE DATABASE, 1-21

NET START, 1-22

REGEDT32, 1-24

configuring

Oracle Spatial, 2-8

Oracle Text, 2-5

CONNECT /AS SYSDBA

using, 3-10, 3-21

connecting

to a database, 3-10, 3-21

control files

additional backslashes in r. 8.0.4, 1-3, 3-20

maximum size, 7-7

CREATE DATABASE command, 1-21

custom database

archiving mode, 3-20

data dictionary

Advanced Replication tables, 2-14

data warehousing

importing a sample schema, 1-14

Database Configuration Assistant

deleting databases, 1-15

database files

deleting, 1-18

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-26

connecting to, 3-10, 3-21

creating manually, 1-15

deleting, 1-18

exporting, 1-17

importing, 1-23

monitoring, 4-2

naming conventions, 1-2

password encryption, 3-19

shutting down, 3-9, 3-11

starting, 3-9

DBLINK_ENCRYPT_LOGIN, 3-19

encrypting, database passwords, 3-19

error messages

ORA-00256, 1-3, 3-20

ORA-01102, 1-2

ORA-09291, 1-3, 3-20

OSD-04018, 1-3, 3-20

Event Viewer, 4-2

blue (informational) icon, 4-11

for monitoring a database, 4-2

managing, 4-12

reading, 4-11

red (stop sign) icon, 4-11

using, 4-9

yellow (exclamation point) icon, 4-11

Export Utility

databases, 1-17

interactive mode, 1-17

parameter mode, 1-17

extended partition

creating, A-5

defined, A-2

extents

maximum number for each database, 7-7

files

alert, 4-13

maximum number for each database, 7-7

maximum size possible, 7-7

sample init.ora, 7-3

trace, 4-13

Hostname parameter, 4-3

Import Utility

databases, 1-23

interactive mode, 1-23

parameter mode, 1-23

index size, calculating, 7-7

initialization parameter file

defined, 7-2

editing, 7-3

location, 7-2

initialization parameter requirements

Advanced Replication Support, 2-13

instances

modifying, 1-31

running multiple instances, 3-15

interactive mode

Export Utility, 1-17

Import Utility, 1-23

LOG_ARCHIVE_DEST_n, 1-3, 3-20, 3-22

LOG_ARCHIVE_FORMAT parameter, 3-22

LOG_ARCHIVE_START, 3-22

mapped drives, 1-3, 3-20

MAXDATAFILES, 1-20

memory usage, 5-4

monitoring

alert files, 4-2

Event Viewer, 4-2

Management Pack, 4-2

Performance Monitor, 4-2

trace files, 4-2

multiple instances, running, 3-15

multiple Oracle homes

service naming conventions, 3-2

naming conventions for multiple Oracle homes, 3-2

NET START command, 1-22

NOARCHIVELOG mode, 3-21

OCOPY

backup file types, 6-5

OLTP

importing a sample schema, 1-14

ORA_ENCRYPT_LOGIN, 3-19

ORA-00256 error, 1-3, 3-20

Oracle Enterprise Manager

Management Pack, 4-2

Oracle Managed Files, 1-21

Oracle Services

auto-starting, 3-7

naming conventions for multiple Oracle homes, 3-2

shutting down a database, 3-11

starting, 3-5

stopping, 3-6

Oracle Spatial

configuring, 2-8

Oracle Text

configuring, 2-5

ORACLE_SID, 1-24, 3-15

Oracle9i database

connecting to, 3-10, 3-21

password encryption, 3-19

selecting a backup and recovery tool, 6-2

shutting down, 3-9, 3-11

specifications, 7-7

starting, 3-9

ORADEBUG

debugging utility, 3-24

starting, 3-24

ORADIM

modifying an instance, 1-31

moving or copying password files, 3-17

ORAPWD

creating password files, 3-15

parameter mode

Export Utility, 1-17

Import Utility, 1-23

parameters

AUDIT_FILE_DEST, 4-13

BACKGROUND_DUMP_DEST, 4-13

block size, 7-7

DBLINK_ENCRYPT_LOGIN, 3-19

Hostname, 4-3

LOG_ARCHIVE_DEST_n, 1-3, 3-20, 3-22

LOG_ARCHIVE_FORMAT, 3-22

LOG_ARCHIVE_START, 3-22

ORA_ENCRYPT_LOGIN, 3-19

ORACLE_SID, 1-24, 3-15

Password, 4-3

REMOTE_LOGIN_PASSWORDFILE, 3-16

USER_DUMP_DEST, 4-13

Username, 4-3

partitions

extended, A-2

logical partition, A-3

physical disk, A-2

raw, A-2

password

encryption, 3-19

utility, 3-15

password file

authenticating database administrators, 3-15

creating, 3-15

hiding, 3-16

viewing, 3-17

Password parameter, 4-3

Performance Monitor, 4-2

accessing, 4-4

for monitoring a database, 4-2

Hostname parameter, 4-3

Password parameter, 4-3

registry information, 4-3

troubleshooting information, 4-9

Username parameter, 4-3

using, 4-2

Performance Pack, monitoring a database, 4-2

PhysicalDrive, A-2

PWDSID.ORA file, 3-15

raw partition

defined, A-2

logical partition, A-3

overview, A-2

physical disk, A-2

recovering

Oracle9i database, 6-2

redo log files

archiving, 3-20

REGEDT32 command, 1-24

registry

Hostname, 4-3

Password, 4-3

update ORACLE_SID, 1-24

Username, 4-3

remote computers, accessing database files, 3-20

REMOTE_LOGIN_PASSWORDFILE, 3-16

schemas

data warehousing, 1-14

OLTP, 1-14

services, 3-2

auto-starting, 3-7

shutting down a database, 3-11

starting, 1-20, 3-5

stopping, 3-6

SET ORACLE_SID=SID, 3-15

shared server

configuring, 2-9

disabling, 2-9

enabling, 2-9

shutting down

databases, 3-9, 3-11

specifying an archiving file format, 3-22

SQL*Plus

shutting down the database, 3-9

starting, 3-9

starting the database, 3-9

using ORADEBUG, 3-24

starter database

archiving mode, 3-20

starting

databases, 3-9

Oracle Services, 3-5

Performance Monitor, 4-4

SQL*Plus, 3-9

stopping, Oracle Services, 3-6

symbolic links

creating, A-9

tablespaces

Advanced Replication support, 2-13, 2-14

trace files, 4-13

creating with ORADEBUG, 3-24

for monitoring a database, 4-2

USER_DUMP_DEST, 4-13

using, 4-13

troubleshooting

with ORADEBUG, 3-24

tuning Windows NT Server operating system, 5-2

UNC, 1-3, 3-20

Universal Naming Convention, 1-3, 3-20

USER_DUMP_DEST, 4-13

Username parameter, 4-3

viewing

password file, 3-17

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 server, 5-3

removing unused network protocols, 5-7

resetting the network protocol bind order, 5-8

screen savers, 5-18

startup folder, 5-17

using hardware and operating system striping, 5-11

virtual DOS machines, 5-18

Windows NT-specific

archiving procedures, 3-22

audit trail availability, 4-11

audit trail facility, 4-11

automatic database startup after restart, 3-7

initialization parameter file, 7-2

parameter file location, 7-2

parameter filename and location, 7-2

password filename and location, 3-15

trace file names, 4-13

Index

Symbols

A

B

C

D

E

F

H

I

L

M

N

O

P

R

S

T

U

V

W