My Oracle Support Banner

Info trandata got error "ORA-01031: insufficient privileges" in CDB environment (Doc ID 2689843.1)

Last updated on MAY 11, 2022

Applies to:

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


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"/>
   <appender-ref name="traceini"/>
    <level value="all"/>

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.




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

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