# Why does TOAD 12.10.0.30 take so long to report ORA-01017 invalid username/password?

**URL:** <https://forums.toadworld.com/t/why-does-toad-12-10-0-30-take-so-long-to-report-ora-01017-invalid-username-password/41070>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [June 18, 2018, 9:06am UTC](https://forums.toadworld.com/t/why-does-toad-12-10-0-30-take-so-long-to-report-ora-01017-invalid-username-password/41070 "2018-06-18T09:06:46Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![mrpilotron](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/mrpilotron/32/10229_2.png) [@mrpilotron](https://forums.toadworld.com/u/mrpilotron)\
**Post date:** [June 18, 2018, 9:06am UTC](https://forums.toadworld.com/t/why-does-toad-12-10-0-30-take-so-long-to-report-ora-01017-invalid-username-password/41070/1 "2018-06-18T09:06:46Z")

</div>

When I enter the correct username/password, my connection goes through and I am doing work within 5 seconds. When I enter an invalid password, the screen hangs for what seems to be ages before displaying the error message. Actual clock time is around 45 seconds. When I spool the output, TOAD knows that the password was wrong in about .047 seconds so it seems like a horribly long time to wait for another chance to enter the correct password. Doing the same good/bad password test in SQL\*Plus returns instantly in both cases.

Here is the spool output with appropriate privacy edits applied:

* * *

– Timestamp: 10:55:45.005  
Connect: [SYSTEM@mydb.mydomain.COM](mailto:SYSTEM@mydb.mydomain.COM)

* * *

– Session: [SYSTEM@mydb.mydomain.COM](mailto:SYSTEM@mydb.mydomain.COM)  
– Timestamp: 10:55:45.052  
Error: ORA-01017: invalid username/password; logon denied

* * *

– Timestamp: 10:56:43.840  
Connect: [SYSTEM@mydb.mydomain.COM](mailto:SYSTEM@mydb.mydomain.COM)

* * *

– Session: [SYSTEM@mydb.mydomain.COM](mailto:SYSTEM@mydb.mydomain.COM)  
– Timestamp: 10:56:43.902  
SELECT version, product, sysdate FROM sys.PRODUCT\_COMPONENT\_VERSION WHERE UPPER(PRODUCT) LIKE ‘%ORACLE%’;

---

<div class="post-metadata">

**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:** [June 18, 2018, 9:26am UTC](https://forums.toadworld.com/t/why-does-toad-12-10-0-30-take-so-long-to-report-ora-01017-invalid-username-password/41070/2 "2018-06-18T09:26:42Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![mrpilotron](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/mrpilotron/32/10229_2.png) [@mrpilotron](https://forums.toadworld.com/u/mrpilotron)\
**Post date:** [June 18, 2018, 9:47am UTC](https://forums.toadworld.com/t/why-does-toad-12-10-0-30-take-so-long-to-report-ora-01017-invalid-username-password/41070/3 "2018-06-18T09:47:31Z")

</div>

Thanks for the reply John. I can see the connect attempt and the error message in the spool window for the whole 45 seconds that I am waiting for the error message to pop up so the messages are being spooled out immediately. Several of my coworkers have reported the same problem since we upgraded to new Windows 10 machines with this newer version of TOAD loaded. Our old Windows 7 machines would display the error message in under 1 second.

I only have Oracle Client 11.2.0.4 loaded on my PC. The old PC used 11.2.0.2 and a previous version of TOAD that I don’t remember. It was probably a 10.x.

---

<div class="post-metadata">

**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:** [June 18, 2018, 10:17am UTC](https://forums.toadworld.com/t/why-does-toad-12-10-0-30-take-so-long-to-report-ora-01017-invalid-username-password/41070/4 "2018-06-18T10:17:59Z")

</div>

I just tried it on windows 10 and for me, it comes back immediately. I tried with Toad 13.0 and 12.10, (both 64 bit) using an 18c client, connecting to a remote 12.2 database.

Can you try the newest Oracle client and see if that solves it? I can try 11.2, but I’ll take me a little while to set that up, as I don’t want to change the W10 testbed that I have now.

---

<div class="post-metadata">

**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:** [June 18, 2018, 12:26pm UTC](https://forums.toadworld.com/t/why-does-toad-12-10-0-30-take-so-long-to-report-ora-01017-invalid-username-password/41070/5 "2018-06-18T12:26:24Z")

</div>

I just re-read your message and noticed that you said you get the connection error in the spool sql, but then another 45 seconds to get the dialog. So you’re right, it does not seem to be related to Oracle.

For what it’s worth, I tried it with Windows 10 and Oracle 11.2 client and I got the error dialog quickly.

I don’t see any need for you to try an 18c client, but I’d be interested in knowing if this happens with the Toad 13.0 trial.

Also, can you post (or email to me) the contents of help -\> support bundle? you can send to [john.dorlon@quest.com](mailto:john.dorlon@quest.com)

---

<div class="post-metadata">

**Author:** ![dbarocco](https://avatars.discourse-cdn.com/v4/letter/d/9d8465/32.png) [@dbarocco](https://forums.toadworld.com/u/dbarocco)\
**Post date:** [October 10, 2018, 2:36pm UTC](https://forums.toadworld.com/t/why-does-toad-12-10-0-30-take-so-long-to-report-ora-01017-invalid-username-password/41070/6 "2018-10-10T14:36:45Z")

</div>

What is your solution about the topic?

---

<div class="post-metadata">

**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:** [October 10, 2018, 2:37pm UTC](https://forums.toadworld.com/t/why-does-toad-12-10-0-30-take-so-long-to-report-ora-01017-invalid-username-password/41070/7 "2018-10-10T14:37:55Z")

</div>

I don’t have a solution because I can’t reproduce it.

---

<div class="post-metadata">

**Author:** ![dbarocco](https://avatars.discourse-cdn.com/v4/letter/d/9d8465/32.png) [@dbarocco](https://forums.toadworld.com/u/dbarocco)\
**Post date:** [October 10, 2018, 2:41pm UTC](https://forums.toadworld.com/t/why-does-toad-12-10-0-30-take-so-long-to-report-ora-01017-invalid-username-password/41070/8 "2018-10-10T14:41:21Z")

</div>

> [@JohnDorlon](#):
>
> I don’t have a solution because I can’t reproduce it.

Can you share the contents of your sqlnet.ora file with us?

---

<div class="post-metadata">

**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:** [October 10, 2018, 2:42pm UTC](https://forums.toadworld.com/t/why-does-toad-12-10-0-30-take-so-long-to-report-ora-01017-invalid-username-password/41070/9 "2018-10-10T14:42:50Z")

</div>

It’s not very exciting but here it is:

```
SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
```

---

<div class="post-metadata">

**Author:** ![dbarocco](https://avatars.discourse-cdn.com/v4/letter/d/9d8465/32.png) [@dbarocco](https://forums.toadworld.com/u/dbarocco)\
**Post date:** [October 10, 2018, 2:46pm UTC](https://forums.toadworld.com/t/why-does-toad-12-10-0-30-take-so-long-to-report-ora-01017-invalid-username-password/41070/10 "2018-10-10T14:46:33Z")

</div>

Thank you for your interest.  
We’ ve already came accross with tihs issue. However we couldn’t resolved yet.

---

<div class="post-metadata">

**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:** [October 10, 2018, 2:56pm UTC](https://forums.toadworld.com/t/why-does-toad-12-10-0-30-take-so-long-to-report-ora-01017-invalid-username-password/41070/11 "2018-10-10T14:56:44Z")

</div>

If you discover anything, please let us know.

---

<div class="post-metadata">

**Author:** ![dbarocco](https://avatars.discourse-cdn.com/v4/letter/d/9d8465/32.png) [@dbarocco](https://forums.toadworld.com/u/dbarocco)\
**Post date:** [October 10, 2018, 3:01pm UTC](https://forums.toadworld.com/t/why-does-toad-12-10-0-30-take-so-long-to-report-ora-01017-invalid-username-password/41070/12 "2018-10-10T15:01:51Z")

</div>

Allright. If I find something different, I will inform you,

---

<div class="post-metadata">

**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:** [October 10, 2018, 3:06pm UTC](https://forums.toadworld.com/t/why-does-toad-12-10-0-30-take-so-long-to-report-ora-01017-invalid-username-password/41070/13 "2018-10-10T15:06:43Z")

</div>

Here are some things that I wonder about it

1. Does it happen on any database?
2. Does it happen if you try a different Oracle client?
3. do your coworkers experience it too? If not, can you find something different about their configuration?

---

<div class="post-metadata">

**Author:** ![mrpilotron](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/mrpilotron/32/10229_2.png) [@mrpilotron](https://forums.toadworld.com/u/mrpilotron)\
**Post date:** [October 10, 2018, 3:19pm UTC](https://forums.toadworld.com/t/why-does-toad-12-10-0-30-take-so-long-to-report-ora-01017-invalid-username-password/41070/14 "2018-10-10T15:19:39Z")

</div>

For me, this happens on any database. We have “lots” of Oracle instances (exact number is company private info, not to be publicly shared). I would be surprised if this is related to the Oracle Client since the error message shows up in the spool window immediately. All of my coworkers experience the same problem and it started for each of them as they got the new version. Unfortunately, I cannot test exclusively if this is related to Win7 vs Win10 because all of our old Win7 boxes had Toad 10.x and all of our new Win10 boxes have the newer Toad 12.x.

I wonder if it is possibly related to our tnsnames.ora file being exceptionally long to handle all of our instance names?

---

<div class="post-metadata">

**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:** [October 10, 2018, 3:24pm UTC](https://forums.toadworld.com/t/why-does-toad-12-10-0-30-take-so-long-to-report-ora-01017-invalid-username-password/41070/15 "2018-10-10T15:24:26Z")

</div>

I’ve put 1000’s of entries in my tnsnames.ora but it didn’t seem to matter.

I’ve looked at our code. There really is very little that happens between receiving the error and displaying the message. WHen you say “spool window” are you talking about spool sql or the separate SQL Tracker app? If SQL Tracker, do you see same timings in Spool SQL? SQL Tracker kind of sits between Toad and Oracle client. Spool SQL is in the same process as Toad.exe.

I don’t think this problem is exclusive to W10…I’ve heard of this problem off and on over the years, before W10 existed.

---

<div class="post-metadata">

**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:** [October 10, 2018, 3:25pm UTC](https://forums.toadworld.com/t/why-does-toad-12-10-0-30-take-so-long-to-report-ora-01017-invalid-username-password/41070/16 "2018-10-10T15:25:40Z")

</div>

I don’t think tnsnames.ora is related, but as a test, you could rename that file, then make a direct connection.

---

<div class="post-metadata">

**Author:** ![mrpilotron](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/mrpilotron/32/10229_2.png) [@mrpilotron](https://forums.toadworld.com/u/mrpilotron)\
**Post date:** [October 10, 2018, 3:39pm UTC](https://forums.toadworld.com/t/why-does-toad-12-10-0-30-take-so-long-to-report-ora-01017-invalid-username-password/41070/17 "2018-10-10T15:39:16Z")

</div>

I am using the built in TOAD Spool SQL window.

---

<div class="post-metadata">

**Author:** ![mrpilotron](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/mrpilotron/32/10229_2.png) [@mrpilotron](https://forums.toadworld.com/u/mrpilotron)\
**Post date:** [October 10, 2018, 7:01pm UTC](https://forums.toadworld.com/t/why-does-toad-12-10-0-30-take-so-long-to-report-ora-01017-invalid-username-password/41070/18 "2018-10-10T19:01:12Z")

</div>

Could this be caused by the fact that our machines are locked down tight by the admins to where we don’t have write permissions on most of the subdirectories where log files may be written? I just confirmed that I cannot create or modify files in the \network\logs or \network\trace directories. Similarly, I cannot edit anything in the …Toad for Oracle 12.10\ClientFiles\* subdirectories. Also, my sqlnet.ora and tnsnames.ora files are on a read-only network mount.

---

<div class="post-metadata">

**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:** [October 10, 2018, 7:12pm UTC](https://forums.toadworld.com/t/why-does-toad-12-10-0-30-take-so-long-to-report-ora-01017-invalid-username-password/41070/19 "2018-10-10T19:12:36Z")

</div>

Maybe? I can try to lock things down here a bit and see what happens.

Toad only uses the (install folder)\ClientFiles folders when it needs to make a new folder for user files in C:\Users(user name)\AppData\Roaming\Quest Software\Toad for Oracle(version number), so I don’t think that would come into play here.

---

<div class="post-metadata">

**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:** [October 10, 2018, 7:18pm UTC](https://forums.toadworld.com/t/why-does-toad-12-10-0-30-take-so-long-to-report-ora-01017-invalid-username-password/41070/20 "2018-10-10T19:18:01Z")

</div>

Do you have anything set in your sqlnet.ora that might result in any client side logging?

[Next page](https://forums.toadworld.com/t/why-does-toad-12-10-0-30-take-so-long-to-report-ora-01017-invalid-username-password/41070.md?page=2)
