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
- 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