Oracle8i Parallel Server Getting Started
Release 8.1.5 for Windows NT
A68813-01

Library

Product

Contents

Prev

Index

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

Symbols

\\.\PhysicalDriveX, 3-5, Glossary-7
\DBCA directory, A-4
\MANUAL, A-4
\OPS directory, A-2, A-4
\OPSM, A-4
\PARALLEL_SERVER directory, A-2

A

administering instances, 7-1 to 7-14

B

BACKGROUND_DUMP_DEST parameter, C-13, C-14
BSP0 process, 1-13

C

C:\ORACLE, explained, A-2
C:\ORANT, defined, xix
C:\ORAWIN, defined, xix
C:\ORAWIN95, defined, xix
CACHE_SIZE_THRESHOLD parameter, 7-9
CHECKPOINT_PROCESS parameter, 7-7
Choose Start >, defined, xviii
Cluster Management component, described, 1-7
Cluster Manager
defined, 1-4, Glossary-1
See CM, 1-6
cluster, defined, 1-10
CM, C-6
check-ins, C-7
cluster interconnect, C-3
Cluster Management, 1-7
CmDiskFile registry value, B-3
CM.EXE, C-6, C-8
CmHostName registry value, B-3, C-5
CM.LOG, C-6, C-12
CmSrvrPath registry value, B-3, C-3, C-6, C-8
configuration tips, C-2
configuration verification, C-3
creating a CM service, C-3
creating a CM service with tracing, C-8
defined, 1-4, Glossary-2
DefinedNodes, C-4
DefinedNodes registry value, B-3, C-11
de-installing as a service, C-3
described, 1-6
determining groups available, 1-7, Glossary-2
determining instances available, 1-7, Glossary-2
ErrorLog registry value, B-3, C-6
installing as a service, C-3
interacting with IDLM, 1-6, 1-16
MissCount registry value, B-3, C-7
NM.DLL, C-6
NM.LOG, C-7
Node Monitor, 1-6
PollInterval registry value, B-3, C-7
secondary backup, C-9
software verification, C-2
tracing, C-8
troubleshooting, C-2
verifying proper setup, C-6
CM registry key, B-3
CmDiskFile registry value, B-3
CMDLL registry value, B-2
CM.EXE, C-6, C-8
CmHostName registry value, B-3, C-5
CM.LOG, C-6, C-12
CmSrvrPath registry value, B-3, C-3, C-6, C-8
configuration tasks
verification for CM, C-2
Consistent Read Server, 1-13
contact information, Oracle Support Services, xiii
control file, 1-13
CONTROL_FILES parameter, 7-9
CPU_COUNT parameter, 7-9
CR Server, 1-13

D

data files, 1-13, 1-14
database creation failure, C-10
database files, 1-10
database name
OP, 7-2
database, defined, 1-10
DB_BLOCK_SIZE parameter, 7-9
DB_FILES parameter, 7-9
DB_NAME parameter, 1-10, 7-2, 7-9
DBA locking, 1-18
DBWR process, 1-13
DefinedNodes, C-4
DefinedNodes registry value, B-3, C-11
DELAYED_LOGGING_BLOCK_

CLEANOUTS parameter, 7-7
directory structure, A-1 to A-5
disk definition, 3-4
disks, shared access, 1-14
Distributed Lock Manager, described, 1-13
DLL, defined, Glossary-2
DLM, described, 1-13
DML_LOCKS parameter, 7-7, 7-9
documentation
generic, xxi
operating system-specific, xxi
domain, defined, Glossary-2
domain, group, Glossary-1
DYNAMIC LOCKS ALLOCATED, C-12
DYNAMIC RESOURCES ALLOCATED, C-12

E

error call trace stack, C-14
error messages
resolving, xii
ErrorLog registry value, B-3, C-6
extended partition
create logical partitions, 3-12
creating, 3-10
defined, 3-2, Glossary-2

F

fine-grain locks, 1-18
1 block to 1 block ratio, 1-18
defined, Glossary-2
fixed, 1-18
releasable, 1-18
when to use, 1-19

G

