I had a similar problem. Not sure why. Took me couple of hours to get it
working.
Some one mentioned I do not have an alias that can go from fnd_remote to
fnd_remote.domain.com.
Changing the command as above fixed the problem.
Shakir
--- Jose Luis Delgado <joseluis_delgado@(protected) > wrote:
> List...
>
> Please, help me to solve this thread, I 've been trying
> for a whole day and cannot find the problem...
> also, I 've been searching at Metalink with no luck.
>
> this is the scenario:
>
> 1.- Local BD: Oracle 8.1.7, SID = fnd on Solaris 5.8
> 1.1 TNSNAMES.ORA has a FND_REMOTE alias for Remote BD
>
> 2.- Remote BD: Oracle 8.1.7, SID = fnd on Solaris 5.8
>
> Note that both are the same SID, DB and OS version.
> They are at distinct locations.
>
> On local BD, tnsnames.ora is configured correctly,
> I 've checked in this way:
>
> 1.- $ tnsping fnd_remote
> Attempting to contact
> (ADDRESS=(PROTOCOL=TCP)(Host=xx.xx.xx.xx)(PORT22))
> OK (10 msec)
>
> 2.-
> SQL >
> connect sys/my_incredible_secret_password@(protected)
> Connected.
>
> The problem starts when I create a PUBLIC db_link.
>
> SQL > create public database link fnd_remote
> 2 using 'fnd_remote ';
>
> Database link created.
>
> I 'm configuring Symmetric Replication, so, I need a
> PUBLIC database link like above.
>
> And, now... and type:
>
> SQL > select * from global_name@(protected);
> select * from global_name@(protected)
> *
> ERROR at line 1:
> ORA-12154 (See ORA-12154.ora-code.com): TNS:could not resolve service name
>
> Facts:
> global_names = true on both databases
> Connectivity is OK in both ways.
>
> Any ideas?
> Thanks in advance!
>
> JL
>
>
>
>
>
> __ ____ ____ ____ ____ ____ ______
> Do you Yahoo!?
> Yahoo! Mail Address AutoComplete - You start. We finish.
> http://promotions.yahoo.com/new_mail
> -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
> To unsubscribe send email to: oracle-l-request@(protected)
> put 'unsubscribe ' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
>
====Mohammed Shakir
CompuSoft, Inc.
11 Heather Way
East Brunswick, NJ 08816-2825
(732) 672-0464 (Cell)
(732) 257-6001 (Home)
__ ____ ____ ____ ____ ____ ______
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
http://promotions.yahoo.com/new_mail
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
