I am using Toad 16. Now it is taking long time to load . it is about 40second on initializing version engine.
Also this is my debug file content after enable it
[INFO] [2024-03-04 16:20:51:697] - Initializing application
[INFO] [2024-03-04 16:20:51:791] - Creating GlobalDataModule
[INFO] [2024-03-04 16:20:51:900] - Performing Toad's startup tasks
[INFO] [2024-03-04 16:20:51:900] - Setting FPU exception mask
[INFO] [2024-03-04 16:20:51:900] - Setting Application properties
[INFO] [2024-03-04 16:20:51:900] - Desensitizing drag & drop
[INFO] [2024-03-04 16:20:51:900] - Creating GUISettings folder
[INFO] [2024-03-04 16:20:51:900] - Setting Toad help file
[INFO] [2024-03-04 16:20:51:900] - Checking installer induced policy restriction "Restrict Passwords"
[INFO] [2024-03-04 16:20:51:916] - Checking runtime intelligence opt-in
[INFO] [2024-03-04 16:20:51:916] - Opted out of runtime intelligence reporting
[INFO] [2024-03-04 16:20:51:916] - Checking installer induced policy restriction "Restrict Internet"
[INFO] [2024-03-04 16:20:51:916] - Internet access is disabled
[INFO] [2024-03-04 16:20:51:916] - Checking for critical files
[INFO] [2024-03-04 16:20:52:087] - Getting license information
[INFO] [2024-03-04 16:20:52:087] - Verifying Toad license
[INFO] [2024-03-04 16:20:52:087] - Checking existing QuestKey licenses
[INFO] [2024-03-04 16:20:53:088] - Found permanent license
[INFO] [2024-03-04 16:20:53:088] - Saving edition to SettingsLocations.INI file
[INFO] [2024-03-04 16:20:53:088] - License status: Perpetual
[INFO] [2024-03-04 16:20:53:088] - Checking entitlement period
[INFO] [2024-03-04 16:20:53:088] - Setting global options
[INFO] [2024-03-04 16:20:53:088] - ToadActions.dat: Loading
[INFO] [2024-03-04 16:20:53:104] - ToadActions.dat: Ensure Unique IDs
[INFO] [2024-03-04 16:20:53:104] - ToadActions.dat: Assign Action Set Pointers
[INFO] [2024-03-04 16:20:53:104] - ToadActions.dat: Create Scheduled Script Action Set
[INFO] [2024-03-04 16:20:53:104] - ToadActions.dat: Clear Directory C:\Users\Administrator\AppData\Roaming\Quest Software\Toad for Oracle\16.1\User Files\AppBackups
[INFO] [2024-03-04 16:20:53:104] - ToadActions.dat: Remove duplicate categories
[INFO] [2024-03-04 16:20:53:104] - ToadActions.dat: Rebalance
[INFO] [2024-03-04 16:20:53:104] - ToadActions.dat: Finished
[INFO] [2024-03-04 16:20:53:104] - Checking installer induced enablements
[INFO] [2024-03-04 16:20:53:104] - Initializing Version Engine
[INFO] [2024-03-04 16:20:53:104] - Certified Version Engine - Initializing
[INFO] [2024-03-04 16:20:53:104] - Certified Version Engine - Session ID: TOAD-B47296CF-980F-442E-A1C7-0CDC2C730779
[INFO] [2024-03-04 16:21:23:871] - Certified Version Engine - Engine Health - [Status] OK
[INFO] [2024-03-04 16:21:23:871] - Certified Version Engine - Checking Operating System
[INFO] [2024-03-04 16:21:40:265] - Certified Version Engine - Operating System Checked - [Result] EngineError [Action] Allow [LicenseModel] QuestKey [LicenseType] PerpetualOnMaintenance* [LicenseIsTrial] False [Message] No valid policy found.
[INFO] [2024-03-04 16:21:40:265] - Starting settings auto-save thread
[INFO] [2024-03-04 16:21:40:265] - Creating main window
[INFO] [2024-03-04 16:21:40:500] - Main window created
[INFO] [2024-03-04 16:21:40:500] - Loading logins
[INFO] [2024-03-04 16:21:40:500] - Create Bitmaps Form
[INFO] [2024-03-04 16:21:40:860] - Restoring dock layout
[INFO] [2024-03-04 16:21:40:860] - Load Schema/DB Snapshot file list
[INFO] [2024-03-04 16:21:40:860] - Register self as a drop target for files
[INFO] [2024-03-04 16:21:40:860] - Restore main form size/position
[INFO] [2024-03-04 16:21:40:876] - Checking for Spotlight
[INFO] [2024-03-04 16:21:40:876] - Checking for SQL Impact
[INFO] [2024-03-04 16:21:40:876] - Initializing Team Coding
[INFO] [2024-03-04 16:21:40:922] - Building quick scripts menu
[INFO] [2024-03-04 16:21:40:922] - Building external tools menu
[INFO] [2024-03-04 16:21:40:922] - Enabling features based on license
[INFO] [2024-03-04 16:21:41:612] - Performing Toad's command line tasks
[INFO] [2024-03-04 16:21:41:627] - Application.Run
[INFO] [2024-03-04 16:21:46:554] - Saving Toolbar Layout
[INFO] [2024-03-04 16:21:46:711] - Destroying Dock Panels
[INFO] [2024-03-04 16:21:46:711] - Closing Forms
[INFO] [2024-03-04 16:21:46:711] - Saving LRU List
[INFO] [2024-03-04 16:21:46:711] - Saving Dock Layout
[INFO] [2024-03-04 16:21:46:711] - Stop activity manager
[INFO] [2024-03-04 16:21:46:914] - Freeing Process History
[INFO] [2024-03-04 16:21:46:914] - Hiding Mainform
[INFO] [2024-03-04 16:21:46:914] - Freeing MDI Forms
[INFO] [2024-03-04 16:21:46:914] - Freeing Docking Manager
[INFO] [2024-03-04 16:21:46:945] - End DebugLog
Are you in a restricted environment where internet access is limited? Toad 16 checks the digital signature of these files at startup. They are within your Toad installation directory.
- CertifiedVersionPolicy.cab
- CertifiedVersionEngine\CertifiedVersionEngine.exe
If you rt-click on those files and view their signatures are they shown as trusted/OK on your machine? If not, you can install the certificate used to sign the files so that it is trusted from the Digital Signature tab in the file properties dialog. Select the signature, click Details, click View Certificate, and then Install.
In some environments where trusted certificates are managed by the company or where internet access is limited so that trusted certificates are not downloaded or online Certificate Revocation Lists cannot be read the validation takes a long time.
If you can install Toad 16.3 or 17.0 those versions eliminate the signature validation and startup times should be improved.
1 Like
We installed both cert although another show same debug
[INFO] [2024-03-04 18:01:51:371] - Initializing application
[INFO] [2024-03-04 18:01:51:481] - Creating GlobalDataModule
[INFO] [2024-03-04 18:01:51:528] - Performing Toad's startup tasks
[INFO] [2024-03-04 18:01:51:528] - Setting FPU exception mask
[INFO] [2024-03-04 18:01:51:528] - Setting Application properties
[INFO] [2024-03-04 18:01:51:528] - Desensitizing drag & drop
[INFO] [2024-03-04 18:01:51:528] - Creating GUISettings folder
[INFO] [2024-03-04 18:01:51:528] - Setting Toad help file
[INFO] [2024-03-04 18:01:51:528] - Checking installer induced policy restriction "Restrict Passwords"
[INFO] [2024-03-04 18:01:51:528] - Checking runtime intelligence opt-in
[INFO] [2024-03-04 18:01:51:528] - Opted out of runtime intelligence reporting
[INFO] [2024-03-04 18:01:51:528] - Checking installer induced policy restriction "Restrict Internet"
[INFO] [2024-03-04 18:01:51:528] - Internet access is disabled
[INFO] [2024-03-04 18:01:51:528] - Checking for critical files
[INFO] [2024-03-04 18:01:51:700] - Getting license information
[INFO] [2024-03-04 18:01:51:700] - Verifying Toad license
[INFO] [2024-03-04 18:01:51:700] - Checking existing QuestKey licenses
[INFO] [2024-03-04 18:01:52:608] - Found permanent license
[INFO] [2024-03-04 18:01:52:608] - Saving edition to SettingsLocations.INI file
[INFO] [2024-03-04 18:01:52:608] - License status: Perpetual
[INFO] [2024-03-04 18:01:52:608] - Checking entitlement period
[INFO] [2024-03-04 18:01:52:608] - Setting global options
[INFO] [2024-03-04 18:01:52:608] - ToadActions.dat: Loading
[INFO] [2024-03-04 18:01:52:623] - ToadActions.dat: Ensure Unique IDs
[INFO] [2024-03-04 18:01:52:623] - ToadActions.dat: Assign Action Set Pointers
[INFO] [2024-03-04 18:01:52:623] - ToadActions.dat: Create Scheduled Script Action Set
[INFO] [2024-03-04 18:01:52:623] - ToadActions.dat: Clear Directory C:\Users\Administrator\AppData\Roaming\Quest Software\Toad for Oracle\16.1\User Files\AppBackups
[INFO] [2024-03-04 18:01:52:639] - ToadActions.dat: Remove duplicate categories
[INFO] [2024-03-04 18:01:52:639] - ToadActions.dat: Rebalance
[INFO] [2024-03-04 18:01:52:639] - ToadActions.dat: Finished
[INFO] [2024-03-04 18:01:52:639] - Checking installer induced enablements
[INFO] [2024-03-04 18:01:52:639] - Initializing Version Engine
[INFO] [2024-03-04 18:01:52:639] - Certified Version Engine - Initializing
[INFO] [2024-03-04 18:01:52:639] - Certified Version Engine - Session ID: TOAD-E98836E5-17ED-49C9-980E-EEECBABF5D12
[INFO] [2024-03-04 18:02:23:499] - Certified Version Engine - Engine Health - [Status] OK
[INFO] [2024-03-04 18:02:23:499] - Certified Version Engine - Checking Operating System
[INFO] [2024-03-04 18:02:39:910] - Certified Version Engine - Operating System Checked - [Result] EngineError [Action] Allow [LicenseModel] QuestKey [LicenseType] PerpetualOnMaintenance* [LicenseIsTrial] False [Message] No valid policy found.
[INFO] [2024-03-04 18:02:39:910] - Starting settings auto-save thread
[INFO] [2024-03-04 18:02:39:910] - Creating main window
[INFO] [2024-03-04 18:02:40:144] - Main window created
[INFO] [2024-03-04 18:02:40:160] - Loading logins
[INFO] [2024-03-04 18:02:40:160] - Create Bitmaps Form
[INFO] [2024-03-04 18:02:40:552] - Restoring dock layout
[INFO] [2024-03-04 18:02:40:552] - Load Schema/DB Snapshot file list
[INFO] [2024-03-04 18:02:40:552] - Register self as a drop target for files
[INFO] [2024-03-04 18:02:40:552] - Restore main form size/position
[INFO] [2024-03-04 18:02:40:567] - Checking for Spotlight
[INFO] [2024-03-04 18:02:40:567] - Checking for SQL Impact
[INFO] [2024-03-04 18:02:40:567] - Initializing Team Coding
[INFO] [2024-03-04 18:02:40:598] - Building quick scripts menu
[INFO] [2024-03-04 18:02:40:598] - Building external tools menu
[INFO] [2024-03-04 18:02:40:598] - Enabling features based on license
[INFO] [2024-03-04 18:02:41:287] - Performing Toad's command line tasks
[INFO] [2024-03-04 18:02:41:287] - Application.Run
[INFO] [2024-03-04 18:02:48:813] - Saving Toolbar Layout
[INFO] [2024-03-04 18:02:48:969] - Destroying Dock Panels
[INFO] [2024-03-04 18:02:48:969] - Closing Forms
[INFO] [2024-03-04 18:02:48:969] - Saving LRU List
[INFO] [2024-03-04 18:02:48:969] - Saving Dock Layout
[INFO] [2024-03-04 18:02:48:969] - Stop activity manager
[INFO] [2024-03-04 18:02:49:188] - Freeing Process History
[INFO] [2024-03-04 18:02:49:188] - Hiding Mainform
[INFO] [2024-03-04 18:02:49:188] - Freeing MDI Forms
[INFO] [2024-03-04 18:02:49:188] - Freeing Docking Manager
[INFO] [2024-03-04 18:02:49:204] - End DebugLog
Is your internet access restricted in any way? Can you access *.quest.com domains? Specifically this one is of interest certifiedversions.ism.quest.com.
You can test access by going to this URL in your browser https://certifiedversions.ism.quest.com/api/status/ping and verify you receive an HTTP 200 response. Your browser's developer tools can be of assistance here, e.g. if using Chrome hit F12 and select the Network tab. Go to the URL and check the code shown in the Status column.
1 Like
It does not have internet access . Although we set InternetAccess=0 in Toad.ini file in follow path
"C:\Users\Administrator\AppData\Roaming\Quest Software\Toad for Oracle\16.1\User Files"
How can we fix it ? How can prevent it to check by internet ?
Part of digital signature validation is checking Certificate Revocation Lists (CRL). In many environments this is snappy, but we have seen some cases similar to yours where even this process is impossible. For Toad for Oracle 16.3 we changed the validation procedure to not rely on the digital signature check. If you can download the Toad for Oracle 17.0 trial, try that and see if your problems are resolved. I am unaware of any solutions for Toad 16.0 in restricted environments.
You can download the trial from here. The text at the top of the page mentions Toad for Oracle Subscription, but that will not work for you in your environment. Scroll down a little and you'll see two download options; one for DBA Edition and the other for Developer Edition. Choose one of those, complete the form, and a link to download will be emailed to you. These versions are the "offline" version similar to what you're currently using.
Thanks. But my current version is Toad for oracle 16.1 , So I think have to install Toad for oracle 16.3.
Please provide download link
You can download 16.3 from here if you are on a maintenance contract allowing for upgrades. Note that version 17.0 is the latest. The page defaults to the latest, but you can select 16.3. If you are able to upgrade all the way to 17.0 I'd suggest doing that. If you are unable to download the full version you can try the trial using the instructions in my prior email.
1 Like
17.0 is the latest release. 17.1 is in beta.
1 Like