Re: Database Hang On Shutdown

Hi Scott,

I think, it doesn't have but.. has any process doing a transaction or rollback ? on a new database.. this is a strange behavior.

Shutdown Immediate Hang Situations

http://mammqm.blogspot.com/2016/04/shutdown-immediate-hang-situations.html

regards,
angelo

On Thu, 3 Sep 2020 at 11:03, Scott Canaan <srcdco_at_rit.edu> wrote:

> It just took a very long time to shutdown. I don’t know why, but it took
> at least 5 minutes.
>
>
>
> *Scott Canaan ‘88*
>
> *Sr Database Administrator *Information & Technology Services
> Finance & Administration
>
>
> *Rochester Institute of Technology *o: (585) 475-7886 | f: (585) 475-7520
>
> *srcdco_at_rit.edu <srcdco_at_rit.edu>* | c: (585) 339-8659
>
> *CONFIDENTIALITY NOTE*: The information transmitted, including
> attachments, is intended only for the person(s) or entity to which it is
> addressed and may contain confidential and/or privileged material. Any
> review, retransmission, dissemination or other use of, or taking of any
> action in reliance upon this information by persons or entities other than
> the intended recipient is prohibited. If you received this in error, please
> contact the sender and destroy any copies of this information.
>
>
>
> *From:* oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> *On
> Behalf Of *Scott Canaan
> *Sent:* Thursday, September 3, 2020 9:52 AM
> *To:* 'oracle-l_at_freelists.org' <oracle-l_at_freelists.org>
> *Subject:* Database Hang On Shutdown
>
>
>
> I have a new Oracle 19.8 install on a new Linux VM. I’m trying to create
> a new database, but when I do a “shutdown immediate”, it just hangs.
>
>
>
> This is what’s in the alert log:
>
>
>
> 2020-09-03T09:47:35.357511-04:00
>
> Shutting down ORACLE instance (immediate) (OS id: 14781)
>
> 2020-09-03T09:47:35.357621-04:00
>
> Shutdown is initiated by sqlplus_at_rinnprod1.rit.edu (TNS V1-V3).
>
> 2020-09-03T09:47:37.651798-04:00
>
> Stopping background process SMCO
>
> 2020-09-03T09:47:39.288475-04:00
>
> Shutting down instance: further logons disabled
>
> 2020-09-03T09:47:39.346277-04:00
>
> Stopping background process CJQ0
>
> Stopping background process MMNL
>
> 2020-09-03T09:47:40.361625-04:00
>
> Stopping background process MMON
>
> 2020-09-03T09:48:12.490564-04:00
>
> Background process MMON not dead after 30 seconds
>
> Killing background process MMON
>
> 2020-09-03T09:48:12.490863-04:00
>
> Process termination requested for pid 14765 [source = rdbms], [info = 2]
> [request issued by pid: 14781, uid: 35003]
>
> 2020-09-03T09:48:13.501001-04:00
>
> License high water mark = 8
>
> 2020-09-03T09:48:13.501140-04:00
>
> Stopping Emon pool
>
> 2020-09-03T09:48:13.501926-04:00
>
> Stopping all emon processes
>
> Stopping EMNC
>
> 2020-09-03T09:48:13.514981-04:00
>
> Stopping all emon processes
>
> Stopping background process AQPC
>
>
>
> That’s it and it just sits there. I can do a “shutdown abort” then a
> startup, but as soon as I try to do a “shutdown immediate” again, it does
> this.
>
>
>
> What is causing it? How can I fix it?
>
>
>
>
>
> *Scott Canaan ‘88*
>
> *Sr Database Administrator *Information & Technology Services
> Finance & Administration
>
>
> *Rochester Institute of Technology *o: (585) 475-7886 | f: (585) 475-7520
>
> *srcdco_at_rit.edu <srcdco_at_rit.edu>* | c: (585) 339-8659
>
> *CONFIDENTIALITY NOTE*: The information transmitted, including
> attachments, is intended only for the person(s) or entity to which it is
> addressed and may contain confidential and/or privileged material. Any
> review, retransmission, dissemination or other use of, or taking of any
> action in reliance upon this information by persons or entities other than
> the intended recipient is prohibited. If you received this in error, please
> contact the sender and destroy any copies of this information.
>
>
>

--
http://www.freelists.org/webpage/oracle-l