| 10G become unresponsive [message #320094] |
Wed, 14 May 2008 01:32  |
felberch
Messages: 3
Registered: May 2008
Location: Germany
|
Junior Member |
|
|
Oracle 10.2.0.3 (Yesterday night we installed the 0.3 patch) The database server is based on IA64 (4 CPU each 2 cores with Windows 2003 Server)
Now my problem:
During load the database starts to behave strange:
The CPU load decrease to 12.5 % (that means only one cpu core runs with 100% and the other cores are on idle)
When the database get in this state no more sql connections would be accepted by the database. Even a connection to the Enterprise Manager is not possible any more. And a open Enterprise Manager window could not be refreshed any more.
We tried to give the database time to heal herselfe but after 30 minutes we gave up.
Because in this state our application seems to not responde. The database answers requests very very slow! (For a search of a specific number 5 minutes)
So the users think the system is down.
The only way to solve this issue, is to restart the database instance.
Any hints or help would be greate!!!
Thanks for your help in advance
|
|
|
|
|
|
| Re: 10G become unresponsive [message #320137 is a reply to message #320131] |
Wed, 14 May 2008 03:06  |
felberch
Messages: 3
Registered: May 2008
Location: Germany
|
Junior Member |
|
|
Not yet.
This is a productive environment with a lot of users online and i dont want to get any angry calls any more ... so we installed the patch this night to reduce possible causes.
I am watching the server at the momten if it will happen again i ll post it.
br.
Chris
|
|
|
|
| Re: 10G become unresponsive [message #320152 is a reply to message #320137] |
Wed, 14 May 2008 03:20 |
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
|
Senior Member |
|
|
Can you run :
SELECT * FROM v$parameter WHERE name = 'cpu_count';
to see how many CPUs Oracle thinks it has?
Also have you looked at the alert log or any trace files that might have been created during the problem?
|
|
|
|
| Re: 10G become unresponsive [message #320158 is a reply to message #320152] |
Wed, 14 May 2008 03:35 |
felberch
Messages: 3
Registered: May 2008
Location: Germany
|
Junior Member |
|
|
54 cpu_count 3 8 8 TRUE FALSE IMMEDIATE TRUE FALSE FALSE FALSE number of CPUs for this instance 1095434542
If i am right the database thinks to have 8 cpus and it is useing the 8 cores.
I did not find any errormessages or something similar in the alert logs. ....
Only when the database is in this strange mode i got login errors "tns protokoll adapter".
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
