Edit D:\rfid\database\database\doc\server.112\e10897\em_manage.htm
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html lang="en" xml:lang="en" xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=us-ascii" /> <meta http-equiv="Content-Language" content="en" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <meta http-equiv="Content-Script-Type" content="text/javascript" /> <meta name="robots" content="all" scheme="http://www.robotstxt.org/" /> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = document) - Version 5.1" /> <meta name="Date" content="2009-09-09T22:35:12Z" /> <meta name="doctitle" content="Oracle® Database 2 Day DBA 11g Release 2 (11.2)" /> <meta name="partno" content="E10897-02" /> <meta name="docid" content="ADMQS" /> <link rel="Start" href="../../index.htm" title="Home" type="text/html" /> <link rel="Copyright" href="../../dcommon/html/cpyr.htm" title="Copyright" type="text/html" /> <link rel="Stylesheet" href="../../dcommon/css/blafdoc.css" title="Default" type="text/css" /> <script type="text/javascript" src="../../dcommon/js/doccd.js"> </script> <link rel="Contents" href="toc.htm" title="Contents" type="text/html" /> <link rel="Index" href="index.htm" title="Index" type="text/html" /> <link rel="Prev" href="install.htm" title="Previous" type="text/html" /> <link rel="Next" href="network.htm" title="Next" type="text/html" /> <link rel="alternate" href="../e10897.pdf" title="PDF version" type="application/pdf" /> <title>Getting Started with Database Administration</title> </head> <body> <div class="header"> <div class="zz-skip-header"><a name="top" id="top" href="#BEGIN">Skip Headers</a></div> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <tr> <td align="left" valign="top"><b>Oracle® Database 2 Day DBA<br /> 11<i>g</i> Release 2 (11.2)</b><br /> Part Number E10897-02</td> <td valign="bottom" align="right"> <table class="icons oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="245"> <tr> <td align="center" valign="top"><a href="../../index.htm"><img width="24" height="24" src="../../dcommon/gifs/doclib.gif" alt="Go to Documentation Home" /><br /> <span class="icon">Home</span></a></td> <td align="center" valign="top"><a href="../../nav/portal_booklist.htm"><img width="24" height="24" src="../../dcommon/gifs/booklist.gif" alt="Go to Book List" /><br /> <span class="icon">Book List</span></a></td> <td align="center" valign="top"><a href="toc.htm"><img width="24" height="24" src="../../dcommon/gifs/toc.gif" alt="Go to Table of Contents" /><br /> <span class="icon">Contents</span></a></td> <td align="center" valign="top"><a href="index.htm"><img width="24" height="24" src="../../dcommon/gifs/index.gif" alt="Go to Index" /><br /> <span class="icon">Index</span></a></td> <td align="center" valign="top"><a href="../../dcommon/html/feedback.htm"><img width="24" height="24" src="../../dcommon/gifs/feedbck2.gif" alt="Go to Feedback page" /><br /> <span class="icon">Contact Us</span></a></td> </tr> </table> </td> </tr> </table> <hr /> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <tr> <td align="left" valign="top"> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="98"> <tr> <td align="center" valign="top"><a href="install.htm"><img width="24" height="24" src="../../dcommon/gifs/leftnav.gif" alt="Go to previous page" /><br /> <span class="icon">Previous</span></a></td> <td align="center" valign="top"><a href="network.htm"><img width="24" height="24" src="../../dcommon/gifs/rightnav.gif" alt="Go to next page" /><br /> <span class="icon">Next</span></a></td> </tr> </table> </td> <td align="right" valign="top" style="font-size: 90%"><a href="../e10897.pdf">View PDF</a></td> </tr> </table> <a name="BEGIN" id="BEGIN"></a></div> <div class="IND"><!-- End Header --><a id="CACHGFFI" name="CACHGFFI"></a><a id="ADMQS003" name="ADMQS003"></a> <h1 class="chapter"><span class="secnum">3</span> Getting Started with Database Administration</h1> <p><a id="sthref103" name="sthref103"></a><a id="sthref104" name="sthref104"></a>This chapter provides a brief roadmap for administering your database, and introduces you to Oracle Enterprise Manager Database Control (Database Control), the Web-based interface for managing an Oracle database.</p> <p>This chapter contains the following sections:</p> <ul> <li> <p><a href="#BABDIGDJ">Managing Your Database: A Roadmap</a></p> </li> <li> <p><a href="#BABCGBJF">Introduction to Oracle Enterprise Manager Database Control</a></p> </li> <li> <p><a href="#BABBAIHD">Starting and Stopping the Database Control Console Process</a></p> </li> <li> <p><a href="#BABHJAGE">Accessing the Database Home Page</a></p> </li> <li> <p><a href="#BABHCDGA">Granting Access to Database Control for Nonadministrative Users</a></p> </li> <li> <p><a href="#CACFCDBE">Creating Database Control Administrative Users</a></p> </li> <li> <p><a href="#BABDJJFF">Setting Database Control Preferences</a></p> </li> <li> <p><a href="#BABGJCIB">Administering the Database with SQL-Based Management Tools</a></p> </li> <li> <p><a href="#CACDGDHG">Getting Started with Oracle Enterprise Manager: Oracle By Example Series</a></p> </li> </ul> <a id="BABDIGDJ" name="BABDIGDJ"></a><a id="ADMQS037" name="ADMQS037"></a> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h2 class="sect1">Managing Your Database: A Roadmap</h2> <p>This section provides an overview of the tasks involved in managing an Oracle database instance. Each chapter in this guide describes a different task in detail.</p> <a id="ADMQS12132" name="ADMQS12132"></a> <p class="subhead2"><a id="sthref105" name="sthref105"></a>To manage your Oracle database:</p> <ol> <li> <p>Start the database instance.</p> <p>After the installation, your instance is started and your database is open. In the future, there will be times, perhaps for doing database maintenance or because of a power or media failure, that you shut down your database instance and later restart it.</p> <p>See <a href="instance.htm#CACCCCBC">"Shutting Down and Starting Up the Oracle Instance"</a>.</p> </li> <li> <p>Optionally, configure the network environment to enable clients to connect to your database.</p> <p>See <a href="network.htm#CHDFHIFE">Chapter 4, "Configuring the Network Environment"</a>.</p> </li> <li> <p>Review your database storage structures: tablespaces and data files, online redo log files, and control files. Create or modify storage structures as needed.</p> <p>See <a href="storage.htm#CHDIFFDC">Chapter 6, "Managing Database Storage Structures"</a>.</p> </li> <li> <p>Review memory allocation and adjust as needed.</p> <p>See <a href="instance.htm#CACBFIED">"Managing Memory"</a>.</p> </li> <li> <p>Review, unlock, and reset passwords for predefined database users as needed. Create new users, and assign privileges and roles to them.</p> <p>See <a href="users_secure.htm#CHDJBHHI">Chapter 7, "Administering User Accounts and Security"</a>.</p> </li> <li> <p>Create the necessary schema objects, including tables, views, and indexes. Populate the tables with data.</p> <p>See <a href="schema.htm#CFHJAHAA">Chapter 8, "Managing Schema Objects"</a>.</p> </li> <li> <p>Create or review the backup strategy for the database and back up the database.</p> <p>See <a href="backrest.htm#CIHEHFJJ">Chapter 9, "Performing Backup and Recovery"</a>.</p> </li> <li> <p>Enable archiving of online redo log files, if not already done.</p> <p>See <a href="backrest.htm#CHDJHFDB">"Configuring Recovery Settings"</a>.</p> </li> <li> <p>Monitor database performance, diagnose performance problems, and tune the database as necessary.</p> <p>See <a href="montune.htm#CHDDAFBD">Chapter 10, "Monitoring and Tuning the Database"</a>.</p> </li> <li> <p>Investigate, gather diagnostic data for, and report to Oracle Support Services any critical database errors.</p> <p>See <a href="problems.htm#CHDGJDHG">Chapter 11, "Investigating, Reporting, and Resolving Problems"</a>.</p> </li> <li> <p>Keep Oracle Database software up-to-date with the latest patch releases.</p> <p>See <a href="software.htm#CHDBJFDC">Chapter 12, "Managing Oracle Database Software"</a>.</p> </li> </ol> </div> <!-- class="sect1" --> <a id="BABCGBJF" name="BABCGBJF"></a><a id="ADMQS031" name="ADMQS031"></a> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h2 class="sect1">Introduction <a id="sthref106" name="sthref106"></a>to Oracle Enterprise Manager Database Control</h2> <p>Oracle Enterprise Manager Database Control (Database Control) is the primary tool for managing your Oracle database. It is installed with the database.</p> <p>Using <a id="sthref107" name="sthref107"></a>Database Control, you can perform administrative tasks such as creating schema objects (tables, views, indexes, and so on), managing user security, managing database memory and storage, backing up and recovering your database, and importing and exporting data. You can also view performance and status information about your database.</p> <a id="ADMQS12308" name="ADMQS12308"></a> <p class="subhead2">Database Home Page</p> <p>The main page for database administration is the Database Home page. This is the page that loads when you log in to Database Control. See <a href="#BABHJAGE">"Accessing the Database Home Page"</a>.</p> <a id="ADMQS12309" name="ADMQS12309"></a> <p class="subhead2">Online Help</p> <p><a id="sthref108" name="sthref108"></a>You can access context-sensitive online help by clicking the <span class="bold">Help</span> link displayed at the top of every page. On any help page, click <span class="bold">Contents</span> for links to all help topics. A search facility enables you to search the contents of online help.</p> <a id="ADMQS12310" name="ADMQS12310"></a> <p class="subhead2">Navigation</p> <p>Navigational features of Database Control include the following:</p> <ul> <li> <p>Subpage links at the top of the page. These links take you to the various Database Control subpages that organize management tasks into distinct categories. For example, you click <span class="bold">Availability</span> to perform tasks associated with backing up and recovering your data.</p> <img width="661" height="51" src="img/hp-propertypages.gif" alt="Description of hp-propertypages.gif follows" title="Description of hp-propertypages.gif follows" longdesc="img_text/hp-propertypages.htm" /><br /> <a id="sthref109" name="sthref109" href="img_text/hp-propertypages.htm">Description of the illustration hp-propertypages.gif</a><br /> <br /></li> <li> <p>Drill-down links that provide increasing levels of detail.</p> <img width="262" height="59" src="img/drilldownlink.gif" alt="Description of drilldownlink.gif follows" title="Description of drilldownlink.gif follows" longdesc="img_text/drilldownlink.htm" /><br /> <a id="sthref110" name="sthref110" href="img_text/drilldownlink.htm">Description of the illustration drilldownlink.gif</a><br /> <br /> <p>For example, clicking the link next to the label Host provides additional details about the computer on which the database runs.</p> </li> <li> <p>Suggested related links for more information.</p> <img width="589" height="153" src="img/hp_relatedlinks.gif" alt="Description of hp_relatedlinks.gif follows" title="Description of hp_relatedlinks.gif follows" longdesc="img_text/hp_relatedlinks.htm" /><br /> <a id="sthref111" name="sthref111" href="img_text/hp_relatedlinks.htm">Description of the illustration hp_relatedlinks.gif</a><br /> <br /></li> </ul> </div> <!-- class="sect1" --> <a id="CACHIJDC" name="CACHIJDC"></a><a id="ADMQS12369" name="ADMQS12369"></a> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h2 class="sect1">Configuring the Operating System Environment Variables</h2> <p>Before using certain tools that access the Oracle database, such as SQL*Plus, you must configure environment variables for your operating system. These environment variables are used by Oracle Database to determine the database instance to which the tool should connect.</p> <a id="ADMQS12370" name="ADMQS12370"></a> <p class="subhead2">To configure operating system environment variables for your database instance on Linux and UNIX systems:</p> <ol> <li> <p>Open an operating system command window.</p> </li> <li> <p>Ensure that the environment variables <code>ORACLE_HOME</code> and <code>ORACLE_SID</code> are set properly. The commands to use to set these environment variables depend on the shell you use to interface with the operating system. For example:</p> <ul> <li> <p>(bash or ksh) <code>export ORACLE_SID=orcl</code></p> </li> <li> <p>(csh or tcsh) <code>setenv ORACLE_SID=orcl</code></p> </li> </ul> <p>You can set these with the scripts <code>coraenv</code> (for the C shell) and <code>oraenv</code> (for other shells). These scripts are typically located in the <code>/usr/local/bin</code> directory.</p> </li> <li> <p>Ensure that the <code>$ORACLE_HOME/bin</code> directory is in your <code>PATH</code> environment variable.</p> </li> <li> <p>You can also edit the profile file for your default shell in the home directory of the software owner, for example <code>/home/oracle</code>, so that these environment variables are set every time you log in as that user.</p> </li> </ol> <a id="ADMQS12371" name="ADMQS12371"></a> <p class="subhead2">To configure operating system environment variables for your database instance on Windows systems:</p> <ol> <li> <p>Open an operating system command window.</p> </li> <li> <p>Use either <code>regedit</code> or the Oracle Administration Assistant for Windows to make sure the <code>ORACLE_HOME</code> and <code>ORACLE_SID</code> parameters are set to the correct values in the <code>HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_HOME_NAME</code> registry subkey.</p> </li> <li> <p>Ensure that the <code>%ORACLE_HOME%\bin</code> directory is in your <code>PATH</code> environment variable. At a command prompt, use a command similar to the following:</p> <pre xml:space="preserve" class="oac_no_warn">set PATH=%ORACLE_HOME%\bin;%PATH% </pre></li> </ol> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <ul> <li> <p><a class="olink UNXAR001" href="http://www.oracle.com/pls/db112/lookup?id=UNXAR001"><span class="italic">Oracle Database Administrator's Reference for Linux and UNIX</span></a> for more information about setting environment variables</p> </li> <li> <p><a class="olink NTQRF180" href="../../win.112/e10845/registry.htm#NTQRF180"><span class="italic">Oracle Database Platform Guide for Microsoft Windows</span></a> for details on modifying the registry entries</p> </li> </ul> </div> </div> <!-- class="sect1" --> <a id="BABBAIHD" name="BABBAIHD"></a><a id="ADMQS032" name="ADMQS032"></a> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h2 class="sect1">Starting and Stopping the Database Control Console Process</h2> <p>To <a id="sthref112" name="sthref112"></a><a id="sthref113" name="sthref113"></a>access Oracle Enterprise Manager Database Control (Database Control) from a browser, the Database Control console process <code>dbconsole</code> must be running on the database host computer. The <code>dbconsole</code> process is automatically started after installation. However, if the system must be restarted, you can start the <code>dbconsole</code> process manually at the command line or start it as a service in Windows. You can also run commands to stop the <code>dbconsole</code> process or view its status. If the <code>dbconsole</code> process is stopped, then it must be manually restarted before you use Database Control.</p> <a id="ADMQS12133" name="ADMQS12133"></a> <p class="subhead2">To start or stop, or to view the status of the dbconsole process from the command line:</p> <ol> <li> <p>Configure the operating system environment variables, as described in <a href="#CACHIJDC">"Configuring the Operating System Environment Variables"</a>.</p> </li> <li> <p>Do one of the following:</p> <ul> <li> <p>To start the <code>dbconsole</code> process, run the following command:</p> <pre xml:space="preserve" class="oac_no_warn">./emctl start dbconsole </pre></li> <li> <p>To stop the <code>dbconsole</code> process, run the following command:</p> <pre xml:space="preserve" class="oac_no_warn">./emctl stop dbconsole </pre></li> <li> <p>To view the status of the <code>dbconsole</code> process, run the following command:</p> <pre xml:space="preserve" class="oac_no_warn">./emctl status dbconsole </pre></li> </ul> <div class="infoboxnote"> <p class="notep1">Note:</p> If you are prompted to set the <code>ORACLE_UNQNAME</code> environment variable, then set this variable and run the <code>emctl</code> command again. Set the variable to the database unique name (the value of the <code>DB_UNIQUE_NAME</code> database parameter). A typical value for <code>DB_UNIQUE_NAME</code> is <code>orcl</code>.</div> </li> </ol> <a id="ADMQS12134" name="ADMQS12134"></a> <p class="subhead2">To start or stop dbconsole as a service on Microsoft Windows:</p> <ol> <li> <p>Do one of the following:</p> <ul> <li> <p>On Windows XP and Windows Server 2003, click <span class="bold">Start</span>, and then select <span class="bold">Control Panel</span>.</p> </li> <li> <p>On Windows 2000 Server, click <span class="bold">Start</span>, select <span class="bold">Settings</span>, and then select <span class="bold">Control Panel</span>.</p> </li> </ul> <p>The Control Panel window opens.</p> </li> <li> <p>Double-click the <span class="bold">Administrative Tools</span> icon, and then double-click the <span class="bold">Services</span> icon.</p> <p>The Services window opens.</p> <p>Oracle Database services begin with <code>Oracle</code>. The <code>dbconsole</code> service is listed as <code>OracleDBConsole</code><code><span class="codeinlineitalic">Oracle_sid</span></code>, where <code><span class="codeinlineitalic">Oracle_sid</span></code> is the system identifier (SID) for your database instance. The status of this process (either started or stopped) is listed in the Status column.</p> </li> <li> <p>Double-click the <code>OracleDBConsole</code><code><span class="codeinlineitalic"><code><span class="codeinlineitalic">Oracle_sid</span></code></span></code> service.</p> <p>The service properties window opens.</p> </li> <li> <p>In the Startup Type list, ensure that either <span class="bold">Manual</span> or <span class="bold">Automatic</span> is selected.</p> </li> <li> <p>Do one of the following:</p> <ul> <li> <p>To start <code>dbconsole</code>, click <span class="bold">Start</span>, and then click <span class="bold">OK</span>.</p> </li> <li> <p>To stop <code>dbconsole</code>, click <span class="bold">Stop</span>, and then click <span class="bold">OK</span>.</p> </li> </ul> </li> </ol> </div> <!-- class="sect1" --> <a id="BABHJAGE" name="BABHJAGE"></a><a id="ADMQS033" name="ADMQS033"></a> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h2 class="sect1">Accessing the Database Home Page</h2> <p>The Database Home page is the main database management page in Oracle Enterprise Manager Database Control (Database Control).</p> <a id="ADMQS12135" name="ADMQS12135"></a> <p class="subhead2">To access the Database Home page:</p> <ol> <li> <p>Ensure that the <code>dbconsole</code> process is running on the database host computer.</p> <p>See <a href="#BABBAIHD">"Starting and Stopping the Database Control Console Process"</a>.</p> </li> <li> <p>In your Web browser, enter the following URL:</p> <pre xml:space="preserve" class="oac_no_warn">https://<span class="italic">hostname:portnumber</span>/em </pre> <p>For example, if you installed the database on a host computer named <code>comp42.example.com</code>, and the installer indicated that your Enterprise Manager Console HTTP port number is <code>1158</code>, then enter the following URL:</p> <pre xml:space="preserve" class="oac_no_warn">https://comp42.example.com:1158/em </pre> <p>If you have recently installed Oracle Database, you can determine the port number for Database Control on Linux and UNIX systems by viewing the <code>$ORACLE_HOME/install/portlist.ini</code> file. Otherwise, you can determine the port number for Database Control by searching for <code>REPOSITORY_URL</code> in the <code>$ORACLE_HOME/</code><code><span class="codeinlineitalic">Oracle_sid</span></code><code>/sysman/config/emd.properties</code> file, where <code><span class="codeinlineitalic">Oracle_sid</span></code> is the system identifier (SID) for your database instance.</p> <p>If the database instance is running, then the Login page appears when you access Database Control. If the database is down and must be restarted, Database Control displays the Startup/Shutdown and Perform Recovery page.</p> <p>You must do the following to start the database:</p> <ol> <li> <p>Click <span class="bold">Startup/Shutdown</span>, enter the host login user name and password, and then enter the database login user name and password.</p> <p>For the database user name and password, enter <code>SYS</code> and the password that you specified during installation.</p> </li> <li> <p>Click <span class="bold">OK</span> to start the database instance, and then in the Confirmation page, click <span class="bold">Yes</span> to start the database in open mode.</p> </li> </ol> </li> <li> <p>Log in to the database with a user account that is authorized to access Database Control.</p> <p>This user initially could be <code>SYS</code> or <code>SYSTEM</code>, with the password that you specified during database installation.</p> <p>While the <code>SYSTEM</code> account can be used to perform day-to-day administrative tasks, Oracle strongly recommends creating a named user accounts for administering the Oracle database to enable monitoring of database activity. To back up, recover, or upgrade the database, you must log in as a SYSDBA user.</p> <p>Database Control displays the Database Home page.</p> </li> </ol> <img width="931" height="751" src="img/homepage_small.gif" alt="Description of homepage_small.gif follows" title="Description of homepage_small.gif follows" longdesc="img_text/homepage_small.htm" /><br /> <a id="sthref114" name="sthref114" href="img_text/homepage_small.htm">Description of the illustration homepage_small.gif</a><br /> <br /> <p>The subpage links across the top of the page enable you to access performance, availability, and other administration pages to manage your database. The features provided by these pages are discussed in other sections of this documentation.</p> <p>The various sections of the Database Home page provide information about the environment and status of the database. For example, the Alerts and Diagnostic Summary sections warn you of errors and performance problems that are impacting the operation of your database. You can click the provided links to see more detail about the problem areas, and, in some cases, to obtain recommendations for resolving the problems. These topics are discussed in <a href="montune.htm#CHDDAFBD">Chapter 10, "Monitoring and Tuning the Database"</a>.</p> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <ul> <li> <p><a href="#BABBAIHD">"Starting and Stopping the Database Control Console Process"</a></p> </li> <li> <p><a class="olink TDPSG20030" href="http://www.oracle.com/pls/db112/lookup?id=TDPSG20030"><span class="italic">Oracle Database 2 Day + Security Guide</span></a></p> </li> </ul> </div> </div> <!-- class="sect1" --> <a id="BABHCDGA" name="BABHCDGA"></a><a id="ADMQS12090" name="ADMQS12090"></a> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h2 class="sect1">Granting Access to Database Control for Nonadministrative Users</h2> <p>As a database administrator, you can log in to Oracle Enterprise Manager Database Control (Database Control) with the <code>SYS</code> or <code>SYSTEM</code> user account to perform administrative and other tasks. Nonadministrative users may also want to log in to Database Control. For example, application developers may want to take advantage of the Database Control interface to create or modify tables, indexes, views, and so on. You must grant access to Database Control to these users before they can log in.</p> <p><a id="sthref115" name="sthref115"></a>For nonadministrative users to have access to Database Control, they must be granted the <code>SELECT_CATALOG_ROLE</code> role. See <a href="users_secure.htm#CHDBDBGI">"Example: Granting Privileges and Roles to a User Account"</a>.</p> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <a class="olink TDPSG20030" href="http://www.oracle.com/pls/db112/lookup?id=TDPSG20030"><span class="italic">Oracle Database 2 Day + Security Guide</span></a></div> </div> <!-- class="sect1" --> <a id="CACFCDBE" name="CACFCDBE"></a><a id="ADMQS034" name="ADMQS034"></a> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h2 class="sect1">Creating Database Control Administrative Users</h2> <p><a id="sthref116" name="sthref116"></a><a id="sthref117" name="sthref117"></a><a id="sthref118" name="sthref118"></a><a id="sthref119" name="sthref119"></a><a id="sthref120" name="sthref120"></a><a id="sthref121" name="sthref121"></a>When you log in to Oracle Enterprise Manager Database Control (Database Control) using the <code>SYS</code>, <code>SYSTEM</code>, or <code>SYSMAN</code> user accounts, you are logging in as the Database Control super user. These are the only accounts that are automatically granted the roles and privileges required to administer Database Control itself. Examples of Database Control administration tasks include the following:</p> <ul> <li> <p>Creating other Database Control administrators</p> </li> <li> <p>Configuring e-mail and other notification methods</p> <p>See <a href="montune.htm#CBBDBJFI">"Setting Up Direct Alert Notification"</a>.</p> </li> <li> <p>Setting alert thresholds for database metrics, such as <code>tablespace space usage percentage exceeded</code> or <code>SQL response time exceeded</code></p> <p>See <a href="montune.htm#CACCIHAB">"Managing Alerts"</a>.</p> </li> <li> <p>Selecting database policies to apply, so that Database Control can show alerts if a policy is violated. (An example policy is "A nonsystem user cannot use the <code>SYSTEM</code> or <code>SYSAUX</code> tablespace as its default tablespace.")</p> </li> <li> <p>Defining <span class="bold">blackouts</span>, which are time periods in which database monitoring is suspended so that maintenance operations do not skew monitoring data or generate needless alerts.</p> <p>See <a href="#g1092839">"Defining Blackout Periods"</a>.</p> </li> </ul> <p>You can create Database Control administrative users who have enough privileges to administer Database Control itself, but lack the high-level database administration privileges of the <code>SYS</code> and <code>SYSTEM</code> users. This practice enables you to assign the minimum privileges required for other Database Control administrators to do their jobs, which is a best practice for database security. You can also create a Database Control administrative account for yourself, thus avoiding logging in as <code>SYS</code> or <code>SYSTEM</code> until you must perform database administration tasks.</p> <p><a id="sthref122" name="sthref122"></a>Using the following procedure, you can assign Database Control administrative privileges to an existing database user or create a new Database Control administrative user. When you create a new Database Control administrative user, a user account is created for that user for the database. You must then decide which system privileges, object privileges, or roles to grant the user, if any, to perform database administration tasks.</p> <a id="ADMQS12136" name="ADMQS12136"></a> <p class="subhead2">To create a Database Control administrative user:</p> <ol> <li> <p>On any Database Control page, at the top of the page, click <span class="bold">Setup</span>.</p> <p>The Enterprise Manager Configuration page appears, showing the Overview of Setup page.</p> </li> <li> <p>In the left navigation bar, click <span class="bold">Administrators</span>.</p> <p>The Administrators page appears.</p> <img width="729" height="218" src="img/em_admin_create.gif" alt="Description of em_admin_create.gif follows" title="Description of em_admin_create.gif follows" longdesc="img_text/em_admin_create.htm" /><br /> <a id="sthref123" name="sthref123" href="img_text/em_admin_create.htm">Description of the illustration em_admin_create.gif</a><br /> <br /></li> <li> <p>Click <span class="bold">Create</span>.</p> <p>The Create Administrator: Properties page appears.</p> <img width="691" height="205" src="img/em_admin_create_properties.gif" alt="Description of em_admin_create_properties.gif follows" title="Description of em_admin_create_properties.gif follows" longdesc="img_text/em_admin_create_properties.htm" /><br /> <a id="sthref124" name="sthref124" href="img_text/em_admin_create_properties.htm">Description of the illustration em_admin_create_properties.gif</a><br /> <br /></li> <li> <p>In the <span class="bold">Name</span> field, enter the name of an existing database user, or click the flashlight icon next to the field and select an existing database user.</p> </li> <li> <p>Enter one or more e-mail addresses for this administrator only if you plan to set up e-mail notifications for the database.</p> <p>See <a href="montune.htm#CBBDBJFI">"Setting Up Direct Alert Notification"</a> for more information.</p> </li> <li> <p>Click <span class="bold">Review</span> to view a page that summarizes the information that you entered.</p> </li> <li> <p>Click <span class="bold">Finish</span> to configure the database user as a Database Control administrative user.</p> <p>The Administrators page appears, showing the new administrator in the list.</p> </li> </ol> </div> <!-- class="sect1" --> <a id="BABDJJFF" name="BABDJJFF"></a><a id="ADMQS035" name="ADMQS035"></a> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h2 class="sect1">Setting Database Control Preferences</h2> <p>This section discusses setting user preferences for Oracle Enterprise Manager Database Control (Database Control). It contains the following topics:</p> <ul> <li> <p><a href="#BABEGIII">About Database Control Preferences</a></p> </li> <li> <p><a href="#g1092839">Defining Blackout Periods</a></p> </li> <li> <p><a href="#g1092758">Setting Preferred Credentials</a></p> </li> </ul> <a id="BABEGIII" name="BABEGIII"></a><a id="ADMQS12034" name="ADMQS12034"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2">About Database Control Preferences</h3> <p>Database Control enables you to set user preferences in the following areas:</p> <a id="ADMQS12137" name="ADMQS12137"></a><a id="sthref125" name="sthref125"></a> <p class="subhead2">Notification</p> <p><a id="sthref126" name="sthref126"></a>These settings enable Database Control to e-mail you alerts. Alerts are notifications that the database is in an undesirable state and needs your attention. By default, the Database Home page lists all alerts. However, setup is required for e-mail notification. For more information about alerts and setting up notifications, see <a href="montune.htm#CBBDBJFI">"Setting Up Direct Alert Notification"</a>.</p> <a id="ADMQS12138" name="ADMQS12138"></a><a id="sthref127" name="sthref127"></a> <p class="subhead2">Blackout Administration</p> <p><a id="sthref128" name="sthref128"></a>Blackouts suspend the collection of database monitoring data and the sending of alerts by Database Control. Blackouts enable you to perform scheduled maintenance on the database without receiving needless alerts and without skewing the monitoring data.</p> <p>For example, you can stop data collections during a database backup or a hardware upgrade. If you continue monitoring during these periods, then the collected data shows trends and other monitoring information that is not the result of typical day-to-day operations. To get a more accurate, long-term picture of database performance, you can use blackouts to exclude these special-case situations from data analysis. See <a href="#g1092839">"Defining Blackout Periods"</a> for more information.</p> <a id="ADMQS12139" name="ADMQS12139"></a><a id="sthref129" name="sthref129"></a> <p class="subhead2">Preferred Credentials</p> <p>Database Control can automatically execute many routine administrative tasks, such as backups. You can use a job scheduling system that is built into Database Control for these routine tasks. To keep your environment secure, setting up tasks for automatic execution in Enterprise Manager requires you to provide login information for the host computer and database. To avoid entering this information every time you create or run a job or task, Database Control enables you to save this information as preferred credentials. Preferred credentials are stored in the database in encrypted mode to protect them from unauthorized use. See <a href="#g1092758">"Setting Preferred Credentials"</a>.</p> </div> <!-- class="sect2" --> <a id="g1092839" name="g1092839"></a><a id="ADMQS0351" name="ADMQS0351"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2">Defining Blackout Periods</h3> <p><a id="sthref130" name="sthref130"></a>You can define one or more one-time or repeating blackout periods during which collection of database monitoring information and the sending of alerts are suspended.</p> <a id="ADMQS12140" name="ADMQS12140"></a> <p class="subhead2">To define a blackout period:</p> <ol> <li> <p>On any Database Control page, at the top of the page, click <span class="bold">Setup</span>.</p> <p>The Enterprise Manager Configuration page appears, showing the Overview of Setup page.</p> </li> <li> <p>In the left-hand pane, click <span class="bold">Blackouts</span>.</p> <p>The Blackouts page appears.</p> </li> <li> <p><a id="sthref131" name="sthref131"></a>Click <span class="bold">Create</span> to start the Create Blackout wizard.</p> <p>The Create Blackout: Properties page appears.</p> <img width="684" height="646" src="img/em_blackout_properties.gif" alt="Description of em_blackout_properties.gif follows" title="Description of em_blackout_properties.gif follows" longdesc="img_text/em_blackout_properties.htm" /><br /> <a id="sthref132" name="sthref132" href="img_text/em_blackout_properties.htm">Description of the illustration em_blackout_properties.gif</a><br /> <br /></li> <li> <p>(Optional) Replace the default blackout name with one of your choosing.</p> </li> <li> <p>(Optional) In the <span class="bold">Comments</span> field, enter text that describes the purpose of the blackout.</p> </li> <li> <p>In the <span class="bold">Reason</span> list, select the blackout reason that is most appropriate.</p> </li> <li> <p>In the Available Targets section, in the Type list, select <span class="bold">Database Instance</span>.</p> <p>The fully qualified name for your database instance appears in the Available Targets list.</p> </li> <li> <p>In the Available Targets list, select your instance, and then click the <span class="bold">Move</span> icon.</p> <div class="infoboxnote"> <p class="notep1">Note:</p> You can also double-click the instance name.</div> <p>The instance name is moved from the Available Targets list to the Selected Targets list.</p> </li> <li> <p>Click <span class="bold">Next</span>.</p> <p>The Create Blackout Schedule page appears.</p> <img width="788" height="511" src="img/em_blackout_schedule.gif" alt="Description of em_blackout_schedule.gif follows" title="Description of em_blackout_schedule.gif follows" longdesc="img_text/em_blackout_schedule.htm" /><br /> <a id="sthref133" name="sthref133" href="img_text/em_blackout_schedule.htm">Description of the illustration em_blackout_schedule.gif</a><br /> <br /></li> <li> <p>On the Create Blackout Schedule page, do the following:</p> <ol> <li> <p>In the Start section, schedule the blackout either immediately or for a later date and time.</p> </li> <li> <p>In the Duration section, indicate the duration of the blackout.</p> </li> <li> <p>To repeat the blackout periodically, in the Repeating section, select a repeat frequency from the Repeat list. Otherwise, use the default value of Do Not Repeat.</p> </li> </ol> </li> <li> <p>Click <span class="bold">Next</span>.</p> <p>The review page appears.</p> <p>Review what you have entered. You can click <span class="bold">Back</span> to change a setting.</p> </li> <li> <p>Click <span class="bold">Finish</span>.</p> <p>The Confirmation heading appears on the Blackouts page, and the new blackout period is shown in the list.</p> </li> </ol> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <ul> <li> <p><a href="montune.htm#CBBGDIBJ">"About Alerts"</a></p> </li> </ul> </div> </div> <!-- class="sect2" --> <a id="g1092758" name="g1092758"></a><a id="ADMQS0352" name="ADMQS0352"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2">Setting Preferred Credentials</h3> <p>When you set preferred credentials, Database Control automatically fills in host computer and database login credentials for you at times when it usually prompts for these credentials. Database Control also fills in these credentials when it is about to run a job that requires credentials.</p> <a id="ADMQS12141" name="ADMQS12141"></a> <p class="subhead2">To set preferred credentials for the database:</p> <ol> <li> <p>From any Database Control page, at the top of the page, click <span class="bold">Preferences</span>.</p> <p>The Preferences page appears.</p> </li> <li> <p>Click <span class="bold">Preferred Credentials</span> in the left-hand pane.</p> <p>The Preferred Credentials page appears, showing a table of targets.</p> <img width="620" height="212" src="img/em_pref_credentials.gif" alt="Description of em_pref_credentials.gif follows" title="Description of em_pref_credentials.gif follows" longdesc="img_text/em_pref_credentials.htm" /><br /> <a id="sthref134" name="sthref134" href="img_text/em_pref_credentials.htm">Description of the illustration em_pref_credentials.gif</a><br /> <br /></li> <li> <p>In the table row for the Database Instance, click the icon under <span class="bold">Set Credentials</span>.</p> <p>The Database Preferred Credentials page appears.</p> </li> <li> <p>Enter the following credentials:</p> <ul> <li> <p>Database credentials for <span class="bold">Username/Password</span> and <span class="bold">SYSDBA Username/SYSDBA Password</span></p> </li> <li> <p>Host credentials for <span class="bold">Host Username/Host Password</span></p> </li> </ul> <p>For example, you might typically connect as the user <code>SYSTEM</code>, use the <code>SYS</code> account for <code>SYSDBA</code> access, and use <code>oracle</code> for the host user name.</p> <div class="infoboxnote"> <p class="notep1">Note:</p> The host user may require certain host privileges to run background jobs such as database backups. For example, on UNIX and Linux, the host user must belong to the <code>OSDBA</code> group (typically <code>dba</code>). On Windows, the host user must be a member of the <code>Administrators</code> group and must be granted the <code>Log</code> <code>on</code> <code>as</code> <code>batch</code> <code>job</code> logon right. See your platform documentation for more information.</div> </li> <li> <p>Click <span class="bold">Test</span> to test your credentials.</p> <p>A confirmation message is displayed if your credentials can be verified.</p> </li> <li> <p>Click <span class="bold">Apply</span> to apply the changes.</p> </li> </ol> </div> <!-- class="sect2" --></div> <!-- class="sect1" --> <a id="BABGJCIB" name="BABGJCIB"></a><a id="ADMQS12035" name="ADMQS12035"></a> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h2 class="sect1">Administering the Database with SQL-Based Management Tools</h2> <p>In addition to using the graphical user interface (GUI) pages presented in Database Control, you can use other Oracle tools such as SQL Developer and SQL*Plus to administer your database. These tools enable you to perform database management operations, and to query, insert, update, or delete data directly in the database.</p> <p>The following sections provide details:</p> <ul> <li> <p><a href="#BABICEGA">About SQL</a></p> </li> <li> <p><a href="#BABCGECF">About SQL*Plus</a></p> </li> <li> <p><a href="#BABDJBCJ">Starting SQL*Plus and Connecting to the Database</a></p> </li> <li> <p><a href="#BABGEGFB">About SQL Developer</a></p> </li> </ul> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <ul> <li> <p><a class="olink TDDDG12200" href="http://www.oracle.com/pls/db112/lookup?id=TDDDG12200"><span class="italic">Oracle Database 2 Day Developer's Guide</span></a></p> </li> <li> <p><a class="olink SQLRF" href="http://www.oracle.com/pls/db112/lookup?id=SQLRF"><span class="italic">Oracle Database SQL Language Reference</span></a></p> </li> </ul> </div> <a id="BABICEGA" name="BABICEGA"></a><a id="ADMQS12311" name="ADMQS12311"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2">About SQL</h3> <p>To perform many of its operations, Oracle Enterprise Manager Database Control (Database Control) submits<a id="sthref135" name="sthref135"></a> structured query language (SQL) statements to the database. SQL (pronounced like <span class="italic">sequel</span>) is an industry-standard English-like computer programming language for querying and updating databases.</p> <p>The following is an example of a SQL query that lists information about countries in a countries table, which is owned by user <code>hr</code>:</p> <pre xml:space="preserve" class="oac_no_warn">SELECT COUNTRY_ID, COUNTRY_NAME FROM HR.COUNTRIES; </pre> <p>SQL is a powerful language that can also be used to perform a variety of database administration tasks. The following SQL statement creates the database user <code>nick</code> and assigns him a password of your choosing, represented by <span class="italic">password</span>:</p> <pre xml:space="preserve" class="oac_no_warn">CREATE USER nick IDENTIFIED BY <span class="italic">password</span>; </pre> <p>When performing an administrative task in Database Control, you can click <span class="bold">Show SQL</span> to see the SQL statements that Database Control generates and submits.</p> </div> <!-- class="sect2" --> <a id="BABCGECF" name="BABCGECF"></a><a id="ADMQS12312" name="ADMQS12312"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2">About SQL*Plus</h3> <p>SQL*Plus is a command-line program that you use to submit SQL and PL/SQL statements to an Oracle database. You can submit statements interactively or as SQL*Plus scripts. SQL*Plus is installed with the database and is located in your <code><span class="codeinlineitalic"><code><span class="codeinlineitalic">ORACLE_HOME</span></code></span></code><code>/bin</code> directory.</p> <p>You can start SQL*Plus from the command line, or on Microsoft Windows, from the Start menu.</p> <p>When SQL*Plus loads, it issues the SQL prompt, which looks like this:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> </pre> <p>At the SQL prompt, you can enter statements that perform administrative tasks such as shutting down the database or creating a new user, or you can query, insert, update, and delete data.</p> <p>You can enter a single SQL statement on multiple lines. You must end each statement with a semicolon (;). For most statements, you can rerun a statement by entering a slash (/) on a line by itself.</p> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <ul> <li> <p><a class="olink SQPUG" href="http://www.oracle.com/pls/db112/lookup?id=SQPUG"><span class="italic">SQL*Plus User's Guide and Reference</span></a></p> </li> <li> <p><a class="olink CNCPT829" href="http://www.oracle.com/pls/db112/lookup?id=CNCPT829"><span class="italic">Oracle Database Concepts</span></a></p> </li> </ul> </div> </div> <!-- class="sect2" --> <a id="BABDJBCJ" name="BABDJBCJ"></a><a id="ADMQS0361" name="ADMQS0361"></a> <div class="sect2"> <h3 class="sect2">Starting SQL*Plus and Connecting to the Database</h3> <p>The section describes how to start SQL*Plus and connect to the database from both the command line and the Windows start menu.</p> <p>For a new installation, you connect to the database using either the <code>SYS</code> or <code>SYSTEM</code> database accounts. When you enter <code>SYS</code> or a slash (<code>/</code>) as the user name and provide the <code>AS</code> <code>SYSDBA</code> clause, your access is authenticated using operating system authentication. <span class="bold">Operating system authentication</span> uses your Windows, UNIX, or Linux host user account to authenticate you to Oracle Database. You must have logged in to the host computer with a user account that is a member of a special host user group. On UNIX and Linux, this user group is typically <code>dba</code>. This type of authentication enables you to connect to an Oracle database that is not yet started, so that you can start it up. See <a class="olink ADMIN11010" href="http://www.oracle.com/pls/db112/lookup?id=ADMIN11010"><span class="italic">Oracle Database Administrator's Guide</span></a> for more information.</p> <p>The following procedures show how to log in to the database as user <code>SYS</code> using the <code>SYSDBA</code> privilege.</p> <a id="ADMQS12142" name="ADMQS12142"></a> <p class="subhead2">To start SQL*Plus and connect to the database from the command line:</p> <ol> <li> <p>Open a command window.</p> </li> <li> <p>Configure the operating system environment variables, as described in <a href="#CACHIJDC">"Configuring the Operating System Environment Variables"</a>.</p> </li> <li> <p>Start SQL*plus using a command in the following format:</p> <pre xml:space="preserve" class="oac_no_warn">sqlplus {<span class="codeinlineitalic">username</span> | /} [as sysdba] </pre> <p>An example of this command is the following:</p> <pre xml:space="preserve" class="oac_no_warn">$ sqlplus / AS SYSDBA Enter password: <span class="italic">password</span> </pre> <p>For <code><span class="codeinlineitalic">username</span></code>, you can use the <code>SYS</code> or <code>SYSTEM</code> administrative users. At the prompt, enter the password that you set up during installation. If you use the <code>SYS</code> user, you must include <code>AS SYSDBA</code> after the username.</p> <p>SQL*Plus connects you to the default database instance (Microsoft Windows) or the database instance specified by environment variables (Linux and UNIX).</p> </li> </ol> <a id="ADMQS12143" name="ADMQS12143"></a> <p class="subhead2">To start SQL*Plus and connect to the database from the Windows Start menu:</p> <ol> <li> <p>Configure the operating system environment variables, as described in <a href="#CACHIJDC">"Configuring the Operating System Environment Variables"</a>.</p> </li> <li> <p>Click <span class="bold">Start</span>, select <span class="bold">Programs</span> (or <span class="bold">All Programs</span>), then <span class="bold">Oracle -</span> <span class="bolditalic">HOME_NAME</span>, then <span class="bold">Application</span> <span class="bold">Development</span>, and then <span class="bold">SQL*Plus</span>.</p> </li> <li> <p>When prompted, enter the <span class="bold">user name</span> and <span class="bold">password</span> for the account to use to connect to the database.</p> <p>For the user name, you can use the <code>SYS</code> or <code>SYSTEM</code> administrative accounts, and you can use the password that you set up during installation.</p> <p>If you use <code>SYS</code> or <code>/</code> as the user name, follow them with a space and then the clause <code>AS</code> <code>SYSDBA</code>, as shown in the following examples:</p> <pre xml:space="preserve" class="oac_no_warn">Enter user-name: SYS AS SYSDBA Enter password: <span class="italic">password</span> or Enter user-name: / AS SYSDBA </pre></li> </ol> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <ul> <li> <p><a href="network.htm#CIHJHJGJ">"Connecting to an Oracle Database from a Client Computer"</a></p> </li> <li> <p><a href="users_secure.htm#CHDFFCIG">"About Administrative Accounts and Privileges"</a></p> </li> <li> <p><a class="olink ADMIN00102" href="http://www.oracle.com/pls/db112/lookup?id=ADMIN00102"><span class="italic">Oracle Database Administrator's Guide</span></a></p> </li> <li> <p><a class="olink SQPUG" href="http://www.oracle.com/pls/db112/lookup?id=SQPUG"><span class="italic">SQL*Plus User's Guide and Reference</span></a></p> </li> <li> <p><a class="olink SQLRF" href="http://www.oracle.com/pls/db112/lookup?id=SQLRF"><span class="italic">Oracle Database SQL Language Reference</span></a></p> </li> </ul> </div> </div> <!-- class="sect2" --> <a id="BABGEGFB" name="BABGEGFB"></a><a id="ADMQS12036" name="ADMQS12036"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2">About SQL Developer</h3> <p>SQL Developer provides another GUI for accessing your Oracle database. SQL Developer supports development in both the SQL and PL/SQL languages. It is available in the default installation of Oracle Database.</p> <p>With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, also create and save your own.</p> <p>You can download SQL Developer from the Oracle Technology Network (OTN) Web site.</p> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <ul> <li> <p><a class="olink TDDDG12200" href="http://www.oracle.com/pls/db112/lookup?id=TDDDG12200"><span class="italic">Oracle Database 2 Day Developer's Guide</span></a> for instructions for starting SQL Developer</p> </li> <li> <p><a class="olink CNCPT7654" href="http://www.oracle.com/pls/db112/lookup?id=CNCPT7654"></a><span class="italic">Oracle Database Concepts</span> for more information about SQL Developer</p> </li> </ul> </div> </div> <!-- class="sect2" --></div> <!-- class="sect1" --> <a id="CACDGDHG" name="CACDGDHG"></a><a id="ADMQS038" name="ADMQS038"></a> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h2 class="sect1">Getting Started with Oracle Enterprise Manager: Oracle By Example Series</h2> <p>Oracle By Example (OBE) has a series on the <span class="italic">Oracle Database 2 Day DBA</span> guide. This OBE steps you through the tasks in this chapter and includes annotated screenshots.</p> <p>To view the Getting Started with Oracle Enterprise Manager OBE, in your browser, enter the following URL:</p> <p><code><a href="http://www.oracle.com/technology/obe/11gr2_2day_dba/gettingstatarted/gettingstarted.htm">http://www.oracle.com/technology/obe/11gr2_2day_dba/gettingstatarted/gettingstarted.htm</a></code></p> </div> <!-- class="sect1" --></div> <!-- class="ind" --> <div class="footer"> <hr /> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="33%" /> <col width="*" /> <col width="33%" /> <tr> <td align="left"> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="98"> <tr> <td align="center" valign="top"><a href="install.htm"><img width="24" height="24" src="../../dcommon/gifs/leftnav.gif" alt="Go to previous page" /><br /> <span class="icon">Previous</span></a></td> <td align="center" valign="top"><a href="network.htm"><img width="24" height="24" src="../../dcommon/gifs/rightnav.gif" alt="Go to next page" /><br /> <span class="icon">Next</span></a></td> </tr> </table> </td> <td style="font-size: 90%" align="center" class="copyrightlogo"><img width="144" height="18" src="../../dcommon/gifs/oracle.gif" alt="Oracle" /><br /> Copyright © 2004, 2009, Oracle and/or its affiliates. All rights reserved.<br /> <a href="../../dcommon/html/cpyr.htm">Legal Notices</a></td> <td align="right"> <table class="icons oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="245"> <tr> <td align="center" valign="top"><a href="../../index.htm"><img width="24" height="24" src="../../dcommon/gifs/doclib.gif" alt="Go to Documentation Home" /><br /> <span class="icon">Home</span></a></td> <td align="center" valign="top"><a href="../../nav/portal_booklist.htm"><img width="24" height="24" src="../../dcommon/gifs/booklist.gif" alt="Go to Book List" /><br /> <span class="icon">Book List</span></a></td> <td align="center" valign="top"><a href="toc.htm"><img width="24" height="24" src="../../dcommon/gifs/toc.gif" alt="Go to Table of Contents" /><br /> <span class="icon">Contents</span></a></td> <td align="center" valign="top"><a href="index.htm"><img width="24" height="24" src="../../dcommon/gifs/index.gif" alt="Go to Index" /><br /> <span class="icon">Index</span></a></td> <td align="center" valign="top"><a href="../../dcommon/html/feedback.htm"><img width="24" height="24" src="../../dcommon/gifs/feedbck2.gif" alt="Go to Feedback page" /><br /> <span class="icon">Contact Us</span></a></td> </tr> </table> </td> </tr> </table> </div> <noscript> <p>Scripting on this page enhances content navigation, but does not change the content in any way.</p> </noscript> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de