一阵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...
SQL> select status,instance_name from v$instance; STATUS INSTANCE_NAME --- --- OPEN t02 SQL> alter system set local_listener="T02"; 系统已更改。 SQL> (6)验证,再测试: 验证,发现L1、L2已能正常注册服务: LSNRCTL> set curr L1 目前的监听程序为 L1 LSNRCTL> status 正在连接到 (DESCRIPTION=(A...
SQL> select status,instance_name from v$instance; STATUS INSTANCE_NAME --- --- OPEN t02 SQL> alter system set local_listener="T02"; 系统已更改。 SQL> (6)验证,再测试: 验证,发现L1、L2已能正常注册服务: LSNRCTL> set curr L1 目前的监听程序为 L1 LSNRCTL> status 正在连接到 (DESCRIPTION=(A...
记录下刚刚做的一个为一个数据库(t02)配置多个监听(listener)的实验,过程有点小曲折。 (1)新增两个测试的监听,listener.ora的配置内容(可纯手动编辑该文件或使用netca)如下: (LISTENER为系统原有;L1、L2为测试用新增的监听) [sql]view plain copy
// set a higher IP connection rate quota override, verify that the higher limit is now enforced val newRateLimit = 18 updateIpConnectionRate(Some(localAddress.getHostAddress), newRateLimit) verifyConnectionRate(14, newRateLimit, "PLAINTEXT", ignoreIOExceptions = true) waitForConnectionCount(initi...
Cannot open backup device 'C:\TEMP\Demo.bak'. Operating system error 2(The system cannot find the file specified.). Cannot parse using OPENXML with namespace Cannot promote the transaction to a distributed transaction because there is an active save point in this transaction Cannot resolve colla...
BEGIN TRAN; -- Set SYSTEM_VERSIONING to OFF ALTER TABLE [dbo].[YourTable] SET (SYSTEM_VERSIONING = OFF); -- Drop Primary Key ALTER TABLE [dbo].[YourTable] DROP CONSTRAINT [PK_YourTable]; -- Alter table to update int to bigint on the PK column ALTER TABLE [dbo].[YourTable] A...
当监听的端口是默认的1521时,PMON会动态注册该监听(listener); 当监听的端口不是默认的1521时,需要使用alter system set local_listener="T02";来手动注册监听。 Ref: http://warehouse.itpub.net/post/777/472788">http://warehouse.itpub.net/post/777/472788...
记录下刚刚做的一个为一个数据库(t02)配置多个监听(listener)的实验,过程有点小曲折。 (1)新增两个测试的监听,listener.ora的配置内容(可纯手动编辑该文件或使用netca)如下: (LISTENER为系统原有;L1、L2为测试用新增的监听) # listener.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\networ...