Index
A
B
C
D
E
F
I
K
L
M
N
O
P
Q
R
S
T
U
W
A
- admin directory, explained, 6-17
- Administration Assistant for Windows NT
- starting, 5-8
- application development
- and data access, 10-4
- database tools, 5-2
- finding information, 10-2
- architecture
- thread-based, 4-2
- audit trail
- operating system, 5-20
B
- background processes
- querying, 4-3
- backup
- control files, 9-8
- tools, 5-5
- Backup Wizard
- preferred tools, 5-5
C
- configuration parameters
- defined, 9-2
- registry, defined, 9-2
- CONNECT INTERNAL
- replacement, 5-2
- CREATE LIBRARY
- command, 10-11
D
- database connection
- error messages, A-26
- database roles
- granting limited SYS privileges, 8-4
- of default accounts, 8-4
- database tools
- administration, 5-3
- operating system compatibility, 5-2
- starting from the command line, 5-10
- starting from the Start Menu, 5-8
- starting in multiple Oracle Homes, 5-7
- DB_NAME
- directory, explained, 6-18
- multiple Oracle homes, 6-6
- DBVERIFY
- operating system compatibility, 5-3
- starting, 5-10
- debugging external procedures, 10-13
- developing applications
- for Windows, 10-2
- diagnostic and tuning utilities
- for Windows, 5-23
- disk striping, 6-23
- DLLs
- compared to UNIX shared libraries, 2-3
- displaying with Task List, 5-23
- external procedures, 10-10
- Oracle Performance Monitor, 9-11
- Oracle Real Application Clusters, 9-12
E
- Enterprise Login Assistant
- starting, 5-8
- Enterprise Manager Configuration Assistant
- starting, 5-8
- Enterprise Manager Console
- starting, 5-8
- environment variables
- ORACLE_HOME, 6-10
- TNS_ADMIN, 6-12
- error messages
- DIM-00000 to DIM-00039, A-19
- Intercartridge Exchange, 10-18
- logging, A-2
- ORA-12547 TNS, 7-4
- ORA-12560, A-26
- OSD-04000 to OSD-04099, A-6
- OSD-04100 to OSD-04199, A-10
- OSD-04200 to OSD-04299, A-12
- OSD-04300 to OSD-04399, A-16
- OSD-04400 to OSD-04499, A-16
- OSD-04500 to OSD-04599, A-17
- OSD-09275, A-2
- Event Viewer
- defined, 5-19
- integration with Oracle9i database, 5-19
- logging operating system audit trail, 5-20
- operating system compatibility, 5-4
- exception conditions, Intercartridge Exchange, 10-18
- executable images
- modifying, 4-5
- EXECUTE privileges, on a PL/SQL library, 10-11
- Export Utility
- operating system compatibility, 5-3
- preferred tools, 5-5
- redirecting output, A-2
- starting, 5-10
- Export Wizard
- preferred tools, 5-5
- EXTERNAL clause, 10-11
- external procedures
- building a DLL, 10-10
- creating a PL/SQL library, 10-11
- debugging, 10-13
- EXTERNAL clause, 10-11
- granting EXECUTE privileges, 10-11
- registering with Oracle database, 10-11
- using EXTPROC, 10-9
- writing, 10-9
- EXTPROC
- example, 10-9
- explained, 10-8
- responsibilities, 10-9
F
- features
- 4GT tuning, 4-6
- large user populations, 4-6
- Oracle PKI, 4-7
- file I/O enhancements, 4-5
- files
- oracle.key, 6-10
- size limitations, 4-5
I
- ICX. See Intercartridge Exchange
- Import Utility
- operating system compatibility, 5-3
- preferred tools, 5-5
- Import Wizard
- preferred tools, 5-5
- initialization parameters
- path in registry, 9-5
- instance
- Oracle, 4-2
- integration with Windows
- 4GT tuning, 4-6
- Active Directory, 4-7
- Oracle Fail Safe, 4-9
- Oracle Net Naming, 4-8
- Oracle PKI, 4-7
- Oracle Services for MTS, 4-8
- Intercartridge Exchange
- accessing Web data, 10-14
- configuring, 10-14
- error messages, 10-18
- exception conditions, 10-18
- packaged functions, 10-16
- stored packages, 10-16
- using, 10-16
- internet applications
- developing, 10-5
- INTYPE File Assistant
- starting, 5-8
- IPC
- DeviceNic registry value, 9-13
- InstanceID registry value, 9-13
K
- keys
- defined, 9-2
L
- Load Wizard
- preferred tools, 5-5
- Locale Builder
- starting, 5-8
- logging error messages, A-2
M
- Microsoft Management Console
- defined, 5-20
- integration with Oracle9i database, 5-20
- starting, 5-15
- Microsoft ODBC Administration
- starting, 5-9
- Migration Utility
- operating system compatibility, 5-3
- preferred tools, 5-5
- starting, 5-10
- Migration Workbench
- starting, 5-9
- MMC. See Microsoft Management Console
- monitoring
- Oracle events, 5-20
- multiple Oracle homes
- ALL_HOMES registry subkey, 9-8
- benefits, 6-3
- environment, 6-5
- functionality in different releases, 6-3
- introduction, 6-2
- overview, 6-2
- program groups, 6-6
- registry entries, 6-6
- service names, 6-6
- system identifier, 6-6
- use of one listener for spawning, 6-5
N
- Net Configuration Assistant
- starting, 5-9
- Net Manager
- starting, 5-9
O
- Object Type Translator
- operating system compatibility, 5-2
- OCOPY
- and raw files, 4-5
- operating system compatibility, 5-3
- preferred tools, 5-5
- starting, 5-10
- operating systems
- audit trail, 5-20
- OPERFCFG
- operating system compatibility, 5-3
- starting, 5-11
- syntax examples, 9-20
- Optimal Flexible Architecture
- benefits, 6-13
- characteristics of a database, 6-14
- default OFA database, 6-19
- differences since previous releases, 6-15
- introduction, 6-2
- nondefault OFA database 1, 6-20
- nondefault OFA database 2, 6-21
- overview, 6-12
- Windows and UNIX differences, 6-24
- ORA-12560 TNS, 7-5
- Oracle Administration Assistant for Windows NT
- operating system compatibility, 5-3
- using, 9-17, 9-21
- using the Oracle Home Configuration snap-in, 9-17
- using the Performance Monitoring snap-in, 9-21
- Oracle Advanced Security
- operating system compatibility, 5-3
- Oracle Data Migration Assistant
- operating system compatibility, 5-3
- preferred tools, 5-5
- starting, 5-8
- Oracle Database Configuration Assistant
- operating system compatibility, 5-3
- preferred tools, 5-5
- starting, 5-8
- Oracle Directory Manager
- starting, 5-9
- Oracle Enterprise Login Assistant
- preferred tools, 5-5
- security, 4-7
- Oracle Enterprise Manager Console
- operating system compatibility, 5-3
- preferred tools, 5-5
- starting from a Web browser, 5-13
- starting tools, 5-12
- Oracle home
- new-style, defined, 6-12
- Oracle Home Configuration snap-in
- using, 9-17
- Oracle Home Selector
- changing PATH value, 6-8
- Oracle Migration Workbench
- operating system compatibility, 5-3
- Oracle Net
- configuring for external procedures, 10-9
- Oracle Net Configuration Assistant
- operating system compatibility, 5-3
- Oracle Net Manager
- operating system compatibility, 5-3
- Oracle Net Naming
- with Active Directory, 4-8
- Oracle Performance Monitor
- integration with Windows, 2-2
- operating system compatibility, 5-3
- parameters, 9-10
- starting, 3-3
- using, 9-21
- Oracle Performance Monitor for Windows NT
- defined, 5-20
- integration with Oracle9i database, 5-20
- monitoring specific Oracle events, 5-20
- starting, 5-9, 5-15
- Oracle Portal
- operating system compatibility, 5-2
- Oracle Real Application Clusters
- registry values, 9-12
- Oracle Services for Microsoft Transaction Server
- operating system compatibility, 5-2
- Oracle Wallet Manager, 4-7
- preferred tools, 5-5
- ORACLE_BASE
- explained, 6-16
- ORACLE_HOME
- directory structure, 6-17
- environment variable, 6-10, 6-11
- specifying, 6-19
- oracle.key file, 6-10, 6-11
- ORADATA directory, explained, 6-18
- ORADIM
- command syntax errors, A-19
- operating system compatibility, 5-3
- preferred tools, 5-5
- starting, 5-11
- ORAPWD
- operating system compatibility, 5-3
- preferred tools, 5-5
- starting, 5-11
P
- packaged functions
- Intercartridge Exchange, 10-16
- UTL_HTTP.REQUEST, 10-16
- UTL_HTTP.REQUEST_PIECES, 10-17
- parameters
- DEFAULT_HOME, 9-9
- DisplayName, 9-11
- HOME_COUNTER, 9-9
- Hostname, 9-10
- ImagePath, 9-11
- INST_LOC, 9-8
- LAST_HOME, 9-9
- LOGFILE, 9-11
- MSHELP_TOOLS, 9-4
- NAME, 9-9
- NLS_LANG, 9-4
- ObjectName, 9-12
- OO4O, 9-8
- ORA_AFFINITY, 9-6
- ORA_CWD, 9-4
- ORA_SID_AUTOSTART, 9-4
- ORA_SID_PFILE, 9-5
- ORA_SID_SHUTDOWN, 9-5
- ORA_SID_SHUTDOWN_TIMEOUT, 9-5
- ORA_SID_SHUTDOWNTYPE, 9-5
- Oracle Performance Monitor, 9-20
- ORACLE_BASE, 9-6
- ORACLE_GROUP_NAME, 9-6
- ORACLE_HOME, 9-6
- ORACLE_HOME_KEY, 9-7
- ORACLE_HOME_NAME, 9-7
- ORACLE_PRIORITY, 9-7
- ORACLE_SID, 9-7
- OSAUTH_PREFIX_DOMAIN, 9-8
- OSAUTH_X509_NAME, 9-8
- PATH, 9-9
- PERF_FILE_NAME, 9-11
- RDBMS_ARCHIVE, 9-7
- RDBMS_CONTROL, 9-8
- SQLPATH, 9-8
- TNS_ADMIN, 6-12
- Username, 9-11
- PARFILE, using, A-2
- partition
- raw, 6-24
- Password parameter, 9-11
- Password Utility
- operating system compatibility, 5-3
- passwords
- changing, 8-2, 8-3
- for default accounts, 8-4
- PATH, changing the value of, 6-7
- PERFORMANCE key, 9-10
- performance, increasing, 6-23
- PL/SQL Embedded Gateway, 10-2
- PRAGMA RESTRICT_REFERENCES, with Intercartridge Exchange, 10-18
- Pro C-C++
- starting, 5-9
- Pro*C/C++
- operating system compatibility, 5-2
- Pro*COBOL
- operating system compatibility, 5-2
- Process Explode, 5-23
- Process Viewer, 5-23
- program groups
- multiple Oracle homes, 6-6
Q
- QuickSlice, 5-23
R
- RAID. See Redundant Array of Independent Disks
- raw files
- using, 4-5
- raw partitions
- defined, 6-24
- Recovery Manager
- operating system compatibility, 5-3
- preferred tools, 5-5
- Recovery Wizard
- preferred tools, 5-5
- Redundant Array of Independent Disks, 6-23
- registering an external procedure, 10-11
- registry
- adding parameters, 9-15
- ALL_HOMES subkey, 9-8
- and multiple Oracle homes, 6-6
- and Oracle Real Application Clusters, 9-12
- Cluster Manager, 9-12
- ClusterID, 9-12
- ClusterName, 9-12
- CmDiskFile, 9-12
- CMDLL, 9-12
- CmHostName, 9-12
- configuration parameters, defined, 9-2
- DEFAULT_HOME, 9-9
- DefinedNodes, 9-12
- DeviceNic, 9-13
- DisplayName, 9-11
- editor, 9-2
- editor, starting, 5-16
- HOME_COUNTER, 9-9
- Hostname, 9-10
- ImagePath, 9-11
- INST_LOC, 9-8
- InstanceID, 9-13
- Inter-Process Communication, 9-13
- IODLL, 9-12
- IPCDLL, 9-12
- keys, defined, 9-2
- LAST_HOME, 9-9
- LOGFILE, 9-11
- MissCount, 9-12
- modifying values, 9-14
- MSHELP_TOOLS, 9-4
- NAME, 9-9
- NLS_LANG, 9-4
- ObjectName, 9-12
- OO4O, 9-8
- ORA_AFFINITY, 9-6
- ORA_CWD, 9-4
- ORA_SID_AUTOSTART, 9-4
- ORA_SID_PFILE, 9-5
- ORA_SID_SHUTDOWN, 9-5
- ORA_SID_SHUTDOWN_TIMEOUT, 9-5
- ORA_SID_SHUTDOWNTYPE, 9-5
- ORACLE_BASE, 9-6
- ORACLE_GROUP_NAME, 9-6
- ORACLE_HOME, 9-6
- ORACLE_HOME_KEY, 9-7
- ORACLE_HOME_NAME, 9-7
- ORACLE_PRIORITY, 9-7
- ORACLE_SID, 9-7
- OSAUTH_PREFIX_DOMAIN, 9-8
- OSAUTH_X509_NAME, 9-8
- Password, 9-11
- PATH, 9-9
- PERF_FILE_NAME, 9-11
- PERFORMANCE key, 9-10
- PollInterval, 9-13
- PublicNames, 9-13
- RDBMS_ARCHIVE, 9-7
- RDBMS_CONTROL, 9-8
- REG_DWORD, 9-2, 9-16
- REG_EXPAND_SZ, 9-2, 9-16
- REG_MULTI_SZ, 9-2, 9-16
- REG_SZ, 9-2, 9-16
- REGEDT32, 9-14, 9-15
- ServiceName, 9-13
- SQLPATH, 9-8
- STARTDLL, 9-12
- Username, 9-11
- using OPERFCFG, 9-20
- reliability, increasing, 6-23
- roles
- of default accounts, 8-4
S
- Server Manager
- replacement, 5-2
- service names
- multiple Oracle homes, 6-6
- services
- defined, 7-2
- location, 7-6
- Oracle Object Service, 7-2
- Oracle OLAP Agent, 7-3
- Oracle OLAP Services 9.0.1.1.0, 7-3
- OracleCMan, 7-4
- OracleCMService, 7-3
- OracleDirectoryService_SID, 7-3
- OracleEXTPRC, 7-3
- OracleGSDService, 7-3
- OracleHOME_NAMEAgent, 7-3
- OracleHOME_NAMEClientCache, 7-4
- OracleHOME_NAMEManagementServer, 7-4
- OracleHOME_NAMEPaging Server, 7-4
- OracleHOME_NAMEServer, 7-4
- OracleMSCSService, 7-5
- OracleMTSRecoveryService, 7-5
- OracleNAMES, 7-5
- OracleORACLE_HOMECMAdmin, 7-4
- OracleORACLE_HOMETNSListener, 7-4
- OracleServiceSID, 7-5
- OracleSNMPPeerEncapsulator, 7-5
- OracleSNMPPeerMasterAgent, 7-5
- OraFenceService, 7-6
- using, 7-6
- Shared server process, 4-6
- snap-ins
- Oracle Home Configuration, 9-17
- Oracle Performance Monitoring, 9-21
- SQL*Loader
- control file conventions, 5-18
- direct path option, 5-18
- operating system compatibility, 5-3
- preferred tools, 5-5
- starting, 5-11
- SQL*Plus
- operating system compatibility, 5-2, 5-3
- preferred tools, 5-5
- starting, 5-9, 5-11
- SQL*Plus Worksheet
- preferred tools, 5-5
- starting, 5-9
- Start HTTP Server powered by Apache
- starting, 5-9
- Stop HTTP Server powered by Apache
- starting, 5-10
- stored packages, Intercartridge Exchange, 10-16
- striping disks, 6-23
- symbolic links, 6-25
- system identifier
- multiple Oracle homes, 6-6
T
- Task List, 5-23
- Task Manager
- starting, 5-16
- using, 5-22
- threads
- and Microsoft Management Console, 5-20
- and multiple Oracle instances, 4-3
- and Oracle services, 7-2
- and ORASTACK, 4-5
- and shared server process, 4-6
- and UNIX processes, 2-6
- defined, 4-2
- optional and required, 4-3
- process errors, A-4
- processor affinity, 9-6
- scheduling priority, 9-7
- TKPROF
- operating system compatibility, 5-3
- starting, 5-11
- tools, starting
- Administration Assistant for Windows NT, 5-8
- DBVERIFY, 5-10
- Enterprise Login Assistant, 5-8
- Enterprise Manager Configuration Assistant, 5-8
- Enterprise Manager Console, 5-8
- Event Viewer, 5-15
- Export Utility, 5-10
- INTYPE File Assistant, 5-8
- Locale Builder, 5-8
- Microsoft Management Console, 5-15
- Microsoft ODBC Administration, 5-9
- Migration Utility, 5-10
- Migration Workbench, 5-9
- Net Configuration Assistant, 5-9
- Net Manager, 5-9
- OCOPY, 5-10
- OPEFCFG, 5-11
- Oracle Data Migration Assistant, 5-8
- Oracle Database Configuration Assistant, 5-8
- Oracle Directory Manager, 5-9
- Oracle Performance Monitor for Windows NT, 5-9, 5-15
- Pro C-C++, 5-9
- Recovery Manager, 5-11
- SQL*Plus, 5-9
- SQL*Plus Worksheet, 5-9
- Start HTTP Server powered by Apache, 5-9
- Stop HTTP Server powered by Apache, 5-10
- Task Manager, 5-16
- TKPROF, 5-11
- User Manager, 5-16
- Wallet Manager, 5-10
- troubleshooting
- ORA-12560 error, A-26
- ORA-28575 error, A-26
- TNS-12203 error, A-26
U
- UNIX
- and Optimal Flexible Architecture, 6-24
- and Windows, Oracle9i differences, 2-1
- User Manager
- defined, 5-22
- integration with Oracle9i database, 5-22
- preferred tools, 5-5
- starting, 5-16
- usernames
- changing, 8-3
- of administrative accounts, 8-4
- UTL_HTTP.REQUEST, Intercartridge Exchange, 10-16
- UTL_HTTP.REQUEST_PIECES, Intercartridge Exchange, 10-17
W
- Wallet Manager
- starting, 5-10
- Web browser
- running Oracle Enterprise Manager, 5-13
- Web data, Intercartridge Exchange, 10-14
- Windows
- and UNIX, Oracle9i differences, 2-1
- diagnostic and tuning utilities, 5-23
- extensions for internet development, 10-5
- tools operating system compatibility, 5-4
