Re: db hang on shutdown

Others too, if you read in this group, are not happy with someone flogging their product. Whoever is pushing the product, free or not, should still do so in the appropriate group. This isn't it!

Daniel Morgan

Chan wrote:

> I am not offended by what you perceived because you conviently
> neglected to note that the guy said "FREE download and register".
>
> I for one am a new Oracle dba and downloaded Platypus for FREE.
> Paid NO monied to these guys (because it was FREE)
> and already found the product to be enormously helpful.
>
> If anyone out there offers help to others via a FREE product
> then that help is NOT "unabashed commercial nature".
>
> If you MUST pay then it is. And I for one welcome such contributions
> because:
> 1. I dont have the money to PAY for a product.
> 2. DO not wish to learn a whole lot of SQL when there is a GUI product
> that
> can do it for me for FREE.
>
> Thank you.
> Chan
>
> "Daniel A. Morgan" <damorgan_at_exesolutions.com> wrote in message news:<3C44AE0D.7BD7C461@exesolutions.com>...
> > I am beginning to be offended by what I perceive to be the unabashed commercial nature of your posts, as in "download and register". If
> > you want to help people with Oracle ... please do so. If you want to push your product do so in the appropriate usenet group which is
> > comp.databases.oracle.marketplace.
> >
> > Thank you.
> >
> > Daniel Morgan
> >
> >
> >
> >
> > Earl wrote:
> >
> > > If this problem can be replicated easily (i.e it occurs quite often) then do the following:
> > > 1. Before doing a shutdown immediate connect to the db as "system" using a db monitoring tool
> > > [Platypus is FREE to download and register from http://www.websoft.com.au/downloads.html ]
> > > Firstly, in the LeftHandSide [LHS] frame click on the "Database Settings".
> > > You must change the default mode from "Read Only" = "Y" to "N"
> > > The screen in Platypus to do this looks like http://www.websoft.com.au/images/puser_dbsetting1_shot.jpg
> > > 2. Current User Logins
> > > Click on the "Group" on the LHS tree and "Users Currently Logged In" Tab on the RHS.
> > > The screen should look like this http://www.websoft.com.au/images/puser_userslogged1_shot.jpg
> > > Note if there are any users logged on other than your platypus session.
> > > If there ARE other users logged on then click on the row showing they logon to see:
> > > a) What Objects they have opened and
> > > b) What SQL they last executed in the Oracle SGA.
> > > You must now decide what steps you wish to take to log them out.
> > > a) Find the user/process and close it normally or
> > > b) Highlight the logon row and click on the "-" icon in Platypus to kill and terminate they session.
> > > Now refresh the screen by clicking "recource name" row on the Top RHS of the platypus screen to confirm that they have removed.
> > > 3. DBMS_JOBS running
> > > I know you said that you do not have any dbms_jobs defined in your db. However, please confirm this by:
> > > Clicking on the "DBMS_JOBS" Tab on the RHS.
> > > The screen should look like this http://www.websoft.com.au/images/puser_dbmsjob1_shot.jpg
> > > If there ARE jobs defined in the db then Platypus will tell you if they are currently running
> > > [a giff annimation of a runner is displayed in the RHS column called "Running" as in the screenshot example above Job#25 is
> > > running]
> > > At this stage you can now either:
> > > a) "REMOVE" the job permanently from the job queue by highlighting the job on the RHS and clicking on the "-" icon. or
> > > b) "DISABLE" (or Oracle uses the word BREAK" a job by highlighting the job and clicking on the job "STATUS" column
> > > to toggle it from a Green flag to a Red flag.
> > >
> > > Please let me know if you still can't issue a shutdown immediate even after you have followed the above and confirmed that:
> > > a) No users logged on
> > > b) No jobs running
> > > Regards,
> > > Earl.
> > >
> > > Dusan Bolek wrote (on 15 Jan 2002 05:03:00):
> > >
> > > > Ed_Stevens_at_nospam.noway.nohow (Ed Stevens) wrote in message news:<3c433fbd.7157151_at_ausnews.austin.ibm.com>...
> > > >
> > > > > Any takers to either question?
> > > > > 1 - Why does this one db seem to hang on a shutdown immediate
> > > > > 2 - Why does this one db show well over 100 sessions (some up to several days
> > > > > old) when there are only six client machines in existence?
> > > >
> > > > I had exactly the same problem few years ago. Some session just hanged
> > > > and had no intentions to die honorably. I had advantage that platform
> > > > was HP-UX, so I used "kill -9" and everything was OK. These zombie
> > > > sessions were not killable by internal Oracle tools.
> > > > You can use timeout in listener.ora, or check if your applications are
> > > > logging out correctly. However neither first or second helped me.
> > > >
> > > > --
> > > > _________________________________________
> > > >
> > > > Dusan Bolek, Ing.
> > > > Oracle team leader
> > > >
> > > > Note: pagesflames_at_usa.net has been cancelled due to changes (maybe we
> > > > can call it an overture to bankruptcy) on that server. I'm still using
> > > > this email to prevent SPAM. Maybe one day I will change it and have a
> > > > proper mail even for news, but right now I can be reached by this
> > > > email.
Received on Thu Jan 17 2002 - 00:23:40 CET