ITPub博客

首页 > Linux操作系统 > Linux操作系统 > GoldenGat在win 7平台出错

GoldenGat在win 7平台出错

原创 Linux操作系统 作者:abstractcyj 时间:2013-07-09 11:14:35 0 删除 编辑
在源端的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.

https://forums.oracle.com/thread/1632639


来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8520577/viewspace-765866/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
曾从事java方向开发多年。近年已经转入数据库方向。主要擅长SQL优化,Oracle数据库问题诊断,Oracle备份与恢复等。服务于医药物流,医院等行业

注册时间:2010-01-26

  • 博文量
    555
  • 访问量
    828738