oracle 错误码 ORA-00119 / ORA-00130

今天启动oracle时居然报错，错误信息如下：

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

思路：

1）首先看看是不是服务端口问题，检查/etc/services文件。

atm-zip-office  1520/tcp                # atm zip office
atm-zip-office  1520/udp                # atm zip office
ncube-lm        1521/tcp                # nCube License Manager
ncube-lm        1521/udp                # nCube License Manager
ricardo-lm      1522/tcp                # Ricardo North America License Manager
ricardo-lm      1522/udp                # Ricardo North America License Manager
cichild-lm      1523/tcp                # cichild
cichild-lm      1523/udp                # cichild
pdap-np         1526/tcp                # Prospero Data Access Prot non-priv
pdap-np         1526/udp                # Prospero Data Access Prot non-priv
tlisrv          1527/tcp                # oracle
tlisrv          1527/udp                # oracle
coauthor        1529/udp                # oracle

发现一切正常，端口号没什么问题，为什么会连接不上呢？

2）接下来怀疑是HOST=win，是不是HOST的问题呢？查看linux的host文件，/etc/hosts。

127.0.0.1        localhost.localdomain localhost
::1        localhost6.localdomain6 localhost6
127.0.0.1        localhost.localdomain localhost
127.0.0.1        oc5603811686.ibm.com oc5603811686

发现并没有win的主机名信息，所以问题应该就出在这儿，不知到为什么win这个主机名被修改了，不管怎样，添加这个主机名应该能解决问题。

127.0.0.1        localhost.localdomain localhost
::1        localhost6.localdomain6 localhost6
127.0.0.1        localhost.localdomain localhost
127.0.0.1        oc5603811686.ibm.com oc5603811686
127.0.0.1    win

 

重新尝试启动oracle，正常。

SQL> startup
ORACLE instance started.

Total System Global Area 1068937216 bytes
Fixed Size            2233344 bytes
Variable Size          658508800 bytes
Database Buffers      402653184 bytes
Redo Buffers            5541888 bytes
Database mounted.
Database opened.
SQL>