CLIENT_IDENTIFIER Column Of V$SESSION Is Not Filled By RWSERVLET After Migration To 11G
(Doc ID 1638385.1)
Last updated on FEBRUARY 19, 2024
Applies to:
Oracle Reports Developer - Version 11.1.1.7.0 to 11.1.2.2.0 [Release 11g]Information in this document applies to any platform.
Symptoms
After migrating the enviroment from Oracle Portal 10g to Oracle Portal 11g, when running a report the column CLIENT_IDENTIFIER on v$session has no information.
CLIENT_IDENTIFIER column of V$SESSION is not filled by RWSERVLET after migration to 11G.
This column is used for the VPD function.
For Example, running the below script:
1 SET LINESIZE 500
2 SET PAGESIZE 1000
3 COLUMN username FORMAT A15
4 COLUMN machine FORMAT A25
5 COLUMN OSUSER FORMAT A15
6 COLUMN logon_time FORMAT A20
7 COLUMN CLIENT_IDENTIFIER FORMAT A20
8 COLUMN CLIENT_info FORMAT A40
9 SELECT s.inst_id,
10 NVL(s.username, '(oracle)') AS username,
11 s.osuser OSUSER,
12 s.sid,
13 s.serial#,
14 s.audsid,
15 p.spid,
16 last_call_et,
17 s.CLIENT_IDENTIFIER,
18 s.client_info,
19 s.status,
20 s.module,
21 s.machine,
22 s.program,
23 TO_CHAR(s.logon_Time,'DD-MON-YYYY HH24:MI:SS') AS logon_time,
24 sql_id,
25 sql_child_number,
26 s.lockwait
27 ,s.service_name
28 ,s.resource_consumer_group
29 FROM gv$session s,
30 gv$process p
31 WHERE s.paddr = p.addr
32 AND s.status = 'ACTIVE'
33 AND s.username is not null
34 AND s.username <> 'ORAWSM'
35 AND nvl(s.program,'x') not like '%O00%'
36 ORDER BY s.username,s.inst_id, s.osuser,s.last_call_et,s.audsid;
37* SET PAGESIZE 14
GENERATES THE BELOW OUTPUT
=======================
In Reports 11g:
INST_ID USERNAME OSUSER SID SERIAL# AUDSID SPID LAST_CALL_ET CLIENT_IDENTIFIER CLIENT_INFO STATUS MODULE
---------- --------------- --------------- ---------- ---------- ---------- ------------------------ ------------ -------------------- ---------------------------------------- -------- ---------------------------------------------
1 DEMO_USER demo.user 999 22222 99888888 27777 0 ACTIVE SQL*Plus
1 DEMO_USER demo.user 1888 51111 99888888 32222 0 ACTIVE SQL*Plus
1 DEMO_USER demo.user 1888 51111 99888888 17777 0 ACTIVE SQL*Plus
1 DEMO_USER demo.user 955 20685 99888888 17773 0 ACTIVE SQL*Plus
2 DEMO_USER demo.user 855 21403 99888888 27777 0 ACTIVE SQL*Plus
2 DEMO_USER demo.user 855 21403 99888888 17771 0 ACTIVE SQL*Plus
1 RDFSERVER oracle 1166 23135 99888888 3373 1 ACTIVE java@xxxx.oracle.com (TNS V1-V3)
In Reports 10g:
INST_ID USERNAME OSUSER SID SERIAL# AUDSID SPID LAST_CALL_ET CLIENT_IDENTIFIER CLIENT_INFO STATUS MODULE
---------- --------------- --------------- ---------- ---------- ---------- ------------------------ ------------ -------------------- ---------------------------------------- -------- ----------------------------------------------
1 DEMO_USER demo.user 666 688 97888888 10111 0 ACTIVE SQL*Plus
1 RDFSERVER oracle 599 44 97888887 9555 0 demo.user ACTIVE java@xxxx.oracle.com (TNS V1-V3)
Changes
Upgraded to Oracle Fusion Middleware 11g.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |