Index

A

Access Control Lists (ACL)
- adding and deleting security group members 1
- available security groups 1
- setting NTFS ACLs manually 1
- setting on Net Service directory objects 1
accessing Active Directory 1
ACLs
- adding and deleting security group members 1
- available security groups 1
- setting NTFS ACLs manually 1
- setting on Net Service directory objects 1
Active Directory
- adding and deleting security group members 1
- automatic discovery of directory servers 1
- how Oracle directory objects appear 1
- integration with Oracle objects 1
- managing Access Control Lists 1
- managing security groups 1
- testing connectivity with SQL*Plus 1
- testing database connectivity 1
- user interface extensions 1
adding and deleting users
- Net Service Objects 1
- OracleDBCreators 1
- OracleNetAdmins 1
adding executables 1
- firewall exceptions for Oracle Clusterware and Oracle ASM 1
- firewall exceptions for Oracle Database 1
- firewall exceptions for Oracle Database Examples 1
- firewall exceptions for Oracle Gateways 1
- firewall exceptions for other Oracle Products 1
administering external roles 1
administration tools prompting for password
- Domain User Account 1
- Local User Account 1
- password not stored in Oracle Wallet 1
administrator
- starting ASMCA tool
  - member of ORA_ASMADMIN 1
- starting DBCA tool
  - member of ORA_DBA 1
- starting DBUA tool
  - member of ORA_ASMADMIN 1
Administrators group
- running configuration tools 1
advanced replication
- about 1
- configuring
  - adding and modifying initialization parameters 1
  - checking tablespace 1
  - monitoring data dictionary tables 1
alert logs
- monitoring a database 1
- using 1
archiving mode
- controlling 1, 2
- custom database 1, 2
- starter database 1, 2
archiving procedures
- for redo log files 1, 2
archiving redo log files 1, 2
AUDIT_FILE_DEST 1, 2
audit trail
- managing 1
- operating system 1
Authenticated Users 1
- permissions for Oracle Database Client Oracle home 1
- permissions for Oracle Database Oracle home 1
- permissions for Oracle Grid Infrastructure Oracle home 1
Authenticated Users group 1
authentication
- automatically enabling during installation 1
- enhancements 1
- OSAUTH_PREFIX_DOMAIN parameter 1
- overview 1, 2
- using a password file 1
- using Windows native authentication methods 1
- using Windows native methods 1
auto-starting Oracle Database services 1
- using Control Panel 1
- using Oracle Administration Assistant 1

B

backing up database
- 32-bit Oracle Database 1
- about 1, 2
- in archivelog mode
  - component-based 1, 2, 3
  - volume-based 1, 2, 3
- in noarchivelog mode
  - component-based 1
  - volume-based 1
- new database 1
blocks for each file, maximum 1

C

command-line tool
- ORADIM 1
commands
- CREATE DATABASE 1
- CREATE LIBRARY 1
- NET START 1
- REGEDT32 1
- SET INSTANCE 1
- SET ROLE 1
configuration parameters
- defined 1
- LOCAL 1
- registry, defined 1
- TNS_ADMIN 1
- USE_SHARED_SOCKET 1
configuring
- advanced replication 1
  - adding and modifying initialization parameters 1
  - monitoring data dictionary tables 1
- Named Pipes Protocol Adapter 1
- Oracle Multimedia 1
- Oracle Spatial and Graph 1
  - automatically 1
- Oracle Text 1
- Windows firewall exceptions 1
- Windows firewall postinstallation 1
configuring Oracle Net Services for external procedures 1
configuring Oracle Text
- using Database Configuration Assistant 1
- using DBCA 1
CONNECT /AS SYSDBA
- connecting without a password 1
- using 1
connecting
- LOCAL parameter 1
- to active directory using Windows login credentials 1
- to a database 1
CREATE LIBRARY command 1
creating
- an Oracle Context 1
- external operating system users 1
- external roles manually 1
- ORACLE_SID parameter 1
- Oracle Schema objects 1
custom database
- archiving mode 1, 2
- noarchiving mode 1, 2

D

