Oracle Parallel Server -- Index

Cluster Manager

defined, 1-5, G-1

described, 1-7

PGMS, 1-4

cluster, defined, 1-10, G-1

CM, defined, 1-5, G-1

configuration, 5-1-5-27

configuration file

LISTENER.ORA, 5-15, 6-4

LISTENER_NODE_HOSTNAME.ORA, 5-17

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

TOPOLOGY.OPS, 5-17

configuration files

testing, 5-20

using OPSCONF, 5-17

using Oracle Net8 Easy Config, 5-19

configure

domains, 5-8

Oracle Enterprise Manager, 6-8-6-19

Oracle Parallel Server, 5-1-5-27

Oracle Performance Manager, 6-20-6-24, 8-15

OSD, 5-8

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

third or fourth node, 8-10-8-15

control file, 1-11

CONTROL_FILES parameter, 7-9

CPU_COUNT parameter, 7-9

CRTSRV batch file, 5-9

data files, 1-11, 1-12

database creation, 5-21, 8-5

DATABASE directory, A-2

DB_BLOCK_SIZE parameter, 7-9

DB_FILES parameter, 7-9

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

DELAYED_LOGGING_BLOCK_
CLEANOUTS parameter, 7-7

directory

BIN, A-2

DBS, A-2

JRE11, A-2

MSHELP, A-2

NET80, A-2

OPS, A-2

PLUS80, A-3

SYSMAN, A-3

directory structure, A-1-A-3

disk definition, 3-4

disks, shared access, 1-12

Distributed Lock Manager, described, 1-11

DISTRIBUTED_TRANSACTIONS parameter, 6-22

DLL, defined, G-1

DLM, described, 1-11

DML_LOCKS parameter, 7-7, 7-9

domain, defined, 1-10, G-1

domain, group, 1-4

EERN804 directory, A-2

EXP80, 8-5

export data from old database, 8-4

Export utility, 8-5

extended partition

create logical drives, 3-7

creating, 3-5

defined, 3-2, G-2

fine-grain locks, 1-16

1 block to 1 block ratio, 1-16

fixed, 1-16

GC_FILES_TO_LOCKS parameter, 1-15, 7-7, 7-9

GC_LCK_PROCS parameter, 7-7, 7-9

GC_RELEASABLE_LOCKS parameter, 1-16, 7-7

GC_ROLLBACK_LOCKS parameter, 7-7, 7-9

Global Constant Parameters list, 7-7

Group Membership Service

defined, 1-3, G-2

described, 1-4

See PGMS

group, domain, 1-4

hardware requirements, 2-2

hashed locks, 1-16

fixed, 1-16

releasable, 1-16

when to use, 1-17

hashed locks, defined, G-2

HOME_NAME, defined, xiii

HOMEID, defined, xiii

IDLM

block access synchronization, 1-14

deadlock detection, 1-14

defined, 1-13, G-2

described, 1-14

interaction with PGMS, 1-15

LMDn, 1-14

LMON, 1-14

modification synchronization, 1-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

CACHE_SIZE_THRESHOLD, 7-9

CHECKPOINT_PROCESS, 7-7

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

DELAYED_LOGGING_BLOCK_
CLEANOUTS, 7-7

DISTRIBUTED_TRANSACTIONS, 6-22

DML_LOCKS, 7-7, 7-9

GC_FILES_TO_LOCKS, 1-15, 7-7, 7-9

GC_LCK_PROCS, 7-7, 7-9

GC_RELEASABLE_LOCKS, 1-16, 7-7

GC_ROLLBACK_LOCKS, 7-7, 7-9

Global Constant Parameters, 7-6

identical parameters, 7-9

LOG_ARCHIVE_FORMAT, 7-7

LOG_FILES, 7-9

MAX_COMMIT_PROPAGATION_DELAY, 7-8, 7-9

NLS_* parameter, 7-8

OPEN_LINKS, 6-22

PARALLEL_DEFAULT_MAX_INSTANCES, 7-9

PARALLEL_DEFAULT_MAX_SCANS, 7-9

PARALLEL_SERVER, 5-24

PARALLEL_SERVER parameter, 7-8

parameter notes, 7-7

PROCESSES, 7-8

RECOVERY_PARALLELISM, 7-8

ROLLBACK_SEGMENTS, 7-8, 7-9

initialization files, 7-1-7-13

definition, 7-2

editing, 7-10

for instances, 7-2

identical parameters, 7-9

