Posted in 2016

Unified auditing

# Stop RAC DBs vom ORACLE_HOME, dass man relinkt

[oracle@rac2-pub ~]$ cd /u01/app/oracle/product/
[oracle@rac2-pub lib]$ make -f uniaud_on ioracle

# setasmgid wegen oracle:asmadmin auf oracle binary

[oracle@rac2-pub lib]$ su
[root@rac2-pub lib]# /u01/app/ -o=/u01/app/oracle/product/
[root@rac2-pub lib]# ls -l /u01/app/oracle/product/
-rwsr-s--x. 1 oracle asmadmin 323795924 Apr  8 13:51 /u01/app/oracle/product/
[root@rac1-pub lib]# exit
[oracle@rac1-pub lib]$ srvctl start database -db racdb

# Verifikation sqlplus session zeigt jetzt Unified Auditing

[oracle@rac1-pub lib]$ sqlplus / as sysdba

SQL*Plus: Release Production on Fri Apr 8 13:56:16 2016

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to:
Oracle Database 12c Enterprise Edition Release - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics, Real Application Testing and Unified Auditing options

SQL> col parameter for a16
SQL> col value for a5
SQL> select parameter , value from v$option where PARAMETER = 'Unified Auditing';

---------------- -----
Unified Auditing TRUE



Database administrator who loves to work with Oracle software. (Sometimes not)

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s