topic Re: Required permissions and considerations for moving to ASM based oracle in Qlik Replicate

Required permissions and considerations for moving to ASM based oracle

user2828 — Tue, 10 Sep 2024 11:51:40 GMT

Hi team,

The current oracle db is standalone and the team is going with Oracle ASM based database. So I want to send them what and all required permissions and pre-requisites for this. So that I can enable CDC for tables.
They have asked for required permissions and pre-requisites as a list. Can anyone help me out with this.

Thanks,
Sreehari

Re: Required permissions and considerations for moving to ASM based oracle

kng — Tue, 10 Sep 2024 12:04:38 GMT

Hello Team,
Good Day

Thanks for reaching Qlik community portal!!

Please find the below link which provide the information related to the Required ASM privileges and prerequsites

https://help.qlik.com/en-US/replicate/May2024/Content/Global_Common/Content/SharedReplicateHDD/Oracle/oracle_prerequisites.htm

https://help.qlik.com/en-US/replicate/May2024/Content/Global_Common/Content/SharedReplicateHDD/Oracle/OracleDBSource_Security.htm

https://help.qlik.com/en-US/replicate/May2024/Content/Global_Common/Content/SharedReplicateHDD/Oracle/OracleDB_source_limitations.htm

Hope this helps!!

Regards,
Shivananda C S

Re: Required permissions and considerations for moving to ASM based oracle

SachinB — Tue, 10 Sep 2024 12:07:58 GMT

Hello @user2828 ,

Thanks for reaching out to Qlik community forum.

Grant the following read privilege:

SELECT ON v_$transportable_platform

From Oracle 11g Release 2 (11.2.0.2), Replicate must be granted the SYSASM privilege in order to access the ASM account. For older supported versions, granting Replicate the SYSDBA privilege should be sufficient.

You can validate ASM account access by opening a command prompt and issuing the following statements:

sqlplus asmuser/asmpassword@+asmserver as sysdba

-OR-

sqlplus asmuser/asmpassword@+asmserver as sysasm

Also please follow the below link

Required ASM privileges

Regards,

Sachin B

Re: Required permissions and considerations for moving to ASM based oracle

user2828 — Tue, 10 Sep 2024 12:28:26 GMT

HI team

Is the below error due to not giving the mentioned privilage?

error

Re: Required permissions and considerations for moving to ASM based oracle

SachinB — Tue, 10 Sep 2024 13:46:58 GMT

Hello @user2828 ,

Please follow the below community link as below.

https://community.qlik.com/t5/Official-Support-Articles/Qlik-Replicate-task-does-not-start-with-OCI-error-ORA-12560-TNS/ta-p/1935117

If you still get the error, I will request you to create a case and Kindly attach "Source capture" in verbose, we can work together on the same.

Regards,

Sachin B