解决ORA-00119 和ORA-00130问题?

发布时间:2020-07-08 00:00:00

启动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 = sizhuang)(PORT = 1521))
    )
  )

HOST是sizhuang,然后用hostname命令查看了一下我的主机名,也是sizhuang。再查看一下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改成了sizhuang,然后启动服务,就好了


12cOCP

<<