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