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
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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
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-...
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. ...
1
vote
4answers
2k views

AlwaysON - Force users connection to use Readable Secondary Nodes

I'm implementing SQL Server 2015 Enterprise on my actual client, using Always On Availability Groups. Processes like Reporting, ETL (extraction of data), and read workload are being redirected to the ...
1
vote
1answer
35k views

Linux Error: 111: Connection refused LSNRCTL

I have a problem starting my listener, I am using Centos 6.5 and Oracle 12cR1. Database has been installed successfully. Now my issue is when I start my listener, the following error is shown: ...