Hi all,
GG Sqlserver2008 to Oracle11gR2.
I have configured the above setup.
Initial LOAD was successful, using the following prms
Source:(inext.prm)
=====
SOURCEISTABLE
SOURCEDB HR, userid sa, password sa
RMTHOST dtc-pc, MGRPORT 7809
RMTFILE d:\GGora\dirdat\ex
TABLE hrschema.emp;
Target: (inload.prm)
=====
SPECIALRUN
END RUNTIME
USERID gg_user, PASSWORD welcome1
EXTFILE d:\ggora\dirdat\ex
SOURCEDEFS d:\ggora\dirdef\emp.def
MAP hrschema.emp, TARGET gg_user.emp;
Then I proceed to LIVE DATA CAPTURE. But my extract process got error? maybe the prm is not correct?
Source: (msext.prm)
===============
EXTRACT MSEXT
TRANLOGOPTIONS MANAGESECONDARYTRUNCATIONPOINT
SOURCEDB HR, userid sa, password sa
RMTHOST dtc-pc, MGRPORT 7809
RMTTRAIL d:\ggora\dirdat\ms
TABLE HRSCHEMA.EMP;
Target: (msrep.prm)
==============
REPLICAT MSREP
USERID gg_user, PASSWORD welcome1
SOURCEDEFS d:\ggora\dirdef\emp.def
MAP hrschema.emp, TARGET gg_user.emp;
I got error on the source EXTRACT MSEXT
2013-06-21 23:35:01 ERROR OGG-00551 Database operation failed: Couldn't connect to HR. ODBC error: SQLSTATE 37000 native database error 4060. [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "emp" requested by the login. The login failed.
2013-06-21 23:35:01 ERROR OGG-01668 PROCESS ABENDING.
ggserr.log
=======
2013-06-21 23:31:18 INFO OGG-00983 Oracle GoldenGate Manager for SQL Server, mgr.prm: Manager started (port 7808).
2013-06-21 23:32:37 INFO OGG-00987 Oracle GoldenGate Command Interpreter for SQL Server: GGSCI command (DTC): start manager.
2013-06-21 23:35:00 INFO OGG-00987 Oracle GoldenGate Command Interpreter for SQL Server: GGSCI command (DTC): start extract msext.
2013-06-21 23:35:00 INFO OGG-00963 Oracle GoldenGate Manager for SQL Server, mgr.prm: Command received from GGSCI on host DTC-PC.domain:51376 (START EXTRACT MSEXT ).
2013-06-21 23:35:00 INFO OGG-00975 Oracle GoldenGate Manager for SQL Server, mgr.prm: EXTRACT MSEXT starting.
2013-06-21 23:35:01 INFO OGG-00992 Oracle GoldenGate Capture for SQL Server, MSEXT.prm: EXTRACT MSEXT starting.
2013-06-21 23:35:01 INFO OGG-03035 Oracle GoldenGate Capture for SQL Server, MSEXT.prm: Operating system character set identified as windows-1252. Locale: en_PH, LC_ALL:.
2013-06-21 23:35:01 ERROR OGG-00551 Oracle GoldenGate Capture for SQL Server, MSEXT.prm: Database operation failed: Couldn't connect to HR. ODBC error: SQLSTATE 37000 native database error 4060. [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "emp" requested by the login. The login failed.
2013-06-21 23:35:01 ERROR OGG-01668 Oracle GoldenGate Capture for SQL Server, MSEXT.prm: PROCESS ABENDING.
=========
I can login to HR using ggsci
=====================
GGSCI (DTC-PC) 8> dblogin sourcedb hr, userid sa, password sa
2013-06-22 00:23:26 INFO OGG-03036 Database character set identified as windows-1252. Locale: en_US.
2013-06-22 00:23:26 INFO OGG-03037 Session character set identified as windows-1252.
Successfully logged into database.
Please help...
Thanks a lot,
zxy