Oracle Parallel Server Getting Started
Release 8.0.6 for Windows NT

A69942-01

Library

Product

Contents

Prev

Index

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


Symbols

\\.\PhysicalDrivex, 3-4, Glossary-6

A

A2OWIZ80 directory, A-2
administering instances, 7-1 to 7-12
AGENTBIN directory, A-2
ALTER DATABASE ADD LOGFILE, 8-2
automatic discovery, 6-15

B

BACKGROUND_DUMP_DEST parameter, B-10
backup, 9-1 to 9-3
BIN directory, A-2

C

C:\ORANT, defined, xxi
C:\ORAWIN95, defined, xxi
C_OPS3.SQL script, 8-13
C_OPS4.SQL script, 8-13
CACHE_SIZE_THRESHOLD parameter, 7-7
CATALOG.SQL script, 8-8
CATPARR.SQL script, 8-8
CATPROC.SQL script, 8-8
CHECKPOINT_PROCESS parameter, 7-6
Choose Start >, defined, xx
Cluster Manager
check-ins, B-5
CmHostName, B-4
CM.LOG, B-5
configuration tips, B-2
configuration verification, B-2
defined, 1-4, Glossary-1
DefinedNodes, B-3
described, 1-5
ErrorLog, B-6, B-13
MissCount, B-5
PGMS, 1-3
PollInterval, B-5
secondary backup, B-6
software, B-2
troubleshooting, B-2
cluster, defined, 1-8, Glossary-1
CM, defined, 1-4, Glossary-1
CM.LOG, B-5, B-13
configuration, 5-1 to 5-20
configuration files
LISTENER_NODE_HOSTNAME.ORA, 5-13
LISTENER.ORA, 5-12
testing, 5-15
TNSNAMES.ORA, 5-12, 5-13, 6-4
TOPOLOGY.OPS, 5-13
using OPSCONF, 5-13
configure
domains, 5-7
Oracle Enterprise Manager, 6-8 to 6-17
Oracle Parallel Server, 5-1 to 5-20
Oracle Performance Manager, 6-18 to 6-20
OSD, 5-7
single instance to parallel server, 8-2 to 8-10
third or fourth node, 8-10 to 8-14
control file, 1-9
CONTROL_FILES parameter, 7-7
CPU_COUNT parameter, 7-7
CREATE DATABASE script, 8-5
CRTSRV batch file, 5-8
Customer Support
contacting, xii

D

data files, 1-9, 1-10
database creation, 5-15, 8-5
DATABASE directory, A-2
DB_BLOCK_SIZE parameter, 7-7
DB_FILES parameter, 7-7
DB_NAME parameter, 1-8, 5-7, 7-7
DBA locking, 1-14
DBA_DATA_FILES, 8-6
DBS directory, A-2
DBWR process, 1-9
DefinedNodes, B-3
DELAYED_LOGGING_BLOCK_
CLEANOUTS parameter, 7-6
directory
A2OWIZ80, A-2
AGENTBIN, A-2
BIN, A-2
DATABASE, A-2
DBS, A-2
EERN805, A-2
JRE11, A-2
MSHELP, A-2
NET80, A-2
NLSRTL33, A-2
OPS, A-2
ORAINST, A-2
OTRACE80, A-2
PLSQL80, A-3
PLUS80, A-3
RDBMS80, A-3
SYSMAN, A-3
VS10, A-3
directory structure, A-2 to A-3
discovery, 6-15
disk definition, 3-4
disks, shared access, 1-10
Distributed Lock Manager, described, 1-9
DISTRIBUTED_TRANSACTIONS parameter, 6-18
DLL, defined, Glossary-1
DLM, described, 1-9
DML_LOCKS parameter, 7-6, 7-7
documentation
generic, xxii
operating system-specific, xxii
domain, defined, 1-8, Glossary-1
domain, group, 1-3
During, B-5
DYNAMIC LOCKS ALLOCATED, B-9
DYNAMIC RESOURCES ALLOCATED, B-9

E

EERN805 directory, A-2
error call trace stack, B-11
error messages
resolving, xii, B-14
EXP80, 8-5
export data from old database, 8-4
Export utility, 8-5
extended partition
create logical partitions, 3-9
creating, 3-8
defined, 3-2, Glossary-1

F

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

G

