Oracle9i Administrator's Reference
Release 2 (9.2.0.1.0) for UNIX Systems: AIX-Based Systems, Compaq Tru64 UNIX, HP 9000 Series HP-UX, Linux Intel, and Sun Solaris Part No. A97297-01 |
|
This guide and the Oracle9i Installation Guide Release 2 (9.2.0.1.0) for UNIX Systems provide instructions for administering and configuring Oracle9i release 2 (9.2.0.1.0) on UNIX systems.
This document is intended for anyone responsible for administering and configuring Oracle9i release 2 (9.2.0.1.0) on UNIX systems.
Unless noted otherwise, the information in this document is common to both Oracle9i Standard Edition and Oracle9i Enterprise Edition.
The names for the UNIX operating systems have been shortened in this guide and in the Oracle9i Installation Guide Release 2 (9.2.0.1.0) for UNIX Systems. The names are as follows:
Operating System | Abbreviated Name |
---|---|
AIX-Based Systems | AIX
Note: Where there is a difference between AIX 4.3.3 and 5.1, this is noted in the text. |
HP 9000 Series HP-UX | HP |
Linux Intel (32-bit) | Linux |
Sun Solaris (32-bit and 64-bit) | Solaris
Note: Where there is a difference between 32-bit and 64-bit systems, this is noted in the text. |
Compaq Tru64 UNIX | Tru64 |
The following typographic conventions are used in this guide:
Convention | Description |
---|---|
monospace | Monospace type indicates UNIX commands, directory names, usernames, pathnames, and filenames. |
italics | Italic type indicates a variable, including variable portions of filenames. It is also used for emphasis and for book titles. |
UPPERCASE | Uppercase letters indicate Structured Query Language (SQL) reserved words, initialization parameters, and environment variables. |
<cr> | This string indicates a newline character. |
UNIX command syntax appears in monospace
font and assumes the use of the Bourne shell. The "$
" character at the beginning of UNIX command examples is the default UNIX command prompt. Do not enter it as part of the command.
Convention | Description |
---|---|
backslash \ | A backslash indicates a command that is too long to fit on a single line. Enter the line as displayed (with a backslash) or enter it on a single line without a backslash:
|
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:SIZE filesize [K|M]
|
Oracle9i release 2 (9.2.0.1.0) for UNIX systems documentation includes this guide and the Oracle9i Installation Guide Release 2 (9.2.0.1.0) for UNIX Systems. You can install documentation in HTML and PDF (Adobe Portable Document Format, which requires Acrobat Reader) formats. UNIX-specific documentation files are located on the Oracle9i CD-ROM. Generic documentation files are located on the Online Generic Documentation CD-ROM. The exact location of the documentation files is determined according to the following rules:
If the ORACLE_DOC environment variable is defined in the environment, then the files are installed in the directory defined by the environment variable.
If the ORACLE_DOC environment variable is not defined but the ORACLE_BASE environment variable is defined, then the files are installed in the $ORACLE_BASE/doc
directory.
If neither the ORACLE_DOC environment variable nor the ORACLE_BASE environment variable are defined in the environment, then the files are installed in the $ORACLE_HOME/doc
directory.
To access the documentation, navigate to the documentation directory. If you want to access the HTML documentation, then use a browser to open the index.htm
file. If you prefer paper documentation, then open and print the PDF files.
Oracle9i product documentation is on the Oracle9i Generic Documentation CD-ROM. Instructions for accessing and installing the documents on the CD-ROM are found in the README file in the top-level directory of the CD-ROM.
The documentation library on the Generic Documentation CD-ROM includes a Web-based search tool that enables you to search through the complete library of Oracle9i documents. You may search for information on a particular product, parameter, filename, procedure, error message, or other area of interest. The tool also makes it possible to construct a "virtual book" that consists of topics and procedures relevant for your needs drawn from the complete documentation library. The library also includes a comprehensive Master Index, as well as lists of SQL and PL/SQL keywords, initialization parameters, catalog views, and data dictionary views.
If you are unfamiliar with the concepts or terminology associated with relational database management systems, then refer to Oracle9i Database Concepts before beginning your installation. Use the Installation Checklist in the Oracle9i Installation Guide Release 2 (9.2.0.1.0) for UNIX Systems to ensure that you have the required information and that you have completed the necessary pre-installation steps for a successful installation.
Information on system administration and tuning for a production database system is provided in these documents:
Oracle9i Installation Guide Release 2 (9.2.0.1.0) for UNIX Systems
Oracle9i Database Administrator's Guide
Oracle9i Net Services Administrator's Guide
Oracle9i Database Performance Guide and Reference
Information on upgrading from a previous version of the Oracle Server is provided in Oracle9i Database Migration.
The Oracle corporate Web page is located at:
http://www.oracle.com
Oracle Corporation offers a wide range of services from this Web site to help facilitate corporate system solutions, including Oracle Education courses, Oracle Consulting services, and Oracle Worldwide Customer Support. In addition, Oracle Corporation provides free trial software, updates on Oracle products and services, and technical brochures and data sheets.
Technical Support registration and worldwide contact information is available at:
http://www.oracle.com/support
At the Oracle support site, templates are available to help you prepare information about your problem before you call so that you may be helped more quickly. You must also provide your CSI (Customer Support Identifier) or SAC (Support Access Code) number if applicable or complete contact details, including any special project information.
OracleMetaLink is an Oracle Corporation Web service that provides technical information. Members of OracleMetaLink can search for updates, alerts, patches, and other information about products, releases, and operating systems, or set preferences to be notified automatically of new information. OracleMetaLink offers a variety of services to assist in setting up and administrating Oracle products, including procedures, scripts, commentary, and tuning and configuration best-practices bulletins. In addition, it offers forums for information sharing among Oracle customers, and direct communication with Oracle Support. OracleMetaLink is available to Product Support Customers at no extra cost. Sign up for free membership for this service at:
http://www.oracle.com/support/metalink
Use your CSI or SAC number to register.
For U.S.A. customers, Oracle Store is at:
http://oraclestore.oracle.com/
Links to Stores in other countries are provided at this site.
Product documentation can be found at:
http://docs.oracle.com
Global Customer Service contacts are listed at:
http://www.oracle.com/support/
Training information and worldwide schedules are available at:
http://www.oracle.com/education/
Register with the Oracle Technology Network (OTN) at:
http://otn.oracle.com/
OTN delivers technical papers, code samples, product documentation, an Oracle on-line community, and self-service developer support. It also offers the Oracle key developer products to enable rapid development and deployment of applications built on Oracle technology.
Our goal is to make Oracle products, services, and supporting documentation accessible, with good usability, to the disabled community. 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. Standards will continue to evolve over time, and Oracle Corporation 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 additional information, visit the Oracle Accessibility Program Web site at http://www.oracle.com/accessibility/
.
JAWS, a Windows screen reader, 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, JAWS may not always read a line of text that consists solely of a bracket or brace.
This documentation may contain links to Web sites of other companies or organizations that Oracle Corporation does not own or control. Oracle Corporation neither evaluates nor makes any representations regarding the accessibility of these Web sites.
Oracle Corporation provides dedicated Text Telephone (TTY) access to Oracle Support Services within the United States of America 24 hours a day, seven days a week.
For technical questions, call 1.800.446.2398
For non-technical questions, call 1.800.464.2330
|
![]() Copyright © 1996, 2002 Oracle Corporation All rights reserved |
|