Navicat連接配接oracle失敗：Error - OCI_INVALID_HANDLE

原因：突然斷電或者把oracle程序殺掉了(殺掉之後又重新開機oracle服務後使用navicat連接配接正常但運作sql報錯)

解決：将以下指令儲存為.bat腳本檔案，運作一下

for /f %%i in ('reg query HKCU\Software\Classes\CLSID') do call:checkDelCLSID %%i
 
reg delete HKCR\NavicatProfileBackup /f 1>nul 2>nul 
reg delete HKCR\NavicatProfileBatchJob /f 1>nul 2>nul
reg delete HKCR\NavicatProfileDataSync /f 1>nul 2>nul
reg delete HKCR\NavicatProfileExport /f 1>nul 2>nul
reg delete HKCR\NavicatProfileImport /f 1>nul 2>nul
reg delete HKCR\NavicatProfileModel /f 1>nul 2>nul
reg delete HKCR\NavicatProfileStructureSync /f 1>nul 2>nul
reg delete HKCR\NavicatProfileTransfer /f 1>nul 2>nul
reg delete HKCU\Software\PremiumSoft /f 1>nul 2>nul
 
rmdir /S /Q C:\Users\你的使用者名\Documents\Navicat
rmdir /S /Q C:\Users\你的使用者名\AppData\Local\Temp\NavicatCloud

exit
 
:checkDelCLSID
echo filtering %1
echo %1|findstr "{CAFEEFAC-" 1>nul 2>nul
set result=%errorlevel%
if %result%==0 goto:eof
 
echo checking %1
reg query %1\Info 1>nul 2>nul
set result=%errorlevel%
if %result%==1 goto:eof
 
echo deleteing %1
reg delete %1 /f 1>nul 2>nul
 
goto:eof
           

說明：

該腳本檔案本用于無限試用navicat，是以會删除注冊等資訊，包括資料庫連接配接資訊，使用前要導出備份