GC list, 7-7
GC_FILES_TO_LOCKS parameter, 1-17, 7-7, 7-9
GC_LCK_PROCS parameter, 7-9
GC_RELEASABLE_LOCKS parameter, 1-18, 7-7
GC_ROLLBACK_LOCKS parameter, 7-7, 7-9
generic documentation references
configuration on Windows NT, 1-1
Conventions, xviii
fine grain locking, 1-18
OPSCTL, 7-12
Windows NT-specific location of *.SQL scripts, A-4
Global Constant Parameters list, 7-7
Group Membership Service, described, 1-7, Glossary-2
group, domain, Glossary-1

H

hashed locks, 1-18
fixed, 1-18
releasable, 1-18
when to use, 1-19
hashed locks, defined, Glossary-2
HOME_NAME, defined, xx
HOMEID, defined, xx

I

IDLM
block access synchronization, 1-16
deadlock detection, 1-16
defined, 1-15, Glossary-2
described, 1-15
interacting with CM, 1-6, 1-16
LMDN, 1-15
LMON, 1-15
modification synchronization, 1-16
IFILE parameter, 7-3, 7-4
infowin@us.oracle.com, xiii
INIT_COM.ORA, 7-2
BACKGROUND_DUMP_DEST, C-13, C-14
DB_NAME, 1-10
GC_FILES_TO_LOCKS, 1-17
GC_RELEASABLE_LOCKS, 1-18
Global Constant Parameters, 7-6
LM_LOCKS, C-12
LM_RESS, C-12
USER_DUMP_DEST, C-14
INITDB_NAME.ORA, 7-2
CACHE_SIZE_THRESHOLD, 7-9
CHECKPOINT_PROCESS, 7-7
CONTROL_FILES, 7-9
CPU_COUNT, 7-9
DB_BLOCK_SIZE, 7-9
DB_FILES, 7-9
DB_NAME, 1-10, 7-2, 7-9
DELAYED_LOGGING_BLOCK_

CLEANOUTS, 7-7
DML_LOCKS, 7-7, 7-9
GC_FILES_TO_LOCKS, 7-7, 7-9
GC_LCK_PROCS, 7-9
GC_RELEASABLE_LOCKS, 7-7
GC_ROLLBACK_LOCKS, 7-7, 7-9
identical parameters, 7-9
INSTANCE_NUMBER, 7-7
LM_LOCKS, 7-9, 7-10
LM_PROCS, 7-9, 7-10
LM_RESS, 7-9, 7-10
LOG_ARCHIVE_FORMAT, 7-7
LOG_FILES, 7-9
MAX_COMMIT_PROPAGATION_DELAY, 7-7, 7-9
NLS_* parameter, 7-8
PARALLEL_DEFAULT_MAX_INSTANCES, 7-9
PARALLEL_DEFAULT_MAX_SCANS, 7-9
PARALLEL_SERVER parameter, 7-8
parameter notes, 7-7
PROCESSES, 7-8
RECOVERY_PARALLELISM, 7-8
ROLLBACK_SEGMENTS, 7-8, 7-9
ROW_LOCKING, 7-9
SERIALIZABLE, 7-9
THREAD, 7-8
initialization files, 7-1 to 7-14
definition, 7-2
editing, 7-10
for instances, 7-2
identical parameters, 7-9
INIT_COM.ORA, 7-2
INITDB_NAME.ORA, 7-2
INITSID.ORA, 7-2
location, 7-9, 7-10
initialization parameters
descriptions, 7-10
editing, 7-10
Global Constant Parameters, 7-6
identical, 7-9
setting, 7-6
INITSID.ORA, 1-11, 7-2
IFILE, 7-3, 7-4
INSTANCE_NAME, 1-11, 7-4
PARALLEL_SERVER, 7-4
ROLLBACK_SEGMENTS, 1-11, 7-4
THREAD, 1-11, 7-4
Input/Output
defined, 1-4, Glossary-3
described, 1-8
INSTANCE_NAME parameter, 1-11, 7-4
INSTANCE_NUMBER parameter, 7-7
instances
administering, 7-1 to 7-14
defined, 1-10, Glossary-3
identical parameters, 7-9
issues, 7-6
setting initialization parameters, 7-6
shutdown, 7-14
starting and stopping, 7-11
starting with OPSCTL, 7-12
stopping with OPSCTL, 7-14
Integrated Distributed Lock Manager
defined, 1-15, Glossary-3
described, 1-15
See IDLM
Inter-Process Communication
defined, 1-4
described, 1-8
Inter-process Communication, defined, Glossary-3
IO, defined, 1-4, Glossary-3
IODLL registry value, B-2
IPC, defined, 1-4, Glossary-4
IPCDLL registry value, B-2

