Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!feed.news.tiscali.de!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 12:15:03 +0200
Lines: 21
Message-ID: <2qaopbFs6vn5U1@uni-berlin.de>
References: <chpa0j$pcq$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 17RKrGACxO6RrxtQmfs5sANCRmm6ZzbYhBsaYGShokNHthVtby
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: <chpa0j$pcq$1@newsserver.cilea.it>
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:224568

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