修改linux主機名稱後，oracle需要修改的檔案

背景：將主機名稱從DBT_A改為DBTA

CentOS5.5  ORACLE11gR2

需要修改3個檔案。

[root@DBTA ~]# vi /etc/hosts# Do not remove the following line, or various programs# that require network functionality will fail.127.0.0.1               DBTA localhost::1             localhost6.localdomain6 localhost6

[root@DBTA ~]# vi /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora# Generated by Oracle configuration tools.LISTENER =  (DESCRIPTION_LIST =    (DESCRIPTION =      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))      (ADDRESS = (PROTOCOL = TCP)(HOST = DBTA)(PORT = 1521))    )  )ADR_BASE_LISTENER = /u01/app/oracle

[root@DBTA ~]# vi /u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora# Generated by Oracle configuration tools.ORCL =  (DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP)(HOST = DBTA)(PORT = 1521))    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = orcl)    )  )

此外在此目錄下還會有原來主機名稱命名的檔案

有可能需要重啟系統。