L

LCKN process, 1-13
LGWR process, 1-13
listener, defined, Glossary-4
LISTENER.ORA, defined, Glossary-4
LM_LOCKS parameter, 7-9, 7-10, C-12
LM_PROCS parameter, 7-9, 7-10
LM_RESS parameter, 7-9, 7-10, C-12
LMD0 process, 1-13
LMDN process, 1-15
LMON process, 1-13, 1-15
LMON process, defined, Glossary-4
LMON, defined, Glossary-4
LOG_ARCHIVE_FORMAT parameter, 7-7
LOG_FILES parameter, 7-9
logical partitions
creating, 3-12
defined, Glossary-4
unassigning drive letters, 3-16

M

MAX_COMMIT_PROPAGATION_DELAY parameter, 7-7, 7-9
MissCount registry value, B-3, C-7
multiple Oracle homes
defined, xix

N

NLS_* parameter, 7-8
NM, C-6
NM.DLL, C-6
NM.EXE, C-6
NM.LOG, C-7
Node Monitor component, described, 1-6
node, defined, 1-10, Glossary-5

O

OFA, defined, 1-23
Operating System Dependent layer
defined, Glossary-6
See OSD
OPQ
defined, 1-15, Glossary-5, Glossary-6
described, 1-20
issuing SQL statements, 1-22
OPSCTL requirements, 7-12
OPSCTL START usage, 7-13
OPSCTL STOP usage, 7-14
OPSCTL utility, Glossary-5
defined, Glossary-5, Glossary-6
managing instances, 7-12
OPSM
defined, 1-3, Glossary-5
OPSCTL requirements, 7-12
Oracle Enterprise Manager, 1-3
registry entries, B-4
starting and stopping instances, 7-11
using, 7-11
OP.TBL file, 3-19, 3-20
Optimal Flexible Architecture, defined, 1-23
ORA-29702, C-12
ORA-600, C-17
ORA-600 (9030), C-16
Oracle Database Configuration Assistant
error message, C-11
failing, C-10
Oracle Enterprise Manager
defined, Glossary-5
OPSM, 1-3
Oracle Parallel Query
defined, 1-15, Glossary-5
described, 1-20
issuing SQL statements, 1-22
See OPQ
Oracle Parallel Server
database files, 1-14
defined, Glossary-5
overview, 1-1 to 1-24
Oracle Parallel Server Manager
defined, Glossary-5
OPSCTL requirements, 7-12
See OPSM
starting and stopping instances, 7-11
using, 7-11
Oracle Parallel Server Option
defined, 1-3
Oracle Performance Manager, 7-11
Oracle service, defined, Glossary-6
Oracle Support Services
contact information, xiii
contacting, xii
Oracle Universal Installer
defined, 1-23
ORACLE_BASE, explained, A-2
ORACLE_HOME, explained, xix
Oracle8 database
location of *.SQL scripts, A-4
Oracle8 database, defined, Glossary-6
Oracle8 Enterprise Edition
defined, 1-3
Oracle8 ORDBMS, defined, Glossary-6
OracleServiceSID registry key
registry
OracleServiceSID, C-10
ORAXXXXX.TRC file, C-14
OSD
Cluster Manager (CM), 1-6
components, 1-4
defined, 1-3, Glossary-6
described, 1-4
Input/Output, 1-8
Inter-Process Communication (Node-to-Node), 1-8
Startup, 1-9
OSD registry key, B-2

P

