建站
咨詢
售后
建站咨詢
新聞中心
在Oracle 10g環(huán)境下搭建數(shù)據(jù)庫監(jiān)聽，可以按照以下步驟進(jìn)行：
創(chuàng)新互聯(lián)專注于亭湖網(wǎng)站建設(shè)服務(wù)及定制，我們擁有豐富的企業(yè)做網(wǎng)站經(jīng)驗(yàn)。 熱誠為您提供亭湖營銷型網(wǎng)站建設(shè)，亭湖網(wǎng)站制作、亭湖網(wǎng)頁設(shè)計(jì)、亭湖網(wǎng)站官網(wǎng)定制、微信平臺小程序開發(fā)服務(wù)，打造亭湖網(wǎng)絡(luò)公司原創(chuàng)品牌,更為您提供亭湖網(wǎng)站排名全網(wǎng)營銷落地服務(wù)。
1、配置監(jiān)聽器參數(shù)文件
需要?jiǎng)?chuàng)建一個(gè)監(jiān)聽器參數(shù)文件，在Oracle安裝目錄下的networkadmin文件夾中，創(chuàng)建一個(gè)新的文本文件，例如listener.ora，并編輯該文件，添加以下內(nèi)容：
“`
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
“`
HOST和PORT分別表示監(jiān)聽器的主機(jī)名和端口號，如果使用IPC通信，還需要設(shè)置KEY參數(shù)。
2、啟動(dòng)監(jiān)聽器服務(wù)
在命令行中，切換到Oracle安裝目錄下的bin文件夾，然后執(zhí)行以下命令啟動(dòng)監(jiān)聽器服務(wù)：
“`
lsnrctl start
“`
如果一切正常，將看到類似以下的輸出信息：
“`
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service…
The command completed successfully
“`
3、測試監(jiān)聽器服務(wù)
可以使用tnsping命令測試監(jiān)聽器服務(wù)是否正常工作，在命令行中執(zhí)行以下命令：
“`
tnsping orcl
“`
如果一切正常，將看到類似以下的輸出信息：
“`
TNS Ping Utility for 64bit Windows: Version 10.2.0.1.0 Production on 08SEP2022 14:37:49
Using builtin version of tnsping utility.
Truncated binary data: Incorrect information length: expected 24, received 0. Truncated binary data: Incorrect information length: expected 24, received 0. Truncated binary data: Incorrect information length: expected 24, received 0. Truncated binary data: Incorrect information length: expected 24, received 0. Truncated binary data: Incorrect information length: expected 24, received 0. Truncated binary data: Incorrect information length: expected 24, received 0. Truncated binary data: Incorrect information length: expected 24, received 0. Truncated binary data: Incorrect information length: expected 24, received 0. Truncated binary data: Incorrect information length: expected 24, received 0. Truncated binary data: Incorrect information length: expected 24, received 0. Truncated binary data: Incorrect information length: expected 24, received 0. Truncated binary data: Incorrect information length: expected 24, received 0. Truncated binary data: Incorrect information length: expected 24, received 0. Truncated binary data: Incorrect information length: expected 24, received 0. Truncated binary data: Incorrect information length: expected 24, received 0. Truncated binary data: Incorrect information length: expected 24, received 0. Truncated binary data: Incorrect information length: expected 24, received 0. Truncated binary data: Incorrect information length: expected 24, received 0. Truncated binary data: Incorrect information length: expected 24, received 0. Truncated binary data: Incorrect information length: expected 24, received 0. Truncated binary data: Incorrect information length: expected 24, received 0. Truncated binary data: Incorrect information length: expected 24, received 0. Truncated binary data: Incorrect information length: expected 24, received 0. Truncated binary data: Incorrect information length: expected 24, received 0. Truncated binary data: Incorrect information length: expected 24, received 0. Truncated binary data: Incorrect information length: expected 24, received 0. Truncated binary data: Incorrect information length: expected 24, received 0. Truncated binary data: Incorrect information length: expected 24, received 0. Truncated binary data: Incorrect information length: expected 24, received 0. Truncated binary data: Incorrect information length: expected 24, received 0. Truncated binary data: Incorrect information length: expected 24, received 0. Truncated binary data: Incorrect information length: expected
分享標(biāo)題：Oracle10g環(huán)境下的數(shù)據(jù)庫監(jiān)聽搭建實(shí)踐
URL鏈接：http://m.fisionsoft.com.cn/article/coieogc.html
