Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdddg\tdddg_connecting002.htm
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <script src="./callback.js" type="text/javascript"></script> <noscript>Your browser does not support JavaScript. This help page requires JavaScript to render correctly.</noscript> </head> <meta http-equiv="Content-Type" content="text/html; charset=us-ascii" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <meta http-equiv="Content-Script-Type" content="text/javascript" /> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1.1 Build 005" /> <meta name="date" content="2009-04-21T9:46:23Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="Connecting to Oracle Database from SQL Developer" /> <meta name="relnum" content="11g Release 2 (11.2)" /> <meta name="partnum" content="E10766-01" /> <link rel="copyright" href="./dcommon/html/cpyr.htm" title="Copyright" type="text/html" /> <link rel="stylesheet" href="./dcommon/css/blafdoc.css" title="Oracle BLAFDoc" type="text/css" /> <link rel="contents" href="toc.htm" title="Contents" type="text/html" /> <link rel="prev" href="tdddg_connecting001.htm" title="Previous" type="text/html" /> <link rel="next" href="tdddg_connecting003.htm" title="Next" type="text/html" /> <title>Connecting to Oracle Database from SQL Developer</title> </head> <body> <div class="zz-skip-header"><a href="#BEGIN">Skip Headers</a></div> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr valign="bottom"> <td align="left"></td> <td align="center"><a href="tdddg_connecting001.htm"><img width="24" height="24" src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdddg_connecting003.htm"><img width="24" height="24" src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CEGFCEGG" name="CEGFCEGG"></a><a id="TDDDG12200" name="TDDDG12200"></a></p> <div class="sect1"> <h1>Connecting to Oracle Database from SQL Developer</h1> <a name="BEGIN" id="BEGIN"></a> <p><a id="sthref69" name="sthref69"></a><a id="sthref70" name="sthref70"></a>SQL Developer is a client program with which you can access Oracle Database. This section assumes that SQL Developer is installed on your system, and shows how to start it and connect to Oracle Database. If SQL Developer is not installed on your system, see <a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=RPTUG10100','newWindow').focus()"><span class="italic">Oracle Database SQL Developer User's Guide</span></a> for installation instructions.</p> <div class="helpinfonote"> <p><span class="bold">Note: </span>For the following procedure: <ul> <li> <p>The first time you start SQL Developer on your system, you must provide the full path to <code>java</code>.<code>exe</code> in step <a href="#CEGJHDEC">4</a>.</p> </li> <li> <p>For step <a href="#CEGBJEEE">7</a>, you need a user name and password.</p> </li> <li> <p>For step <a href="#CEGCICDA">9</a>, you need a host name and port.</p> </li> </ul> </p> </div> <a id="TDDDG121" name="TDDDG121"></a> <p class="subhead2">To connect to Oracle Database from SQL Developer:</p> <ol> <li> <p>Access the menu from which you can select SQL Developer:</p> <ul> <li> <p>On a Windows system: From the Start menu, select <span class="bold">All Programs</span>.</p> </li> <li> <p>On a Linux system:</p> <ul> <li> <p>On Gnome: Click <span class="bold">Application</span>.</p> </li> <li> <p>On KDE: Click <span class="bold">K</span>.</p> </li> </ul> </li> </ul> </li> <li> <p>Select <span class="bold">Oracle -</span> <span class="bolditalic">ORACLE_HOME</span>.</p> </li> <li> <p>Select <span class="bold">Application Development</span>.</p> </li> <li><a id="CEGJHDEC" name="CEGJHDEC"></a> <p>Select <span class="bold">SQL Developer</span>.</p> <p>If this is the first time you have started SQL Developer on your system, you are prompted to enter the full path to <code>java</code>.<code>exe</code> (for example, <code>C:\jdk1.5.0\bin\java.exe</code>). Either type the full path after the prompt or browse to it, and then press the key <span class="bold">Enter</span>.</p> <p>The Oracle SQL Developer window opens.</p> </li> <li> <p>In the navigation frame of the window, click <span class="bold">Connections</span>.</p> <p>The Connections pane appears.</p> </li> <li> <p>In the Connections pane, click the icon <span class="bold">New Connection</span>.</p> <p>The New/Select Database Connection window opens.</p> </li> <li><a id="CEGBJEEE" name="CEGBJEEE"></a> <p>In the New/Select Database Connection window, type the appropriate values in the fields Connection Name, Username, and Password.</p> <p>For security, the password characters that you type appear as asterisks.</p> <p>Near the Password field is the check box Save Password. By default, it is deselected. Oracle recommends accepting the default.</p> </li> <li> <p>In the New/Select Database Connection window, click the tab <span class="bold">Oracle</span>.</p> <p>The Oracle pane appears.</p> </li> <li><a id="CEGCICDA" name="CEGCICDA"></a> <p>In the Oracle pane:</p> <ul> <li> <p>For Role, accept the default.</p> </li> <li> <p>For Connection Type, accept the default (Basic).</p> </li> <li> <p>In the fields Hostname and Port, type the appropriate values.</p> </li> <li> <p>Select the option <span class="bold">SID</span>.</p> </li> <li> <p>In the SID field, type the appropriate value.</p> </li> </ul> </li> <li> <p>In the New/Select Database Connection window, click the button <span class="bold">Test</span>.</p> <p>The connection is tested. If the connection succeeds, the Status indicator changes from blank to <code>Success</code>.</p> </li> <li><a id="CEGGJCBE" name="CEGGJCBE"></a> <p>If the test succeeded, click the button <span class="bold">Connect</span>.</p> <p>The New/Select Database Connection window closes. The Connections pane shows the connection whose name you entered in the Connection Name field in step <a href="#CEGBJEEE">7</a>.</p> </li> </ol> <p>You are in the SQL Developer environment.</p> <p>To exit SQL Developer, select <span class="bold">Exit</span> from the File menu.</p> <div class="helpinfonote"> <p><span class="bold">Note: </span>Exiting SQL Developer ends the SQL Developer session, but does not shut down the Oracle Database instance. The next time you start SQL Developer, the connection you created using the preceding procedure still exists. SQL Developer prompts you for the password that you supplied in step <a href="#CEGBJEEE">7</a> (unless you selected the check box Save Password).</p> </div> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="tdddg_connecting006.htm#BABIAAIA">Connecting to Oracle Database as User HR from SQL Developer</a></p> <p><a href="tdddg_intro007.htm#CEGHIBFI">About SQL Developer</a></p> <p><a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=RPTUG10400','newWindow').focus()"><span class="italic">Oracle Database SQL Developer User's Guide</span></a></p> <p><a href="tdddg_connecting.htm#CEGGIIEJ">Connecting to Oracle Database</a></p> </div> </div> <!-- class="sect1" --> <!-- Start Footer --> <div class="footer"> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr> <td align="left"><span class="copyrightlogo">Copyright © 1996, 2009, Oracle and/or its affiliates. All rights reserved.</span><br /> <a href="./dcommon/html/cpyr.htm"><span class="copyrightlogo">Legal Notices</span></a></td> <td align="center"><a href="tdddg_connecting001.htm"><img width="24" height="24" src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdddg_connecting003.htm"><img width="24" height="24" src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> </div> <!-- class="footer" --> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de