- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: How to force oracle to hang
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-14-2003 05:08 AM
тАО04-14-2003 05:08 AM
Re: How to force oracle to hang
how about locking a table in one session or keeping a session active.
and issuing a "shutdown normal" (instead of shutdown immediate)
haven't tried it though..
hth
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-14-2003 05:23 AM
тАО04-14-2003 05:23 AM
Re: How to force oracle to hang
That did the trick - when the redo log filled everything started to hang... and my script did detect the problem.
Dietmar,
Sending a SIGSTOP to pmon didn't seem to have any effect - perhaps I needed to leave it for longer.
Yogeeraj,
I suspect that this will just produce a different error from my monitor script... it logs into the database as a seperate session every time it polls the database, so once a shutdown command has been issued, rather than a hang I'll just get a "ORA-01090: shutdown in progress - connection is not permitted" message from sqlplus.
Any other ideas will also score points. The more different methods I have to test this the better.
Cheers
Duncan
I am an HPE Employee
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-14-2003 05:32 AM
тАО04-14-2003 05:32 AM
Re: How to force oracle to hang
are you running 9i?
If yes, here's the good news!
In 9i, we have an alter database quiesce available with the resource manager.
This'll let you "pause" the system (put people on hold in effect).
Good luck
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-14-2003 05:40 AM
тАО04-14-2003 05:40 AM
Re: How to force oracle to hang
Note that you can find more info in the Oracle9i Data Guard Concepts and Administration Release 2 Chapter 4.
You would do something like:
Ensure that Resource Manager is configured. (Resource Manager is a requirement when putting the database into a quiesced state.)
then
alter system quiesce restricted;
then Unquiesce the system and and switch logfiles:
alter system unquiesce;
alter system switch logfile;
regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-14-2003 06:04 AM
тАО04-14-2003 06:04 AM
Re: How to force oracle to hang
unfortunately I'm on 8i...
but i'll take note for when I have a 9i DB to cluster.
Cheers
Duncan
I am an HPE Employee
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-15-2003 04:57 AM
тАО04-15-2003 04:57 AM
Re: How to force oracle to hang
If you stop archiving as you said on your initial submittal, Oracle may not care if you do a switchlog unless it feels that it has to have dbwriter write the changes before it can re-use the log, it won't hang.
Hope this helps.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-15-2003 08:34 PM
тАО04-15-2003 08:34 PM
Re: How to force oracle to hang
Here is another test method to test your MC/ServiceGuard monitoring scripts.
I have picked this one form another client who accidently caused their database to hang, but seems to be a good test case.
Database will hang after a while (2 hours) if listener is started by root with "su -"
Eg:- "su - oracle -c "lsnrtl start LISTENER_name.world"
We know that the listener needs to be started by the oracle user, not root. It is started as root with the above command, so in fact it should be as if it was started by oracle. This will work fine at the command line. But if it is started in the serviceguard script, with the same command as above everything works fine for about 2 hours. Then every session will start to hang.
Another way to cause your database to hang will be to issue the suspend command.
Database will be suspended by an ALTER SYSTEM SUSPEND statement
The other ways is to fill your archivelog destination directory which others mentioned.
- « Previous
-
- 1
- 2
- Next »