修改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)
    )
  )

此外在此目录下还会有原来主机名命名的文件

有可能需要重启系统。