Hi all,
Do we need to make an entry in the tnsname.ora file in local database to connect to remote database using db link ?
Below is my code :-
create database link ****_DBLINK
connect to USER IDENTIFIED BY "user"
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = **.*.*.*)(PORT = 1521))
)
(CONNECT_DATA = (SERVICE_NAME = REM)
)';
After creation of the DB link when I am trying to execute select 1 from dual@***_DBLINK
it is throwing me an error ORA 12154: TNS : could not resolve the connect identifier specified
Am I expected to make an entry in the tnsname.ora file for "REM". I do not remember making any changes in the tnsname.ora file for creation and access of remote database via dblink.
Please help.
Thanks in advance.