Problem Note 65899: "ERROR: ORACLE disconnect error: ORA-03135" occurs when SAS® disconnects from the Oracle database server
 |  |  |  |
If you have a VPN connection to a host running 32-bit SAS on Windows, you might encounter the following error when SAS tries to disconnect from the Oracle database:
ERROR: ORACLE disconnect error: ORA-03135: connection lost contact
For example, you might get the error when you run either of the following statements in the SQL procedure:
libname libref clear;
disconnect from oracle;
This is a known problem related to Oracle client 12c.
The workaround is to install and use the 32-bit Oracle client 11g or to upgrade to 64-bit SAS with the 64-bit Oracle client 11g or later versions. 64-bit SAS has better performance and is recommended.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Oracle | Microsoft Windows 8 Enterprise 32-bit | 9.43 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Pro 32-bit | 9.43 | 9.4 TS1M6 | ||||
| Microsoft Windows 8.1 Enterprise 32-bit | 9.43 | 9.4 TS1M6 | ||||
| Microsoft Windows 8.1 Pro 32-bit | 9.43 | 9.4 TS1M6 | ||||
| Microsoft Windows 8.1 Pro x64 | 9.43 | 9.4 TS1M6 | ||||
| Microsoft Windows 10 | 9.43 | 9.4 TS1M6 | ||||
| Microsoft Windows Server 2012 Datacenter | 9.43 | 9.4 TS1M6 | ||||
| Microsoft Windows Server 2012 R2 Datacenter | 9.43 | 9.4 TS1M6 | ||||
| Microsoft Windows Server 2012 R2 Std | 9.43 | 9.4 TS1M6 | ||||
| Microsoft Windows Server 2012 Std | 9.43 | 9.4 TS1M6 | ||||
| Microsoft Windows Server 2016 | 9.43 | 9.4 TS1M6 | ||||
| Microsoft Windows Server 2019 | 9.43 | 9.4 TS1M6 | ||||
| Windows 7 Enterprise 32 bit | 9.43 | 9.4 TS1M6 | ||||
| Windows 7 Enterprise x64 | 9.43 | 9.4 TS1M6 | ||||
| Windows 7 Home Premium 32 bit | 9.43 | 9.4 TS1M6 | ||||
| Windows 7 Home Premium x64 | 9.43 | 9.4 TS1M6 | ||||
| Windows 7 Professional 32 bit | 9.43 | 9.4 TS1M6 | ||||
| Windows 7 Professional x64 | 9.43 | 9.4 TS1M6 | ||||
| Windows 7 Ultimate 32 bit | 9.43 | 9.4 TS1M6 | ||||
| Windows 7 Ultimate x64 | 9.43 | 9.4 TS1M6 | ||||
When you run 32-bit SAS on Windows and disconnect from the Oracle database server, you might see the error: "ERROR: ORACLE disconnect error: ORA-03135: connection lost contact."
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2020-05-07 07:04:08 |
| Date Created: | 2020-04-28 15:40:25 |