goldengate连接Oracle数据库，可以使用几种方式：
- 直连接
在参数文件里可以使用setenv命令：
SETENV (ORACLE_SID=r11g)
USERID chensq, PASSWORD chensq
ggsci提示符下连接数据库，只能先设置环境变量：
D:toolsggs>set oracle_sid=r11g
D:toolsggs>ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 10.4.0.19 Build 002
Windows (optimized), Oracle 11 on Sep 18 2009 16:32:37
Copyright (C) 1995, 2009, Oracle and/or its affiliates. All rights reserved.
GGSCI (thinkpad) 1> dbloin userid chensq, password chensq
ERROR: Invalid command.
GGSCI (thinkpad) 2> dblogin userid chensq, password chensq
ERROR: Failed to open data source for user CHENSQ.
GGSCI (thinkpad) 3> exit
D:toolsggs>set oracle_sid=test
D:toolsggs>ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 10.4.0.19 Build 002
Windows (optimized), Oracle 11 on Sep 18 2009 16:32:37
Copyright (C) 1995, 2009, Oracle and/or its affiliates. All rights reserved.
GGSCI (thinkpad) 1> dblogin userid chensq, password chensq
Successfully logged into database.
- Tnsnames解析
GGSCI (thinkpad) 2> dblogin USERID ggs@as52,password ggs
Successfully logged into database.
- Easyconnect
GGSCI (thinkpad) 3> dblogin USERID ggs@//192.168.0.241/r11g,password ggs
Successfully logged into database.
--转自
当前位置：
论坛首页 »
自由讨论区 »
MySQL, Oracle及数据库讨论区
»
发起投票
技术讨论
加好友
发消息
2015-4-22 10:49:34 |
赞(
操作
