Bushmelev Anton
enable Oracle Label Security
Oracle Database 12c: Security 13 — 3 Enabling and Managing OLS •Register and enable OLS: – Using DBCA or – Executing the LBACSYS.CONFIGURE_OLS and LBACSYS.OLS_ENFORCEMENT.ENABLE_OLS procedures •The The LBACSYS schema owns all OLS objects. •Use Enterprise Manager Cloud Control (EMCC) SQL*Plus to manage the Label Security policies. •In PDBs, which canhttp://bushmelev-aa.ru/wp-admin/edit-tags.php?taxonomy=post_tag be plugged in and … Читать далее
Enable unified auditing option
https://blogs.oracle.com/imc/entry/oracle_database_12c_new_unified Enalbe unified audit 1.Stop all Oracle processes: databases, listener and Enterprise Manager. 2.Relink Oracle with the uniaud_on option. cd $ORACLE_HOME/rdbms/lib make -f ins_rdbms.mk uniaud_on ioracle check that option is enabled:
Duplicate ORA-17628: Oracle error 19505 returned by remote Oracle server
after check oracle binary group solution will be :
script to find locks in awr
result
How To Configure SSH for a RAC Installation [ID 300548.1]
How To Configure SSH for a RAC Installation [ID 300548.1]
qick config bash profile for oracle and grid user
Grid Oracle:
mac os x virtual box issue on oracle install
original at Can’t Compile GI 12.1.0.2 and Segmentation Fault quick fix
wait events with discriptions
original db file sequential reads Possible Causes : · Use of an unselective index · Fragmented Indexes · High I/O on a particular disk or mount point · Bad application design · Index reads performance can be affected by slow I/O subsystem and/or poor database files layout, which result in a higher average wait time … Читать далее
trace trigger
grant execute on dbms_monitor to some_user db username: Os username: