各位老大，別見笑！

自從有了10g被該死的偵聽器折磨好幾次了，估計該遇到的問題全遇到了一次關於解決資料庫偵聽的小經歷

這個只是其中一個小小的問題...

好好的報表伺服器的資料庫突然有人說登陸不了了，PL/SQLdeveloper登陸報Ora-12541:TNS:沒有監聽器的錯誤，而SQLPlus以本機登陸卻是好好的，百思不得其解；因專案原因還是自己動手儘快解決吧。

1.手工在windows的服務中重啟tns監聽服務，起不來
2.Check windows的application日誌，未發現有價值訊息
3.Check windows的system日誌，未發現有價值訊息
4.手工在命令列方式下檢視lsnrctl status和lsnrctl start，發現在start過程中TNS-12545: Connect failed because target host or object does not exist
5.核對機器名和listener.ora中的機器名發現不一致，修改好重新啟動，一切OK

NND，原來被那些搞公司系統檢查的人把機器名給改了，連個通知也沒有！一次關於解決資料庫偵聽的小經歷

Microsoft Windows [Version 5.2.3790]

C:\Documents and Settings\Administrator>lsnrctl

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 03-JAN-2008 09:54:54

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> status

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

32-bit Windows Error: 2: No such file or directory

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=PRCSGI00883.ad.infosys.c

om)(PORT=1521)))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

32-bit Windows Error: 61: Unknown error

LSNRCTL> start

Starting tnslsnr: please wait...

TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production

System parameter file is D:\oracle\product\10.2.0\db_1\network\admin\listener.ora

Log messages written to D:\oracle\product\10.2.0\db_1\network\log\listener.log

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc

)))

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

Listener failed to start. See the error message(s) above...

--Modify the IP address in listener.ora then start

LSNRCTL> start

Starting tnslsnr: please wait...

TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production

System parameter file is D:\oracle\product\10.2.0\db_1\network\admin\listener.ora

Log messages written to D:\oracle\product\10.2.0\db_1\network\log\listener.log

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc

)))

Listeningon: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=PRCSGI01177.ad.infosys.com)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))

STATUS of the LISTENER

------------------------

Alias LISTENER

Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production

Start Date 03-JAN-2008 09:57:02

Uptime 0 days 0 hr. 0 min. 3 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File D:\oracle\product\10.2.0\db_1\network\admin\listener.ora

Listener Log File D:\oracle\product\10.2.0\db_1\network\log\listener.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=PRCSGI01177.ad.infosys.com)(PORT=152

1)))

Services Summary...

Service "PLSExtProc" has 1 instance(s).

Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

LSNRCTL>

一次關於解決資料庫偵聽的小經歷

相關文章