PL-SQL筆記3_Oracle Listener與Listener.ora檔案,lsnrctl(Listener control)
Oracle Net Listener : a separate process that runs on the database server computer. It receives incoming client connection requests and manages the traffic of these requests to the database server.
Listener.ora檔案 : is the configuration file for a listener. It can include the protocol address it is accepting connection requests on a list of the database and other services it is listening for, and control paramaters used by the listener.
預設windows安裝好的位置
C:\app\你的User名\product\21c\homes\OraDB21Home1\network\admin
# listener.ora Network Configuration File: C:\app\chous\product\21c\homes\OraDB21Home1\NETWORK\ADMIN\listener.ora # Generated by Oracle configuration tools. DEFAULT_SERVICE_LISTENER = XE SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = C:\app\chous\product\21c\dbhomeXE) (PROGRAM = extproc) (ENVS = "EXTPROC_DLLS=ONLY:C:\app\chous\product\21c\dbhomeXE\bin\oraclr.dll") ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = LAPTOP-86Q2OIMP.mshome.net)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) )
lsnrctl(Listener control) : is a SQL*Net Utility used for controlling database listeners.
A listener is required for allowing remote (not local) clients to connect to the Oracle database via the network.
lsnrctl status 可以列出所有正在被監聽的服務狀態,常用於檢查連線狀態。
留言
張貼留言