SLTechnology News&Howtos › Database ›

ORA-00119 error

Shulou Source: shulou.com Published: 2022-06-01 07:35:29 10月03日 Update

When you restart Oracle11g after inadvertently changing the linux hostname, the

ORA-00119: invalid specification for system parameter LOCAL_LISTENER

ORA-00130: invalid listener address'(ADDRESS= (PROTOCOL=TCP) (HOST=aaa) (PORT=1521))'

After observation, it is found that the HOST=aaa is inconsistent with the actual hostname.

NETWORKING=yes

HOSTNAME=XXX

Restart normally after re-changing the hostname consistency.