database administrator (DBA) privileges
- for ASM 1
- for databases 1
database connection error messages 1
database monitoring
- with alert logs 1
- with trace files 1
database operator privileges
- for databases 1
databases
- backing up 1
- connecting to 1
- creating manually 1
- deleting 1
- exporting 1
- importing 1
- monitoring 1
- naming conventions 1
- password encryption 1
- shutting down 1, 2
- starting 1
database tools
- operating system compatibility 1
- running with administrator privileges 1
- running with Windows User Account Control 1
- starting ASMCA 1
- starting DBCA 1, 2
- starting from the command line 1
- starting from the Start Menu 1
- starting in multiple Oracle Homes 1
- starting Microsoft ODBC Administration 1
- starting NetCA 1, 2
- starting Oracle Directory Manager 1
- starting Oracle Net Manager 1
- starting Oracle Wallet Manager 1
data dictionary tables 1
Data Pump Export, starting 1
Data Pump Import, starting 1
DBCA prompts for password
- Domain User Account 1
- Local User Account 1
- password not stored in Oracle Wallet 1
debugging external procedures 1
deleting database files 1
developing applications for Windows 1
directory naming software requirements 1
directory servers
- automatic discovery of directory servers 1
- features integrated with Oracle Database 11g 1
- how Oracle directory objects display in Active Directory 1
- managing Access Control Lists 1
- user interface extensions 1
DLLs
- compared to UNIX shared libraries 1
- Oracle Real Application Clusters 1
dnfs_batch_size parameter
- default value is 4096 1
- recommended setting 1
- to control the number of queued asynchronous I/Os 1
duplicating a database
- creating a nonstandby database from shadow copies 1
- creating a standby database from shadow copies 1

E

encrypting, database passwords 1
enhanced security 1, 2
enhancing Oracle directory object type descriptions 1
error messages
- DIM-00000 to DIM-00228 1
- ORA-01102 1
- ORA-09275 1
- ORA-12560 1
- ORA-15252 to ORA-15266 1
- ORA-15301 to ORA-15302 1
- OSD-04000 to OSD-04099 1
- OSD-04100 to OSD-04199 1
- OSD-04200 to OSD-04299 1
- OSD-04300 to OSD-04399 1
- OSD-04400 to OSD-04499 1
- OSD-04500 to OSD-04599 1
Event Viewer
- defined 1
- for monitoring a database 1
- integration with Oracle Database 1
- logging operating system audit trail 1
- managing 1
- reading 1
- starting 1
EXECUTE privileges, on a PL/SQL library 1
exporting
- databases 1
- interactive mode 1
- parameter mode 1
- preferred tools 1
Export parameter mode 1
Export Wizard 1
extended partition 1
EXTERNAL clause 1
external operating system users
- administering 1
- authentication 1
- authentication on client computer 1
- creating 1
- migrating manually 1
external procedures
- advantages 1
- creating 1
- creating a PL/SQL library 1
- debugging 1
- executing 1
- EXTERNAL clause 1
- granting EXECUTE privileges 1
- registering with Oracle Database 1
- using 1
- using EXTPROC 1
- writing 1
external roles
- administering 1
- authorization on client computer 1
- authorization on Oracle database server 1
- creating manually 1
EXTPROC agent
- authentication using CREATE LIBRARY extension
  - CREDENTIAL clause 1
  - DIRECTORY object 1
- example 1
- explained 1
- responsibilities 1

F

failure to modify ownership, group, and permission of open files 1
features supporting large user population
- Oracle Database Shared Server Process 1
- Oracle Net multiplexing and connection pooling 1
- Oracle RAC 1
file I/O enhancements 1
file permissions 1, 2
files
- maximum number for each database 1
- maximum size possible 1
- sample init.ora 1
- trace 1
finding information on application development for Windows 1
FSEEK line terminators 1

H

hiding password file
- using command prompt 1
- using Windows Explorer 1

I

importing
- databases 1
- parameter mode 1
- preferred tools 1
Import Wizard 1
initialization parameter file
- defined 1
- displaying values 1
- editing 1
- location 1
- operating system specific 1
- unmodifiable 1
- using Advanced Replication Support 1
initialization parameters
- OS_ROLES 1
- path in registry 1
instances
- modifying 1
- Oracle Database 1
- running multiple instances 1
integration with Windows
- Oracle Fail Safe 1
- Oracle PKI 1
- Oracle Services for MTS 1

