Home » RDBMS Server » Server Administration » server hang very often (windows 2000 server oracle 9i)
server hang very often [message #547365] Wed, 14 March 2012 00:45 Go to next message
mrdb
Messages: 62
Registered: December 2009
Location: dubai
Member
hi,

We a running oracle9i database and forms 6i appication.

We have 4 gb ram size and sized the sga for 700mb pga for 400mb
for past 4 months there is no problem.

Now from last week we encounter the server hang, and we do restart.
How to check reason for hanging.
what are all the check list to carried out.

pls help

Report message to a moderator

Re: server hang very often [message #547374 is a reply to message #547365] Wed, 14 March 2012 01:38 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What did you do "last week"? Install any new software? If so, which one?

Report message to a moderator

Re: server hang very often [message #547378 is a reply to message #547374] Wed, 14 March 2012 01:46 Go to previous messageGo to next message
mrdb
Messages: 62
Registered: December 2009
Location: dubai
Member
No there is oracle 9i database alone installed

Report message to a moderator

Re: server hang very often [message #547380 is a reply to message #547365] Wed, 14 March 2012 01:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
What is the evidence the server "hangs"?
What did you do to diagnose this? Copy and paste what you did and got.
Are you sure this comes from Oracle instance?

Regards
Michel

Report message to a moderator

Re: server hang very often [message #547387 is a reply to message #547378] Wed, 14 March 2012 02:02 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
mrdb wrote on Wed, 14 March 2012 07:46
No there is oracle 9i database alone installed

So, no new antivirus, firewall (and such)?

Report message to a moderator

Re: server hang very often [message #547388 is a reply to message #547387] Wed, 14 March 2012 02:03 Go to previous messageGo to next message
mrdb
Messages: 62
Registered: December 2009
Location: dubai
Member
The evidence is users are not able to connect to the database.
When the users are not able to connect then only we come to know that database server got hangup.
We do mannualy restart the windos 2000 server and shutdown and startup the database.
Since oracle 9i database alone installed we assume that oracle instance was the problem.

Report message to a moderator

Re: server hang very often [message #547391 is a reply to message #547388] Wed, 14 March 2012 02:22 Go to previous messageGo to next message
mrdb
Messages: 62
Registered: December 2009
Location: dubai
Member
Little foot,
nod 32 antivirus is installed

Report message to a moderator

Re: server hang very often [message #547394 is a reply to message #547388] Wed, 14 March 2012 02:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
When the users are not able to connect then only we come to know that database server got hangup.


From what?
Ths first I think when a user can't connect is that his network cable is unplugged.

Regards
Michel

Report message to a moderator

Re: server hang very often [message #547398 is a reply to message #547394] Wed, 14 March 2012 02:42 Go to previous messageGo to next message
mrdb
Messages: 62
Registered: December 2009
Location: dubai
Member
Through forms 6i loging in is not possible when the server got hangup.
so they complain about the login, after that we do check the server which is not responding at all.

Report message to a moderator

Re: server hang very often [message #547406 is a reply to message #547398] Wed, 14 March 2012 03:39 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
Through forms 6i loging in is not possible when the server got hangup.

OK.

But the opposite is not true. So the server can go well and the user can't log.
Or if you prefer, this is not because the user can't log that the server hangs.
So prove us (and yourself) the server really hangs (whatever this means for you and you have to tell us).

Regards
Michel

[Updated on: Wed, 14 March 2012 03:39]

Report message to a moderator

Re: server hang very often [message #547419 is a reply to message #547406] Wed, 14 March 2012 04:23 Go to previous messageGo to next message
mrdb
Messages: 62
Registered: December 2009
Location: dubai
Member
I don't know how to give further details to you Michel.

Can you tell me the reasons from the database server hangup if u can.

One of the reasons may be not enough memory, anything else... if u can

Report message to a moderator

Re: server hang very often [message #547421 is a reply to message #547419] Wed, 14 March 2012 04:30 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
Can you tell me the reasons from the database server hangup if u can.


The database does not hang... unless you prove it does.

Regards
Michel

Report message to a moderator

Re: server hang very often [message #547423 is a reply to message #547419] Wed, 14 March 2012 04:44 Go to previous messageGo to next message
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
Senior Member
Hello - I'll try to identify the problem, at least a bit. When you refer to the "the server", do you meant the Oracle instance, or the machine on which it is running? Is it the machine that you say hangs, or is the machine happy and it is the instance that hangs?

[Updated on: Wed, 14 March 2012 04:46]

Report message to a moderator

Re: server hang very often [message #547497 is a reply to message #547423] Wed, 14 March 2012 08:07 Go to previous messageGo to next message
mrdb
Messages: 62
Registered: December 2009
Location: dubai
Member
The machine hang "We do mannualy restart the windos 2000 server " means pressing the restart button.

Report message to a moderator

Re: server hang very often [message #547500 is a reply to message #547497] Wed, 14 March 2012 08:09 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You are saying that - when users report that "it is hanging" - you go to the computer (running under Windows 2000 server), log on (Ctrl + Alt + Del, enter password), and you can't do absolutely nothing because computer doesn't respond, so you need to shut it off and on again.

Is that correct?

Report message to a moderator

Re: server hang very often [message #547501 is a reply to message #547500] Wed, 14 March 2012 08:12 Go to previous messageGo to next message
mrdb
Messages: 62
Registered: December 2009
Location: dubai
Member
It wont look it is always open so no need of ctl+alt+del
when we try to move the mouse or key board doesn't respond. so we press the restart button.

Report message to a moderator

Re: server hang very often [message #547503 is a reply to message #547501] Wed, 14 March 2012 08:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
So why do you think it is something related to the database?
In fact, you don't know anything about the reason.

Regards
Michel

Report message to a moderator

Re: server hang very often [message #547505 is a reply to message #547503] Wed, 14 March 2012 08:58 Go to previous messageGo to next message
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
Senior Member
Exactly. Sounds more like a hardware or OS issue.
I would throw the problem back to the system administrators.

Report message to a moderator

Re: server hang very often [message #547506 is a reply to message #547503] Wed, 14 March 2012 09:04 Go to previous messageGo to next message
mrdb
Messages: 62
Registered: December 2009
Location: dubai
Member
If it is not related to database then the server machine should have hangup in the mid night.
why it always hangup in the working hours.
Tell me the possible reason for server machine hangup.
Like virus signature updates, or any server updates .. and os on tell me the reasons like this .
If sga and pga was not properly sized will the database work properly.
Three months before the same problem eventhough there is 4 GB of RAM the database was using only 300MB
we configured it by give SGA - 700 MB and PGA -- 400 totally 1100mb of RAM used then other parameter like process parameter was set from 150 to 200, then currently using schema objects are moved to separate tablespace, all the index were move to sepearate index tablespace. After that the server hangup stoped and it was working fine for past 3 months,
Suddenly from last week it started hangingup again.

Report message to a moderator

Re: server hang very often [message #547508 is a reply to message #547506] Wed, 14 March 2012 09:07 Go to previous message
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
Senior Member
Sorry, I can't advise on what make a WIndows box hang. Particularly not when you don't ever say "thank you".

Report message to a moderator

Previous Topic: ORA-00054 resource busy and acquire with NOWAIT specified or timed expired
Next Topic: Regarding Opatch Utility
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 01 14:33:21 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.