Re: Urgent help: strange DB

From: Mohammed Shakir <mshakir08816_at_yahoo.com>
Date: Sat, 31 Jul 2004 22:16:51 -0700 (PDT)
Message-ID: <20040801051651.11726.qmail@web20104.mail.yahoo.com>

Try

select * from global_name_at_fnd_remote.domain.com;

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_at_yahoo.com> 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_at_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_at_fnd_remote;
> select * from global_name_at_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_at_freelists.org
> 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_at_freelists.org 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
-----------------------------------------------------------------

Received on Sun Aug 01 2004 - 00:12:40 CDT

Re: Urgent help: strange DB_LINK problem...