Forum Stats

  • 3,876,212 Users
  • 2,267,082 Discussions
  • 7,912,473 Comments

Discussions

GoldenGate: OCI Error during OCIServerAttach

user651239
user651239 Member Posts: 94 Blue Ribbon
edited Mar 27, 2011 9:23PM in GoldenGate
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 [email protected], 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 [email protected], 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 [email protected], 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

Answers

This discussion has been closed.