Shared Server: Port 1521 Open on Firewall But Unable to Connect Due to Errors: ORA-12535,TNS-12203
Last updated on OCTOBER 27, 2016
Applies to:Oracle Net Services - Version 188.8.131.52 to 184.108.40.206 [Release 8.1.7 to 11.2]
Information in this document applies to any platform.
Checked for relevance on 30-SEP-2011
This document describes a situation where a recent change to SHARED SERVER has occurred the firewall is now blocking the redirected connections to the dispatcher processes.
Firewall is present between the Oracle database and the clients. Port 1521 is open in the firewall.
Client connections time out or fail to complete giving errors like ORA-12535 or TNS-12203.
- Firewall service has been installed between database and clients.
- One of these:
- Database has been switched from dedicated mode to shared mode or client connections were restricted to shared mode.
- Database has been migrated to RAC setup.
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