We’re rewarding the question askers & reputations are being recalculated! Read more.

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
17
votes
1answer
84k views

Oracle 11g listener fails with ORA-12514 and ORA-12505 errors

I run an instance of Oracle 11g locally on my development machine and can connect to the local instance directly via SqlPlus: c:\>sqlplus ace SQL*Plus: Release 11.2.0.2.0 Production on Mon Mar ...
13
votes
2answers
138k views

How to configure an Oracle Listener without SID_LIST_LISTENER in listener.ora?

I have access to a ORACLE 11g server using the following listener.ora # listener.ora Network Configuration File: D:\app\Administrator\product\11.1.0\db_1\NETWORK\ADMIN\listener.ora # Generated by ...
9
votes
3answers
1k views

Always On Availability Group, Always redirect user to read only instance

We have an Always On availability group with a primary and a read-enabled secondary. We have a user for the implementation team who uses the database to check the correctness of the data that they are ...
6
votes
2answers
5k views

Listener listening without listener.ora

I have an Oracle DB working in production for more than a year. I have my listener working: [oracle@base admin]$ lsnrctl status LSNRCTL for Linux: Version 11.2.0.4.0 Connecting to (ADDRESS=(...
5
votes
1answer
7k 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 ...
4
votes
4answers
70k views

ORA-12541: TNS:no listener

I've been working this issue all day, reading posts here and other locations. I'm just not able to get past this error. I can connect just fine locally on my server (CentOS), but continue to get the ...
4
votes
1answer
804 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 (...
4
votes
1answer
24k views

Oracle program “lsnrctl” is missing after the installation of 32bit Oracle client

I cleaned up my computer for all old Oracle stuff using Uninstall (OUI) and then later used regedit to delete all references to Oracle and then deleted all remains of Oracle directories. I have HP ...
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. ...
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 ...
4
votes
2answers
4k views

How does SQL*Plus connect to Oracle without a listener?

sqlplus can be used even if there is no listener in the system, or if it isn't running. How does SQL*Plus connect to Oracle without a listener? I can connect any user using SQL*plus even with no ...
3
votes
1answer
5k views

ORA-12528 and ORA-12505 error on Oracle database 11g

It's been one week since I last tried to run my final project that I worked on in my last internship at some banking company. Suddenly, my webapps (Java project) in Eclipse can't start. In the log it ...
3
votes
3answers
1k views

Distributed Availability groups & Listeners

I'm currently doing my first setup with Distributed Availability groups. This is currently a POC setup but will normally be implemented soon. I have 4 nodes, 2 nodes located together and 2 other also ...
3
votes
2answers
8k views

Setting up a listener for sql server alwayson availability groups without computer object rights in the AD

Is there a way to create a sql server alwayson listener in an active directory (AD) environment where I don’t have create computer object rights? The AD admin created a computername for me. Is there a ...
3
votes
2answers
740 views

How is an AAG listener implemented? Where does it run?

I'm fairly new to SQL Server but generally well versed in RDBMS and network topics. I'm trying to wrap my head around AlwaysOn Availability Groups. I've read a handful of articles on MSDN and Googled ...
3
votes
2answers
47k views

Error ORA-12541: TNS:no listener

Whenever I try to start the listener (I just have only one Oracle database) I get the following: LSNRCTL> status Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=admin-41f89f35d)(PORT=1521))...
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 ...
3
votes
0answers
1k views

Oracle listener configuration [closed]

I have oracle 11.2.0 installed on linux. And I have arcgis server 10.2 on the same machine. I created an geodatabase. But when i try the sde functions like sde.st_asText i got: -ORA-28575: unable to ...
2
votes
1answer
102 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 ...
2
votes
3answers
11k 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 ...
2
votes
4answers
43k views

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor on linux

I have configured oracle 12c on Rhel 7. When I try to connect database using following command it gets connected with no issues: sqlplus system/Forest123@orcl I'm facing problem when I try to put ...
2
votes
2answers
45 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?
2
votes
1answer
252 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 ...
2
votes
1answer
55k views

check listener status other than 1521

I have two listner: one is running on port 1521 another on 1531. lsnrctl stat show's status of services running on port 1521 only. How should i check whether the services running on port 1531 is ...
2
votes
2answers
172 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': ...
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
3answers
50k views

How to solve “ORA-12514: TNS:listener does not currently know of service requested in connect descriptor” error?

I am trying to create connection with the database for debugging ASP.Net website. Database is 11g Oracle DB... There is no problem when I connect using SQL Developer, however using Visual Studio I get ...
2
votes
2answers
35k views

SQL Developer cannot connect to Oracle database, yet sqlplus can!

I am having a problem connecting sql developer to my Oracle 10g database. sqlplus is able to connect fine, but when I try to open the connection in sql developer, I get 'ORA-12514 TNS does not know ...
2
votes
2answers
45 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 ...
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 ...
2
votes
1answer
414 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 (...
2
votes
1answer
2k 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-...
2
votes
2answers
566 views

Oracle how do i see who connected to my database

I am using oracle 11g and I would like to see who connected to my database some hours ago. In what file can I see those who have connected to my database through a network connection? Thanks
2
votes
1answer
631 views

Listener protocol error - Oracle [closed]

Okay first things first, this is probably a common issue which gets resolved going through all those questions and googling it but still I face this issue: LSNRCTL> service Connecting to (ADDRESS=(...
2
votes
1answer
407 views

Oracle Application Express Listener PDF Report

We need our reports to be available in PDF format on our Oracle 11g, APEX:4.2.6 Followed this tutorial and selected "Oracle APEX Listener". But the generated PDF report is empty. We are using EPG. ...
2
votes
1answer
1k views

Linking Oracle 10g XE with SQL server using ODBC

I am connecting Oracle 10 XE with an SQL server 2008 using ODBC in windows 7. I have successfully done following steps: Configured ODBC and test it, runs ok! Configured listener in tnsnames.ora and ...
2
votes
2answers
6k views

Listener Log Oracle 11g R2

I'm using Oracle 11gR2 in RHEL5. Now a days my application, during run time, is showing exception as below. Listener refused the connection with the following error: ORA-12519, TNS:no appropriate ...
2
votes
1answer
5k views

listener does not currently know of SID given in connect descriptor in oracle 10g and solaris 10 env

I have an Oracle 10g database on a Solaris 10 system. The SID=OTRS, I can connect to the Oracle database from the local server itself. But I am not able to connect from another client. It is returning ...
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
1answer
166 views

SQL 2014 Availability Group Cluster or Listener

We recently deployed a setup of SQL 2014 availability groups and we are having some difficulty with the failover. Setup: Two windows server 2012R2 VMs in a windows cluster with a CNAME pointed at ...
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
2answers
2k 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 ...
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 ...
1
vote
1answer
380 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
41k views

ORA-01034: ORACLE not available in oracle 11g

I installed oracle 11g on ubuntu 14.04 and i started lister and the message is as below. LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 10-OCT-2014 14:20:02 Copyright (c) 1991, 2011, Oracle. ...