Re: database link error

From: Lando <Markl_at_plant.pnwss.com>
Date: 1997/02/20
Message-ID: <01bc1eb6$faf25d40$2a868cc6@quebim.quebim>#1/1

Bob Yeh <Bob_Yeh_at_vaffx2_at_cscuuxch.dayton.csc.com> wrote in article <330B7A11.5E0E_at_cscuuxch.dayton.csc.com>...
> Hi,
>
> I have two databases running 7.3.2.2 on Sun solaris 2.4. The database
> link only work one way. The sqlnet is working properly. I can connect
> to both servers using tnsname alias no problem.
>
> When I do "select * from global_name_at_db1" it gave me error:
> ORA-03113 end-of-file on communication channel.
>
> Then when I re-connect it gave me error:
> ORA-01041: internal error. hostdef extension doesn't exist
>
>
> Can someone help?
>
> Thanks.
> Bob
>

Make sure you have a tnsnames.ora in both of your servers \network\admin subdirectory that includes an alias for the database you created a link to. Database links use the server's (not clients) tnsnames.ora for sqlnet alias information.

M.Landa Received on Thu Feb 20 1997 - 00:00:00 CST