dblogin登陆数据库时报错ORA-04060

时间:2022-12-01 20:00:16
问题描述:dblogin登陆数据库时报错ORA-04060,如下所示:
oracle:11.2.0.4
GGSCI (leo-11g-ogg) 5> dblogin userid ogg,password ogg

2022-12-01 12:19:49 WARNING OGG-25108 Failed to set the Oracle session tag: ORA-04060: insufficient privileges to execute DBMS_STREAMS.SET_TAG
ORA-06512: at "SYS.DBMS_STREAMS", line 16
ORA-06512: at line 1.
Successfully logged into database.
异常原因:
ogg用户权限不足.
解决过程:
GGSCI (leo-11g-ogg as ogg@orcl) 6> exit
[oracle@leo-11g-ogg ogg]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Thu Dec 1 12:28:49 2022

Copyright (c) 1982, 2013, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

sys@ORCL 2022-12-01 12:28:49> grant dba to ogg;

Grant succeeded.

sys@ORCL 2022-12-01 12:29:05> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@leo-11g-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 11g on Oct 17 2019 23:13:12
Operating system character set identified as UTF-8.

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



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