XStream Oracle Permission

[wali]

We are sitting up the XStream connection for Oracle. The Pre-requisite document states the following. "when the Oracle XStream endpoint is configured, the user specified in the endpoint setting must also be an XStream administrator?

Can you provide the actual Oracle grants that is required for the XStream endpoint to be successful?

[Dana_Baldwin]

Hi @wali 

I got this from the latest release (2024.11) user guide, it doesn't mention XStream administrator:

To use the Oracle XStream endpoint in a replication task, the user defined in the Oracle XStream endpoint settings must be granted the following privileges in the Oracle database.

Information note

If any of the required privileges cannot be granted to a V$xxx, then grant them to the V_$xxx.

• CREATE SESSION
• SELECT on V_$PARAMETER
• SELECT on V_$NLS_PARAMETERS
• SELECT on V_$TIMEZONE_NAMES
• SELECT on GV_$TRANSACTION
• SELECT on V_$CONTAINERS
• SELECT on ALL_INDEXES
• SELECT on ALL_OBJECTS
• SELECT on ALL_TABLES
• SELECT on ALL_USERS
• SELECT on ALL_CATALOG
• SELECT on ALL_CONSTRAINTS
• SELECT on ALL_CONS_COLUMNS
• SELECT on ALL_TAB_COLS
• SELECT on ALL_IND_COLUMNS
• SELECT on SYS.DBA_REGISTRY
• If views are exposed: SELECT on ALL_VIEWS

Permissions when replicating explicitly selected tables

Grant the following additional privilege (for each replicated table) when you are using an explicit table list:

• SELECT on <any-replicated-table>;

Permissions when replicating tables that match a pattern

Grant the following additional privilege when using a pattern for the table list:

• SELECT ANY TABLE;

Permission for accessing an Oracle standby database

• SELECT on V$STANDBY_LOG

Permissions for accessing nested tables

• SELECT on all_nested_tables
• SELECT on all_nested_table_cols

------------------------------------------

Copied from: Prerequisites | Qlik Replicate Help

Hope this helps!

Dana

[wali]

Hi Dana,

Thank you for quick response. How can one grant XStream Administrator role to Qlik Replicate account?

[Dana_Baldwin]

Hi @wali 

I did a quick search and found this: Configuring XStream In

Thanks,

Dana

[wali]

Hi Dana,

This is the Xstream configuration in Oracle, however with respect to Qlik XStream endpoint what is required? when I connect and Source Oracle Endpoint it says the Server is setup to support Streams. Having said that we have a QLIK-USER setup with all the pre-requisite permissions you have listed before. The only question is what is required to have the XStream Administrator role granted to the QLIK--USER. It is a bet confusing?

[Dana_Baldwin]

Hi @wali 

It looks like the XStream Admin role isn't needed, and I don't see a way for the endpoint to automatically grant it.

Also, you can't use the regular Oracle endpoint for XStream, it's a separate endpoint type. You need to be running version 2024.11 and have it included in your license. If you don't see Oracle XStream as an available endpoint type, but you are on 2024.11, then it is not in your license. You would need to contact your Account Manager.

Thanks,

Dana

[DesmondWOO]

Hi @wali ,

To use the Oracle XStream endpoint in a replication task, please note the following requirements:

1. A GoldenGate license.
2. The user defined in the Oracle XStream endpoint settings must be a GoldenGate administrator.
3. When configuring the Oracle XStream endpoint to create the XStream Server, the specified user must also be an XStream administrator.

For more information, please check GoldenGate requirements.

Regards,
Desmond

[wali]

Hi Desmond,

1: How and what can be done to verify the goldengate license?

2: What is the GRANTS for the QLIK REPL USER ACCOUNT to have the Goldengate administrator role?

3: Dana provided the XStream administrator role setup. We are good there.

4: Does our Qlik Replicate for Oracle endpoint needs to have license for XStream connector as well? or it is already given?

regards,

Wali

[wali]

I have setup everything as per documentation and still getting this error.

00021264: 2025-02-28T18:19:56:680264 [SOURCE_CAPTURE  ]E:  OCI error 'ORA-01031: insufficient privileges' [1022307]  (oracle_xstream_utils.c:913)

00021264: 2025-02-28T18:19:56:849704 [SOURCE_CAPTURE  ]E:  Error executing command [1022307]  (streamcomponent.c:2056)

00021264: 2025-02-28T18:19:56:849704 [TASK_MANAGER    ]E:  Stream component failed at subtask 0, component st_0_CAMP_XStream  [1022307]  (subtask.c:1474)

00021264: 2025-02-28T18:19:56:849704 [SOURCE_CAPTURE  ]E:  Stream component 'st_0_CAMP_XStream' terminated [1022307]  (subtask.c:1643)

00021264: 2025-02-28T18:19:57:100991 [SOURCE_CAPTURE  ]E:  OCI error 'Error - OCI_INVALID_HANDLE' [1022307]  (oracle_xstream_utils.c:98)