Skip Headers

Oracle9i Database Administrator's Guide
Release 2 (9.2) for Windows

Part Number A95491-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents

Master Index

Feedback

Go to previous page

Index

A  B  C  D  E  F  H  I  L  M  N  O  P  R  S  T  U  V  W 


Symbols

\\.\PhysicalDrivex, A-2

A

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

B

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

C

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

D

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

E

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

F

files
alert, 4-13
maximum number for each database, 7-7
maximum size possible, 7-7
sample init.ora, 7-3
trace, 4-13

H

Hostname parameter, 4-3

I

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

L

LOG_ARCHIVE_DEST_n, 1-3, 3-20, 3-22
LOG_ARCHIVE_FORMAT parameter, 3-22
LOG_ARCHIVE_START, 3-22

M

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

N

naming conventions for multiple Oracle homes, 3-2
NET START command, 1-22
NOARCHIVELOG mode, 3-21

O

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

P

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

R

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

S

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

T

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

U

UNC, 1-3, 3-20
Universal Naming Convention, 1-3, 3-20
USER_DUMP_DEST, 4-13
Username parameter, 4-3

V

viewing
password file, 3-17

W

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

Go to previous page
Oracle
Copyright © 1996, 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents

Master Index

Feedback