例程 "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...
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...
记录下刚刚做的一个为一个数据库(t02)配置多个监听(listener)的实验,过程有点小曲折。 (1)新增两个测试的监听,listener.ora的配置内容(可纯手动编辑该文件或使用netca)如下: (LISTENER为系统原有;L1、L2为测试用新增的监听) [sql]view plain copy # listener.ora Network Configuration File: D:\oracle\produc...
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 ...
The SCOPE clause has the same behavior as described for the alter_system_set_clause. SID Specify the SID clause to remove a previously specified setting of this parameter for your instance (that is, a previous ALTER SYSTEM SET ... SID = 'sid' statement). Your instance will assume the ...
CMDSCOPE must be blank, or the local queue manager, if QSGDISP is set to GROUP. ' ' The command is executed on the queue manager on which it was entered. qmgr-name The command is executed on the queue manager you specify, providing the queue manager is active within the queue sharing...
If you reduce the maximum message length for the queue manager, you must also reduce the maximum message length of the SYSTEM.DEFAULT.LOCAL.QUEUE definition. You must also reduce the maximum message length for all other queues defined on the queue manager. This change ensures that the limit of...
Can I EXECUTE a SQL Server Stored Procedure with Parameters and store the result set to a CTE Table so that I can then UNION to it Can I find out the "Listener" name through a SQL Server Query Can i give a rollup an Alias? Can I have a conditional JOIN? Can I have a primary ke...
(7)总结 当监听的端口是默认的1521时,PMON会动态注册该监听(listener); 当监听的端口不是默认的1521时,需要使用alter system set local_listener="T02";来手动注册监听。 Ref:http://warehouse.itpub.net/post/777/472788