Database Link to 12c RAC Database leads to ORA-02019
Hello.
I have set up a database link from a standalone database to a 2 node RAC DB.
If i try to access the RAC DB by using the link I receive: ORA-02019: connection description for remote database not found.
As follows the steps I have done so far:
CREATE DATABASE LINK "racdbname.domainname"
CONNECT TO user
IDENTIFIED BY pw
USING 'tnsname';
select * from dual@"racdbname.domainname;
*
ERROR at line 1:
ORA-02019: connection description for remote database not found
tnsnames of standalone db:
'tnsname'=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dbname-scan.domainname)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = oltpworkloadservicename.domainname)
)
)
A sqlplus remote login to the RAC db using this tnsname is working.