如何更改oracle監聽器的埠
我們知道oracle 預設監聽器埠為1521,為了安全起見如何更改成我們自己定義的埠呢 如1523:
首先 lsnrctl stop
更改listener.ora檔案
# LISTENER.ORA Network Configuration File: D:\oracle\ora92\network\admin\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = d10063)(PORT = 1523))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\ora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = gsid)
(ORACLE_HOME = D:\oracle\ora92)
(SID_NAME = paul)
)
(SID_DESC =
(GLOBAL_DBNAME = paul)
(ORACLE_HOME = D:\oracle\ora92)
(SID_NAME = paul)
)
(SID_DESC =
(GLOBAL_DBNAME = test)
(ORACLE_HOME = D:\oracle\ora92)
(SID_NAME = test)
)
(SID_DESC =
(GLOBAL_DBNAME = copy)
(ORACLE_HOME = D:\oracle\ora92)
(SID_NAME = copy)
)
(SID_DESC =
(GLOBAL_DBNAME = pubtest)
(ORACLE_HOME = D:\oracle\ora92)
(SID_NAME = pubtest)
)
)
tnsnames.ora 檔案
PUBTEST1523 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = d10063)(PORT = 1523))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = pubtest)
)
)
然後再lsnrctl start
就ok了
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7199859/viewspace-262711/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle rac scan監聽更改埠號Oracle
- oracle更改預設埠號,監聽器加密,限制ip訪問Oracle加密
- 【Oracle】修改scan監聽器埠號Oracle
- 【Oracle】修改oracle監聽埠Oracle
- 如何配置多個監聽器不同埠
- 如何更改監聽器日誌檔名稱
- oracle 監聽配置多個埠Oracle
- Oracle 建立非1521埠監聽Oracle
- Oracle 11g 修改監聽埠Oracle
- Oracle資料庫修改LISTENER的監聽埠Oracle資料庫
- Oracle 修改預設監聽埠故障分析Oracle
- oracle之 單例項監聽修改埠Oracle單例
- oracle 監聽器配置Oracle
- 修改oracle監聽佔用的8080埠(轉)Oracle
- 如何發現遠端伺服器上某埠正在監聽的ORACLE例項/服務伺服器Oracle
- Oracle之 11gR2 RAC 修改監聽器埠號的步驟Oracle
- Windows server 防火牆開放oracle監聽埠WindowsServer防火牆Oracle
- oracle 監聽器學習Oracle
- 如何防止網路監聽與埠掃描
- 如何移除事件監聽器事件
- [20160418]修改oracle監聽埠.txtOracle
- oracle監聽【非1521埠】動態註冊Oracle
- 初始化監聽埠
- samba程序與監聽埠Samba
- Tomcat監聽443埠的方法Tomcat
- 說說Oracle監聽器(一)Oracle
- 說說Oracle監聽器(二)Oracle
- Oracle 監聽器日誌解析Oracle
- oracle例項和監聽器Oracle
- windows10怎麼檢視監聽埠_windows10檢視監聽埠的方法Windows
- oracle 11g 修改預設監聽埠1521Oracle
- [20130422]修改oracle監聽埠.txtOracle
- mongodb如何更改埠號MongoDB
- Sqlserver重啟alwayson監聽埠SQLServer
- Oracle 監聽器日誌解析(續)Oracle
- Oracle 監聽Oracle
- Oracle監聽的作用Oracle
- ORACLE 動態註冊,靜態註冊,多個監聽,一個監聽多個埠配置Oracle