问题描述: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.
dblogin登陆数据库时报错ORA-04060
原创Liujun_Deng 博主文章分类:Oracle ©著作权
文章标签 ORA-04060 dblogin登陆数据库 文章分类 Oracle 数据库
©著作权归作者所有:来自51CTO博客作者Liujun_Deng的原创作品,请联系作者获取转载授权,否则将追究法律责任

提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
数据库在启动时报错ORA-32004
数据库在启动时报错ORA-32004
数据库 oracle sql -
还原mysql数据库时报错
mysql数据库还原时报错
mysql 还原 -
设置28401事件后启动数据库时报错ORA-49100
设置28401事件后启动数据库时报错ORA-49100
oracle sql 数据库 -
数据库在执行全库恢复后,open时报错ORA-01113、ORA-01110 ORA-00312 ORA-01113
数据库在执行全库恢复后,open时报错ORA-01113、ORA-01110 ORA-00312 ORA-01113
ORA-01113 ORA-01110 ORA-00312 ORA-01113