Linux红旗系统下修改oracle11实例名
<p>原数据库实例名称为：orcl 修改为 project</p><h1>1.查询当前设置的实例名</h1>
<p>切换到Oracle用户下</p>
<div class="cnblogs_code">
<pre><span style="font-size: 16px">su <span style="color: rgba(128, 128, 128, 1)">-</span> oracle</span></pre>
</div>
<h2><span style="font-size: 18px">（1）查询配置的实例名称</span></h2>
<div class="cnblogs_Highlighter">
<pre class="brush:sql;gutter:true;"><span style="font-size: 16px">echo ${ORACLE_SID}
</span></pre>
</div>
<h2>（2）查询数据库中的实例名称</h2>
<div class="cnblogs_code">
<pre><span style="font-size: 16px">sqlplus <span style="color: rgba(128, 128, 128, 1)">/</span><span style="color: rgba(0, 0, 0, 1)">nolog
sql</span><span style="color: rgba(128, 128, 128, 1)">></span> conn <span style="color: rgba(128, 128, 128, 1)">/</span><span style="color: rgba(0, 0, 255, 1)">as</span><span style="color: rgba(0, 0, 0, 1)"> sysdba
sql</span><span style="color: rgba(128, 128, 128, 1)">></span> <span style="color: rgba(0, 0, 255, 1)">select</span> instance <span style="color: rgba(0, 0, 255, 1)">from</span> v$thread;</span></pre>
</div>
<h1>2.关闭数据服务</h1>
<h2>（1）关闭数据库服务</h2>
<div class="cnblogs_code">
<pre><span style="font-size: 16px">sqlplus <span style="color: rgba(128, 128, 128, 1)">/</span><span style="color: rgba(0, 0, 0, 1)">nolog
sql</span><span style="color: rgba(128, 128, 128, 1)">></span> conn <span style="color: rgba(128, 128, 128, 1)">/</span><span style="color: rgba(0, 0, 255, 1)">as</span><span style="color: rgba(0, 0, 0, 1)"> sysdba
sql</span><span style="color: rgba(128, 128, 128, 1)">></span> <span style="color: rgba(0, 0, 255, 1)">shutdown</span><span style="color: rgba(0, 0, 0, 1)"> immediate;
sql</span><span style="color: rgba(128, 128, 128, 1)">></span> <span style="color: rgba(0, 0, 255, 1)">exit</span>;</span></pre>
</div>
<h2>（2）关闭监听服务</h2>
<p>在Oracle用户下执行：</p>
<div class="cnblogs_code">
<pre><span style="font-size: 16px">lsnrctl stop</span></pre>
</div>
<p> 查看监听状态</p>
<div class="cnblogs_code">
<pre><span style="font-size: 16px">lsnrctl status</span></pre>
</div>
<h1>3.修改环境变量</h1>
<div class="cnblogs_code">
<pre><span style="font-size: 16px">export ORACLE_UNQNAME<span style="color: rgba(128, 128, 128, 1)">=</span><span style="color: rgba(0, 0, 0, 1)">project
export ORACLE_SID</span><span style="color: rgba(128, 128, 128, 1)">=</span>project</span></pre>
</div>
<h1>4.修改<code>/etc/oratab</code>文件，将sid名由orcl修改为project</h1>
<div class="cnblogs_code">
<pre><span style="font-size: 16px">orcl:<span style="color: rgba(128, 128, 128, 1)">/</span>oracle<span style="color: rgba(128, 128, 128, 1)">/</span>product<span style="color: rgba(128, 128, 128, 1)">/</span><span style="color: rgba(128, 0, 0, 1); font-weight: bold">11.2</span>.<span style="color: rgba(128, 0, 0, 1); font-weight: bold">0</span><span style="color: rgba(128, 128, 128, 1)">/</span>db_1:N <span style="color: rgba(128, 128, 128, 1)">-></span> project:<span style="color: rgba(128, 128, 128, 1)">/</span>oracle<span style="color: rgba(128, 128, 128, 1)">/</span>product<span style="color: rgba(128, 128, 128, 1)">/</span><span style="color: rgba(128, 0, 0, 1); font-weight: bold">11.2</span>.<span style="color: rgba(128, 0, 0, 1); font-weight: bold">0</span><span style="color: rgba(128, 128, 128, 1)">/</span>db_1:N</span></pre>
</div>
<h1> 5.进入到$ORACLE_HOME/dbs目录</h1>
<div class="cnblogs_code">
<pre><span style="font-size: 16px"><span style="color: rgba(0, 0, 0, 1)">cd ${ORACLE_HOME}
cd .</span><span style="color: rgba(128, 128, 128, 1)">/</span>dbs</span></pre>
</div>
<p> 进入目录后修改文件（现场情况可能不一样，可以用ll命令展示全部的文件，然后将带有原实例名的字样修改成新实例名的字样，要区分大小写）</p>
<div class="cnblogs_code">
<pre><span style="color: rgba(0, 0, 0, 1); font-size: 16px">mv hc_orcl.dat hc_project.dat
mv lkORCL lkPROJECT
mv orapworcl orapwproject
mv spfileorcl.ora spfileproject.ora</span></pre>
</div>
<p> </p>
<h1>6.重建文件</h1>
<div class="cnblogs_code">
<pre><span style="font-size: 16px">orapwd <span style="color: rgba(0, 0, 255, 1)">file</span><span style="color: rgba(128, 128, 128, 1)">=</span>$ORACLE_HOME<span style="color: rgba(128, 128, 128, 1)">/</span>dbs<span style="color: rgba(128, 128, 128, 1)">/</span>orapw$ORACLE_SID password<span style="color: rgba(128, 128, 128, 1)">=</span><span style="color: rgba(128, 0, 0, 1); font-weight: bold">123456</span> entries<span style="color: rgba(128, 128, 128, 1)">=</span><span style="color: rgba(128, 0, 0, 1); font-weight: bold">5</span> force<span style="color: rgba(128, 128, 128, 1)">=</span>y</span></pre>
</div>
<h1>7.重启oracle服务</h1>
<div class="cnblogs_code">
<pre><span style="font-size: 16px">sqlplus <span style="color: rgba(128, 128, 128, 1)">/</span> <span style="color: rgba(0, 0, 255, 1)">as</span><span style="color: rgba(0, 0, 0, 1)"> sysdba
sql</span><span style="color: rgba(128, 128, 128, 1)">></span> startup;</span></pre>
</div>
<h1><span style="color: rgba(255, 0, 0, 1)">补充：修改服务名</span></h1>
<p> </p>
<div class="cnblogs_code">
<pre><span style="font-size: 16px">sqlplus <span style="color: rgba(128, 128, 128, 1)">/</span> <span style="color: rgba(0, 0, 255, 1)">as</span><span style="color: rgba(0, 0, 0, 1)"> sysdba
sql</span><span style="color: rgba(128, 128, 128, 1)">></span> <span style="color: rgba(0, 0, 255, 1)">alter</span> system <span style="color: rgba(0, 0, 255, 1)">set</span> service_names<span style="color: rgba(128, 128, 128, 1)">=</span><span style="color: rgba(255, 0, 0, 1)">'</span><span style="color: rgba(255, 0, 0, 1)">PROJECT</span><span style="color: rgba(255, 0, 0, 1)">'</span><span style="color: rgba(0, 0, 0, 1)">;
sql</span><span style="color: rgba(128, 128, 128, 1)">></span> <span style="color: rgba(0, 0, 255, 1)">alter</span> system <span style="color: rgba(0, 0, 255, 1)">set</span> db_unique_name<span style="color: rgba(128, 128, 128, 1)">=</span><span style="color: rgba(255, 0, 0, 1)">'</span><span style="color: rgba(255, 0, 0, 1)">PROJECT</span><span style="color: rgba(255, 0, 0, 1)">'</span> scope<span style="color: rgba(128, 128, 128, 1)">=</span><span style="color: rgba(0, 0, 0, 1)">spfile;
sql</span><span style="color: rgba(128, 128, 128, 1)">></span> <span style="color: rgba(0, 0, 255, 1)">alter</span> system <span style="color: rgba(0, 0, 255, 1)">set</span> instance_name<span style="color: rgba(128, 128, 128, 1)">=</span><span style="color: rgba(255, 0, 0, 1)">'</span><span style="color: rgba(255, 0, 0, 1)">PROJECT</span><span style="color: rgba(255, 0, 0, 1)">'</span> scope<span style="color: rgba(128, 128, 128, 1)">=</span><span style="color: rgba(0, 0, 0, 1)">spfile;
sql</span><span style="color: rgba(128, 128, 128, 1)">></span> <span style="color: rgba(0, 0, 255, 1)">shutdown</span><span style="color: rgba(0, 0, 0, 1)"> immediate;
sql</span><span style="color: rgba(128, 128, 128, 1)">></span> startup;</span></pre>
</div>
<p> </p><br><br>
来源：https://www.cnblogs.com/BKYhailong/p/18509696
頁:
[1]