Database Administration (MOSC)

MOSC Banner

11.2.0.3 Delays in connecting to DB with sqlplus

edited Jun 19, 2018 12:40PM in Database Administration (MOSC) 5 commentsAnswered
Hi, just upgraded the DB to 11.2.0.3 and cloned it from RAC to single instance.

On that instance I eperience long delay of connection to the DB.

The symptoms are the same as in note 561429.1

From a client trace file:

[000001 13-NOV-2013 11:42:58:311] nsrdr: recving a packet
[000001 13-NOV-2013 11:42:58:311] nsprecv: entry
[000001 13-NOV-2013 11:42:58:311] nsprecv: reading from transport...
[000001 13-NOV-2013 11:42:58:311] nttrd: entry
[000001 13-NOV-2013 11:43:10:467] nttrd: socket 10 had bytes read=554
[000001 13-NOV-2013 11:43:10:467] nttrd: exit
[000001 13-NOV-2013 11:43:10:467] nsprecv: 554 bytes from transport
[000001 13-NOV-2013 11:43:10:467] nsprecv: tlen=554, plen=554, type=6
[000001 13-NOV-2013 11:43:10:467] nsprecv: packet dump

Is there any patch for this bug on 11.2.0.3 ?

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center