Oracle8
i
Parallel Server Setup and Configuration Guide
Release 2 (8.1.6)
Part Number A76934-01
Library
Product
Contents
Index
A
B
C
D
E
F
G
H
I
J
L
M
N
O
P
R
S
T
U
V
Symbols
\database directory, A-4
\network directory, A-4
\ops directory, A-4
\opsm\admin directory, A-4
A
abort mode, warning notice, 7-10
ACTIVE_INSTANCE_COUNT parameter, 5-6
adding nodes to a cluster, 9-7
administering instances
with initialization parameter files, 4-4
with Oracle Parallel Server Management, 7-2
alert logs, C-10
ALTER DATABASE ADD LOGFILE statement, 9-4
applications
converting to multi-instance, 9-3
architecture
OPSCTL utility on UNIX, 6-4
OPSCTL utility on Windows NT, 6-5
Optimal Flexible Architecture (OFA), 1-8,
1-9
Oracle Enterprise Manager, 6-7
Oracle Parallel Server, 1-2
Oracle Parallel Server Management, 6-2
archive log destinations
conversion to multi-instance, 9-3
multiple
on UNIX, 4-15
on Windows NT, 4-16
shared
on UNIX, 4-10
on Windows NT, 4-12
B
BACKGROUND_DUMP_DEST parameter, 4-7,
C-9,
C-10
BACKUP parameter, 5-3
backups
after creating new databases, 3-39
Backup Wizard, 4-16
before database creation, 3-32
consistent, 4-16
conversion to multi-instance, 9-3
Recovery Manager, 4-9
boldface, defined, xvii
brackets, defined, xvii
C
client load balancing
configuring, 4-2
described, 4-2
with TAF, 5-4
with Transparent Application Failover, 5-4
Cluster Manager (CM)
described, 1-5
DefinedNodes registry value, 3-26
cluster, defined, 1-2
CM
described, 1-5
DefinedNodes registry value, 3-26
components, 4-3
Configuration Assistant, 6-10
configuring
archive logs for backup and recovery, 4-9 to
4-16
clients
client load balancing, 4-2
connect-time failover, 4-2
primary and secondary instances, 5-8
global database name, 3-4
high availability, 5-1 to
5-16
primary and secondary instances, 5-6
TAF, 5-2
Transparent Application Failover, 5-2
listeners
primary and secondary instances, 5-9
Oracle Enterprise Manager, 6-10 to
6-27
Oracle Intelligent Agents on UNIX, B-10 to
B-11
Oracle Parallel Server Management, 6-1 to
6-34
Oracle Performance Manager, 6-27 to
6-34
primary and secondary instances, 5-6
Recovery Manager, 4-9 to
4-16
SID Prefix, 3-4
TAF, 5-2
Transparent Application Failover, 5-2
connecting
Oracle Enterprise Manager repository database, 6-28
Oracle Parallel Server database, 4-3
connection load balancing, 3-13
connect-time failover
configuring, 4-2
described, 4-2
GLOBAL_DBNAME parameter in listener.ora file, 3-15
with TAF, 5-4
with Transparent Application Failover, 5-4
Console
described, 2-3,
6-2
Event Management window, 6-2
Group window, 6-2
Job window, 6-2
Navigator window, 6-2
Navigator window with Oracle Parallel Server objects, 7-3
right-mouse menu, 7-5
Connect, 7-6
Disconnect, 7-6
Edit, 7-6,
7-16
Related Tools, 7-6
Remove, 7-6
Results, 7-6,
7-12
Shutdown, 7-6,
7-9
Startup, 7-6,
7-7
scheduling jobs, 7-19
setup, 6-7
starting, 6-12
starting Oracle Parallel Server database, 7-7
stopping Oracle Parallel Server database, 7-9
viewing Oracle Parallel Server status, 7-16
viewing shutdown results, 7-12
viewing startup results, 7-12
control files
described, 1-14
raw devices, 2-6
CONTROL_FILES parameter, 4-7
CREATE DATABASE OPS script, 3-38
Create Job property sheet, 7-20 to
7-25
General tab, 7-21
Parameters tab, 7-23
Tasks tab, 7-22
creating
db_name
.conf file, B-2
init
db_name
.ora file, 3-36
initialization parameter files, 3-12,
3-36
init
sid
.ora file, 3-12,
3-36
Oracle Enterprise Manager repository, 6-10
Oracle Parallel Server database
backing up the new database, 3-39
CREATE DATABASE OPS script, 3-38
db_name
.conf file, 3-9,
3-33
during installation, 3-7
init
db_name
.ora file, 3-36
init
sid
.ora file, 3-12,
3-36
ORACLE_SID environment variable, 3-35
OracleService
sid
. service, 3-11,
3-35
oratab file, 3-9,
3-32
password files, 3-37
registry entries, 3-10,
3-33
with manual methods, 3-29
with Oracle Database Configuration Assistant, 3-7,
3-24
password files, 3-37
preferred credentials, 6-19
raw devices on UNIX, 2-7
raw devices on Windows NT, 2-9
crtsrv batch file, 3-35
curly brackets, defined, xvii
Custom database creation type, 1-11
Custom installation type, 3-2
D
data files, 1-3
described, 1-12
raw devices, 2-6
Data Warehousing database, 1-10
database creation during installation, 3-7
database, defined, 1-2
DB_DOMAIN parameter, 4-8
DB_NAME parameter, 1-15,
4-4,
4-7
db_name
.conf file
creating, B-2
environ parameter, B-5
inst_init_ora parameter, B-5,
B-7
inst_oracle_sid parameter, B-4,
B-6
inst_sid_list parameter, C-4
instance parameters, B-6
listener configuration, B-8
lsnr_listener_name parameter, B-5,
B-9,
C-4
node#
inst_init_ora parameter, B-5
node#
tns_admin parameter, B-5
node_list parameter, B-4,
C-3
oracle_home parameter, B-5
overview, B-2,
B-10
parameter expansion, B-3
parameter syntax, B-3
parameters, B-4
parameters node overrides, B-6
sample, B-10
service discovery, C-3
tns_admin parameter, B-5,
B-8
DBA Studio
described, 2-3
limitations, 6-34
DBCA_RAW_CONFIG environment variable, 2-9
/dbs directory, A-3
DBSNMP START command, 6-10
DefinedNodes registry value, 3-26
DELAY parameter, 5-3
directory structure, A-1 to
A-4
UNIX, A-3
Windows NT, A-4
discovering nodes, 6-15
discovery
See
service discovery
Discovery Wizard, 6-15
DRSYS tablespace
raw device, 2-6
DRSYS tablespace, description, 1-12
E
Edit Parallel Server dialog box, 7-16
Edit User Preferences dialog box, 6-25
ellipsis, defined, xvii
errors
call trace stack, C-11
ORA-600, C-12
ORA-9291, 4-16
Oracle Enterprise Manager discovery, C-2
exp utility, 9-5
export data from old database, 9-5
Export utility, 9-5
F
FAILOVER parameter, 4-2
FAILOVER_MODE parameter, 5-3
FORCE mode, warning notice, 7-8
G
General tab, from Create Job property sheet, 7-21
global database name, 1-2,
3-4,
3-27
global V$ view tables, 6-1,
8-2
GLOBAL_DBNAME parameter, 3-15
GUI, 6-12
GV$FILESTAT view, 8-9,
8-10,
8-11
GV$LICENSE view, 8-14,
8-15,
8-16,
8-17
GV$LOCK_ACTIVITY view, 8-12
GV$PING view, 8-5,
8-6,
8-8
GV$PROCESS view, 8-13
GV$SESSION view, 8-13
H
hardware requirements, 2-2
high availability
configuring, 5-1 to
5-16
primary and secondary instances, 5-6
TAF, 5-2
Transparent Application Failover, 5-2
host.equiv file, 2-11
I
IFILE parameter, 4-5
imp utility, 9-6
import data, 9-6
Import utility, 9-6
INDX tablespace
described, 1-12
raw device, 2-6
init
db_name
.ora file
ACTIVE_INSTANCE_COUNT parameter, 5-6
BACKGROUND_DUMP_DEST parameter, 4-7,
C-9,
C-10
CONTROL_FILES parameter, 4-7
creating, 3-36
DB_DOMAIN parameter, 4-8
DB_NAME parameter, 1-15,
4-4,
4-7
described, 1-14,
4-6
LOCAL_LISTENER parameter, 3-6
MTS_DISPATCHER parameter, 4-8
SERVICE_NAMES parameter, 4-9
USER_DUMP_DEST parameter, 4-9,
C-10
initialization parameter files
creating for database creation, 3-12,
3-36
definition, 4-4
editing before database creation, 3-36
for instances, 4-4 to
4-9
init
db_name
.ora, 4-6
init
sid
.ora, 4-4
init
sid
.ora file
creating, 3-12,
3-36
described, 1-14,
4-4
IFILE parameter, 4-5
INSTANCE_NAME parameter, 1-15,
1-16,
4-5
LOG_ARCHIVE_DEST parameter, 4-11
REMOTE_LOGIN_PASSWORDFILE parameter, 4-5
ROLLBACK_SEGMENTS parameter, 1-16,
4-5
THREAD parameter, 1-16,
4-5
inst_init_ora parameter, B-5,
B-7
inst_oracle_sid parameter, B-4,
B-6
inst_sid_list parameter, C-4
installation
directory structure, A-1 to
A-4
ldap.ora file, 3-16
listener.ora file, 3-14
Net8 Configuration Assistant, 3-6
Oracle Database Configuration Assistant, 3-7
Oracle Parallel Server database creation, 3-7
pre-installation, 2-1 to
2-12
repository database, 6-9
software requirements, 2-2
tnsnames.ora file, 3-16
verifying raw devices, 3-5,
3-7,
3-23
installation requirements, 2-2 to
2-5
disk space, 2-5
hardware, 2-2
hardware requirements, 2-2
Oracle Enterprise Manager, 2-3
shared disk partitions, 2-5
software, 2-2
installation type
Custom, 3-2
Minimal, 3-2
Typical, 3-2
installing
Operating System Dependent layer, 2-11,
9-5
Oracle Enterprise Manager, 6-9
Oracle Parallel Server, 3-3
with Custom installation type, 3-5
with Typical installation type, 3-5
Oracle8
i
Enterprise Edition, 3-3
with Oracle Universal Installer, 3-3
instance name, 1-15,
1-16
INSTANCE_NAME parameter, 1-15,
1-16,
3-18,
4-5
instances
adding to cluster, 9-7
control files, 1-3
data files, 1-3
db_name
.conf file, B-6
described, 1-2
Destination Type tasks for, 7-23
initialization parameter files, 4-4 to
4-9
init
sid
.ora file, 1-14
instance name, 1-15,
1-16
INSTANCE_NAME parameter, 1-15,
1-16
Oracle Parallel Server Management, 7-2
Oracle System Identifier (SID), 1-15
ORACLE_SID environment variable, 1-15
ORACLE_SID registry entry, 1-15
rollback segments, 1-16
ROLLBACK_SEGMENTS parameter, 1-16
SID, 1-15,
4-4
SID Prefix, 3-4,
3-27
startup and shutdown results, 7-12,
7-17
thread ID, 1-16
THREAD parameter, 1-16
verifying, 3-42
Inter-Process Communication (IPC)
described, 1-5
Introduction, 1-1
italic, defined, xvii
J
jobs
choosing tasks for, 7-22
creating for Oracle Parallel Server, 7-19
setting up rights for running, 7-24
specifying information for, 7-21
specifying parameters for OPSM tasks, 7-23
L
ldap.ora file, 3-16
creating, 3-16
default configuration, 3-16
LISTENER (LIS or LIST) attribute, 4-8
listener.ora file, 3-14,
3-40
default configuration, 3-14
Oracle Enterprise Manager service discovery, C-4
Oracle Parallel Server Management requirements, 6-6
SID_DESC parameter, C-4
SID_LIST_
listener_name
parameter, 3-40,
6-6,
C-4
listeners
GLOBAL_DBNAME parameter, 3-15
listener.ora file, 3-14
lsnr_listener_name parameter in
db_name
.conf file, B-9
tns_admin parameter in
db_name
.conf file, B-8
LOAD_BALANCE parameter, 4-2
LOCAL_LISTENER parameter, 3-6,
4-8
Lock Manager, 3-24,
3-44
LOG_ARCHIVE_DEST parameter, 4-11
lowercase courier, defined, xvii
lsnodes -l -n command, 3-30
lsnr_listener_name parameter, B-5,
B-9,
C-4
LSNRCTL utility
DBSNMP STARTommand, 6-10,
B-11
START command, 3-41
M
managed targets, described, 2-3
Management Server
described, 2-3,
6-3
OMSCONFIG.PROPERTIES file, 6-11
starting, 6-11
METHOD parameter, 5-3
migrating
Oracle Parallel Server issues, 3-21
single instance to Oracle Parallel Server, 9-2 to
9-7
Minimal installation type, 3-2
MTS_DISPATCHERS parameter, 4-8
LISTENER attribute, 4-8
PROTOCOL attribute, 4-8
multi-instance database
converting application, 9-3
reasons not to convert to, 9-2
reasons to convert to, 9-2
requirements, 9-3
multiple Oracle homes
UNIX, 3-22
Windows NT, 3-22
Multi-Purpose database, 1-10
multi-threaded server
configuring, 3-13
connection load balancing, 3-13
dispatchers, 3-13
MTS_DISPATCHERS parameter, 4-8
N
Navigator window
Oracle Parallel Server folder, 7-3
Oracle Parallel Server objects, 7-3
Parallel Server Instances folder, 7-5
right-mouse menu, 7-5,
7-12
Connect, 7-6
Disconnect, 7-6
Edit, 7-6,
7-16
Related Tools, 7-6
Remove, 7-6
Results, 7-6
Shutdown, 7-6,
7-9
Startup, 7-6,
7-7
starting Oracle Parallel Server database, 7-7
stopping Oracle Parallel Server database, 7-9
viewing Oracle Parallel Server status, 7-16
viewing shutdown results, 7-12
viewing startup results, 7-12
Net8 Configuration Assistant
Custom installation, 3-6
Typical installation, 3-5
using during installation, 3-6
network configuration files
ldap.ora.ora, 3-16
listener.ora, 3-14,
3-40,
6-6
Oracle Enterprise Manager service discovery, C-4
sqlnet.ora, 3-21,
3-40
testing, 4-3
tnsnames.ora, 3-16,
3-40
Oracle Enterprise Manager service discovery, C-5
/network directory, A-3
nmiconf.log file, C-7
nmiconf.lst file, C-7
node#
:environ parameter, B-5
node#
:inst_init_ora parameter
, B-5
node#
:tns_admin parameter, B-5
node_list parameter, B-4,
C-3
nodes
adding to cluster, 9-7
described, 1-2
non-shared locations, B-10
O
oemapp console command, 6-12
oemapp pm command, 6-28
oemctrl start oms command, 6-11
OLTP database, 1-10
OMSCONFIG.PROPERTIES file, 6-11
Online Transaction Processing database, 1-10
Operating System Dependent layer
described, 1-5
installing, 2-11,
9-5
OPS Communication Daemon, defined, 6-4
/ops directory, A-3
OPS Overview chart, 8-18
OPS_DATABASE entry, C-6
OPS_DATABASE entry in services.ora file, C-6
OPS_INSTANCE entry, C-7
OPS_INSTANCE entry in services.ora file, C-7
OPSCTL utility, 6-4
architecture on UNIX, 6-4
architecture on Windows NT, 6-5
configuring on UNIX, B-1 to
B-11
db_name
.conf file, B-2
OPSD, defined, 6-4
/opsm/admin directory, A-3
ops.sql script, 3-38
Optimal Flexible Architecture (OFA), 1-8,
1-9
ORA-600, C-12
ORA-9291 message, 4-16
Oracle Data Gatherer
described, 6-3
starting, 6-27
Oracle Database Configuration Assistant
control files, 1-14
creating Oracle Parallel Server database
after installation, 3-24
during installation, 3-7
Custom database creation type, 1-11
data files, 1-12
database types
Data Warehousing, 1-10
Multi-Purpose, 1-10
OLTP, 1-10
deleting Oracle Parallel Server database, 3-43
error message, 3-26
initialization parameter files, 1-14
multi-threaded server configuration, 3-13
redo log files, 1-13
rollback segments, 1-14
running
during installation, 3-7
stand-alone mode, 3-23
tablespaces, 1-12
troubleshooting, 3-24,
3-44
Typical database creation type, 1-11
Oracle Diagnostics Pack
described, 2-4
Oracle Performance Manager, 2-4
Oracle Enterprise Manager
architecture, 6-7
Backup Wizard, 4-9,
4-16
components of, 2-3
Configuration Assistant, 6-10
configuring, 6-10 to
6-27
repository, 6-10
Console, 2-3,
6-2,
6-12
db_name
.conf file requirements, 3-9,
3-33
DBA Studio, 2-3
described, 6-2
discovering nodes, 6-15
Discovery Wizard, 6-15
hardware requirements, 2-3
installation requirements, 2-3
installing repository database, 6-9
managed targets, 2-3
Management Server, 2-3,
6-3,
6-11
nmiconf.log file, C-7
nmiconf.lst file, C-7
OPS Communication Daemon, 6-4
OPSCTL utility, 6-4
OPSD, 6-4
Oracle Data Gatherer, 6-3
Oracle Diagnostics Pack, 2-4
Oracle Intelligent Agents, 6-3
Oracle Parallel Server Management, 1-5
Oracle Performance Manager, 6-3
oratab file requirements, 3-32
preferred credentials, 6-19
Recovery Wizard, 4-9
registry requirements, 3-10,
3-33
repository database, 6-3
configuring, 6-10
described, 2-3
scheduling jobs, 7-19
service discovery, 6-15,
C-2
services.ora file, C-6
setup scenarios, 6-7
SID_LIST_
listener_name
parameter in listener.ora file, 3-40,
6-6,
C-4
software requirements, 2-3
solving service discovery failures, C-2
specifying preferred credentials, 6-19
starting
components, 6-10
Console, 6-12
Management Server, 6-11
Oracle Data Gatherer, 6-27
Oracle Intelligent Agents, 6-10
Oracle Parallel Server database, 7-7
Oracle Performance Manager, 8-4
stopping Oracle Parallel Server database, 7-9
super administrator account, 6-12
SYSDBA privilege, 6-26
SYSOPER privilege, 6-26
TOOLS tablespace, 2-6
understanding discovery failures, C-2
User Manager, 6-20
version 2 changes, 6-10
viewing
Oracle Parallel Server status, 7-16
shutdown results, 7-12
startup results, 7-12
Oracle home
defined, xvii
non-shared on UNIX, B-11
shared on UNIX, B-11
Oracle Intelligent Agents
described, 6-3
setup and location on UNIX, B-10 to
B-11
starting, 6-10
Oracle Parallel Server
architecture, 1-2
data files, 1-3
database files, 1-17
Destination Type tasks, 7-23
folder in Console Navigator window, 7-3
hardware requirements, 2-2
initialization parameter files, 1-14
installation requirements, 2-2
installing, 3-3
instances, 1-2
Operating System Dependent layer, 1-5
Oracle Parallel Server Management, 1-5
overview, 1-1 to
1-4
pre-installation, 2-1 to
2-12
raw device setup, 2-5 to
2-10
software components
Oracle Parallel Server, 1-5
Oracle Parallel Server Management, 1-5
Oracle8
i
Enterprise Edition, 1-5
software requirements, 2-2
Oracle Parallel Server databases, 3-38
backing up, 3-39
creating
with manual methods, 3-29
with Oracle Database Configuration Assistant after installation, 3-24
with Oracle Database Configuration Assistant during installation, 3-7
creating a job on, 7-19
deleting, 3-43
disconnecting from, 7-10
displaying objects in Console, 7-3
mounting, 7-8
password files, 3-37
shutdown, 7-12
starting, 3-41
Oracle Parallel Server Management
administration of instances, 7-2
architecture, 6-2
configuring, 6-1 to
6-34
described, 1-5
node requirements, 6-6
OPS Communication Daemon, 6-4
OPSCTL utility, 6-4
OPSD process, 6-4
Oracle Enterprise Manager, 1-5,
6-2
requirements, 6-6
SIDs, 6-6
Oracle Performance Manager, 8-18
accessing Oracle Parallel Server charts, 6-30
charts, 8-1 to
8-18
OPS Overview, 8-18
Parallel Server Active Users, 8-16
Parallel Server Active Users by Instance, 8-17
Parallel Server Block Ping, 8-5
Parallel Server Block Ping Tablespace Instance, 8-6
Parallel Server Block Ping Tablespace Object, 8-6
Parallel Server Data Block Ping, 8-6
Parallel Server Data Block Ping by Instance, 8-8
Parallel Server File I/O Rate, 8-9
Parallel Server File I/O Rate by Instance, 8-11
Parallel Server File I/O Rate by Object, 8-10
Parallel Server Lock Activity, 8-12
Parallel Server Sessions, 8-13
Parallel Server Users Logged On, 8-14
Parallel Server Users Logged On by Instance, 8-15
configuring, 6-27 to
6-34
Databases folder, 6-32
described, 2-4,
6-3
displaying charts, 8-4
Oracle Diagnostics Pack, 2-4
overview, 8-2
Parallel Server Instance folder, 6-30
starting, 6-28,
8-4
Oracle System Identifier (SID), defined, 1-15
Oracle Universal Installer, 3-3
ORACLE_HOME environment variable, B-5
oracle_home parameter, B-5
ORACLE_HOME, defined, xvii
ORACLE_PSRV environment variable, B-3,
B-5,
C-7
ORACLE_SID environment variable, 1-15,
3-35
ORACLE_SID registry entry, 1-15
Oracle8
i
Enterprise Edition
described, 1-5
installing, 3-3
Oracle
HOME_NAME
Agent service, 6-10
Oracle
HOME_NAME
DataGatherer service, 6-27
Oracle
HOME_NAME
ManagementServer service, 6-11
OraclePGMSService service, 3-21
OracleService
sid
service, 3-11,
3-35
ORAPWD utility, 3-37
orapw
sid
file, 3-37
ora
xxxxx
.trc file, C-10
Output tab
from Parallel Server Operation Results dialog box, 7-15
P
PARALLEL option, 3-41,
3-42
Parallel Server Active Users by Instance chart, 8-17
Parallel Server Active Users chart, 8-16
Parallel Server Block Ping chart, 8-5
Parallel Server Block Ping Tablespace Instance chart, 8-6
Parallel Server Block Ping Tablespace Object chart, 8-6
Parallel Server Data Block Ping by Instance chart, 8-8
Parallel Server Data Block Ping chart, 8-6
Parallel Server File I/O Rate by Instance chart, 8-11
Parallel Server File I/O Rate by Object chart, 8-10
Parallel Server File I/O Rate chart, 8-9
Parallel Server Instances folder
in Console Navigator window, 7-5
Parallel Server Instances Logon dialog box, 6-31
Parallel Server Lock Activity chart, 8-12
Parallel Server Operation Results dialog box, 7-12
Parallel Server Sessions chart, 8-13
Parallel Server Shutdown dialog box, 7-10
Parallel Server Shutdown Progress dialog box, 7-11
Parallel Server Started message box, 7-9
Parallel Server Startup dialog box, 7-7
Parallel Server Startup Results dialog box, 7-9
Parallel Server Startup/Shutdown Results dialog box, 7-12
Parallel Server Stopped message box, 7-12
Parallel Server Users Logged On by Instance chart, 8-15
Parallel Server Users Logged On chart, 8-14
Parameters tab
from Create Job property sheet, 7-23
password files, 3-37
Performance Manager Login dialog box, 6-28
preferred credentials, 6-19
creating an operating system account, 6-20
database, 6-19
nodes, 6-19
SYSDBA or SYSOPER for database, 6-19
preferred user credentials, described, 6-19
pre-installation, 2-1 to
2-12
DBCA_RAW_CONFIG, 2-9
oracle account activities, 2-11
raw device creation, 2-5 to
2-10
root user activities, 2-11
primary and secondary instances
client configuration, 5-8
connecting to secondary instances, 5-9
init
db_name
.ora file configuration, 5-7
listener configuration, 5-9
overview, 5-6
PROTOCOL (PRO or PROT) attribute, 4-8
pwd
sid
.ora file, 3-37
R
raw devices
control files, 2-6
creating, 2-7
on UNIX, 2-7
on Windows NT, 2-9
creating as root user, 2-7
data files, 2-6
DRSYS tablespace, 2-6
identifying on UNIX
control1 database object, 2-8
control2 database object, 2-8
drysys1 database object, 2-8
indx1 database object, 2-8
rbs1 database object, 2-8
redo
thread_number
database object, 2-8
system1 database object, 2-8
temp1 database object, 2-8
tools1 database object, 2-8
users1 database object, 2-8
identifying on Windows NT
db_name
_control1 symbolic link, 1-14,
2-10
db_name
_control2 symbolic link, 1-14,
2-10
db_name
_drsys1 symbolic link, 1-13,
2-10
db_name
_indx1 symbolic link, 1-13,
2-10
db_name
_rbs1 symbolic link, 1-13,
2-10
db_name
_redo
thread_number
symbolic link, 1-13,
2-10
db_name
_system1 symbolic link, 1-13,
2-10
db_name
_temp1 symbolic link, 1-13,
2-10
db_name
_tools1 symbolic link, 1-13,
2-10
db_name
_users1 symbolic link, 1-13,
2-10
INDX tablespace, 2-6
RBS tablespace, 2-6
redo log files, 2-6
setting DBCA_RAW_CONFIG environment variable, 2-9
setting up, 2-5 to
2-10
SYSTEM tablespace, 2-6
TEMP tablespace, 2-6
TOOLS tablespace, 2-6
USERS tablespace, 2-6
verification, 3-5,
3-7,
3-23
RBS tablespace
description, 1-12
raw device, 2-6
Recovery Manager
configure archive logs, 4-9 to
4-16
recovery with Recovery Manager, 4-9
redo log files
described, 1-13
raw devices, 2-6
registry
DefinedNodes value, 3-26
PM\
db_name
key, 3-11,
3-34,
C-3
remote connections to secondary instances, 5-10
REMOTE_LOGIN_PASSWORDFILE parameter, 4-5
repository database
described, 2-3,
6-3
installing, 6-9
RETRIES parameter, 5-3
.rhosts file, 2-11
RMAN
See
Recovery Manager
rollback segments, 1-16
described, 1-14
ROLLBACK_SEGMENTS parameter, 1-16,
4-5
root, 2-11
S
security login, 6-13
Select Instances to Start dialog box, 7-8
Select Instances to Stop dialog box, 7-11
service discovery
db_name
.conf file, C-3
errors, C-2
listener.ora file, C-4
nmiconf.log file, C-7
nmiconf.lst file, C-7
on UNIX, C-3
on Windows NT, 3-11,
3-34,
C-3
performing, 6-15
PM\
db_name
registry key, 3-11,
3-34,
C-3
See
auto-discovery
services.ora file, C-6
SID_LIST_
listener_name
parameter, C-4
tnsnames.ora file, C-5
troubleshooting, C-7
understanding, C-2
SERVICE_NAME parameter in tnsnames.ora file, 3-18
SERVICE_NAMES parameter in init
db_name
.ora file, 4-9
services
Oracle
HOME_NAME
Agent, 6-10
Oracle
HOME_NAME
DataGatherer, 6-27
Oracle
HOME_NAME
ManagementServer, 6-11
OraclePGMSService, 3-21
services.ora file, C-6,
C-7
SGA, defined, 1-2
shared disk storage subsystem, 2-5
shared Oracle home, B-11
shutdown types, 7-10
abort, 7-10
immediate, 7-10
normal, 7-10
shutdown database and other services, 7-11
shutdown database only, 7-11
shutting down an Oracle Parallel Server database, 7-12
setting parameters, 7-25
viewing results, 7-12
with SYSDBA privilege, 6-26
with SYSOPER privilege, 6-26
SID
described, 1-15
SID Prefix, 3-4,
3-27
SID_DESC parameter, C-4
SID_LIST_
listener_name
parameter, 3-40,
6-6,
C-4
SID
_startup net service name, C-5
sid
alrt.log file, C-10
sid
bsp0.trc file, C-9
sid
dbwr.trc file, C-9
sid
lck
n
.trc file, C-9,
C-11
sid
lmd
n
.trc file, C-9
sid
lmon.trc file, C-9
sid
p00
n
.trc file, C-9
sid
smon.trc file, C-9
single-instance database
migrating to multi-instance, 9-3
software requirements, 2-2,
2-3
sqlnet.ora file, 3-21,
3-40
default configuration, 3-21
square brackets, defined, xvii
starting
Console, 6-12
listener, 3-41
Management Server, 6-11
Oracle Data Gatherer, 6-27
Oracle Enterprise Manager, 6-10
Oracle Intelligent Agents, 6-10
Oracle Parallel Server database, 3-41,
7-7
Oracle Performance Manager, 8-4
from Console, 6-28
standalone, 6-28
startup
results, 7-12
setting Parallel Server parameters for, 7-24
SYSDBA privilege, 6-26
SYSOPER privilege, 6-26
startup types, 7-8
force, 7-8
mount, 7-8
no mount, 7-8
open, 7-8
restrict, 7-8
Status Details tab, 7-13
from Edit Parallel Server dialog box, 7-18
from Parallel Server Operation Results dialog box, 7-13
Status tab
from Edit Parallel Server dialog box, 7-17
stopping
Oracle Parallel Server database, 7-9
switchlog.sql script, 4-15
SYSDBA privilege, 6-19,
6-26,
7-24
SYSDBA privilege, granting, 6-24
SYSOPER privilege, 6-19,
6-26,
7-24
SYSOPER privilege, granting, 6-24
System Global Area (SGA), defined, 1-2
SYSTEM tablespace
raw device, 2-6
SYSTEM tablespace, description, 1-12
T
tablespaces
DRSYS, 1-12
expanding for large sorts, 1-12
INDX, 1-12
RBS, 1-12
SYSTEM, 1-12
TEMP, 1-12
TOOLS, 1-12
USERS, 1-12
TAF
configuring, 5-2
GLOBAL_DBNAME parameter in listener.ora file, 3-15
overview, 5-2
pre-establishing a connection, 5-5
retrying a connection, 5-5
with client load balancing, 5-4
with connect-time failover, 5-4
Tasks tab
from Create Job property sheet, 7-22
TEMP tablespace
described, 1-12
raw device, 2-6
testing the network, 4-3
thread ID, 1-16
THREAD parameter, 1-16,
4-5
TNS_ADMIN environment variable, B-5
tns_admin parameter, B-5,
B-8
tnsnames.ora file, 3-16,
3-40
BACKUP parameter, 5-3
default configuration, 3-16
DELAY parameter, 5-3
FAILOVER parameter, 4-2
FAILOVER_MODE, 5-3
INSTANCE_NAME parameter, 3-18
LOAD_BALANCE parameter, 4-2
METHOD parameter, 5-3
RETRIES parameter, 5-3
service discovery, C-5
SERVICE_NAME parameter, 3-18
TYPE parameter, 5-3
TOOLS tablespace
described, 1-12
raw device, 2-6
trace files, C-8
background thread trace files, C-9
error call trace stack, C-11
ora
xxxxx
.trc, C-10
sid
alrt.log, C-10
sid
bsp0.trc, C-9
sid
dbwr.trc file, C-9
sid
lck
n
.trc, C-9,
C-11
sid
lmd
n
.trc, C-9
sid
lmon.trc, C-9
sid
p00
n
.trc, C-9
sid
smon.trc file, C-9
Transparent Application Failover
configuring, 5-2
GLOBAL_DBNAME parameter in listener.ora file, 3-15
overview, 5-2
pre-establishing a connection, 5-5
retrying a connection, 5-5
with client load balancing, 5-4
with connect-time failover, 5-4
troubleshooting, C-1 to
C-12
Oracle Database Configuration Assistant, 3-24,
3-44
service discovery, C-2
trace files, C-8
TYPE parameter, 5-3
Typical database creation type, 1-11
Typical installation type, 3-2
U
upgrading
Oracle Parallel Server issues, 3-21
uppercase, defined, xvii
User Manager, for Oracle Enterprise Manager, 6-20
user trace files, C-10
USER_DUMP_DEST parameter, 4-9,
C-10
USERS tablespace
described, 1-12
raw device, 2-6
V
V$ACTIVE_INSTANCES, 3-42
V$ACTIVE_INSTANCES table, 7-17
V$SESSION table, 5-6
vppcntl -start command, 6-27
Copyright © 1996-2000, Oracle Corporation.
All Rights Reserved.
Library
Product
Contents