create permission check failed for oracle directory objects

[SomeDude]

DBA will not grant CREATE ANY DIRECTORY privilege. He says oracle directories for REDO and ARCHIVED logs are already created and READ was granted to QLIKREPLICATE user and I don't need to create them.

How do I set the names of the directories in the Qlik replication configuration and skip the CREATE DIRECTORY step?

Thanks

[adershb]

Hello @john_wang ,

I have tested this with verbose logging. Please see the below output from repsrv.log 

00018855: 2022-08-30T09:02:18:858649 [SERVER ]V: Oracle error code is '604' (oracle_endpoint_utils.c:3113)
00018855: 2022-08-30T09:02:18:858710 [SERVER ]T: ORA-00604: error occurred at recursive SQL level 1 ORA-16000: database or pluggable database open for read-only access [1022307] (oracle_endpoint_utils.c:3113)
00018855: 2022-08-30T09:02:18:858752 [SERVER ]T: Create permission check failed for Oracle directory objects [1020103] (oracle_endpoint_conn.c:514)
00018855: 2022-08-30T09:02:18:858778 [SERVER ]T: Free component test_database (oracle_endpoint.c:51)

Attached the repsrv.log for your reference. Please advise. 

Thanks, Adersh

[john_wang]

Hello @adershb ,

For security reason, please do not share your log files in community articles. Remove the file asap please.

A support ticket is needed, please open a support case and attach the file. Support team will help you on the issue.

Regards,

John.

[adershb]

Hello @john_wang , 

Removed the log file. From the output, what could be the reason. Is that due to read-only standby?

see the below output from repsrv.log 

00018855: 2022-08-30T09:02:18:858649 [SERVER ]V: Oracle error code is '604' (oracle_endpoint_utils.c:3113)
00018855: 2022-08-30T09:02:18:858710 [SERVER ]T: ORA-00604: error occurred at recursive SQL level 1 ORA-16000: database or pluggable database open for read-only access [1022307] (oracle_endpoint_utils.c:3113)
00018855: 2022-08-30T09:02:18:858752 [SERVER ]T: Create permission check failed for Oracle directory objects [1020103] (oracle_endpoint_conn.c:514)
00018855: 2022-08-30T09:02:18:858778 [SERVER ]T: Free component test_database (oracle_endpoint.c:51)

Already a case opened with support - case # 50619

Thanks, 

Adersh

[adershb]

Hello @john_wang , 

Thank you. The warning was due to the create directory statement failed as the source DB was a physical standby (readonly). 

00018855: 2022-08-30T09:02:18:332367 [SERVER ]T: Going to execute the statement 'create or replace directory attrep_dir_test as 'attrep_dir_test'' (without select) (oracle_endpoint_utils.c:3103)

00018855: 2022-08-30T09:02:18:858649 [SERVER ]V: Oracle error code is '604' (oracle_endpoint_utils.c:3113)
00018855: 2022-08-30T09:02:18:858710 [SERVER ]T: ORA-00604: error occurred at recursive SQL level 1 ORA-16000: database or pluggable database open for read-only access [1022307] (oracle_endpoint_utils.c:3113)
00018855: 2022-08-30T09:02:18:858752 [SERVER ]T: Create permission check failed for Oracle directory objects [1020103] (oracle_endpoint_conn.c:514)

Thanks for your support. 

Regards,

Adersh