Oracle7 Getting Started for Windows NT Go to Product Documentation Library
Library
Go to books for this product
Product
Go to Contents for this book
Contents
Go to Index
Index



Go to previous file in sequence

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



Go to previous file in sequence Prev Oracle
Copyright © 1996 Oracle Corporation.
All Rights Reserved.
Go to Product Documentation Library
Library
Go to books for this product
Product
Go to Contents for this book
Contents
Go to Index
Index