goldengate连接Oracle数据库，可以使用几种方式：
- 直连接
在参数文件里可以使用setenv命令：
SETENV (ORACLE_SID=r11g)
USERID chensq, PASSWORD chensqggsci提示符下连接数据库，只能先设置环境变量：
D:\tools\ggs>set oracle_sid=r11g
D:\tools\ggs>ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 10.4.0.19 Build 002
Windows (optimized), Oracle 11 on Sep 18 2009 16:32:37Copyright (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:\tools\ggs>set oracle_sid=test
D:\tools\ggs>ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 10.4.0.19 Build 002
Windows (optimized), Oracle 11 on Sep 18 2009 16:32:37Copyright (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.