RE: dblin help needed

From: Gurgaon, DBA (CAP, GECSI, CONTRACTOR) <DBA.Gurgaon_at_geind.GE.com>
Date: Thu, 8 Jun 2000 10:51:47 +0530
Message-Id: <10521.108175@fatcity.com>

ORA-00470: LGWR process terminated with error  The log writer process terminated abnormally. Check the accompanying messages, and the background process trace file. Correct the problem mentioned in the messages. Then shut down and restart the instance. If the trace file mentions any other background process errors, check the trace file for the mentioned process until the root error is found.

ORA-02063: this error is due to the previous one.

Vikas

-----Original Message-----
From: Stephen J Palmer [mailto:spalmer_at_brk.photronics.com] Sent: Thursday, June 08, 2000 9:04 AM
To: Multiple recipients of list ORACLE-L Subject: dblin help needed

This is the first time I've had a problem with database links. Any idea what is going on here? I have dropped and recreated the link several times, and bounced the database instance. The LGWR proccess IS running and I can connect to the instance.

21:28:32 SQL> create public database link BRKTEST

                         connect to mtuser identified by password
                          using 'brktest';

Database link created.

21:32:46 SQL> @links.rep

Wed Jun

7                                                                page
1
                         DATABASE LINK REPORT

Owner          Name            Username   Host      Created
--------------- ----------------- -------------- ---------
---------------
PUBLIC       BRKMT        MTUSER   brktest  10-MAY-00
PUBLIC       BRKTEST     MTUSER   brktest  07-JUN-00

21:29:06 SQL> select sysdate from dual_at_brktest; select sysdate from dual_at_brktest

                         *

ERROR at line 1:
ORA-00470: LGWR process terminated with error ORA-02063: preceding line from BRKTEST

Any thoughts would be appreciated.

Thanks in advance.

Steve Palmer

-- 
Author: Stephen J Palmer
  INET: spalmer_at_brk.photronics.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Thu Jun 08 2000 - 00:21:47 CDT