Oracle listener 文件修改

1:在C:\app\Administrator\product\11.1.0\db_2\NETWORK\ADMIN下找到listener.ora文件，
  LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    )
  )

      将其中的HOST = 127.0.0.1 换成主机名， 例如,如果你的主机名lab3-24.则修改成
      HOST = lab3-24

2:1:在C:\app\Administrator\product\11.1.0\db_2\NETWORK\ADMIN下找到tnsnames.ora文件，
ORCL=
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

      将其中的HOST = 127.0.0.1 换成主机名， 例如,如果你的主机名lab3-24.则修改成
      HOST = lab3-24