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
2answers
24 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 ...
0
votes
1answer
36 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 ...
1
vote
1answer
57 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 ...
2
votes
1answer
34 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 ...
1
vote
1answer
73 views

Availability groups multiple instance, multiple listeners

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 ...
1
vote
0answers
101 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 ...
1
vote
0answers
320 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
53 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
101 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
35 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
174 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
169 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
120 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
263 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
139 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
82 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
68 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
534 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
1k 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
38 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
39 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
139 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
378 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
536 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
6k 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
207 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
497 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
352 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
258 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
415 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
725 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
351 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
589 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
3k 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
407 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
235 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
332 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
220 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
290 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
68 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
362 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 "...
1
vote
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
2k 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
8k 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 ...