在部署OGG的时候新建OGG用户忘记授权，目标端REPLICAT进程启动不了。

GGSCI (ycods1) 1> start treplva aftercsn 12354995266226

Sending START request to MANAGER ...

REPLICAT TREPLVA starting

GGSCI (ycods1) 2> info all

Program     Status      Group       Lag           Time Since Chkpt
MANAGER     RUNNING
REPLICAT    STOPPED     TREPLVA     00:00:00      00:01:18

经过分析发现OGG用户没有CREATE SESSION权限。

2013-04-26 23:04:45  ERROR   OGG-00664  OCI Error beginning session (status = 1045-ORA-01045: user OGGUSER lacks CREATE SESSION privilege; logon denied).

2013-04-26 23:04:45  ERROR   OGG-01668  PROCESS ABENDING.

给OGG用户授予CONNECT和RESOURCE角色，报OGG-00665错误。

SQL> grant connect,resource to ogguser;

Grant succeeded.
GGSCI (ycods1) 1> start treplva aftercsn 12354995266226

Sending START request to MANAGER ...

REPLICAT TREPLVA starting
GGSCI (ycods1) 2> info all

Program     Status      Group       Lag           Time Since Chkpt
MANAGER     RUNNING
REPLICAT    STOPPED     TREPLVA     00:00:00      00:01:57

2013-04-26 23:05:22  ERROR   OGG-00665  OCI Error describe for query (bad syntax) (status = 942-ORA-00942: table or view does not exist), SQL<SELECT db.name, i.instance_name, i.version FROM v$database db, v$instance i>.

2013-04-26 23:05:22  ERROR   OGG-01668  PROCESS ABENDING.

授予OGG需要的所有权限，问题解决。

SQL> GRANT CONNECT TO ogguser;

Grant succeeded.
SQL> GRANT ALTER SESSION TO ogguser;

Grant succeeded.
SQL> GRANT SELECT ANY DICTIONARY to ogguser;

Grant succeeded.
SQL> GRANT SELECT any table TO ogguser;

Grant succeeded.
SQL> GRANT INSERT any table to ogguser;

Grant succeeded.
SQL> GRANT UPDATE any table to ogguser;

Grant succeeded.

SQL> GRANT DELETE any table to ogguser;

Grant succeeded.

GGSCI (ycods1) 1> start treplva aftercsn 12354995266226

Sending START request to MANAGER ...

REPLICAT TREPLVA starting

GGSCI (ycods1) 2> info all

Program     Status      Group       Lag           Time Since Chkpt

MANAGER     RUNNING
REPLICAT    RUNNING     TREPLVA     01:15:20      00:00:00
GGSCI (ycods1) 3> stats treplva

Sending STATS request to REPLICAT TREPLVA ...
Start of Statistics at 2013-04-26 23:07:04.
Replicating from STDPM.T_STD_YEAR_PLAN to ODS_YYJC_BUF.T_STD_YEAR_PLAN:
*** Total statistics since 2013-04-26 23:06:56 ***
Total inserts                              966.00
Total updates                                0.00
Total deletes                              966.00
Total discards                               0.00
Total operations                          1932.00

这个问题，如果足够细心，一般不会遇到。

本文固定链接: http://www.dbdream.com.cn/2013/05/%e6%96%b0%e5%bb%baogg%e7%94%a8%e6%88%b7%e6%b2%a1%e6%9c%89%e6%8e%88%e6%9d%83%e5%af%bc%e8%87%b4ogg-00664%e5%92%8cogg-00665%e9%94%99%e8%af%af/ | 信春哥，系统稳，闭眼上线不回滚！