GoldenGat在win 7平臺出錯
在源端的error log中一直出現
error 13 (Permission denied) opening redo log C:\ORACLE\ORADATA\ORCL\REDO03.LOG for sequence 36.
在Oracle的論壇中找到了解決辦法。因win7的redo log的預設許可權被改變了,所以一直會碰到這個錯誤。推薦解決方案是將MGR安裝為windows的service.
Cause
On windows 2008 or Windows 7, the default permission for Oracle online redo log is changed. Therefore, the other users cannot read them.
Solution
1. install GG service (e.g., "install ADDSERVICE").
The installation will require administrator privilege. After the installation, starting the manager by service (not from ggsci command line). Then, the extract may be started and able to read redo logs. This is the preferred way.
2. Start manager/extract processes as administrator.
Right click 'cmd' program (DOS), select 'run as administrator'. Then starting manager and extract will give the extract the permission to read redo logs.
3. Change online redo log files permission
Add read permission on all the redo logfiles to the user who will start up the manager and extract.
right click the file ->property->security->Edit->add
This may have side effects on database security, and is not recommended in production environment.
On windows 2008 or Windows 7, the default permission for Oracle online redo log is changed. Therefore, the other users cannot read them.
Solution
1. install GG service (e.g., "install ADDSERVICE").
The installation will require administrator privilege. After the installation, starting the manager by service (not from ggsci command line). Then, the extract may be started and able to read redo logs. This is the preferred way.
2. Start manager/extract processes as administrator.
Right click 'cmd' program (DOS), select 'run as administrator'. Then starting manager and extract will give the extract the permission to read redo logs.
3. Change online redo log files permission
Add read permission on all the redo logfiles to the user who will start up the manager and extract.
right click the file ->property->security->Edit->add
This may have side effects on database security, and is not recommended in production environment.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/8520577/viewspace-765866/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 達夢7在Linux平臺安裝Linux
- win10系統steam平臺提示錯誤程式碼-7的解決方法Win10
- VSCode連線伺服器在選擇平臺時報錯VSCode伺服器
- 直播平臺原始碼,JavaScript 的四種除錯輸出方式原始碼JavaScript除錯
- 如何遠端除錯部署在CloudFoundry平臺上的nodejs應用除錯CloudNodeJS
- win10系統無法安裝epic遊戲平臺出現錯誤2503怎麼解決Win10遊戲
- HyBridCLR在WebGL平臺下面打包出現的問題記錄Web
- 自媒體一鍵釋出平臺,3分鐘釋出全平臺
- Win10和win7雙系統出現引導錯誤怎麼修復Win10Win7
- 殭屍軍團遊戲已登陸Win7/win8.1以及win10等PC平臺遊戲Win7Win10
- golang在windows平臺使用zmqGolangWindowsMQ
- win7系統執行程式出現APPCRASH錯誤怎麼解決Win7行程APP
- .netCore System.Drawing.Common 釋出,在CentOS 執行報錯,生成圖片流時。會因為不支援在liunx平臺生成圖片。NetCoreCentOS
- win10應用商店伺服器出錯_win10應用商店0x80072ee7伺服器出錯的解決方法Win10伺服器
- 自媒體釋出平臺,釋出多個平臺,多渠道展現內容
- 在開放平臺建立第三方平臺應用
- 在 Pygame 遊戲中放置平臺GAM遊戲
- 11對戰平臺在win10中怎麼調魔獸3亮度Win10
- 7 – 在 Django Admin 後臺釋出文章Django
- Win7電腦不能重灌系統怎麼辦,臺式電腦重灌win7系統,臺式電腦重灌系統win7教程Win7
- 構建良好雲平臺的7個步驟
- 【linux】驅動-7-平臺裝置驅動Linux
- 在 heroku 平臺部署 node.js 程式Node.js
- 騰訊在美直播平臺Trovo曝光
- 在 iOS 平臺實現Ping 和 tracerouteiOS
- 自媒體一鍵多發平臺,多個平臺一鍵釋出
- win10應用商店執行出錯提示0x80072ee7修復方法Win10
- Win7 IIS7.5執行ASP時出現500錯誤的解決辦法Win7
- SmartX 釋出管理平臺 CloudTower 2.0 版本Cloud
- zblog新增html後臺出錯,zblog後臺設定固定域名繫結錯誤HTML
- Windows平臺下opatch apply報錯:OUI-67073WindowsAPPUI
- 在海之舟大資料平臺上搭建mysql+php開發平臺大資料MySqlPHP
- quicktimei在win10下安裝出錯怎麼辦_win10安裝不了quicktimei解決方法UIWin10
- dotnet 6 在 Win7 系統證書鏈錯誤導致 HttpWebRequest 記憶體洩露Win7HTTPWeb記憶體洩露
- 星海後臺測試平臺社群版正式釋出
- 帶你7天玩轉視覺化建站平臺視覺化
- 《指尖領主》7月5日全平臺上線
- 在Ubuntu上除錯ARMv7的core檔案Ubuntu除錯
- 開源DevOps工具在平臺的未來dev