# Toad connection time when instance is down **URL:** \ **Category:** Toad for Oracle & DevOps Toolkit\ **Created:** [May 20, 2019, 7:01am UTC](https://forums.toadworld.com/t/toad-connection-time-when-instance-is-down/46556 "2019-05-20T07:01:20Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![raul.kaubi](https://avatars.discourse-cdn.com/v4/letter/r/d26b3c/32.png) [@raul.kaubi](https://forums.toadworld.com/u/raul.kaubi)\ **Post date:** [May 20, 2019, 7:01am UTC](https://forums.toadworld.com/t/toad-connection-time-when-instance-is-down/46556/1 "2019-05-20T07:01:20Z")
Hi Toad 13.1 I have noticed when instance is down and trying to connect there (direct connection), then it would take nearly a minute to output the following error > ORA-12514: TNS:listener does not currently know of service requested in connect descriptor At the mean time, when I test the connection, then it takes about ~2 seconds to output the same error. Why is that..? Regards Raul ---
**Author:** ![NormTeamT](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/normteamt/32/53_2.png) [@NormTeamT](https://forums.toadworld.com/u/NormTeamT)\ **Post date:** [May 20, 2019, 9:50am UTC](https://forums.toadworld.com/t/toad-connection-time-when-instance-is-down/46556/2 "2019-05-20T09:50:53Z")
I'm currently on Toad 13.0, but when I connect to a database where the _server_ itself is down, `Toad`, `tnsping` and `SQL*Plus` all take the same couple of seconds to report back that there is no listener. (`ORA-12541: TNS:no listener`) When the listener is up and running, but the database itself is down, then `Toad`, `tnsping` and `SQL*Plus` all take the same couple of seconds to report the `ORA-12514: TNS:listener does not currently know of service requested in connect` error. I'm using Oracle "fat" client and not LDAP, EZConnect, or Direct etc - I have a full install of Oracle XE 18c for Windows on my desktop, and I use that client for _everything_ I connect to oracle-wise. All my connections are configured in Toad to use the tnsnames naming methods to connect. My `tnsnames.ora` file lives within the XE 18c installation, and I have a `TNS_ADMIN` environment variable defined that points to it. In summary then, I can't reproduce your problem on my setup here, sorry. ☹ Cheers, Norm. [TeamT] ---
**Author:** ![raul.kaubi](https://avatars.discourse-cdn.com/v4/letter/r/d26b3c/32.png) [@raul.kaubi](https://forums.toadworld.com/u/raul.kaubi)\ **Post date:** [May 20, 2019, 10:06am UTC](https://forums.toadworld.com/t/toad-connection-time-when-instance-is-down/46556/3 "2019-05-20T10:06:03Z")
Yes, I am describing the case, where specific database instance is down. Server itself is up and running. I also tried tnsnames.ora Set this as follows: > ORCL = > (DESCRIPTION = > (ADDRESS = (PROTOCOL = TCP)(HOST = [oradb.domain.com](http://oradb.domain.com))(PORT = 1521)) > (CONNECT\_DATA = > (SERVER = DEDICATED) > (SERVICE\_NAME = orcl) > ) > ) Then tried connecting, and the behaviour is the same, it took nearly a minute. While just testing the connection, it took me ~2 seconds. FYI: Toad is installed in terminal server, where there is no access to public internet (access is only to company intranet). By the way, this topic is quite similar to my problem, since this same thing happens when database instance is up and running, but I have put wrong username/password: > [@Why does TOAD 12.10.0.30 take so long to report ORA-01017 invalid username/password?](https://forums.toadworld.com/t/why-does-toad-12-10-0-30-take-so-long-to-report-ora-01017-invalid-username-password/41070/2): > > We don’t add any delay. If there is an error, we post it immediately. My guess in your situation is that the “Connect” command isn’t spooled until it is kicked back from Oracle with the error. Are SQL\*Plus and Toad using the same Oracle client? Regards Raul ---
**Author:** ![NormTeamT](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/normteamt/32/53_2.png) [@NormTeamT](https://forums.toadworld.com/u/NormTeamT)\ **Post date:** [May 20, 2019, 10:12am UTC](https://forums.toadworld.com/t/toad-connection-time-when-instance-is-down/46556/4 "2019-05-20T10:12:42Z")
Hi Raul, Is this repeatable? Does it happen every time the instance is down? As I cannot reproduce it here, it _might_ be the terminal server that's causing it. When you test, what do you use? `Tnsping`? `SQL*Plus`? Are they in the terminal server environment or running locally from your desktop/laptop? (Are we comparing apples with apples!) Cheers, Norm. [TeamT] ---
**Author:** ![raul.kaubi](https://avatars.discourse-cdn.com/v4/letter/r/d26b3c/32.png) [@raul.kaubi](https://forums.toadworld.com/u/raul.kaubi)\ **Post date:** [May 20, 2019, 10:22am UTC](https://forums.toadworld.com/t/toad-connection-time-when-instance-is-down/46556/5 "2019-05-20T10:22:56Z")
I encourage you to look my last post also, as I edited it a few minutes back. So problem is the same, when I use wrong username/password to connect to database instance, which is up and running. **I bet this other topic has the same issue, since in my case, it is about right, it takes me 40-45 seconds to report the error also.** And yes, it is repeatable always. I do not use tnsping nor the sqlplus to test the connections. When I test, I use Toad functionality also (**Session -\> New Connection -\> (select connection) --\> Test Connections**). ![image](https://global.discourse-cdn.com/quest/original/2X/7/77d77dff00f70af4dced104e856ce83da26ab163.png) We have many terminal servers, each of these have the same behaviour (windows server 2008 - windows server 2016). ---
**Author:** ![raul.kaubi](https://avatars.discourse-cdn.com/v4/letter/r/d26b3c/32.png) [@raul.kaubi](https://forums.toadworld.com/u/raul.kaubi)\ **Post date:** [May 20, 2019, 10:52am UTC](https://forums.toadworld.com/t/toad-connection-time-when-instance-is-down/46556/6 "2019-05-20T10:52:14Z")
I just let some of our developers test it. They have Toad installed in their localhost, which has access to public internet. And he got error in 2 seconds. Bear in mind, when this ORA-12514 or ORA-01017 is produced, it will produce the following pop-up: ![image](https://global.discourse-cdn.com/quest/original/2X/b/b352af0be11ed3189b7a8da9efd378ad321ccf84.png) Could it be possible, that it is already trying to resolve the following internet addresses **(knowledge base, forum)** in the background..? Raul ---
**Author:** ![NormTeamT](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/normteamt/32/53_2.png) [@NormTeamT](https://forums.toadworld.com/u/NormTeamT)\ **Post date:** [May 20, 2019, 11:11am UTC](https://forums.toadworld.com/t/toad-connection-time-when-instance-is-down/46556/7 "2019-05-20T11:11:27Z")
Hi Raul, thanks for the explanation regarding how you test. I wasn't certain how you were testing. I've connected to a database here and then shut it down (I have the power!) and then, on session-\>test Connection, I get the following window in about a second: ![image](https://global.discourse-cdn.com/quest/original/2X/f/f88edf41ab826c4540f19c1edba3ca196374085b.png) I do not get any attempted connections to the internet to check the KB or the Forums unless, I click the button shown. However, it sounds, from your latest posting, that your colleagues with direct access to Toad don't have the same problem that you are suffering from - so they appear to be seeing what I see - a quick response. his would tend to pint the finger at the Terminal Server as the potential culprit. I checked the various Toad Options and there doesn't appear to be one that determines whether to automatically search the internet for error details or KB advice. It appears from John's updates on your other problem, that you are suffering from a bug in 10g when the user's account has expired and you cannot connect to change the password. ☹ Cheers, Norm. [TeamT] ---
**Author:** ![raul.kaubi](https://avatars.discourse-cdn.com/v4/letter/r/d26b3c/32.png) [@raul.kaubi](https://forums.toadworld.com/u/raul.kaubi)\ **Post date:** [May 20, 2019, 11:29am UTC](https://forums.toadworld.com/t/toad-connection-time-when-instance-is-down/46556/8 "2019-05-20T11:29:10Z")
HI > It appears from John's updates on your other problem, that you are suffering from a bug in 10g when the user's account has expired and you cannot connect to change the password. ☹ No, this is no way connected to that topic. Username is not expired, and I tried the same with 10g, 11g, and 12c databases, and behavior is the same, it takes ~40-45 seconds to report error: - When connecting with wrong username/password - Or when connecting to database instance, that is not up and running (server itself is up and running) I don't think that problem is terminal servers. My bet is, Toad is trying to connect to somewhere in background. In firewall log, I get policy violation to this IP address (152.195.132.183 HTTP), when connecting with wrong username/password or instance that is down. And when I click to these links from that pop-up, each time it is trying to resolve the same IP address. ![image](https://global.discourse-cdn.com/quest/original/2X/1/1e3924eaafa0ad9ef43e634a31e25f13e0addd66.png) Raul ---
**Author:** ![NormTeamT](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/normteamt/32/53_2.png) [@NormTeamT](https://forums.toadworld.com/u/NormTeamT)\ **Post date:** [May 20, 2019, 11:45am UTC](https://forums.toadworld.com/t/toad-connection-time-when-instance-is-down/46556/9 "2019-05-20T11:45:12Z")
Hi Raul, > [@raul.kaubi](#): > > No, this is no way connected to that topic. Username is not expired... Sorry, what I meant was, your other problem was cause, it appears, by a 10g bug. Not that this problem was caused by the same bug. Apologies for my English - I'm Scottish! 😃 > [@raul.kaubi](#): > > In firewall log, I get policy violation to this IP address (152.195.132.183 HTTP), when connecting with wrong username/password or instance that is down. That's an interesting IP address, this link - [152.195.132.245 IP Address Detail - IP Address Location Lookup - Abuse IP Report](http://ipaddress.is/152.195.132.245) - puts it right in the middle of the Cheney Reservoir in the Cheney National Park! When my "test connection" fails, I click the link and it takes me to [support.quest.com](http://support.quest.com) which is a completely different (set of) IP address (es) - 13.35.198 followed by one of .83 or .87 or .114 or .127, and nothing like the one you are seeing. Do you have a proxy server between you and the database or outside world? Can you ping that IP address (I suspect not, I certainly cannot from here, but our internet is heavily proxy'd and there are many addresses we have no access to etc.) Cheers, Norm. [TeamT] ---
**Author:** ![raul.kaubi](https://avatars.discourse-cdn.com/v4/letter/r/d26b3c/32.png) [@raul.kaubi](https://forums.toadworld.com/u/raul.kaubi)\ **Post date:** [May 20, 2019, 12:09pm UTC](https://forums.toadworld.com/t/toad-connection-time-when-instance-is-down/46556/10 "2019-05-20T12:09:16Z")
This still looks to be some quest IP. Search google: "toad 152.195.132.183" I get the following hostname: **[community-downloads.quest.com](http://community-downloads.quest.com)** And this will ping just fine through hostname on my localhost, that has access to public internet. > ping -a [community-downloads.quest.com](http://community-downloads.quest.com) > > Pinging **[sa8gl.wpc.mucdn.net](http://sa8gl.wpc.mucdn.net) [152.195.132.183]** with 32 bytes of data: > Reply from 152.195.132.183: bytes=32 time=7ms TTL=53 > Reply from 152.195.132.183: bytes=32 time=7ms TTL=53 > Reply from 152.195.132.183: bytes=32 time=7ms TTL=53 > Reply from 152.195.132.183: bytes=32 time=7ms TTL=53 > > Ping statistics for 152.195.132.183: > Packets: Sent = 4, Received = 4, Lost = 0 (0% loss), > Approximate round trip times in milli-seconds: > Minimum = 7ms, Maximum = 7ms, Average = 7ms > PS C:\Windows\system32\> > PS C:\Windows\system32\> nslookup [community-downloads.quest.com](http://community-downloads.quest.com) > Server: YYYYYY.domain.... > Address: XXXXXX > > Non-authoritative answer: > Name: [sa8gl.wpc.mucdn.net](http://sa8gl.wpc.mucdn.net) > Address: 152.195.132.183 > Aliases: [community-downloads.quest.com](http://community-downloads.quest.com) > [community-downloads-quest-com.azureedge.net](http://community-downloads-quest-com.azureedge.net) > [community-downloads-quest-com.ec.azureedge.net](http://community-downloads-quest-com.ec.azureedge.net) > [scdn1.wpc.6c216.mucdn.net](http://scdn1.wpc.6c216.mucdn.net) Raul ---
**Author:** ![NormTeamT](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/normteamt/32/53_2.png) [@NormTeamT](https://forums.toadworld.com/u/NormTeamT)\ **Post date:** [May 20, 2019, 12:14pm UTC](https://forums.toadworld.com/t/toad-connection-time-when-instance-is-down/46556/11 "2019-05-20T12:14:56Z")
Hi Raul, > [@raul.kaubi](#): > > This still looks to be some quest IP. > > Search google: "toad 152.195.132.183" > > I get the following hostname: **[community-downloads.quest.com](http://community-downloads.quest.com)** > > And this will ping just fine through hostname on my localhost, that has access to public internet. Interesting. I don't work for Quest, so I'm not able to say why Toad might want to connect to that address when a session test fails. Sorry. ☹ I suspect we need a developer to jump in now. Cheers, Norm. [TeamT] ---
**Author:** ![raul.kaubi](https://avatars.discourse-cdn.com/v4/letter/r/d26b3c/32.png) [@raul.kaubi](https://forums.toadworld.com/u/raul.kaubi)\ **Post date:** [May 20, 2019, 12:16pm UTC](https://forums.toadworld.com/t/toad-connection-time-when-instance-is-down/46556/12 "2019-05-20T12:16:31Z")
> [@NormTeamT](#): > > I suspect we need a developer to jump in now. I agree. Will these developers also read these forum posts, or do we need to make another topic somewhere..? Raul ---
**Author:** ![NormTeamT](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/normteamt/32/53_2.png) [@NormTeamT](https://forums.toadworld.com/u/NormTeamT)\ **Post date:** [May 20, 2019, 12:19pm UTC](https://forums.toadworld.com/t/toad-connection-time-when-instance-is-down/46556/13 "2019-05-20T12:19:08Z")
Hi Raul, no, the developers practically live on these forums, so they will pick this up as soon as they get a moment. There's no need to start a new topic. I'm not sure which time zone they are in, or when their day begins, but they will be here. Cheers, Norm. [TeamT] ---
**Author:** ![raul.kaubi](https://avatars.discourse-cdn.com/v4/letter/r/d26b3c/32.png) [@raul.kaubi](https://forums.toadworld.com/u/raul.kaubi)\ **Post date:** [May 20, 2019, 12:21pm UTC](https://forums.toadworld.com/t/toad-connection-time-when-instance-is-down/46556/14 "2019-05-20T12:21:08Z")
Ok thanks. Let's hope they'll pick it up some time then..🙂 Raul ---
**Author:** ![raul.kaubi](https://avatars.discourse-cdn.com/v4/letter/r/d26b3c/32.png) [@raul.kaubi](https://forums.toadworld.com/u/raul.kaubi)\ **Post date:** [May 20, 2019, 12:50pm UTC](https://forums.toadworld.com/t/toad-connection-time-when-instance-is-down/46556/15 "2019-05-20T12:50:43Z")
Oh, I was blind. This other topic, had solution: > We’ve just solved the problem by copying following .xml file to the following path indicated below. > > XML FILE : [http://community-downloads.quest.com/toadsoft/ORACLE/VERSION/online\_resources.xml](http://community-downloads.quest.com/toadsoft/ORACLE/VERSION/online_resources.xml) > > PATH: C:\Users\AppData\Roaming\Quest Software\Toad for Oracle\13.0\User Files > > After the copy process you have to restart TOAD. > At first wrong password attempt, TOAD waits for a while. Then you’ll get a quick response for the wrong password attempts. ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [May 20, 2019, 12:54pm UTC](https://forums.toadworld.com/t/toad-connection-time-when-instance-is-down/46556/16 "2019-05-20T12:54:03Z")
Toad's connection error dialog has some links to quest resources, but to make sure those links are up to date, we try to download file from one of Quest's servers. If the PC where Toad is installed does not have internet access, you can prevent Toad from looking. If you download that online\_resources.xml file, and put it in your User Files folder, that may help. In Toad 13.2, there is a Toad.ini setting you can make which disables all internet-related activity in Toad. in [SETTINGS]... InternetAccess=0 But as I mentioned, that works in 13.2 and newer, not 13.1. ---
**Author:** ![raul.kaubi](https://avatars.discourse-cdn.com/v4/letter/r/d26b3c/32.png) [@raul.kaubi](https://forums.toadworld.com/u/raul.kaubi)\ **Post date:** [May 20, 2019, 1:02pm UTC](https://forums.toadworld.com/t/toad-connection-time-when-instance-is-down/46556/17 "2019-05-20T13:02:03Z")
Yeah, this **online\_resources.xml** file fixes this. For Toad 13.2, this is not yet released, correct..? (since from [support.quest.com](http://support.quest.com) the latest seems to be 13.1.1) Raul ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [May 20, 2019, 1:06pm UTC](https://forums.toadworld.com/t/toad-connection-time-when-instance-is-down/46556/18 "2019-05-20T13:06:58Z")
13.2 is currently in beta. If you are interested, you can download it here: > [@Toad for Oracle 17.1 Beta](https://forums.toadworld.com/t/toad-for-oracle-13-2-beta/41283): > > We are pleased to announce the Toad for Oracle v17.1 beta We encourage you to participate in the beta program to help us deliver a high quality product. This is your opportunity to participate in the development, direction, and testing of Toad for Oracle. By becoming a beta tester you will have direct access to the development team and product management via the Toad World forum. Instructions for joining the Beta program: Read the [Beta Agreement](https://www.toadworld.com/quest-beta-agreement). Downloading the Toad Beta constitutes usage… The 13.2 beta requires that 13.1 is installed. ---
**Author:** ![raul.kaubi](https://avatars.discourse-cdn.com/v4/letter/r/d26b3c/32.png) [@raul.kaubi](https://forums.toadworld.com/u/raul.kaubi)\ **Post date:** [May 20, 2019, 1:10pm UTC](https://forums.toadworld.com/t/toad-connection-time-when-instance-is-down/46556/19 "2019-05-20T13:10:42Z")
Ok.. Another question though, is it possible to set this somewhere from the settings also, that do not download this file from internet, but take this file from some fileshare location..? I am asking because, we have lots of users using Toad in terminal server, that would mean, that this file needs to be copied to each user folder separately each time when doing Toad upgrade (with new version of Toad, there comes new User files folder)..? Raul ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [May 20, 2019, 1:22pm UTC](https://forums.toadworld.com/t/toad-connection-time-when-instance-is-down/46556/20 "2019-05-20T13:22:40Z")
We don't have a way to get the file from somewhere else, sorry. However, on upgrade, the User Files folder is copied from the the old version to the new version (to preserve your settings) so the online\_resources file should be carried along. If you are installing from MSI file, you can disable internet access with a command line option from the installer. search this page for "internet" (it's at the bottom) [https://support.quest.com/technical-documents/toad-for-oracle/12.12/editions-installation-guide/install-toad-silently-from-the-command-line](https://support.quest.com/technical-documents/toad-for-oracle/12.12/editions-installation-guide/install-toad-silently-from-the-command-line)