摘要:由於修改機器名or IP 導致Oracle TNS Listener不能啟動
在oracle中嘗試啟動 listener 出現
Starting tnslsnr: please wait...
TNSLSNR for 32-bit Windows: Version 10.2.0 .1.0 - Production
System parameter file is D:oracleproduct 10.2.0 db_1networkadminlistener.ora
Log messages written to D:oracleproduct 10.2.0 db_1networkloglistener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=.pipeEXTPROC1ipc
)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=PRCSGI00883.ad.inf
osys.com)(PORT=1521)))
TNS-12545: Connect failed because target host or object does not exist
TNS-12560: TNS:protocol adapter error
TNS-00515: Connect failed because target host or object does not exist
32-bit Windows Error: 49: Unknown error
嘗試過修改
\oracle\product\10.2\network\admin\listener.ora
\oracle\product\10.2\network\admin\tnsnames.ora
不行，
最後在
vi /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
172.16.0.252 localhost.localdomain localhost
修改第一個ＩＰ再reboot，
就能夠啟動TNS Listener