在linux上安裝完oracle資料庫後，如何修改ORACLE_HOSTNAME

標籤：section   ip地址   int   com   oracle資料庫   listen   dmi   class   tns   

1、修改HOSTS檔案，添加JTWF到本機IP地址的映射：

[[email protected] home]# gedit /etc/hosts

最後一行為添加的：

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4::1         localhost localhost.localdomain localhost6 localhost6.localdomain616.54.136.81 JTWF

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

[[email protected] home]# gedit /etc/sysconfig/networkNETWORKING=yesHOSTNAME=JTWF

3、修改listener.ora

su oraclegedit /home/oracle/product/11.2/db_1/network/admin/listener.ora

修改HOST由HOST=localhost改為HOST=JTWF（隨意）：

# listener.ora Network Configuration File: /home/oracle/product/11.2/db_1/network/admin/listener.ora# Generated by Oracle configuration tools.LISTENER =  (DESCRIPTION_LIST =    (DESCRIPTION =      (ADDRESS = (PROTOCOL = TCP)(HOST = JTWF)(PORT = 1521))    )  )ADR_BASE_LISTENER = /home/oracle

4、tnsnames.ora檔案不修改也可，我沒修改

gedit /home/oracle/product/11.2/db_1/network/admin/tnsnames.ora

# tnsnames.ora Network Configuration File: /home/oracle/product/11.2/db_1/network/admin/tnsnames.ora# Generated by Oracle configuration tools.ORCL =  (DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = orcl)    )  )

在linux上安裝完oracle資料庫後，如何修改ORACLE_HOSTNAME