Re: I get grumpy when I see negative serial#''s in v$session_connect_info ...
From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Tue, 8 Feb 2011 10:15:11 -0800 (PST)
Message-ID: <5d042ea9-8f50-4316-a13d-925620843dea_at_q2g2000pre.googlegroups.com>
On Feb 8, 8:37 am, John Hurley <hurleyjo..._at_yahoo.com> wrote:
> ( Sorry a repeat of blog posting ... )
>
> 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.
Date: Tue, 8 Feb 2011 10:15:11 -0800 (PST)
Message-ID: <5d042ea9-8f50-4316-a13d-925620843dea_at_q2g2000pre.googlegroups.com>
On Feb 8, 8:37 am, John Hurley <hurleyjo..._at_yahoo.com> wrote:
> ( Sorry a repeat of blog posting ... )
>
> 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.
I do not remember ever seeing negative serial# in any of the v$session views. Interesting and probably a bug. I request you go ahead and enter a SR with support. Maybe by version 12.2 or 13.1 there will be a fix.
HTH -- Mark D Powell -- Received on Tue Feb 08 2011 - 12:15:11 CST