No question at this time
The DBA-Village forum
as RSS feed
Site StatisticsEver registered users | 48572 | Total active users | 1389 | Act. users last 24h | 2 | Act. users last hour | 0 | Registered user hits last week | 114 | Registered user hits last month | 299 |
|
Go up
dba_audit_session view in pluggable database
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 |
Subject: |
dba_audit_session view in pluggable database |
Author: |
rkl dba, United States |
Date: |
Sep 14, 2020, 20:01, 130 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, 130 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, 130 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, 130 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, 130 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
|