Tuesday, February 8, 2011

I get grumpy when I see negative serial#'s in v$session_connect_info

This is almost enough to make a groundhog run for cover. Looking for sessions not using AES256 encryption ... running 11.1.0.7.5 ( patchset update about to go to 11.1.0.7.6 ).

This query shows rows from v$session_connect_info that have serial#'s less than zero.

select * from ( select sid, serial#, authentication_type, network_service_banner from v$session_connect_info where instr(network_service_banner,'AES256') > 0 ) where serial# < 1

SID,SERIAL#,AUTHENTICATION_TYPE,NETWORK_SERVICE_BANNER
5088,-21485,DATABASE,Oracle Advanced Security: AES256 encryption service adapter for Linux: Version 11.1.0.7.0 - Product
5301,-29006,DATABASE,Oracle Advanced Security: AES256 encryption service adapter for Linux: Version 11.1.0.7.0 - Product
5382,-26393,DATABASE,Oracle Advanced Security: AES256 encryption service adapter for Linux: Version 11.1.0.7.0 - Product

When I check these sessions against v$session the serial# looks ok ( not negative ).

select saddr, sid, serial#, username, osuser, type from v$session where
sid in ( select sid from
( select sid, serial#, authentication_type, network_service_banner from v$session_connect_info where instr(network_service_banner,'AES256') > 0 ) where serial# < 1 )

SADDR,SID,SERIAL#,USERNAME,OSUSER,TYPE
00000002D7C49DD0,5382,39143,I1236,whse,USER
00000002D792E920,5088,44051,I0952,sales,USER
00000002D7B6EC08,5301,36530,I5304,sales,USER

*** I guess I have to volley this over to Oracle Support I did not find anything relevant yet in my searches.

1 comment:

  1. Did you open a case with Oracle on this? I'm curious what their response was. Thanks.

    ReplyDelete