L

large page support
- enabling 1
- overview 1
- running as user 1
listener requirements 1
LOCAL networking parameter 1

M

manually migrating external operating system users 1
maximum file size of control files 1
memory usage 1
Microsoft Active Directory 1
Microsoft Certificate Services 1
Microsoft Certificate Stores 1
Microsoft Management Console (MMC)
- defined 1
- integration with Oracle Database 1
- starting 1
migrating
- Oracle Database 11g or earlier 1
- Oracle Database 12c from Oracle Database 11g 1
Migration Utility tool 1
MMC
- See: Microsoft Management Console
modifying executable images 1
monitoring
- alert logs 1
- Event Viewer 1
- Management Pack 1
- trace files 1
monitoring data dictionary tables 1
multiple instances, running 1
multithreaded agent architecture 1

N

Named Pipes Protocol Adapter 1
Named Pipes Protocol Adapter with an Oracle Names Server 1
naming conventions for multiple Oracle homes 1
Net Service Objects security group 1
networking parameters
- LOCAL 1
- TNS_ADMIN 1
- USE_SHARED_SOCKET 1
noarchiving mode
- custom database 1, 2
NTFS file system permission setting 1
NTLM (NT Lan Manager)
- authenticating Windows domain users 1
- authenticating Windows local users 1
- deprecation 1
NTS
- See: Windows native authentication

O

operating system authentication
- automatically enabling during installation 1
- connecting as SYSDBA without a password 1
- OSAUTH_PREFIX_DOMAIN parameter 1
operating systems
- audit trail 1
- authentication overview 1, 2
OPER privileges 1
ORA_DBA local group 1
ORACLE_SID 1, 2
Oracle ASM Configuration Assistant (ASMCA) 1
Oracle ASM File Access Control
- managing 1, 2, 3
Oracle Automatic Storage Management (Oracle ASM)
- about 1
- configuring disks 1
Oracle Automatic Storage Management Configuration Assistant (ASMCA) 1
Oracle Database
- connecting remotely using SYSDBA privileges 1
- connecting to 1
- password encryption 1
- shutting down 1, 2
- specifications 1
- starting 1
- verifying remotely 1
Oracle Database Configuration Assistant (DBCA) 1
- preferred tools 1
- registering a database object in a directory server 1
- starting 1
Oracle Database services
- auto-starting 1
  - using Control Panel 1
  - using Oracle Administration Assistant 1
- naming conventions for multiple Oracle homes 1
- Oracle VSS Writer
  - command-line syntaxes 1
  - installing and uninstalling 1
  - integrating with third-party requester applications 1, 2
  - options 1
- privileges
  - SeBackupPrivilege 1
  - SeBatchLogonRight 1
  - SeIncreaseBasePriorityPrivilege 1
  - SeLockMemoryPrivilege 1
- run under
  - LocalService Account 1
  - NetworkService Account 1
  - Windows User Account 1
- shutting down a database 1
- starting 1
  - using command prompt 1
  - using Control Panel 1
  - using Oracle Administration Assistant 1
- stopping 1
  - using command prompt 1
  - using Control Panel 1
  - using Oracle Administration Assistant 1
