oracle12c ogg配置Extract进程后无法启动,提示用户名密码无效,实际上用户名密码是正确的
配置信息:
EXTRACT EORA_1
SETENV (NLS_LANG=AMERICAN_AMERICA.UTF8)
SETENV (ORACLE_HOME=“D:\app\Administrator\oracle12c\product\12.2.0\dbhome_1”)
SETENV (ORACLE_SID=“orcl”)
USERID ykgrid_compre, PASSWORD 123456
DISCARDFILE D:\shuzhi\ogg\dirrpt\EORA_1.dsc,APPEND,MEGABYTES 1024
EXTTRAIL D:\shuzhi\ogg\dirdat\eora1
TABLE ykgrid_compre.*;
错误信息:ERROR OGG-00303 Unable to connect to database using user ykgrid_compre. Ensure that the necessary privileges are granted to the user.
Login to the database as user ykgrid_compre failed because of error ORA-01017: 用户名/口令无效; 登录被拒绝.