GC list, 7-5
GC_FILES_TO_LOCKS parameter, 1-13, 7-5, 7-7
GC_LCK_PROCS parameter, 7-5, 7-7
GC_RELEASABLE_LOCKS parameter, 1-13, 7-5
GC_ROLLBACK_LOCKS parameter, 7-5, 7-7
generic documentation references
configuration on Windows NT, 1-1
console OPSM software requirements, 6-5
fine grain locking, 1-14
node OPSM software requirements, 6-4
OPSCTL, 7-9
OPSM node software requirements, 5-17, 6-15, 6-18
Oracle Enterprise Manager architecture, 6-6
Oracle Enterprise Manager auto-discovery, 6-15
Oracle Parallel Server data files and log files, 5-3, 8-6
PGMS startup, 5-8
start an instance, 5-17
Global Constant Parameters list, 7-5
Group Membership Service
defined, 1-3, Glossary-2
described, 1-3
See PGMS
group, domain, 1-3

H

hardware requirements, 2-2
hashed locks, 1-13
fixed, 1-13
releasable, 1-13
when to use, 1-15
hashed locks, defined, Glossary-2
HOME_NAME, defined, xxi
HOMEID, defined, xxi

I

IDLM
block access synchronization, 1-12
deadlock detection, 1-12
defined, 1-11, Glossary-2
described, 1-11
interaction with PGMS, 1-12
LMDn, 1-11
LMON, 1-11
modification synchronization, 1-12
If, B-14
IFILE parameter, 5-2, 7-3
IMP80, 8-9
import data, 8-9
Import utility, 8-9
INIT_COM.ORA, 5-5, 8-12
BACKGROUND_DUMP_DEST, B-10
CACHE_SIZE_THRESHOLD, 7-7
CHECKPOINT_PROCESS, 7-6
CONTROL_FILES, 7-7
CPU_COUNT, 7-7
DB_BLOCK_SIZE, 7-7
DB_FILES, 7-7
DB_NAME, 1-8, 5-7, 7-7
DELAYED_LOGGING_BLOCK_
CLEANOUTS, 7-6
DISTRIBUTED_TRANSACTIONS, 6-18
DML_LOCKS, 7-6, 7-7
GC_FILES_TO_LOCKS, 1-13, 7-5, 7-7
GC_LCK_PROCS, 7-5, 7-7
GC_RELEASABLE_LOCKS, 1-13, 7-5
GC_ROLLBACK_LOCKS, 7-5, 7-7
Global Constant Parameters, 7-5
identical parameters, 7-7
INSTANCE_NUMBER, 7-6
LM_LOCKS, 7-7, B-9
LM_PROCS, 7-7, 7-8
LM_RESS, 7-7, 7-8, B-9
LOG_ARCHIVE_FORMAT, 7-6
LOG_FILES, 7-7
MAX_COMMIT_PROPAGATION_DELAY, 7-6, 7-7
NLS_* parameter, 7-6
OPEN_LINKS, 6-18
PARALLEL_DEFAULT_MAX_INSTANCES, 7-7
PARALLEL_DEFAULT_MAX_SCANS, 7-7
PARALLEL_SERVER, 5-18
PARALLEL_SERVER parameter, 7-6
parameter notes, 7-6
PROCESSES, 7-6
RECOVERY_PARALLELISM, 7-6
ROLLBACK_SEGMENTS, 7-6, 7-7
ROW_LOCKING, 7-7
SERIALIZABLE, 7-7
THREAD, 7-6
USER_DUMP_DEST, B-10
INITCOM.ORA, 7-2
initialization files, 7-1 to 7-12
definition, 7-2
editing, 7-8
for instances, 7-2
identical parameters, 7-7
INITCOM.ORA, 7-2
INITSID.ORA, 7-2
location, 7-7, 7-8
initialization parameters
descriptions, 7-8
editing, 7-8
Global Constant Parameters, 7-5
identical, 7-7
setting, 7-4
INITSID.ORA, 5-5, 7-2
IFILE, 5-2, 7-3
INSTANCE_NUMBER, 5-7, 7-3
ROLLBACK_SEGMENTS, 7-3
THREAD, 7-3
Input/Output
defined, 1-4, Glossary-2, Glossary-3
described, 1-6
install
Oracle Diagnostic Pack, 6-8
Oracle Enterprise Manager, 6-7
Oracle Parallel Server Manager Server, 4-3
Oracle Parallel Server Option, 4-2, 4-3, 8-3
Oracle8 Enterprise Edition, 4-2, 8-3
OSD, 4-3, 8-4
repository database, 6-7
installation, 4-1 to 4-3
installation requirements, 2-1
disk space, 2-4
hardware, 2-2
shared disk partitions, 2-4
software, 2-3
INSTANCE_NUMBER parameter, 5-7, 7-3, 7-6
instances
administering, 7-1 to 7-12
defined, 1-8, Glossary-2
identical parameters, 7-7
issues, 7-5
setting initialization parameters, 7-5
shutdown, 7-11
starting and stopping, 7-8
starting with OPSCTL, 7-9
stopping with OPSCTL, 7-11
verifying, 5-19
Integrated Distributed Lock Manager
defined, 1-11
described, 1-11
See IDLM
Integrated Distributed Lock Manager, defined, Glossary-3
Inter-Process Communication
defined, 1-4
described, 1-6
Interprocess Communication, defined, Glossary-3
IO, defined, 1-4, Glossary-2
IPC, defined, 1-4, Glossary-3

