Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

v$session.audsid all of a sudden much higher after patch 19.21

Oracle Database Enterprise Edition 19

Hallo

As soon as RU 19.21 is applied al of a sudden v$session.audsid and sys_context('USERENV','SESSIONID') returns a much higher value.


-- before patching to 19.21 ( 19.20 )

SQL> select version_full from dba_registry where rownum = 1;

VERSION_FULL

------------------------------

19.20.0.0.0


SQL> conn dbsnmp

Enter password:

Connected.

SQL> select sys_context('USERENV','SESSIONID') from dual;


SYS_CONTEXT('USERENV','SESSIONID')

--------------------------------------------------------------------------------

638455


-- ( out of place with new Oracle home ) patched to 19.21

-- attach to 19.21 Home and run $ORACLE_HOME/OPatch/datapatch -verbose

sqlplus dbsnmp

SQL> select version_full from dba_registry where rownum = 1;

VERSION_FULL

------------------------------

19.21.0.0.0


SQL> select sys_context('USERENV','SESSIONID') from dual;

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