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
1 answer
17 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 ...
user avatar
  • 7,104
0 votes
1 answer
88 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 ...
user avatar
  • 1
0 votes
0 answers
211 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). ...
user avatar
  • 11
2 votes
1 answer
96 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 ...
user avatar
-1 votes
1 answer
49 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, ...
user avatar
  • 1
-2 votes
1 answer
243 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.
user avatar
0 votes
1 answer
90 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 ...
user avatar
0 votes
0 answers
58 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 ...
user avatar
  • 11
0 votes
3 answers
273 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
727 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, ...
user avatar
1 vote
1 answer
157 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 ...
user avatar
0 votes
1 answer
51 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 ...
user avatar
  • 111
0 votes
2 answers
1k 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 ...
user avatar
0 votes
1 answer
935 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 ...
user avatar
1 vote
1 answer
966 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 ...
user avatar
  • 73
0 votes
0 answers
188 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 ...
user avatar
  • 1
0 votes
1 answer
160 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 = (...
user avatar
0 votes
2 answers
1k 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) ...
user avatar
0 votes
1 answer
28 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 ...
user avatar
0 votes
1 answer
48 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 ...
user avatar
-1 votes
4 answers
1k 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 (...
user avatar
  • 84
0 votes
1 answer
198 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 ...
user avatar
0 votes
1 answer
760 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 ...
user avatar
3 votes
1 answer
11k 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....
user avatar
0 votes
2 answers
503 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/...
user avatar
1 vote
1 answer
572 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 ...
user avatar
  • 25
1 vote
1 answer
1k 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\...
user avatar
  • 1,698
0 votes
1 answer
470 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 ...
user avatar
  • 508
0 votes
2 answers
5k 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 ...
user avatar
  • 508
0 votes
1 answer
17 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? ...
user avatar
0 votes
0 answers
38 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 ...
user avatar
  • 11
3 votes
1 answer
18k 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 ...
user avatar
2 votes
2 answers
600 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 ...
user avatar
0 votes
0 answers
265 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 ...
user avatar
0 votes
2 answers
708 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 ...
user avatar
  • 508
0 votes
1 answer
353 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 ...
user avatar
  • 508
1 vote
1 answer
330 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 ...
user avatar
2 votes
1 answer
979 views

CNAME alias for AlwaysOn Listener

We are currently experiencing an issue with SQL Server migration. There is a legacy product and we don't want to change connection strings due to various reasons. Thus, we would like to keep existing ...
user avatar
2 votes
2 answers
2k views

Availability groups multiple instance, multiple listeners [closed]

In my work environment, I have two database machines: DB01 DB02 Each database machine has three SQL Server instances: MSSQLSERVER FBG Central I've managed to set up availability groups with SQL ...
user avatar
  • 23
1 vote
0 answers
747 views

Oracle 18 on Windows with long hostnames doesn't talk to the local listener?

Note: Initially this was about installing Oracle 18c XE on a Windows machine with a long (> 15 chars) hostname. During our further tests we then noticed that Oracle 18c XE does not work properly at ...
user avatar
  • 2,401
1 vote
0 answers
3k views

Oracle listener give "Message 850 not found; No message file for product=network, facility=NL"

I'have just completed oracle 11g database software installation on Linux. I launched netca and configured a listener. As soon as I try to run lsnrctl I get the following error. [oracle@lnx-db ~]$ ...
user avatar
  • 337
1 vote
1 answer
340 views

Question on Enabling Kerberos Authentication using SetSPN for Availability Listener alternative DNS name

We have Availability Group, and original DNS name that was given to AG Listener, is too long (something like longername-Listener-01.mydomain.com); Its hard for us to change original DNS name of ...
user avatar
2 votes
0 answers
294 views

Connection to availability group listener on non-default port doesn't require port to be specified

I inherited some 2016 SQL Servers with an availability group and listener. The SQL instances are set up to use port 30001, and the AG listener is also set up to use port 30001. When I connect using ...
user avatar
  • 21
1 vote
1 answer
189 views

SQL 2017 CU10 on Windows Server 2019 - Availability Group Listener fails to obtain IP from DHCP

We have a few instances of SQL 2017 CU10 Standard on several Windows Server 2016 machines, and normally we create Basic Availability Groups with Listeners obtaining IPs from our DHCP (192.168.112.0/22 ...
user avatar
1 vote
1 answer
2k views

Listener IP not changing after failover

We have a multi-subnet AlwaysOn availability group. There are 2 subnets and those are listed on the cluster and also the listener. Whenever I fail over and ping by the listener name it still shows ...
user avatar
  • 1,007
0 votes
0 answers
375 views

SQL listener connection fluctuates between primary and Secondary

We have SQL Server 2017 + CU11 Always On set up with one primary and a secondary replica. Suddenly we started facing issues where SQL Server AG listener connection started fluctuating between primary ...
user avatar
0 votes
1 answer
807 views

Listener Port 1433 for Always on Availability Group

In our Availability group I have a reporting server where report writers will connect directly and also crystal reports will be used, If the listener port is 1433 and the clients also gets connected ...
user avatar
  • 1,007
1 vote
1 answer
1k views

I need help creating an encrypted listener for my 11gR2 database using a wallet and SHA1 encryption

We are using 11.2.0.4. Since Oracle connections are not encrypted by default and access personally identifiable ( PII ) data in our application we are required to go to an encrypted listener. I am ...
user avatar
  • 1,502
0 votes
0 answers
835 views

SQL Server error 19456 when adding the listener

I have three replica same subnet both has a Private and public network. I was able to create the cluster and create the availability group . When I try to add the listener I get the below error ...
user avatar
  • 1,007
1 vote
2 answers
388 views

AG listener creation failed SQL Server [closed]

I'm getting the error below while creating an AG listener in SQL Server. Ensure that the network adapters for dependent IP address resources have access to at least one DNS server. Alternatively, ...
user avatar
  • 11