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 Troubleshooting.

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