ora 03113 [message #220776] |
Thu, 22 February 2007 01:51 |
rsenthil.aag
Messages: 5 Registered: February 2007 Location: bangalore
|
Junior Member |
|
|
Hello all,
Here we have 200 machines connected to the server.
I have a problem on the client machine (NT/XP machines), when i try to connect using oracle client sqlplus 3.1/9.2 or any other applications, i get the error ora-03113.
If the connection is successful also, some time between the transaction the connection breaks.
The issue is very serious as it is a production database, and because of the the production is getting halted.
The memory configuration is as follows
shared pool - 356
buffer cache - 254
large pool - 80
pga - 500
If the service is restarted then it works fine for a day or such and later the problems repeats.
Any suggestion on this is appreciated.
thanks in advance
rsenthil
|
|
|
|
|
|
|
|
|
Re: ora 03113 [message #220796 is a reply to message #220791] |
Thu, 22 February 2007 03:08 |
rsenthil.aag
Messages: 5 Registered: February 2007 Location: bangalore
|
Junior Member |
|
|
Hey Taj,
that is what Taj, i get the error message every second, for instance when i try to log using sqlplus normally you have 3 tries, i try for 2 times and get this error some time later i try for the 3rd time it gets connected. some time, even after few minutes it generates this error, and more importantly, no other ora error messages such as ora 02608 ora ora 03114 with it.
i am completely fed up with this Taj.
regards
rsenthil
|
|
|