From: Luggy <dave@oracle-consultant.co.uk>
Newsgroups: comp.databases.oracle.server
Subject: Re: Problem when starting up database instance
Date: Tue, 12 Dec 2000 09:08:47 GMT
Organization: Deja.com - Before you buy.
Lines: 75
Message-ID: <914pus$8j$1@nnrp1.deja.com>
References: <3A35C945.1C8BC010@schaefer-shop.de>
NNTP-Posting-Host: 212.113.2.161
X-Article-Creation-Date: Tue Dec 12 09:08:47 2000 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT)
X-Http-Proxy: 1.1 x51.deja.com:80 (Squid/1.1.22) for client 212.113.2.161
X-MyDeja-Info: XMYDJUIDdgh_consulting


Hi Markus,

Believe it or not this error can occur when your alert<sid>.log is
larger than 2GB, even if you have large file support enabled.

If the alert<sid>.log really is 2GB or bigger, rename/delete it and try
again.

Hope this helps,

Dave Henderson.


In article <3A35C945.1C8BC010@schaefer-shop.de>,
  Markus =?iso-8859-1?Q?B=F6hmer?= <markus.boehmer@schaefer-shop.de>
wrote:
> Hello,
>
> we are running an Oracle 8.1.5 database on a Sun Ultra Enterprise 250.
> After a normal shutdown of the database, and a normal reboot of the
> Enterprise we can't get the Oracle Database back to work again.
>
> I'll give you our attempts on bringing the database to work and the
> errormessages.
>
> I think that something with the networkconfiguration is wrong, but I
> don't know what it could be.
>
> I hope, that someone is abl=F6e to help.
>
> Greetings
> Markus
>
> Here are the error messages:
>
> SVRMGR> connect internal
> Connected.
> SVRMGR> startup
> ORACLE instance started.
> Total System Global Area                         35052944 bytes
> Fixed Size                                          64912 bytes
> Variable Size                                    18030592 bytes
> Database Buffers                                 16777216 bytes
> Redo Buffers                                       180224 bytes
> ORA-03113: end-of-file on communication channel
>
> SVRMGR> connect internal
> Connected.
> SVRMGR> startup nomount
> ORACLE instance started.
> Total System Global Area                         35052944 bytes
> Fixed Size                                          64912 bytes
> Variable Size                                    18030592 bytes
> Database Buffers                                 16777216 bytes
> Redo Buffers                                       180224 bytes
> SVRMGR> mount dbnm
>      2> ;
> mount dbnm
> *
> ORA-12571: TNS:packet writer failure
> -- =
>
> Markus Boehmer
> Systemadministrator & Datenbankentwickler
> SSI Schaefer Shop GmbH
> mailto:markus.boehmer@schaefer-shop.de
>

--
Any opinions expressed in the above posting are entirely factual and obj
Please do not argue with me, as my Dad is bigger than your Dad.


Sent via Deja.com http://www.deja.com/
Before you buy.