7
votes
Accepted
Cannot connect database as sys as sysdba using sqlplus
If the password contains special characters such as @, enter the password between double quotes:
$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Nov 11 15:41:40 2019
Version ...
- 39.5k
6
votes
Listener listening without listener.ora
You don't need a listener.ora. The listener will happily start without one, but will just start without supporting any services. pmon will periodically register databases with the listener, but you ...
- 31.5k
5
votes
Accepted
Distributed Availability groups & Listeners
After a call with someone from Microsoft, I was told that there are no listeners on the Distributed availability level yet. So currently if we want to use DAG, you will have to change your DNS or ...
- 1,712
5
votes
Always On Availability Group, Always redirect user to read only instance
I don't have an answer to your entire question (though I gave an answer to a similar question today https://dba.stackexchange.com/a/137844/36812) but you mentioned that using ApplicationIntent=...
- 3,488
5
votes
Accepted
Connecting to ReadOnly Secondary Replica of SQL Server via the Listener by Default
The Availability Group Listener is (per the documentation), simply "a Domain Name System (DNS) listener name, listener port designation, and one or more IP addresses." It becomes a resource in the ...
- 15.9k
5
votes
Reaching SQL Server AlwaysOn HA listener from the Internet
It's generally considered a really bad idea to make your database accessible from the internet.
Making the database accessible from the public internet is a HUGE security risk. It's easy to port-...
- 15.9k
5
votes
SQL Server Standard Basic Availability Group - only 10 Listeners limit?
The limitation is only number of replicas.
Limit of two replicas (primary and secondary).
he was able to set up 12 basic availability groups. He was able to set up 10 listeners
You can create many ...
- 61.8k
5
votes
Accepted
SQLServer - Detect who is connecting via an AG listener
[…] is there any way to verify this from the SQL side once they are connected?
Unfortunately there is not, most of the client side connection string settings are not persisted or sent across the wire ...
- 28.1k
5
votes
Accepted
CNAME alias for AlwaysOn Listener
Yes you can create CNAME pointing to listener name. I have been using the same for over 100 Availability group. SQL Server version 2012, 2014, 2016 and 2017. I have been using this for close to 3 ...
- 12.8k
4
votes
Accepted
Listener listening without listener.ora
"As far as I know, for the listener to work, I have to have listener.ora file."
Starting with 8.1.5, listener.ora is optional for a default listener.
Starting the Listener without a LISTENER.ORA (...
- 39.5k
4
votes
Accepted
AG listener issues with ApplicationIntent=ReadOnly
The reason that this fails outside of the internal Rackspace location is due to the URL Endpoints being set to a value that is not able to be connected through from your local environment.
I discuss ...
- 28.1k
4
votes
Accepted
Do I need an Availability Group Listener if I have "Failover Partner" in my connection string?
Failover partner is for when you are using database mirroring, you should not use it for Availability Groups. While it, strictly speaking, will work, it will only do so when the primary server is ...
- 3,983
4
votes
Availability Group Listener - Dedicated Server?
The listener is part of the Availability Group and will reside in the resource group of the Availability Group in the Windows Server Failover Cluster. Thus it is not possible to have a specific ...
- 28.1k
4
votes
nslookup returning secondary IP of a listener (different subnet)
If you’re using the default cluster settings, RegisterAllProvidersIP = 1, SQL Server will register all listener IP address in DNS, not just the active one. As such, DNS will return all registered IP ...
- 3,303
3
votes
AlwaysON - Force users connection to use Readable Secondary Nodes
There is no way to complete this with just SQL Server and the interfaces it exposes. In order to do this you'll either need an appliance between the clients and SQL Server (the users connect to the ...
- 28.1k
3
votes
Accepted
Setting up a listener for sql server alwayson availability groups without computer object rights in the AD
There is one proper way to pre-stage the listener and one way to allow the cluster to create the listener itself. Please note that YOUR account is not what is used to authorize to AD to create the ...
- 28.1k
3
votes
Accepted
Configure SQL Server to associate a user login with a specific port
See the instructions at:
Configure the Database Engine to Listen on Multiple TCP Ports
To set up a new TDS endpoint a code sample is:
USE master;
GO
CREATE ENDPOINT [CustomConnection]
STATE = ...
- 13.9k
3
votes
What is an example of an extproc.ora file?
Why do you expect that "there must be more to it"? extproc.ora simply sets environment variables for the extproc daemon, which is used to execute code for external stored procedures, and for ...
- 24.3k
3
votes
Accepted
How can I troubleshoot issues with dynamic registration?
Listener registration in the database can be traced with:
alter system set events='immediate trace name listener_registration level 3';
Disable tracing when it is not needed anymore:
alter system ...
- 39.5k
3
votes
Sqlcmd: 'KReadOnly': Unknown Option
One needs to use recent enough a version of sqlcmd. The parameter for application intent is -K. Note that sqlcmd's parameters are case sensitive, which is uncommon in Windows environment.
To check ...
- 2,926
3
votes
Accepted
Listener IP not changing after failover
This behavior occurs due to the time to live (TTL) on the DNS records. A client does not do a DNS lookup every time it attempts to connect to a server. It first looks in its DNS cache to see if ...
- 7,889
3
votes
Accepted
What is the correct configuration for the SQL Server listener with 2 nodes on-prem and 1 node in Azure?
For the listener connection to work in a DR scenario do I need to follow the instructions for creating the listener on the WSFC here instead?
Since you only have a single node in Azure and that must ...
- 28.1k
2
votes
ORA-12518: TNS:listener could not hand off client connection ORACLE XE 11.2 x64
To understand the problem and try to fix it you need to check related logs:
listener.log, alert log, trace file, etc
possible causes and solutions:
listener problem:
Make sure there is no error ...
- 2,670
2
votes
ORA-12518: TNS:listener could not hand off client connection ORACLE XE 11.2 x64
I has this problem in Windows (with oracle 11g) because the user under which the listener service was running was not part of the administrators group... once added to the administrator group all was ...
- 31
2
votes
Accepted
How does SQL*Plus connect to Oracle without a listener?
As @BalazsPapp mentioned, the oracle db can be connected locally even without a listener. In this case, the BEQ (Bequeath) protocol is used, instead of the tcp-based normal oracle communication.
...
- 2,017
2
votes
How is an AAG listener implemented? Where does it run?
The Availability Group Listener (AGL) is part of the AG's Windows Server Failover Cluster (WSFC) Resource. It is a Virtual Network Name with n number of IP addresses. Being in a cluster resource it ...
- 915
2
votes
Accepted
adrci not purge trace files and alert logs
ADRCI deletes the XML files, but not the plain text logs, which is a nuisance.
An easy but dirty solution would be overwriting the file with empty content, e.g:
$ cat /dev/null > listener.log
...
- 39.5k
2
votes
Always On Availability Group, Always redirect user to read only instance
Ste, what you are wanting is a point and click solution or a setting somewhere. Unfortunately, none of these currently exist in "off the shelf" form. It would be realllly nice if Microsoft included ...
- 1,485
2
votes
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor on linux
Since you have the following error message that mean either hostname is not correct and/or the domain you are using.
How to know if everything is working fine or not?
You need to execute hostname ...
- 2,670
2
votes
Oracle database not responding
I had a similar issue with an off the shelf three tier application where the app server would make a connection to the database when the user logged on. The user activity was typically to log on in ...
- 4,219
Only top scored, non community-wiki answers of a minimum length are eligible