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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- bugfree在win7(64位)平臺的搭建Win7
- 達夢7在Linux平臺安裝Linux
- Toad或Sqlplus Developer在Win7 64位平臺安裝SQLDeveloperWin7
- win10系統steam平臺提示錯誤程式碼-7的解決方法Win10
- 同一個EAR程式在不同平臺JBoss3.22上部署出錯。S3
- 在Windows 平臺遇上ORA-29339 錯誤Windows
- Linux木馬神通廣大:感染Win7/Win8.1平臺LinuxWin7
- Win10釋出/Win8停售,戴爾還在推Win7Win10Win7
- win7 64位 VC++6.0 除錯出錯 解決辦法Win7C++除錯
- 遊戲平臺釋出最新統計資料:Win7持續稱霸Steam,Win10份額不到24%遊戲Win7Win10
- jb7+weblogic7出錯!Web
- win32平臺下研究除錯SSL通訊機制Win32除錯
- Laravel5.4 在 win7 下使用 cnpm 構建前端工作流出現編譯出錯LaravelWin7NPM前端編譯
- 直播平臺原始碼,JavaScript 的四種除錯輸出方式原始碼JavaScript除錯
- win10系統無法安裝epic遊戲平臺出現錯誤2503怎麼解決Win10遊戲
- Linux-0.11系統在Windows平臺下的除錯LinuxWindows除錯
- VSCode連線伺服器在選擇平臺時報錯VSCode伺服器
- 在MAC平臺下使用Eclipse出現了中文亂碼MacEclipse
- Windows平臺下不能建立資料庫連線出錯分析(2)Windows資料庫
- Windows平臺下不能建立資料庫連線出錯分析 (1)Windows資料庫
- 殭屍軍團遊戲已登陸Win7/win8.1以及win10等PC平臺遊戲Win7Win10
- 自媒體一鍵釋出平臺,3分鐘釋出全平臺
- HP-UX平臺Ioctl ASYNC_CONFIG error, errno =7報錯分析UXError
- 在 Pygame 遊戲中放置平臺GAM遊戲
- golang在windows平臺使用zmqGolangWindowsMQ
- 在AWS中部署OpenShift平臺
- 如何遠端除錯部署在CloudFoundry平臺上的nodejs應用除錯CloudNodeJS
- 微軟宣佈Win7/Win8.1對Skylake平臺支援將延長到2018年7月微軟Win7
- HyBridCLR在WebGL平臺下面打包出現的問題記錄Web
- 藉此平臺出幾本書
- .NET Core 跨平臺釋出
- Win10蟬聯4月Steam平臺冠軍 Win7系統降低幅度持續走低Win10Win7
- 自媒體釋出平臺,釋出多個平臺,多渠道展現內容
- Win10和win7雙系統出現引導錯誤怎麼修復Win10Win7
- win7+iis7+ASP.NET URL重寫實現偽靜態,除錯OK,但釋出就報 404錯誤Win7ASP.NET除錯
- 在開放平臺建立第三方平臺應用
- 11對戰平臺在win10中怎麼調魔獸3亮度Win10
- weblogic7的SESSION出錯WebSession