Database link not going through
4071Nov 1 2004 — edited Nov 6 2004Hi to all,
i have two databases.
1) SID = SESL, global_name = SESL, in init.ORA global names = TRUE
2) SID = ORACLE3, globla_name = ORACLE3, init.ora global names = TRUE
i connected to SESL database and tryint to create databsae link lik this
create public database link oracle3 connect to scott identified by tiger using 'oracle3';
where as oracle3 is my net service name.
the link is created.
but when i try to access from SESL> it gives folowing error
SESL>select * from emp@oracle3;
select * from emp@oracle3
*
ERROR at line 1:
ORA-12545: Connect failed because target host or object does not exist
i tried my level best to solve. by goign through metalinl, OTN etc, with out sucess. all the time with diffrent errors finally ended with this
Thanks in advance,