Oracle Database Upgrade Assistant (DBUA) 1
OracleDBCreator security group 1
Oracle Enterprise Manager Console
- preferred tools 1
Oracle Enterprise Manager Database Management Pack 1
OracleHOMENAMEClientCache 1
OracleHOMENAMECMAdmin 1
OracleHOMENAMECMan 1
OracleHOMENAMETNSListener 1
OracleHOMENAMETNSListener service 1
Oracle Home User
- comparison with Linux/UNIX Oracle User 1
- permissions 1
Oracle Home User Control tool
- command-line tool 1
- updates password of Oracle Home User 1
Oracle Installation User
- permissions 1
Oracle Locale Builder 1
Oracle Managed Files 1
Oracle Multimedia
- about 1
- configuring 1
- enabling Oracle Database to store, manage, and retrieve images 1
OracleNetAdmins security group 1
Oracle Net Configuration Assistant
- configuring Oracle software with a directory server 1, 2
- creating Oracle Context 1
- creating Oracle schema object 1
Oracle Net Configuration Assistant (NetCA) 1, 2
Oracle Net mutiplexing and connection pooling 1
Oracle Net Services
- advanced configuration 1
- running CMADMIN 1
- running CMAN 1
- running Oracle Listener 1
Oracle Public Key Infrastructure 1
Oracle RAC 1
Oracle Real Application Clusters
- See: Oracle RAC
- allows multiple server computers to access the same database files 1
- increases the number of user connections 1
- registry values 1
Oracle Scheduler 1
Oracle Spatial and Graph configuring 1
Oracle Text
- about 1
- configuring 1
- enables text queries through SQL and PL/SQL 1
Oracle VSS writer
- command-line syntaxes 1
- component-based backup 1, 2, 3
- installing and uninstalling 1
- options 1
- volume-based backup 1, 2
Oracle VSS Writer
- shadow copies
  - component-based 1
  - volume-based 1
Oracle Wallet Manager
- about 1
- starting 1
Oracle Wallets 1
- creating 1
- for Oracle Database Services 1
- storing in the registry 1
- storing private keys and trust points 1
ORADIM
- accepts operating system user name and password if no /ospass option after osusr 1, 2
- command syntax errors 1
- creates Oracle Database service 1, 2
- creates Oracle Scheduler service 1, 2
- creates Oracle VSS Writer service 1, 2
- moving or copying password files 1
- preferred tools 1
- starting 1
- using operating system user name and password 1
ORAPWD
- creating password files 1
- starting 1
OS_AUTHENT_PREFIX parameter
- case-insensitive 1
- using 1
OS_ROLES parameter
- using with external roles 1
OSAUTH_PREFIX_DOMAIN 1
OSAUTH_PREFIX_DOMAIN parameter 1

P

parameter mode
- Export 1
- Import 1
parameters
- AUDIT_FILE_DEST 1
- INST_LOC 1
- LOCAL 1
- MSHELP_TOOLS 1
- NLS_LANG and Other Globalization Parameters 1
- ORA_AFFINITY 1
- ORA_CWD 1
- ORA_HOMENAME 1
- ORA_SID_AUTOSTART 1
- ORA_SID_PFILE 1
- ORA_SID_SHUTDOWN 1
- ORA_TZFILE 1
- ORACLE_BASE 1
- ORACLE_GROUP_NAME 1
- ORACLE_HOME 1
- ORACLE_HOME_KEY 1
- ORACLE_HOME_USER 1
- ORACLE_PRIORITY 1
- ORACLE_SID 1, 2, 3
- OSAUTH_PREFIX_DOMAIN 1, 2
- RDBMS_ARCHIVE 1
- RDBMS_CONTROL 1
- REMOTE_LOGIN_PASSWORDFILE 1
- SGA_MAX_SIZE 1
- SQLPATH 1
- TNS_ADMIN 1
- USE_SHARED_SOCKET 1
partitions
- extended 1
- logical partition 1
- physical disk 1
- raw 1
password
- encryption 1
- not needed with SYSDBA 1
- utility 1
password file
- authenticating database administrators 1
- creating 1
- hiding 1
  - using command prompt 1
  - using Windows Explorer 1
- viewing
  - using command prompt 1
  - using Windows Explorer 1
permissions
- Administrators 1
- Oracle Home User 1
- Oracle Installation User 1
- SYSTEM 1
PhysicalDrive 1
PL/SQL Embedded Gateway 1
postinstallation
- setting NTFS file system permissions 1
- setting NTFS File System security 1
- setting permissions for Windows Registry Entries 1
- setting permissions for Windows Service Entries 1
- setting Windows registry security 1
preferred tools
- Backup Wizard 1
- Load Wizard 1
- OCOPY 1
- Recovery Manager 1
- Recovery Wizard 1
- SQL*Loader 1
privileges 1
PWDSID.ORA file 1

Q

querying background processes 1

R

