jueves, 28 de octubre de 2010

ORACLE FGA

DESHABILITAR QUE EL USUARIO NO LE APLIQUEN LAS POLITICAS DE FGA

SQL> REVOKE EXEMPT ACCESS POLICY FROM HR;

Revoke succeeded.

SQL> GRANT EXEMPT ACCESS POLICY TO HR;

Grant succeeded.

SQL> REVOKE EXEMPT ACCESS POLICY FROM HR;

Revoke succeeded.

SQL> SELECT * FROM DBA_SYS_PRIVS WHERE PRIVILEGE LIKE '%EXE%';

viernes, 1 de octubre de 2010

Opatch Invoking OPatch

bash-3.00$ cd OPatch/

bash-3.00$ pwd
/u01/app/oracle/product/10.2.0/OPatch
bash-3.00$ ls
docs emdpatch.pl jlib opatch opatch.ini opatch.pl opatchprereqs
bash-3.00

$ opatch lsinventory
Invoking OPatch 10.2.0.4.3

Oracle Interim Patch Installer version 10.2.0.4.3
Copyright (c) 2007, Oracle Corporation. All rights reserved.


Oracle Home : /u01/app/oracle/product/10.2.0
Central Inventory : /u01/app/oracle/oraInventory
from : /var/opt/oracle/oraInst.loc
OPatch version : 10.2.0.4.3
OUI version : 10.2.0.4.0
OUI location : /u01/app/oracle/product/10.2.0/oui
Log file location : /u01/app/oracle/product/10.2.0/cfgtoollogs/opatch/opatch2010-10-01_17-32-41PM.log

Lsinventory Output file location : /u01/app/oracle/product/10.2.0/cfgtoollogs/opatch/lsinv/lsinventory2010-10-01_17-32-41PM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (2):

Oracle Database 10g 10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 3 10.2.0.4.0
There are 2 products installed in this Oracle Home.


There are no Interim patches installed in this Oracle Home.


--------------------------------------------------------------------------------

OPatch succeeded.
bash-3.00$