CREATE DATABASE LINK myLINK CONNECT TO username IDENTIFIED BY password USING 'PROD';
OPT= (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 126.96.36.199)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = PROD) ) )
I get following error:
A connection to a database or other service was requested using a connect identifier, and the connect identifier specified could not be resolved into a connect descriptor using one of the naming methods configured. For example, if the type of connect identifier used was a net service name then the net service name could not be found in a naming method repository, or the repository could not be located or reached
I can connect using sqlplus though and can get response from tnsping.