J

JRE11 directory, A-2

L

LCKn process, 1-9
LGWR process, 1-9
listener
defined, Glossary-3
OracleHOME_NAMETNSListener80 service, 5-15
OracleHOME_NAMETNSListener80LSNR service, 5-15
starting, 5-15
starting from Control Panel, 5-15
LISTENER_NODE_HOSTNAME.ORA file, 5-13
LISTENER.ORA file, 5-12
LISTENER.ORA, defined, Glossary-3
LM_LOCKS parameter, 7-7, B-9
LM_PROCS parameter, 7-7, 7-8
LM_RESS parameter, 7-7, 7-8, B-9
LMD0 process, 1-9
LMDn process, 1-11
LMON process, 1-9, 1-11
LMON process, defined, Glossary-3
LMON, defined, Glossary-3
LOG_ARCHIVE_FORMAT parameter, 7-6
LOG_FILES parameter, 7-7
logfile, 8-6
logical partitions
assigning symbolic links, 5-2, 8-11
creating, 3-9
defined, Glossary-3
unassigning drive letters, 3-13

M

Make, B-2
MAX_COMMIT_PROPAGATION_DELAY parameter, 7-6, 7-7
MSHELP directory, A-2
multiple Oracle homes, 4-2
OraclePGMSService, 4-2
OSD, 4-2

N

Net8 Client, 6-5
NET80 directory, A-2
NLS_* parameter, 7-6
NLSRTL33 directory, A-2
node, defined, 1-8, Glossary-3
NT Backup Manager, 9-1 to 9-3
NT Recovery Manager, 9-1 to 9-3
NT user account
creating, 6-11

O

