Re: Database Hang On Shutdown

From: Frank Gordon <frankagordon_at_gmail.com>
Date: Tue, 8 Sep 2020 11:54:54 +0100
Message-ID: <CAA0QMtnERUZJ4n3AmU0GyEwdGLKKdazjf4eDEnjJQ4+6eHLJ4Q_at_mail.gmail.com>



Hello,

Does it make any difference if you turn off AQ completely once just for a test?

Frank

On Fri, Sep 4, 2020 at 12:24 PM Scott Canaan <srcdco_at_rit.edu> wrote:

> It’s a brand new database. There aren’t any app servers yet and no app
> data even in the database. It was created less than 10 minutes prior.
>
>
>
> *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:* Reen, Elizabeth <elizabeth.reen_at_citi.com>
> *Sent:* Thursday, September 3, 2020 4:46 PM
> *To:* angelolistas_at_gmail.com; Scott Canaan <srcdco_at_rit.edu>
> *Cc:* oracle-l_at_freelists.org
> *Subject:* RE: Database Hang On Shutdown
>
>
>
> Did you shut down your app servers?
>
>
>
>
>
> Liz
>
>
>
>
>
>
>
> *From:* [External] oracle-l-bounce_at_freelists.org <
> oracle-l-bounce_at_freelists.org> *On Behalf Of *[External] angelo
> *Sent:* Thursday, September 3, 2020 11:00 AM
> *To:* srcdco_at_rit.edu
> *Cc:* oracle-l_at_freelists.org
> *Subject:* 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
> <https://urldefense.com/v3/__http:/mammqm.blogspot.com/2016/04/shutdown-immediate-hang-situations.html__;!!Jkho33Y!3KJWaWJnPxRgv8j2MtU2GhSGb2tfg_hTPaVfFEx8I0nB8hbejilDcjCN7dGaoNU5XA$>
>
>
>
> 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.
>
>
>
>

-- 
+353-86-0695383

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Sep 08 2020 - 12:54:54 CEST

Original text of this message