INITCOM.ORA, 7-3

INITSID.ORA, 7-2

location, 7-9

initialization parameters

descriptions, 7-9

editing, 7-10

Global Constant Parameters, 7-6

identical, 7-9

setting, 7-6

INITSID,ORA

INSTANCE_NUMBER, 5-8

INITSID.ORA, 5-5, 7-2, 8-12

IFILE, 5-2, 7-3

INSTANCE_NUMBER, 7-4

ROLLBACK_SEGMENTS, 7-4

THREAD, 7-4

Input/Output

defined, 1-5

described, 1-8

Input/Output, defined, G-2, G-3

install

Oracle Enterprise Manager, 6-7

Oracle Enterprise Manager Performance Pack, 6-7

Oracle Parallel Server Manager Server, 4-3

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

Oracle8 Enterprise Edition, 4-3, 8-3

OSD, 4-4, 8-3

repository database, 6-7

installation, 4-1-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-8, 7-4, 7-7

instances

administering, 7-1-7-13

defined, 1-10, G-2

identical parameters, 7-9

issues, 7-6

setting initialization parameters, 7-6

shutdown, 7-13

starting and stopping, 7-10

starting with OPSCTL, 7-11

stopping with OPSCTL, 7-13

verifying, 5-26

Integrated Distributed Lock Manager

defined, 1-13

described, 1-14

See IDLM

Integrated Distributed Lock Manager, defined, G-3

Inter-Process Communication

defined, 1-5

described, 1-8

IO, defined, 1-5, G-2

IPC, defined, 1-5, G-3

listener

OracleHOME_NAMETNSListener80 service, 5-20

OracleHOME_NAMETNSListener80LSNR service, 5-20

starting, 5-20

starting from Control Panel, 5-20

LISTENER.ORA file, 5-15, 5-19, 6-4

LISTENER.ORA, defined, G-3

LISTENER_NODE_HOSTNAME.ORA file, 5-17

LM_LOCKS parameter, 7-9

LM_PROCS parameter, 7-9

LM_RESS parameter, 7-9

LMD0 process, 1-11

LMDn process, 1-14

LMON process, 1-11, 1-14

LMON process, defined, G-3

LMON, defined, G-3

LOG_ARCHIVE_FORMAT parameter, 7-7

LOG_FILES parameter, 7-9

logical drives

assigning symbolic links, 5-2, 8-11

creating, 3-7

defined, G-3

unassigning drive letters, 3-11

MAX_COMMIT_PROPAGATION_DELAY parameter, 7-8, 7-9

MSHELP directory, A-2

multiple Oracle homes, 4-2

OraclePGMSService, 4-2

NLSRTL33 directory, A-2

node, defined, 1-10, G-3

NT Backup Manager, 9-1-9-3

NT Recovery Manager, 9-1-9-3

NT user account, creating, 6-11

OPEN_LINKS parameter, 6-22

Operating System Dependent layer

components, 1-5

defined, 1-3, G-5

described, 1-5

See OSD

OPQ

defined, 1-13, G-4, G-5

described, 1-18

issuing SQL statements, 1-20

OPS directory, A-2

OPS.SQL script, 5-5, 8-12

OPS_cntr01, 5-4

OPS_CTAB.SQL script, 6-20

OPS_DBL.SQL script, 5-17, 6-4, 6-20, 8-15

creating from OPSCONF, 6-21

creating manually, 6-21

OPS_log1t1, 5-3

OPS_log1t2, 5-3

OPS_log2t1, 5-3, 5-4

OPS_MON.SQL script, 6-4, 6-20, 8-15

OPS_PACK.SQL script, 6-20

OPSALL.SQL script, 5-22

OPSCONF utility, 5-15, 6-20

defined, G-4, G-5

OPS_DBL.SQL script, 6-21

Oracle Performance Manager, 5-15

using, 5-17

OPSCTL requirements, 7-11

OPSCTL START usage, 7-12

OPSCTL STOP usage, 7-13

OPSCTL utility, 6-3, G-4

architecture, 6-3

defined, G-4, G-5

managing instances, 7-11

OPSM, 4-3

configuration, 6-1-6-24

defined, 1-3, G-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-21, 5-23, 6-9, 8-13, B-2

OPSREG80 DEL, B-2

ORA-600 (9030), B-2

Oracle Data Manager, 8-9

Oracle Enterprise Manager

configuration files, creating, 6-15

configuration steps, 6-8-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, G-4, G-5

install, 6-7

