Re: Help on db link.

In article <7f672k$nrk$1_at_nnrp1.dejanews.com>,   eternal0136_at_my-dejanews.com wrote:
> I tried to create a db link using
> "create database link dal202
> connect to bill identified by bill
> using 'dal202.world';"
> When I used it, like "select * from test_at_dal202",
> I got an error message saying that
> "Error at line 1:
> ORA-03113: end-of-line on communication channel"
>
> Could you tell me what's wrong with it?
>
> Thanks in advance.
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

I haven't had that error with a link as I have usually seen a message with tns in it, but until you get a better reply you could verify each of the following:

1. bill/bill is a valid user/password combination at dal202 with connect priviledge
2. bill ether owns table test, has a private synonym to it, or a public synonym exists for test. If bill does not own test he has select priviledge to it.
3. on the machine dal202 is running on the listener is started and listens for instance dal202
4. the tns entry on the machine where the instance holding the link points to the correct port for the machine where dal202 is, and the listener is running.
5. Both database's must have the distributed option installed.

None of these should have resulted in your error, but it you have double checked each of these, and do not get a better post you should be ready to call support. -- Mark D. Powell -- The only advice that counts is the advice that you follow so follow your own advice --

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Apr 16 1999 - 08:19:54 CDT