Hello,
I am an Oracle consultant and new to Cisco firewall. I consulted my network team with a problem between firewall and Oracle sqlnet and they couldn't figure it out.
1. How can I check the below settings in the CISCO firewall.
- SQLNet fixup protocol (for CISCO)
- Inspect Feature in CISCO
- Deep Packet Inspection (for DPI)
- SQLNet packet inspection
- SQL Fixup
Our databases run on Red Hat Linux Servers version 5.4. The Primary database is in Boston and Standby Database is in Chicago.
When the primary database transports archive files from Boston to Chicago to the standby database, sporadically the network gets disconnected in the night. The Oracle database throws the below errors:
RFS network connection lost at host 'standbydb'
Error 3135 writing standby archive log file at host 'standbydb'
ORA-03135: connection lost contact
RFS network connection lost at host 'standbydb'
Error 3135 writing standby archive log file at host 'standbydb'
ORA-03135: connection lost contact
Upon consulting the Oracle support they suggested to check the above Firewall settings. they think that Firewall is intercepting the SQLNET connection between Boston and Chicago. My network team confirmed that we only have external firewall and not internal firewall.
Is it possible that the external firewall is intercepting the Network connection between Boston and Chicago?
Any suggestions will be much appreciated.
Thanks in advance.
