使用ogg登陆出现OGG-25108告警

时间:2022-12-01 19:58:28
问题描述:使用ogg登陆出现OGG-25108告警,如下所示:
GGSCI (leo-19c-ogg) 7> dblogin userid ogg,password ogg

2022-12-01 14:05:34 WARNING OGG-25108 Failed to set the Oracle session tag: ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_XSTREAM_GG_ADM' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored.
Successfully logged into database.

异常原因:
用户权限不足.
解决过程:
SQL> conn / as sysdba
Connected.
SQL> grant dba to ogg;

Grant succeeded.
[oracle@leo-19c-ogg ogg]$ ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 19.1.0.0.4 OGGCORE_19.1.0.0.0_PLATFORMS_191017.1054_FBO
Linux, x64, 64bit (optimized), Oracle 19c on Oct 17 2019 21:16:29
Operating system character set identified as UTF-8.

Copyright (C) 1995, 2019, Oracle and/or its affiliates. All rights reserved.



GGSCI (leo-19c-ogg) 1> dblogin userid ogg,password ogg
Successfully logged into database.

结论:授予dba权限后成功登陆.