- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- How to detect Oracle db is in process of shutting ...
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
тАО02-07-2006 01:54 AM
тАО02-07-2006 01:54 AM
way to check if db is in process of shutting
down.
I know of one , that is just trying to
log in and receive the ORA error.
But I would like to find other ways as well
for example check an internal table to see what
the status is ?
Any other 'good' ideas of course welcome
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-07-2006 01:57 AM
тАО02-07-2006 01:57 AM
Re: How to detect Oracle db is in process of shutting down
# tail -f /etc/cmcluster/pkgxx/logfile
Regards,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-07-2006 02:01 AM
тАО02-07-2006 02:01 AM
Re: How to detect Oracle db is in process of shutting down
Check the alert.log of your instance.
Normaly it is in $ORACLE_BASE/admin/$instance/bdump
The name can also be alert_instance.log
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-07-2006 02:19 AM
тАО02-07-2006 02:19 AM
Re: How to detect Oracle db is in process of shutting down
I found this in the log
Shutting down instance (immediate)
License high water mark = 17
Sun Feb 5 10:20:23 2006
SHUTDOWN: waiting for logins to complete.
I am puzzled because normally on sunday
there is no activity,
so why is it waiting for logins to complete ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-07-2006 02:39 AM
тАО02-07-2006 02:39 AM
Re: How to detect Oracle db is in process of shutting down
Old, idle connections will do that to you, as well as "up" Apache servers with plsql components for example. Processes that sit around do queue management will regularly have to wake up every so often and see if there is new work process, etc. so that they will have to remain connected.
A full Oracle system with nothing going on rarely has absolutely nothing going on...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-07-2006 03:04 AM
тАО02-07-2006 03:04 AM
Re: How to detect Oracle db is in process of shutting down
Will this be helpful ?
http://forums.dbasupport.com/forums/showpost.php?p=223460&postcount=3
-Arun
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-07-2006 03:37 AM
тАО02-07-2006 03:37 AM
Re: How to detect Oracle db is in process of shutting down
Simply tail your alert log.
Regards,
Simon
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-07-2006 06:29 PM
тАО02-07-2006 06:29 PM
Re: How to detect Oracle db is in process of shutting down
more $ORACLE_LOG/$ORACLE_SID/alert*.log
CONECTS=$(ps -ef|grep -i oracle$ORACLE_SID|grep LOCAL=NO|grep -v grep|awk '{print $2}')
kill -9 $CONECTS
ran
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-07-2006 08:26 PM
тАО02-07-2006 08:26 PM
Re: How to detect Oracle db is in process of shutting down
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-07-2006 08:27 PM