Go up

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......		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......		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:
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:
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