Urgent help: strange DB_LINK problem... 2004-07-30 - By Jose Luis Delgado
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
