Oracle Parallel Server -- Index

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

Cluster Manager

check-ins, B-5

CmHostName, B-4

CM.LOG, B-5

configuration tips, B-2

configuration verification, B-2

defined, 1-5, Glossary-1

secondary backup, B-6

software, B-2

troubleshooting, B-2

cluster, defined, 1-10, Glossary-1

CM, defined, 1-5, Glossary-1

CM.LOG, B-5, B-15

configuration, 5-1 to 5-25

configuration file

LISTENER_NODE_HOSTNAME.ORA, 5-17

LISTENER.ORA, 5-16, 6-4

TNSNAMES.ORA, 5-16, 5-17, 6-4

configuration files

configure

Oracle Enterprise Manager, 6-8 to 6-19

Oracle Parallel Server, 5-1 to 5-25

Oracle Performance Manager, 6-20 to 6-22

OSD, 5-9

single instance to parallel server, 8-2 to 8-11

third or fourth node, 8-11 to 8-15

contact information

Oracle Technical Publications, xi

Oracle Worldwide Customer Support, xii

control file, 1-11

CONTROL_FILES parameter, 7-8

CPU_COUNT parameter, 7-8

CRTSRV batch file, 5-10

data files, 1-11, 1-12

database creation, 5-20, 8-6

DATABASE directory, A-2

DB_BLOCK_SIZE parameter, 7-8

DB_FILES parameter, 7-8

DB_NAME parameter, 1-10, 5-9, 7-8

DELAYED_LOGGING_BLOCK_

CLEANOUTS parameter, 7-6

directory

directory structure, A-1 to A-3

discover, 6-15

disk definition, 3-4

disks, shared access, 1-12

Distributed Lock Manager, described, 1-12

DISTRIBUTED_TRANSACTIONS parameter, 6-20

DLL, defined, Glossary-1

DLM, described, 1-12

DML_LOCKS parameter, 7-6, 7-8

documentation

generic, xxi

domain, defined, 1-10, Glossary-1

domain, group, 1-4

DYNAMIC LOCKS ALLOCATED, B-11

DYNAMIC RESOURCES ALLOCATED, B-11

EERN804 directory, A-2

error call trace stack, B-13

EXP80, 8-5

export data from old database, 8-5

Export utility, 8-5

extended partition

create logical partitions, 3-10

creating, 3-8

defined, 3-2, Glossary-1

fine-grain locks, 1-16

1 block to 1 block ratio, 1-16

GC_FILES_TO_LOCKS parameter, 1-15, 7-6, 7-8

GC_LCK_PROCS parameter, 7-6, 7-8

GC_RELEASABLE_LOCKS parameter, 1-16, 7-6

GC_ROLLBACK_LOCKS parameter, 7-6, 7-8

generic documentation references

configuration on Windows NT, 1-1

console OPSM software requirements, 6-5

fine grain locking, 1-16

node OPSM software requirements, 6-4

OPSCTL, 7-11

OPSM node software requirements, 5-22, 6-15, 6-20

Oracle Enterprise Manager architecture, 6-6

Oracle Enterprise Manager auto-discovery, 6-15

Oracle Parallel Server data files and log files, 5-4, 8-7

PGMS startup, 5-10

start an instance, 5-22

Global Constant Parameters list, 7-6

Group Membership Service

defined, 1-3, Glossary-2

described, 1-4

See PGMS

group, domain, 1-4

hardware requirements, 2-2

hashed locks, defined, Glossary-2

HOME_NAME, defined, xx

HOMEID

defined, xx

IDLM

block access synchronization, 1-14

deadlock detection, 1-14

defined, 1-13, Glossary-2

described, 1-13

interaction with PGMS, 1-14

LMDn, 1-13

LMON, 1-13

modification synchronization, 1-14

IFILE parameter, 5-2, 7-3

IMP80, 8-10

import data, 8-10

Import utility, 8-10

infowin@us.oracle.com, xiv

INIT_COM.ORA, 5-6, 8-13

BACKGROUND_DUMP_DEST, B-11, B-12

CACHE_SIZE_THRESHOLD, 7-8

CHECKPOINT_PROCESS, 7-6

DB_NAME, 1-10, 5-9, 7-8

DELAYED_LOGGING_BLOCK_

CLEANOUTS, 7-6

DISTRIBUTED_TRANSACTIONS, 6-20

