SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=wang)(PORT=1521))'
SQL>
初步判断是因为主机名的问题,进入oracle安装目录中查看监听文件listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = wang)(PORT = 1521))
)
)
HOST是wang,然后用hostname命令查看了一下我的主机名,也是wang。再查看一下linux的配置问题hosts,发现hostname配置错误了,
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
202.200.112.107 oracledb
把上面的oracledb改成了wang,然后启动服务,就好了