Home » RDBMS Server » Server Administration » 10G become unresponsive (10.2.0.3, Windows 2003 Server, IA64)
10G become unresponsive [message #320094] Wed, 14 May 2008 01:32 Go to next message
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 #320131 is a reply to message #320094] Wed, 14 May 2008 02:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Now it is too late to know what happened.
Does this occur again?

Regards
Michel
Re: 10G become unresponsive [message #320137 is a reply to message #320131] Wed, 14 May 2008 03:06 Go to previous messageGo to next message
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 Go to previous messageGo to next message
ThomasG
Messages: 3189
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 Go to previous message
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".


Previous Topic: Reg Processes Parameter
Next Topic: 10g Recyclebin
Goto Forum:
  


Current Time: Fri Dec 09 01:49:20 CST 2016

Total time taken to generate the page: 0.07146 seconds