raw partition
- considerations 1
- defined 1
- logical partition 1
- overview 1
- physical disk 1
Recovery Manager
- preferred tools 1
- starting 1
registering an external procedure 1
registry
- adding parameters 1
- and Oracle Real Application Clusters 1
- configuration parameters, defined 1
- editor 1
- editor, starting 1
- INST_LOC 1
- keys, defined 1
- modifying values 1
- MSHELP_TOOLS 1
- NLS_LANG and Other Globalization Parameters 1
- ORA_AFFINITY 1
- ORA_CWD 1
- ORA_HOMENAME 1
- ORA_SID_AUTOSTART 1
- ORA_SID_PFILE 1
- ORA_SID_SHUTDOWN 1
- ORA_SID_SHUTDOWN_TIMEOUT 1
- ORA_SID_SHUTDOWNTYPE 1
- ORA_TZFILE 1
- ORACLE_BASE 1
- ORACLE_GROUP_NAME 1
- ORACLE_HOME 1
- ORACLE_HOME_KEY 1
- ORACLE_HOME_USER 1
- ORACLE_PRIORITY 1
- ORACLE_SID 1
- OracleHOMENAMEClientCache 1
- OracleHOMENAMECMAdmin 1
- OracleHOMENAMECMan 1
- OracleHOMENAMETNSListener 1
- OSAUTH_PREFIX_DOMAIN 1, 2
- RDBMS_ARCHIVE 1
- RDBMS_CONTROL 1
- REG_BINARY 1, 2
- REG_DWORD 1, 2
- REG_EXPAND_SZ 1, 2
- REG_MULTI_SZ 1, 2
- REG_QWORD 1, 2
- REG_SZ 1, 2
- REGEDT32 1, 2
- setting security 1
- SQLPATH 1
- update ORACLE_SID 1
registry keys 1
registry parameters for storing an Oracle Wallet 1
REMOTE_LOGIN_PASSWORDFILE 1
resetting passwords for default accounts 1
resolving database connection issue
- OEM failure 1
- OID failure 1
- startup mode set to automatic 1
Restoring and Recovering a Database
- archivelog mode
  - performing disaster recovery 1
  - recovering all tablespaces 1
  - recovering from the loss of all multiplexed control files 1
  - recovering tablespaces or datafiles 1
  - restoring server parameter file 1
- noarchivelog mode
  - restoring component-based backups 1
  - restoring volume-based backups 1
role authorization
- description 1
- method enhancements 1
running SYSASM
- authentication on Oracle database server 1
running SYSDBA
- authentication on Oracle database server 1
running SYSOPER
- authentication on Oracle database server 1
running tools with Windows User Account Control 1
running windows services 1

S

services 1
- auto-starting 1
- shutting down a database 1
- starting 1
- stopping 1
SET ORACLE_SID=SID 1
SET ROLE command 1
setting file permissions
- Database Upgrade Assistant 1
- Oracle Database Configuration Assistant 1
- Oracle Universal Installer 1
setting registry parameters
- for starting Oracle Database 1
- for stopping Oracle Database 1
- optional
  - ORA_SID_SHUTDOWN_TIMEOUT 1, 2
  - ORA_SID_SHUTDOWNTYPE 1, 2
- ORA_SHUTDOWN 1
- ORA_SID_AUTOSTART 1
- ORA_SID_PFILE 1
- ORA_SID_SHUTDOWN 1
Shared Server Process 1
shutting down databases 1, 2
SQL*Loader
- control file conventions 1
- preferred tools 1
- starting 1
SQL*Plus
- connecting to a database through Active Directory 1
- preferred tools 1
- shutting down the database 1
- starting 1, 2, 3
- starting the database 1
SQL*Plus Worksheet
- preferred tools 1
sqlnet.ora file
- and Windows native authentication 1, 2
- location of 1, 2
starting
- Oracle Database 1
- Oracle Database services 1
  - using command prompt 1
  - using Control Panel 1, 2
  - using Oracle Administration Assistant 1
- SQL*Plus 1
- TKPROF 1
starting an Oracle Database instance 1
starting Oracle Database 1
stopping
- Oracle Database 1
- Oracle Database services 1
  - using command prompt 1
  - using Control Panel 1, 2
  - using Oracle Administration Assistant 1
