Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

error :ora03114

one mpls user is trying to connect through the l3 switch conencted to an asa .

In the asa there is a dmz oracle server and only one user is getting this error

ORA-03114: not connected to oracle

rest of them can connect fine

this user gets disconnected randomly

any help would be appreciated

5 REPLIES

Re: error :ora03114

Hi ... I am not sure about the error message but it seems to be related to network connectivity on that user only. I suggest check the switch port where the user is connected. check for errors, duplex mismatch, verify physical cables ...etc. if after doing that the user still having the problem, then confirm the user's application is working as it should.

I hope it helps .. please rate it if it does !!!

New Member

Re: error :ora03114

Hi,

different vlans are getting this problem randomly like marketing ,stores etc

nothing to do with swtich mismatch

happens at various locations from time to time and resolves by itself

raj

New Member

Re: error :ora03114

Do you have application inspection for HTTP or IM turned on any interfaces or globally? I have experienced numerous random TCP connection issues when those two inspect commands are applied. Other forum posts indicate similar issues. The connections affected appear to be random and do not have to be the actual traffic matched in the class-map.

Try disabling those inpsect actions in the policy-map and see if it clears up. I would definitely try this if you have them enabled!

Andrew

New Member

Re: error :ora03114

Hi,

gets the user prior the error ORA-03113? We had this failure while an server-server-connection from one to another dmz (FWSM). The result of sniffer was: no disconnection of the tcp-session an an perpetual stream of TNS-traffic. The database-disconnect was restored within 1 second. The customer installed one server (for tests) in the same vlan (without firewall) and the error occured too.

I found this via google:

"ORA-03113 end-of-file on communication channel

Cause: An unexpected end-of-file was processed on the communication channel. The problem could not be handled by the Net8, two task, software. This message could occur if the shadow two-task process associated with a Net8 connect has terminated abnormally, or if there is a physical failure of the interprocess communication vehicle, that is, the network or server machine went down. In addition, this message could occur when ALTER SYSTEM KILL SESSION or ALTER SYSTEM DISCONNECT SESSION were issued with the IMMEDIATE qualifier because, in those cases, the client's connection to the database is terminated without waiting for the client to issue a request.

Action: If this message occurs during a connection attempt, check the setup files for the appropriate Net8 driver and confirm Net8 software is correctly installed on the server. If the message occurs after a connection is well established, and the error is not due to a physical failure, check if a trace file was generated on the server at failure time. Existence of a trace file may suggest an Oracle internal error that requires the assistance of customer support."

I hope this helps.

New Member

Re: error :ora03114

Hi,

Thanks for the reply.

I would check the policy map but that should not be the issue.

Other vlans are also facing the same problem .

The users get disconnected and get back connected again once they close the application will take captures and sylogs

Raj

757
Views
0
Helpful
5
Replies
CreatePlease login to create content