DML_LOCKS, 7-6, 7-8

GC_FILES_TO_LOCKS, 1-15, 7-6, 7-8

GC_LCK_PROCS, 7-6, 7-8

GC_RELEASABLE_LOCKS, 1-16, 7-6

GC_ROLLBACK_LOCKS, 7-6, 7-8

Global Constant Parameters, 7-5

identical parameters, 7-8

INSTANCE_NUMBER, 7-6

LM_LOCKS, 7-8, 7-9, B-11

LM_PROCS, 7-8, 7-9

LM_RESS, 7-8, 7-9, B-11

LOG_ARCHIVE_FORMAT, 7-6

LOG_FILES, 7-8

MAX_COMMIT_PROPAGATION_DELAY, 7-6, 7-8

NLS_* parameter, 7-7

OPEN_LINKS, 6-20

PARALLEL_DEFAULT_MAX_INSTANCES, 7-8

PARALLEL_DEFAULT_MAX_SCANS, 7-8

PARALLEL_SERVER, 5-23

PARALLEL_SERVER parameter, 7-7

parameter notes, 7-6

PROCESSES, 7-7

RECOVERY_PARALLELISM, 7-7

ROLLBACK_SEGMENTS, 7-7, 7-8

initialization files, 7-1 to 7-13

definition, 7-2

editing, 7-9

for instances, 7-2

identical parameters, 7-8

INITCOM.ORA, 7-2

INITSID.ORA, 7-2

location, 7-8, 7-9

initialization parameters

descriptions, 7-9

editing, 7-9

Global Constant Parameters, 7-5

identical, 7-8

setting, 7-5

INITSID,ORA

INSTANCE_NUMBER, 5-9

INITSID.ORA, 5-6, 7-2

IFILE, 5-2, 7-3

INSTANCE_NUMBER, 7-3

ROLLBACK_SEGMENTS, 7-3

THREAD, 7-3

Input/Output

defined, 1-5, Glossary-2, Glossary-3

described, 1-8

install

Oracle Diagnostic Pack, 6-8

Oracle Enterprise Manager, 6-7

Oracle Parallel Server Manager Server, 4-3

Oracle Parallel Server Option, 4-3, 8-4

Oracle8 Enterprise Edition, 4-3, 8-4

OSD, 4-4, 8-4

repository database, 6-7

installation, 4-1 to 4-4

installation requirements, 2-1

disk space, 2-4

hardware, 2-2

shared disk partitions, 2-4

software, 2-3

INSTANCE_NUMBER parameter, 5-9, 7-3, 7-6

instances

administering, 7-1 to 7-13

defined, 1-10, Glossary-2

identical parameters, 7-8

issues, 7-5

setting initialization parameters, 7-5

shutdown, 7-13

starting and stopping, 7-10

starting with OPSCTL, 7-11

stopping with OPSCTL, 7-13

verifying, 5-24

Integrated Distributed Lock Manager

defined, 1-13

described, 1-13

See IDLM

Integrated Distributed Lock Manager, defined, Glossary-3

Inter-Process Communication

defined, 1-5

described, 1-8

Interprocess Communication, defined, Glossary-3

IO, defined, 1-5, Glossary-2

IPC, defined, 1-5, Glossary-3

listener

OracleHOME_NAMETNSListener80 service, 5-19

OracleHOME_NAMETNSListener80LSNR service, 5-19

starting, 5-19

starting from Control Panel, 5-19

LISTENER_NODE_HOSTNAME.ORA file, 5-17

LISTENER.ORA file, 5-16, 6-4

LISTENER.ORA, defined, Glossary-3

LM_LOCKS parameter, 7-8, 7-9, B-11

LM_PROCS parameter, 7-8, 7-9

LM_RESS parameter, 7-8, 7-9, B-11

LMD0 process, 1-11

LMDn process, 1-13

LMON process, 1-11, 1-13

LMON process, defined, Glossary-3

LMON, defined, Glossary-3

LOG_ARCHIVE_FORMAT parameter, 7-6

LOG_FILES parameter, 7-8

logfile, 8-7

logical partitions

assigning symbolic links, 5-3, 8-12

creating, 3-10

defined, Glossary-3

unassigning drive letters, 3-14

MAX_COMMIT_PROPAGATION_DELAY parameter, 7-6, 7-8

MSHELP directory, A-2

multiple Oracle homes, 4-2

defined, xix

OraclePGMSService, 4-2

NLSRTL33 directory, A-2

node, defined, 1-10, Glossary-3

NT Backup Manager, 9-1 to 9-3

NT Recovery Manager, 9-1 to 9-3

NT user account, creating, 6-11

ntdoc@us.oracle.com, xi

OPEN_LINKS parameter, 6-20

Operating System Dependent layer

components, 1-5

defined, 1-3, Glossary-5

described, 1-5

See OSD

OPQ

defined, 1-13, Glossary-4, Glossary-5

described, 1-18

issuing SQL statements, 1-20

OPS directory, A-2

OPS_8MON.SQL script, 6-20

OPS_MON.SQL script, 6-4

OPSALL.SQL script, 5-20

OPSCONF utility, 5-16

defined, Glossary-4, Glossary-5

using, 5-17

OPSCTL requirements, 7-11

OPSCTL START usage, 7-12

OPSCTL STOP usage, 7-13

OPSCTL utility, 6-3, Glossary-4

architecture, 6-3

defined, Glossary-4, Glossary-5

managing instances, 7-11

OPSM, 4-3

configuration, 6-1 to 6-22

defined, 1-3, Glossary-4

node requirements, 6-4

OPSCTL requirements, 7-11

OPSCTL utility, 6-3

Oracle Enterprise Manager, 1-3

Oracle Enterprise Manager Console requirements, 6-5

requirements, 6-4

starting and stopping instances, 7-10

using, 7-10

OPSREG80 ADD, 5-20, 5-22, 6-9, 8-14, B-10

OPSREG80 DEL, B-10

OPS.SQL script, 5-6, 8-13

ORA XXXXX.TRC file, B-12

ORA-29702, B-10

ORA-600, B-16

ORA-600 (9030), B-15

Oracle Data Manager, 8-10

Oracle Diagnostic Pack, 6-8

Oracle Diagnostics Pack, 6-5

Oracle Diagnostics Pack, installation, 6-8

Oracle Enterprise Manager

configuration files, creating, 6-15

configuration steps, 6-8 to 6-19

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-3

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-2

Oracle Net8 Easy Config, defined, Glossary-4

Oracle Parallel Query

defined, 1-13, Glossary-4

described, 1-18

issuing SQL statements, 1-20

See OPQ

Oracle Parallel Server

database files, 1-12

defined, Glossary-4

overview, 1-1 to 1-20

Oracle Parallel Server database

creating, 5-20, 8-6

starting, 5-22, 8-11

Oracle Parallel Server Manager, 4-3

configuration, 6-1 to 6-22

defined, 1-3, Glossary-4

OPSCTL requirements, 7-11

See OPSM

starting and stopping instances, 7-10

using, 7-10

Oracle Parallel Server Manager Server

defined, 4-3

Oracle Parallel Server Option

defined, 1-3, 4-3

installing, 4-3

Oracle Parallel Server Option, installing, 8-4

Oracle Performance Manager, 7-10

configuration steps, 6-20 to 6-22

Oracle service, defined, Glossary-5

Oracle Technical Publications, contact information, xi

Oracle Worldwide Customer Support

contact information, xii

ORACLE_HOME, explained, xix

ORACLE_SID parameter, add to registry, 5-13, 9-2

Oracle8 database, defined, Glossary-5

Oracle8 Enterprise Edition, defined, 1-3

Oracle8 Enterprise Edition, installing, 4-3, 8-4

Oracle8 ORDBMS, defined, Glossary-5

OracleHOME_NAMETNSListener80 service, 5-17, 5-19

OracleHOME_NAMETNSListener80LSNR service, 5-19

OracleHOME_NAMETNSListenerLSNR service, 5-17

OraclePGMSService service, 1-4, 4-3

OraclePGMSService, de-installing, B-14

OraclePGMSService, multiple Oracle homes, 4-2

OracleServiceSID, creating, 5-10

ORAINST directory, A-2

ORALINK*.TBL file, 8-3

ORALINK1.TBL file, 5-3, 5-4

ORALINK2.TBL file, 5-3, 8-12

ORALINK3.TBL file, 5-3, 8-12

OSD

Cluster Manager (CM), 1-7

components, 1-5

configure, 5-9