Parallel Cache Management
defined, 1-15, Glossary-6
described, 1-17
See PCM
parallel coordinator, defined, 1-20, Glossary-6
parallel server process, defined, 1-20, Glossary-7
PARALLEL_DEFAULT_MAX_INSTANCES parameter, 7-9
PARALLEL_DEFAULT_MAX_SCANS parameter, 7-9
PARALLEL_SERVER parameter, 7-4, 7-8
partition
extended, 3-2
logical partition, 3-6
physical disk, 3-5
raw, 3-2
PCM
defined, 1-15, Glossary-7
described, 1-17
fine-grain locks, 1-18
fine-grain locks usage, 1-19
hashed locking usage, 1-19
hashed locks, 1-18
PFILE option, 7-10
PGMS
Cluster Manager, 1-7, Glossary-1, Glossary-2
described, 1-7, Glossary-2
physical disk, defined, Glossary-7
PhysicalDrive, 3-5, C-16
PM registry key, B-4
PM\DB_NAME registry key, C-10
PMDLL registry value, B-2
PMON process, 1-13
PollInterval registry value, B-3, C-7
pre-installation tasks, 3-1 to 3-23
primary partition, defined, Glossary-7
PROCESSES parameter, 7-8

R

raw partition
defined, 3-2
logical partition, 3-6
overview, 3-2
physical disk, 3-5
raw partition definition, 3-5
RECOVERY_PARALLELISM parameter, 7-8
REG_MULTI_SZ, B-4
registry
CM key, B-3
CmDiskFile, B-3
CMDLL, B-2
CmHostName, B-3, C-5
CmSrvrPath, B-3, C-3, C-6, C-8
DefinedNodes, B-3, C-4, C-11
entries defined, B-2
entries for CM, B-3
entries for OPSM, B-4
ErrorLog, B-3, C-6
generic DLL values, B-2
IODLL, B-2
IPCDLL, B-2
MissCount, B-3, C-7
OSD key, B-2
PM key, B-4
PM\DB_NAME key, C-10
PMDLL, B-2
PollInterval, B-3, C-7
STARTDLL, B-2
resources, 1-15
ROLLBACK_SEGMENTS parameter, 1-11, 7-4, 7-8, 7-9
ROW_LOCKING parameter, 7-9

S

SERIALIZABLE parameter, 7-9
SETLINKS utility, 3-18
defined, Glossary-7
SGA, defined, 1-10
shared disks, 1-14
Shared Global Area, defined, 1-10
SHUTDOWN ABORT, C-16
SID, defined, 1-11, Glossary-7
SIDALRT.LOG file, C-14
SIDBSP0.TRC file, C-13
SIDLCKN.TRC file, C-13
SIDLMDN.TRC file, C-13
SIDLMON.TRC file, C-13, C-15
SIDP00N.TRC file, C-13
SMON process, 1-13
square brackets, defined, xviii
START, defined, 1-4, Glossary-8
STARTDLL registry value, B-2
Startup
defined, 1-4, Glossary-7
described, 1-9
syntax
for creating CM service, C-3
for creating CM service with tracing, C-8
for starting instances with OPSCTL, 7-13
for stopping instances with OPSCTL, 7-14
system ID, defined, Glossary-7

T

tablespace, defined, Glossary-8
TEMPLATE.TBL file, 3-19
THREAD parameter, 1-11, 7-4, 7-8
TNSNAMES.ORA, defined, Glossary-8
To, C-8
trace files, C-13
background thread trace files, C-13
CM.LOG, C-8
error call trace stack, C-14
ORAXXXXX.TRC, C-14
SIDALRT.LOG, C-14
SIDBSP0.TRC, C-13
SIDLCKN.TRC, C-13
SIDLMDN.TRC, C-13
SIDLMON.TRC file, C-13
SIDP00N.TRC, C-13
troubleshooting, xii, C-1 to C-17

U

unassign drive letters, 3-16
USER_DUMP_DEST parameter, C-14

V

V$PQ_SYSSTAT, 1-22
vsa@us.oracle.com, xiv

Prev
Oracle
Copyright © 1999 Oracle Corporation.
All Rights Reserved.
Library Product Contents