stopping Oracle Database 1
storing an Oracle Wallet 1
SYSDBA privileges
- connecting without a password 1
- member of
  - ORA_DBA 1
  - ORA_HOMENAME_DBA 1
SYSTEM user
- permissions 1

T

Task Manager
- starting 1
- using 1
testing connectivity
- from client computers 1
- from Microsoft tools 1
thread-based architecture 1
threads
- and Microsoft Management Console 1
- and multiple Oracle Database instances 1
- and ORASTACK 1
- and shared server process 1
- defined 1
- optional and required 1
- process errors 1
- processor affinity 1
- scheduling priority 1
TNS_ADMIN networking parameter 1
tools, starting
- asmtool 1
- asmtoolg 1
- Database Configuration Assistant 1
- Data Pump Export 1
- Data Pump Import 1
- DBVERIFY 1
- Event Viewer 1
- Export 1
- Microsoft Management Console 1
- Microsoft ODBC Administration 1
- Oracle Automatic Storage Management Configuration Assistant (ASMCA) 1
- Oracle Directory Manager 1
- Oracle Locale Builder 1
- Oracle Net Configuration Assistant 1
- Oracle Net Manager 1
- Oracle Wallet Manager 1
- ORADIM 1
- ORAPWD 1
- Recovery Manager 1
- Registry Editor 1
- SQL*Loader 1
- SQL*Plus 1, 2
- Task Manager 1
- TKPROF 1
trace files
- for monitoring a database 1
- using 1
troubleshooting
- ORA-12560 error 1
- ORA-28575 error 1
- TNS-12203 error 1
- Windows firewall exceptions 1
tuning Windows Server operating system 1

U

UNIX and Windows, Oracle Database differences 1
USE_SHARED_SOCKET networking parameter 1
user authentication
- description 1
- enhancement methods 1
user group privileges
- ORA_ASMADMIN 1
- ORA_ASMDBA 1
- ORA_ASMOPER 1
- ORA_DBA 1
- ORA_HOMENAME_DBA 1
- ORA_HOMENAME_OPER 1
- ORA_HOMENAME_SYSBACKUP 1
- ORA_HOMENAME_SYSDG 1
- ORA_HOMENAME_SYSKM 1
- ORA_OPER 1
user replacement failure on Windows 1
using Oracle Administration Assistant
- start Oracle Database 1
- stop Oracle Database 1
using ORADIM
- creating an Oracle Database instance 1
- modifying an instance 1
- starting an Oracle Database instance 1
- starting services 1
using UTL_FILE 1
using VSS
- database backup and recovery
  - concepts 1
  - purpose 1
  - scope 1
  - steps 1

V

viewing password file
- using command prompt 1
- using Windows Explorer 1
Volume Shadow Copy Service (VSS) 1
VSS
- Oracle VSS Writer 1
  - backup 1
- VSS provider 1
- VSS requester 1

W

Wallet Resource Locator 1
Windows
- and UNIX, Oracle Database differences 1
Windows 32-bit operating system features
- large user populations 1
- Oracle PKI 1
Windows domains
- administering external users and roles 1
- basic features 1
Windows firewall exceptions
- configuring 1
- troubleshooting 1
Windows firewall postinstallation 1
Windows local groups 1
Windows local groups with DBA privileges 1
Windows native authentication
- benefits 1, 2
- enhancements 1
- installation of 1, 2
- methods and use of 1, 2
- overview 1, 2
- role authorization enhancements 1
- setting the sqlnet.ora file 1, 2
- user and role requirements 1
- user authentication enhancements 1
Windows-specific
- audit trail 1
- initialization parameter file 1
- parameter file location 1
- parameter filename and location 1
- password filename and location 1
- role syntax 1
- trace file names 1
Windows tuning
- applying latest service packs 1
- closing unnecessary foreground applications 1
- configuring server to be an application server 1
- disabling unnecessary services 1
- foreground applications 1
- multiple striped volumes for sequential and random access 1
- multiplex windows server virtual memory paging file 1
- overview 1
- removing unused network protocols 1
- resetting the network protocol bind order 1
- setting the order of multiple network interface cards 1
- using hardware and operating system striping 1
Windows utility tool
- ORADIM 1