Oracle8
i
Parallel Server Getting Started
Release 8.1.5 for Windows NT
A68813-01
Library
Product
Contents
Index
A
B
C
D
E
F
G
H
I
L
M
N
O
P
R
S
T
U
V
Symbols
\\.\PhysicalDrive
X
, 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
HOME
ID
, 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
LMD
N
, 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
INIT
DB_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
INIT
DB_NAME
.ORA, 7-2
INIT
SID
.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
INIT
SID
.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
LCK
N
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
LMD
N
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
OracleService
SID
registry key
registry
OracleService
SID
, C-10
ORA
XXXXX
.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
SID
ALRT.LOG file, C-14
SID
BSP0.TRC file, C-13
SID
LCK
N
.TRC file, C-13
SID
LMD
N
.TRC file, C-13
SID
LMON.TRC file, C-13,
C-15
SID
P00
N
.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
ORA
XXXXX
.TRC, C-14
SID
ALRT.LOG, C-14
SID
BSP0.TRC, C-13
SID
LCK
N
.TRC, C-13
SID
LMD
N
.TRC, C-13
SID
LMON.TRC file, C-13
SID
P00
N
.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
Copyright © 1999 Oracle Corporation.
All Rights Reserved.
Library
Product
Contents