修改主机名后oracle无法启动

昨天修改了主机名，今天启动报错：

<pre name="code" class="sql">SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=db2)(PORT=1521))'

alert日志：

<pre name="code" class="sql">System parameters with non-default values:
  processes                = 300
  memory_target            = 404M
  control_files            = "/u01/oradata/ora11g/control01.ctl"
  control_files            = "/u01/oradata/ora11g/control02.ctl"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  log_archive_dest_1       = "location=/u01/archivelog"
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=ora11gXDB)"
  session_cached_cursors   = 100
  audit_file_dest          = "/u01/app/oracle/admin/ora11g/adump"
  audit_trail              = "DB"
  db_name                  = "ora11g"
  open_cursors             = 400
  diagnostic_dest          = "/u01/app/oracle"
<strong>USER (ospid: 4846): terminating the instance due to error 119</strong>
Instance terminated by USER, pid = 4846

后来突然想到，修改了主机名，db2不能解析了，那local_listener也被视为无效参数（如果其中HOST=IP应该不受影响）。

所以修改主机名同时也要修改/etc/hosts，修改后192.168.1.3  db2

注：修改主机名的风险是很大的，一般不要去修改。