Re: oracle instance is not running

Hi Ruediger
More detail provided by Oracle should be available in the alert log. This file is sitting in your background dump directory as specified by background_dump_dest in your init<sid>.ora. This last file is located in %ORACLE_HOME%\database.
Probably posting the alert<sid>.log will provide more clues as to what happened.

Hth,

Sybrand Bakker, Oracle DBA

Ruediger Tams wrote:

> Hello!
>
> I have some trouble with our Oracle Workgroup-Server 7.3.4
> on NT4 Server SP3.
>
> We changed our domain an the IP-Adress for our Oracle-Server.
>
> Now Oracle NT Instance Manager shows
> #
> SID Status Startup
> ORCL
> Services Started Automatic
> Instance Stopped Automatic
> #
>
> But Win NT Services shows
>
> OracleServiceORCL Started
> OracleStartORCL Started
>
> In Eventviewer the last correct detail says
> 'Initializing PGA for process SNP0 in instance orcl.'
>
> After this i have the following eventdetail:
> The description of the event ID (0) in source (ORACLE7.orcl)
> could not be found. It contains the following insert character
> string (n): ACTION : 'shutdown'.
>
> Then there are this 3 events:
> Shutdown normal performed on instance orcl.
> All process in instance orcl stopped.
> Instance orcl has been terminated.
>
> Now Oracle isn't availabe an more :-( (ORA-01034)
> So where is the problem?
>
> kindly regards
>
> Ruediger Tams
> KomTel GmbH
> Flensburg, Germany

Received on Fri Jan 08 1999 - 13:46:03 CST