Database Networking (MOSC)

MOSC Banner

DB LInk not connecting

edited Oct 7, 2019 5:30AM in Database Networking (MOSC) 4 commentsAnswered

Oracle Enterprise DB 12.1.0.2

--> I am able to log to SQL plus using:

SQLPLUS TEMP_CP_VALIDATION/VALIDATION2019@VL236DB1

--> I created this database link:

create database link

  TRNBLUEORIGINP_DB1

connect to

  TEMP_CP_VALIDATION

identified by

  VALIDATION2019

using

  'VL236DB1';

--> Database link created

SQL> select * from dual@TRNBLUEORIGINP_DB1;

ERROR at line 1:

ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

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