Re: db hang on shutdown

[Quoted] You wrote: "just a joke" .. I say no. Lets put his feet to the fire. We can settle out of court for an apology and a guarantee that in the future he will post in .marketplace when he wants to sell his product.

Daniel Morgan

AF wrote:

> READ AGAIN:
>
> You missed the part from their site:
> ---------------------------------------------------
> Interested in Platypus User but want to find out more? Download your free
> trial version of Platypus now. Discover the power of Platypus for database
> access!!
>
> Platypus User Trial Version has a 30 day expiry date. After this time,
> Platypus will no longer be operational and you may download a new trial
> version or purchase a copy of Platypus. To download Platypus without
> registration will impose that Platypus will only allow connections to the
> database for 30 minutes. To bypass this security, we invite you to register
> before downloading Platypus. When you register Platypus, we shall e-mail you
> your necessary information needed to begin using Platypus!
>
> * = Mandatory information must be specified
> ---------------------------------------------------
>
> As they probably stole the code from an open source project like TOra this
> is BS.
>
> I do have a plan: As all of these people are on this group giving away free
> software especially Steve (note: e-mail address) stating in a post:
> On Thu, 17 Jan 2002 10:12:39 +1100, Steve Katsaras
> <steve_at_websoft.com.au> wrote:
>
> >Switch to a brand new DB management application solution that is
> >user-friendly, platform independent and fast.
> >
> >It's called, Platypus User V1.2 for Oracle.
> >It gives you database information, schema information, runs sql scripts.
> >
> >And best it's free.
> >
> >http://www.websoft.com.au/platypus_user.html
> -----------------------------------------------------------------------
> Here in the US I take him up on him selling me his software $0 without
> limit. This will nulify the 30 day limit as he did not state that limit in
> his ad. Everyone download the software when it breaks in 30 days lets all
> get a class action suit together and close them down...We may have a good
> case.
>
> (just a joke)
>
> "Chan" <chan21672167_at_yahoo.co.uk> wrote in message
> news:eccc6cbc.0201161651.6ea15376_at_posting.google.com...
> > I am NOT offended by what you perceive because this guy said
> > "FREE download and register" but you left the FREE out in your quote.
> >
> > I am a new DBA and after reading the post downloaded Platypus for
> > FREE.
> > Paid NO monied and it was already help me lot to know what is going on
> > in database in GUI way.
> >
> > I do not want to learn all that SQL when there is a FREE product that
> > help
> > me straight away. I'll learn the SQL for things that a product can't
> > do.
> >
> > Anyone who wishes to respond to a post and offers help via they
> > own product which we can use for FREE is welcome to do so and I hope
> > that
> > guy is not put off by people like you.
> > Thanks!
> >
> > Chan
> >
> > "Daniel A. Morgan" <damorgan_at_exesolutions.com> wrote in message
> news:<3C44AE0D.7BD7C461_at_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 - 18:49:11 CET