最新国产好看的视频,伊人天堂AV在线,国产Aaaaaa视频,蜜臀视频在线观看一区,人妻av色图,密臀久久久精品影片,青青视频免费观看毛片,久草在线观看视,国产三级精品色情在线

windows環(huán)境下重建oracle監(jiān)聽(tīng)方式

 更新時(shí)間:2026年01月06日 15:58:15   作者:MrZhou周  
文章描述了數(shù)據(jù)庫(kù)監(jiān)聽(tīng)啟動(dòng)失敗的解決過(guò)程,包括修改listenr.ora文件、啟動(dòng)監(jiān)聽(tīng)、配置tnsnames.ora內(nèi)容和注冊(cè)服務(wù)

windows環(huán)境下重建oracle監(jiān)聽(tīng)

由于某種原因?qū)е聰?shù)據(jù)庫(kù)監(jiān)聽(tīng)啟動(dòng)失敗,需要重新創(chuàng)建監(jiān)聽(tīng)。

過(guò)程如下:

第一步

修改 listenr.ora 文件 ,增加新的監(jiān)聽(tīng)配置

 LISTENER4 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = DESKTOP-BE6GDNT)(PORT = 1528))
    )
  )

ADR_BASE_LISTENER4 = D:\app\zhou

第二步

啟動(dòng)監(jiān)聽(tīng)

lsnrctl start LISTENER4

日志記錄如下:
C:\Windows\system32>lsnrctl start LISTENER4

LSNRCTL for 64-bit Windows: Version 11.2.0.4.0 - Production on 31-MAY-2024 12:19:07

Copyright (c) 1991, 2013, Oracle.  All rights reserved.

Starting tnslsnr: please wait...

Failed to open service <OracleOraDb11g_home1TNSListenerLISTENER4>, error 1060.
TNSLSNR for 64-bit Windows: Version 11.2.0.4.0 - Production
System parameter file is D:\app\zhou\product\11.2.0\dbhome_1\network\admin\listener.ora
Log messages written to D:\app\zhou\diag\tnslsnr\DESKTOP-BE6GDNT\listener4\alert\log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DESKTOP-BE6GDNT)(PORT=1528)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=DESKTOP-BE6GDNT)(PORT=1528)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER4
Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.4.0 - Production
Start Date                31-MAY-2024 12:19:13
Uptime                    0 days 0 hr. 0 min. 6 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   D:\app\zhou\product\11.2.0\dbhome_1\network\admin\listener.ora
Listener Log File         D:\app\zhou\diag\tnslsnr\DESKTOP-BE6GDNT\listener4\alert\log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DESKTOP-BE6GDNT)(PORT=1528)))
The listener supports no services
The command completed successfully

第三步

配置 tnsnames.ora 內(nèi)容,注冊(cè)服務(wù)

scimdb4 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = DESKTOP-BE6GDNT)(PORT = 1528))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = SCIMSDB)
    )
  )

第四步

注冊(cè)服務(wù)

alter system set local_listener='scimdb2','scimdb3','scimdb4';
alter system register;

總結(jié)

以上為個(gè)人經(jīng)驗(yàn),希望能給大家一個(gè)參考,也希望大家多多支持腳本之家。

相關(guān)文章

最新評(píng)論

清镇市| 莲花县| 同江市| 马边| 黄冈市| 三河市| 贵阳市| 龙门县| 绥宁县| 柘荣县| 穆棱市| 肥西县| 太原市| 庆阳市| 保靖县| 台州市| 维西| 永仁县| 阳谷县| 咸宁市| 龙海市| 子洲县| 会宁县| 太白县| 望奎县| 杭锦旗| 潢川县| 九江市| 靖边县| 扎赉特旗| 思茅市| 大渡口区| 育儿| 新野县| 松潘县| 额济纳旗| 蓝山县| 洮南市| 桂阳县| 泾川县| 广平县|