Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!proxad.net!fr.ip.ndsoftware.net!fu-berlin.de!uni-berlin.de!not-for-mail
From: akush <Berlin3010@web.de>
Newsgroups: comp.databases.oracle.server
Subject: Re: Autorecovery when oracle crash
Date: Thu, 09 Sep 2004 13:59:06 +0200
Lines: 48
Message-ID: <2qausbFshpiaU1@uni-berlin.de>
References: <chpa0j$pcq$1@newsserver.cilea.it> <2qaopbFs6vn5U1@uni-berlin.de> <chpek4$u2b$1@newsserver.cilea.it>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Trace: news.uni-berlin.de rWTM2yE6z7Z+UF8uQ3bZHw8NrNQs2eiJRY5AKB20JAxRqJlReG
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.5) Gecko/20031013 Thunderbird/0.3
X-Accept-Language: en-us, en
In-Reply-To: <chpek4$u2b$1@newsserver.cilea.it>
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:224572

Nicky wrote:

> Thanks !
> 
> Do you know if there is an automatic tool that can do this ?
> 
> Thank very much
> Bye
> 
> 
> 
> "akush" <Berlin3010@web.de> wrote in message
> news:2qaopbFs6vn5U1@uni-berlin.de...
> 
>>Nicky wrote:
>>
>>
>>>Hello
>>>
>>>Sometimes, my oracle server crash due to some problems I can't resolve
> 
> at
> 
>>>the moment.
>>>The only possibiliy I have to restart the oracle server, is restart the
>>>machine. (the commadn line tool: "LSNRCTL Start" doesn't work).
>>>
>>
>>lsnrctl only starts the oracle net listener. you have also to restart
>>the database with sqlplus or rman.
>>
>>sqlplus /nolog
>> >> conn / as sysdba;
>> >> startup;
>>
>>
>>
>>akush
>>
> 
> 
> 

hmm, not really. you could write a script that checks regulary if the 
database is running.

akush