Home » RDBMS Server » Performance Tuning » Solution for database hung (Oracle 11.2.0.4,Linux 6)
Solution for database hung [message #677942] Fri, 25 October 2019 01:05 Go to next message
BalajiDBA
Messages: 139
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
Re: Solution for database hung [message #677944 is a reply to message #677942] Fri, 25 October 2019 01:26 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
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 Go to previous messageGo to next message
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
Re: Solution for database hung [message #677964 is a reply to message #677942] Sat, 26 October 2019 01:44 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
You might get somewhere with
sqlplus -prelim / as sysdba
Re: Solution for database hung [message #678125 is a reply to message #677961] Tue, 12 November 2019 06:10 Go to previous messageGo to next message
BalajiDBA
Messages: 139
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.
Re: Solution for database hung [message #678133 is a reply to message #678125] Tue, 12 November 2019 12:09 Go to previous messageGo to next message
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
Re: Solution for database hung [message #678138 is a reply to message #678133] Tue, 12 November 2019 23:43 Go to previous messageGo to next message
BalajiDBA
Messages: 139
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.
Re: Solution for database hung [message #678142 is a reply to message #678138] Wed, 13 November 2019 02:46 Go to previous messageGo to next message
cookiemonster
Messages: 13917
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.
Re: Solution for database hung [message #678148 is a reply to message #678142] Wed, 13 November 2019 03:35 Go to previous messageGo to next message
BalajiDBA
Messages: 139
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.
Re: Solution for database hung [message #678149 is a reply to message #678148] Wed, 13 November 2019 03:37 Go to previous messageGo to next message
cookiemonster
Messages: 13917
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.
Re: Solution for database hung [message #678157 is a reply to message #678148] Wed, 13 November 2019 07:42 Go to previous messageGo to next message
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
Re: Solution for database hung [message #678158 is a reply to message #678157] Wed, 13 November 2019 07:52 Go to previous message
BalajiDBA
Messages: 139
Registered: October 2018
Location: India
Senior Member
Thank you
Previous Topic: Disk file operations i/o
Next Topic: Top SQL and Top sessions
Goto Forum:
  


Current Time: Thu Mar 28 05:47:11 CDT 2024