Question

怎么配置oracle的监听

Answer 1

用net manager->监听程序，点击要配置的监听，一般参数不做修改，监听位置，协议一般我是选tcp/ip,主机就填localhost ,数据库服务:填你要监听的数据库sid和数据库主目录，其他服务：程序名：extproc;sid:CLRExtProc;oracle主目录：按安装途径填写就好了，然后重启oracle 的监听服务

Answer 2

SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = D:\oraclexe\app\oracle\product\11.2.0\server) (PROGRAM = extproc) ) (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = D:\oraclexe\app\oracle\product\11.2.0\server) (PROGRAM = extproc) ) )
LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) (ADDRESS = (PROTOCOL = TCP)(HOST = Dang-PC)--Dang-PC是算机名(PORT = 1521)) ) )
DEFAULT_SERVICE_LISTENER = (XE)--XE是对象名
就这两个要改，其他的不用动