- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle DB. was hanging, no error messages in a...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-10-2002 05:49 PM
тАО04-10-2002 05:49 PM
Oracle DB. was hanging, no error messages in alert_LOG , but sys log say something ...
Please help to,
Typical situation, when users were compleining, that db was not responding, I checked, was unable to login to Oracle ,
but the alert_LOG didn't show any error messages.
The system log, was showing some errors, around 4:33pm was, the starting point of system hanging.
How to diagnos the problem? Could it be os or network problem,
Please find the attached file, the content of alert_LOG and system log file, during the time, system hanging.
Please ...
Thanks & Regards
Syed
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-10-2002 06:02 PM
тАО04-10-2002 06:02 PM
Re: Oracle DB. was hanging, no error messages in alert_LOG , but sys log say something ...
/opt/resmon/b
in/resdata -R 148176898 -r /system/events/core_hw/core_hw -n 148176903 -a
(not sure if that is one command or two)
Ron
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-10-2002 06:08 PM
тАО04-10-2002 06:08 PM
Re: Oracle DB. was hanging, no error messages in alert_LOG , but sys log say something ...
You need to execute the following commands:
/opt/resmon/b
in/resdata -R 148176898 -r /system/events/core_hw/core_hw -n 148176903 -a
/opt/resmon/b
in/resdata -R 148176898 -r /system/events/core_hw/core_hw -n 148176904 -a
Since it's pointing to core_hw it's possible you have a HW problem.
HTH,
Jeff
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-10-2002 06:29 PM
тАО04-10-2002 06:29 PM
Re: Oracle DB. was hanging, no error messages in alert_LOG , but sys log say something ...
Thank lot for the response.
I run the following, but,
/opt/resmon/bin/resdata -R 148176898 -r /system/events/core_hw/core_hw -n 148176903 -a
There is no active monitor request for the resource /system/events/core_hw/core_
hw associated with the request id 148176898.
/opt/resmon/bin/resdata -R 148176898 -r /system/events/core_hw/core_hw -n 148176904 -a
There is no active monitor request for the resource /system/events/core_hw/core_
hw associated with the request id 148176898.
So where should I look at this error?
Is there any way to have thorugh check of hardware?
So Please !!!
Thanks & Regards
Syed
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-10-2002 06:34 PM
тАО04-10-2002 06:34 PM
Re: Oracle DB. was hanging, no error messages in alert_LOG , but sys log say something ...
/etc/opt/resmon/log
Should be the client.log
Rgds,
Jeff
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-10-2002 06:37 PM
тАО04-10-2002 06:37 PM
Re: Oracle DB. was hanging, no error messages in alert_LOG , but sys log say something ...
HTH,
Jeff
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-10-2002 11:02 PM
тАО04-10-2002 11:02 PM
Re: Oracle DB. was hanging, no error messages in alert_LOG , but sys log say something ...
Please look into the STM logs.
Your syslog file does not show any point to the error except it tells that it is a core hardware problem(event from the EMS)
check the logs and browse the below link for the errors.
http://docs.hp.com/hpux/onlinedocs/diag/ems/dm_core_hw.htm
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-10-2002 11:21 PM
тАО04-10-2002 11:21 PM
Re: Oracle DB. was hanging, no error messages in alert_LOG , but sys log say something ...
I didn't find much info.in /etc/opt/resmon/log
Going back again, If in our absense (dba), if users compleined, that they were un-able to login to oracle-system.
First definitely we'll look at alert_LOG,
then sys_LOG.
What else we should do, at the O/S or Network level, to diagnos the problem?
Could it be possible that, it was a database problem, but nothing recorded in alert_LOG by oracle?
Please ....
Thanks & Regards
Syed
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-11-2002 01:22 AM
тАО04-11-2002 01:22 AM
Re: Oracle DB. was hanging, no error messages in alert_LOG , but sys log say something ...
Thanks lot, the HP-Doc site refered by you is great.
Can you pls tell more about STM logs?
Regards
Syed
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-11-2002 01:23 AM
тАО04-11-2002 01:23 AM
Re: Oracle DB. was hanging, no error messages in alert_LOG , but sys log say something ...
$ORACLE_HOME/network/log/listener.log
Ruediger