ORACLE DBA

Most of the DBA's struggle while setting up virtual box setup due to yum repository issues, here i am collected steps to setup yum repo we need to download  the repository config file (OEL6)   cd /etc/yum.repos.d/ wget http://yum.oracle.com/public-yum-ol6.repo Install Oracle 12cR1/12cR2, Based on your requirementw yum install --nogpgcheck oracle-rdbms-server-12cR1-preinstall yum install --nogpgcheck oracle-database-server-12cR2-preinstall yum install oracle-validated yum update Verifcation Step to install firefox  yum list yum install firefox Detailed information on http://public-yum.oracle.com/

SQL> select * from scott.newtab;     EMPNO ENAME      JOB              MGR HIREDATE         SAL       COMM     DEPTNO ---------- ---------- --------- ---------- --------- ---------- ---------- ----------       7369 SMITH      CLERK           7902 17-DEC-80        800                    20       7499 ALLEN      SALESMAN        7698 20-FEB-81       1600        300         30       7521 WARD       SALESMAN        7698 22-FEB-81       1250        500         30       7566 JONES      MANAGER         7839 02-APR-81       2975                    20       7654 MARTIN     SALESMAN        7698 28-SEP-81       1250       1400         30       7698 BLAKE      MANAGER         7839 01-MAY-81       2850                    30       7782 CLARK      MANAGER         7839 09-JUN-81       2450                    10       7788 SCOTT      ANALYST         7566 19-APR-87       3000                    20       7839 KING       PRESIDENT            17-NOV-81       5000                    10    

Change Protection Mode for Active Dataguard (11GR2) Primary Database :  TESTDB Standby Database :  TESTDBDR Database version   :  11gR2  The database is running under Maximum Performance mode. SQL> select status,instance_name,database_role,protection_mode from v$database,v$instance; STATUS INSTANCE_NAME DATABASE_ROLE PROTECTION_MODE ------ ------------- ------------- -------------------- OPEN    TESTDB        PRIMARY       MAXIMUM PERFORMANCE In order to change the protection mode to either MAXIMUM AVAILABILITY/MAXIMUM PROTECTION, we need to have the standby redo logs configured on the standby database. Also, the redo shippment parameter (log_archive_dest_2) on the primary database should be configured to use SYNCHRONOUS (“SYNC”) mode. Let’s check the number of online redo logs and it’s size on primary database SQL> select group#,bytes/1024/1024 from v$log; GROUP# BYTES/1024/1024 -