---
title: "Oracle listener 文件修改"
author: "demojava"
date: "2010-08-27T15:42:02Z"
tags: []
categories: ["数据库"]
slug: "oracle-listener"
draft: false
lastmod: "2011-06-27T09:46:02Z"
id: 749041
url: "https://demojava.iteye.com/blog/749041"
---

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