My customer wants to get some specific information from each database on regular basis. I was sure to be able doing that with Enterprise Manager, so the information would be stored in the repository.
Here how it is done:
(more…)This feature was just backported from Oracle 23ai. The new ORA$MANDATORY audit policy was added with the Oracle 19.26 RU. This policy is not visible at UNIFIED_AUDIT_POLICIES or AUDIT_UNIFIED_ENABLED_POLICIES.
After patching the database to 19.26, then you see entries on UNIFIED_AUDIT_TRAIL:
SYS@CDB2.CDB$ROOT> select EVENT_TIMESTMAP, SYSTEM_PRIVILEGE_USED, ACTION_NAME
from UNIFIED_AUDIT_TRAIL
where UNIFIED_AUDIT_POLICIES='ORA$MANDATORY'
order by EVENT_TIMESTMAP;
EVENT_TIMESTAMP SYSTEM_PRIVILEGE_USED ACTION_NAME
_________________________________ _________________________ _________________
02-FEB-2025 21:54:56.192982000 SYSDBA LOGON
02-FEB-2025 21:54:56.216549000 SYSDBA SELECT
02-FEB-2025 21:55:00.381577000 SYSDBA, ALTER DATABASE ALTER DATABASE
02-FEB-2025 21:55:00.393882000 SYSDBA LOGOFF
...
The actions that are audited by ORA$MANDATORY policy are described on Oracle 23ai documentation.
What I find interesting, is that the “ALTER DATABASE MOUNT” during startup is audited, so we can have a good history of database startups.
(more…)Goldengate Microservices architecture replaced the “ggsci” tool with “adminclient”. This new client has few limitations and does not work well with “rlwrap” – my favorite tool to have history between sessions.
The Adminclient provides some options you can easily change after starting the tool:
$ ./adminclient
...
OGG (not connected) 1> show
Current directory: /home/oracle
COLOR : OFF
DEBUG : OFF
EDITOR : vi
PAGER : more
VERBOSE : OFF
OGG (not connected) 2> set color ON
OGG (not connected) 3> set pager less
OGG (not connected) 4> show
Current directory: /home/oracle
COLOR : ON
DEBUG : OFF
EDITOR : vi
PAGER : less
VERBOSE : OFF
However to keep the settings across sessions it is not very straight forward. The way to do it is to set variables:
$ export ADMINCLIENT_COLOR=ON # ON, OFF in uppercase!
And ADMINCLIENT_DEBUG and ADMINCLIENT_VERBOSE for DEBUG and VERBOSE respectively
For the editor and pager, the variables are simply:
export EDITOR=nano
export PAGER=less
Attention that the variable EDITOR is used also by other clients, like sqlplus “edit” command.
So the way I do it, is to set everything within an alias:
alias gg="cd $OGG_HOME/bin; EDITOR=nano PAGER=less ADMINCLIENT_COLOR=ON $RLWRAP ./adminclient ; cd -"
And inside .bash_profile or something that sets the environment:
RLWRAP="$(command -v rlwrap)" && RLWRAP="${RLWRAP} -c"
export OGG_HOME="/u00/app/oracle/product/ogg/21.15"
alias gg="cd $OGG_HOME/bin; EDITOR=nano PAGER=less ADMINCLIENT_COLOR=ON $RLWRAP ./adminclient ; cd -"