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.

31 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
4
votes
1answer
2k 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 ...
3
votes
0answers
623 views

Connection timeout via AlwaysOn Listener IP on local computer

I have AlwaysOn availability group and it has one Listener IP. I can connect this instance using Listener name but, cannot connect using Listener IP from my local computer. It returns following error ...
2
votes
2answers
104 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 ...
2
votes
0answers
129 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 ...
2
votes
0answers
267 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 ...
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 ...
2
votes
0answers
2k views

TNS-12500: TNS:listener failed to start a dedicated server process Oracle9i Database on Windows 2003 64x server

My client wants to move his database from Windows 2000 server to Windows 2003 Enterprise Edition 64x server. I have created the Windows servers in VMware and installed the Oracle 9i databases on it. ...
2
votes
0answers
10k views

TNS-01190: The user is not authorized to execute the requested listener command

Oracle 11g Release 2 Oracle Linux Enterprise 5.10 [oracle@dub-ImrORA3 scripts]$ id oracle uid=502(oracle) gid=502(oinstall) groups=502(oinstall),503(dba),504(oper) context=user_u:system_r:...
2
votes
1answer
227 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 ...
1
vote
0answers
209 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
639 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
0answers
447 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 ...
1
vote
0answers
362 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, ...
1
vote
0answers
103 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
0answers
454 views

Fail to perfom static registration of nomount instance

I'm trying to make standby to database. I've insalled Oracle 11g database on virtual machine (host - oratest). Standby is on virtual machine too (standbysrv). When I'm trying to connect from source ...
1
vote
0answers
1k views

TNS Listener started but not working

My listener exists and is started, but when I try to connect to the database it tells me no listener exists. I've tried restarting the listener to no effect. listener.ora SID_LIST_LISTENER = (...
1
vote
1answer
171 views

SQL Server 2014 AG Listener

I have built a two node SQL Server 2014 Always On cluster on the same subnet. I need to create two availability groups/listeners in the same instance for two sets of databases. Do I need two separate ...
1
vote
1answer
882 views

Oracle Rac With Scan Error

I have installed Oracle RAC with ASM on Oracle Linux 5.8. My database version is 11.2.0.1. I have 2 node in my plan and all of them are active. I set scan in my DNS server but I can not connect to ...
0
votes
0answers
16 views

SELECT LISTEN in Postgres

How might I SELECT my NOTIFY I sent to the database in an IDE like PG-Admin? I am trying to figure out hour to SELECT my NOTIFY statement so I can use it in ADO recordsets using VBA in MS-Access. I ...
0
votes
0answers
24 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 ...
0
votes
0answers
109 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 ...
0
votes
0answers
209 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
0answers
162 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 ...
0
votes
0answers
608 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
410 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
381 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
2answers
8k views

Net Configuration Assistant doesn't open, created Listener in Net Manager but it isn't recognized when creating database Win 7

I have installed Oracle 11g on my Windows 7 64-bit system. The Net Configuration Assistant does not open for me to create a listener. I was able to add a listener through the Net Manger and it says it ...
0
votes
1answer
185 views

connecting to an oracle sql database from sql developer on the same computer. When the computer is a domain computer

Hi I am trying to do DBA course that requires that I use Oracle database. I am using my corporate pc to do it. I set up the loopback adapter to enable localhost communication and setup the hosts ...
0
votes
0answers
1k views

Cluster network name resource 'XYZ' cannot be brought online

I have given wrong name for listener while configuring the always on in SQL Server management studio. One option I can see is deleting and re-creating the listener, But is it right way of doing it? ...
0
votes
1answer
190 views

Rebuild Windows cluster for Alwayson.

I am setting up Alwayson,somehow my cluster is gone ( get-clusternode shows down,down,down and Joining). SQL Server is working fine. What Should I do? Create new cluster or build new server? Any ...
-1
votes
1answer
499 views

Listener not working after installing Oracle 11g

I have installed Oracle 11g on a machine which was already running Oracle 12c. Now the listeners configured for 12c are not started. Lsnrctl status shows the listener parameter file of 11g. How to ...