10G listener问题，急

ZALBB · 发表于 2007-4-4 15:22

我的意见是，在没正式投产前，尽量使用高补丁，因为之前低补丁的BUG可能在
高版本修复，若此版本都没法修复，则之前的低版本就更不用说了。

用上之后，若有问题，在继续打补丁。

kevensun · 发表于 2007-4-4 15:50

痛苦的是我的生产环境已经是10.2.0.1了。
metalink 上有
https://metalink.oracle.com/meta ... 868542:::

https://metalink.oracle.com/meta ... 868542:::

ZALBB · 发表于 2007-4-4 16:01

如果确定是BUG，则打上相应的补丁了。

刚上的系统，升级到10203应该没问题。

你可以解释，系统应用之初，有问题是正常的。

kevensun · 发表于 2007-4-4 16:30

好吧，没办法的时候再升级一次。有任何结果再和大家分享。

ZALBB · 发表于 2007-4-5 09:20

道理很简单，系统在使用前，谁也不知道挂靠到哪个版本的数据库比较好使，
所以此时我宁可相信高补丁的版本，毕竟补丁上面罗列的BUG是摆着的。

使用后再发现有BUG，则再打补丁或想办法避开。

kevensun · 发表于 2007-4-8 21:25

今天升级10.2.0.3.0了,从6点开始使用,目前比较正常.

xwangxwang · 发表于 2007-4-9 03:27

My sense of feeling is like that there might be some problems with your SGA setting. For a system with 6G memory, 1.2G for GSA is too much smalll and 1.2G PGA a little bit bigger. You could consider to modify those parameters. Other issue which come up to my mind is that from dump file, we see there is an error associated with KGL layer which normally is for library cache and internal memomry allocation and deallocation. So the problem might be with library cache and shared pool if you see the reported error. The libarary cache couldn't allocate certain trunk of memories for session SQL cursors. Third issue is that you might consider the cursor related parameter such as cursor_sharing, cursor_space_for_time or so but that might be the solution for this issue. Finally you might think you hit a 10g R1 bug and you should upgrade or patch your system if that's the case. Hope it helps.

xwangxwang · 发表于 2007-4-9 03:30

I missed one word NOT as below.

Third issue is that you might consider the cursor related parameter such as cursor_sharing, cursor_space_for_time or so but that might NOT be the solution for this issue.

wgz7747 · 发表于 2007-7-17 13:57

我也遇到这个问题了