Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-12541 error when attempting a database link in Oracle SQL Developer

AnnieMMay 18 2020 — edited May 19 2020

Greetings,

PL/SQL Release 10.1.0.5.0 - Production

Oracle SQL Developer Version 19.2.1.247

Windows 7

Within a SQL worksheet connected to one of our databases, I attempted a link to another one of our campus' databases:

create public database link

Banner

using 'xxx:1528/yyy';

where  xxx = hostname

and yyy = serviceName

.

And then tried to execute this query:

select

HS.BANNER_CD,

HS.HS_NAME,

BN.STVSBGI_DESC

from ADMISSIONS.AMHGHSCT HS

INNER JOIN STVSBGI@Banner BN

ON HS.BANNER_CODE = BN.STVSBGI_CODE ;

(When I access that other database referenced above as Banner within a difference SQL worksheet, I can run a query, select * from STVSBGI

without errors)

But for the database link I received this error:

ORA-12541: TNS:no listener

  1. 12541. 00000 - "TNS:no listener"

*Cause:    The connection request could not be completed because the listener

is not running.

*Action:   Ensure that the supplied destination address matches one of

the addresses used by the listener - compare the TNSNAMES.ORA entry with

the appropriate LISTENER.ORA file (or TNSNAV.ORA if the connection is to

go by way of an Interchange). Start the listener on the remote machine.

Does anyone know what the issue is here? I am not a DBA. And our DBA, reviewed quickly but couldn't see an issue either

Thank you for your help and i hope you are doing well at this time,

Annie

Comments
Post Details
Added on May 18 2020
16 comments
7,092 views