| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: db hang on shutdown
READ AGAIN:
You missed the part from their site:
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!
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
(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 - 17:55:10 CST
 |
 |
