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
0 answers
21 views

Permission error while creating LISTENER in AOAG setup

I know this is more of a NETWORK-related question, but you may have encountered this. We are setting up AOAG with 1 primary and 2 secondary nodes. When configuring LISTENER with 3 unassigned private ...
0 votes
1 answer
1k 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
2 answers
13k 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
1 answer
2k views

ORA-12152: TNS: unable to send break message - Only LISTENER restart works

i have a strange problem with our Oracle 12.1.0.1.0 on our VM Windows Server 2016. I create a daily batch script whichs creates a dump file (via EXP) and execute some sql statements (via SQLPlus). ...
0 votes
0 answers
36 views

listener issues in oracle 19c

These are my listener.ora and tnsnames.ora files listener.ora SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = dr_DGMGRL) (ORACLE_HOME = /u01/app/oracle/product/19.0.0/...
2 votes
1 answer
4k 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 ...
0 votes
1 answer
432 views

Failing to enable TCPS on Oracle 11

I have added the following settings to my Oracle 11 server (Bolded text is the change)- sqlnet.ora- SQLNET.AUTHENTICATION_SERVICES = (**TCPS,** NTS) listener.ora- SID_LIST_LISTENER = (SID_LIST = ...
0 votes
1 answer
43 views

Setting up Oracle 19c Database instance with access from different subnets using scan listeners

We have a RAC cluster where we are upgrading a database. (12c to 19c) The upgrade process is to build a new database on the same cluster and import a copy of the old database. The old database has a ...
2 votes
1 answer
11k 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:...
1 vote
0 answers
48 views

Always-On listener not working correctly

I have an Always-On architecture with two nodes and two AG. One of AG working correctly but other AG's listener only directs to the primary node. When I fail it to the secondary node, the application ...
4 votes
1 answer
7k 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
1 answer
376 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
1 answer
95 views

Configuring a DNN listener for an availability group fails

I am running into problem when creating DNN listener on Azure VM. I am runnign the script provided in Microsoft article: https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/...
0 votes
0 answers
50 views

I am having trouble creating a listner in Oracle 19C. Some help will be appreciated

These are my active services: SQL> SELECT NAME FROM V$ACTIVE_SERVICES; NAME ---------------------------------------------------------------- pdb3 orcldb pdb2 pdb1 and this is my listener.ora ...
0 votes
0 answers
36 views

How to use the same Azure SQL VM in two different Load Balancers

I have already configured always on availability group between VM1 and VM2 azure machines. Internal Load Balancer was created for these two VMs and mapped to AG Listener. VM2 is used for read workload ...
0 votes
0 answers
59 views

How is this service registering with listener when invalid LOCAL_LISTENER is used?

I have a single instance 19c CDB with 2 PDBS, I am also running Grid Infrastructure (Oracle Restart) for ASM. The database has LOCAL_LISTENER set to LISTENER_MYDB which is a non existent listener, and ...
0 votes
1 answer
320 views

LSNRCTL cannot stop Listener

When I'm trying to lsnrctl start, i have following error: TNS-01106: Listener using listener name LISTENER has already been started However, if i try to lsnrctl stop: Connecting to (ADDRESS=(PROTOCOL=...
0 votes
3 answers
11k views

Listener (lsnrctl) reload vs stop/start

Some blogs tell that reload is equal stop and start, but in my test it does not stop the listener (uptime does not change). What situation can I use only reload and when I must stop/start the ...
1 vote
1 answer
134 views

limit access to oracle scan port by IP address

We run an Exadata XM-8 with multiple DBs for a variety of clients in our company. I want to limit access to one of the DBs to one particular server. I know I can run a logon trigger and limit the IP ...
1 vote
1 answer
1k 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
2 answers
403 views

Registration of SPNs for Availability Groups

Manually registering SPNs for Availability group - Do I need to register SPNs for the AG Listener as well as the individual nodes, for both the instance name and the listening ports for the managed ...
2 votes
1 answer
817 views

Listener error ORA-12518 & ORA-12520 after changing the IP with domain

We have a server with Oracle 11g and a database. The network administrator added an alias domain to the ip of the server where oracle is. We haven't changed anything else. After that, when SSRS server ...
0 votes
1 answer
233 views

Where is Oracle TNS redirection configured?

The short version, I need to connect to an Oracle server and I am getting redirected to an IP address that is blocked by the firewall. What do I need to ask to find out what IP addresses I will be ...
0 votes
1 answer
230 views

Is it possible to write a generic trigger for all tables in Postgres?

I want to listen to every transaction that is recorded in the database And I noticed that there is a concept in Postgres under the title LISTEN and NOTIFY (Of course, I am not sure that this is the ...
0 votes
2 answers
581 views

How does SQL Browser work when default port is missing and AG Listener specifies port 1433?

Background: To keep things simple, we have a 2 node cluster where each node in the cluster has 3 instances of SQL installed: default + 2 named. I understand instance stacking is bad and it is ...
0 votes
2 answers
111 views

multisubnet listener

Good morning all , I have an alwayson instance with a multisubnet listener I configured RegisterAllProvidersIP = 0 in order to register a single DNS entry HostRecordTTL is configured at 1200 seconds I ...
0 votes
1 answer
358 views

AlwaysOn listeners across subnets

Can someone help me clear something up with regards to AlwaysOn listeners across 2 subnets. Windows Server 2019 SQL Server 2019 This is in Azure I have created a multi-subnet AG. The listener has 2 IP ...
1 vote
2 answers
6k views

lsnrctl is not working on Ubuntu 14.04

I have managed to install Oracle 11g on Ubuntu 14.04 through lots of pain. I managed to install it in the end but listener does not seem to be working and even responding any command. My /home/...
2 votes
1 answer
3k views

SPN for Availability group(AG) listener for SQL Server 2016

Requesting some inputs.. We have a 2 node SQL 2016 Availability group configured and apps currently use primary replica for connection. We are now planning to use listener instead. Questions is, how ...
0 votes
1 answer
1k views

nslookup returning secondary IP of a listener (different subnet)

I'm pretty confused about this issue. We noticed that we sometimes receive some errors from the app servers causing timeouts. after a lot of digging, we discovered that sometimes when using a listener ...
0 votes
1 answer
245 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 ...
3 votes
6 answers
70k 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 ...
3 votes
3 answers
60k 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))...
0 votes
2 answers
877 views

JDBC oracle listener random port

I have an issue with our listener trying to assign random ports to JDBC connections. We have a 19c oracle db running on a RHEL server with two ports opened 1523 and 1524. When application tries to ...
0 votes
1 answer
664 views

Oracle XE 18c, on every connect attempt, Oracle listener OracleOraDB18Home1TNSListener stops, and I am unable to connect to any connection

For the purpose of learning, I have installed Oracle 18c XE v18.4.0.0 and Oracle SQL Developer v21.4.2. I have no previous experience with Oracle database. Command LSNRCTL stat seems to show correct ...
2 votes
1 answer
3k views

oracle - Change host to 0.0.0.0 in listener

Im using oracle 12c on windows server 2016. I want to make my oracle to listen to the port 1521 to 0.0.0.0 Here is my listner.ora file. # listener.ora Network Configuration File: C:\app\bhuvi\...
2 votes
1 answer
299 views

What is the correct configuration for the SQL Server listener with 2 nodes on-prem and 1 node in Azure?

I am setting up a 3-node Availability Group with 2 nodes on-premises and the 3rd on a VM in Azure. All nodes are SQL Server 2019 Enterprise with CU14. The Availability Group is fine and the listener ...
-1 votes
1 answer
116 views

I have error in one machine from ORACLE cluster

I am using Oracle 10g Cluster. So, the listener on 1 Oracle machine hasn't been working for a week now. I get an error: ORA-12541: TNS:no listener When I want to start listener from oracle user, ...
-1 votes
4 answers
2k views

DNN Listener resolving to a secondary server in WSFC & AO AG

I have an Azure AO AG which consists of three servers (all WS-2019 & SQL-2019 CU8): A - Subnet 1 - Principal Server (Sync) B - Subnet 1 - Secondary Server (Sync) C - Subnet 2 - Secondary Server (...
-2 votes
1 answer
1k views

Netca command not found Oracle 12c (silent mod)

i'm new on the Oracle's world, the installation it was easy and good, but , I dont know where is the problem here.
0 votes
1 answer
457 views

Listener oracle in pacemaker cluster

I need some help. I have created a cluster with 2 nodes. I created all resources, but listener has errors and the pacemaker cluster status shows Oracle Listener has stopped. In the web interface I ...
1 vote
1 answer
374 views

Still can't create an AAG listener

I just built a test cluster with 2 MS SQL Server 2014 machines, 1 domain controller, an 1 file share witness. (All of them are Windows2016-based.) The 2 MS SQL Server machines are a WSFC members. When ...
0 votes
0 answers
290 views

Questions about the endpoints_listener.ora

How to understand the backward compatibility with pre-11.2 databases of the endpoints_listener.ora in depth? Why would manually editing the listener.ora not lead to automatically updating its ...
0 votes
0 answers
3k views

Oracle 19c listener stops on connection TNS-12541 error

I have just installed Oracle 19c Standard Edition 2 on Windows 10 and created a local database. I can connect to it with sqlplus / sysdba, but if I try to connect with sqlplus user/password@host:port, ...
0 votes
1 answer
238 views

Configure listen_addresses automatically in custom installation

I have included Postgres in a custom installer for a Windows application. I do not use the installer binary, but extract the Postgres zip archive for installation and then run initdb from a batch ...
0 votes
2 answers
5k views

Launching LSNRCTL produces an error

I am trying to launch LSNRCTL on my Windows 10 64-bit laptop; Oracle 18 XE I get this error message: C:\app\Owner\product\18.0.0\dbhomeXE\bin>lsnrctl LSNRCTL for 64-bit Windows: Version 18.0.0.0.0 ...
0 votes
2 answers
1k views

How do you configure a 4-node AlwaysOn cluster to have two listeners?

Looking to build a 4-node (servers A, B, C & D) AlwaysOn Windows 2016 failover cluster with 2 nodes in the primary datacenter for HA, and 2 other replica nodes in the DR datacenter for disaster/...
0 votes
1 answer
4k views

Connection to Oracle DB 19c fails when listener is set to the host IP address

I am new to Oracle DB and need help in solving the following issue. I am using sqlplus (SQL*Plus: Version 21.1.0.0.0) to connect to the Oracle DB 19c. Statement: I am able to connect to the Oracle DB ...
0 votes
0 answers
524 views

unable to connect between SQL Developer and Oracle VM Virtualbox

I have setup an Oracle DB within Oracle VirtualBox and I am trying to connect to it using SQL Developer installed on the same desktop. It worked initially but has since stopped connecting. It seems ...
0 votes
1 answer
359 views

Oracle 11gR2 - Dynamic Registration

Database version: Oracle 11gR2 We want to use DYNAMIC_REGISTRATION_LISTENER parameter with off option. Our listener.ora file like this: LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (...