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.
173
questions
0
votes
1
answer
35
views
Login via SQLServer AlwaysOn "Listener" Failed (Error: 18456, Severity: 14, State: 5)
I have setup an AlwaysOn Availability Group on SQLServer 2022.
I have created a login on both replicas with same SID.
But I could not login via listener IP or DomainName via SSMS.
I could login ...
- 9
0
votes
1
answer
48
views
Azure MS SQL Always On Availibity Group Setup Issue
I have 2 VMs on azure where MS SQL server is configured with always on high availability, one VM is acting as primary and other one is secondary. On top of that, there is domain controller VM which is ...
0
votes
1
answer
50
views
Does availability group listener runs on both SQL Server nodes or does it run on a separate machine
Lets say I am setting up AlwaysOn Availability Groups and following are the nodes:
Primary
192.168.1.10
Secondary
192.168.1.11
I try to create a DNS entry for availability group listener called ...
- 451
0
votes
0
answers
52
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 ...
- 1
0
votes
0
answers
107
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/...
0
votes
1
answer
743
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 ...
- 11
1
vote
0
answers
60
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 ...
- 66
0
votes
0
answers
69
views
I am having trouble creating a listener in Oracle 19C
These are my active services:
SQL> SELECT NAME FROM V$ACTIVE_SERVICES;
NAME
----------------------------------------------------------------
pdb3
orcldb
pdb2
pdb1
and this is my listener.ora ...
- 62
0
votes
1
answer
221
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/...
- 55
0
votes
1
answer
1k
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=...
- 3
1
vote
1
answer
314
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 ...
- 13
2
votes
2
answers
532
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 ...
- 373
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 ...
- 23
0
votes
1
answer
343
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 ...
- 115
0
votes
1
answer
385
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 ...
- 101
0
votes
2
answers
870
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 ...
- 245
0
votes
1
answer
662
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 ...
- 349
0
votes
1
answer
581
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 =
...
0
votes
1
answer
2k
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 ...
- 7,436
0
votes
1
answer
756
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 ...
- 1
0
votes
1
answer
3k
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).
...
- 21
2
votes
1
answer
344
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 ...
- 23
-1
votes
1
answer
148
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, ...
- 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.
0
votes
1
answer
540
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 ...
- 9
0
votes
0
answers
350
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 ...
- 121
0
votes
2
answers
1k
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 ...
dragont
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, ...
1
vote
1
answer
446
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 ...
- 43
0
votes
1
answer
276
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 ...
- 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 ...
- 29
0
votes
1
answer
5k
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 ...
3
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 ...
- 113
0
votes
0
answers
581
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 ...
- 1
0
votes
1
answer
409
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 =
(...
- 29
1
vote
2
answers
6k
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) ...
- 13
0
votes
1
answer
81
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 ...
- 15
0
votes
2
answers
125
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 ...
-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 (...
- 84
0
votes
1
answer
430
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 ...
- 95
0
votes
1
answer
3k
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 ...
4
votes
1
answer
34k
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....
- 141
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/...
- 611
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
...
- 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\...
- 1,950
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 ...
- 801
0
votes
3
answers
13k
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 ...
- 801
0
votes
1
answer
155
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? ...
- 1
0
votes
0
answers
99
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 ...
- 11
5
votes
1
answer
69k
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 ...
- 55