解决ORA-00119 和ORA-00130问题

jiawang

启动oracle时，用startup命令后，出现了如下错误

SQL> startup

ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=wangjia)(PORT=1521))'

SQL>

初步判断是因为主机名的问题，进入oracle安装目录中查看监听文件listener.ora

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = wangjia)(PORT = 1521))
    )
  )

HOST是wangjia，然后用hostname命令查看了一下我的主机名，也是wangjia。再查看一下linux的配置问题hosts,发现hostname配置错误了，

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.0.137   oracledb

把上面的oracledb改成了wangjia，然后启动服务，就好了