install Oracle Enterprise Manager Performance Pack, 6-7

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 Enterprise Manager Performance Pack, 6-5, 6-7

Oracle Enterprise Manager Performance Pack, installation, 6-7

Oracle home, defined, xiii

Oracle Intelligent Agent, defined, 6-2

Oracle Net8 Easy Config, 5-15, 5-19

Oracle Net8 Easy Config, defined, G-4

Oracle Parallel Query

defined, 1-13, G-4

described, 1-18

issuing SQL statements, 1-20

See OPQ

Oracle Parallel Server

database files, 1-12

defined, G-4

overview, 1-1-1-20

Oracle Parallel Server database

creating, 5-21, 8-5

starting, 5-23, 8-10

Oracle Parallel Server Manager, 4-3

configuration, 6-1-6-24

defined, 1-3, G-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-3

Oracle Performance Manager, 7-10

configuration steps, 6-20-6-24, 8-15

OPS_DBL.SQL, 5-17, 6-4, 6-20, 8-15

OPS_MON.SQL, 6-4, 6-20, 8-15

OPS_PACK.SQL, 6-20

starting, 6-23

Oracle service, defined, G-5

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

Oracle8 database, defined, G-5

Oracle8 Enterprise Edition, defined, 1-3

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

Oracle8 ORDBMS, defined, G-5

OracleHOME_NAMETNSListener80 service, 5-16, 5-20

OracleHOME_NAMETNSListener80LSNR service, 5-20

OracleHOME_NAMETNSListenerLSNR service, 5-16

OraclePGMSService service, 1-4, 4-3

OraclePGMSService, multiple Oracle homes, 4-2

OracleServiceSID, creating, 5-9

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

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

OTRACE80 directory, A-3

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

PARALLEL, 5-24

Parallel Cache Management

defined, 1-13, G-6

described, 1-15

See PCM

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

PARALLEL option, 5-23, 8-8

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

PARALLEL_DEFAULT_MAX_INSTANCES parameter, 7-9

PARALLEL_DEFAULT_MAX_SCANS parameter, 7-9

PARALLEL_SERVER parameter, 5-24, 7-8

partition

PCM

fine-grain locks, 1-16

fine-grain locks usage, 1-17

hashed locking usage, 1-17

hashed locks, 1-16

Performance and Management

PGMS

physical partition, defined, G-6

PhysicalDrive, 3-4, B-2

PLSQL80 directory, A-3

PLUS80 directory, A-3

PMON process, 1-11

pre-installation tasks, 3-1-3-12

primary node, defined, 1-11

primary partition, defined, G-6

PROCESSES parameter, 7-8

raw partition

raw partition definition, 3-4

RDBMS80 directory, A-3

recovery, 9-1-9-3

RECOVERY_PARALLELISM parameter, 7-8

redo logs, 1-11

REGEDT32, 5-12

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

repository database, defined, 6-2

repository user account, 6-10

resources, 1-14

ROLLBACK_SEGMENTS parameter, 7-4, 7-8, 7-9

ROW_LOCKING parameter, 7-9

SERIALIZABLE parameter, 7-9

services, create, 5-9

SETLINKS utility, 5-2, 8-11

create symbolic links, 5-2, 8-11

SGA, defined, 1-10, G-2

shared disk storage subsystem, 2-4

shared disks, 1-12

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

SHUTDOWN ABORT, B-3

SHUTDOWN NORMAL, B-3

SID, defined, 1-10, G-7

SID_DESC keyword, using, 5-19

SIDLCKn.TRC file, B-2

SIDLMDn.TRC file, B-2

SIDLMON.TRC file, 5-23, 5-24, B-2

SIDP00n.TRC file, B-2

SMON process, 1-11

software requirements, 2-3

START, defined, 1-5, G-7

starting Oracle Parallel Server database, 5-23, 8-10

Startup

symbolic link

SYSMAN directory, A-3

system ID, defined, G-7

system requirements, 2-1-2-4

tablespace, defined, G-7

THREAD parameter, 7-4, 7-8

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

TNSNAMES.ORA, defined, G-7

TOPOLOGY.OPS file, 5-17

troubleshooting, B-1-B-3

unassign drive letters, 3-11

User Manager, for Oracle Enterprise Manager, 6-11

user preferences, 6-5

V$ACTIVE_INSTANCES, 5-26

V$DATABASE, 6-22

V$PQ_SYSSTAT, 1-20

VS10 directory, A-3

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