linux 启动oracle服务器
<h1 class="postTitle">Linux下启动/关闭Oracle</h1><div class="clear"> </div>
<div class="postBody">
<div id="cnblogs_post_body" class="blogpost-body blogpost-body-html">
<p>一、Linux下启动Oracle</p>
<p> Linux下启动Oracle分为两步：</p>
<p> 1）启动监听；</p>
<p> 2）启动数据库实例；</p>
<p> </p>
<p>1.登录服务器，切换到oracle用户，或者以oracle用户登录</p>
<div class="cnblogs_code">
<pre>$ su - oracle
密码：
$</pre>
</div>
<p>2.打开监听服务</p>
<div class="cnblogs_code">
<pre>$ lsnrctl start</pre>
</div>
<p>可以通过lsnrctl status命令查看Oracle监听器运行状况</p>
<div class="cnblogs_code">
<pre>$ lsnrctl status
</pre>
</div>
<p>3.以SYS用户身份登录Oracle</p>
<div class="cnblogs_code">
<div class="cnblogs_code_toolbar"><span class="cnblogs_code_copy"><img src="https://common.cnblogs.com/images/copycode.gif"></span></div>
<pre>$ sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Fri Dec 1 23:29:19 2017
Copyright (c) 1982, 2009, Oracle.All rights reserved.
SQL> conn /as sysdba
Connected to an idle instance.</pre>
<div class="cnblogs_code_toolbar"><span class="cnblogs_code_copy"><img src="https://common.cnblogs.com/images/copycode.gif"></span></div>
</div>
<p>切换用户：</p>
<p>CONN 用户名/密码 ，如果是sys用户一定要写上AS SYSDBA</p>
<p>4.通过startup命令启动实例</p>
<div class="cnblogs_code">
<div class="cnblogs_code_toolbar"><span class="cnblogs_code_copy"><img src="https://common.cnblogs.com/images/copycode.gif"></span></div>
<pre>SQL> startup
ORACLE instance started.
Total System <br>... ...<br>Database mounted.
Database opened.
SQL></pre>
<div class="cnblogs_code_toolbar"><span class="cnblogs_code_copy"><img src="https://common.cnblogs.com/images/copycode.gif"></span></div>
</div>
<p> </p>
<p>二、Linux下关闭Oracle</p>
<p>1.关闭数据库实例</p>
<div class="cnblogs_code">
<div class="cnblogs_code_toolbar"><span class="cnblogs_code_copy"><img src="https://common.cnblogs.com/images/copycode.gif"></span></div>
<pre>SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.<br>SQL> quit<br>Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production<br>With the Partitioning, OLAP, Data Mining and Real Application Testing options</pre>
<div class="cnblogs_code_toolbar"><span class="cnblogs_code_copy"><img src="https://common.cnblogs.com/images/copycode.gif"></span></div>
</div>
<p>2.关闭监听器</p>
<div class="cnblogs_code">
<pre>$ lsnrctl stop</pre>
</div>
</div>
</div><br><br>
来源：https://www.cnblogs.com/xsdf/p/14481432.html
頁:
[1]