My Oracle Support Banner

Extract abends with OGG-00303 ORA-01804 (Doc ID 2586519.1)

Last updated on SEPTEMBER 14, 2019

Applies to:

Oracle GoldenGate - Version 18.1.0.0.0 and later
Information in this document applies to any platform.

Symptoms

1) Goldengate process fails to start with below error message although OGG user has all the privileges :

2019-09-09 20:12:29  ERROR   OGG-00303  Unable to connect to database using user ogguser. Ensure that the necessary privileges are granted to the user.
Login to the database as user ogguser failed because of error Error while trying to retrieve text for error ORA-01804.

2019-09-09 20:12:29  ERROR   OGG-01668  PROCESS ABENDING

 

2) DBTIMEZONE  is set correctly :

SQL>  SELECT property_name,property_value FROM database_properties WHERE property_name in ('DBTIMEZONE', 'NLS_CHARACTERSET', 'NLS_NCHAR_CHARACTERSET') ORDER BY property_name;

PROPERTY_NAME                                      PROPERTY_VALUE
-------------------------------------------------- --------------------------------------------------
DBTIMEZONE                                         America/New_York
NLS_CHARACTERSET                                   AL32UTF8
NLS_NCHAR_CHARACTERSET                             AL16UTF16

 

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.