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

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

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

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

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

過程如下:

第一步

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

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

ADR_BASE_LISTENER4 = D:\app\zhou

第二步

啟動監(jiān)聽

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)容,注冊服務(wù)

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

第四步

注冊服務(wù)

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

總結(jié)

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

相關(guān)文章

最新評論

乌拉特后旗| 江陵县| 铜鼓县| 汉川市| 建湖县| 阜南县| 梁山县| 辽中县| 晋城| 怀来县| 旬邑县| 永州市| 阿城市| 古交市| 靖州| 舞钢市| 建昌县| 康定县| 黎川县| 桃源县| 贺兰县| 青阳县| 双峰县| 瓮安县| 华池县| 海兴县| 仁寿县| 金沙县| 石家庄市| 博罗县| 仁布县| 陇西县| 元朗区| 石柱| 类乌齐县| 新民市| 封丘县| 镇沅| 本溪| 东丰县| 乌兰浩特市|