Oracle® Database Administrator's Reference 10g Release 2 (10.2) for UNIX-Based Operating Systems Part Number B15658-06 |
|
|
View PDF |
This guide provides information about administering and configuring Oracle Database 10g release 2 (10.2) on the following platforms:
AIX 5L Based Systems (64-Bit)
Apple Mac OS X (Intel)
hp Tru64 UNIX
hp-ux PA-RISC (64-Bit)
hp-ux Itanium
IBM zSeries Based Linux
Linux Itanium
Linux on POWER
Linux x86
Linux x86-64
Solaris Operating System (SPARC 64-Bit)
Solaris Operating System (x86)
Solaris Operating System (x86-64)
This guide is intended for anyone responsible for administering and configuring Oracle Database 10g release 2 (10.2). If you are configuring Oracle Real Application Clusters (RAC), then refer to Oracle Database Oracle Clusterware and Oracle Real Application Clusters Administration and Deployment Guide.
Our goal is to make Oracle products, services, and supporting documentation accessible to all users, including users that are disabled. To that end, our documentation includes features that make information available to users of assistive technology. This documentation is available in HTML format, and contains markup to facilitate access by the disabled community. Accessibility standards will continue to evolve over time, and Oracle is actively engaged with other market-leading technology vendors to address technical obstacles so that our documentation can be accessible to all of our customers. For more information, visit the Oracle Accessibility Program Web site at http://www.oracle.com/accessibility/
.
Accessibility of Code Examples in Documentation
Screen readers may not always correctly read the code examples in this document. The conventions for writing code require that closing braces should appear on an otherwise empty line; however, some screen readers may not always read a line of text that consists solely of a bracket or brace.
Accessibility of Links to External Web Sites in Documentation
This documentation may contain links to Web sites of other companies or organizations that Oracle does not own or control. Oracle neither evaluates nor makes any representations regarding the accessibility of these Web sites.
TTY Access to Oracle Support Services
To reach AT&T Customer Assistants, dial 711 or 1.800.855.2880. An AT&T Customer Assistant will relay information between the customer and Oracle Support Services at 1.800.223.1711. Complete instructions for using the AT&T relay services are available at http://www.consumer.att.com/relay/tty/standard2.html
. After the AT&T Customer Assistant contacts Oracle Support Services, an Oracle Support Services engineer will handle technical issues and provide customer support according to the Oracle service request process.
Refer to the appropriate section for a listing of Oracle Database 10g documentation specific to your platform:
AIX 5L Based Systems (64-Bit) Documentation
Oracle Database
Oracle Database Release Notes for AIX 5L Based Systems (64-Bit)
Oracle Database Installation Guide for AIX 5L Based Systems (64-Bit)
Oracle Database Quick Installation Guide for AIX 5L Based Systems (64-Bit)
Oracle Database Oracle Clusterware and Oracle Real Application Clusters Installation Guide for AIX Based Systems
Oracle Database Administrator's Reference for UNIX-Based Operating Systems
Oracle Database Client
Oracle Database Client Installation Guide for AIX 5L Based Systems (64-Bit)
Oracle Database Client Quick Installation Guide for AIX 5L Based Systems (64-Bit)
Oracle Database 10g Companion CD
Oracle Database Companion CD Installation Guide for AIX 5L Based Systems (64-Bit)
Oracle Database Companion CD Quick Installation Guide for AIX 5L Based Systems (64-Bit)
hp-ux PA-RISC (64-Bit) Documentation
Oracle Database
Oracle Database Release Notes for hp-ux PA-RISC (64-Bit)
Oracle Database Installation Guide for hp-ux PA-RISC (64-Bit)
Oracle Database Quick Installation Guide for hp-ux PA-RISC (64-Bit)
Oracle Database Oracle Clusterware and Oracle Real Application Clusters Installation Guide for hp-ux
Oracle Database Administrator's Reference for UNIX-Based Operating Systems
Oracle Database Client
Oracle Database Client Installation Guide for hp-ux PA-RISC (64-Bit)
Oracle Database Client Quick Installation Guide for hp-ux PA-RISC (64-Bit)
Oracle Database 10g Companion CD
Oracle Database Companion CD Installation Guide for hp-ux PA-RISC (64-Bit)
Oracle Database Companion CD Quick Installation Guide for hp-ux PA-RISC (64-Bit)
hp-ux Itanium Documentation
Oracle Database
Oracle Database Release Notes for hp-ux Itanium
Oracle Database Installation Guide for hp-ux Itanium
Oracle Database Quick Installation Guide for hp-ux Itanium
Oracle Database Oracle Clusterware and Oracle Real Application Clusters Installation Guide for hp-ux
Oracle Database Administrator's Reference for UNIX-Based Operating Systems
Oracle Database Client
Oracle Database Client Installation Guide for hp-ux Itanium
Oracle Database Client Quick Installation Guide for hp-ux Itanium
Oracle Database 10g Companion CD
Oracle Database Companion CD Installation Guide for hp-ux Itanium
Oracle Database Companion CD Quick Installation Guide for hp-ux Itanium
Linux on POWER Documentation
Oracle Database
Oracle Database Release Notes for Linux on POWER
Oracle Database Installation Guide for Linux on POWER
Oracle Database Quick Installation Guide for Linux on POWER
Oracle Database Oracle Clusterware and Oracle Real Application Clusters Installation Guide for Linux
Oracle Database Administrator's Reference for UNIX-Based Operating Systems
Oracle Database Client
Oracle Database Client Installation Guide for Linux on POWER
Oracle Database Client Quick Installation Guide for Linux on POWER
Oracle Database Companion CD
Oracle Database Companion CD Installation Guide for Linux on POWER
Oracle Database Companion CD Quick Installation Guide for Linux on POWER
Linux x86 Documentation
Oracle Database
Oracle Database Release Notes for Linux x86
Oracle Database Installation Guide for Linux x86
Oracle Database Quick Installation Guide for Linux x86
Oracle Database Oracle Clusterware and Oracle Real Application Clusters Installation Guide for Linux
Oracle Database Administrator's Reference for UNIX-Based Operating Systems
Oracle Database Client
Oracle Database Client Installation Guide for Linux x86
Oracle Database Client Quick Installation Guide for Linux x86
Oracle Database 10g Companion CD
Oracle Database Companion CD Installation Guide for Linux x86
Oracle Database Companion CD Quick Installation Guide for Linux x86
Linux x86-64 Documentation
Oracle Database
Oracle Database Release Notes for Linux x86-64
Oracle Database Installation Guide for Linux x86-64
Oracle Database Quick Installation Guide for Linux x86-64
Oracle Database Oracle Clusterware and Oracle Real Application Clusters Installation Guide for Linux
Oracle Database Administrator's Reference for UNIX-Based Operating Systems
Oracle Database Client
Oracle Database Client Installation Guide for Linux x86-64
Oracle Database Client Quick Installation Guide for Linux x86-64
Oracle Database 10g Companion CD
Oracle Database Companion CD Installation Guide for Linux x86-64
Oracle Database Companion CD Quick Installation Guide for Linux x86-64
Solaris Operating System (SPARC 64-Bit) Documentation
Oracle Database
Oracle Database Release Notes for Solaris Operating System (SPARC 64-Bit)
Oracle Database Installation Guide for Solaris Operating System (SPARC 64-Bit)
Oracle Database Quick Installation Guide for Solaris Operating System (SPARC 64-Bit)
Oracle Database Oracle Clusterware and Oracle Real Application Clusters Installation Guide for Solaris Operating System
Oracle Database Administrator's Reference for UNIX-Based Operating Systems
Oracle Database Client
Oracle Database Client Installation Guide for Solaris Operating System (SPARC 64-Bit)
Oracle Database Client Quick Installation Guide for Solaris Operating System (SPARC 64-Bit)
Oracle Database 10g Companion CD
Oracle Database Companion CD Installation Guide for Solaris Operating System (SPARC 64-Bit)
Oracle Database Companion CD Quick Installation Guide for Solaris Operating System (SPARC 64-Bit)
Solaris Operating System (x86) Documentation
Oracle Database
Oracle Database Release Notes for Solaris Operating System (x86)
Oracle Database Installation Guide for Solaris Operating System (x86)
Oracle Database Quick Installation Guide for Solaris Operating System (x86)
Oracle Database Oracle Clusterware and Oracle Real Application Clusters Installation Guide for Solaris Operating System
Oracle Database Administrator's Reference for UNIX-Based Operating Systems
Oracle Database Client
Oracle Database Client Installation Guide for Solaris Operating System (x86)
Oracle Database Client Quick Installation Guide for Solaris Operating System (x86)
Oracle Database 10g Companion CD
Oracle Database Companion CD Installation Guide for Solaris Operating System (x86)
Oracle Database Companion CD Quick Installation Guide for Solaris Operating System (x86)
Solaris Operating System (x86-64) Documentation
Oracle Database
Oracle Database Release Notes for Solaris Operating System (x86-64)
Oracle Database Installation Guide for Solaris Operating System (x86-64)
Oracle Database Quick Installation Guide for Solaris Operating System (x86-64)
Oracle Database Oracle Clusterware and Oracle Real Application Clusters Installation Guide for Solaris Operating System
Oracle Database Administrator's Reference for UNIX-Based Operating Systems
Oracle Database Client
Oracle Database Client Installation Guide for Solaris Operating System (x86-64)
Oracle Database Client Quick Installation Guide for Solaris Operating System (x86-64)
Oracle Database 10g Companion CD
Oracle Database Companion CD Installation Guide for Solaris Operating System (x86-64)
Oracle Database Companion CD Quick Installation Guide for Solaris Operating System (x86-64)
Apple Mac OS X (Intel) Documentation
Oracle Database
Oracle Database Release Notes for Apple Mac OS X (Intel)
Oracle Database Installation Guide for Apple Mac OS X (Intel)
Oracle Database Administrator's Reference for UNIX-Based Operating Systems
Oracle Database Client
Oracle Database Client Installation Guide for Apple Mac OS X (Intel)
Oracle Database 10g Companion CD
Oracle Database Companion CD Installation Guide for Apple Mac OS X (Intel)
For important information that was not available when this book was released, refer to the release notes for your platform. The release notes for Oracle Database are updated regularly. You can get the most recent version from Oracle Technology Network at
http://www.oracle.com/technology/documentation/index.html
The following text conventions are used in this document:
Convention | Meaning |
---|---|
boldface | Boldface type indicates graphical user interface elements associated with an action, or terms defined in text or the glossary. |
italic | Italic type indicates book titles, emphasis, or placeholder variables for which you supply particular values. |
monospace |
Monospace type indicates commands within a paragraph, URLs, code in examples, text that appears on the screen, or text that you enter. |
UNIX command syntax appears in monospace
font. The dollar character ($), number sign (#), or percent character (%) are UNIX command prompts. Do not enter them as part of the command. The following command syntax conventions are used in this guide:
Convention | Description |
---|---|
backslash \ | A backslash is the UNIX command continuation character. It is used in command examples that are too long to fit on a single line. Enter the command as displayed (with a backslash) or enter it on a single line without a backslash:
dd if=/dev/rdsk/c0t1d0s6 of=/dev/rst0 bs=10b \ count=10000 |
braces { } | Braces indicate required items:
.DEFINE {macro1} |
brackets [ ] | Brackets indicate optional items:
cvtcrt termname [outfile] |
ellipses ... | Ellipses indicate an arbitrary number of similar items:
CHKVAL fieldname value1 value2 ... valueN |
italics | Italic type indicates a variable. Substitute a value for the variable:
library_name
|
vertical line | | A vertical line indicates a choice within braces or brackets:
FILE filesize [K|M]
|
The names of some UNIX operating systems have been shortened in this guide. These are:
Operating System | Abbreviated Name |
---|---|
AIX 5L Based Systems (64-Bit) | AIX |
Apple Mac OS X (Intel) | Mac OS X |
hp-ux PA-RISC (64-bit) hp-ux Itanium |
HP-UX
Note: Where the information for HP-UX is different on a particular architecture, this is noted in the text. |
hp Tru64 UNIX | Tru64 UNIX |
Linux Itanium Linux on POWER IBM zSeries Based Linux Linux x86 Linux x86-64 |
Linux
Note: Where the information for Linux is different on a particular architecture, this is noted in the text. |
Solaris Operating System (SPARC 64-Bit) Solaris Operating System (x86) Solaris Operating System (x86-64) |
Solaris
Note: Where the information for Solaris is different on a particular architecture, this is noted in the text. |
The documentation for Oracle Database 10g release 2 (10.2) includes platform-specific documentation and generic product documentation.
Platform-Specific Documentation
Platform-specific documentation includes information about installing and using Oracle products on particular platforms. The platform-specific documentation for this product is available in both Adobe portable document format (PDF) and HTML format on the product disc. To access the platform-specific documentation on disc:
Use a Web browser to open the welcome.htm
file in the top-level directory of the disc.
For DVDs only, select the appropriate product link.
Select the Documentation tab.
If you prefer paper documentation, then open and print the PDF files.
Product Documentation
Product documentation includes information about configuring, using, or administering Oracle products on any platform. The product documentation for Oracle Database 10g products is available in both HTML and PDF formats in the Oracle Database 10g Release 2 (10.2) Online Documentation Library. This library is on the Oracle Technology Network Web site at
http://www.oracle.com/technology/documentation/index.html
This program contains third party software from HP. The Oracle program license that accompanied this product determines your right to use the Oracle program, including the HP software. Notwithstanding anything to the contrary in the Oracle program license, the HP software is provided "AS IS" and without intellectual property indemnities, warranties, or support of any kind from Oracle or HP.
This program also contains third party software from International Business Machines Corporation (IBM). The Oracle program license that accompanied this product determines your right to use the Oracle program, including the IBM software.
Notwithstanding anything to the contrary in the Oracle program license, the IBM software is provided "AS IS" and without intellectual property indemnities, warranties, or support of any kind from Oracle or IBM.