Required permissions and considerations for moving to ASM based oracle

[Sreehari]

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

[kng]

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/Oracl...

https://help.qlik.com/en-US/replicate/May2024/Content/Global_Common/Content/SharedReplicateHDD/Oracl...

https://help.qlik.com/en-US/replicate/May2024/Content/Global_Common/Content/SharedReplicateHDD/Oracl...

Hope this helps!!

Regards,
Shivananda C S

[SachinB]

Hello @Sreehari ,

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

[Sreehari]

HI team

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

error

[SachinB]

Hello @Sreehari ,

Please follow the below community link as below.

https://community.qlik.com/t5/Official-Support-Articles/Qlik-Replicate-task-does-not-start-with-OCI-...

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