GoldenGate: OCI Error during OCIServerAttach
Hi:
I follow below mention steps for goldengate:
1). Install oracle 10g with two database on the same machine. orcl and orcl2 in d:\ drive.
2). In orcle a user name ggs_owner with employees table with 107 records.
3). In orcl2 a user ggs_owner2 with black employees table.
3). Download goldengate 10.4 and put into c:\GG folder after unzip.
4). Access GGSCI through cmd.
5). Create directories with "CREATE SUBDIRS" command.
6). configure mgr file with "EDIT PARAMS MGR" with below mention text.
[PORT 7809
USERID ggs_owner@orcl, PASSWORD ggs_owner
PURGEOLDEXTRACTS C:\GGs\dirdat\ex, USECHECKPOINTS]
7). Add extract : ADD EXTRACT load1, SOURCEISTABLE
8). edit params load1
[EXTRACT load1
SETENV (NLS_LANG = "AMERICAN_AMERICA.WE8MSWIN1252")
SETENV (ORACLE_HOME = "D:\Oracle\product\10.2.0")
SETENV (ORACLE_SID = "orcl")
USERID ggs_owner@orcl, PASSWORD ggs_owner
RMTHOST 10.8.11.227, MGRPORT 7809
RMTTASK replicat, GROUP load2
TABLE ggs_owner.departments;]
9). Add extract ADD REPLICAT load2, SPECIALRUN
10). edit params load2
[REPLICAT load2
USERID ggs_owner2@orcl2, PASSWORD ggs_owner2
ASSUMETARGETDEFS
MAP ggs_owner.departments, TARGET ggs_owner2.departments;]
After this setup i am going to run extract process.
11). start manager.
12 ). start extract laod1
after some time it display the ggsci propmt and below mention error in C:\GGS\dirrpt folder.
[ 2011-03-26 14:07:41 GGS ERROR 182 OCI Error during OCIServerAttach (status = 12154-Error while
trying to retrieve text for error ORA-12154).
2011-03-26 14:07:41 GGS ERROR 190 PROCESS ABENDING.]
Please help in stuck in this process.
Regards,
Abhishek