Troubleshooting

Alation Cloud Service Applies to Alation Cloud Service instances of Alation

Customer Managed Applies to customer-managed instances of Alation

Log Location

Refer to Troubleshoot OCF Connectors.

Connection via Native Network Encryption (NNE) fails

Make sure that you have the required permissions.

  1. Grant permission on tables v_$session_connect_info and v_$mystat to the user as these are the corresponding synonyms too.

    If you can’t grant permissions directly, run the following commands:

    GRANT SELECT ON v_$mystat TO <user>
GRANT SELECT ON v_$session_connect_info TO <user>

  2. Run the following commands:

    select network_service_banner from v$session_connect_info where sid in (select distinct sid from v$mystat);

  3. Verify the output for the queries mentioned above.

    If encryption or checksum is enabled:

    TCP/IP NT Protocol Adapter for Linux: Version 19.0.0.0.0 - Production
Encryption service for Linux: Version 19.0.0.0.0 - Production
AES256 Encryption service adapter for Linux: Version 19.0.0.0.0 - Production
Crypto-checksumming service for Linux: Version 19.0.0.0.0 - Production
SHA1 Crypto-checksumming service adapter for Linux: Version 19.0.0.0.0 - Production

    If encryption or checksum is disabled:

    TCP/IP NT Protocol Adapter for Linux: Version 19.0.0.0.0 - Production
Encryption service for Linux: Version 19.0.0.0.0 - Production
Crypto-checksumming service for Linux: Version 19.0.0.0.0 - Production