查看Oracle數(shù)據(jù)庫(kù)監(jiān)聽(tīng)是否啟動(dòng)應(yīng)使用lsnrctl命令,命令如下
在寧江等地區(qū),都構(gòu)建了全面的區(qū)域性戰(zhàn)略布局,加強(qiáng)發(fā)展的系統(tǒng)性、市場(chǎng)前瞻性、產(chǎn)品創(chuàng)新能力,以專(zhuān)注、極致的服務(wù)理念,為客戶提供網(wǎng)站設(shè)計(jì)、做網(wǎng)站 網(wǎng)站設(shè)計(jì)制作按需設(shè)計(jì),公司網(wǎng)站建設(shè),企業(yè)網(wǎng)站建設(shè),品牌網(wǎng)站制作,全網(wǎng)整合營(yíng)銷(xiāo)推廣,外貿(mào)網(wǎng)站建設(shè),寧江網(wǎng)站建設(shè)費(fèi)用合理。
$?lsnrctl?status
Connecting?to?(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ocm1.oracle.domain)(PORT=1521)))
STATUS?of?the?LISTENER
————————
Alias?????????????????????LISTENER
Version???????????????????TNSLSNR?for?Linux:?Version?10.2.0.1.0?–?Production
Start?Date????????????????17-MAY-2011?21:03:40
Uptime????????????????????0?days?0?hr.?2?min.?49?sec
Trace?Level???????????????off
Security??????????????????ON:?Local?OS?Authentication
SNMP??????????????????????OFF
Listener?Parameter?File???/u01/app/oracle/product/10.2.1/db/network/admin/listener.ora
Listener?Log?File?????????/u01/app/oracle/product/10.2.1/db/network/log/listener.log
Listening?Endpoints?Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.oracle.domain)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.oracle.domain)(PORT=1522)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.oracle.domain)(PORT=1600)))
Services?Summary…
Service?“POD”?has?1?instance(s).
Instance?“POD”,?status?READY,?has?1?handler(s)?for?this?service…
Service?“POD1″?has?1?instance(s).
Instance?“POD”,?status?UNKNOWN,?has?1?handler(s)?for?this?service…
Service?“PODS”?has?1?instance(s).
Instance?“POD”,?status?READY,?has?2?handler(s)?for?this?service…
Service?“pod_XPT”?has?1?instance(s).
Instance?“POD”,?status?READY,?has?1?handler(s)?for?this?service…
Service?“repos”?has?2?instance(s).
Instance?“repos”,?status?UNKNOWN,?has?1?handler(s)?for?this?service…
Instance?“repos”,?status?READY,?has?1?handler(s)?for?this?service…
Service?“repos_XPT”?has?1?instance(s).
Instance?“repos”,?status?READY,?has?1?handler(s)?for?this?service…
The?command?completed?successfully
lsnrctl命令常用參數(shù):
$?lsnrctl?status:檢查當(dāng)前監(jiān)聽(tīng)器的狀態(tài)
$?lsnrctl?start?[listener-name]?啟動(dòng)所有的監(jiān)聽(tīng)器,可以指定名字來(lái)啟動(dòng)特定的監(jiān)聽(tīng)器
$?lsnrctl?stop?[listener-name]??關(guān)閉所有的監(jiān)聽(tīng)器,可以指定名字來(lái)關(guān)閉特定的監(jiān)聽(tīng)器
$?lsnrctl?reload??重啟監(jiān)聽(tīng)器,此命令可以代替lsnrctl?stop,lsnrctl?start
$?lsnrctl?help??????可以顯示所有可用的監(jiān)聽(tīng)器命令
用 oracle:~ # lsof -i:1521 如果有返回信息,就說(shuō)明偵聽(tīng)是啟用的,如果沒(méi)有返回任何信息說(shuō)明偵聽(tīng)是停用的,或者你用 lsnrctl start。
oracle@oracle:~ lsnrctl start
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 04-JUL-2014 18:28:35
Copyright (c) 1991, 2011, Oracle. All rights reserved.
TNS-01106: Listener using listener name LISTENER has already been started
返回以上信息,說(shuō)明是啟用的。
方法1::
看 oracle監(jiān)聽(tīng)是否啟動(dòng) 在CMD下運(yùn)行如下命令就可以 ?lsnrctl status
正在連接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=spcc)(PORT=1525)))
TNS-12541: TNS:無(wú)監(jiān)聽(tīng)器
TNS-12560: TNS: 協(xié)議適配器錯(cuò)誤
TNS-00511: 無(wú)監(jiān)聽(tīng)器
32-bit Windows Error: 61: Unknown error
LSNRCTL start listener1
啟動(dòng)tnslsnr:請(qǐng)稍候...
這表示沒(méi)有啟動(dòng)。。
方法2:
如果是LINUX系統(tǒng)可以通過(guò)如下命令看進(jìn)程在不在
ps -ef|grep lsn
看 oracle監(jiān)聽(tīng)是否啟動(dòng) 在CMD下運(yùn)行如下命令就可以
lsnrctl status
正在連接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=spcc)(PORT=1525)))
TNS-12541: TNS:無(wú)監(jiān)聽(tīng)器。TNS-12560: TNS: 協(xié)議適配器錯(cuò)誤。TNS-00511: 無(wú)監(jiān)聽(tīng)器
32-bit Windows Error: 61: Unknown error
LSNRCTL start listener1
啟動(dòng)tnslsnr:請(qǐng)稍候...。這表示沒(méi)有啟動(dòng)。。
如果是LINUX系統(tǒng)可以通過(guò)如下命令看進(jìn)程在不在
ps -ef|grep lsn
使用netstst命令查看正在監(jiān)聽(tīng)狀態(tài)的端口:
1、netstat
-nupl
//n表示用數(shù)字形式顯示端口號(hào),u,表示udp協(xié)議類(lèi)型,p是程序pid,l表示處于監(jiān)聽(tīng)狀態(tài)的;
2、netstat
-nuplf|grep
3306
//這個(gè)表示查找處于監(jiān)聽(tīng)狀態(tài)的,端口號(hào)為3306的進(jìn)程
網(wǎng)站標(biāo)題:linux下查看監(jiān)聽(tīng)命令 linux 監(jiān)聽(tīng)
網(wǎng)頁(yè)網(wǎng)址:http://www.chinadenli.net/article20/dddhico.html
成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián),為您提供動(dòng)態(tài)網(wǎng)站、軟件開(kāi)發(fā)、標(biāo)簽優(yōu)化、全網(wǎng)營(yíng)銷(xiāo)推廣、網(wǎng)頁(yè)設(shè)計(jì)公司、手機(jī)網(wǎng)站建設(shè)
聲明:本網(wǎng)站發(fā)布的內(nèi)容(圖片、視頻和文字)以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主,如果涉及侵權(quán)請(qǐng)盡快告知,我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如需處理請(qǐng)聯(lián)系客服。電話:028-86922220;郵箱:631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載,或轉(zhuǎn)載時(shí)需注明來(lái)源: 創(chuàng)新互聯(lián)
營(yíng)銷(xiāo)型網(wǎng)站建設(shè)知識(shí)