例程 "t02", 状态 READY, 包含此服务的 1 个处理程序... 命令执行成功 LSNRCTL> set curr L2 目前的监听程序为 L2 LSNRCTL> status 正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=PC1255-20110528)(PORT=1523))) LISTENER 的 STATUS --- 别名 L2 版本 TNSLSNR for 32-bit Windows: Version 10.2...
一阵google之后发现,如果默认端口不是1521,则需要设置LOCAL_LISTENER来手动指定监听别名: When configuring the listener to listen on TCP/IP, you should enter the default port of 1521. If you do not, you must configure the LOCAL_LISTENER parameter in the intialization parameter file and resolve the l...
记录下刚刚做的一个为一个数据库(t02)配置多个监听(listener)的实验,过程有点小曲折。 (1)新增两个测试的监听,listener.ora的配置内容(可纯手动编辑该文件或使用netca)如下: (LISTENER为系统原有;L1、L2为测试用新增的监听) [sql]view plain copy # listener.ora Network Configuration File: D:\oracle\produc...
LSNRCTL> set curr L1 目前的监听程序为 L1 LSNRCTL> status 正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=PC1255-20110528)(PORT=1522))) LISTENER 的 STATUS --- 别名 L1 版本 TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production 启动日期 24-7月 -2011 22:14:19 正常运行时间 0...
set_encryption_key::= Description of the illustration set_encryption_key.eps shutdown_dispatcher_clause::= Description of the illustration shutdown_dispatcher_clause.eps alter_system_set_clause::= Description of the illustration alter_system_set_clause.eps ...
As a result, clients may not be able to access the services for as long as 60 seconds after the listener is started. See Also: Oracle9i Database Concepts and Oracle9i Net Services Administrator's Guide for information on the PMON background process and listeners alter_system_set_clause ...
ALTER SESSION SET EVENTS and ALTER SYSTEM SET EVENTS are undocumented in the Oracle9 i and Oracle10 g Oracle Database SQL Reference manuals as well as in Oracle Database SQL Language Reference 11g Release 1 . The manual Oracle Database Performance Tuning Guide 10g Release 2 contains an ALTER...
SQL> alter system register; 2 You will need to re-register your instance with the listener with “alter system” if you have restarted the listener, or if you started the database instance before starting the listener。(例如,数据库还启动着,这时stop listener,然后启动,就需要手动注册) ...
LIKE(SYSTEM.DEFAULT.LISTENER) A default listener is provided but it can be altered by the installation of the default values required. See Rules for naming IBM WebSphere MQ objects . LOCLNAME(string) The NetBIOS local name that the listener uses. This parameter is valid only on Windows wh...
LISTENER ‘dns_name’ ( <add_listener_option> ) | MODIFY LISTENER ‘dns_name’ ( <modify_listener_option> ) | RESTART LISTENER ‘dns_name’ | REMOVE LISTENER ‘dns_name’ | OFFLINE } [ ; ] <set_option_spec> ::= AUTOMATED_BACKUP_PREFERENCE = { PRIMARY | SECONDARY_ONLY| SECONDARY |...