Re: Oracle screws up Sun host

From: Kenneth A Kauffman (kkauffman@nospam.headfog.com)
Date: 04/21/03 

From: "Kenneth A Kauffman" <kkauffman@nospam.headfog.com>
Date: Mon, 21 Apr 2003 20:19:29 GMT

"Rick Denoire" <100.17706@germanynet.de> wrote in message
news:9ef8avkappqgv0ub05rt2bvia2u2gd7c5e@4ax.com...
> We are running two Oracle DB (both 8.1.7) on the same host (Sun
> E3500/Solaris 7). The first is small and stable and is never changed
> in its structure (it is a commercial product) - it should run 24x7.
> The second one is "big" (60 GB Data + Indexes), is being changed
> almost constantly and runs PL/SQL jobs lasting many hours (Data Mining
> operations). This second DB produces about 3 ORA-00600 errors a week
> and at times, it MUST be shut down (because of runaway processes, for
> example). Normally, shutting down the "big" DB (the instance) is
> tolerable.
>
> But if it must be shut down due to a problem, if often can't be. Using
> "shutdown immediate" goes as far as closing the DB, but then, the
> process of shutting down the DB hangs. If after a while I interrupt
> the process with Control-C, I get the SQL prompt but I am out of
> business (disconnected). Nothing more can be done with the DB, since I
> can't even connect ("instance is down"). Then I notice that there are
> still one or more Oracle background processes running, which I have to
> kill at the OS command line. Then I am still unable to connect. As a
> last effort, I remove the file $ORACLE_HOME/dbs/lk<SID-NAME>, which
> does not help either. Somehow the host is crewed up at this point, and
> the only chance I have to get things fixed is to restart the whole
> host.
>
> This is a shame since this is not windows and there should be a way of
> cleaning up things without having to restart the host. Restarting the
> host is not tolerable (it runs the 1st 24x7 DB and an Intranet Server,
> and it is a NIS Master).
>
> So your advice will be to separate the DBs. We are actually planing
> exactly that, the new server hardware is being ordered. But my
> question still remains, how to let the other instances untouched when
> one of them goes nuts. >>The new server will hold several instances<<
> Hm.
>
> Any clue?
>
> Rick Denoire

I agree with the other two posters. In addition, you may need to apply an
upgrade if you are still running 8.1.7.0.0 or other lower versions.

ken k

Relevant Pages

  • Re: Biztalk slow to receive files after host instance restart
    ... Especially when you use the default BizTalk host configuration because the host is than also responsible for moving tracking information from msgbox db to tracking db. ... Give the SQL jobs some time to process the backlog and after that see if the host restart time gets better. ...
    (microsoft.public.biztalk.general)
  • Re: WinUSB resume
    ... It sounds like you aren't using UMDF at all, so the host automatic host restart would not be a part of the picture. ... Conceptually there are two types of stacks you could use WinUSB 1) WinUSB->UMDF framework->Your UMDF Driver Code or 2) WinUSB->Your user-mode service/application. ... Plug in a usb device to my PC, I monitor the current of the usb device is ...
    (microsoft.public.development.device.drivers)
  • Re: Biztalk slow to receive files after host instance restart
    ... Backup Biztalk Server ... On closer inspection the T-SQL statements that ran these jobs needed ... Especially when you use the default BizTalk host configuration ... host restart time gets better. ...
    (microsoft.public.biztalk.general)
  • Re: Oracle screws up Sun host
    ... Somehow the host is crewed up at this point, ... | cleaning up things without having to restart the host. ... Do kill -15 to kill any remaining processes of the big database, ... When you don't find a solution, open a TAR with Oracle ...
    (comp.unix.solaris)