Re: Urgent help: strange DB_LINK problem...

Try

select * from global_name@xxxxxxxxxxxxxxxxxxxxx;

where global name is domain.com

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@xxxxxxxxx> 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)(PORT=1522))
> OK (10 msec)
> 
> 2.- 
> SQL>
> connect sys/my_incredible_secret_password@fnd_remote
> 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@fnd_remote;
> select * from global_name@fnd_remote
>                           *
> ERROR at line 1:
> ORA-12154: 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@xxxxxxxxxxxxx
> 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@xxxxxxxxxxxxx
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
-----------------------------------------------------------------

Other related posts: