Oracle7 Getting Started for Windows NT
Library
Product
Contents
Index
Index
Index
A
Advanced Networking Option, 2-3
Advanced Replication Option
configuring, 3-20
data dictionary tables, 3-21
initialization parameters, 3-19
tablespace requirements, 3-18
using, 3-22
alert files, 7-7
for monitoring a database, 7-2
using, 7-7
ALTER SESSION, using, E-4
ARCH thread name, C-6
AUTOEXEC.BAT file, editing parameters, C-3
B
BACKGROUND_DUMP_DEST parameter, 7-7
backing up
databases, 8-2
with NT Backup Manager, 8-2
with OCOPY, 8-2,
8-3
with Oracle Enterprise Manager Backup Manager, 8-2
browsers
Java-enabled, 1-2
Microsoft Internet Explorer, 1-2
Netscape Navigator, 1-2
C
CKPT thread name, C-6
command prompt
convention, xiii
editing configuration parameters, C-3
COMMIT_POINT_ STRENGTH parameter, B-3
COMPATIBLE parameter, B-3
configuration files
TNSNAMES.ORA, 3-12
TOPOLOGY.ORA, 3-12
configuration parameters
defined, C-2
editing at the command prompt, C-3
editing in AUTOEXEC.BAT, C-3
editing in the Windows NT registry, C-2
NLS_LANG, C-4
ORA_sid_PWFILE, C-6
ORA_sid
_XCPT, C-7
ORA_XCPT, C-7
ORACLE_GROUP_NAME, C-5
ORACLE_HOME, C-5
ORACLE_PRIORITY, C-5
ORACLE_SID, C-6
PLSQLnn, C-7
RDBMSnn, C-7
configuring
Advanced Replication Option, 3-18
ConText Option, 3-17
Oracle Client Software Manager, 3-22
Oracle Enterprise Manager, 3-9
Oracle7 Spatial Data Option, 3-16
SQL*Net, 3-22
connecting as INTERNAL, 6-9
connecting as SYSDBA, 6-8
connecting as SYSOPER, 6-8
ConText Option
configuring, 3-17
control files, names, 3-6
CONTROL_FILES parameter, B-3
conventions, used in this manual, xiii
copy modes for OCOPY, 8-3
CREATE DATABASE SQL script, 5-7
CTL1ORCL.ORA file, 3-6
CTL2ORCL.ORA file, 3-6
customer support, contacting, F-1
D
data dictionary, definition, 3-7
data files, names, 3-5
database administration
16-bit tools, 4-13
32-bit tools, 4-13
managing services, 6-2
database administrators
operating system authentication, 6-8
password file authentication, 6-7
database files, deleting, 5-3
database monitoring
with alert files, 7-2,
7-7
with error message logging, 7-2
with Event Viewer, 7-2,
7-7
with Performance Monitor, 7-2
with trace files, 7-2,
7-7
database roles
creating, 6-11
granting, 6-12
databases
authenticating DBAs, 6-7
authenticating users, 6-5
backing up, 8-2
creating a new database, 5-2
exporting, 5-11
granting roles, 6-12
monitoring, 7-2
parameters for a new database, B-5
password encryption, 6-15
security, 6-5
starter database, 3-27
DB_BLOCK_SIZE parameter, B-3
DB_FILE_MULTIBLOCK_ READ_ COUNT parameter, B-3
DB_FILE_SIMULTANEOUS_ WRITES parameter, B-3
DB_FILES parameter, B-3
DBLINK_ENCRYPT_LOGIN parameter, 6-15
DBWR thread name, C-6
direct path option, SQL*Loader, 4-11
directory structures
Windows, A-4
Windows 95, A-4
Windows NT, A-2
DISK_FULL error message, D-2
documentation
definition of platform-specific, 1-3
finding specific information, 1-7
formats, 1-2
hard copy, 1-2
HTML, 1-2
included manuals, 1-3
Oracle Information Navigator, 1-2
DRIVE_LOCKED error message, D-2
E
error messages
logging, 7-2,
D-2
Oracle Installer, D-2
Oracle7 Server database, D-4
OSD-4000 to OSD-4099, D-7
OSD-4100 to OSD-4199, D-12
OSD-4200 to OSD-4299, D-14
OSD-4300 to OSD-4399, D-17
OSD-4400 to OSD-4499, D-17
OSD-4500 to OSD-4599, D-18
Event Viewer
for monitoring a database, 7-2
using, 7-7
Export Utility
redirecting output, D-2
starting, 4-6
F
FILE_CORRUPTED error message, D-2
FILE_NOT_FOUND error message, D-2
files
alert, 7-7
AUTOEXEC.BAT, C-3
control, 3-6
data, 3-5
INITsid.ORA, 3-5
redo log, 3-6
sample INIT.ORA, B-2
TNSNAMES.ORA, 3-12
TOPOLOGY.ORA, 3-12
trace, 7-7
I
Import Utility, starting, 4-6
initialization parameter file
definition, B-2
editing, B-2
location, B-2
modifying, 5-5
starter database, 3-5
initialization parameters
Advanced Replication Option, 3-19
BACKGROUND_DUMP_ DEST, B-3
COMMIT_POINT_ STRENGTH, B-3
COMPATIBLE, B-3
CONTROL_FILES, B-3
DB_BLOCK_SIZE, B-3
DB_FILE_MULTIBLOCK_ READ_ COUNT, B-3
DB_FILE_SIMULTANEOUS_ WRITES, B-3
DB_FILES, B-3
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_MAX_DISPATCHERS, B-4
MTS_MAX_SERVERS, B-4
MTS_SERVERS, B-4
NLS_LANGUAGE, B-4
NLS_SORT, B-4
NLS_TERRITORY, B-4
OPEN_CURSORS, B-4
OS_AUTHENT_PREFIX, B-4
PROCESSES, B-4
REMOTE_LOGIN_ PASSWORDFILE, B-4
SHARED_POOL_SIZE, B-4
SORT_READ_FAC, B-4
SORT_SPACEMAP_SIZES, B-4
TEMPORARY_TABLE_ LOCKS, B-4
TRANSACTIONS_PER_ ROLLBACK_ SEGMENT, B-4
USER_DUMP_DEST, B-4
INITORCL.ORA file, 3-5
Instance Manager
command line version, 4-2
GUI version, 4-2
help, 4-10
starting command line, 4-5
starting GUI, 4-5
using command line version, 4-8
instances
background threads, 2-5
creating, 4-8,
5-5
default ORCL, 2-4
definition, 2-4
deleting, 4-10
editing, 4-10
INITsid.ORA, 3-5
memory structures, 2-5
ORACLE_SID, C-6
running multiple, 2-4,
6-5
starting, 4-9,
5-5
stopping, 4-9
INTERNAL user account, 3-3
INTERNAL, connecting as, 6-9
INVALID_FILE_NAME error message, D-2
J
Java-enabled browsers, 1-2
L
LEXICAL_ERROR error message, D-3
LGWR thread name, C-6
LOCKING_VIOLATION error message, D-3
LOG_ARCHIVE_BUFFER_ SIZE parameter, B-4
LOG_ARCHIVE_BUFFERS parameter, B-4
LOG_ARCHIVE_DEST parameter, B-4
LOG_ARCHIVE_FORMAT parameter, B-4
LOG_CHECKPOINT_ INTERVAL parameter, B-4
LOG_FILES parameter, B-4
LOG_SMALL_ENTRY_MAX_ SIZE parameter, B-4
LOG1ORCL.ORA redo log file, 3-6
LOG2ORCL.ORA redo log file, 3-6
logging error messages, D-2
LSNRCTL utility, starting, 3-10,
3-15
M
memory map of process, C-7
Microsoft Internet Explorer, 1-2
monitoring a database, 7-2
MTS_MAX_DISPATCHERS parameter, B-4
MTS_MAX_SERVERS parameter, B-4
MTS_SERVERS parameter, B-4
N
Netscape Navigator, 1-2
NLS initialization parameters, E-4
NLS_LANGUAGE, E-4
NLS_TERRITORY, E-4
NLS language parameters
using ALTER SESSION, E-4
NLS languages
installing additional, E-8
language file abbreviations, E-8
language files, E-8
NLS parameters
available languages, E-5
available single-byte character sets, E-8
available territories, E-6
NLS support, E-2
NLS_LANG configuration parameter, C-4
NLS_LANG parameter, E-2
default values, E-2
territory and character set defaults, E-3
NLS_LANGUAGE parameter, B-4
NLS_SORT parameter, B-4,
E-4
NLS_TERRITORY parameter, B-4
NT Backup Manager
backing up database files, 8-2
restriction, F-2
NT Backup Tool, starting, 4-7
O
OCOPY
backing up database files, 8-2,
8-3
copy modes, 8-3
restoring database files, 8-5
starting, 4-7
syntax for backing up files, 8-4
syntax for restoring files, 8-5
OCSM.
See
Oracle Client Software Manager
OPEN_CURSORS parameter, B-4
operating systems
authenticating database administrators, 6-5
authenticating users, 6-8
list of supported platforms, 2-2
OPERF73.LOG file, Performance Monitor status, 7-5
OPS$ database logon, 6-5
ORA_%SID%_DBA, 6-11
ORA_ENCRYPT_LOGIN parameter, 6-15
ORA_sid_PWFILE configuration parameter, C-6
ORA_sid
_XCPT configuration parameter, C-7
ORA_XCPT configuration parameter, C-7
Oracle Call Interface, compiling, 3-25
Oracle Client Software Manager
configuring, 3-22
description, 3-22
Oracle DECnet Protocol Adapter, 2-3
Oracle Enterprise Manager
configuring, 3-9
creating a repository, 3-14
creating a repository user account, 3-10
creating an NT user account, 3-11
creating TNSNAMES.ORA file, 3-12
creating TOPOLOGY.ORA file, 3-12
discovering network services, 3-14
overview, 3-9
starting, 4-7
starting the Oracle Intelligent Agent, 3-10,
3-15
verifying Oracle Services, 3-10
Oracle Enterprise Manager Backup Manager, 8-2
Oracle Home, creating multiple, 3-26
Oracle Information Navigator, 1-2
Oracle Installer, error messages, D-2
Oracle Intelligent Agent
overview, 3-9
starting, 3-10,
3-15
Oracle Migration Wizard for Microsoft Access, 2-3
Oracle Network Manager, 3-8
Oracle XA Interface, 2-3
Oracle XA Library, compiling and linking, 3-24
ORACLE_GROUP_NAME configuration parameter, C-5
ORACLE_HOME configuration parameter, C-5
ORACLE_PRIORITY configuration parameter, C-5
ORACLE_SID, C-6
ORACLE_SID configuration parameter, C-6
Oracle7 objects, 7-2
Oracle7 Server
database error messages, D-4
definition for Windows NT, 2-2
integration with Windows NT, 2-4
key features, 2-2
monitoring the database, 7-2
new features, 2-3
supported operating systems, 2-2
OracleServiceORCL, 2-4,
6-2
OracleServicesid, 2-4
OracleStartORCL, 6-2
OracleTNSListenerid, 2-4
ORADIM73 command, 4-5
ORADIM73.LOG file, 4-10
ORAPWD73, starting, 4-7
OS_AUTHENT_PREFIX parameter, B-4
OS_ERROR error message, D-3
OSD-4000 to OSD-4099 error codes, D-7
OSD-4100 to OSD-4199 error codes, D-12,
D-14
OSD-4300 to OSD-4399 error codes, D-17
OSD-4400 to OSD-4499 error codes, D-17
OSD-4500 to OSD-4599error codes, D-18
P
PARFILE, using, D-2
password files, creating, 6-7
Performance Monitor, 7-2
for monitoring a database, 7-2
modifying Windows NT Registry values, 7-6
using, 7-2
viewing OPERF73.LOG file status, 7-5
Windows NT Registry values, 7-5
PERMISSION_DENIED error message, D-3
PLSQLnn configuration parameter, C-7
PMON thread name, C-6
Pro*C, compiling, 3-24
PROCESSES parameter, B-4
PWDsid.ORA file, 6-7
R
RBS1ORCL.ORA data file, 3-5
RDBMSnn configuration parameter, C-7
READ_ERROR error message, D-3
RECALIBRATION_FAILURE error message, D-3
RECO thread name, C-6
redo log files, names, 3-6
refreshing table snapshots, 6-16
REGEDT32
editing the Windows NT Registry, C-2
registers, C-7
REMOTE_LOGIN_ PASSWORDFILE parameter, B-4
REMOTE_LOGIN_PASSWORDFILE parameter, 6-10
replication database, 3-2
repository
creating for Oracle Enterprise Manager, 3-14
user account, 3-10
restoring database files
with OCOPY, 8-5
roles
creating, 6-11
DBA, 3-3
granting, 6-12
RESOURCE, 3-3
ROLLBACK_DATA tablespace, 3-4
S
SCOTT user account, 3-3
Server Manager
defining NLS parameters, E-4
starting, 4-5
using, 6-3
services
Oracle definition, 2-4
OracleServiceORCL, 2-4
OracleServicesid, 2-4
OracleTNSListener, 2-4
starting, 6-2
stopping, 6-2
Windows NT definition, 2-4
workstation security, 2-5
SHARED_POOL_SIZE parameter, B-4
SHARING_VIOLATION error message, D-3
SMON thread name, C-6
SNAPSHOT_REFRESH_INTERVAL parameter, 6-16
SNAPSHOT_REFRESH_KEEP_CONNECTIONS parameter, 6-16
SNAPSHOT_REFRESH_PROCESSES parameter, 6-16
SNP0 thread name, C-6
SNP9 thread name, C-6
SORT_READ_FAC parameter, B-4
SORT_SPACEMAP_SIZES parameter, B-4
Spatial Data Option, configuring, 3-16
SQL*Loader
starting, 4-6
using, 4-11
SQL*Net
configuring, 3-8
Oracle Network Manager, 3-8
OracleTNSListenerid, 2-4
SQL*Net Easy Configuration, 3-8
SQL*Net Easy Configuration, 3-8
SQL*Plus
starting, 4-8
standard database, 3-2
starter database
contents, 3-2
instance name, 2-4
tablespaces, 3-4
types, 3-27
user accounts, 3-3
starting
Export Utility, 4-6
Import Utility, 4-6
Instance Manager command line, 4-5
Instance Manager GUI, 4-5
NT Backup Tool, 4-7
OCOPY, 4-7
Oracle Enterprise Manager, 4-7
Server Manager, 4-5
SQL*Loader, 4-6
SQL*Plus, 4-8
User Manager, 4-7
syntax
for backing up files with OCOPY, 8-4
for restoring files with OCOPY, 8-5
SYS user account, 3-3
SYS1ORCL.ORA data file, 3-5
SYSDBA, use of, 6-8
SYSOPER, use of, 6-8
System Global Area (SGA), 2-4
System Identifier (SID), C-6
SYSTEM tablespace, 3-4
SYSTEM user account, 3-3
T
table snapshots
refreshing, 6-16
tablespaces, names, 3-4
TEMPORARY_DATA tablespace, 3-4
TEMPORARY_TABLE_ LOCKS parameter, B-4
threads
priority, C-6
starting instances, 2-5
TMP1ORCL.ORA data file, 3-5
TNSNAMES.ORA file
creating, 3-12
TOO_MANY_OPEN_FILES error message, D-3
tools
for backing up databases, 8-2
overview, 4-2
TOPOLOGY.ORA file, creating, 3-12
trace files, 7-7
for monitoring a database, 7-2
using, 7-7
using USER_DUMP_DEST parameter, 7-8
TRANSACTIONS_PER_ ROLLBACK_ SEGMENT parameter, B-4
TRWR thread name, C-6
U
user accounts, names and passwords, 3-3
User Manager
starting, 4-7
USER_DATA tablespace, 3-4
USER_DUMP_DEST parameter, 7-8,
B-4
users, operating system authentication, 6-5
USR1ORCL.ORA data file, 3-5
utilities, overview, 4-2
W
Windows 3.1
directory structure, A-4
Windows 95
directory structure for database, A-4
Windows NT
directory structure for database, A-2
Windows NT Registry
editing configuration parameters, C-2
monitoring Oracle7, 7-6
WIndows NT user account
creating for Oracle Enterprise Manager, 3-11
WRITE_ERROR error message, D-4
WRITE_PROTECTED error message, D-4
Prev
Copyright © 1996 Oracle Corporation.
All Rights Reserved.
Library
Product
Contents
Index