Daily Archives: March 26, 2014

How to enable Oracle Database Vault in Binary mode


Step1: Shutdow database SQL> shut imemdiate Step2: Stop dbconsole $ emctl stop dbconsole Step3: Stop Listener $ lsnrctl stop listener Step4: Enable database vault in binary mode cd $ORACLE_HOME/rdbms/lib make -f ins_rdbms.mk dv_on lbac_on ioracle

Oracle DBA Important Tables


v$database v$controlfile dba_data_files v$datafile dba_temp_files v$tempfile v$tempspace_header dba_users dba_db_links v$link dba_objects dba_tables dba_indexees dba_ind_columns dba_tab_columns dba_sequences dba_synonyms dba_source dba_views dba_errors dba_triggers dba_roles dba_role_privs session_roles dba_tablespaces dba_tab_privs role_tab_privs session_privs dba_ts_quotas dba_registry dba_rollback_segs dba_properties

Metalink Note


Database ******** NOTE.1012933.6 : General Information : Alert Logs and Trace Files NOTE.209870.1 : How to Reload the JVM in 9.2.0.X NOTE.175472.1 : How to Reload the JVM in 8.1.7.X NOTE.159143.1 : Separating Multiple 8i or 9i Oracle Versions to Avoid NOTE.307349.1 : OUI tips for Oracle RDBMS 10.1.X on OpenVMS NOTE.130814.1 : How to […]