-
제목
Toad for Oracle startup issue -
설명
Toad for Oracle will take more than 50 seconds to startup completely after checking critical files, checking feedback and initializing version engine.
-
원인
Starting from Toad for Oracle 14.1 onwards, it has a new file called CertifiedVersionPolicy.cab. This file is the default policy definition for the new Certified Version service. It defines which operating system and database versions Toad for Oracle has been certified to operate against.Certificate verification is multi-process performed by Toad to reach out to online sources to fetch the latest Certificate Revocation List (CRL). In some restrictive environment, it can cause slowness to verify and validate this process. -
해결 방안
Workaround
Modify Toad.ini; its default location is %APPDATA%\Quest Software\Toad for Oracle\xxx\User Files\Toad.ini – xxx referred to Toad version.
1) Modify InternetAccess=0 to the [SETTINGS] section – (where 1 check online and 0 is to check offline).
2) If startup delays are still present the user should also set AuthenticodeDisableCRLCheck=1 in Toad.ini.
3) Add DEBUG=1 to the [SETTINGS] section. Example
4) Example as follow:
[SETTINGS]
DEBUG=1
SCRIPTDEBUG=0
InternetAccess=0
AuthenticodeDisableCRLCheck=1
BarPaintingOptimization=0
UpgradeFlags=115The InternetAccess=0 INI setting removes Toad's ability to connect to the internet. This setting is also applied to the Certified Version Engine client.
Debug = 1 is optional for logging purposes.
Next, modify appsettings.json; its location is <install-dir>\CertifiedVersionEngine\appsettings.json where <install-dir> is the directory containing Toad.exe.1) Add a new section for AuthenticodeOptions and add a new key/value pair for "urlRetrievalTimeoutSeconds": 1
2) Set Serilog > MinimumLevel value to Debug (optional)
3) Example as follow:
{
"ProductPolicies": {
"ApiBase": "https://certifiedversions.ism.quest.com",
"Query": "api/policies?productId={0}&productVersion={1}"
},
"Serilog": {
"MinimumLevel": "Debug",
"WriteTo": [
{
"Name": "File",
"Args": {
"path": "%ProgramData%\\Quest Software\\DBT\\CVE\\Logs\\CVE.log",
"fileSizeLimitBytes": 20000000,
"rollingInterval": "Day",
"rollOnFileSizeLimit": true,
"retainedFileCountLimit": 5
}
}
]
},
"ApiPolicy": {
"RetryCount": 2,
"TimeoutSeconds": 5
}
},
"AuthenticodeOptions": {
"urlRetrievalTimeoutSeconds": 1
}
}Adding this parameters is to set the CVENG client's URL retrieval timeout used for cert validation.
Set MinimumLevel value to "Debug" is for logging purposes.