OPEN_LINKS parameter, 6-18
Operating System Dependent layer
components, 1-4
defined, 1-3, Glossary-5
described, 1-4
See OSD
OPQ
defined, 1-11, Glossary-4, Glossary-5
described, 1-15
issuing SQL statements, 1-17
OPS directory, A-2
OPS_8MON.SQL script, 6-18
OPS_cntr01, 5-4
OPS_log1t1, 5-3
OPS_log1t2, 5-4
OPS_log2t1, 5-3, 5-4
OPS_MON.SQL script, 6-4
OPS_rbs01, 5-3
OPS_sys01, 5-3
OPS_tmp01, 5-4
OPS_usr01, 5-3
OPSALL.SQL script, 5-16
OPSCONF utility, 5-13
defined, Glossary-4, Glossary-5
using, 5-14
OPSCTL requirements, 7-10
OPSCTL START usage, 7-10
OPSCTL STOP usage, 7-11
OPSCTL utility, 6-3, Glossary-4
architecture, 6-3
defined, Glossary-4, Glossary-5
managing instances, 7-9
OPSM, 4-3
configuration, 6-1 to 6-20
defined, 1-2, Glossary-4
node requirements, 6-4
OPSCTL requirements, 7-10
OPSCTL utility, 6-3
Oracle Enterprise Manager, 1-2
Oracle Enterprise Manager Console requirements, 6-5
requirements, 6-4
starting and stopping instances, 7-8
using, 7-9
OPSREG80 ADD, 5-16, 5-17, 6-9, 8-13, B-8
OPSREG80 DEL, B-9
OPS.SQL script, 5-5, 8-12
ORA XXXXX.TRC file, B-10
ORA-29702, B-8
ORA-600, B-14
ORA-600 (9030), B-13
Oracle, B-11
Oracle Data Manager, 8-4, 8-9
Oracle Diagnostic Pack, 6-8
Oracle Diagnostics Pack, 6-5
Oracle Diagnostics Pack, installation, 6-8
Oracle Enterprise Manager
configuration files
creating, 6-14
configuration steps, 6-8 to 6-17
create the repository, 6-15
creating a repository user account, 6-10
creating an Windows NT user account, 6-11
creating NT user account, 6-11
defined, Glossary-4, Glossary-5
install, 6-7
install Oracle Diagnostics Pack, 6-8
install repository database, 6-7
installation, 6-7
OPSM, 1-2
start Oracle services, 6-9
User Manager, 6-11
verifying Oracle Services, 6-9
Oracle Enterprise Manager Console
defined, 6-2
Oracle Intelligent Agent
defined, 6-3
Oracle Net8 Easy Config, defined, Glossary-4
Oracle Parallel Query
defined, 1-11, Glossary-4
described, 1-15
issuing SQL statements, 1-17
See OPQ
Oracle Parallel Server
database files, 1-10
defined, Glossary-4
overview, 1-1 to 1-18
Oracle Parallel Server database
creating, 5-15, 8-5
starting, 5-17, 8-10
Oracle Parallel Server Manager, 4-3
configuration, 6-1 to 6-20
defined, 1-2, Glossary-4
OPSCTL requirements, 7-10
See OPSM
starting and stopping instances, 7-8
using, 7-9
Oracle Parallel Server Manager Server, defined, 4-3
Oracle Parallel Server Option
defined, 1-2, 4-3
installing, 4-2
Oracle Parallel Server Option, installing, 8-3
Oracle Performance Manager, 7-9
configuration steps, 6-18 to 6-20
defined, 6-2
described, 6-2
installation, 6-7
OPS_8MON.SQL, 6-18
OPS_MON.SQL, 6-4
starting, 6-19
Oracle service, defined, Glossary-5
ORACLE_HOME, explained, xxi
ORACLE_SID parameter, add to registry, 5-10, 9-2
Oracle8 database, defined, Glossary-5
Oracle8 Enterprise Edition, defined, 1-2
Oracle8 Enterprise Edition, installing, 4-2, 8-3
Oracle8 ORDBMS, defined, Glossary-5
OracleHOME_NAMETNSListener80 service, 5-13, 5-15
OracleHOME_NAMETNSListener80LSNR service, 5-15
OracleHOME_NAMETNSListenerLSNR service, 5-13
OraclePGMSService service, 1-3, 4-3
OraclePGMSService, de-installing, B-12
OraclePGMSService, multiple Oracle homes, 4-2
OracleServiceSID, creating, 5-8
ORAINST directory, A-2
ORALINK*.TBL file, 8-3
ORALINK1.TBL file, 5-2, 5-3
ORALINK2.TBL file, 5-2, 8-11
ORALINK3.TBL file, 5-2, 8-11
OSD
Cluster Manager (CM), 1-5
components, 1-4
configure, 5-7
defined, 1-3, Glossary-5
described, 1-4
Input/Output, 1-6
Inter-Process Communication (Node-to-Node), 1-6
multiple Oracle homes, 4-2
Performance and Management, 1-7
Startup, 1-7
OSD files, installing, 4-3, 8-4
OTRACE80 directory, A-2

P

