Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

-1
votes
0answers
31 views

Is there any script for oracle listener to restart it

Is there any script that could restart listener when dedicated connections reach to more than 500? Best regards
1
vote
0answers
56 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 ...
0
votes
0answers
73 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 ~]$ ...
1
vote
1answer
40 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 ...
2
votes
0answers
72 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 ...
1
vote
1answer
26 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 ...
1
vote
1answer
113 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 ...
0
votes
0answers
137 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 ...
0
votes
1answer
86 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 ...
1
vote
1answer
210 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 ...
0
votes
0answers
93 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 ...
1
vote
2answers
64 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, ...
0
votes
1answer
36 views

Difference between Client Access Name in SQL server Fail over Cluster and Always on availability group

We are migrating from SQL Server Fail over Instance to Always On Availability group. The current network name is ABC\ABCTEST where ABC is the SQL server Virtual Name and ABCTEST is the named instance ...
0
votes
1answer
26 views

Don't show local databases in SQL Always-On AG

We're installing a SQL Server Always On AG solution(SQL Server 2016) in a test-enviroment at our organisation. When testing the features we notice that all databases from a node are listed when we ...
1
vote
1answer
391 views

Turn off listener logging in oracle 12c release 2

I am trying to turn off listener logging in oracle 12c R2 (SAP on oracle), but I am getting a TNS-12508 error. I have verified that the listener.ora is owned by the oracle user and I am performing the ...
3
votes
1answer
796 views

Oracle Database Server TNS Listener Remote Registration Vulnerability (CVE-2012-1675)

Some of our Internal DBs Oracle installed in Linux and Windows servers have been highlighted with the issue Oracle TNS Listener Remote Poisoning (CVE-2012-1675). This security alert addresses the ...
2
votes
2answers
36 views

Availability Group Listener - Dedicated Server?

Should an AG Listener be set up on it's own server? If so, does it require it's own SQL Server license?
1
vote
1answer
36 views

SQLServer - Detect who is connecting via an AG listener

We have multiple generations of applications connecting to SQL Server, some of which we know [their connection libraries] do not support using the MultiSubnetFailover=True connection parameter. Fine. ...
2
votes
2answers
114 views

Sqlcmd: 'KReadOnly': Unknown Option

I am using SQL Server 2014 SP2 with AG, running this command: sqlcmd -S ABC-ISELL -E -d ABP_SFA_BMB -K ReadOnly Where ABC-ISELL is the listener name, I am getting this error: Sqlcmd: 'KReadOnly': ...
1
vote
1answer
308 views

Listener does not connect to the correct instance

I have an instance with Always ON and two replicas, one of primary and one of secondary. I have created another instance and enabled Always On, each group located in different instances has a ...
0
votes
0answers
442 views

Availability group listener is not listening

I've successfully created an availability group with 3 nodes. I've tried to create a listener, separately trying port 1433 and 1435, but the listener is not even trying to listen - there's no entry in ...
0
votes
1answer
5k views

Listener Status Blocked

I'm deploying a 12C dataguard on oracle. When performing all procedures, start the instance in the standby, as nomount. I noticed that the standby listener is as BLOCKED status, making it impossible ...
1
vote
0answers
189 views

Secondary Replica Read-Only Routing via Linked Server working from one server, but not the other

I have been given the task of setting up a read-only linked server on ServerA to Availability Group listener ListnerX. ListnerX points to ServerY or ServerZ (ServerY is usually the primary). Read-only ...
1
vote
1answer
428 views

Oracle 10g Listener issues after IT changed computer domain name

I need some help here. We have Oracle 10.2.0.5.0 installed on a windows 2008R2 machine. The issue is that our IT department changed the domain for that machine. I tried editing our tnsnames.ora and ...
1
vote
2answers
1k views

SQL Server Standard Basic Availability Group - only 10 Listeners limit?

Is there a limit to the number of listeners that can be created using SQL Server Standard? I'm working with a DBA who has set up a 2017 Standard server, with CU3. We have 12 databases, and he was ...
0
votes
1answer
321 views

Unable to connect to Listener after rebuild

I dropped an AG with DROP AVAILABILITY GROUP [MyDb] it had a listener. I left the listener open in the object Explorer of SSMS 17.3. While the AG and Listener were down. I hit refresh on the ...
0
votes
1answer
232 views

Rule of thumb on what changes require a database reboot

I am working on enabling SSL for database listeners. As a part of it, I have to modify the sqlnet.ora and listener.ora files. Does this require a database bouncing to take effect? Is there a general ...
0
votes
1answer
2k views

Setting up the Listeners for Oracle Dataguard

I setup up a Oracle 12c Dataguard configuration. To build the standby database I used the RMAN DUPLICATE command, which requires a static listener configuration. tnsname.ora on HOSTNAMEA and ...
0
votes
1answer
344 views

Oracle: Listener alias vs Listener name

In sqlplus we can set the local_listener to either the description of the listener or the listener alias. What is the difference between listener alias and listener name. Are these the same ? If not ...
0
votes
1answer
627 views

Connect Oracle Database 12c via SQL Developer when it is in restricted mode

I would like to connect to database 12c via SQL Developer(in same VM where db is hosted) when it is in restrict mode. Tried below approaches but nothing worked. Kindly help ! Added (UR=A) in tnsname....
0
votes
0answers
331 views

Unable to connect Oracle 11g server remotely after recovering Database on a new host?

I have recovered my Oracle database using RMAN after following this tutorial http://www.isaca.org/Groups/Professional-English/oracle-database/GroupDocuments/CKE-...
0
votes
1answer
492 views

Unable to connect to Oracle 11g server remotely using SQL developer ORA-12520

Hello everyone I'm unable to connect to my Oracle Server remotely using SQL developer ....while I can connect from SQL developer when I'm in the server directly ....I get the following error when I ...
2
votes
1answer
2k views

How can I troubleshoot issues with dynamic registration?

For testing I have been trying to install Oracle 11g on a test system with a single database several times with the aid of snapshots. This most recent iteration I have been having issues getting the ...
2
votes
1answer
1k views

When trying to configure data guard broker I'm getting Error: ORA - 12154 : TNS: could not resolve the connect identifier specified

I'm trying to setup data guard broker in my production instance. I have duplicated the primary database to standby database successfully. I've added primary database to data broker configuration and ...
1
vote
0answers
383 views

When trying to configure data guard broker I'm getting Error: ORA-16606: unable to find property “”

I'm trying to setup data guard broker in my production instance. I have duplicated the primary database to standby database successfully. I've added primary database to my configuration and when I'm ...
2
votes
1answer
207 views

Reaching SQL Server AlwaysOn HA listener from the Internet

I've successfully created a SQL Server AlwaysOn High Availability Group between two servers and everything seems to be working great internally. Each replica is on a separate physical location, behind ...
1
vote
2answers
2k views

What is an example of an extproc.ora file?

What do the contents of extproc file look like? I'm aware that my extproc.ora file is missing, and I'd like to create one in it's absence. The instructions here tell me to: Configure the Oracle ...
4
votes
1answer
1k views

SQL Server AG Listener issues in an AWS VPC

I'm experimenting with creating a 2-node SQL Server Availability Group following Guy Glantser's excellent guide at MadeiraData where he describes a configuration with no AD domain or internal DNS. ...
1
vote
0answers
304 views

Error CRS-5014 when runing RAC 11gr2 on Redhat 6

My database using RAC 11gr2 with two node on Redhat 6. My system running fine, but after some time about 3-4 days. Process "ora.LISTENER.lsnr" change status Online to INTERMEDIATE and then pedding, ...
2
votes
1answer
205 views

Listener is not starting in my Standby database

I'm facing a serious issue in data guard installation. I'm setting oracle_sid and oracle_home and when I start the listener,error is showing as below: C:\Windows\system32>lsnrctl start LSNRCTL for ...
0
votes
1answer
273 views

SQL 2016 Always on Listener

I have followed many articles on how to get SQL 2016 always on setup and I am hopelessly stuck on the listener. One of such articles is http://blog.fedenko.info/2016/06/sql-server-2016-always-on-...
0
votes
2answers
64 views

AlwaysOn Read Only Routing Configuration for Different Listeners

I have 5 sql servers. 3 of them are working sync and 2 are async. Load Balance Read-Only Routing is a great feature on SQL Server 2016. But if I add async servers into the load balancing configuration ...
1
vote
1answer
343 views

Do I need an Availability Group Listener if I have “Failover Partner” in my connection string?

I am a developer trying to work with a new Sql Server 2016 Always On cluster. In reading documentation I am getting conflicting information. Some documentation tells me that I just need to add "...
0
votes
1answer
2k views

Connecting to ReadOnly Secondary Replica of SQL Server via the Listener by Default

We have the ApplicationIntent=ReadOnly properly routing our users to the Secondary ReadOnly replica. Is there a way to make this the default behavior? Apparently the default behavior seems to be ...
2
votes
1answer
1k views

AlwaysOn AG with and without listener

I inherited a few SQL Servers (2014) with AlwaysOn AGs on AWS. I am totally new to this and we are talking live production environments. 2 different setups. Both have 2 servers each with one AG, so ...
0
votes
1answer
7k views

ORA-12504: TNS:listener was not given

I created container orcl2 database with pluggable database pdborcl2. When I try to connect SQL> connect system@pdborcl2 I get this error: ORA-12504: TNS:listener was not given the ...
4
votes
1answer
6k views

AlwaysOn Availability Group listener port selection

Simple question (I hope!) Why would you use a non-default port for an Always On AG listener? I haven't found a good post (yet) outlining advantages vs disadvantages. Currently, I can think of three ...
2
votes
1answer
302 views

Add New Interface for Oracle DB

I believe there are similar question about this. But I need more explanation about my plan. I have an 11g Oracle database running with one listener on port 1522. And currently using one interface (...
0
votes
1answer
1k views

Why do we need listener for Oracle EBS application server?

I'm using Oracle Application EBS R12 which connects to Oracle DB 10.2.0.4 Why do we need Listener.ora in Oracle EBS Application ? If so, can anyone explain why EBS Application needs it ?
1
vote
0answers
93 views

AG Listener network traffic routing

I'm trying to get a clearer picture of how communication works with Availability Groups. I know the listener technically 'lives' in the sqlserver.exe process on the primary server. I also know that ...