ORA-00119 & ORA-00130 when trying to startup Oracle
Well, my teammate found the answer to the problem.

He changed some details in the file 'tnsnames.ora' at ORACLE_HOME\NETWORK\ADMIN. He just replaced “hostname” by “localhost”.

WP5 =
  (DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = &lt;b&gt;localhost&lt;/b&gt;)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = WP5)
    )
  )

LISTENER_WP5 =&lt;br&gt;
  (ADDRESS = (PROTOCOL = TCP)(HOST = &lt;b&gt;localhost&lt;/b&gt;)(PORT = 1521))

A new startup (without leaving sqlplus) made it work!



PS: We still have no ideia why/how it was working before, since the file updated date dates from about 2 weeks ago.