P&M, defined, 1-4, Glossary-5
PARALLEL, 5-18
Parallel Cache Management
defined, 1-11, Glossary-6
described, 1-12
See PCM
parallel coordinator, defined, 1-15, Glossary-6
PARALLEL option, 5-18, 8-8
parallel server process, defined, 1-15, Glossary-6
PARALLEL_DEFAULT_MAX_INSTANCES parameter, 7-7
PARALLEL_DEFAULT_MAX_SCANS parameter, 7-7
PARALLEL_SERVER parameter, 5-18, 7-6
partition
extended, 3-2
logical partition, 3-5
physical disk, 3-4
raw, 3-2
PCM
defined, 1-11, Glossary-6
described, 1-12
fine-grain locks, 1-14
fine-grain locks usage, 1-15
hashed locking usage, 1-15
hashed locks, 1-13
Performance and Management
defined, 1-4, Glossary-6
described, 1-7
OPSM, 1-7
Performance and Management (P&M)
PM key, B-7
PFILE option, 7-8
PGMS, B-5
Cluster Manager, 1-3
defined, 1-3, Glossary-6
described, 1-3
PGMS.LOG, B-5
PGMS.EXE, 4-2
PGMS.LOG, B-5, B-12
PGMS.LOG file, B-5, B-8
physical disk, defined, Glossary-6
PhysicalDrive, 3-4, B-13
PLSQL80 directory, A-3
PLUS80 directory, A-3
PMON process, 1-9
pre-installation tasks, 3-1 to 3-14
primary node, defined, 1-9
primary partition, defined, Glossary-6
PROCESSES parameter, 7-6

R

raw partition
creating, 8-3
defined, 3-2
logical partition, 3-5
overview, 3-2
physical disk, 3-4
raw partition definition, 3-4
RDBMS80 directory, A-3
recovery, 9-1 to 9-3
RECOVERY_PARALLELISM parameter, 7-6
redo logs, 1-9
REGEDT32, 5-11
registry
CmHostName, B-4
DefinedNodes, B-3
ErrorLog, B-6, B-13
MissCount, B-5
PM key, B-7
PollInterval, B-5
registry, adding ORACLE_SID entry, 5-10, 9-2
repository database
defined, 6-2
repository user account, 6-10
resources, 1-11
ROLLBACK_SEGMENTS parameter, 7-3, 7-6, 7-7
ROW_LOCKING parameter, 7-7

S

secondary, B-6
SERIALIZABLE parameter, 7-7
services, create, 5-8
SETLINKS utility, 5-2, 8-11
create symbolic links, 5-2, 8-11
defined, Glossary-7
ignoring links, 5-6
OPS_cntr01, 5-4
OPS_log1t1, 5-3
OPS_log1t2, 5-4
OPS_log2t1, 5-3, 5-4
OPS_rbs01, 5-3
OPS_sys01, 5-3
OPS_tmp01, 5-4
OPS_usr01, 5-3
removing links, 5-6
SGA, defined, 1-8, Glossary-2
shared disk storage subsystem, 2-4
shared disks, 1-10
Shared Global Area, defined, 1-8, Glossary-2
SHUTDOWN ABORT, B-13
SID, defined, 1-9, Glossary-6
SIDALRT.LOG file, B-10
SIDLCKn.TRC file, B-10
SIDLMDn.TRC file, B-10
SIDLMON.TRC file, 5-17, 5-18, B-8, B-10, B-11
SIDP00n.TRC file, B-10
SMON process, 1-9
SNMP_RO.ORA file, 6-9
SNMP_RW.ORA file, 6-9
software requirements, 2-3
square brackets, defined, xx
START, defined, 1-4, Glossary-7
starting Oracle Parallel Server database, 5-17, 8-10
Startup
defined, 1-4, Glossary-7
described, 1-7
symbolic link
creating, 5-2, 8-11
ignoring, 5-6
removal, 5-6
SYSMAN directory, A-3
system ID, defined, Glossary-7
system requirements, 2-1 to 2-4

T

tablespace, defined, Glossary-7
The, 5-3
THREAD parameter, 7-3, 7-6
TNSNAMES.ORA file, 5-12, 5-13, 6-4
TNSNAMES.ORA, defined, Glossary-7
TOPOLOGY.OPS file, 5-13
trace files, B-9
background thread trace files, B-9
CM.LOG, B-13
error call trace stack, B-11
ORA XXXXX.TRC, B-10
PGMS.LOG, B-12
SIDALRT.LOG, B-10
SIDLCKn.TRC, B-10
SIDLMDn.TRC, B-10
SIDLMON.TRC file, B-10
SIDP00n.TRC, B-10
troubleshooting, xii, B-1 to B-14
Typically, B-2

U

unassign drive letters, 3-13
User Manager
for Oracle Enterprise Manager, 6-11
user preferences, 6-5
USER_DUMP_DEST parameter, B-10

V

V$ACTIVE_INSTANCES, 5-19
V$PQ_SYSSTAT, 1-17
VS10 directory, A-3

W

Windows NT user account
creating, 6-11

Prev
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents