No question at this time
DBA Top 10
1 M. Cadot 10400
2 A. Kavsek 7600
3 B. Vroman 4800
4 P. Wisse 4000
5 J. Schnackenberg 3200
6 J. PĂ©ran 2200
7 T. Boles 600
8 Z. Hudec 400
8 G. Lambregts 400
8 N. Havard 400
8 F. Pachot 400
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48535
Total active users1398
Act. users last 24h2
Act. users last hour0
Registered user hits last week128
Registered user hits last month443
Go up

dba_audit_session view in pluggable database
Next thread: Do you have a trick for me ;-)
Prev thread: Oracle Interview Questions

Message Score Author Date
Dear All: we got a four node oracle rac of 19c und...... rkl dba Sep 14, 2020, 20:01
2 questions: - Are you sure you connect to Plug...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Michel Cadot Sep 14, 2020, 20:59
Michel, Thanks for being so quick and bless you...... rkl dba Sep 14, 2020, 21:42
>>> <i>do I need to explicitly run the audit c...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Michel Cadot Sep 14, 2020, 21:51
Michel, Thanks. I did try with one of sandbox a...... rkl dba Sep 15, 2020, 02:14

Follow up by mail Click here


Subject: dba_audit_session view in pluggable database
Author: rkl dba, United States
Date: Sep 14, 2020, 20:01, 11 days ago
Os info: LInux
Oracle info: 19c
Message: Dear All: we got a four node oracle rac of 19c under RedHat. We also built 2 pluggable [PlugA, PlugB] under the container database. Now the connections to the pluggables work fine, however for the PlugA, I could see the entries in dba_audit_session however the same view is blank for PlugB database. We are running several trials with jdbc and oracle net8 connections separately to PlugA and PlugB. but it is showing in PlugA as intended but missing in PlugB when running the dba_audit_session separately in each pluggable. both the case, the audit_tail parameter set to DB.

Any help, suggestions would be highly appreciated.

Thanks.
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: dba_audit_session view in pluggable database
Author: Michel Cadot, France
Date: Sep 14, 2020, 20:59, 10 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message:
2 questions:
- Are you sure you connect to PlugB?
- Are you sure sessions are audited in PlugB? (query dba_priv_audit_opts and dba_stmt_audit_opts)

Regards
Michel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: dba_audit_session view in pluggable database
Author: rkl dba, United States
Date: Sep 14, 2020, 21:42, 10 days ago
Message: Michel,

Thanks for being so quick and bless your heart. Now I do surely connect to PlugB and you are right: I don't see any entry in the dba_priv_audit_opts/dba_stmt_audit_opts. However I do see the entries in those two above views in PlugA.

Now to make sure,I do see them in the PlugB: do I need to explicitly run the audit command : audit create session

I wonder how it happens in PlugA but missed in PlugB when both using the same common user : system.

Thanks.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: dba_audit_session view in pluggable database
Author: Michel Cadot, France
Date: Sep 14, 2020, 21:51, 10 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message:

>>> do I need to explicitly run the audit command : audit create session

Yes or AUDIT SESSION which is the same thing (afaik).

Regards
Michel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: dba_audit_session view in pluggable database
Author: rkl dba, United States
Date: Sep 15, 2020, 02:14, 10 days ago
Message: Michel,

Thanks. I did try with one of sandbox and works out as intended. You are a life saver.

Thank you again for your kind attention and vast knowledge base. Please stay curious and help as you do always.

RKL
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here