Modify Oracle listening address under Linux

What if your server has switched to IP?

What if your server changed its name?

What about the former little buddy?

What about previous old customers?

It doesn't matter, simply teach you to modify the listening address, old friends casually find!

To modify the listening address first find two files, determine two things!

　First name of your host?

Second your IP address?

Third, where is your listener.ora?

Four, where's your tnsnames.ora?

The original file listens on localhost, and the name is mapped to an IP address in/etc/hosts 127.0.0.1

Lisenter.ora directory in

/opt/oracle/11g/network/admin

LISTENER =            = = = (PROTOCOL = IPC) (KEY = EXTPROC1521)) = (PROTOCOL       = TCP) (HOST = 10.1.111.123) (PORT = 1521))    )  =/opt/oracle

Tnsnames.ora

ORCL =      = = (PROTOCOL = TCP) (HOST = 10.1.111.123) (PORT = 1521))    = c18/>= dedicated)      = orcl)    )  )

It is possible to replace localhost with its own IP.