Info trandata got error "ORA-01031: insufficient privileges" in CDB environment
(Doc ID 2689843.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle GoldenGate - Version 19.0.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
The issue exists in CDB environment .
GGSCI> info trandata <Schema_name>.<Table_name>
ERROR: OCI Error ORA (status = 1031-ORA-01031: insufficient privileges
In some cases , you might get below error message when you start the Extract process :
2020-04-15 14:44:20 ERROR OGG-00303 OCI Error ORA (status = 24964-ORA-24964: ALTER SESSION SET CONTAINER error
In activity trace file :
2020-07/10 19:38:23.198 main |DEBUG| 66 ggdbora/ocicpp/OCIStatem | Preparing statement: ALTER SESSION SET CONTAINER=<PDB_NAME> <<<<<<<<<<<<<<<<<<<<<<<<<<<<
2020-07/10 19:38:23.198 main |DEBUG| 188 ggdbora/ocicpp/OCIStatem | executing stmt
2020-07/10 19:38:23.198 main |DEBUG| 260 ggdbora/ocicpp/OCIStatem | stmt type 7
2020-07/10 19:38:23.199 main |DEBUG| 216 ggdbora/ocicpp/OCIStatem | Failed to execute dpi stmt
2020-07/10 19:38:23.199 main |DEBUG| 114 ggdbora/ocicpp/OCIErrorH | DPI Error ORA - 1031 - ORA-01031: insufficient privileges
For how to create activity trace , please follow below steps :
1 create a file by name gglog-ggsci.xml in ogg home with following contents
<?xml version="1.0"?>
<configuration reset="true">
<appender name="traceini" class="RollingFileAppender">
<param name="BufferedIO" value="false"/>
<param name="Append" value="true"/>
<param name="File" value="traceLog_%I_%A"/>
<param name="MaxBackupIndex" value="5"/>
<param name="MaxFileSize" value="500MB"/>
<layout class="PatternLayout">
<param name="Pattern" value="%d{%Y-%m/%d %H:%M:%S} %-22t|%-5p|%5L %-24.24C | %m%n"/>
</layout>
</appender>
<root>
<appender-ref name="traceini"/>
<level value="all"/>
</root>
</configuration>
2 Reproduce the issue :
ggsci> dblogin USERID <ogguser>, PASSWORD xxx
ggsci> info trandata trandata <Schema_name>.<Table_name>
3 The trace files would be created under OGG HOME directory .
! NOTE ! Please remove the xml file after you gather the trace.
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 |