Stack Exchange Network

Stack Exchange network consists of 174 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.

0
votes
0answers
36 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
34 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
36 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
16 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
21 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
49 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
102 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 ...
0
votes
0answers
95 views

TNS-01153 : Failed to Process the String

I changed IP Server address which installed Oracle 11g on windows server. But my listener service has not worked so I can't access from the remote. Below are my listener.ora # listener.ora Network ...
2
votes
2answers
34 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
33 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. ...
0
votes
0answers
27 views

TCP / IP SQL configuration

I currently have two instances. Initially, I had only one network card, but I added one more. I have configured the new IP of the second card in the TCP / IP corresponding to one of the instances, the ...
2
votes
2answers
69 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
154 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
208 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
0answers
11 views

error in create listener in server testing

I have try to create listener AGSQLDBDC01 into server testing name SQLDBDC01 but failed. What another solution for solve this error?
0
votes
1answer
2k 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
97 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
230 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
728 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
228 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
0answers
394 views

SQL Server not starting after SQL Server 2016 SP1 CU6

After installing SQL Server 2016 SP1 CU6, AG listener will not start. Error log is filled with 41066 and 41160. Below are some lines from error log. Error: 41066, Severity: 16, State: 0. Cannot ...
0
votes
1answer
174 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
837 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
206 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
381 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
259 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
310 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 ...
1
vote
1answer
1k 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
698 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
268 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 ...
3
votes
1answer
138 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
1k 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 ...
0
votes
0answers
401 views

Can't start the listener - lsnrctl start stop and status do absolutely nothing

lsnrctl start stop and status do absolutely nothing and cannot start the listener xxx@server:/$ lsnrctl start xxx@server:/$ lsnrctl status my listener.ora # Generated by Oracle configuration ...
4
votes
1answer
964 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
237 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
138 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
223 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
51 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
293 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
1k 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 ...
1
vote
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
4k 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
4k 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
183 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
841 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
76 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 ...
1
vote
1answer
84 views

Configure SQL Server to associate a user login with a specific port

We have SQL Server instances that sit in our DMZ, and associated firewall rules to allow access to them from our corporate network. The server is correctly listening on the configured ports, but now ...
2
votes
3answers
7k views

Why is TNSLSNR loading wrong listener?

I'm using ORACLE 12c. I have 1 CDB and 1 PDB (for what I know). To practice, I have created 2 listeners. I have made the appropriate settings in my tnsnames.ora file. Observations: when I just run ...
3
votes
1answer
1k views

Allow remote access to Oracle 12c

After finishing the installation of Oracle 12c on Centos 7, now I try to allow access on my PC (via SQL Developer) to the server. The problem is that when I do: lsnrctl status I get this error: TNS-...
4
votes
1answer
562 views

AG listener issues with ApplicationIntent=ReadOnly

Need help in resolving a specific issue connect AG listener with ApplicationIntent=ReadOnly. We have 3-node cluster with AlwaysOn AG and synchronous replica. All 3-nodes are in same data center (...