dblin help needed

From: Stephen J Palmer <spalmer_at_brk.photronics.com>
Date: Wed, 07 Jun 2000 22:20:56 -0400
Message-Id: <10521.108165@fatcity.com>

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. Received on Wed Jun 07 2000 - 21:20:56 CDT