28/28
Index
A
B
C
D
E
F
H
I
L
M
N
O
P
Q
R
S
T
U
V
W
X
A
Access Control Lists (ACL)
adding and deleting security group members,
14.6.3
available security groups,
14.6
setting NTFS ACLs manually,
5.4.1.5
setting on Net Service directory objects,
14.6.2
accessing Active Directory,
14.1.2
ACLs
adding and deleting security group members,
14.6.3
available security groups,
14.6
setting NTFS ACLs manually,
5.4.1.5
setting on Net Service directory objects,
14.6.2
Active Directory
adding and deleting security group members,
14.6.3
automatic discovery of directory servers,
14.2.2
connecting to a database,
14.5
how Oracle directory objects appear,
14.2.7
integration with directory servers,
14.5
integration with Oracle objects,
14.2.3
managing Access Control Lists,
14.6
managing security groups,
14.6
requirements for using Oracle,
14.5
testing connectivity from client computers,
14.5
testing connectivity with SQL*Plus,
14.2.4
testing database connectivity,
14.2.4
user interface extensions,
14.2.4
adding and deleting users
Net Service Objects,
14.6.3
OracleDBCreators,
14.6.3
OracleNetAdmins,
14.6.3
adding executables,
5.1.1.2
firewall exceptions for Oracle Clusterware and Oracle ASM,
5.1.1.2.4
firewall exceptions for Oracle Database,
5.1.1.2.1
firewall exceptions for Oracle Database Examples,
5.1.1.2.2
firewall exceptions for Oracle Gateways,
5.1.1.2.3
firewall exceptions for other Oracle Products,
5.1.1.2.5
administering external roles,
11.2
administration tools prompting for password
Domain User Account,
2.2
Local User Account,
2.2
password not stored in Oracle Wallet,
2.2
administrator
starting ASMCA tool
member of ORA_ASMADMIN,
2.2
starting DBCA tool
member of ORA_DBA,
2.2
starting DBUA tool
member of ORA_ASMADMIN,
2.2
Administrators group
running configuration tools,
2.2.2
advanced replication
about,
5.9
configuring
adding and modifying initialization parameters,
5.9.2
,
5.9.2
checking tablespace,
5.9.1
monitoring data dictionary tables,
5.9.3
,
5.9.3
alert logs
monitoring a database,
7.1
using,
7.3
archiving mode
controlling,
6.7
custom database,
6.7
starter database,
6.7
archiving procedures
for redo log files,
6.7
archiving redo log files,
6.7
audit trail
managing,
7.2.3
operating system,
2.5.1
AUDIT_FILE_DEST,
7.2.3
,
15.4
Authenticated Users,
5.3
permissions for Oracle Database Client Oracle home,
5.4.1.1
permissions for Oracle Database Oracle home,
5.4.1.1
permissions for Oracle Grid Infrastructure Oracle home,
5.4.1.1
Authenticated Users group,
5.4.1.1
authentication
automatically enabling during installation,
10.4
enhancements,
10.3
OSAUTH_PREFIX_DOMAIN parameter,
11.2.1.1
overview,
10.1
,
14.4
using a password file,
6.5
using Windows native authentication methods,
14.4
using Windows native methods,
10.1
viewing parameter settings,
11.1.6
auto-starting Oracle Database services,
6.1.4
using Control Panel,
6.1.4
using Oracle Administration Assistant,
6.1.4
B
backing up database
32-bit Oracle Database,
4.5.1
about,
9.3
in archivelog mode
component-based,
9.3
,
9.3.2
volume-based,
9.3
,
9.3.2
in noarchivelog mode
component-based,
9.3.3
volume-based,
9.3.3
new database,
4.3.11
blocks for each file, maximum,
15.7
C
command-line tool
ORADIM,
4.4
commands
CREATE DATABASE,
4.3.6
CREATE LIBRARY,
17.2.5
NET START,
4.3.7
REGEDT32,
4.3.9
SET INSTANCE,
11.2.2.2
SET ROLE,
11.2.4.1
configuration parameters
defined,
16.1
LOCAL,
B.4.1
registry, defined,
16.1
TNS_ADMIN,
B.4.2
USE_SHARED_SOCKET,
B.4.3
configuring
advanced replication,
5.9.1
adding and modifying initialization parameters,
5.9.2
monitoring data dictionary tables,
5.9.3
Named Pipes Protocol Adapter,
B.5.2
Oracle Multimedia,
5.6.1
Oracle Spatial and Graph,
5.8
automatically,
5.8.1
Oracle Text,
5.7
Windows firewall exceptions,
5.1.1.1
Windows firewall postinstallation,
5.1.2
configuring Oracle Net Services for external procedures,
17.2.2.2
configuring Oracle Text
using Database Configuration Assistant,
5.7
using DBCA,
5.7
CONNECT /AS SYSDBA
connecting without a password,
10.4
using,
6.2
connecting
LOCAL parameter,
B.4.1
to a database,
6.2
to active directory using Windows login credentials,
14.2.6
CREATE LIBRARY command,
17.2.5
creating
an Oracle Context,
14.3.2
external operating system users,
11.2.1
external roles manually,
11.2.4
Oracle Schema objects,
14.3.1
ORACLE_
SID
parameter,
4.3.10
creating a local database role,
11.1.8
custom database
archiving mode,
6.7
noarchiving mode,
6.7
D
data dictionary tables,
5.9.3
Data Pump Export, starting,
2.2.4
Data Pump Import, starting,
2.2.4
database administrator (DBA) privileges
for a single database on a computer,
11.1.10
for all databases on a computer,
11.1.3
for ASM,
11.2.2
for databases,
11.2.2
database connection error messages,
D.6
database monitoring
with alert logs,
7.3
with Event Viewer,
7.2
with trace files,
7.3
database operator privileges
for a single database on a computer,
11.1.11
for all databases on a computer,
11.1.4
for databases,
11.2.2
database tools
operating system compatibility,
2.1.1
running with administrator privileges,
2.2.2
running with Windows User Account Control,
2.2.2
starting ASMCA,
2.2.3
starting DBCA,
2.2.3
,
4.2
starting from the command line,
2.2.4
starting from the Start Menu,
2.2.3
starting in multiple Oracle Homes,
2.2.1
starting Microsoft ODBC Administration,
2.2.3
starting NetCA,
2.2.3
,
14.3.2.1
starting Oracle Administration Assistant for Windows,
2.2.3
starting Oracle Directory Manager,
2.2.3
starting Oracle Net Manager,
2.2.3
starting Oracle Wallet Manager,
2.2.3
databases
backing up,
4.3.11
connecting to,
6.2
creating manually,
4.3
deleting,
4.3.2
exporting,
4.3.1
importing,
4.3.8
monitoring,
7.1
naming conventions,
4.1
password encryption,
6.6.2
shutting down,
6.2
,
6.3
starting,
6.2
DBCA prompts for password
Domain User Account,
4.2
Local User Account,
4.2
password not stored in Oracle Wallet,
4.2
debugging external procedures,
17.4
deleting database files,
4.3.2
developing applications for Windows,
17.1
diagnostic and tuning utilities for Windows,
2.6
directory naming software requirements,
14.3.3
directory servers
automatic discovery of directory servers,
14.2.2
features integrated with Oracle Database 11
g
,
14.2.1
how Oracle directory objects display in Active Directory,
14.2.7
integration with Active Directory,
14.5
managing Access Control Lists,
14.6
requirements for using Oracle with Active Directory,
14.5
user interface extensions,
14.2.4
DisplayName parameter,
B.2.1
DLLs
compared to UNIX shared libraries,
E.5
displaying with Task List,
2.6
external procedures,
17.2.4
Oracle Real Application Clusters
dnfs_batch_size parameter
default value is 4096,
1.1.4
recommended setting,
1.1.4
to control the number of queued asynchronous I/Os,
1.1.4
DNS-style naming convention,
14.5
duplicating a database
about,
9.6
creating a nonstandby database from shadow copies,
9.6.1
creating a standby database from shadow copies,
9.6.2
E
encrypting, database passwords,
6.6.2
enhanced security,
5.4.1
,
5.4.5
enhancing Oracle directory object type descriptions,
14.2.5
error messages
DIM-00000 to DIM-00228,
D.5
ORA-01102,
4.1
ORA-09275,
D.1
ORA-12560,
D.6
ORA-15252 to ORA-15266,
D.2
ORA-15301 to ORA-15302,
D.3
OSD-04000 to OSD-04099,
D.4.1
OSD-04100 to OSD-04199,
D.4.2
OSD-04200 to OSD-04299,
D.4.3
OSD-04300 to OSD-04399,
D.4.4
OSD-04400 to OSD-04499,
D.4.5
OSD-04500 to OSD-04599,
D.4.6
Event Viewer
blue (informational) icon,
7.2
defined,
2.5.1
for monitoring a database,
7.1
integration with Oracle Database,
2.5.1
logging operating system audit trail,
2.5.1
managing,
7.2.3
reading,
7.2.2
red (stop sign) icon,
7.2
starting,
2.2.5
using,
7.2
yellow (exclamation point) icon,
7.2
EXECUTE privileges, on a PL/SQL library,
17.2.5
Export parameter mode,
4.3.1
Export Wizard,
2.1.2
exporting
databases,
4.3.1
interactive mode,
4.3.1
parameter mode,
4.3.1
preferred tools,
2.2.4
extended partition,
A.1
EXTERNAL clause,
17.2.5
external operating system users
administering,
11.1
,
11.2
authentication,
11.2.1.1
authentication on client computer,
11.2.1.2
creating,
11.1.7
,
11.2.1
migrating manually,
11.2.5
external procedures
advantages,
17.2.1
building a DLL,
17.2.4
creating,
17.2
creating a PL/SQL library,
17.2.5
debugging,
17.4
executing,
17.2.7
EXTERNAL clause,
17.2.5
granting EXECUTE privileges,
17.2.5
registering with Oracle Database,
17.2.5
using,
17.2
using EXTPROC,
17.2.2.2
writing,
17.2.3
external roles
administering,
11.1
,
11.2
authorization on client computer,
11.2.4.2
authorization on Oracle database server,
11.2.4.1
creating,
11.1.9
creating manually,
11.2.4
external users
administering,
11.1
creating,
11.1.7
EXTPROC agent
authentication using CREATE LIBRARY extension
CREDENTIAL clause,
17.2.5
DIRECTORY object,
17.2.5
example,
17.2.3
explained,
17.2.2.1
responsibilities,
17.2.2.2
F
failure to modify ownership, group, and permission of open files,
D.3
features supporting large user population
Oracle Database Shared Server Process,
1.2.1
Oracle Net multiplexing and connection pooling,
1.2.1
Oracle RAC,
1.2.1
file I/O enhancements,
1.1.4
file permissions,
5.4.1
,
5.4.5
files
maximum number for each database,
15.7
maximum size possible,
15.7
sample init.ora,
15.2
trace,
7.3
finding information on application development for Windows,
17.1
FSEEK line terminators,
17.5
H
hiding password file
using command prompt,
6.5.1
using Windows Explorer,
6.5.1
I
ImagePath parameter,
B.2.1
Import Wizard,
2.1.2
importing
databases,
4.3.8
parameter mode,
4.3.8
preferred tools,
2.1.2
initialization parameter file
defined,
15.1
displaying values,
15.5
editing,
15.1.2
location,
15.1.1
operating system specific,
15.4
unmodifiable,
15.6
using Advanced Replication Support,
5.9.2
initialization parameters
OS_ROLES,
10.3
path in registry,
16.3.1.5
instances
modifying,
4.4.4
Oracle Database,
1.1.3
running multiple instances,
6.4
integration with Windows
Oracle Fail Safe,
1.3.3
Oracle PKI,
1.3.1
Oracle Services for MTS,
1.3.2
L
large page support
enabling,
8.2.2
overview,
8.2
running as user,
8.2
listener requirements,
B.3
LOCAL networking parameter,
B.4.1
M
manually migrating external operating system users,
11.2.5
MAXDATAFILES,
4.3.3
maximum file size of control files,
15.7
memory usage,
8.4
Microsoft Active Directory,
14.1.1
Microsoft Certificate Services,
13.2.2
Microsoft Certificate Stores,
13.2.1
Microsoft Management Console (MMC)
defined,
2.5.2
integration with Oracle Database,
2.5.2
starting,
2.2.5
migrating
Oracle Database 11
g
or earlier,
4.5.3
Oracle Database 12
c from Oracle Database 11
g
,
4.5.2
Migration Utility tool,
2.1.2
MMC.
See
Microsoft Management Console
modifying executable images,
1.1.3
monitoring
alert logs,
7.1
Event Viewer,
7.1
Management Pack,
7.1
trace files,
7.1
monitoring data dictionary tables,
5.9.3
multiple instances, running,
6.4
multithreaded agent architecture,
17.3
N
Named Pipes Protocol Adapter,
B.5.2
Named Pipes Protocol Adapter with an Oracle Names Server,
B.5.2
naming conventions for multiple Oracle homes,
6.1.1
Net Service Objects security group,
14.6.1.3
networking parameters
LOCAL,
B.4.1
TNS_ADMIN,
B.4.2
USE_SHARED_SOCKET,
B.4.3
noarchiving mode
custom database,
6.7
NTFS file system permission setting,
5.4
NTLM (NT Lan Manager)
authenticating Windows domain users,
Preface
,
10.2
authenticating Windows local users,
Preface
,
10.2
deprecation,
Preface
,
10.2
O
ObjectName parameter,
B.2.1
OPER privileges,
11.2.2
operating system authentication
automatically enabling during installation,
10.4
connecting as SYSDBA without a password,
10.4
OSAUTH_PREFIX_DOMAIN parameter,
11.2.1.1
operating systems
audit trail,
2.5.1
authentication overview,
10.1
,
14.4
ORA_DBA local group,
10.4
Oracle Administration Assistant for Windows
adding a computer to the navigation tree,
11.1.2
adding Oracle home parameter,
16.6.2
connecting to a database,
11.1.5
creating a local database role,
11.1.8
creating an external operating system user,
11.1.7
creating an external role,
11.1.9
database connection issues,
11.1.5.1
deleting Oracle home parameter,
16.6.4
editing Oracle home parameter,
16.6.3
granting administrator privileges,
11.1.10
granting operator privileges,
11.1.11
managing remote computers,
11.1.1
saving a navigation tree configuration,
11.1.2
setting OS_AUTHENT_PREFIX,
11.1.6
starting,
2.2.3
,
16.6.1
using,
11.1
,
16.6
using the Oracle Home Configuration snap-in,
16.6
viewing authentication settings,
11.1.6
Oracle ASM Configuration Assistant (ASMCA),
2.2.2
Oracle ASM File Access Control
about,
1.1.2
managing,
1.1.2.1
,
1.1.2.2
,
1.1.2.3
Oracle Automatic Storage Management Configuration Assistant (ASMCA),
2.2.3
Oracle Automatic Storage Management (Oracle ASM)
about,
1.1.1
configuring disks,
A.2
Oracle Database
connecting remotely,
6.6
connecting remotely using SYSDBA privileges,
6.6.1
connecting to,
6.2
password encryption,
6.6.2
shutting down,
6.2
,
6.3
specifications,
15.7
starting,
6.2
verifying remotely,
6.6.2
Oracle Database Configuration Assistant (DBCA),
2.2.2
preferred tools,
2.1.2
registering a database object in a directory server,
14.2.6
starting,
2.2.3
Oracle Database services
auto-starting,
6.1.4
using Control Panel,
6.1.4
using Oracle Administration Assistant,
6.1.4
naming conventions for multiple Oracle homes,
6.1.1
Oracle VSS Writer
command-line syntaxes,
9.2
installing and uninstalling,
9.2
integrating with third-party requester applications,
9.5
,
9.5.1
,
9.5.2
options,
9.2
privileges
SeBackupPrivilege,
C.1.2
SeBatchLogonRight,
C.1.2
SeIncreaseBasePriorityPrivilege,
C.1.2
SeIncreaseQuotaPrivilege,
C.1.2
SeLockMemoryPrivilege,
8.2.1
,
C.1.2
run under
LocalService Account,
3
NetworkService Account,
3
Windows User Account,
3
shutting down a database,
6.3
starting,
6.1.2
using command prompt,
6.1.2
using Control Panel,
6.1.2
using Oracle Administration Assistant,
6.1.2
stopping,
6.1.3
using command prompt,
6.1.3
using Control Panel,
6.1.3
using Oracle Administration Assistant,
6.1.3
Oracle Database Upgrade Assistant (DBUA),
2.2.2
Oracle Enterprise Manager Console
preferred tools,
2.1.2
Oracle Enterprise Manager Database Management Pack,
7.1
Oracle Home Configuration snap-in,
16.6
,
16.6
Oracle Home User
comparison with Linux/UNIX Oracle User,
E.13
permissions,
5.4.1.1
Oracle Home User Control tool
command-line tool,
2.3
updates password of Oracle Home User,
2.3
Oracle Installation User
permissions,
5.4.1.1
Oracle Locale Builder,
2.2.3
Oracle Managed Files,
4.3.6
Oracle Multimedia
about,
5.6
configuring,
5.6.1
enabling Oracle Database to store, manage, and retrieve images,
5.6
Oracle Net Configuration Assistant
configuring Oracle software with a directory server,
14.2.2
,
14.2.6
creating Oracle Context,
14.3
creating Oracle schema object,
14.3
Oracle Net Configuration Assistant (NetCA),
2.2.2
,
2.2.3
Oracle Net directory naming,
14.5
Oracle Net mutiplexing and connection pooling,
1.2.1
Oracle Net Services
advanced configuration,
B.5
running CMADMIN,
B.3.1
running CMAN,
B.3.1
running Oracle Listener,
B.3.1
Oracle Public Key Infrastructure,
13.1
Oracle RAC,
1.2.1
Oracle Real Application Clusters
allows multiple server computers to access the same database files,
1.2.1
increases the number of user connections,
1.2.1
registry values,
16.4
Oracle Scheduler,
5.5
Oracle Spatial and Graph configuring,
5.8
Oracle Text
about,
5.7
configuring,
5.7
,
5.7
enables text queries through SQL and PL/SQL,
5.7
Oracle VSS writer
command-line syntaxes,
9.2
component-based backup,
9.3
,
9.3.1
installing and uninstalling,
9.2
integrating with third-party requester applications,
9.5
options,
9.2
volume-based backup,
9.3
Oracle VSS Writer
shadow copies
component-based,
9.1.3.1
volume-based,
9.1.3.2
Oracle Wallet Manager
about,
12.3.1
starting,
2.2.3
Oracle Wallets,
12.3
creating,
4.3.4.2
for Oracle Database Services,
4.3.4.2
storing in the registry,
12.3
storing private keys and trust points,
12.1
ORACLE_
SID
,
4.3.9
,
6.4
OracleDBCreator security group,
14.6.1.1
Oracle
HOMENAME
ClientCache,
B.2.1
Oracle
HOMENAME
CMAdmin,
B.2.1
Oracle
HOMENAME
CMan,
B.2.1
Oracle
HOMENAME
TNSListener,
B.2.1
Oracle
HOMENAME
TNSListener service,
B.5.2
OracleNetAdmins security group,
14.6.1.2
ORADIM
accepts operating system user name and password if no /ospass option after osusr,
4.4
,
C.1
command syntax errors,
D.5
creates Oracle Database service,
4.4
,
C.1
creates Oracle Scheduler service,
4.4
,
C.1
creates Oracle VSS Writer service,
4.4
,
C.1
moving or copying password files,
6.5
preferred tools,
2.1.2
starting,
2.2.4
using operating system user name and password,
2.1.2
ORAPWD
creating password files,
6.5
starting,
2.2.4
OS_AUTHENT_PREFIX parameter
case-insensitive,
11.2.1.1
defined,
11.1.6
using,
11.2.1.1
OS_ROLES parameter
defined,
11.1.6
using with external roles,
10.3
OSAUTH_PREFIX_DOMAIN,
11.1.1
,
11.2.1.1
OSAUTH_PREFIX_DOMAIN parameter,
11.2.1.1
P
parameter mode
Export,
4.3.1
,
4.3.1
Import,
4.3.8
parameters
AUDIT_FILE_DEST,
7.2.3
DisplayName,
16.3.3.1
,
B.2.1
ImagePath,
16.3.3.1
,
B.2.1
INST_LOC,
16.3.2.1
LOCAL,
B.4.1
,
B.4.1
MSHELP_TOOLS,
16.3.1.1
NLS_LANG and Other Globalization Parameters,
16.3.1.2
ObjectName,
16.3.3.1
,
B.2.1
ORA_AFFINITY,
16.3.1.10
ORA_CWD,
16.3.1.3
ORA_HOMENAME,
16.3.1.16
ORA_
SID
_AUTOSTART,
16.3.1.4
ORA_
SID
_PFILE,
16.3.1.5
ORA_
SID
_SHUTDOWN,
16.3.1.6
ORA_TZFILE,
16.3.1.9
ORACLE_BASE,
16.3.1.11
ORACLE_GROUP_NAME,
16.3.1.12
ORACLE_HOME,
16.3.1.13
ORACLE_HOME_KEY,
16.3.1.14
ORACLE_HOME_USER,
16.3.1.15
ORACLE_PRIORITY,
16.3.1.17
ORACLE_
SID
,
4.3.9
,
6.4
,
16.3.1.18
OS_AUTHENT_PREFIX,
11.1.6
OS_ROLES,
11.1.6
OSAUTH_PREFIX_DOMAIN,
11.1.1
,
11.2.1.1
,
16.3.1.19
RDBMS_ARCHIVE,
16.3.1.20
RDBMS_CONTROL,
16.3.1.21
REMOTE_LOGIN_PASSWORDFILE,
6.5
SGA_MAX_SIZE,
15.3
SQLPATH,
16.3.1.22
TNS_ADMIN,
B.4.2
USE_SHARED_SOCKET,
B.4.3
partitions
extended,
A.1
logical partition,
A.1.2
physical disk,
A.1.1
raw,
A.1
password
encryption,
6.6.2
not needed with SYSDBA,
10.4
utility,
6.5
password file
authenticating database administrators,
6.5
creating,
6.5
hiding,
6.5
using command prompt,
6.5.1
using Windows Explorer,
6.5.1
viewing
using command prompt,
6.5.1
using Windows Explorer,
6.5.1
permissions
Administrators,
5.4.1.1
Oracle Home User,
5.4.1.1
Oracle Installation User,
5.4.1.1
SYSTEM,
5.4.1.1
PhysicalDrive,
A.1.1
PL/SQL Embedded Gateway,
17.1.6
postinstallation
setting NTFS file system permissions,
5.4
setting NTFS File System security,
5.4.4
setting permissions for Windows Registry Entries,
5.4.2
setting permissions for Windows Service Entries,
5.4.3
setting Windows registry security,
5.4.5
preferred tools
Backup Wizard,
2.1.2
Load Wizard,
2.1.2
OCOPY,
2.1.2
Recovery Manager,
2.1.2
Recovery Wizard,
2.1.2
SQL*Loader,
2.1.2
privileges,
2.2.2
Process Explode,
2.6
Process Viewer,
2.6
PWD
SID
.ORA file,
6.5
Q
querying background processes,
1.1.3
R
raw partition
considerations,
A.1.3
defined,
A.1
logical partition,
A.1.2
overview,
A.1
physical disk,
A.1.1
Recovery Manager
preferred tools,
2.1.2
starting,
2.2.4
registering an external procedure,
17.2.5
registry
adding parameters,
16.5.2
and Oracle Real Application Clusters
configuration parameters, defined,
16.1
DisplayName,
16.3.3.1
,
B.2.1
editor,
16.2
editor, starting,
2.2.5
ImagePath,
16.3.3.1
,
B.2.1
INST_LOC,
16.3.2.1
keys, defined,
16.2
managing parameters,
16.6
modifying values,
16.5
MSHELP_TOOLS,
16.3.1.1
NLS_LANG and Other Globalization Parameters,
16.3.1.2
ObjectName,
16.3.3.1
,
B.2.1
ORA_AFFINITY,
16.3.1.10
ORA_CWD,
16.3.1.3
ORA_HOMENAME,
16.3.1.16
ORA_
SID
_AUTOSTART,
16.3.1.4
ORA_
SID
_PFILE,
16.3.1.5
ORA_
SID
_SHUTDOWN,
16.3.1.6
ORA_
SID
_SHUTDOWN_TIMEOUT,
16.3.1.7
ORA_
SID
_SHUTDOWNTYPE,
16.3.1.8
ORA_TZFILE,
16.3.1.9
ORACLE_BASE,
16.3.1.11
ORACLE_GROUP_NAME,
16.3.1.12
ORACLE_HOME,
16.3.1.13
ORACLE_HOME_KEY,
16.3.1.14
ORACLE_HOME_USER,
16.3.1.15
ORACLE_PRIORITY,
16.3.1.17
ORACLE_
SID
,
16.3.1.18
Oracle
HOMENAME
ClientCache,
B.2.1
Oracle
HOMENAME
CMAdmin,
B.2.1
Oracle
HOMENAME
CMan,
B.2.1
Oracle
HOMENAME
TNSListener,
B.2.1
OSAUTH_PREFIX_DOMAIN,
11.2.1.1
,
16.3.1.19
RDBMS_ARCHIVE,
16.3.1.20
RDBMS_CONTROL,
16.3.1.21
REG_BINARY,
16.2
,
16.5.2
REG_DWORD,
16.2
,
16.5.2
REG_EXPAND_SZ,
16.2
,
16.5.2
REG_MULTI_SZ,
16.2
,
16.5.2
REG_QWORD,
16.2
,
16.5.2
REG_SZ,
16.2
,
16.5.2
REGEDT32,
16.5.1
,
16.5.2
setting security,
5.4.5
SQLPATH,
16.3.1.22
update ORACLE_SID,
4.3.9
registry keys,
16.2
registry parameters for storing an Oracle Wallet,
12.3
remote computers
managing with Oracle Administration Assistant for Windows,
11.1.1
REMOTE_LOGIN_PASSWORDFILE,
6.5
resetting passwords for default accounts,
5.2
resolving database connection issue
OEM failure,
4.4
OID failure,
4.4
startup mode set to automatic,
4.4
restoring and recovering a database
about,
9.4
archivelog mode,
9.4
noarchivelog mode,
9.4
Restoring and Recovering a Database
archivelog mode
performing disaster recovery,
9.4.1.5
recovering all tablespaces,
9.4.1.4
recovering from the loss of all multiplexed control files,
9.4.1.2
recovering tablespaces or datafiles,
9.4.1.3
restoring server parameter file,
9.4.1.1
noarchivelog mode
restoring component-based backups,
9.4.2
restoring volume-based backups,
9.4.2
role authorization
description,
10.3
method enhancements,
10.3
roles
creating,
11.1.9
creating a local database role,
11.1.8
running SYSASM
authentication on Oracle database server,
11.2.2.1
running SYSDBA
authentication on Oracle database server,
11.2.2.1
running SYSOPER
authentication on Oracle database server,
11.2.2.1
running tools with Windows User Account Control,
2.2.2
running windows services,
C.1.1
S
security groups
Net Service Objects,
14.6.1
OracleDBCreators,
14.6.1
OracleNetAdmins,
14.6.1
services,
6.1.1
auto-starting,
6.1.4
,
6.1.4
,
6.1.4
creating,
4.3.4
shutting down a database,
6.3
starting,
4.3.4
,
6.1.2
,
6.1.2
,
6.1.2
,
6.1.2
stopping,
6.1.3
,
6.1.3
,
6.1.3
,
6.1.3
SET ORACLE_SID=SID,
6.4
SET ROLE command,
11.2.4.1
setting file permissions
Database Upgrade Assistant,
5.4.1
Oracle Database Configuration Assistant,
5.4.1
Oracle Universal Installer,
5.4.1
setting registry parameters
for starting Oracle Database,
6.3
for stopping Oracle Database,
6.3
optional
ORA_
SID
_SHUTDOWN_TIMEOUT,
6.3
,
16.3.1.7
ORA_
SID
_SHUTDOWNTYPE,
6.3
,
16.3.1.8
ORA_SHUTDOWN,
6.3
ORA_SID_AUTOSTART,
6.3
ORA_SID_PFILE,
6.3
ORA_SID_SHUTDOWN,
6.3
Shared Server Process,
1.2.1
shutting down databases,
6.2
,
6.3
SQL*Loader
control file conventions,
2.4.2
preferred tools,
2.1.2
starting,
2.2.4
SQL*Plus
connecting to a database through Active Directory,
14.2.4
preferred tools,
2.1.2
shutting down the database,
6.2
starting,
2.2.3
,
2.2.4
,
6.2
starting the database,
6.2
SQL*Plus Worksheet
preferred tools,
2.1.2
sqlnet.ora file
and Windows native authentication,
11.2.2.2
,
11.2.4.1
location of,
11.2.2.2
,
11.2.4.1
starting
Oracle Database,
6.3
Oracle Database services,
6.1.2
using command prompt,
6.1.2
using Control Panel,
6.1.2
,
6.3
using Oracle Administration Assistant,
6.1.2
SQL*Plus,
6.2
TKPROF,
2.2.4
starting an Oracle Database instance,
4.3.5
starting Oracle Database,
6.3
stopping
Oracle Database,
6.3
Oracle Database services,
6.1.3
using command prompt,
6.1.3
using Control Panel,
6.1.3
,
6.3
using Oracle Administration Assistant,
6.1.3
stopping Oracle Database,
6.3
storing an Oracle Wallet,
12.3
SYSDBA privileges
connecting without a password,
10.4
for a single database on a computer,
11.1.10
for all databases on a computer,
11.1.3
member of
ORA_DBA,
10.4
ORA_HOMENAME_DBA,
10.4
SYSOPER privileges
for a single database on a computer,
11.1.11
for all databases on a computer,
11.1.4
SYSTEM user
permissions,
5.4.1.1
T
Task List,
2.6
Task Manager
starting,
2.2.5
using,
2.5.4
testing connectivity
from client computers,
14.5.1
from Microsoft tools,
14.5.2
thread-based architecture,
1.1.3
threads
and Microsoft Management Console,
2.5.2
and multiple Oracle Database instances,
1.1.3
and ORASTACK,
1.1.3
and shared server process,
1.2.1
and UNIX processes,
E.14
defined,
1.1.3
optional and required,
1.1.3
process errors,
D.4
processor affinity,
16.3.1.10
scheduling priority,
16.3.1.17
TNS_ADMIN networking parameter,
B.4.2
tools, starting
asmtool,
2.2.4
asmtoolg,
2.2.4
Data Pump Export,
2.2.4
Data Pump Import,
2.2.4
Database Configuration Assistant,
2.2.3
DBVERIFY,
2.2.4
Event Viewer,
2.2.5
Export,
2.2.4
Microsoft Management Console,
2.2.5
Microsoft ODBC Administration,
2.2.3
Oracle Administration Assistant for Windows,
2.2.3
Oracle Automatic Storage Management Configuration Assistant (ASMCA),
2.2.3
Oracle Directory Manager,
2.2.3
Oracle Locale Builder,
2.2.3
Oracle Net Configuration Assistant,
2.2.3
Oracle Net Manager,
2.2.3
Oracle Wallet Manager,
2.2.3
ORADIM,
2.2.4
ORAPWD,
2.2.4
Recovery Manager,
2.2.4
Registry Editor,
2.2.5
SQL*Loader,
2.2.4
SQL*Plus,
2.2.3
,
2.2.4
Task Manager,
2.2.5
TKPROF,
2.2.4
trace files
for monitoring a database,
7.1
using,
7.3
troubleshooting
ORA-12560 error,
D.6
ORA-28575 error,
D.6
TNS-12203 error,
D.6
Windows firewall exceptions,
5.1.3
tuning Windows Server operating system,
8.1
U
UNIX and Windows, Oracle Database differences,
E
USE_SHARED_SOCKET networking parameter,
B.4.3
user authentication
description,
10.3
enhancement methods,
10.3
user group privileges
ORA_ASMADMIN,
11.2.2
ORA_ASMDBA,
11.2.2
ORA_ASMOPER,
11.2.2
ORA_DBA,
11.2.2
ORA_HOMENAME_DBA,
11.2.2
ORA_HOMENAME_OPER,
11.2.2
ORA_HOMENAME_SYSBACKUP,
11.2.2
ORA_HOMENAME_SYSDG,
11.2.2
ORA_HOMENAME_SYSKM,
11.2.2
ORA_OPER,
11.2.2
user replacement failure on Windows,
D.2
using Oracle Administration Assistant
start Oracle Database,
6.3
stop Oracle Database,
6.3
using ORADIM
creating an Oracle Database instance,
4.4.1
modifying an instance,
4.4.4
starting an Oracle Database instance,
4.4.2
starting services,
4.4.2
using UTL_FILE,
17.5
using VSS
database backup and recovery
concepts,
9.1.3
overview,
9.1
purpose,
9.1.1
scope,
9.1.2
steps,
9.1.4
V
viewing password file
using command prompt,
6.5.1
using Windows Explorer,
6.5.1
Volume Shadow Copy Service (VSS),
9.1
,
9.1
,
9.1.1
VSS
Oracle VSS Writer,
9.1.3
backup,
9.1.3.3
VSS provider,
9.1.3
VSS requester,
9.1.3
VSS.
See
Volume Shadow Copy Service
W
Wallet Resource Locator,
13.2.3
Windows
and UNIX, Oracle Database differences,
E
diagnostic and tuning utilities,
2.6
Windows 32-bit operating system features
large user populations,
1.2.1
Oracle PKI,
1.3.1
Windows domains
administering external users and roles,
11.1
,
11.2
basic features,
10.3
Windows firewall exceptions
configuring,
5.1.1.1
troubleshooting,
5.1.3
Windows firewall postinstallation,
5.1.2
Windows local groups,
10.4
Windows local groups with DBA privileges,
11.2.4.1
Windows native authentication
benefits,
10.1
,
14.4
enhancements,
10.3
installation of,
10.1
,
14.4
methods and use of,
10.1
,
14.4
overview,
10.1
,
14.4
role authorization enhancements,
10.3
setting the sqlnet.ora file,
11.2.2.2
,
11.2.4.1
user and role requirements,
10.3
user authentication enhancements,
10.3
Windows tuning
applying latest service packs,
8.9
closing unnecessary foreground applications,
8.12
configuring server to be an application server,
8.4
disabling unnecessary services,
8.5
foreground applications,
8.3
multiple striped volumes for sequential and random access,
8.10.1
multiplex windows server virtual memory paging file,
8.11
overview,
8.1
removing unused network protocols,
8.6
resetting the network protocol bind order,
8.7
setting the order of multiple network interface cards,
8.8
using hardware and operating system striping,
8.10
Windows utility tool
ORADIM,
4.4
Windows-specific
audit trail,
7.2.2
initialization parameter file,
15.1
parameter file location,
15.1.1
parameter filename and location,
15.1
password filename and location,
6.5
role syntax,
11.2.4.1
trace file names,
7.3
X
X.500 naming convention,
14.5
Scripting on this page enhances content navigation, but does not change the content in any way.