OraFAQ Forum: Performance Tuning » Solution for database hung

Home » RDBMS Server » Performance Tuning » Solution for database hung (Oracle 11.2.0.4,Linux 6)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Solution for database hung [message #677942]

Fri, 25 October 2019 01:05

BalajiDBA
Messages: 129
Registered: October 2018
Location: India

Senior Member

Hi,

Can someone please tell me what are the ways to login to a database when its hung.

Regards,
Balaji

Report message to a moderator

Re: Solution for database hung [message #677944 is a reply to message #677942]

Fri, 25 October 2019 01:26

Michel Cadot
Messages: 68165
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Google?

[Updated on: Fri, 25 October 2019 01:27]

Report message to a moderator

Re: Solution for database hung [message #677961 is a reply to message #677944]

Fri, 25 October 2019 08:37

JPBoileau
Messages: 88
Registered: September 2017

Member

One of the first things you need to do is to figure out WHY the database is hung, if it's even "hung".

Have a look at the alert log and look for anything to indicates an error. Also, have a look at the CPU usage and see if it's pegged at 100%.

JP

Report message to a moderator

Re: Solution for database hung [message #677964 is a reply to message #677942]

Sat, 26 October 2019 01:44

John Watson
Messages: 8702
Registered: January 2010
Location: Global Village

Senior Member

You might get somewhere with
sqlplus -prelim / as sysdba

Report message to a moderator

Re: Solution for database hung [message #678125 is a reply to message #677961]

Tue, 12 November 2019 06:10

BalajiDBA
Messages: 129
Registered: October 2018
Location: India

Senior Member

Have a look at the alert log and look for anything to indicates an error. Also, have a look at the CPU usage and see if it's pegged at 100%.Quote:

But what is the solution when we aren't connected to database and it is hung.

Report message to a moderator

Re: Solution for database hung [message #678133 is a reply to message #678125]

Tue, 12 November 2019 12:09

JPBoileau
Messages: 88
Registered: September 2017

Member

If it's hung, it's hung. You need to figure out WHY first, that will determine what to do next.

JP

Report message to a moderator

Re: Solution for database hung [message #678138 is a reply to message #678133]

Tue, 12 November 2019 23:43

BalajiDBA
Messages: 129
Registered: October 2018
Location: India

Senior Member

Quote:

If it's hung, it's hung. You need to figure out WHY first, that will determine what to do next.

This is what my question is. Could you please tell me how to detemine the issue and resolve it.

Report message to a moderator

Re: Solution for database hung [message #678142 is a reply to message #678138]

Wed, 13 November 2019 02:46

cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester

Senior Member

As mentioned above you need to look in the alert log and see what that says, solution depends on the problem.

Report message to a moderator

Re: Solution for database hung [message #678148 is a reply to message #678142]

Wed, 13 November 2019 03:35

BalajiDBA
Messages: 129
Registered: October 2018
Location: India

Senior Member

Could you please explain in detail how to view alert log file when the db is hung and none of users are connected.

Report message to a moderator

Re: Solution for database hung [message #678149 is a reply to message #678148]

Wed, 13 November 2019 03:37

cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester

Senior Member

It's a file on the server.
You view it in a text editor.

Not sure what else you are asking.

Report message to a moderator

Re: Solution for database hung [message #678157 is a reply to message #678148]

Wed, 13 November 2019 07:42

JPBoileau
Messages: 88
Registered: September 2017

Member

Connect to the server (not the database), either via ssh (Unix) or via Remote Desktop (Windows) as the Oracle user.

Navigate to the directory that contains the alert log, open it via "vi" (Unix) or Notepad (Windows). Go to the bottom and start reading.

JP

Report message to a moderator

Re: Solution for database hung [message #678158 is a reply to message #678157]

Wed, 13 November 2019 07:52

BalajiDBA
Messages: 129
Registered: October 2018
Location: India

Senior Member

Thank you

Report message to a moderator

Previous Topic:	Disk file operations i/o
Next Topic:	Top SQL and Top sessions

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 18 11:27:27 CDT 2022