Still not working
Sam Weber, June 26, 2020 - 4:17 pm UTC
Where do I add a followup like this in the ticket?
Not sure why I would edit the TNSNAMES.ora when the DB LINK itself has the connection information in it. But I went ahead and changed the TNSNAMES.ORA on the server I am connected to. I still get the same error when global_names is set to True. Anything else I can try?
June 29, 2020 - 5:54 am UTC
Where do I add a followup like this in the ticket?
You just did :-)
Not sure why I would edit the TNSNAMES.ora when the DB LINK itself has the connection information in it.
Hard to comment on that, given that you didn't provide any detail on it to us.
But I went ahead and changed the TNSNAMES.ORA on the server
From what to what?
What is the domain?
What is the tns entries in the file?
....
Followup with detail
Sam Weber, June 29, 2020 - 9:27 pm UTC
sorry, should have provided more detail. here is the link sql I used:
CREATE PUBLIC DATABASE LINK "LIMS11.SMRTL.LOCAL"
CONNECT TO XXXXXX
IDENTIFIED BY <password>
USING '(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxxxx)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = xxxx)
))';
the domain on the SOURCE db is: smrtl.local
I should mention that the TARGET db does not have a value in the Oracle domain parameter.
Then TNSNAMES entry I edited was on the Source DB in it's Oracle Linux environment:
LIMS11.SMRTL.LOCAL=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =xxxxx)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = lims11.smrtl.local)
)
)