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>