Posted in 2016

Unified auditing



# Stop RAC DBs vom ORACLE_HOME, dass man relinkt

[oracle@rac2-pub ~]$ cd /u01/app/oracle/product/12.1.0.2/rdbms/lib/
[oracle@rac2-pub lib]$ make -f ins_rdbms.mk uniaud_on ioracle

# setasmgid wegen oracle:asmadmin auf oracle binary

[oracle@rac2-pub lib]$ su
Password: 
[root@rac2-pub lib]# /u01/app/12.1.0.2/grid/bin/setasmgid -o=/u01/app/oracle/product/12.1.0.2/bin/oracle
[root@rac2-pub lib]# ls -l /u01/app/oracle/product/12.1.0.2/bin/oracle
-rwsr-s--x. 1 oracle asmadmin 323795924 Apr  8 13:51 /u01/app/oracle/product/12.1.0.2/bin/oracle
[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 12.1.0.2.0 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 12.1.0.2.0 - 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';

PARAMETER	 VALUE
---------------- -----
Unified Auditing TRUE

Advertisements

Author:

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:

WordPress.com Logo

You are commenting using your WordPress.com 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