DG4MSQL SSL Connection from Linux Fails With Error - Seeding the PRNG failed, Most Likely Because the System Does Not Have /dev/random. {08001 (Doc ID 1920411.1)

Last updated on JANUARY 19, 2017

Applies to:

Oracle Database Gateway for SQL Server - Version 12.1.0.1 and later
Linux x86-64

Symptoms

Using the Database Gateway for SQL*Server (DG4MSQL) 12.1, running on the RHEL6 Linux x86_64 platform, the following error occurs trying to connect to a SQL*Server 2008 R2 database in the Azure Cloud -

SQL: >select * from INFORMATION_SCHEMA.TABLES@DG4MSQL;
select * from INFORMATION_SCHEMA.TABLES@DG4MSQL
                                       *
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Oracle][ODBC SQL Server Wire Protocol driver]Seeding the PRNG failed, most
likely because the system does not have /dev/random. {08001}
ORA-02063: preceding 2 lines from DG4MSQL

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms