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.
168
questions
0
votes
0
answers
33
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 ...
- 54
0
votes
0
answers
28
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 ...
- 1,243
0
votes
0
answers
40
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 ...
- 21
0
votes
0
answers
41
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
137
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
95
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
1
vote
2
answers
240
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 ...
- 295
2
votes
1
answer
345
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 ...
- 21
0
votes
1
answer
148
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
140
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
371
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 ...
- 193
0
votes
1
answer
158
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 ...
- 181
0
votes
1
answer
331
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
821
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,344
0
votes
1
answer
577
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
1k
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).
...
- 11
2
votes
1
answer
259
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
95
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
916
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
370
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
213
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 ...
- 11
0
votes
2
answers
699
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
2k
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
338
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
209
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
4k
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
3k
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 ...
2
votes
1
answer
3k
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 ...
- 83
0
votes
0
answers
471
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
290
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
3k
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
66
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
104
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
2k
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
349
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
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 ...
3
votes
1
answer
21k
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....
- 131
0
votes
2
answers
981
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,900
0
votes
1
answer
880
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 ...
- 550
0
votes
3
answers
9k
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 ...
- 550
0
votes
1
answer
40
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
78
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
3
votes
1
answer
41k
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 ...
- 35
2
votes
2
answers
1k
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 ...
- 255
0
votes
0
answers
290
views
Install Oracle 12c on Oracle Linux 6.7 port in use
I have attempted to install Oracle 12.1.0.2.0 on Oracle Linux 6.7 multiple times without success. I have installed the database software only with the configuration assistant and am attempting to ...
- 111
0
votes
2
answers
1k
views
ASM - How the asm search the disks and where is this parameter from?
I'm a begginer in Oracle ASM and when I will create a diskgroup the ASM shows me this parameter:
Where is this parameter from? I don't remember set any parameter with this name. I know that usually ...
- 550
0
votes
1
answer
629
views
Oracle - Why create several service_name in service_names parameter?
SERVICE_NAMES specifies one or more names by which clients can connect
to the instance. The instance registers its service names with the
listener. When a client requests a service, the listener ...
- 550
1
vote
1
answer
450
views
Read Scale Availability Groups and Listener
Is it possible to use a listener with a read scale availability group?
I have read on some sites you cannot use one but in others that you can.
If so, what IP address do you use for it? I have ...
- 13