Edit D:\rfid\database\database\doc\install.112\e10843\startrdb.htm
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.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.1 Build 026" /> <meta name="Date" content="2010-03-23T20:31:35Z" /> <meta name="doctitle" content="Oracle® Database Installation Guide 11g Release 2 (11.2) for Microsoft Windows" /> <meta name="partno" content="E10843-03" /> <meta name="docid" content="NTDBI" /> <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="Glossary" href="glossary.htm" title="Glossary" type="text/html" /> <link rel="Prev" href="postcfg.htm" title="Previous" type="text/html" /> <link rel="Next" href="deinstall.htm" title="Next" type="text/html" /> <link rel="alternate" href="../e10843.pdf" title="PDF version" type="application/pdf" /> <title>Getting Started with Oracle Database</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 Installation Guide<br /> 11<i>g</i> Release 2 (11.2) for Microsoft Windows</b><br /> Part Number E10843-03</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="postcfg.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="deinstall.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="../e10843.pdf">View PDF</a></td> </tr> </table> <a name="BEGIN" id="BEGIN"></a></div> <div class="IND"><!-- End Header --><a id="BDCCGFFA" name="BDCCGFFA"></a><a id="i1006482" name="i1006482"></a> <h1 class="chapter"><span class="secnum">6</span> <a name="NTDBI005" id="NTDBI005"></a>Getting Started with Oracle Database</h1> <p><a id="ABC1244664" name="ABC1244664"></a><a id="ABC1244664SRI1" name="ABC1244664SRI1"></a>This chapter describes where to go after you have completed an Oracle Database installation, such as how to check the installed contents, start various tools, and identify and locate various files. It covers these topics:</p> <ul> <li> <p><a href="#CHDCADBD">Checking the Installed Oracle Database Contents and Directory Location</a></p> </li> <li> <p><a href="#BDCJJGDA">Logging in to Enterprise Manager Database Control</a></p> </li> <li> <p><a href="#CHDFJABD">Managing Automatic Storage Management</a></p> </li> <li> <p><a href="#CHDDEEAF">Starting and Stopping an Oracle Database</a></p> </li> <li> <p><a href="#CHDIIIDB">Accessing Oracle Database with SQL*Plus</a></p> </li> <li> <p><a href="#BDCCADCJ">Reviewing User Accounts and Passwords</a></p> </li> <li> <p><a href="#i1006051">Identifying Databases</a></p> </li> <li> <p><a href="#BDCFBGCH">Locating the Server Parameter File</a></p> </li> <li> <p><a href="#BDCFHCCJ">Identifying Tablespaces and Data Files</a></p> </li> <li> <p><a href="#BDCDEIDJ">Locating Redo Log Files</a></p> </li> <li> <p><a href="#BDCBJEEG">Locating Control Files</a></p> </li> <li> <p><a href="#i1006089">Understanding Oracle Database Services on Windows</a></p> </li> </ul> <a id="CHDCADBD" name="CHDCADBD"></a> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h2 class="sect1"><span class="secnum">6.1</span> Checking the Installed Oracle Database Contents and Directory Location</h2> <p><a id="sthref484" name="sthref484"></a>Use Oracle Universal Installer to check the contents and directory location of your Oracle Database installation.</p> <p>Follow these steps:</p> <ol> <li> <p>From the <span class="bold">Start</span> menu, select <span class="bold">Programs</span>, then <span class="bold">Oracle -</span> <span class="bolditalic">HOME_NAME</span>, then <span class="bold">Oracle Installation Products</span>, then <span class="bold">Universal Installer</span>.</p> </li> <li> <p>In the Welcome window, click <span class="bold">Installed Products</span> to display the Inventory dialog box.</p> </li> <li> <p>To check the installed contents, find the Oracle Database product in the list.</p> <p>To find additional information about an installed product, click <span class="bold">Details</span>.</p> </li> <li> <p>To check the directory location of the installed contents, click the <span class="bold">Environment</span> tab.</p> </li> <li> <p>Click <span class="bold">Close</span> to exit the Inventory dialog box.</p> </li> <li> <p>Click <span class="bold">Cancel</span> to exit Oracle Universal Installer, then click <span class="bold">Yes</span> to confirm.</p> </li> </ol> </div> <!-- class="sect1" --> <a id="BDCJJGDA" name="BDCJJGDA"></a> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h2 class="sect1"><span class="secnum">6.2</span> <a name="NTDBI0052" id="NTDBI0052"></a>Logging in to Enterprise Manager Database Control<a id="sthref485" name="sthref485"></a></h2> <p>Oracle Enterprise Manager Database Control provides a Web-based user interface that you can use to monitor, administer, and maintain an Oracle database, including Automatic Storage Management.</p> <p>To log in to Oracle Enterprise Manager Database Control:</p> <ol> <li> <p>Open your Web browser and enter the following URL:</p> <pre xml:space="preserve" class="oac_no_warn">https://<span class="italic">hostname</span>:<span class="italic">port</span>/em </pre> <pre xml:space="preserve" class="oac_no_warn"></pre> <p>In a default installation, the port number is 1158. If you are unsure of the correct port number to use, look for the following line in the <code><span class="codeinlineitalic">ORACLE_HOME</span></code><code>\install\portlist.ini</code> file:</p> <pre xml:space="preserve" class="oac_no_warn">Enterprise Manager Console HTTP Port (<span class="italic">dbhome_name</span>) = <span class="italic">port</span> </pre> <div class="infoboxnote"> <p class="notep1">Note:</p> The <code>portlist.ini</code> file is not updated if you change a port number after you install Oracle Database. <a href="ports.htm#BEHEFACG">"Changing the Oracle Enterprise Manager Database Control Ports"</a> explains how to find the Oracle Enterprise Manager Database Control port number in this situation.</div> <p>For example, if you installed the database on a host computer named <code>mgmt42</code>, and the port number listed in the <code>portlist.ini</code> file is 5500, then enter the following URL:</p> <pre xml:space="preserve" class="oac_no_warn">http://mgmt42:5500/em </pre> <pre xml:space="preserve" class="oac_no_warn"></pre> <p>Enterprise Manager displays the Database Control Login Page.</p> </li> <li> <p>Log in to the database using the user name <code>SYSTEM</code> and connect as <code>SYSDBA.</code> Enterprise Manager displays the Database Home page.</p> <p>Use the password that you specified for the <code>SYSTEM</code> account during the installation.</p> <div class="infoboxnote"> <p class="notep1">Note:</p> You can also log in to the Database Control using the <code>SYS</code>, <code>SYSTEM,</code>or <code>SYSMAN</code> accounts or you can grant login privileges to other database users.</div> </li> </ol> <div class="sect2"><a id="sthref486" name="sthref486"></a> <h3 class="sect2"><span class="secnum">6.2.1</span> Understanding Database Control Login Privileges<a id="sthref487" name="sthref487"></a></h3> <p>When you log in to Oracle Enterprise Manager Database Control using the <code>SYSMAN</code> user account, you are logging in as the Oracle Enterprise Manager super user. The <code>SYSMAN</code> account is automatically granted the roles and privileges required to access all the management functionality provided with Database Control.</p> <p>You can also use the <code>SYS</code> and <code>SYSTEM</code> accounts to log in to Database Control. In addition, you can grant login privileges to other database users. To grant management access for other database users, use the following procedure:</p> <ol> <li> <p>Log in to Database Control.</p> <div align="center"> <div class="inftblinformal"><br /> <table class="Informal oac_no_warn" summary="" border="1" width="80%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> <tbody> <tr align="left" valign="top"> <td align="left"> <p class="notep1">See Also:</p> <a href="#BDCJJGDA">"Logging in to Enterprise Manager Database Control"</a></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblinformal" --></div> </li> <li> <p>Click <span class="bold">Setup</span> at the top of the Database Control Home page.</p> </li> <li> <p>Click <span class="bold">Administrators</span> in the left navigation bar.</p> </li> <li> <p>Click <span class="bold">Create</span> to create an Enterprise Manager user.</p> </li> <li> <p>In the <span class="bold">Name</span> field, enter the user name of an existing database user, or click the flashlight icon and select a user from the pop-up window.</p> </li> <li> <p>Enter the password for this user, then click <span class="bold">Review</span>.</p> </li> <li> <p>On the properties page, click <span class="bold">Finish.</span></p> </li> </ol> <p>Enterprise Manager assigns login privileges to the specified user and includes this user in the list of Enterprise Manager users on the Setup Administrators page.</p> <p>To enable a nonadministrative user to log in to Database Control, the user must be granted the <code>SELECT ANY DICTIONARY</code> system privilege.</p> </div> <!-- class="sect2" --></div> <!-- class="sect1" --> <a id="CHDFJABD" name="CHDFJABD"></a> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h2 class="sect1"><span class="secnum">6.3</span> Managing Automatic Storage Management</h2> <p>This section covers the following topics:<a id="sthref488" name="sthref488"></a></p> <ul> <li> <p><a href="#BABFGCII">Starting and Stopping Automatic Storage Management</a></p> </li> <li> <p><a href="#BABFBIGB">Automatic Storage Management Utilities</a></p> </li> </ul> <a id="BABFGCII" name="BABFGCII"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2"><span class="secnum">6.3.1</span> Starting and Stopping Automatic Storage Management</h3> <p><a id="sthref489" name="sthref489"></a>To start and stop Automatic Storage Management, in addition to using SQL*Plus, you can use the <code>srvctl</code> utility.</p> <p>To start Automatic Storage Management instance using the <code>srvctl</code> utility, run the following command:</p> <pre xml:space="preserve" class="oac_no_warn">srvctl start asm </pre> <p>To stop Automatic Storage Management instance using the srvctl utility, run the following command:</p> <pre xml:space="preserve" class="oac_no_warn">srvctl stop asm </pre> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <span class="italic"><a class="olink OSTMG" href="http://www.oracle.com/pls/db112/lookup?id=OSTMG">Oracle Database Storage Administrator's Guide</a></span> for information about starting and stopping Automatic Storage Management instances by using SQL*Plus</div> </div> <!-- class="sect2" --> <a id="BABFBIGB" name="BABFBIGB"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2"><span class="secnum">6.3.2</span> Automatic Storage Management Utilities</h3> <p><a id="sthref490" name="sthref490"></a><a id="sthref491" name="sthref491"></a>To manage Automatic Storage Management, you can use the following tools:</p> <ul> <li> <p><a id="sthref492" name="sthref492"></a>asmcmd: This command-line tool lets you manage Automatic Storage Management disk group files and directories.</p> </li> <li> <p>asmtool: This command-line tool is required to stamp the disks to create or modify disk groups later on after the database installation.</p> </li> <li> <p><a id="sthref493" name="sthref493"></a><a id="sthref494" name="sthref494"></a>Automatic Storage Management Configuration Assistant: Automatic Storage Management Configuration Assistant (ASMCA) is an interactive utility that enables you to create an Automatic Storage Management instance or upgrade existing Automatic Storage Management instances. It also enables you to create and configure disk groups, Automatic Storage Management volumes and Automatic Storage Management File Systems (ASMFS).</p> </li> <li> <p>Oracle Enterprise Manager Grid Control: If you have Oracle Enterprise Manager installed, you can use Grid Control to manage Automatic Storage Management functions such as migrating an existing database to Automatic Storage Management, checking the status of the Automatic Storage Management instance, checking the performance of the Automatic Storage Management disk groups, creating or dropping Automatic Storage Management disk groups, and so on.</p> </li> <li> <p>Oracle Enterprise Manager Database Control: This utility lets you perform functions similar to Grid Control.</p> </li> <li> <p>SQL*Plus: You can use Automatic Storage Management-specific commands from this tool. To connect to the Automatic Storage Management instance, you use the same methods that you use to connect to an Oracle Database instance.</p> </li> </ul> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <ul> <li> <p><a href="#BDCJJGDA">"Logging in to Enterprise Manager Database Control"</a></p> </li> <li> <p><span class="italic"><a class="olink OSTMG" href="http://www.oracle.com/pls/db112/lookup?id=OSTMG">Oracle Database Storage Administrator's Guide</a></span> for more information about managing Automatic Storage Management</p> </li> <li> <p><span class="italic"><a class="olink SUTIL" href="http://www.oracle.com/pls/db112/lookup?id=SUTIL">Oracle Database Utilities</a></span> for more information about the <code>asmcmd</code> utility</p> </li> </ul> </div> </div> <!-- class="sect2" --></div> <!-- class="sect1" --> <a id="CHDDEEAF" name="CHDDEEAF"></a> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h2 class="sect1"><span class="secnum">6.4</span> Starting and Stopping an Oracle Database</h2> <p><a id="sthref495" name="sthref495"></a><a id="sthref496" name="sthref496"></a><a id="sthref497" name="sthref497"></a>You can start and stop an Oracle database by using any of the following methods:</p> <ul> <li> <p><a href="#CHDFCFAI">Starting and Stopping the Database with Oracle Enterprise Manager Database Control</a></p> </li> <li> <p><a href="#CHDGGDAB">Starting and Stopping the Database with Oracle Administration Assistant for Windows</a></p> </li> <li> <p><a href="#CHDFDIHI">Starting and Stopping the Database from the Microsoft Windows Services Utility</a></p> </li> </ul> <a id="CHDFCFAI" name="CHDFCFAI"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2"><span class="secnum">6.4.1</span> Starting and Stopping the Database with Oracle Enterprise Manager Database Control</h3> <p><a id="sthref498" name="sthref498"></a>To start or stop the database:</p> <ol> <li> <p>From a Web browser, start Enterprise Manager Database Control and log in, for example:</p> <pre xml:space="preserve" class="oac_no_warn">http://myserver:1158/em </pre> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <a href="#BDCJJGDA">"Logging in to Enterprise Manager Database Control"</a></div> </li> <li> <p>Click <span class="bold">Home</span> to go to the home page.</p> </li> <li> <p>Under General, click <span class="bold">Start</span> to start the database or click <span class="bold">Shutdown</span> to shut it down.</p> </li> </ol> </div> <!-- class="sect2" --> <a id="CHDGGDAB" name="CHDGGDAB"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2"><span class="secnum">6.4.2</span> Starting and Stopping the Database with Oracle Administration Assistant for Windows</h3> <p>To start or stop the database:</p> <ol> <li> <p>From the <span class="bold">Start</span> menu, select <span class="bold">Programs</span>, then <span class="bold">Oracle -</span> <span class="bolditalic">HOME_NAME</span>, then <span class="bold">Configuration and Migration Tools</span>, and then <span class="bold">Administrative Assistant for Windows</span>.</p> </li> <li> <p>In the console window, expand the Oracle Administration Assistant for Windows tree structure.</p> </li> <li> <p>Under Databases, right-click the name of the database, and from the menu, select from the following options:</p> <ul> <li> <p><span class="bold">Connect Database</span></p> </li> <li> <p><span class="bold">Start Service</span></p> </li> <li> <p><span class="bold">Disconnect Database</span></p> </li> <li> <p><span class="bold">Stop Service</span></p> </li> <li> <p><span class="bold">Startup/Shutdown Options</span></p> </li> </ul> </li> </ol> </div> <!-- class="sect2" --> <a id="CHDFDIHI" name="CHDFDIHI"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2"><span class="secnum">6.4.3</span> Starting and Stopping the Database from the Microsoft Windows Services Utility</h3> <p><a id="sthref499" name="sthref499"></a>You can use SQL or <code>srvctl</code> utility to start or stop the database instance. SRVCTL starts the service automatically.</p> <p>To use SQL to start the database instance, start the Windows services:</p> <ol> <li> <p>From the <span class="bold">Start</span> menu, select <span class="bold">Programs</span>, then <span class="bold">Administrative Tools</span>, and then <span class="bold">Services</span>.</p> </li> <li> <p>In the Services dialog box, locate the name of the database you want to start or stop.</p> </li> <li> <p>Right-click the name of the database, and from the menu, select either <span class="bold">Start</span>, <span class="bold">Stop</span>, or <span class="bold">Pause</span>.</p> <p>To set its startup properties, right-click <span class="bold">Properties</span>, and in the dialog box, select either <span class="bold">Automatic</span>, <span class="bold">Manual</span>, or <span class="bold">Disabled</span>.</p> </li> </ol> </div> <!-- class="sect2" --></div> <!-- class="sect1" --> <a id="CHDIIIDB" name="CHDIIIDB"></a> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h2 class="sect1"><span class="secnum">6.5</span> Accessing Oracle Database with SQL*Plus</h2> <p><a id="sthref500" name="sthref500"></a><a id="sthref501" name="sthref501"></a><a id="sthref502" name="sthref502"></a>To issue SQL and PL/SQL statements to Oracle Database, you can use SQL*Plus. This tool enables you to perform the same database management operations, and query, insert, update, or delete data directly in the database.</p> <p>To start SQL*Plus, from the Start menu, select <span class="bold">Programs</span>, then <span class="bold">Oracle</span> <span class="bolditalic">- HOME_NAME</span>, then <span class="bold">Application Development</span>, and then <span class="bold">SQL Plus</span>.</p> <p>Alternatively, at the command line, you can enter the following command at a Windows command prompt:</p> <pre xml:space="preserve" class="oac_no_warn">C:\> sqlplus /nolog SQL> CONNECT <span class="italic">user_name</span> Enter password: <span class="italic">password</span> </pre> <p>For example, to log on as SYSTEM using the password <code><span class="codeinlineitalic">password</span></code>, you enter:</p> <pre xml:space="preserve" class="oac_no_warn">C:\> sqlplus /nolog SQL> CONNECT SYSTEM Enter password: <span class="italic">password</span> </pre> <p>If you are logging on as <code>SYS</code>, you must connect as <code>SYSDBA</code>:</p> <pre xml:space="preserve" class="oac_no_warn">C:\> sqlplus /nolog SQL> CONNECT SYS AS SYSDBA Enter password: <span class="italic">password</span> </pre> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <ul> <li> <p><span class="italic"><a class="olink SQPUG" href="http://www.oracle.com/pls/db112/lookup?id=SQPUG">SQL*Plus User's Guide and Reference</a></span></p> </li> <li> <p><span class="italic"><a class="olink SQPQR" href="http://www.oracle.com/pls/db112/lookup?id=SQPQR">SQL*Plus Quick Reference</a></span></p> </li> <li> <p>"Connecting to the Database with SQL*Plus" in <span class="italic"><a class="olink ADMIN00102" href="http://www.oracle.com/pls/db112/lookup?id=ADMIN00102">Oracle Database Administrator's Guide</a></span> for more information about accessing Oracle Database using SQL*Plus.</p> </li> </ul> </div> </div> <!-- class="sect1" --> <div class="sect1"><!-- infolevel="all" infotype="General" --><a id="sthref503" name="sthref503"></a> <h2 class="sect1"><span class="secnum">6.6</span> Accessing Oracle Database with SQL Developer</h2> <p><a id="sthref504" name="sthref504"></a><a id="sthref505" name="sthref505"></a><a id="sthref506" name="sthref506"></a><a id="sthref507" name="sthref507"></a>To issue SQL and PL/SQL statements to Oracle Database, you can use SQL Developer. All SQL and PL/SQL commands are supported as they are passed directly from the SQL Worksheet to the Oracle Database.</p> <p>To start SQL Developer:</p> <ol> <li> <p>From the <span class="bold">Start</span> menu, select <span class="bold">Programs</span>, then <span class="bold">Oracle -</span> <span class="bolditalic">HOME_NAME</span>, then <span class="bold">Application Development</span>, and then <span class="bold">SQL Developer</span>.</p> </li> <li> <p>Right-Click <span class="bold">Connections.</span> In the dialog box, enter a Connection name, username, password, and for the host string, the name of the database to which you want to connect and click <span class="bold">Connect.</span></p> </li> </ol> <p>Once connected, you can view, create, modify, and delete the database objects using the Connection Navigator or issue any SQL or PL/SQL command using a SQL Worksheet (From the <span class="bold">Tools</span> menu, select <span class="bold">SQL Worksheet</span>).</p> <p>SQL*Plus commands have to be interpreted by the SQL Worksheet before being passed to the database. The SQL Worksheet currently supports many SQL*Plus commands. SQL*Plus commands which are not supported by the SQL Worksheet are ignored and are not sent to the Oracle Database.</p> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> "SQL*Plus Statements Supported and Not Supported in SQL Worksheet" in <span class="italic"><a class="olink RPTUG10710" href="http://www.oracle.com/pls/db112/lookup?id=RPTUG10710">Oracle Database SQL Developer User's Guide</a></span></div> </div> <!-- class="sect1" --> <a id="BDCCADCJ" name="BDCCADCJ"></a> <div class="sect1"> <h2 class="sect1"><span class="secnum">6.7</span> Reviewing User Accounts and Passwords</h2> <p>All databases created by Oracle Database Configuration Assistant include the <code>SYS</code>, <code>SYSTEM</code>, <code>SYSMAN</code>, and <code>DBSNMP</code> database accounts. In addition, Oracle provides several other administrative accounts. <a id="sthref508" name="sthref508"></a>Before using these other accounts, you must unlock them and reset their passwords. This section covers the following topics:</p> <ul> <li> <p><a href="#CHDHEBIB">Reviewing Administrative Accounts</a></p> </li> <li> <p><a href="#BDCDIEBD">Minimum Requirements for Passwords</a></p> </li> <li> <p><a href="#BABCJHBG">Recommendations for Passwords</a></p> </li> </ul> <div class="infoboxnotealso"> <p class="notep1"><span class="bold">See Also</span>:</p> <ul> <li> <p><a href="#BDCDIEBD">"Minimum Requirements for Passwords"</a> for information about using Oracle Enterprise Manager Database Control to view a complete list of the user accounts defined for your database</p> </li> <li> <p>"Modifying Oracle Counters for Windows Performance Monitor Parameters" in <span class="italic"><a class="olink NTQRF180" href="../../win.112/e10845/registry.htm#NTQRF180">Oracle Database Platform Guide for Microsoft Windows</a></span> for instructions on how to change the password for Oracle Counters for Windows Performance Monitor</p> </li> <li> <p><span class="italic"><a class="olink ADMIN" href="http://www.oracle.com/pls/db112/lookup?id=ADMIN">Oracle Database Administrator's Guide</a></span> for information about Oracle security procedures and security best practices</p> </li> </ul> </div> <a id="CHDHEBIB" name="CHDHEBIB"></a> <div class="sect2"> <h3 class="sect2"><span class="secnum">6.7.1</span> Reviewing Administrative Accounts<a id="sthref509" name="sthref509"></a><a id="sthref510" name="sthref510"></a></h3> <p><a href="#g1016156">Table 6-1</a> describes the administrative user names.</p> <div class="tblhruleformalwide"><a id="sthref511" name="sthref511"></a><a id="g1016156" name="g1016156"></a> <p class="titleintable">Table 6-1 Administrative Accounts <a id="ABC1228910" name="ABC1228910"></a></p> <table class="HRuleFormalWide" title="Administrative Accounts " summary="This table lists Adminstrative usernames. Column 1 lists the username, column 2 provides a description, and column 3 references sources for more information." dir="ltr" border="1" width="100%" frame="hsides" rules="rows" cellpadding="3" cellspacing="0"> <col width="20%" /> <col width="*" /> <col width="35%" /> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t11">User Name</th> <th align="left" valign="bottom" id="r1c2-t11">Description</th> <th align="left" valign="bottom" id="r1c3-t11">See Also</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t11" headers="r1c1-t11"> <p><code>ANONYMOUS</code><a id="sthref512" name="sthref512"></a><a id="sthref513" name="sthref513"></a><a id="sthref514" name="sthref514"></a></p> </td> <td align="left" headers="r2c1-t11 r1c2-t11"> <p><a id="sthref515" name="sthref515"></a><a id="sthref516" name="sthref516"></a>Allows HTTP access to Oracle XML DB.</p> </td> <td align="left" headers="r2c1-t11 r1c3-t11"> <p>Not applicable</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t11" headers="r1c1-t11"> <p><code>APEX_030200</code><a id="sthref517" name="sthref517"></a><a id="sthref518" name="sthref518"></a><a id="sthref519" name="sthref519"></a></p> </td> <td align="left" headers="r3c1-t11 r1c2-t11"> <p>The account owns the Oracle Application Express schema and metadata.</p> </td> <td align="left" headers="r3c1-t11 r1c3-t11"> <p><span class="italic"><a class="olink HTMDB" href="http://www.oracle.com/pls/db112/lookup?id=HTMDB">Oracle Application Express Application Builder User's Guide</a></span></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t11" headers="r1c1-t11"> <p><code>APEX_PUBLIC_USER</code><a id="sthref520" name="sthref520"></a><a id="sthref521" name="sthref521"></a><a id="sthref522" name="sthref522"></a></p> </td> <td align="left" headers="r4c1-t11 r1c2-t11"> <p>The minimally privileged account used for Oracle Application Express configuration with Oracle HTTP Server and mod_plsql.</p> </td> <td align="left" headers="r4c1-t11 r1c3-t11"> <p><span class="italic"><a class="olink HTMDB" href="http://www.oracle.com/pls/db112/lookup?id=HTMDB">Oracle Application Express Application Builder User's Guide</a></span></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r5c1-t11" headers="r1c1-t11"> <p><code>APPQOSSYS</code></p> </td> <td align="left" headers="r5c1-t11 r1c2-t11"> <p>Used for storing or managing all data and metadata required by Oracle Quality of Service Management.</p> </td> <td align="left" headers="r5c1-t11 r1c3-t11"> <p>None</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r6c1-t11" headers="r1c1-t11"> <p><code>BI</code><a id="sthref523" name="sthref523"></a><a id="sthref524" name="sthref524"></a><a id="sthref525" name="sthref525"></a></p> </td> <td align="left" headers="r6c1-t11 r1c2-t11"> <p>Owns the Business Intelligence schema included in the Oracle Sample Schemas. It is only available if you loaded the Sample Schemas.</p> </td> <td align="left" headers="r6c1-t11 r1c3-t11"> <p><span class="italic"><a class="olink COMSC" href="http://www.oracle.com/pls/db112/lookup?id=COMSC">Oracle Database Sample Schemas</a></span></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r7c1-t11" headers="r1c1-t11"> <p><code>CTXSYS</code> <a id="sthref526" name="sthref526"></a><a id="sthref527" name="sthref527"></a><a id="sthref528" name="sthref528"></a></p> </td> <td align="left" headers="r7c1-t11 r1c2-t11"> <p>The Oracle Text account.</p> </td> <td align="left" headers="r7c1-t11 r1c3-t11"> <p><span class="italic"><a class="olink CCREF" href="http://www.oracle.com/pls/db112/lookup?id=CCREF">Oracle Text Reference</a></span></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r8c1-t11" headers="r1c1-t11"> <p><code>DBSNMP</code> <a id="sthref529" name="sthref529"></a><a id="sthref530" name="sthref530"></a><a id="sthref531" name="sthref531"></a></p> </td> <td align="left" headers="r8c1-t11 r1c2-t11"> <p>Used by Management Agent of Oracle Enterprise Manager to monitor and manage the database. This account is created only if you configure the database to use Database Control.</p> </td> <td align="left" headers="r8c1-t11 r1c3-t11"> <p><span class="italic"><a class="olink OEMIG" href="http://www.oracle.com/pls/db112/lookup?id=OEMIG">Oracle Enterprise Manager Grid Control Installation and Basic Configuration</a></span></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r9c1-t11" headers="r1c1-t11"> <p><code>DIP</code><a id="sthref532" name="sthref532"></a><a id="sthref533" name="sthref533"></a><a id="sthref534" name="sthref534"></a></p> </td> <td align="left" headers="r9c1-t11 r1c2-t11"> <p>Used by Directory Integration Platform (DIP) to synchronize the changes in Oracle Internet Directory with the applications in the database.</p> </td> <td align="left" headers="r9c1-t11 r1c3-t11"> <p>None</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r10c1-t11" headers="r1c1-t11"> <p>DVSYS</p> </td> <td align="left" headers="r10c1-t11 r1c2-t11"> <p>There are two roles assciated with this account. Database Vault owner role manages the Database Vault roles and configurations. The Database Vault Account Manager is used to manage database user accounts.</p> <p><span class="bold">Note</span>: Part of Oracle Database Vault user interface text is stored in database tables in the DVSYS schema. By default, only the English language is loaded into these tables. You can use Oracle Database Vault Configuration Assistant to add more languages to Oracle Database Vault. For the necessary steps, refer to <a class="olink DVADM022" href="http://www.oracle.com/pls/db112/lookup?id=DVADM022">Appendix C</a> in <span class="italic"><a class="olink UNXAR" href="http://www.oracle.com/pls/db112/lookup?id=UNXAR">Oracle Database Vault Administrator's Guide</a></span></p> </td> <td align="left" headers="r10c1-t11 r1c3-t11"> <p><span class="italic"><a class="olink DVADM" href="http://www.oracle.com/pls/db112/lookup?id=DVADM">Oracle Database Vault Administrator's Guide</a></span></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r11c1-t11" headers="r1c1-t11"> <p><code>EXFSYS</code><a id="sthref535" name="sthref535"></a><a id="sthref536" name="sthref536"></a><a id="sthref537" name="sthref537"></a></p> </td> <td align="left" headers="r11c1-t11 r1c2-t11"> <p>Owns the Expression Filter schema.</p> </td> <td align="left" headers="r11c1-t11 r1c3-t11"> <p>None</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r12c1-t11" headers="r1c1-t11"> <p><code>FLOWS_FILES</code><a id="sthref538" name="sthref538"></a><a id="sthref539" name="sthref539"></a><a id="sthref540" name="sthref540"></a></p> </td> <td align="left" headers="r12c1-t11 r1c2-t11"> <p>The account owns the Oracle Application Express uploaded files.</p> </td> <td align="left" headers="r12c1-t11 r1c3-t11"> <p><span class="italic"><a class="olink HTMDB" href="http://www.oracle.com/pls/db112/lookup?id=HTMDB">Oracle Application Express Application Builder User's Guide</a></span></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r13c1-t11" headers="r1c1-t11"> <p><code>HR</code><a id="sthref541" name="sthref541"></a><a id="sthref542" name="sthref542"></a><a id="sthref543" name="sthref543"></a></p> </td> <td align="left" headers="r13c1-t11 r1c2-t11"> <p>Owns the Human Resources schema included in the Oracle Sample Schemas. It is available only if you loaded the Sample Schemas.</p> </td> <td align="left" headers="r13c1-t11 r1c3-t11"> <p><span class="italic"><a class="olink COMSC" href="http://www.oracle.com/pls/db112/lookup?id=COMSC">Oracle Database Sample Schemas</a></span></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r14c1-t11" headers="r1c1-t11"> <p><code>IX</code><a id="sthref544" name="sthref544"></a><a id="sthref545" name="sthref545"></a><a id="sthref546" name="sthref546"></a></p> </td> <td align="left" headers="r14c1-t11 r1c2-t11"> <p>Owns the Information Transport schema included in the Oracle Sample Schemas. This account is available only if you loaded the Sample Schemas.</p> </td> <td align="left" headers="r14c1-t11 r1c3-t11"> <p><span class="italic"><a class="olink COMSC" href="http://www.oracle.com/pls/db112/lookup?id=COMSC">Oracle Database Sample Schemas</a></span></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r15c1-t11" headers="r1c1-t11"> <p><code>LBACSYS</code><a id="sthref547" name="sthref547"></a><a id="sthref548" name="sthref548"></a><a id="sthref549" name="sthref549"></a></p> </td> <td align="left" headers="r15c1-t11 r1c2-t11"> <p>The Oracle Label Security administrator account.</p> </td> <td align="left" headers="r15c1-t11 r1c3-t11"> <p><span class="italic"><a class="olink OLSAG" href="http://www.oracle.com/pls/db112/lookup?id=OLSAG">Oracle Label Security Administrator's Guide</a></span></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r16c1-t11" headers="r1c1-t11"> <p><code>MDDATA</code><a id="sthref550" name="sthref550"></a><a id="sthref551" name="sthref551"></a><a id="sthref552" name="sthref552"></a></p> </td> <td align="left" headers="r16c1-t11 r1c2-t11"> <p>Used by Oracle Spatial for storing Geocoder and router data.</p> </td> <td align="left" headers="r16c1-t11 r1c3-t11"> <p><span class="italic"><a class="olink SPATL" href="http://www.oracle.com/pls/db112/lookup?id=SPATL">Oracle Spatial Developer's Guide</a></span></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r17c1-t11" headers="r1c1-t11"> <p><code>MDSYS</code><a id="sthref553" name="sthref553"></a><a id="sthref554" name="sthref554"></a><a id="sthref555" name="sthref555"></a></p> </td> <td align="left" headers="r17c1-t11 r1c2-t11"> <p>The Oracle Spatial and Oracle Multimedia Locator administrator account.</p> </td> <td align="left" headers="r17c1-t11 r1c3-t11"> <p><span class="italic"><a class="olink SPATL" href="http://www.oracle.com/pls/db112/lookup?id=SPATL">Oracle Spatial Developer's Guide</a></span></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r18c1-t11" headers="r1c1-t11"> <p><code>MGMT_VIEW</code><a id="sthref556" name="sthref556"></a><a id="sthref557" name="sthref557"></a><a id="sthref558" name="sthref558"></a></p> </td> <td align="left" headers="r18c1-t11 r1c2-t11"> <p>Used by Oracle Enterprise Manager Database Control.</p> </td> <td align="left" headers="r18c1-t11 r1c3-t11"> <p>None</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r19c1-t11" headers="r1c1-t11"> <p><code>OE</code><a id="sthref559" name="sthref559"></a><a id="sthref560" name="sthref560"></a><a id="sthref561" name="sthref561"></a></p> </td> <td align="left" headers="r19c1-t11 r1c2-t11"> <p>Owns the Order Entry schema included in the Oracle Sample Schemas. This account is available only if you loaded the Sample Schemas.</p> </td> <td align="left" headers="r19c1-t11 r1c3-t11"> <p><span class="italic"><a class="olink COMSC" href="http://www.oracle.com/pls/db112/lookup?id=COMSC">Oracle Database Sample Schemas</a></span></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r20c1-t11" headers="r1c1-t11"> <p><code>ORACLE_OCM</code><a id="sthref562" name="sthref562"></a><a id="sthref563" name="sthref563"></a><a id="sthref564" name="sthref564"></a></p> </td> <td align="left" headers="r20c1-t11 r1c2-t11"> <p>This account contains the instrumentation for configuration collection used by the Oracle Configuration Manager.</p> </td> <td align="left" headers="r20c1-t11 r1c3-t11"> <p><span class="italic"><a class="olink CCRIA" href="http://www.oracle.com/pls/db112/lookup?id=CCRIA">Oracle Configuration Manager Installation and Administration Guide</a></span></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r21c1-t11" headers="r1c1-t11"> <p><code>ORDDATA</code></p> </td> <td align="left" headers="r21c1-t11 r1c2-t11"> <p>This account contains the Oracle Multimedia DICOM data model.</p> </td> <td align="left" headers="r21c1-t11 r1c3-t11"> <p><span class="italic"><a class="olink IMDCM" href="http://www.oracle.com/pls/db112/lookup?id=IMDCM">Oracle Multimedia DICOM Developer's Guide</a></span></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r22c1-t11" headers="r1c1-t11"> <p><code>ORDPLUGINS</code> <a id="sthref565" name="sthref565"></a><a id="sthref566" name="sthref566"></a><a id="sthref567" name="sthref567"></a></p> </td> <td align="left" headers="r22c1-t11 r1c2-t11"> <p>The Oracle Multimedia user. Plug-ins supplied by Oracle and third party plug-ins are installed in this schema.</p> </td> <td align="left" headers="r22c1-t11 r1c3-t11"> <p><span class="italic"><a class="olink AIVUG" href="http://www.oracle.com/pls/db112/lookup?id=AIVUG">Oracle Multimedia Reference</a></span></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r23c1-t11" headers="r1c1-t11"> <p><code>ORDSYS</code> <a id="sthref568" name="sthref568"></a><a id="sthref569" name="sthref569"></a><a id="sthref570" name="sthref570"></a></p> </td> <td align="left" headers="r23c1-t11 r1c2-t11"> <p>The Oracle Multimedia administrator account.</p> </td> <td align="left" headers="r23c1-t11 r1c3-t11"> <p><span class="italic"><a class="olink AIVUG" href="http://www.oracle.com/pls/db112/lookup?id=AIVUG">Oracle Multimedia Reference</a></span></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r24c1-t11" headers="r1c1-t11"> <p><code>OUTLN</code> <a id="sthref571" name="sthref571"></a><a id="sthref572" name="sthref572"></a><a id="sthref573" name="sthref573"></a></p> </td> <td align="left" headers="r24c1-t11 r1c2-t11"> <p>Centrally manages metadata associated with stored outlines. Supports plan stability, which enables maintenance of the same execution plans for the same SQL statements.</p> </td> <td align="left" headers="r24c1-t11 r1c3-t11"> <p><span class="italic"><a class="olink PFGRF" href="http://www.oracle.com/pls/db112/lookup?id=PFGRF">Oracle Database Performance Tuning Guide</a></span></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r25c1-t11" headers="r1c1-t11"> <p><code>OWBSYS</code><a id="sthref574" name="sthref574"></a><a id="sthref575" name="sthref575"></a><a id="sthref576" name="sthref576"></a></p> </td> <td align="left" headers="r25c1-t11 r1c2-t11"> <p>The account used by Oracle Warehouse Builder as its default repository. You must unlock this account after installing the Oracle Database and before starting the Warehouse Builder Repository Assistant.</p> </td> <td align="left" headers="r25c1-t11 r1c3-t11"> <p><span class="italic"><a class="olink WBINS" href="../../owb.112/e10579/toc.htm">Oracle Warehouse Builder Installation and Administration Guide for Windows and Linux</a></span></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r26c1-t11" headers="r1c1-t11"> <p><code>PM</code><a id="sthref577" name="sthref577"></a><a id="sthref578" name="sthref578"></a><a id="sthref579" name="sthref579"></a></p> </td> <td align="left" headers="r26c1-t11 r1c2-t11"> <p>Owns the Product Media schema included in the Oracle Sample Schemas. This account is created only if you loaded the Sample Schemas.</p> </td> <td align="left" headers="r26c1-t11 r1c3-t11"> <p><span class="italic"><a class="olink COMSC" href="http://www.oracle.com/pls/db112/lookup?id=COMSC">Oracle Database Sample Schemas</a></span></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r27c1-t11" headers="r1c1-t11"> <p><code>SCOTT</code><a id="sthref580" name="sthref580"></a><a id="sthref581" name="sthref581"></a><a id="sthref582" name="sthref582"></a></p> </td> <td align="left" headers="r27c1-t11 r1c2-t11"> <p>An account used by Oracle sample programs and examples.</p> </td> <td align="left" headers="r27c1-t11 r1c3-t11"> <p><span class="italic"><a class="olink ADMIN" href="http://www.oracle.com/pls/db112/lookup?id=ADMIN">Oracle Database Administrator's Guide</a></span></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r28c1-t11" headers="r1c1-t11"> <p><code>SH</code><a id="sthref583" name="sthref583"></a><a id="sthref584" name="sthref584"></a><a id="sthref585" name="sthref585"></a></p> </td> <td align="left" headers="r28c1-t11 r1c2-t11"> <p>Owns the Sales History schema included in the Oracle Sample Schemas. This account is available only if you loaded the Sample Schemas during an Enterprise Edition installation</p> </td> <td align="left" headers="r28c1-t11 r1c3-t11"> <p><span class="italic"><a class="olink COMSC" href="http://www.oracle.com/pls/db112/lookup?id=COMSC">Oracle Database Sample Schemas</a></span></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r29c1-t11" headers="r1c1-t11"> <p><code>SI_INFORMTN_SCHEMA</code><a id="sthref586" name="sthref586"></a><a id="sthref587" name="sthref587"></a><a id="sthref588" name="sthref588"></a></p> </td> <td align="left" headers="r29c1-t11 r1c2-t11"> <p>Stores the information views for the SQL/MM Still Image Standard.</p> </td> <td align="left" headers="r29c1-t11 r1c3-t11"> <p><span class="italic"><a class="olink AIVUG" href="http://www.oracle.com/pls/db112/lookup?id=AIVUG">Oracle Multimedia Reference</a></span></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r30c1-t11" headers="r1c1-t11"> <p><code>SPATIAL_CSW_ADMIN_USR</code></p> </td> <td align="left" headers="r30c1-t11 r1c2-t11"> <p>The Catalog Services for the Web (CSW) account. It is used by the Oracle Spatial CSW cache manager to load all record type metadata, and record instances from the database into the main memory for the record types that are cached.</p> </td> <td align="left" headers="r30c1-t11 r1c3-t11"> <p><span class="italic"><a class="olink SPATL" href="http://www.oracle.com/pls/db112/lookup?id=SPATL">Oracle Spatial Developer's Guide</a></span></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r31c1-t11" headers="r1c1-t11"> <p><code>SPATIAL_WFS_ADMIN_USR</code></p> </td> <td align="left" headers="r31c1-t11 r1c2-t11"> <p>The Web Feature Service (WFS) account. It is used by the Oracle Spatial WFS cache manager to load all feature type metadata, and feature instances from the database into main memory for the feature types that are cached.</p> </td> <td align="left" headers="r31c1-t11 r1c3-t11"> <p><span class="italic"><a class="olink SPATL" href="http://www.oracle.com/pls/db112/lookup?id=SPATL">Oracle Spatial Developer's Guide</a></span></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r32c1-t11" headers="r1c1-t11"> <p><code>SYS</code><a id="sthref589" name="sthref589"></a><a id="sthref590" name="sthref590"></a><a id="sthref591" name="sthref591"></a></p> </td> <td align="left" headers="r32c1-t11 r1c2-t11"> <p>Used for performing database administration tasks.</p> </td> <td align="left" headers="r32c1-t11 r1c3-t11"> <p><span class="italic"><a class="olink ADMIN" href="http://www.oracle.com/pls/db112/lookup?id=ADMIN">Oracle Database Administrator's Guide</a></span></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r33c1-t11" headers="r1c1-t11"> <p><code>SYSMAN</code><a id="sthref592" name="sthref592"></a><a id="sthref593" name="sthref593"></a><a id="sthref594" name="sthref594"></a></p> </td> <td align="left" headers="r33c1-t11 r1c2-t11"> <p>The account used to perform Oracle Enterprise Manager database administration tasks.This account is created only if you configure the database to use the Database Control.</p> </td> <td align="left" headers="r33c1-t11 r1c3-t11"> <p><span class="italic"><a class="olink OEMIG" href="http://www.oracle.com/pls/db112/lookup?id=OEMIG">Oracle Enterprise Manager Grid Control Installation and Basic Configuration</a></span></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r34c1-t11" headers="r1c1-t11"> <p><code>SYSTEM</code><a id="sthref595" name="sthref595"></a><a id="sthref596" name="sthref596"></a><a id="sthref597" name="sthref597"></a></p> </td> <td align="left" headers="r34c1-t11 r1c2-t11"> <p>Used for performing database administration tasks.</p> </td> <td align="left" headers="r34c1-t11 r1c3-t11"> <p><span class="italic"><a class="olink ADMIN" href="http://www.oracle.com/pls/db112/lookup?id=ADMIN">Oracle Database Administrator's Guide</a></span></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r35c1-t11" headers="r1c1-t11"> <p><code>WMSYS</code><a id="sthref598" name="sthref598"></a><a id="sthref599" name="sthref599"></a><a id="sthref600" name="sthref600"></a></p> </td> <td align="left" headers="r35c1-t11 r1c2-t11"> <p>The account used to store the metadata information for Oracle Workspace Manager.</p> </td> <td align="left" headers="r35c1-t11 r1c3-t11"> <p><span class="italic"><a class="olink ADWSM" href="http://www.oracle.com/pls/db112/lookup?id=ADWSM">Oracle Database Workspace Manager Developer's Guide</a></span></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r36c1-t11" headers="r1c1-t11"> <p><code>XDB</code><a id="sthref601" name="sthref601"></a><a id="sthref602" name="sthref602"></a><a id="sthref603" name="sthref603"></a><a id="sthref604" name="sthref604"></a></p> </td> <td align="left" headers="r36c1-t11 r1c2-t11"> <p>Used for storing Oracle XML DB data and metadata.</p> </td> <td align="left" headers="r36c1-t11 r1c3-t11"> <p><span class="italic"><a class="olink ADXDB" href="http://www.oracle.com/pls/db112/lookup?id=ADXDB">Oracle XML DB Developer's Guide</a></span><a id="sthref605" name="sthref605"></a></p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblhruleformalwide" --> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <ul> <li> <p>"Database Users and Schemas" of <span class="italic"><a class="olink CNCPT1545" href="http://www.oracle.com/pls/db112/lookup?id=CNCPT1545">Oracle Database Concepts</a></span></p> </li> <li> <p>"Database Administrator Usernames" of <span class="italic"><a class="olink ADMIN001" href="http://www.oracle.com/pls/db112/lookup?id=ADMIN001">Oracle Database Administrator's Guide</a></span></p> </li> <li> <p>"Administering External Users and Roles on Windows" of <span class="italic"><a class="olink NTQRF130" href="../../win.112/e10845/external.htm#NTQRF130">Oracle Database Platform Guide for Microsoft Windows</a></span></p> </li> </ul> </div> </div> <!-- class="sect2" --> <a id="BDCDIEBD" name="BDCDIEBD"></a> <div class="sect2"> <h3 class="sect2"><span class="secnum">6.7.2</span> Minimum Requirements for Passwords<a id="sthref606" name="sthref606"></a><a id="sthref607" name="sthref607"></a><a id="sthref608" name="sthref608"></a></h3> <p>Passwords for all Oracle system administration accounts except <code>SYS</code>, <code>SYSTEM</code>, <code>SYSMAN</code>, and <code>DBSNMP</code> are revoked after installation. Before you use a locked account, you must unlock it and reset its password. If you created a starter database during the installation, Oracle Database Configuration Assistant displays a screen with your database information and the Password Management button. Use the Password Management button and unlock only the user names you use.</p> <p>The installation does not continue if the following requirements are not met:</p> <ul> <li> <p>Password cannot exceed 30 characters.</p> </li> <li> <p>Password cannot contain invalid characters: ! @ % ^ & * ( ) + = \ | ` ~ [ { ] } ; : ' " , < > ?</p> </li> <li> <p>A user name cannot be a password.</p> </li> <li> <p>An empty password cannot be accepted.</p> </li> <li> <p>The <code>SYS</code> account password cannot be <code>change_on_install</code>. (case-insensitive)</p> </li> <li> <p>The <code>SYSTEM</code> account password cannot be <code>manager</code>. (case-insensitive)</p> </li> <li> <p>The <code>SYSMAN</code> account password cannot be <code>sysman</code>. (case-insensitive)</p> </li> <li> <p>The <code>DBSNMP</code> account password cannot be <code>dbsnmp</code>. (case-insensitive)</p> </li> <li> <p>If you choose to use the same password for all the accounts, then that password cannot be <code>change_on_install</code>, <code>manager</code>, <code>sysman</code>, or <code>dbsnmp</code>. (case-insensitive)</p> </li> </ul> <p>If you created a starter database during the installation, but you did not unlock the required account, unlock the account using one of the following methods:</p> <ul> <li> <p><a href="#CHDCBCHD">Using Enterprise Manager Database Control to Unlock and Change Passwords</a></p> </li> <li> <p><a href="#CHDJDDEA">Using SQL*Plus to Unlock and Change Passwords</a></p> </li> </ul> <div class="infoboxnote"> <p class="notep1">Note:</p> To permit unauthenticated access to your data through HTTP, unlock the <code>ANONYMOUS</code> account.</div> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <span class="italic"><a class="olink ADMIN" href="http://www.oracle.com/pls/db112/lookup?id=ADMIN">Oracle Database Administrator's Guide</a></span> for more information about: <ul> <li> <p>Unlocking and changing passwords after installation</p> </li> <li> <p>Oracle security procedures</p> </li> <li> <p>Security best practices</p> </li> </ul> </div> <a id="CHDCBCHD" name="CHDCBCHD"></a> <div class="sect3"> <h4 class="sect3"><span class="secnum">6.7.2.1</span> Using Enterprise Manager Database Control to Unlock and Change Passwords<a id="sthref609" name="sthref609"></a></h4> <p><a id="sthref610" name="sthref610"></a>To unlock and reset user account passwords with Oracle Enterprise Manager Database Control:</p> <ol> <li> <p>Log in to Database Control.</p> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <a href="#BDCJJGDA">"Logging in to Enterprise Manager Database Control"</a></div> </li> <li> <p>Click <span class="bold">Schema</span>.</p> </li> <li> <p>In the Users and Privileges section of the Schema page, click <span class="bold">Users</span>.</p> <p>Enterprise Manager displays a table containing all database accounts. The Account Status column indicates whether the account is locked and whether the password is expired.</p> </li> <li> <p>Select the user account you want to modify, then click <span class="bold">Edit</span>.</p> </li> <li> <p>Use the General page of the Users property sheet to change the password and lock or unlock the selected account. Click <span class="bold">Help</span> for additional information.</p> </li> </ol> </div> <!-- class="sect3" --> <a id="CHDJDDEA" name="CHDJDDEA"></a> <div class="sect3"> <h4 class="sect3"><span class="secnum">6.7.2.2</span> Using SQL*Plus to Unlock and Change Passwords</h4> <p><a id="sthref611" name="sthref611"></a>Use <a id="sthref612" name="sthref612"></a>SQL*Plus to unlock accounts and change passwords any time after the installation process.</p> <p>To change a password after installation:</p> <ol> <li> <p>Start SQL*Plus:</p> <pre xml:space="preserve" class="oac_no_warn">C:\> sqlplus /nolog </pre></li> <li> <p>Connect as <code>SYSDBA</code>:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> CONNECT SYS AS SYSDBA Enter password: <span class="italic">SYS_password</span> </pre></li> <li> <p>Enter a command similar to the following, where <code><span class="codeinlineitalic">account</span></code> is the user account to unlock and <code><span class="codeinlineitalic">password</span></code> is the new password:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> PASSWORD <span class="italic">account</span> UNLOCK; Changing password for <span class="italic">account</span> New password: <span class="italic">password</span> Retype new password: <span class="italic">password</span> </pre> <p>In this example, the <code><span class="codeinlineitalic">account</span></code> <code>UNLOCK</code> clause unlocks the account.</p> </li> </ol> </div> <!-- class="sect3" --></div> <!-- class="sect2" --> <a id="BABCJHBG" name="BABCJHBG"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2"><span class="secnum">6.7.3</span> Recommendations for Passwords</h3> <p>When prompted for a password, follow these guidelines. Oracle recommends that the password you specify:</p> <ul> <li> <p>contains at least one lowercase letter.</p> </li> <li> <p>contains at least one uppercase letter.</p> </li> <li> <p>contains at least one digit.</p> </li> <li> <p>is at least 8 characters in length.</p> </li> <li> <p>uses the database character set which can include the underscore (_), dollar ($), and pound sign (#) characters.</p> </li> <li> <p>if contains special characters, including beginning the password with a number or symbol, then enclose the password with double-quotation marks.</p> </li> <li> <p>should not be an actual word.</p> </li> </ul> </div> <!-- class="sect2" --></div> <!-- class="sect1" --> <a id="i1006051" name="i1006051"></a> <div class="sect1"> <h2 class="sect1"><span class="secnum">6.8</span> Identifying Databases<a id="sthref613" name="sthref613"></a><a id="sthref614" name="sthref614"></a><a id="sthref615" name="sthref615"></a><a id="sthref616" name="sthref616"></a></h2> <p>The Oracle Database 11<span class="italic">g</span> software identifies a database by its <a id="sthref617" name="sthref617"></a><a id="sthref618" name="sthref618"></a>global database name. A global database name consists of the database name and database domain. Usually, the database domain equals the network domain, but it need not be. The global database name uniquely distinguishes a database from any other database in the same network. You specify the global database name when you create a database during the installation, or when using Oracle Database Configuration Assistant. For example:</p> <p><code>sales.us.example.com</code></p> <p>In this example:</p> <ul> <li> <p><code>sales</code> is the name of the database. The database name portion is a string of no more than 30 characters that can contain alphanumeric, underscore (_), dollar ($), and pound (#) characters. The <code>DB_NAME</code> initialization parameter specifies the database name.</p> </li> <li> <p><code>us.example.com</code> is the network domain in which the database is located. Together, the database name and the network domain make the global database name unique. The domain portion is a string of no more than 128 characters that can contain alphanumeric, underscore (_), and pound (#) characters. The <code>DB_DOMAIN</code> initialization parameter specifies the domain name.</p> </li> </ul> <p>The <code>DB_NAME</code> parameter and the <code>DB_DOMAIN</code> name parameter combine to create the global database name value assigned to the <code>SERVICE_NAMES</code> parameter in the initialization parameter file.</p> <p>The system identifier (SID) identifies a specific database instance. The SID uniquely distinguishes the instance from any other instance on the same computer. Each database instance requires a unique SID and database name. <a id="sthref619" name="sthref619"></a></p> <p>For example, if the SID and database name for an Oracle database are <code>ORCL</code>, then each database file is located in the <code><span class="codeinlineitalic">ORACLE_BASE</span></code><code>\oradata\</code><code>orcl</code> directory, and the initialization parameter file is located in the <code><span class="codeinlineitalic">ORACLE_BASE</span></code><code>\admin\</code><code>orcl</code><code>\pfile</code> directory.</p> </div> <!-- class="sect1" --> <a id="BDCFBGCH" name="BDCFBGCH"></a> <div class="sect1"> <h2 class="sect1"><span class="secnum">6.9</span> Locating the Server Parameter File<a id="sthref620" name="sthref620"></a><a id="sthref621" name="sthref621"></a><a id="sthref622" name="sthref622"></a></h2> <p>The starter database contains one database initialization parameter file. <a id="sthref623" name="sthref623"></a><a id="sthref624" name="sthref624"></a><a id="sthref625" name="sthref625"></a>The initialization parameter file, <code>init.ora.</code><code><span class="codeinlineitalic">xxxxx</span></code>, must exist for an instance to start. A parameter file is a text file that contains a list of instance configuration parameters. The starter database <code>init.ora</code> file has preconfigured parameters. You must not edit this file to use the starter database.</p> <p>The server parameter file (SPFILE) is created from the initialization parameter file, then the initialization parameter file is renamed. The SPFILE file name is <code>spfile</code><code><span class="codeinlineitalic">SID</span></code><code>.ora</code> and is located in the <code><span class="codeinlineitalic">ORACLE_HOME</span></code><code>\database</code> directory.</p> <p>You can use Oracle Enterprise Manager Database Control to view the location of the server parameter file and list all of the initialization parameters, as follows:<a id="sthref626" name="sthref626"></a></p> <ol> <li> <p>Log in to Database Control.</p> <div align="center"> <div class="inftblinformal"><br /> <table class="Informal oac_no_warn" summary="" border="1" width="80%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> <tbody> <tr align="left" valign="top"> <td align="left"> <p class="notep1">See Also:</p> <a href="#BDCJJGDA">"Logging in to Enterprise Manager Database Control"</a></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblinformal" --></div> </li> <li> <p>Click <span class="bold">Server</span>.</p> </li> <li> <p>In the Database Configuration section of the Server page, click <span class="bold">All Initialization Parameters</span>.</p> <p>Database Control displays a table listing the current value of each initialization parameter.</p> </li> <li> <p>Click <span class="bold">SPFile</span>.</p> <p>Database Control displays a table listing the value of each initialization parameter specified in the server parameter file. The location of the server parameter file is displayed before the table.</p> </li> </ol> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <ul> <li> <p>"Oracle Database Specifications for Windows" of <span class="italic"><a class="olink NTQRF170" href="../../win.112/e10845/specs.htm#NTQRF170">Oracle Database Platform Guide for Microsoft Windows</a></span> for a list of Oracle Database-specific initialization parameters for Windows and their default values</p> </li> <li> <p><span class="italic"><a class="olink REFRN" href="http://www.oracle.com/pls/db112/lookup?id=REFRN">Oracle Database Reference</a></span> for more information about initialization parameters</p> </li> </ul> </div> </div> <!-- class="sect1" --> <a id="BDCFHCCJ" name="BDCFHCCJ"></a> <div class="sect1"> <h2 class="sect1"><span class="secnum">6.10</span> Identifying Tablespaces and Data Files<a id="sthref627" name="sthref627"></a><a id="sthref628" name="sthref628"></a><a id="sthref629" name="sthref629"></a></h2> <p><a id="sthref630" name="sthref630"></a>An Oracle Database is divided into smaller logical areas of space known as tablespaces. Each tablespace corresponds to one or more physical data files. Data files contain the contents of logical database structures such as tables and indexes. A data file can be associated with only one tablespace and database.</p> <div class="infoboxnote"> <p class="notep1">Note:</p> The <code>SYSAUX</code> and <code>SYSTEM</code> tablespaces must be present in all Oracle Database 11<span class="italic">g</span> Release 2 (11.2) databases.</div> <p><a href="#g1016274">Table 6-2</a> list the tablespaces and data files in the Oracle Database. By default, the data files are located in the <code><span class="codeinlineitalic">ORACLE_BASE</span></code><code>\oradata\</code><code><span class="codeinlineitalic">DB_NAME</span></code> directory.</p> <div class="tblhruleformal"><a id="sthref631" name="sthref631"></a><a id="g1016274" name="g1016274"></a> <p class="titleintable">Table 6-2 Tablespaces and Data Files<a id="sthref632" name="sthref632"></a><a id="sthref633" name="sthref633"></a><a id="sthref634" name="sthref634"></a></p> <table class="HRuleFormal" title="Tablespaces and Data Files" summary="This table lists the Tablespaces and Datafiles of the database. Column 1 lists the tablespaces. Column 2 lists the datafile name. Column 3 describes the content of the datafile." dir="ltr" border="1" width="100%" frame="hsides" rules="rows" cellpadding="3" cellspacing="0"> <col width="17%" /> <col width="21%" /> <col width="*" /> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t19">Tablespace</th> <th align="left" valign="bottom" id="r1c2-t19">Data File</th> <th align="left" valign="bottom" id="r1c3-t19">Description</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t19" headers="r1c1-t19"> <p><code>EXAMPLE<a id="sthref635" name="sthref635"></a><a id="sthref636" name="sthref636"></a></code></p> </td> <td align="left" headers="r2c1-t19 r1c2-t19"> <p><code>EXAMPLE01.DBF</code><a id="sthref637" name="sthref637"></a></p> </td> <td align="left" headers="r2c1-t19 r1c3-t19"> <p><a id="sthref638" name="sthref638"></a><a id="sthref639" name="sthref639"></a>Stores the Sample Schemas, if you included them.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t19" headers="r1c1-t19"> <p><code>SYSAUX</code><a id="sthref640" name="sthref640"></a></p> </td> <td align="left" headers="r3c1-t19 r1c2-t19"> <p><code>SYSAUX01.DBF</code><a id="sthref641" name="sthref641"></a></p> </td> <td align="left" headers="r3c1-t19 r1c3-t19"> <p>Serves as an auxiliary tablespace to the <code>SYSTEM</code> tablespace. Some products and options that previously used the <code>SYSTEM</code> tablespace now use the <code>SYSAUX</code> tablespace to reduce the load on the <code>SYSTEM</code> tablespace.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t19" headers="r1c1-t19"> <p><code>SYSTEM</code> <a id="sthref642" name="sthref642"></a></p> </td> <td align="left" headers="r4c1-t19 r1c2-t19"> <p><code>SYSTEM01.DBF</code><a id="sthref643" name="sthref643"></a></p> </td> <td align="left" headers="r4c1-t19 r1c3-t19"> <p>Stores the data dictionary, including definitions of tables, views, and stored procedures needed by the Oracle Database. Information in this area is maintained automatically.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r5c1-t19" headers="r1c1-t19"> <p><code>TEMP</code> <a id="sthref644" name="sthref644"></a><a id="sthref645" name="sthref645"></a><a id="sthref646" name="sthref646"></a></p> </td> <td align="left" headers="r5c1-t19 r1c2-t19"> <p><code>TEMP01.DBF</code><a id="sthref647" name="sthref647"></a></p> </td> <td align="left" headers="r5c1-t19 r1c3-t19"> <p>Stores temporary tables and indexes created during the processing of your SQL statement. If you run a SQL statement that involves a lot of sorting, such as the constructs <code>GROUP</code> <code>BY</code>, <code>ORDER</code> <code>BY</code>, or <code>DISTINCT</code>, then you must expand this tablespace.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r6c1-t19" headers="r1c1-t19"> <p><code>UNDOTBS</code> <a id="sthref648" name="sthref648"></a><a id="sthref649" name="sthref649"></a></p> </td> <td align="left" headers="r6c1-t19 r1c2-t19"> <p><code>UNDOTBS01.DBF</code></p> </td> <td align="left" headers="r6c1-t19 r1c3-t19"> <p>Stores undo information. The <a href="glossary.htm#i432471"><span class="xrefglossterm">undo tablespace</span></a> contains one or more undo segments that maintain transaction history that is used to roll back, or undo, changes to the database.</p> <p>All starter databases are configured to run in automatic undo management mode.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r7c1-t19" headers="r1c1-t19"> <p><code>USERS</code> <a id="sthref650" name="sthref650"></a><a id="sthref651" name="sthref651"></a></p> </td> <td align="left" headers="r7c1-t19 r1c2-t19"> <p><code>USERS01.DBF</code></p> </td> <td align="left" headers="r7c1-t19 r1c3-t19"> <p>Stores database objects created by database users.</p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblhruleformal" --> <p>To use Oracle Enterprise Manager Database Control to view the list of datafiles currently available in your database:<a id="sthref652" name="sthref652"></a></p> <ol> <li> <p>Log in to Database Control.</p> <div align="center"> <div class="inftblinformal"><br /> <table class="Informal oac_no_warn" summary="" border="1" width="80%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> <tbody> <tr align="left" valign="top"> <td align="left"> <p class="notep1">See Also:</p> <a href="#BDCJJGDA">"Logging in to Enterprise Manager Database Control"</a></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblinformal" --></div> </li> <li> <p>Click <span class="bold">Server</span>.</p> </li> <li> <p>In the Storage section of the Server page, click <span class="bold">Datafiles</span>.</p> <p>Enterprise Manager displays a table listing each data file, and the tablespace with which it is associated. For more information about using Database Control to view, modify, and create tablespaces, click <span class="bold">Help</span>.</p> </li> </ol> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <ul> <li> <p>"Tablespaces, Data Files, and Control Files" of <span class="italic"><a class="olink CNCPT003" href="http://www.oracle.com/pls/db112/lookup?id=CNCPT003">Oracle Database Concepts</a></span></p> </li> <li> <p>"Managing Tablespaces" and "Managing Data Files and Tempfiles" of <span class="italic"><a class="olink ADMIN011" href="http://www.oracle.com/pls/db112/lookup?id=ADMIN011">Oracle Database Administrator's Guide</a></span></p> </li> <li> <p>"Managing the Undo Tablespace" of <span class="italic"><a class="olink ADMIN013" href="http://www.oracle.com/pls/db112/lookup?id=ADMIN013">Oracle Database Administrator's Guide</a></span></p> </li> </ul> </div> </div> <!-- class="sect1" --> <a id="BDCDEIDJ" name="BDCDEIDJ"></a> <div class="sect1"> <h2 class="sect1"><span class="secnum">6.11</span> Locating Redo Log Files<a id="sthref653" name="sthref653"></a><a id="sthref654" name="sthref654"></a><a id="sthref655" name="sthref655"></a><a id="sthref656" name="sthref656"></a></h2> <p>A redo log can be either an online redo log or an archived redo log. The online redo log is a set of two or more redo log groups that records all changes made to Oracle data files and control files. An archived redo log is a copy of an online redo log that has been copied to an offline destination. If the database is in <code>ARCHIVELOG</code> mode and automatic archiving is enabled, then the archive process or processes copy each online redo log to one or more archive log destinations after it is filled.</p> <p>The starter database contains three redo log files located in the <code><span class="codeinlineitalic">ORACLE_BASE</span></code><code>\oradata</code><code>\</code><code><span class="codeinlineitalic">DB_NAME</span></code> directory. Redo log files hold a record of all changes made to data in the database buffer cache. If an instance fails, then Oracle Database uses the redo log files to recover the modified data in memory.</p> <p>To use Oracle Enterprise Manager Database Control to view or modify the redo log files for your starter database:<a id="sthref657" name="sthref657"></a></p> <ol> <li> <p>Start your Web browser and log in to Database Control.</p> <div align="center"> <div class="inftblinformal"><br /> <table class="Informal oac_no_warn" summary="" border="1" width="80%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> <tbody> <tr align="left" valign="top"> <td align="left"> <p class="notep1">See Also:</p> <a href="#BDCJJGDA">"Logging in to Enterprise Manager Database Control"</a></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblinformal" --></div> </li> <li> <p>Click <span class="bold">Server</span>.</p> </li> <li> <p>In the Storage section of the Server page, click <span class="bold">Redo Log Groups</span>.</p> <p>Enterprise Manager displays a table containing the control files currently defined for this database instance.</p> </li> <li> <p>To view the name and location of the redo log file associated with a particular group, select that group then click <span class="bold">View</span>.</p> <p>For more information about using Database Control to view, modify, and create tablespaces, click <span class="bold">Help</span>.</p> </li> </ol> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <ul> <li> <p><span class="italic"><a class="olink BRADV" href="http://www.oracle.com/pls/db112/lookup?id=BRADV">Oracle Database Backup and Recovery User's Guide</a></span></p> </li> <li> <p>"Managing Archived Redo Logs" in <span class="italic"><a class="olink ADMIN008" href="http://www.oracle.com/pls/db112/lookup?id=ADMIN008">Oracle Database Administrator's Guide</a></span></p> </li> </ul> </div> </div> <!-- class="sect1" --> <a id="BDCBJEEG" name="BDCBJEEG"></a> <div class="sect1"> <h2 class="sect1"><span class="secnum">6.12</span> Locating Control Files<a id="sthref658" name="sthref658"></a><a id="sthref659" name="sthref659"></a><a id="sthref660" name="sthref660"></a></h2> <p>The starter database contains three control files located in the <code><span class="codeinlineitalic">ORACLE_BASE</span></code><code>\oradata</code><code>\</code><code><span class="codeinlineitalic">DB_NAME</span></code> directory. Oracle recommends that you keep at least three control files (on separate physical drives) for each database, and set the <code>CONTROL_FILES</code> initialization parameter to list each control file.</p> <p>A control file is an administrative file required to start and run the database. The control file records the physical structure of the database. For example, a control file contains the database name, and the names and locations of the database data files and redo log files.</p> <p>To use Oracle Enterprise Manager Database Control to view or modify the control files for your starter database:<a id="sthref661" name="sthref661"></a></p> <ol> <li> <p>Log in to Database Control.</p> <div align="center"> <div class="inftblinformal"><br /> <table class="Informal oac_no_warn" summary="" border="1" width="80%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> <tbody> <tr align="left" valign="top"> <td align="left"> <p class="notep1">See Also:</p> <a href="#BDCJJGDA">"Logging in to Enterprise Manager Database Control"</a></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblinformal" --></div> </li> <li> <p>Click <span class="bold">Server.</span></p> </li> <li> <p>In the Storage section of the Server page, click <span class="bold">Control files</span>.</p> <p>Enterprise Manager displays a table containing the control files currently defined for this database instance. For more information about using control files and backing up control files, click <span class="bold">Help</span>.</p> </li> </ol> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> "Managing Control Files" of <span class="italic"><a class="olink ADMIN006" href="http://www.oracle.com/pls/db112/lookup?id=ADMIN006">Oracle Database Administrator's Guide</a></span> for information about setting this initialization parameter value</div> </div> <!-- class="sect1" --> <a id="i1006089" name="i1006089"></a> <div class="sect1"> <h2 class="sect1"><span class="secnum">6.13</span> Understanding Oracle Database Services on Windows</h2> <p>Two main Oracle services are automatically started after installation when you create a database:</p> <ul> <li> <p><code>OracleService</code><code><span class="codeinlineitalic">SID</span></code> (Oracle Database service)</p> </li> <li> <p><code>Oracle</code><code><span class="codeinlineitalic">HOME_NAME</span></code><code>TNSListener</code> (Oracle Database listener service)</p> </li> </ul> <p>If you installed Oracle Enterprise Manager Database Control, then the <code>OracleDBConsole</code><code><span class="codeinlineitalic">SID</span></code> service is automatically started. In you configured Automatic Storage Management, the <code>OracleOHService</code> and <code>OracleASMService+ASM</code> services are listed as well. However, other services for networking or other individual components may not automatically start.</p> <p><a id="sthref662" name="sthref662"></a><a id="sthref663" name="sthref663"></a></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="postcfg.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="deinstall.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 © 1996, 2010, 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