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