在linux上安装完oracle数据库后，如何修改ORACLE_HOSTNAME

最后一行为添加的：

127<span class="hljs-selector-class">.0<span class="hljs-selector-class">.0<span class="hljs-selector-class">.1   <span class="hljs-selector-tag">localhost <span class="hljs-selector-tag">localhost<span class="hljs-selector-class">.localdomain <span class="hljs-selector-tag">localhost4 <span class="hljs-selector-tag">localhost4<span class="hljs-selector-class">.localdomain4
<span class="hljs-selector-pseudo">::1         <span class="hljs-selector-tag">localhost <span class="hljs-selector-tag">localhost<span class="hljs-selector-class">.localdomain <span class="hljs-selector-tag">localhost6 <span class="hljs-selector-tag">localhost6<span class="hljs-selector-class">.localdomain6
16<span class="hljs-selector-class">.54<span class="hljs-selector-class">.136<span class="hljs-selector-class">.81 <span class="hljs-selector-tag">JTWF</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span>

2、修改/etc/sysconfig/network添加如下：

<span class="hljs-section">[root@JTWF home]<span class="hljs-comment"># gedit /etc/sysconfig/network
<span class="hljs-attr">NETWORKING=<span class="hljs-literal">yes
<span class="hljs-attr">HOSTNAME=JTWF</span></span></span></span></span>

3、修改listener.ora

su oracle
gedit <span class="hljs-regexp">/home/oracle<span class="hljs-regexp">/product/<span class="hljs-number">11.2<span class="hljs-regexp">/db_1/network<span class="hljs-regexp">/admin/listener.ora</span></span></span></span></span>

修改HOST由HOST=localhost改为HOST=JTWF（随意）：

# listener.ora Network Configuration <span class="hljs-keyword">File: <span class="hljs-regexp">/home/oracle<span class="hljs-regexp">/product/<span class="hljs-number">11.2<span class="hljs-regexp">/db_1/network<span class="hljs-regexp">/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
  (DESCRIPTION_LIST =
    (<span class="hljs-keyword">DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = JTWF)(PORT = <span class="hljs-number">1521))
    )
  )
ADR_BASE_LISTENER = <span class="hljs-regexp">/home/oracle</span></span></span></span></span></span></span></span></span>

4、tnsnames.ora文件不修改也可，我没修改

gedit <span class="hljs-regexp">/home/oracle<span class="hljs-regexp">/product/<span class="hljs-number">11.2<span class="hljs-regexp">/db_1/network<span class="hljs-regexp">/admin/tnsnames.ora</span></span></span></span></span>

# tnsnames.ora Network Configuration <span class="hljs-keyword">File: <span class="hljs-regexp">/home/oracle<span class="hljs-regexp">/product/<span class="hljs-number">11.2<span class="hljs-regexp">/db_1/network<span class="hljs-regexp">/admin/tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
  (<span class="hljs-keyword">DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = <span class="hljs-number">1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )</span></span></span></span></span></span></span></span>

在linux上安装完oracle数据库后，如何修改ORACLE_HOSTNAME

标签：section   ip地址   int   com   oracle数据库   listen   dmi   class   tns