Action.c(9): Error -27796: Failed to connect to server "xxx.xxx.xxx.xxx:xx": [10048] Address already in use
Try changing the registry value
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\tcpip\Parameters\TcpTimedWaitDelay to 30
and HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\tcpip\Parameters\MaxUserPort to 65534
and rebooting the machine
See the readme.doc file for more information.
一般发生上述错误,多是用短连接进行测试的。原因一般是网络或者服务堵塞了,超出了windows机器(......
阅读全文
Set
SET SERVEROUT[PUT] {OFF|ON} [SIZE n] [FOR[MAT] {WRA[PPED]|WOR[D_WRAPPED]|TRU[NCATED]}]
A switch of set whether SQLPLUS will display output of store procedure or plsql block.It has no effect on pure sql. Size try to set the output buffer. You can only set value between 2000 and 1000000. Let us see several examples;15:39:34 lab@ORCL>set serverout off
15:40:16 lab@ORCL>select 1 from dual;
1
----------
1
15:40:21 lab@ORCL>begin
15:40:27 2 dbms_output.put_lin......
阅读全文