GGSCI (gc2) 8> DBLOGIN USERID ogg, PASSWORD ogg在目标库操作这一步出错ERROR: Failed to open data source for user OGG.有哪些原因导致,权限有,监听也正
2条回答 默认 最新
- WorldMobile 2015-01-06 04:26关注
可参考以下内容
[oracle@ora10gr2 11.1]$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jan 1 20:52:22 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining optionsSQL> grant dba to ogg;
Grant succeeded.
SQL> conn ogg/ogg
Connected.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@ora10gr2 11.1]$ ggsciOracle GoldenGate Command Interpreter for Oracle
Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100
Linux, x86, 32bit (optimized), Oracle 10g on Oct 4 2011 23:54:04Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.
GGSCI (ora10gr2) 1> dblogin userid ogg,password ogg;
ERROR: Failed to open data source for user OGG.GGSCI (ora10gr2) 2> DBLOGIN USERID ogg,PASSWORD ogg;
ERROR: Failed to open data source for user OGG.--解决方案
[oracle@ora10gr2 11.1]$ ggsciOracle GoldenGate Command Interpreter for Oracle
Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100
Linux, x86, 32bit (optimized), Oracle 10g on Oct 4 2011 23:54:04Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.
GGSCI (ora10gr2) 1> DBLOGIN USERID ogg,PASSWORD ogg;
ERROR: Failed to open data source for user OGG.GGSCI (ora10gr2) 2> DBLOGIN USERID ogg
Password:
Successfully logged into database.GGSCI (ora10gr2) 3>
其实,在密码后边不加分号 ‘;’ 就可以
解决 无用评论 打赏 举报
悬赏问题
- ¥15 关于无人驾驶的航向角
- ¥15 keil的map文件中Image component sizes各项意思
- ¥30 BC260Y用MQTT向阿里云发布主题消息一直错误
- ¥20 求个正点原子stm32f407开发版的贪吃蛇游戏
- ¥15 划分vlan后,链路不通了?
- ¥20 求各位懂行的人,注册表能不能看到usb使用得具体信息,干了什么,传输了什么数据
- ¥15 Vue3 大型图片数据拖动排序
- ¥15 Centos / PETGEM
- ¥15 划分vlan后不通了
- ¥20 用雷电模拟器安装百达屋apk一直闪退