-
already 3 days I worry about a problem of being kicked off the database.
I can connect to Oracle 8.1.5 using VB application. But after any SELECT with a GROUP or an ORDER I dont get back an curser and loose connection. The sqlnet.log says "Protocol adater error".
There is also a trace on the server with "internal or fatal error". In addition to this there comes an ORA-00600 and a stack trace. There are words like HEAP SIZE, BUCKET and FREE SPACE with not to large values - thats why I thing there may be a parameter problem with the memory sizes.
The server gots 640MB RAM. Oracle installation:
SHARED_POOL_SIZE=64M
LARGE_POOL_SIZE=32M
SORT_AREA_SIZE=32000000
DB_BLOCK_BUFFERS=121525 (block_size=2048)
Please give a hint.
Thanks
-
Generally, if you have 600 errors, you'd call Oracle support.
-
Did you try running the query on the sqlprompt. IF not try that and could you post the status of the issue. Though they say ORA-6000 need to be reported, they aren't that fatel to panic. Lets see what happens when you get to execute the query on the sqlplus. Might be a poor design of query.
Sam
