topic Re: XStream Oracle Permission in Qlik Replicate

XStream Oracle Permission

wali — Tue, 25 Feb 2025 20:56:17 GMT

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?

Re: XStream Oracle Permission

Dana_Baldwin — Tue, 25 Feb 2025 21:03:14 GMT

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.

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

Re: XStream Oracle Permission

wali — Tue, 25 Feb 2025 21:05:16 GMT

Hi Dana,

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

Re: XStream Oracle Permission

Dana_Baldwin — Tue, 25 Feb 2025 21:10:50 GMT

Hi @wali

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

Thanks,

Dana

Re: XStream Oracle Permission

wali — Tue, 25 Feb 2025 21:22:16 GMT

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?

Re: XStream Oracle Permission

Dana_Baldwin — Tue, 25 Feb 2025 21:54:59 GMT

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

Re: XStream Oracle Permission

DesmondWOO — Wed, 26 Feb 2025 05:03:44 GMT

Hi @wali ,

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

A GoldenGate license.
The user defined in the Oracle XStream endpoint settings must be a GoldenGate administrator.
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

Re: XStream Oracle Permission

wali — Wed, 26 Feb 2025 14:51:32 GMT

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

Re: XStream Oracle Permission

wali — Mon, 03 Mar 2025 14:10:01 GMT

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)