Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [listener]

A Network Listener waits for and responds to incoming network requests. Use this tag for questions about e.g. the Oracle Net Listener or SQL Server Availability Group Listener. Be sure to also tag the product name.

Filter by
Sorted by
Tagged with
0 votes
0 answers
37 views

Permission error while creating LISTENER in AOAG setup

I know this is more of a NETWORK-related question, but you may have encountered this. We are setting up AOAG with 1 primary and 2 secondary nodes. When configuring LISTENER with 3 unassigned private ...
S T's user avatar
  • 1
0 votes
0 answers
59 views

listener issues in oracle 19c

These are my listener.ora and tnsnames.ora files listener.ora SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = dr_DGMGRL) (ORACLE_HOME = /u01/app/oracle/product/19.0.0/...
datascinalyst's user avatar
0 votes
1 answer
218 views

Setting up Oracle 19c Database instance with access from different subnets using scan listeners

We have a RAC cluster where we are upgrading a database. (12c to 19c) The upgrade process is to build a new database on the same cluster and import a copy of the old database. The old database has a ...
jmichaelwDBA's user avatar
1 vote
0 answers
53 views

Always-On listener not working correctly

I have an Always-On architecture with two nodes and two AG. One of AG working correctly but other AG's listener only directs to the primary node. When I fail it to the secondary node, the application ...
mbielsa's user avatar
  • 66
0 votes
0 answers
50 views

I am having trouble creating a listner in Oracle 19C. Some help will be appreciated

These are my active services: SQL> SELECT NAME FROM V$ACTIVE_SERVICES; NAME ---------------------------------------------------------------- pdb3 orcldb pdb2 pdb1 and this is my listener.ora ...
dbafix's user avatar
  • 62
0 votes
0 answers
39 views

How to use the same Azure SQL VM in two different Load Balancers

I have already configured always on availability group between VM1 and VM2 azure machines. Internal Load Balancer was created for these two VMs and mapped to AG Listener. VM2 is used for read workload ...
Rauf Asadov's user avatar
  • 1,273
0 votes
0 answers
68 views

How is this service registering with listener when invalid LOCAL_LISTENER is used?

I have a single instance 19c CDB with 2 PDBS, I am also running Grid Infrastructure (Oracle Restart) for ASM. The database has LOCAL_LISTENER set to LISTENER_MYDB which is a non existent listener, and ...
Ian's user avatar
  • 21
0 votes
1 answer
133 views

Configuring a DNN listener for an availability group fails

I am running into problem when creating DNN listener on Azure VM. I am runnign the script provided in Microsoft article: https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/...
VitalicJJ's user avatar
0 votes
1 answer
585 views

LSNRCTL cannot stop Listener

When I'm trying to lsnrctl start, i have following error: TNS-01106: Listener using listener name LISTENER has already been started However, if i try to lsnrctl stop: Connecting to (ADDRESS=(PROTOCOL=...
igor1707's user avatar
1 vote
1 answer
175 views

limit access to oracle scan port by IP address

We run an Exadata XM-8 with multiple DBs for a variety of clients in our company. I want to limit access to one of the DBs to one particular server. I know I can run a logon trigger and limit the IP ...
cptkirkh's user avatar
1 vote
2 answers
446 views

Registration of SPNs for Availability Groups

Manually registering SPNs for Availability group - Do I need to register SPNs for the AG Listener as well as the individual nodes, for both the instance name and the listening ports for the managed ...
PTL_SQL's user avatar
  • 341
2 votes
1 answer
1k views

Listener error ORA-12518 & ORA-12520 after changing the IP with domain

We have a server with Oracle 11g and a database. The network administrator added an alias domain to the ip of the server where oracle is. We haven't changed anything else. After that, when SSRS server ...
eathan's user avatar
  • 23
0 votes
1 answer
278 views

Where is Oracle TNS redirection configured?

The short version, I need to connect to an Oracle server and I am getting redirected to an IP address that is blocked by the firewall. What do I need to ask to find out what IP addresses I will be ...
user1683793's user avatar
0 votes
1 answer
276 views

Is it possible to write a generic trigger for all tables in Postgres?

I want to listen to every transaction that is recorded in the database And I noticed that there is a concept in Postgres under the title LISTEN and NOTIFY (Of course, I am not sure that this is the ...
mostafa hosseini's user avatar
0 votes
2 answers
706 views

How does SQL Browser work when default port is missing and AG Listener specifies port 1433?

Background: To keep things simple, we have a 2 node cluster where each node in the cluster has 3 instances of SQL installed: default + 2 named. I understand instance stacking is bad and it is ...
Data Dill's user avatar
  • 245
0 votes
1 answer
470 views

AlwaysOn listeners across subnets

Can someone help me clear something up with regards to AlwaysOn listeners across 2 subnets. Windows Server 2019 SQL Server 2019 This is in Azure I have created a multi-subnet AG. The listener has 2 IP ...
Sicilian-Najdorf's user avatar
0 votes
1 answer
487 views

Failing to enable TCPS on Oracle 11

I have added the following settings to my Oracle 11 server (Bolded text is the change)- sqlnet.ora- SQLNET.AUTHENTICATION_SERVICES = (**TCPS,** NTS) listener.ora- SID_LIST_LISTENER = (SID_LIST = ...
user3073180's user avatar
0 votes
1 answer
1k views

nslookup returning secondary IP of a listener (different subnet)

I'm pretty confused about this issue. We noticed that we sometimes receive some errors from the app servers causing timeouts. after a lot of digging, we discovered that sometimes when using a listener ...
Racer SQL's user avatar
  • 7,386
0 votes
1 answer
700 views

Oracle XE 18c, on every connect attempt, Oracle listener OracleOraDB18Home1TNSListener stops, and I am unable to connect to any connection

For the purpose of learning, I have installed Oracle 18c XE v18.4.0.0 and Oracle SQL Developer v21.4.2. I have no previous experience with Oracle database. Command LSNRCTL stat seems to show correct ...
Sale U's user avatar
  • 1
0 votes
1 answer
2k views

ORA-12152: TNS: unable to send break message - Only LISTENER restart works

i have a strange problem with our Oracle 12.1.0.1.0 on our VM Windows Server 2016. I create a daily batch script whichs creates a dump file (via EXP) and execute some sql statements (via SQLPlus). ...
Athris's user avatar
  • 21
2 votes
1 answer
318 views

What is the correct configuration for the SQL Server listener with 2 nodes on-prem and 1 node in Azure?

I am setting up a 3-node Availability Group with 2 nodes on-premises and the 3rd on a VM in Azure. All nodes are SQL Server 2019 Enterprise with CU14. The Availability Group is fine and the listener ...
Kevin Feit's user avatar
-1 votes
1 answer
130 views

I have error in one machine from ORACLE cluster

I am using Oracle 10g Cluster. So, the listener on 1 Oracle machine hasn't been working for a week now. I get an error: ORA-12541: TNS:no listener When I want to start listener from oracle user, ...
Vasyl's user avatar
  • 1
-2 votes
1 answer
1k views

Netca command not found Oracle 12c (silent mod)

i'm new on the Oracle's world, the installation it was easy and good, but , I dont know where is the problem here.
Daniel Trindade da França's user avatar
0 votes
1 answer
496 views

Listener oracle in pacemaker cluster

I need some help. I have created a cluster with 2 nodes. I created all resources, but listener has errors and the pacemaker cluster status shows Oracle Listener has stopped. In the web interface I ...
Tsunani's user avatar
0 votes
0 answers
320 views

Questions about the endpoints_listener.ora

How to understand the backward compatibility with pre-11.2 databases of the endpoints_listener.ora in depth? Why would manually editing the listener.ora not lead to automatically updating its ...
lylklb's user avatar
  • 121
0 votes
2 answers
992 views

JDBC oracle listener random port

I have an issue with our listener trying to assign random ports to JDBC connections. We have a 19c oracle db running on a RHEL server with two ports opened 1523 and 1524. When application tries to ...
user avatar
0 votes
0 answers
3k views

Oracle 19c listener stops on connection TNS-12541 error

I have just installed Oracle 19c Standard Edition 2 on Windows 10 and created a local database. I can connect to it with sqlplus / sysdba, but if I try to connect with sqlplus user/password@host:port, ...
user12939286's user avatar
1 vote
1 answer
406 views

Still can't create an AAG listener

I just built a test cluster with 2 MS SQL Server 2014 machines, 1 domain controller, an 1 file share witness. (All of them are Windows2016-based.) The 2 MS SQL Server machines are a WSFC members. When ...
blazonstone's user avatar
0 votes
1 answer
252 views

Configure listen_addresses automatically in custom installation

I have included Postgres in a custom installer for a Windows application. I do not use the installer binary, but extract the Postgres zip archive for installation and then run initdb from a batch ...
Abid's user avatar
  • 111
0 votes
2 answers
5k views

Launching LSNRCTL produces an error

I am trying to launch LSNRCTL on my Windows 10 64-bit laptop; Oracle 18 XE I get this error message: C:\app\Owner\product\18.0.0\dbhomeXE\bin>lsnrctl LSNRCTL for 64-bit Windows: Version 18.0.0.0.0 ...
MurraySobol's user avatar
0 votes
1 answer
4k views

Connection to Oracle DB 19c fails when listener is set to the host IP address

I am new to Oracle DB and need help in solving the following issue. I am using sqlplus (SQL*Plus: Version 21.1.0.0.0) to connect to the Oracle DB 19c. Statement: I am able to connect to the Oracle DB ...
Janmenjoy Roy's user avatar
2 votes
1 answer
4k views

SPN for Availability group(AG) listener for SQL Server 2016

Requesting some inputs.. We have a 2 node SQL 2016 Availability group configured and apps currently use primary replica for connection. We are now planning to use listener instead. Questions is, how ...
kevin's user avatar
  • 103
0 votes
0 answers
549 views

unable to connect between SQL Developer and Oracle VM Virtualbox

I have setup an Oracle DB within Oracle VirtualBox and I am trying to connect to it using SQL Developer installed on the same desktop. It worked initially but has since stopped connecting. It seems ...
MasonT's user avatar
  • 1
0 votes
1 answer
378 views

Oracle 11gR2 - Dynamic Registration

Database version: Oracle 11gR2 We want to use DYNAMIC_REGISTRATION_LISTENER parameter with off option. Our listener.ora file like this: LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (...
jrdba123's user avatar
1 vote
2 answers
5k views

The listener supports no services - 2 databases on oracle linux 7

I'm running two 12c R2 databases on linux oracle 7.9 I've installed the first database (CDB) and also a listener and both of them were running fine. Then, I've installed another 12c R2 database (CDB2) ...
Andrew T's user avatar
0 votes
1 answer
76 views

Does listener gets affected when we replace secondary replica with another server in Availability Group?

I have created Multi Subnet Always On Availability Group. Now, I need to replace secondary replica with another server in Availability Group. In this case, Do I need to re-create listener? OR The ...
Sree Lekha's user avatar
0 votes
2 answers
120 views

multisubnet listener

Good morning all , I have an alwayson instance with a multisubnet listener I configured RegisterAllProvidersIP = 0 in order to register a single DNS entry HostRecordTTL is configured at 1200 seconds I ...
Abdallah Mehdoini's user avatar
-1 votes
4 answers
3k views

DNN Listener resolving to a secondary server in WSFC & AO AG

I have an Azure AO AG which consists of three servers (all WS-2019 & SQL-2019 CU8): A - Subnet 1 - Principal Server (Sync) B - Subnet 1 - Secondary Server (Sync) C - Subnet 2 - Secondary Server (...
Lickrob's user avatar
  • 84
0 votes
1 answer
405 views

Problem connection to a standby database during the create proccess [closed]

I'm trying to install an Oracle Standby Database 19c. I have a Rac Database 19c and now I'm with the firsts steps to create de standby. I have in nomount state the standby database SQL> startup ...
estonolose's user avatar
0 votes
1 answer
2k views

How to add a new listener on a new port and restrict it to one instance only

I am running oracle 11.2.3 and we have a server with multiple instances running. All of them are registered to port 1521 with the default listener. Now we are required to make one instance available ...
user211005's user avatar
4 votes
1 answer
30k views

Oracle 19c database instance doesn't register with listener

I have just installed an oracle 19c (19.3.0.0.0 to be exact) database on a centOS 8 virtual machine. The databases instances can all be started with sqlplus on the host machine. I have set up listener....
Achim Schmitz's user avatar
0 votes
2 answers
1k views

How do you configure a 4-node AlwaysOn cluster to have two listeners?

Looking to build a 4-node (servers A, B, C & D) AlwaysOn Windows 2016 failover cluster with 2 nodes in the primary datacenter for HA, and 2 other replica nodes in the DR datacenter for disaster/...
Chinesinho's user avatar
1 vote
1 answer
1k views

SQL Server Availability Group - Listener configuration problem

Platforms: Windows Server 2016 SQL Server 2016 SSMS 2018 Problem: Create failed for Availability Group listener 'lsn'. None of the IP addresses configured for the availability group ...
jrdba's user avatar
  • 55
2 votes
1 answer
3k views

oracle - Change host to 0.0.0.0 in listener

Im using oracle 12c on windows server 2016. I want to make my oracle to listen to the port 1521 to 0.0.0.0 Here is my listner.ora file. # listener.ora Network Configuration File: C:\app\bhuvi\...
TheDataGuy's user avatar
  • 1,940
0 votes
1 answer
1k views

What exactly mean refused in Oracle listener? [closed]

What are exactly the reasons of the listener refuse some attempt of connection in database? Other question is, the amount of refused connection is lsnrctl services command is all refused connection ...
Astora's user avatar
  • 723
0 votes
3 answers
12k views

Listener (lsnrctl) reload vs stop/start

Some blogs tell that reload is equal stop and start, but in my test it does not stop the listener (uptime does not change). What situation can I use only reload and when I must stop/start the ...
Astora's user avatar
  • 723
0 votes
1 answer
110 views

SQL server Listener removal [closed]

Hi I am planning to drop and recreate the listener with same name what is the best approach? Can i drop the listener from WFCS by removing the resorces or Drop the listener from SQL using SQL command? ...
pavan HM's user avatar
0 votes
0 answers
93 views

Availability Group Listener Loses Connectivity on Failover

I have 2 SQL server 2016 standard Servers. Production (SRV1). For reporting (SRV2) Both servers are nodes in WSFC. SRV1 replicates the production database (DB1) to SRV2 with the distributor ...
BlakeC's user avatar
  • 11
3 votes
1 answer
62k views

Cannot connect database as sys as sysdba using sqlplus

I am new to oracle server 18c (currently taking online course). My problem is sql*plus where I tried to use sqlplus then sys as sysdba (it did not work) and the error appeared below. However, if I ...
Khang Mai's user avatar
2 votes
2 answers
2k views

what happens to user connections when an AG fails over?

I'm not sure quite how to word this, but I am looking for anything a DBA can do (things outside of changing code in the application) to reduce the impact to users when an AG fails over. We have a 2 ...
DBA Greg14's user avatar