今天在给客户安装OGG的时候,EXTRACT进程无法启动。
GGSCI (ycods1) 4> start EXTBAM
Sending START request to MANAGER ...
EXTRACT EXTBAM starting
GGSCI (ycods1) 5> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED EXTBAM 00:00:00 02:59:08
EXTRACT STOPPED PUMPBAM 00:00:00 02:56:41
REPLICAT RUNNING REPCIMXB 00:00:00 00:00:02
REPLICAT RUNNING TREPLVA 00:00:00 00:00:05
观察日志,发现OGG-00664错误。
2013-05-08 15:07:07 ERROR OGG-00664 OCI Error beginning session (status = 12705-ORA-12705: Cannot access NLS data files or invalid environment specified)
这个报错很明显是由于NLS_LANG环境变量设置的不对,观察EXTRACT进程配置文件,发现NLS_LANG部分用了全角的双引号。
EXTRACT extbam
SETENV (NLS_LANG=”AMERICAN_AMERICA.ZHS16GBK”)
SETENV (ORACLE_SID=yyjc1)
USERID ogguser,PASSWORD AACAAAAAAAAAAAHAVEMFFBTCODIDNHRD,ENCRYPTKEY default
DYNAMICRESOLUTION
删除双引号,问题解决。
GGSCI (ycods1) 12> start EXTBAM
Sending START request to MANAGER ...
EXTRACT EXTBAM starting
GGSCI (ycods1) 13> info all
Program Status