Database - RAC/Scalability (MOSC)

MOSC Banner

Database Link to 12c RAC Database leads to ORA-02019

edited Jul 14, 2016 5:39AM in Database - RAC/Scalability (MOSC) 7 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center