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.

learn more… | top users | synonyms

0
votes
1answer
23 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
vote
0answers
21 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 ...
0
votes
0answers
21 views

How can I get Data from 4D ODBC using Oracle 11 g

I want to recover 4D data in an Oracle database ,I followed the steps below : 4D side : Installation of 4D v14 ODBC 64bit . Creating an ODBC source (successful Connection Test ) Creating and ...
0
votes
0answers
22 views

SQL Server 2014 Availability Group Listener only visible to primary node of AG

I'm having some trouble configuring the Availability Group Listener for SQL Server. Here's my current setup: I have one server, lets say server DC, which acts as the domain controller for AD DS with ...
0
votes
0answers
33 views

is it possible to use SQL Server listener IP to the application?

I have 2 application servers and I have SQL Server clusters with always on high availability. I need to point my application server database to the SQL Server listener IP. Is it possible ? if so ...
1
vote
3answers
83 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 ...
0
votes
0answers
45 views

Oracle Netca is configuring IP instead of hostname in listener

I have a standardized Windows 2012 image that I'm running a build package on. On multiple servers it uses hostname in the listener file, but on one test machine it defaults to IP. Is there a reason ...
1
vote
2answers
46 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 ...
0
votes
1answer
18 views

Oracle Listener.ora ignored

I have the following listener.ora file located in $ORACLE_HOME/network/admin/ : TESTSID = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (...
0
votes
1answer
110 views

What is difference between internal and external load balancer listener with respect to azure (IaaS)

As per below MSDN blog, I see there are 2 ways we can create load balancer listener . https://azure.microsoft.com/en-gb/documentation/articles/virtual-machines-windows-classic-ps-sql-int-listener/ ...
0
votes
0answers
63 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 ...
0
votes
0answers
86 views

Unable to create availability group

While trying to create an availability group, I am getting the below error. Can someone find the root cause of this? I even granted "create computer objects" permission, but it still did not work. ...
3
votes
2answers
70 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 ...
1
vote
0answers
53 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 ...
0
votes
2answers
76 views

Disable MEMORY_TARGET after being locked out of database?

I'm setting up a local development environment in a virtual machine in which I installed Oracle XE among other software. When I initially set up the virtual machine, the RAM was set to 4Gb. In this ...
0
votes
3answers
479 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/...
0
votes
0answers
40 views

One Listener for two Oracle Versions

I've got an dev machine with Oracle 10 and 11 running (on separate users) So I want to use only one Listener (the new from 11). I deleted the Listener of Oracle10 and created one on Oracle11. After ...
0
votes
1answer
689 views

adrci not purge trace files and alert logs

I try to purge some files in oracle. I use adrci. I want to purge trace files in listener file. But it's not work. I don't know why. [grid@orcl1 app]$ adrci adrci> set homepath diag/tnslsnr/orcl1/...
5
votes
2answers
195 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 ...
1
vote
0answers
170 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 = (...
0
votes
0answers
199 views

Issues with SCAN IPs in Oracle RAC

I have 5 SCAN IPs running in my two node RAC database - 12c. Thing is that one scan listener is running in my node 1 and other listeners are running in node 2. When I try to ping the one scan listener ...
1
vote
2answers
53 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
1
vote
1answer
218 views

Remote connection issue from windows machine

I have installed database 11g on machine A (Windows). Now I need to access that database from machine B (Windows), where my application is placed. I am able to ping B --> A but telnet is not working. ...
1
vote
1answer
132 views

Listener protocol error - Oracle

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
0answers
71 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
1answer
131 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. ...
1
vote
1answer
89 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
0answers
183 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 ...
1
vote
0answers
594 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. ...
1
vote
1answer
39 views

Configuring Listener on Oracle Server

I am very much new to Oracle environment. I was trying to connect to my Oracle server from another machine on the same network. I found out that I need to configure Oracle Listener on the server that ...
-1
votes
2answers
246 views

Query to get the listener.ora path in Oracle 11G

Can anyone help me out with an PL/SQL query to get the path of the listener.ora file in Oracle 11G? I require it to be fetched from the Oracle DB only via an SQL query & not via the Operating ...
1
vote
0answers
344 views

Oracle listener configuration

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

How to fix “TNS:listener does not currently know of SID given in connect descriptor” with DBVisualizer on Linux?

I am trying to connect with Oracle database from a server having Oracle client installed (RHEL Linux Environment). I installed DB Visualizer on client machine. But getting listner error on hitting ...
0
votes
0answers
27 views

Oracle listener up but instance connection blocked ORA-12528 / ORA-12505! [duplicate]

Its been one week since i last try to run my final project that i worked in my last internship at some banking company. Suddenly, my webapps (java project) in eclipse cant start. In the log it says ...
2
votes
1answer
2k 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
0answers
4k 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
2answers
25k 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
1answer
673 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 ...
0
votes
1answer
331 views

How do the Oracle DB instance and the local listener communicate?

It seems this my other question needs some background: Basically, on Windows, how do the Oracle DB instance process and the listener process communicate? Do they use TCP? Is the configuration of this ...
1
vote
1answer
28k 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. ...
3
votes
3answers
31k 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 ...
0
votes
2answers
13k views

ORA-12518: TNS:listener could not hand off client connection ORACLE XE 11.2 x64

Im starting to be very very frustrated by this Oracle. So, I have installed Oracle XE 11.2 64 bit and ODAC121012_x64. I can start listener, I can do tnsping xe, but when I try to connect as via ...
1
vote
1answer
17k 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: ...
3
votes
1answer
10k 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
2answers
2k 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 ...
1
vote
1answer
6k views

listener can not start

My listener in Oracle 11g R2 can not start . When I want to give the status of that, the error in below is shown: Connecting to <ADDRESS=<PROTOCOL=tcp><HODT=><PORT=1521>> TNS-...
1
vote
2answers
4k 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 ...
0
votes
2answers
5k views

Cannot connect to database remotely (not even locally when using ip address)

I can login using this command: sqlplus test/test@127.0.0.1:1521/local But not this one: (where 192.168.0.240) is my IP sqlplus test/test@192.168.0.240:1521/local I am absolutely sure that my ip ...
1
vote
1answer
2k views

Unable to create a new listener in oracle 11g

In net manager i get an error message "A valid logfile is required" when i click on listener and choose '+' button. and then it keeps on giving me that error when i click on any other tab or button in ...
0
votes
1answer
945 views

extproc env variables oracle 11g

I have oracle 11g with extproc separately configured in listener.ora. Users report some environmental variables that should be exported are not set. From where does extproc gets it environment ...