# LISTENER.ORA Network Configuration File: E:\oracle\ora92\network\admin\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
? (DESCRIPTION_LIST =
??? (DESCRIPTION =
????? (ADDRESS_LIST =
??????? (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
????? )
????? (ADDRESS_LIST =
??????? (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.8.137)(PORT = 1521))
????? )
??? )
? )
SID_LIST_LISTENER =
? (SID_LIST =
??? (SID_DESC =
????? (SID_NAME = PLSExtProc)
????? (ORACLE_HOME = E:\oracle\ora92)
????? (PROGRAM = extproc)
??? )
??? (SID_DESC =
????? (GLOBAL_DBNAME = dev)
????? (ORACLE_HOME = E:\oracle\ora92)
????? (SID_NAME = dev)
??? )
? )
這個(gè)文件，注意IP地址是127.0.0.1? 這樣是一個(gè)不錯(cuò)的選擇，你的數(shù)據(jù)庫(kù)只有你能用，修改成你的機(jī)器的IP地址后，整個(gè)局域網(wǎng)上的用戶(hù)可以用啊！
這樣別人在連接你的數(shù)據(jù)庫(kù)的時(shí)候會(huì)提示，無(wú)偵聽(tīng)器，其實(shí)你有的。
posted on 2006-11-28 10:28
壞男孩 閱讀(958)
評(píng)論(0) 編輯 收藏 所屬分類(lèi):
ORACLE篇章