defined, 1-3, Glossary-5

described, 1-5

Input/Output, 1-8

Inter-Process Communication (Node-to-Node), 1-8

multiple Oracle homes, 4-2

Performance and Management, 1-9

Startup, 1-9

OSD files, installing, 4-4, 8-4

OTRACE80 directory, A-2

P&M, defined, 1-5, Glossary-5

PARALLEL, 5-23

Parallel Cache Management

defined, 1-13, Glossary-6

described, 1-15

See PCM

parallel coordinator, defined, 1-18, Glossary-6

PARALLEL option, 5-22, 8-9

parallel server process, defined, 1-18, Glossary-6

PARALLEL_DEFAULT_MAX_INSTANCES parameter, 7-8

PARALLEL_DEFAULT_MAX_SCANS parameter, 7-8

PARALLEL_SERVER parameter, 5-23, 7-7

partition

extended, 3-2

logical partition, 3-5

physical disk, 3-4

raw, 3-2

PCM

defined, 1-13, Glossary-6

described, 1-15

fine-grain locks, 1-16

fine-grain locks usage, 1-17

hashed locking usage, 1-17

hashed locks, 1-16

Performance and Management

defined, 1-5, Glossary-6

described, 1-9

OPSM, 1-9

Performance and Management (P&M)

defined, 1-3, Glossary-6

PGMS.LOG file, B-5, B-10

physical disk, defined, Glossary-6

PhysicalDrive, 3-4, B-15

PLSQL80 directory, A-3

PLUS80 directory, A-3

PMON process, 1-11

pre-installation tasks, 3-1 to 3-15

primary node, defined, 1-11

primary partition, defined, Glossary-6

PROCESSES parameter, 7-7

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-7

registry

registry, adding ORACLE_SID entry, 5-13, 9-2

repository database, defined, 6-2

repository user account, 6-10

resources, 1-13

ROLLBACK_SEGMENTS parameter, 7-3, 7-7, 7-8

ROW_LOCKING parameter, 7-8

secondary, B-6

SERIALIZABLE parameter, 7-8

services, create, 5-10

SETLINKS utility, 5-3, 8-12

create symbolic links, 5-3, 8-12

SGA, defined, 1-10, Glossary-2

shared disk storage subsystem, 2-4

shared disks, 1-12

Shared Global Area, defined, 1-10, Glossary-2

SHUTDOWN ABORT, B-15

SID, defined, 1-11, Glossary-6

SIDALRT.LOG file, B-12

SIDLCKN.TRC file, B-12

SIDLMDN.TRC file, B-12

SIDLMON.TRC file, 5-22, 5-23

SIDLMON.TRC file, B-10, B-12, B-13

SIDP00N.TRC file, B-12

SMON process, 1-11

SNMP_RO.ORA file, 6-9

SNMP_RW.ORA file, 6-9

software requirements, 2-3

square brackets, defined, xviii

START, defined, 1-5, Glossary-7

starting Oracle Parallel Server database, 5-22, 8-11

Startup

defined, 1-5, Glossary-7

symbolic link

SYSMAN directory, A-3

system ID, defined, Glossary-7

system requirements, 2-1 to 2-4

tablespace, defined, Glossary-7

THREAD parameter, 7-3, 7-7

TNSNAMES.ORA file, 5-16, 5-17, 6-4

TNSNAMES.ORA, defined, Glossary-7

TOPOLOGY.OPS file, 5-17

trace files, B-11

background thread trace files, B-11

CM.LOG, B-15

error call trace stack, B-13

ORA XXXXX.TRC, B-12

PGMS.LOG, B-14

SIDALRT.LOG, B-12

SIDLCKN.TRC, B-12

SIDLMDN.TRC, B-12

SIDLMON.TRC file, B-12

SIDP00N.TRC, B-12

troubleshooting, B-1 to B-16

unassign drive letters, 3-14

User Manager, for Oracle Enterprise Manager, 6-11

user preferences, 6-5

USER_DUMP_DEST parameter, B-12

V$ACTIVE_INSTANCES, 5-24

V$PQ_SYSSTAT, 1-20

VS10 directory, A-3

vsa@us.oracle.com, xiii

Windows NT user account, creating, 6-11

Index

Symbols

A

B

C

D

E

F

G

H

I

J

L

M

N

O

P

R

S

T

U

V

W