Urgent help: strange DB_LINK problem... 2004-07-31 - By DENNIS WILLIAMS
Jose
Working with GLOBAL_NAMES=TRUE can be tricky until you fully understand
everything. Maybe even after that. I haven 't used them long enough to tell.
One thing I notice from the information you have provided, it appears that
the GLOBAL_NAME of one of your databases is "fnd_remote ". It does not appear
that there is a domain appended to the GLOBAL_NAME. If this is true, that
might be the root of your problems. How are you setting the GLOBAL_NAME of
your databases? Are you using ALTER DATABASE? That will automatically append
the domain. If you just do an update to GLOBAL_NAME, then the domain will
not be appended, but that is not correct and might cause problems with your
links.
If you don 't have a strong reason for understanding GLOBAL_NAMES, Igor 's
solution has some merit.
Dennis Williams
DBA
Lifetouch, Inc.
"We all want progress, but if you 're on the wrong road, progress means
doing an about-turn and walking back to the right road; in that case,
the man who turns back soonest is the most progressive. "
-- C.S. Lewis
-- --Original Message-- --
From: oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)]On Behalf Of Jose Luis Delgado
Sent: Friday, July 30, 2004 1:35 PM
To: oracle-l@(protected)
Subject: Urgent help: strange DB_LINK problem...
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
