Hey guys,
When I attempt to set up a data replication demo using GolenGate to replicate data from SQL Server 2008 to Oracle 11g, I encountered an fatal error.
I set up a SQL Server database and an Oracle database on the same PC, and installed GoldedGate.
When I invoke a replicat process like this:
replicat paramfile dirprm/inload.prm reportfile dirrpt/inload.rpt
An error was thrown, "oraxml10.dll is missing, unable to start this program".
Anyone can figure out the root cause?
Here is my GoldenGate configuration:
Source:
GoldenGate Version:
Oracle GoldenGate Command Interpreter for SQL Server
Version 11.2.1.0.2 OGGCORE_11.2.1.0.2T3_PLATFORMS_120724.2205
Windows x64 (optimized), Microsoft SQL Server on Jul 25 2012 03:04:52
OS platform is Windows 7, 64 bit.
Extact process:
GGSCI (chenyj-WorkPC) 1> view param inext
sourceistable
sourcedb ggs
rmthost 127.0.0.1,mgrport 7777
rmtfile d:/ggsora/dirdat/ex
table dbo.emp;
Target:
GoldenGate Version:
Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230
Windows x64 (optimized), Oracle 10g on Apr 23 2012 04:55:04
Database:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
"CORE 11.2.0.1.0 Production"
TNS for 64-bit Windows: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
OS: Windows 7, 64bit
Replicate params:
GGSCI (chenyj-WorkPC) 1> view param inload
specialrun
end runtime
setenv(ORACLE_HOME=C:\oracle\product\11.2.0\dbhome_1)
setenv(ORACLE_SID=ORCL)
userid ggs, password ggs
extfile d:/ggsora/dirdat/ex
sourcedefs d:/ggsora/dirdef/emp.def
map dbo.emp, target ggs.emp;
Any help is appreciated. Thanks in advance.