dispatchers参数修改了，但是show不出来

显示全部楼层 · 2013-9-30 10:17:03

本帖最后由 cdbdp 于 2013-3-26 13:03 编辑
那位大侠能帮忙看看，这是怎么回事
SQL>
SQL>
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area268435456 bytes
Fixed Size
1218892 bytes
Variable Size
67110580 bytes
Database Buffers
197132288 bytes
Redo Buffers
2973696 bytes
Database mounted.
Database opened.
SQL> show parameter disp
NAME
TYPEVALUE
------------------------------------ ----------- ------------------------------
dispatchers
string
max_dispatchers
integer
SQL> alter system set dispatchers='(description=(address=(host=192.168.0.11)(protocol=tcp)(port=1523))(dispatchers=2)(connections=2)(sessions=3)(ticks=5)(service=disp01))' scope=both;
System altered.
SQL>
SQL> show parameter disp
NAME
TYPEVALUE
------------------------------------ ----------- ------------------------------
dispatchers
string
max_dispatchers
integer
SQL>
如上，改了参数后，show不出来，上午是正常的，中午吃个饭，回来重新改了下，就出问题了
SQL> col network for a60
SQL> select name,network from v$dispatcher;
NAME NETWORK---- ------------------------------------------------------------
D000 (ADDRESS=(PROTOCOL=tcp)(HOST=rac1)(PORT=33840))
D001 (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.11)(PORT=33842))
D002 (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.11)(PORT=33843))
D003 (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.11)(PORT=1523))
D004 (description=(address=(host=192.168.0.11)(protocol=tcp)(port=1522,1523))(dispatchers=2)(connections=2)(sessions=3)(ticks=5)(servic
SQL>

千问 · 2013-9-30 10:17:03

不懂

千问 · 2013-9-30 10:17:03

把数据库重启一下

千问 · 2013-9-30 10:17:03

zgdiyy 发表于 2013-3-26 13:09
把数据库重启一下
已经重启了

千问 · 2013-9-30 10:17:03

明白了，dispatchers参数是累加的