Database Networking (MOSC)

MOSC Banner

Oracle 12.1.0.2 database connections hanging at random times/regularly on multiple servers

edited Aug 15, 2019 5:00AM in Database Networking (MOSC) 11 commentsAnswered

Hi All,

We have a call open with Oracle support as we get issues with database connections hanging

When the issue occurs on one of our servers all connections fail to the database

sys/<pwd>@&lt;sid> as sysdba connections hang indefinately.

sys/<pwd> as sysdba work fine after setting oracle home and sid.

Restarting the listener/database does nothing. In fact the database does not stop via the services control panel and instead fails to stop and has to be killed via task manager.  We are on 12.1.0.2 and windows 2012 OS.

The issue occurs on multiple machines patches to the latest Oracle security patches (April 2019). Oracle support have suggested it could be IPV6 related as we get the following in the logs.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center