Oracle8 Enterprise Edition Getting Started
Release 8.0.5 for Windows NT
A64416-01
Library
Product
Contents
Index
Index
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
Symbols
"", SQL*Loader parameter, 3-16
"FIX n", SQL*Loader parameter, 3-16
"VAR xxxx", SQL*Loader parameter, 3-16
.SQL scripts
location of, A-5,
A-9
A
A2OWIZ80 parameter, C-6
Adobe Acrobat Reader, starting, 1-9
Advanced Replication support
additional documentation, 8-50
configuration requirements, 8-3
configuration responsibilities, 8-47
configuration tasks, 8-49
creating a SPOOL file, 8-49,
8-50
data dictionary
tables, 8-51
for custom database, 5-3
for starter database, 5-3
initialization parameter requirements, 8-48
tablespace requirements, 8-48,
8-51
using, 8-51
alert files, 12-13
for monitoring a database, 12-2
using, 12-13
alert view, 12-5
ALL_HOMES, registry subkey for multiple Oracle homes, C-11
ALTER DATABASE ARCHIVELOG command, 10-24
ALTER DATABASE CONVERT, 7-36
ALTER DATABASE OPEN RESETLOGS, 7-37
ALTER PACKAGE, using, 8-50
ALTER USER command, 5-6
AmiPro format, supplied external filter, 16-4
API
parameter, C-10
value, C-6
ARCHIVE LOG LIST command, 10-23
ARCHIVELOG mode, 10-23
archiving mode
custom database, 5-3,
10-23
starter database, 5-3,
10-23
archiving procedures, 10-25
for redo log files, 10-23
specifying an archive destination, 10-25
assistant common files, 2-7
assistants
operating system compatibility, 3-3
Oracle Data Migration Assistant, 2-9
Oracle Database Assistant, 2-9
Oracle INTYPE File Assistant, 2-13
Oracle Migration Assistant for Microsoft Access, 2-10
Oracle Net8 Assistant, 2-10
Oracle Net8 Easy Config, 2-11
Oracle Web Publishing Assistant, 2-14
starting, 3-14
ATTRIB, 3-9
audit trail
created in data dictionary, 5-10
managing, 12-13
audit trail, operating system, 3-20
AUDIT_TRAIL parameter, 12-11
auditing, 12-11
authentication
connecting as INTERNAL without a password, 11-18
connecting as SYSOPER or SYSDBA without a password, 11-14
connecting without a password as a nonprivileged database user, 11-3
creating an operating system-authenticated user, 11-10
granting database roles through Windows NT, 11-23
overview, 11-2
setting OS_AUTHENT_PREFIX, 11-4
setting OSAUTH_PREFIX_DOMAIN, 11-5,
11-7,
15-12
SQLNET.ORA file, 11-3
using a password file, 10-18
using Windows NT Native Authentication Adapter, 11-2
auto-starting
Oracle Services, 10-8
B
BACKGROUND_DUMP_DEST parameter, using with trace files, 12-13
backslash (\), defined, xxiii
backup
databases, 9-21
OCOPY80 file types, 13-4
stopping services to perform cold backups, 13-3
backup and recovery tools
Backup Manager, 13-2
NT Backup and Recovery Manager, 13-3
OCOPY80, 13-3
Recovery Manager (RMAN80.EXE), 13-2
selecting, 13-2
third-party backup and recovery vendors, 13-3
Backup Manager
capabilities, 4-16,
13-2
starting, 3-13
block size, maximum, B-7
blocks per file, maximum, B-7
browsers
Java-enabled, 1-9
Microsoft Internet Explorer, 1-8
Netscape Navigator, 1-8
BUILD_DB.SQL script, 9-7,
9-12
C
C:\>, defined, xxiii
C:\ORANT, defined, xxiv
C:\ORAWIN, defined, xxiv
C:\ORAWIN95, defined, xxiv
C:\ORAWIN98, defined, xxiv
cartridges
for custom database, 5-3
for starter database, 5-3
CAT8000.SQL migration script, 7-37
CAT8004.SQL, 7-42
CATALOG.SQL
location of, A-5
CATALOG.SQL script, 7-47
CATEXP.SQL
location of, A-5
CATMD.SQL
creating data dictionary tables and views, 8-20
packages created, 8-20
CATNSNMP.SQL, capabilities, 5-5
CATOUT.LOG file, 7-37
CATPARR.SQL, 7-38
CATPROC.SQL
location of, A-5
CATPROC.SQL script, 7-47
CATREP8M.SQL, 7-37
executing, 8-49
running, 8-49
CD-ROMs, order of installation, 2-6
chart view, 12-5
Choose Start >, defined, xxiii
code conventions, used in this manual, xxiii
cold backups
performing, 13-3
COMMIT_POINT_ STRENGTH parameter, B-4
communication daemon, responsibilities, 4-7
COMPANY_NAME parameter, C-6,
C-10
COMPATIBLE parameter, 7-36,
7-44,
B-4
compiling
OCI with Oracle XA, 15-11
Oracle XA Library, 15-10
Pro*C/C++ with Oracle XA, 15-11
composite jobs, Job Scheduling System, 4-10
configuration parameters
defined, C-2
registry, C-1
configuration requirements
Advanced Replication support, 8-3
for Oracle products, 8-2
multi-threaded external callouts, 8-3
Net8, 8-2
Oracle Enterprise Manager, 8-2
Oracle Parallel Server, 8-2
Oracle8 ConText Cartridge, 8-3
Oracle8 Image Cartridge, 8-3
Oracle8 Spatial Cartridge, 8-3
Oracle8 Time Series Cartridge, 8-3
Oracle8 Visual Information Retrieval Cartridge, 8-3
PL/SQL external procedures, 8-3
configuration responsibilities
Advanced Replication support, 8-47
Net8, 8-3
Oracle Enterprise Manager, 8-4
Oracle8 ConText Cartridge, 8-21
Oracle8 Image Cartridge, 8-38
Oracle8 Spatial Cartridge, 8-18
Oracle8 Time Series Cartridge, 8-41
Oracle8 Visual Information Retrieval Cartridge, 8-44
configuration tasks
Advanced Replication support, 8-49
Oracle8 ConText Cartridge, 8-33
Oracle8 ConText Cartridge Demos, 8-35
Oracle8 ConText Cartridge Workbench, 8-37
Oracle8 ConText Cartridge Workbench Demos, 8-37
Oracle8 Image Cartridge, 8-39
Oracle8 Image Cartridge Demos, 8-39
Oracle8 Spatial Cartridge, 8-18
Oracle8 Time Series Cartridge, 8-42
Oracle8 Time Series Cartridge Demos, 8-43
Oracle8 Visual Information Retrieval Cartridge, 8-45
Oracle8 Visual Information Retrieval Cartridge Demos, 8-46
configuring, LISTENER.ORA file, 15-3
CONNECT INTERNAL, 10-20
changing the INTERNAL password, 10-21
connecting without a password, 11-18
password, 10-20
using, 10-8,
10-20,
10-23,
F-3
connecting
to a database, 10-8,
10-23,
F-3
console
features, 4-3
Oracle Enterprise Manager, 4-2
windows, 4-5
contact information
documentation sales, 1-2
Legato, 2-7
Oracle Worldwide Customer Support, xvii
ConText.
See
Oracle8 ConText Cartridge, 16-1
control files
creating a second control file with Oracle Database Assistant, 5-3
description, 5-9
starter database, 5-9
Control Panel
defined, 3-18
integration with Oracle8 database, 3-18,
10-3
starting, 3-10
CONTROL_FILES parameter, 9-10,
B-4
copy modes, for OCOPY80, 13-4
CORE40 parameter, C-6
CREATE DATABASE statement, 9-12
CREATE LIBRARY command, 15-6
CREATE USER, 11-10
cross-platform job scripts, 4-10
CTXDEMO user name, 8-34,
8-35
CTXLING demo, 8-35
CTXPLUS demo, 8-35
CTXQUERY demo, 8-35,
8-37
CTXSYS user name, 8-34
CTXV236.OCX, registering on Windows 95 clients, F-9
Custom Configuration
contents, 5-2
database installation type, 5-2
using Oracle Database Assistant, 5-2
custom database
advanced replication support, 5-3
archiving mode, 5-3,
10-23
cartridges and options, 5-3
contents, 5-2
database files, 5-3
database name, 5-2
system identifier, 5-2
tablespaces, 5-3
user names, 5-3
using Oracle Database Assistant, 5-2
Customer Support
contacting, xvi
D
D*.SQL, downgrading script, 2-5
data dictionary
Advanced Replication tables, 8-51
contents, 5-10
description, 5-10
starter database, 5-10
data files
description, 5-8
RBS1
SID
.ORA, 5-8
starter database, 5-8
SYS1
SID
.ORA, 5-8
TMP1
SID
.ORA, 5-8
USR1
SID
.ORA, 5-8
Data Manager
capabilities, 4-17
starting, 3-13
database administration applications
Backup Manager, 4-16
common features, 4-18
Data Manager, 4-17
Instance Manager, 4-15
Oracle Enterprise Manager, 4-15
Schema Manager, 4-16
Security Manager, 4-16
Software Manager, 4-17
SQL Worksheet, 4-15
Storage Manager, 4-15
database backup and recovery tools, 13-3
Backup Manager, 13-2
NT Backup and Recovery Manager, 13-2
OCOPY80, 13-3
Recovery Manager (RMAN80), 13-2
third-party vendors, 13-3
database coexistence
issues, 7-6
overview, 7-3
database files
deleting, 9-9
for custom database, 5-3
for starter database, 5-3
database monitoring
using Performance Monitor, 12-3
with alert files, 12-13
with Event Viewer, 12-10
with trace files, 12-13
database name
for custom database, 5-2
for starter database, 5-2
database privileges
in Windows NT local groups, 11-14,
11-18,
11-24,
11-26
database roles
DBSNMP user name, 5-5
DEMO user name, 5-5
granting through Windows NT, 11-23
MDSYS user name, 5-5
of SYS user name, 5-5
ORDSYS user name, 5-5
SCOTT user name, 5-5
SYSTEM user name, 5-5
database tools
operating system support, 3-2
starting, 3-6
database user, connecting without a password, 11-3
databases
backing up, 9-21
BUILD_DB.SQL script, 9-7
changing passwords, 9-17
coexistence, 7-3
connecting to, 10-8,
10-23,
F-3
control file in starter database, 5-9
creating, 9-1
data dictionary in starter database, 5-10
data files in starter database, 5-8
deleting, 9-9
exporting, 9-8
importing, 9-17
installation in multiple homes, 7-9,
7-16
installation in the same home, 7-8,
7-14
installation on separate computers, 7-10
maximum size possible, B-8
migrating Microsoft Access, 7-50
migration, 7-3,
7-11
monitoring, 12-1,
12-2
naming conventions, 9-2
Oracle Database Assistant, 9-3
parameters for a new database, B-4
password encryption, 10-22
redo log files in starter database, 5-9
shutting down, 10-8,
10-10,
10-15
starting, 10-8,
10-10
system identifier, 5-6
tablespaces in starter database, 5-7
upgrading, 7-3,
7-4,
7-12,
7-40
user names in starter database, 5-4
what to do with existing databases, 7-2
DB_BLOCK_SIZE parameter, B-4
DB_FILE_MULTIBLOCK_ READ_ COUNT parameter, B-4
DB_FILE_SIMULTANEOUS_ WRITES parameter, B-4
DB_FILES parameter, 9-11,
B-4
DB_NAME parameter, 9-10,
B-4
DBA_AUTHORIZATION parameter, 11-18
DBLINK_ENCRYPT_LOGIN parameter, 10-22
DBSNMP user account
dropping with CATNSNMP.SQL, 5-5
DBSNMP user name, 5-5
database roles, 5-5
password, 5-5
DBVERIFY
operating system compatibility, 3-2
starting, 3-8
default control file, CTL1
SID
.ORA, 5-9
default data files
RBS1
SID
.ORA, 5-8
SYS1
SID
.ORA, 5-8
TMP1
SID
.ORA, 5-8
USR1
SID
.ORA, 5-8
default initialization parameter file, INIT
SID
.ORA, 5-8
default redo log files
LOG1
SID
.ORA, 5-9
LOG2
SID
.ORA, 5-9
LOG3
SID
.ORA, 5-9
LOG4
SID
.ORA, 5-9
default tablespaces, 5-7
default user names, 5-4
DEFAULT_HOME parameter, C-11
DEMO user name, 5-5
database roles, 5-5
passwords, 5-5
demos
configuring for Oracle8 Image Cartridge, 8-39
configuring for Oracle8 Time Series Cartridge, 8-43
configuring for Oracle8 Visual Information Retrieval Cartridge, 8-46
Oracle8 ConText Cartridge, 8-35
directory names, convention used, xxiii
directory structure
client, A-7
Windows NT Server, A-2
discovering services, for Oracle Enterprise Manager, 8-13
DISK_FULL error message, D-2
DisplayName parameter, C-14
DISTRIBUTED_TRANSACTIONS parameter, B-4
distributing software
Oracle, 14-2
Systems Management Server, 14-3
DLL, external procedures, 15-5
DML_LOCKS parameter, B-4
documentation
Adobe Acrobat Reader, 1-9
formats supplied, 1-2
generic, 1-3
how to find specific information (online), 1-8
HTML, 1-2
list of included manuals, 1-4
Oracle Information Navigator, 1-2
PDF, 1-2
printed, 1-2
documentation conventions, used in this manual, xxiii
documentation sales, 1-2
DOS compatibility mode, F-7
downgrading scripts
new names, 2-5
DRIVE_LOCKED error message, D-2
dynamic registration
Oracle XA Library, 15-12
E
encrypting, database passwords, 10-22
error messages
Intercartridge Exchange, 15-19
logging, D-2
ORA-01102, 9-2
ORA-12547, F-2
Oracle Installer, D-2
Oracle8 database, D-4
OSD-04000 to OSD-04099, D-7
OSD-04100 to OSD-04199, D-12
OSD-04200 to OSD-04299, D-14
OSD-04300 to OSD-04399, D-17
OSD-04400 to OSD-04499, D-18
OSD-04500 to OSD-04599, D-18
resolving, xvi
errors
migration, F-6
OCIW32.DLL, F-5
ORA-23346, F-7
rollback segments, F-6
system tablespace extend, F-5
Event Management System
Oracle Enterprise Manager, 4-12
proactive events management, 4-12
Event Management Window, Oracle Enterprise Manager, 4-5
event scripts, with Job Scheduling System, 4-12
Event Viewer, 12-10
34 ID, 12-11
auditing, 12-11
blue (informational) icon, 12-11
defined, 3-19
for monitoring a database, 12-2
IDs other than 34, 12-11
integration with Oracle8 database, 3-19
logging operating system audit trail, 3-20
managing, 12-13
overview, 3-19
reading, 12-11
red (stop sign) icon, 12-11
starting, 3-10
using, 12-10
yellow (exclamation point) icon, 12-11
exception conditions, Intercartridge Exchange, 15-19
EXECUTE privileges, on a PL/SQL library, 15-6
EXECUTE_SQL parameter, C-6
existing databases, installation types, 7-2
EXP80.
See
Export Utility
Export Utility
databases, 9-8
interactive mode, 9-8
operating system compatibility, 3-2
parameter mode, 9-8
redirecting output, D-2
starting, 3-8
EXTERNAL clause, 15-6
external filters (supplied), Oracle8 ConText Cartridge, 16-3
external procedures
additional documentation, 15-10
building, 15-2
building a DLL, 15-5
configuring, 15-3
creating, 15-2
creating a PL/SQL library, 15-6
defined, 15-2
enabling multi-threaded callout support, 15-9
EXTERNAL clause, 15-6
features, 15-2
granting EXECUTE privileges, 15-6
installing, 15-3
registering with Oracle8 database, 15-6
using EXTPROC, 15-3
using Oracle7 network configuration files, 8-2
writing, 15-4
EXTPROC, responsibilities, 15-3
F
file names, convention used, xxiii
file size, maximum possible, B-7
FILE_CORRUPTED error message, D-2
FILE_NOT_FOUND error message, D-2
files
alert, 12-13
assistant common, 2-7
LISTENER.ORA, 15-3
maximum number per database, B-7
maximum size possible, B-7
sample INIT.ORA, B-3
trace, 12-13
G
generic documentation references
calculating index size, B-8
configuring Oracle Intelligent Agent, 8-4
CREATE DATABASE, 9-12
custom database archiving mode, 10-23
database audit trail, 5-10
earliest releases that can be migrated, 7-4
install test databases in a separate Oracle home, 6-3
instance identifier and database name matching, 5-2
location of initialization parameter file, B-2
log archive destination, B-4
log archive format, B-4
LOG parameter use, D-2
managing the Event Viewer, 12-13
maximum number of data files, 9-11
Microsoft operating systems certified on version 8, 2-2
multiple control files, 5-3
name and location of convert file, 7-36
Oracle Enterprise Manager setup, 8-4
password file environmental variable, C-7
password file names, 10-18
product versions certified on version 8, 2-7
running CATPROC.SQL, 9-16
setting resource costs, B-8
SORT_AREA_SIZE default value, B-5
specifying archive destinations, B-4
starter database archiving mode, 5-3,
10-23
starting Server Manager (SVRMGR30), 3-10
supported operating systems, 2-2
Windows NT-specific archiving procedures, 10-25
Windows NT-specific audit trail availability, 12-11
Windows NT-specific audit trail facility, 12-11
Windows NT-specific authentication, 11-2
Windows NT-specific automatic database startup after reboot, 10-8
Windows NT-specific control file specifications, 9-10
Windows NT-specific CONTROL_FILE parameter value, B-4
Windows NT-specific database creation procedures, 9-3
Windows NT-specific database migration instructions, 7-17
Windows NT-specific DBVERF80 executable location, A-2,
A-7
Windows NT-specific error messages, D-7
Windows NT-specific initialization parameter file, B-2
Windows NT-specific instance startup file names, 10-9
Windows NT-specific JDBC drivers, 2-8
Windows NT-specific local groups use, 11-14
Windows NT-specific location of .SQL scripts, A-5,
A-9
Windows NT-specific LOG_ARCHIVE_BUFFERS value, B-4
Windows NT-specific LOG_ARCHIVE_DEST format, B-4
Windows NT-specific LOG_ARCHIVE_DEST value, B-4
Windows NT-specific LOG_ARCHIVE_FORMAT format, B-4
Windows NT-specific migration instructions, 7-1
Windows NT-specific NLS_LANG values, E-3
Windows NT-specific NLS_TERRITORY values, E-3
Windows NT-specific Oracle Enterprise Manager startup, 3-11
Windows NT-specific OS_AUTHENT_PREFIX case insensitivity, 11-4
Windows NT-specific parameter file name and location, 5-8,
B-2
Windows NT-specific parameter file values, B-4
Windows NT-specific password file name and location, 10-18
Windows NT-specific Password Utility installation, 2-19
Windows NT-specific redo log file location, 5-9
Windows NT-specific redo log file size, 5-9
Windows NT-specific remote database startup and shutdown procedures, 10-10
Windows NT-specific role granting, 11-23
Windows NT-specific role syntax, 11-26
Windows NT-specific Server Manager executable location, A-2,
A-7
Windows NT-specific trace file names, 12-13
Windows NT-specific upgrading instructions, 7-1
XA linking file names
GLOBAL_NAMES parameter, 9-10
GRANT EXECUTE ON command, 8-50
H
HOME_COUNTER parameter, C-11
HOME_NAME
, defined, xxiv
HOME
ID
defined, xxiv
registry naming convention, C-4
Hostname parameter, 12-3,
C-13
hostname value, 12-3
I
ICX.
See
Intercartridge Exchange
ID parameter, C-6,
C-10
imagecfg utility, 2-2
ImagePath parameter, C-14
IMP80.
See
Import Utility
Import Utility
databases, 9-17
interactive mode, 9-17
operating system compatibility, 3-2
parameter mode, 9-17
starting, 3-8
index size, calculating, B-8
infowin@us.oracle.com, xvi
INIT.ORA file.
See
initialization parameter file
initialization parameter file
creating a customized version, 5-2
defined, B-2
description, 5-8
editing, B-2
INIT
SID
.ORA, 5-8
location, B-2
modifying, 9-10
starter database, 5-8
using PFILE option for database startup, 10-9
using the default file for database startup, 10-9
initialization parameter requirements
Advanced Replication Support, 8-48
initialization parameters
BACKGROUND_DUMP_ DEST, B-4
BACKGROUND_DUMP_DEST, B-4
COMMIT_POINT_ STRENGTH, B-4
COMPATIBLE, B-4
CONTROL_FILES, B-4
DB_BLOCK_SIZE, B-4
DB_FILE_MULTIBLOCK_ READ_ COUNT, B-4
DB_FILE_SIMULTANEOUS_ WRITES, B-4
DB_FILES, B-4
DB_NAME, B-4
DISTRIBUTED_TRANSACTIONS, B-4
DML_LOCKS, B-4
LOG_ARCHIVE_BUFFER_ SIZE, B-4
LOG_ARCHIVE_BUFFERS, B-4
LOG_ARCHIVE_DEST, B-4
LOG_ARCHIVE_FORMAT, B-4
LOG_CHECKPOINT_ INTERVAL, B-4
LOG_FILES, B-4
LOG_SMALL_ENTRY_MAX_ SIZE, B-4
MTS_DISPATCHERS, B-5
MTS_MAX_DISPATCHERS, B-5
MTS_MAX_SERVERS, B-5
MTS_SERVERS, B-5
NLS_LANGUAGE, B-5
NLS_SORT, B-5
NLS_TERRITORY, B-5
OPEN_CURSORS, B-5
OS_AUTHENT_PREFIX, 11-4,
B-5
PROCESSES, B-5
REMOTE_LOGIN_PASSWORDFILE, B-5
SHARED_POOL_SIZE, B-5
SORT_READ_FAC, B-5
SORT_SPACEMAP_SIZES, B-5
TEMPORARY_TABLE_ LOCKS, B-5
TRANSACTIONS_PER_ ROLLBACK_SEGMENT, B-5
USER_DUMP_DEST, B-5
installing, Oracle8 ConText Cartridge wrappers and external filters, 16-4
Instance Manager
capabilities, 4-15
Oracle Enterprise Manager, 4-15
starting, 3-13
instances
creating, 9-22,
9-23,
9-24,
9-25,
9-26
defined, 10-4
deleting, 9-26
running multiple instances, 10-17
integrated applications, of Oracle Enterprise Manager, 4-15
interactive mode, Export Utility, 9-8
interactive mode, Import Utility, 9-17
Intercartridge Exchange
accessing web data, 15-14
configuring, 15-14
error messages, 15-19
exception conditions, 15-19
packaged functions, 15-16
stored packages, 15-16
troubleshooting, 15-21
using, 15-16
INTERNAL, 11-23
alias for SYS and SYSDBA, 5-4
changing the INTERNAL password, 10-21
connecting as, 10-20
connecting without a password, 11-18
password, 5-4,
10-20
user name, 5-4
INVALID_FILE_NAME error message, D-2
italic letters, defined, xxiii
J
Java Database Connectivity
JDBC OCI Driver, 2-8
JDBC Thin Driver, 2-8
Java Runtime Environment, 2-7
Java-enabled browsers, 1-9
JDBC.
See
Java Database Connectivity
Job Scheduling System
composite jobs, 4-10
event scripts, 4-12
lights out management, 4-9
optimized intelligent agent, 4-13
Oracle Enterprise Manager, 4-8
predefined event sets, 4-13
predefined job tasks, 4-9
scalability, 4-11,
4-13
scripts, 4-10
security, 4-11
storing and forwarding job scheduling, 4-9
unsolicited error detection, 4-12
Job Scheduling Window, Oracle Enterprise Manager Console, 4-5
L
LAST_HOME parameter, C-11
Legato NetWorker, defined, 2-7
Legato Storage Manager
adding BIN directory to PATH, 13-7
Legato Storage Manager, defined, 2-7
LEXICAL_ERROR error message, D-2
lights out management, 4-9
linking
OCI with Oracle XA, 15-11
Oracle XA Library, 15-10
Pro*C/C++ with Oracle XA, 15-11
LISTENER.ORA file
external procedures, 15-3
migration, 7-18
local groups
with database privileges, 11-14,
11-18,
11-24,
11-26
LOCKING_VIOLATION error message, D-3
LOG parameter
use of, D-2
log view, 12-5
LOG_ARCHIVE_BUFFER_ SIZE parameter, B-4
LOG_ARCHIVE_BUFFERS parameter, B-4
LOG_ARCHIVE_DEST parameter, 10-25,
B-4
LOG_ARCHIVE_FORMAT parameter, 10-25,
B-4
LOG_ARCHIVE_START parameter, 10-25
LOG_CHECKPOINT_ INTERVAL parameter, B-4
LOG_FILES parameter, B-4
LOG_SMALL_ENTRY_MAX_ SIZE parameter, B-4
LOG1
SID
.ORA file, 5-9
LOG2
SID
.ORA file, 5-9
LOG3
SID
.ORA file, 5-9
LOG4
SID
.ORA file, 5-9
LOGFILE parameter, C-14
logging error messages, D-2
Lotus 123 format, supplied external filter, 16-4
Lotus Freelance format, supplied external filter, 16-4
M
managing jobs, Oracle Enterprise Manager, 4-12
managing, Oracle Services, 10-2
Map Window, Oracle Enterprise Manager, 4-5
MAX_IO_SIZE, B-5
MDSYS user name, 5-5
creating manually, 8-19
database roles, 5-5
password, 5-5
Microsoft Access, migrating to Oracle8, 7-50
Microsoft Excel format, supplied external filter, 16-4
Microsoft Internet Explorer, 1-8
Microsoft PowerPoint format, supplied external filters, 16-4
Microsoft Word format, supplied external filters, 16-4
MIG80.
See
Migration Utility
migrating
using appropriate tool versions, 7-23
migration
instructions, 7-22
LISTENER.ORA file, 7-18
multiple Oracle homes, 7-4
Net8 Listener, 7-18
networking issues, 7-17
Oracle7 Clients, 7-17
overview, 7-3
SQL*Net, 7-19
migration CAT8000.SQL script, 7-37
migration PUPBLD.SQL script, 7-37
Migration Utility
operating system compatibility, 3-2
starting, 3-9
using, 7-22
MIG
SID
.ORA file, 7-33,
7-36
monitoring
alert files, 12-2
databases, 12-1
Event Viewer, 12-2
Oracle events, 3-19,
3-20
Oracle8 Objects, 12-5
Performance Monitor, 12-2
Performance Pack, 12-2
trace files, 12-2
MS_HELP parameter, C-6
MSHELP parameter, C-6
MTS_DISPATCHERS
specifying a value, B-5
MTS_DISPATCHERS parameter, B-5
MTS_MAX_DISPATCHERS parameter, B-5
MTS_MAX_SERVERS parameter, B-5
MTS_SERVERS parameter, B-5
multiple instances, running, 10-17
multiple Oracle homes
ALL_HOMES registry subkey, C-11
defined, xxiv
environment, 6-4
HOME
ID
registry naming convention, C-4
impact on registry, C-4
migration, 7-4
Oracle Enterprise Manager, 6-6
overview, 6-2,
7-3
quitting Oracle Installer, 6-2
registry subkeys, C-4,
C-5
service naming conventions, 10-2,
10-4,
10-5
system identifier, 5-6
upgrading, 7-4
working with, 6-7
multi-threaded callout support
configuration requirements, 8-3
enabling, 15-9
setting ORA_EXTPROC_THREADED, 15-9
setting OracleExtprocAgent, 15-9
multi-threaded server
configuring with Oracle Database Assistant, 2-9
specifying MTS_DISPATCHERS, B-5
N
NAME parameter, C-11
naming conventions for multiple Oracle homes, 10-2
Navigator Window, 4-5
NET START command, 9-15
Net8
configuration requirements, 8-2
configuration responsibilities, 8-3
configuring for external procedures, 15-3
products, 2-10
Net8 Client, defined, 2-11
Net8 Listener, migration, 7-18
Net8 Server, defined, 2-11
NET80 parameter, C-6
Netscape Navigator, 1-8
networking, migration, 7-17
NLS support, E-2,
E-3
NLS_LANG environment variable, 7-24
NLS_LANG parameter, C-6,
C-10,
C-11,
E-2
default values, E-2
territory and character set defaults, E-3
NLS_LANGUAGE parameter, B-5
NLS_SORT parameter, B-5
NLS_TERRITORY parameter, B-5
NLSRTL32 parameter, C-6
NLSRTL33 parameter, C-6
NOARCHIVELOG mode, 10-23
NT Backup Manager
capabilities, 13-3
operating system compatibility, 3-2
starting, 3-9
NT Recovery Manager
capabilities, 13-3
operating system compatibility, 3-2
starting, 3-9
O
Object Type Translator (OTT), defined, 2-13
ObjectName parameter, C-14
OCI
defined, 2-8
Oracle XA Library, 15-11
OCIW32.DLL error message, F-5
OCOPY80
backup file types, 13-4
capabilities, 13-3
copy modes, 13-4
operating system compatibility, 3-2
recovery file types, 13-6
starting, 3-9
syntax for backing up files, 13-5
syntax for recovering files, 13-6
ODBC.
See
Oracle Open Database Connectivity Driver
OI_NLS32 parameter, C-6
OPEN_CURSORS parameter, B-5
operating system authentication
connecting as INTERNAL without a password, 11-18
connecting as SYSOPER or SYSDBA without a password, 11-14
connecting without a password as a nonprivileged database user, 11-3
creating an authenticated user
creating, 11-10
granting database roles through Windows NT, 11-23
setting OS_AUTHENT_PREFIX, 11-4
setting OSAUTH_PREFIX_DOMAIN, 11-5,
11-7,
15-12
SQLNET.ORA file, 11-3
operating systems
audit trail, 3-20
authentication overview, 11-2
supported, 2-2
troubleshooting, F-6
OPERF80.LOG file, 12-9
viewing Performance Monitor status, 12-9
OPS$, 11-4
optimized intelligent agent, Job Scheduling System, 4-13
options
for custom database, 5-3
for starter database, 5-3
ORA_ENCRYPT_LOGIN parameter, 10-22
ORA_EXTPROC_THREADED
setting for multi-threaded callout support, 15-9
ORA_EXTPROC_THREADED parameter, C-6
ORA_NLS33 parameter, C-6
ORA_SHUTDOWN parameter, C-7
ORA_SHUTDOWN value, 10-15
ORA_SHUTDOWN_TIMEOUT parameter, C-7
ORA_SHUTDOWN_TIMEOUT value, 10-15
ORA_
SID
_PWFILE parameter, C-7
ORA_
SID
_SHUTDOWN parameter, C-7
ORA_
SID
_SHUTDOWN value, 10-15
ORA_
SID
_SHUTDOWN_TIMEOUT parameter, C-7
ORA_
SID
_SHUTDOWN_TIMEOUT value, 10-15
ORA-12547 error, F-2
Oracle Administrator Toolbar, defined, 2-8
Oracle Advanced Events, 12-15
Oracle Assistants
problems and workarounds, F-8
Oracle Call Interface.
See
OCI
Oracle Capacity Planner, 12-15
Oracle Change Management Pack, 12-20
Oracle Connection Manager, defined, 2-8
Oracle Data Migration Assistant
defined, 2-9
starting, 3-14
using, 7-20,
7-40
Oracle Database Assistant
configuring cartridges, 9-6
creating an additional control file, 5-3
creating an initialization parameter file, 5-2
defined, 2-9
deleting databases, 9-6
multi-threaded support, 9-6
problems and workarounds, F-9
starting, 3-14
Oracle DECnet Protocol Adapter, defined, 2-22
Oracle Diagnostics Pack, 12-14
Oracle Enterprise Manager
Backup Manager, 4-16,
13-2
common services, 4-6
communication daemon, 4-7
configuration files, 8-13
configuration requirements, 8-2
configuration responsibilities, 8-4
configuration tasks, 8-6
console capabilities, 4-2
console features, 4-3
console windows, 4-5
creating a repository, 8-13
Data Manager, 4-17
database administration applications, 4-15
defined, 2-9
discovering services, 8-13
Event Management System, 4-12
Event Management Window, 4-5
Instance Manager, 4-15
integrated applications, 4-15
Job Scheduling System, 4-8
Job Scheduling Window, 4-5
key components, 4-3
managing jobs, 4-12
Map Window defined, 4-5
multiple Oracle homes installation recommendation, 6-6
Navigator Window, 4-5
operating system compatibility, 3-3
Oracle Intelligent Agent, 4-7
overview, 4-2,
8-4
performance management packs, 12-14
Performance Pack, 12-2
Replication Manager, integrating, 4-18
repository, 4-14
scheduling jobs, 4-8
Schema Manager, 4-16
security, 4-14
Security Manager, 4-16
service discovery, 4-8
setup environments, 8-5
shutting down the database, 10-10
Software Manager, 4-17
SQL Worksheet, 4-15
starting, 3-11
starting the database, 10-10
Storage Manager, 4-15
Tcl scripts
User Manager, 8-9
Oracle Enterprise Manager configuration
creating a repository user account, 8-7
creating an NT user account, 8-9
starting Oracle Services, 8-7
Oracle Enterprise Manager SDK, defined, 2-9
Oracle Expert, 12-19
Oracle File Packager, defined, 2-9
Oracle Home Selector, 6-8
Oracle home,
See multiple Oracle homes
Oracle Information Navigator, starting, 1-8
Oracle Installer
defined, 2-10
error messages, D-2
Oracle Intelligent Agent
communicating with the console, 4-7
defined, 2-10
overview, 8-4
responsibilities, 4-7
starting, 8-7
Oracle INTYPE File Assistant, defined, 2-13
Oracle Lock Manager, 12-16
Oracle LU6.2 Protocol Adapter
defined, 2-12,
2-22
Oracle Migration Assistant for Microsoft Access
defined, 2-10
restrictions, 7-52
starting, 3-14
using, 7-51
Oracle Named Pipes Protocol Adapter
defined, 2-12,
2-22
Oracle Names Server
defined, 2-11,
2-20
Oracle Net8 Assistant
defined, 2-10
starting, 3-14
Oracle Net8 Easy Config, 8-3
defined, 2-11
starting, 3-14
Oracle NetBIOS Protocol Adapter, defined, 2-22
Oracle Objects for OLE, defined, 2-13,
2-22
Oracle Open Database Connectivity Driver, 2-18,
2-21
Oracle Parallel Server Manager Server, defined, 2-13
Oracle Parallel Server Option
defined, 2-13
Oracle Parallel Server, configuration requirements, 8-2
Oracle Performance Manager, 12-15
Oracle products
configuration guidelines, 8-2
for Windows 3.1, 2-21
for Windows NT and Windows 95/98, 2-7
package definition files, 14-2
Systems Management Server support, 14-2
Oracle Replication Manager, defined, 2-14
Oracle Security Server Manager, defined, 2-14
Oracle Services
auto-starting, 10-8
for Oracle8 database, 3-18
naming conventions for multiple Oracle homes, 10-2
OracleAgent, 10-5
OracleConTextService80, 10-5
OracleExtprocAgent, 10-5
OracleService
SID
, 10-4
OracleStart
SID
, 10-4
OracleTNSListener80, 10-4
OracleWebAssistant, 10-5
shutting down a database by stopping a service, 10-15
starting, 10-6
stopping, 10-7
viewing in the Control Panel, 3-18
Oracle SNMP Agent
defined, 2-14
Oracle SNMP Support
overview, 2-3
Oracle SPX Protocol Adapter
defined, 2-12,
2-22
Oracle SQL Analyze, 12-18
Oracle Tablespace Manager, 12-18
Oracle TCP/IP Protocol Adapter
defined, 2-12,
2-22
Oracle TopSessions, 12-16
Oracle Trace, 12-16
overview, 12-16
Oracle Web Publishing Assistant
starting, 3-14
Oracle Web Publishing Assistant, defined, 2-14
Oracle WebServer Manager, defined, 2-14
Oracle WebServer, installation sequence, 2-6
Oracle Worldwide Customer Support
contact information, xvii
Oracle XA Library
additional documentation, 15-14
compiling and linking a Pro*C/C++ program, 15-11
compiling and linking an OCI program, 15-11
dynamic registration, 15-12
functions, 15-10
overview, 15-10
ORACLE_GROUP_NAME parameter, C-7,
C-10
ORACLE_HOME parameter, C-7,
C-10
ORACLE_HOME
, explained, xxiv
ORACLE_HOME_NAME parameter, C-7,
C-10
ORACLE_HOME_SERVICE parameter, C-7
ORACLE_PRIORITY parameter, C-8
ORACLE_SID parameter, C-8
ORACLE_
SID
parameter, 9-19,
10-4,
10-17
Oracle7 applications, database coexistence, 7-6
Oracle7 Clients
connecting to Oracle8 databases, 7-7
migration, 7-17
migration to Oracle8, 7-13
Oracle7 database, migrating, 7-17
Oracle7 Utilities, defined, 2-14
Oracle8
installable products, 2-6
new features, 2-3
new products, 2-3
Oracle8 Buffer Cache, 12-7
Oracle8 Clients, connecting to Oracle7 databases, 7-7
Oracle8 ConText Cartridge
configuration requirements, 8-3
configuration responsibilities, 8-21
configuration tasks, 8-33
defined, 2-15
demos, 8-35
external filters (supplied), 16-3
manual filtering, 16-9
starting servers, 16-2
supplied external filters, setting up, 16-6
upgrading, 8-22
upgrading Oracle8 ConText Cartridge Workbench, 8-37
user-defined external filters, 16-10
Oracle8 ConText Cartridge Demos, defined, 2-15
Oracle8 ConText Cartridge I/O Utility, defined, 2-16
Oracle8 ConText Cartridge System Administration
defined, 2-16
Oracle8 ConText Cartridge Viewer
defined, 2-16
Oracle8 ConText Cartridge Viewer Cartridge, defined, 2-16
Oracle8 ConText Cartridge Viewer Plug-in
defined, 2-17
Oracle8 ConText Cartridge Workbench
defined, 2-15
Oracle8 ConText Cartridge, configuration guidelines, 8-2
Oracle8 ConText ConText Cartridge Configuration Manager, defined, 2-15
Oracle8 Data Dictionary Cache, 12-7
Oracle8 Data Files, 12-8
Oracle8 database
available Oracle Services, 3-18
connecting to, 10-8,
10-23,
F-3
error messages, D-4
operating system permission problems, F-6
password encryption, 10-22
selecting a backup and recovery tool, 13-2
shutting down, 10-8,
10-10,
10-15
shutting down a database with a service, 10-15
specifications, B-7
starter database control file, 5-9
starter database data dictionary, 5-10
starter database data files, 5-8
starter database initialization parameter file, 5-8
starter database redo log files, 5-9
starter database tablespaces, 5-7
starter database user names, 5-4
starting, 10-8,
10-10
system identifier, 5-6
transaction processing monitor, 15-10
using Control Panel, 3-18
using Event Viewer, 3-19
using Performance Monitor, 3-20
using User Manager, 3-24
Oracle8 database backup and recovery tools
Backup Manager, 13-2
NT Backup and Recovery Manager, 13-2
OCOPY80, 13-3
Recovery Manager (RMAN80.EXE), 13-2
third-party vendors, 13-3
Oracle8 DBWR stats1, 12-8
Oracle8 DBWR stats2, 12-8
Oracle8 Dynamic Space Management, 12-8
Oracle8 Enterprise Edition
defined, 2-2,
2-17
Oracle8 Free List, 12-9
Oracle8 Image Cartridge
configuration requirements, 8-3
configuration responsibilities, 8-38
configuration tasks, 8-39
defined, 2-18
running ORDIINST.SQL, 8-39
Oracle8 Image Cartridge Demos, configuration tasks, 8-39
Oracle8 Library Cache, 12-9
Oracle8 Objects, 12-4
Oracle8 Objects Option, 8-3
Oracle8 Objects Option, defined, 2-18
Oracle8 Objects, monitoring, 12-5
Oracle8 Partitioning Option, 8-3
Oracle8 Partitioning Option, defined, 2-19
Oracle8 Performance Monitor
accessing, 12-4
alert view, 12-5
chart view, 12-5
for monitoring a database, 12-2
Hostname parameter, 12-3
installation, 12-3
log view, 12-5
monitoring Oracle8 Objects, 12-5
OPERF80.LOG, 12-9
Oracle8 Buffer Cache, 12-7
Oracle8 Data Dictionary Cache, 12-7
Oracle8 Data Files, 12-8
Oracle8 DBWR stats1, 12-8
Oracle8 DBWR stats2, 12-8
Oracle8 Dynamic Space Management, 12-8
Oracle8 Free List, 12-9
Oracle8 Library Cache, 12-9
Oracle8 Redo Log Buffer, 12-8
password, 12-3
registry information, 12-3
Report View, 12-5
troubleshooting information, 12-9
Username parameter, 12-3
using, 12-3
Oracle8 Performance Utility, defined, 2-19
Oracle8 Redo Log Buffer, 12-8
Oracle8 Sorts, 12-9
Oracle8 Spatial Cartridge
configuration requirements, 8-3
configuration responsibilities, 8-18
configuration tasks, 8-18
creating MDSYS user, 8-19
defined, 2-19
developing applications with SDO80.LIB, 8-20
running CATMD.SQL, 8-20
Oracle8 Spatial Data Cartridge Utilities, defined, 2-19
Oracle8 Time Series Cartridge
configuration requirements, 8-3
configuration responsibilities, 8-41
configuration tasks, 8-42
defined, 2-19
Oracle8 Time Series Cartridge Demos, configuration tasks, 8-43
Oracle8 Utilities
defined, 2-19
operating system compatibility, 3-2
Oracle8 Visual Information Retrieval Cartridge
configuration requirements, 8-3
configuration responsibilities, 8-44
configuration tasks, 8-45
defined, 2-20
Oracle8 Visual Information Retrieval Cartridge Demos, configuration tasks, 8-46
ORACLE80 parameter, C-8
OracleAgent
defined, 10-5
starting, 8-7
OracleConTextService80, defined, 10-5
OracleExtprocAgent, defined, 10-5
OracleService
SID
, defined, 10-4
OracleStart
SID
, defined, 10-4
OracleTNSListener80, defined, 10-4
OracleWebAssistant, defined, 10-5
ORADEBUG
debugging utility, 10-27
starting, 10-27
ORADIM80
changing the INTERNAL password, 10-21
moving or copying password files, 10-20
operating system compatibility, 3-2
starting, 3-9
using, 3-16
ORAPWD80
creating password files, 10-18
operating system compatibility, 3-2
starting, 3-9
OraTcl, using with database commands, 4-10
ORDIINST.SQL, running, 8-39
ORDSYS user name, 5-5
database roles, 5-5
password, 5-5
OS_AUTHENT_PREFIX parameter, 11-4,
B-5
OS_ERROR error message, D-3
OS_ROLES parameter, 11-23
OSAUTH_PREFIX_DOMAIN parameter, 11-5,
11-7,
15-12
OSD-04000 to OSD-04099 error codes, D-7
OSD-04100 to OSD-04199 error codes, D-12,
D-14
OSD-04300 to OSD-04399 error codes, D-17
OSD-04400 to OSD-04499 error codes, D-18
OSD-04500 to OSD-04599 error codes, D-18
OTRACE73 parameter, C-8
OTT_DFLT parameter, C-8
OTT80 parameter, C-8
overview
managing and distributing Oracle software, 14-2
monitoring a database, 12-2
Oracle Enterprise Manager, 4-2
OWAST parameter, C-8
P
package definition files, Oracle products, 14-2
packaged functions
Intercartridge Exchange, 15-16
UTL_HTTP.REQUEST, 15-16
UTL_HTTP.REQUEST_PIECES, 15-17
parameter mode, Export Utility, 9-8
parameter mode, Import Utility, 9-17
parameters
defined, C-2
registry, C-1
PARFILE, using, D-2
password file
authenticating database administrators, 10-18
connecting as INTERNAL, 10-20
creating, 10-18
hiding, 10-18
registry variable, C-7
Password parameter, C-12
Password Utility.
See
ORAPWD80
passwords
changing for SYS user name, 5-6
changing for SYSTEM user name, 5-6
changing the INTERNAL password, 10-21
changing with ALTER USER command, 5-6
connecting without an INTERNAL password, 11-18
encryption, 10-22
for databases, 9-17
for DBSNMP user name, 5-5
for DEMO user name, 5-5
for INTERNAL user name, 5-4,
10-20
for MDSYS user name, 5-5
for ORDSYS user name, 5-5
for SCOTT user name, 5-5
for SYS user name, 5-5
for SYSTEM user name, 5-5
PATH, 6-7
PATH parameter, C-11
PDF format, supplied external filter, 16-5
PERF_FILE_NAME parameter, C-14
PERFORMANCE key, C-12
performance management packs, 12-14
Performance Monitor, 12-3
defined, 3-20
integration with Oracle8 database, 3-20
monitoring specific Oracle events, 3-20
starting, 3-11
viewing OPERF80.LOG file status, 12-9
Performance Pack, monitoring a database, 12-2
PERMISSION_DENIED error message, D-3
PFILE option, using, 10-9
PL/SQL
configuring external procedures, 8-3
external procedures, 15-2
PLSQL23 parameter, C-8
PLSQL80 parameter, C-9
PLUS_DFLT parameter, C-9
PLUS80 parameter, C-9
PRAGMA RESTRICT_REFERENCES, with Intercartridge Exchange, 15-19
predefined event sets
with Job Scheduling System, 4-13
privileges
in Windows NT local groups, 11-14,
11-18,
11-24,
11-26
Pro*C/C++, compiling and linking, 15-11
PRO18 parameter, C-9
PRO80 parameter, C-9
proactive events management
Event Management System, 4-12
PROCESSES parameter, B-5
protocol adapters, defined, 2-12
PUPBLD.SQL migration script, 7-37
PWD
SID
.ORA file, 10-18
R
RBS1
SID
.ORA
data file, 5-8
tablespace contained in, 5-8
RDBMS73 parameter, C-9
RDBMS80 parameter, C-9
RDBMS80_ARCHIVE parameter, C-9
RDBMS80_CONTROL parameter, C-9
READ_ERROR error message, D-3
RECALIBRATION_FAILURE error message, D-3
recovering, an Oracle8 database, 13-2
recovery file types, OCOPY80, 13-6
Recovery Manager, 13-2
capabilities, 13-2
operating system compatibility, 3-2
starting, 3-9
redo log files
archiving, 10-23
LOG1
SID
.ORA, 5-9
LOG2
SID
.ORA, 5-9
LOG3
SID
.ORA, 5-9
LOG4
SID
.ORA, 5-9
starter database, 5-9
REGEDT32 command, 9-19
registering, an external procedure, 15-6
registry
A2OWIZ80, C-6
adding parameters, C-17
ALL_HOMES subkey, C-11
API, C-6
API parameter, C-10
COMPANY_NAME, C-6,
C-10
configuration parameters, C-1
CORE40, C-6
DEFAULT_HOME, C-11
DisplayName, C-14
EXECUTE_SQL, C-6
HOME_COUNTER, C-11
HOME
ID
naming convention, C-4
Hostname, 12-3,
C-13
ID, C-6,
C-10
ImagePath, C-14
impact of multiple Oracle homes, C-4,
C-5
keys, C-2
LAST_HOME, C-11
LOGFILE, C-14
modifying values, C-15
MS_HELP, C-6
MSHELP, C-6
NAME, C-11
NET80, C-6
NLS_LANG, C-6,
C-10,
C-11
NLSRTL32, C-6
NLSRTL33, C-6
ObjectName, C-14
OI_NLS32, C-6
ORA_EXTPROC_THREADED, C-6
ORA_NLS32, C-6
ORA_NLS33, C-6
ORA_SHUTDOWN, 10-15,
C-7
ORA_SHUTDOWN_TIMEOUT, 10-15,
C-7
ORA_
SID
_ SHUTDOWN, C-7
ORA_
SID
_PWFILE, C-7
ORA_
SID
_SHUTDOWN, 10-15
ORA_
SID
_SHUTDOWN_TIMEOUT, 10-15,
C-7
ORACLE_GROUP_NAME, C-7,
C-10
ORACLE_HOME, C-7,
C-10
ORACLE_HOME_NAME, C-7,
C-10
ORACLE_HOME_SERVICE, C-7
ORACLE_PRIORITY, C-8
ORACLE_
SID
, C-8
ORACLE80, C-8
OTRACE73, C-8
OTT_DFLT, C-8
OTT80, C-8
OWAST, C-8
parameter values, C-2
Password, C-12
password value, 12-3
PATH, C-11
PERF_FILE_NAME, C-14
PERFORMANCE key, C-12
PLSQL23, C-8
PLSQL80, C-9
PLUS_DFLT, C-9
PLUS80, C-9
PRO18, C-9
PRO80, C-9
RDBMS73, C-9
RDBMS80, C-9
RDBMS80_ARCHIVE, C-9
RDBMS80_CONTROL, C-9
REG_DWORD, C-2,
C-18
REG_EXPAND_SZ, C-2,
C-18
REG_MULTI_SZ, C-2,
C-18
REG_SZ, C-2,
C-18
REGEDT32, 15-12,
C-15,
C-17
SHARED_ORACLE_HOME, C-9,
C-10
SQLPATH, C-9
starting, 3-11
SVRMGR, C-9
update ORACLE_SID, 9-19
Username, 12-3,
C-12
Registry Editor, C-2
REMOTE_LOGIN_PASSWORDFILE parameter, 10-18,
10-20,
B-5
Replication Manager
ORA-23346 error, F-7
replication, configuration tasks, 8-49
Report View, 12-5
repository database
Oracle Enterprise Manager, 4-14
overview, 8-4
user account, 8-7
Required Support Files
re-installing latest version, F-5
version 7.3.4, 2-20
version 8.0, 2-20
resource costs
setting, B-8
RMAN80.
See
Recovery Manager
roles
granting through Windows NT, 11-23
MDSYS user name, 5-5
of DBSNMP user name, 5-5
of DEMO user name, 5-5
of SCOTT user name, 5-5
of SYSTEM user name, 5-5
ORDSYS user name, 5-5
SYS user name, 5-5
rollback segments error, during migration, F-6
ROLLBACK_DATA tablespace, description, 5-7
S
scalability
Job Scheduling System, 4-11
with Job Scheduling System, 4-13
scheduling jobs, Oracle Enterprise Manager, 4-8
Schema Manager
capabilities, 4-16
starting, 3-13
schema, INTERNAL user name, 5-4
SCOTT user name, 5-5
database roles of, 5-5
password of, 5-5
scripts
location of, A-5,
A-9
SDO80.LIB, Oracle8 Spatial Cartridge application development, 8-20
security
of Oracle Enterprise Manager, 4-14
with Job Scheduling System, 4-11
with Oracle Enterprise Manager, 4-14
Security Manager, 4-16
starting, 3-13
SELECT * FROM ALL_OBJECTS, 8-50
Server Manager
operating system compatibility, 3-2
running CATREP8M.SQL script, 8-49
running multiple instances, 10-17
shutting down the database, 10-8
starting, 3-10,
10-8,
F-3
starting the database, 10-8
using ORADEBUG, 10-27
Server Manager, using appropriate version, 7-23
service discovery, Oracle Enterprise Manager, 4-8
services, 10-2
auto-starting, 10-8
available with Oracle8 database, 3-18
managing, 10-2
OracleAgent, 10-5
OracleConTextService80, 10-5
OracleExtprocAgent, 10-5,
15-9
OracleService
SID
, 10-4
OracleStart
SID
, 10-4
OracleTNSListener80, 10-4
OracleWebAssistant, 10-5
shutting down a database by stopping a service, 10-15
starting, 9-11,
10-6
stopping, 10-7
viewing in the Control Panel, 3-18
SET INSTANCE command, 11-17,
11-22,
11-27
SET ORACLE_SID=SID, 10-17
SHARED_ORACLE_HOME parameter, C-9,
C-10
SHARED_POOL_SIZE parameter, B-5
SHARING_VIOLATION error message, D-3
SHUTDOWN command
options, 10-9
using, 10-9
shutting down
databases, 10-8,
10-10,
10-15
SMS.
See
Systems Management Server
Software Manager, capabilities, 4-17
SORT_READ_FAC parameter, B-5
SORT_SPACEMAP_SIZES parameter, B-5
specifying an archiving file format, 10-25
SPOOL command, using, 8-49,
8-50
SQL scripts
location of, A-5,
A-9
SQL Worksheet
capabilities, 4-15
starting, 3-13
SQL*DBA, using appropriate version, 7-23
SQL*Loader
control file conventions, 3-17
direct path option, 3-16
operating system compatibility, 3-2
starting, 3-10
using, 3-16
SQL*Net
appropriate versions, 7-19
products, 2-20
SQL*Net Client, defined, 2-22
SQL*Net Server, defined, 2-20
SQL*Plus
defined, 2-21,
2-22
operating system compatibility, 3-3
starting, 3-15
SQL, external procedures, 15-2
SQLNET.ORA file, operating system authentication, 11-3
SQLPATH parameter, C-9
square brackets, defined, xxiii
starter database
advanced replication support, 5-3
archiving mode, 5-3,
10-23
cartridges and options, 5-3
contents, 5-2
control file, 5-9
data dictionary, 5-10
data files, 5-8
database files, 5-3
database name, 5-2
initialization parameter file, 5-8
redo log files, 5-9
system identifier, 5-2
tablespaces, 5-3,
5-7
Typical Configuration, 5-2
user names, 5-3,
5-4
starting
databases, 10-8,
10-10
Oracle Services, 10-6
Oracle8 Performance Monitor, 12-4
Server Manager, 10-8,
F-3
STARTUP command
using, 10-9,
F-3
stopping, Oracle Services, 10-7
Storage Manager, capabilities, 4-15
stored packages, Intercartridge Exchange, 15-16
SVRMGR parameter, C-9
SVRMGR versions, 7-23
SVRMGR30.
See
Server Manager
symbols, list of, xxv
syntax
for backing up files with OCOPY80, 13-5
for recovering files with OCOPY80, 13-6
SYS user name, 5-5
changing the password, 5-6
database roles of, 5-5
password of, 5-5
SYS1
SID
.ORA
data file, 5-8
tablespace contained in, 5-8
SYSDBA
connecting without a password, 11-14
SYSOPER
connecting without a password, 11-14
system identifier
defined, 10-4
for custom database, 5-2
for Oracle8 database, 5-6
for starter database, 5-2
multiple Oracle homes, 5-6
SYSTEM tablespace, description, 5-7
system tablespaces, errors during migration, F-5
SYSTEM user name, 5-5
changing the password, 5-6
database roles of, 5-5
password of, 5-5
Systems Management Server
capabilities
defined
distributing software, 14-3
Oracle product support, 14-2
package definition files, 14-2
products available for installation, 14-3
T
tablespaces
Advanced Replication support, 8-48,
8-51
containing RBS1
SID
.ORA, 5-8
containing SYS1
SID
.ORA, 5-8
containing TMP1
SID
.ORA, 5-8
containing USR1
SID
.ORA, 5-8
expanding for large sorts, 5-7
for custom database, 5-3
for starter database, 5-3
ROLLBACK_DATA, 5-7
starter database, 5-7
SYSTEM, 5-7
TEMPORARY_DATA, 5-7
USER_DATA, 5-7
Tcl
including database commands, 4-10
scripts
TEMPORARY_DATA tablespace, description, 5-7
TEMPORARY_TABLE_ LOCKS parameter, B-5
TextServer3 Dictionary Migration Tool
defined, 2-17
third-party backup and recovery vendors, 13-3
TKPROF
operating system compatibility, 3-2
starting, 3-10
TMP1
SID
.ORA
data file, 5-8
tablespace contained in, 5-8
TNSNAMES.ORA file, 15-3
external procedures, 15-3
TOO_MANY_OPEN_FILES error message, D-3
Tool Command Language.
See
Tcl
trace files, 12-13
creating with ORADEBUG, 10-27
for monitoring a database, 12-2
using, 12-13
using BACKGROUND_DUMP_DEST parameter, 12-13
using USER_DUMP_DEST, 12-13
transaction processing monitor
additional documentation, 15-14
interacting with Oracle8 database, 15-10
types, 15-10
TRANSACTIONS_PER_ ROLLBACK_ SEGMENT parameter, B-5
troubleshooting, xvi
Intercartridge Exchange, 15-21
operating system permission problems, F-6
ORA-12203 error, F-2
ORA-12547 error, F-2
ORA-28575 error, F-2
with ORADEBUG, 10-27
Typical Configuration
contents, 5-2
database installation type, 5-2
U
U*.SQL, upgrading script, 2-5
U0800030.SQL script, 7-47
U0800040.SQL script, 7-47
unsolicited error detection, Job Scheduling System, 4-12
upgrading
external filters for Oracle8 ConText Cartridge, 16-6
multiple Oracle homes, 7-4
Oracle8 ConText Cartridge, 8-22
overview, 7-3,
7-4
tools, 7-40
U0800020.SQL script, 7-47
U0800030.SQL script, 7-47
U0800040.SQL script, 7-47
wrappers for Oracle8 ConText Cartridge, 16-6
upgrading scripts
new names, 2-5
User Manager
defined, 3-24
for Oracle Enterprise Manager, 8-9
integration with Oracle8 database, 3-24
starting, 3-11
user names
changing passwords for SYS and SYSTEM, 5-6
CTXDEMO, 8-34,
8-35
CTXSYS, 8-34
DBSNMP, 5-5
DEMO, 5-5
for custom database, 5-3
for starter database, 5-3
INTERNAL, 5-4
MDSYS, 5-5
ORDSYS, 5-5
SCOTT, 5-5
starter database, 5-4
SYS, 5-5
SYSTEM, 5-5
USER_DATA tablespace, description, 5-7
USER_DUMP_DEST parameter, B-5
USER_DUMP_DEST, using, 12-13
Username parameter, C-12
USR1
SID
.ORA
data file, 5-8
tablespace contained in, 5-8
UTL_HTTP.REQUEST, Intercartridge Exchange, 15-16
UTL_HTTP.REQUEST_PIECES, Intercartridge Exchange, 15-17
UTLXPLAN.SQL
location of, A-5
V
variables, convention used, xxiii
vsa@us.oracle.com, xviii
W
web data, Intercartridge Exchange
Windows 95
DOS compatability mode, F-7
Windows NT
directory structure for database, A-2
tools, 3-3
user account, 8-9
Windows NT local groups
with database privileges, 11-14,
11-18,
11-24,
11-26
Windows NT Native Authentication Adapter, use of, 11-2
WordPerfect format, supplied external filters, 16-5
WRITE_ERROR error message, D-3
WRITE_PROTECTED error message, D-4
X
XA.
See
Oracle XA Library
XAVIEW.SQL
location of, A-5
Xerox XIF format, supplied external filter, 16-5
Prev
Copyright © 1998 Oracle Corporation.
All Rights Reserved.
Library
Product
Contents
Index
