Oracle

December 25, 2010

Goldengate error 1008-ORA-01008: not all variables bound

Filed under: Uncategorized — srivenu @ 6:34 am

I was trying to implement Oracle goldengate solution in one of our databases. I decided to use the latest version of Oracle GoldenGate – 11g Release 1 (11.1.1).
When I tried out a simple extract i faced the following error.
ERROR OGG-00665 OCI Error executing statement (status = 1008-ORA-01008: not all variables bound), SQL< SELECT c.constraint_name, c.column_name FROM all_cons_columns c WHERE c.owner = owner1 AND c.table_name = :table1 AND c.constraint_name = (SELECT c1.name FROM>

The SQL could vary depeding on your extract parameters but the error is the same. Setting NLS_LANG=”.WE8ISO8859P1″ (same as DB) did not resolve the issue. 

Found one note relating to  the error on the net, but i had already added supplementary logging.

Searching Metalink revealed a note which pointed out to a bug in Goldengate if CURSOR_SHARING parameter is not set to EXACT. Adding the following SQLEXEC command to the EXTRACT and REPLICAT parameter files resolved the issue.

Sample extract parameter file

EXTRACT extr_x
USERID gguser, PASSWORD temp
SQLEXEC "ALTER SESSION SET cursor_sharing='EXACT'";
............
............

Sample Replicat parameter file

REPLICAT rep_x
USERID gguser, PASSWORD temp
SQLEXEC "ALTER SESSION SET cursor_sharing='EXACT'";
............
............
Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: