ADDM (Automatic Database Diagnostic Monitor) как его запустить?

    Что же делает этот ADDM? 

    ADDM анализирует данные из Automatic Workload Repository (AWR) и находит потенциальные узкие места. Для каждой найденной проблемы он попытается найти root cause и предоставить рекоммендации по ее устранению. 

    Как его запустить? 
Запустить его можно так:

1-й способ: из sqlplus запустить скрипт и следовать подсказкам.

Setup IP-address in Linux

1. Change the ifcfg-eth1 file

Open the ifcfg-eth1 file by using the editor "VI"
[root@oracledb01 ~]# vi /etc/sysconfig/network-scripts/ifcfg-eth1

Get location of REDO log files

    The most crucial structure for recovery operations is the redo log, which consists of two or more preallocated files that store all changes made to the database as they occur. 
    Every instance of an Oracle Database has an associated redo log to protect the database in case of an instance failure.
Get location of REDO log files:

SQL> select current_scn from v$database;

How to convert SCN to DATE and DATE to SCN

Sometimes it is very needed to convert SCN to DATE or DATE to SCN, so now I will tell you how to do it:

Get current SCN:
SQL> select current_scn from v$database;

7597825059

Convert SCN to DATE:
SQL> select scn_to_timestamp(7597825059) as timestamp from dual;

10-OCT-14 01.36.28.000000000 PM

Convert DATE TO SCN:
SQL> select timestamp_to_scn(to_timestamp('10/10/2014 10:24:54','DD/MM/YYYY HH24:MI:SS')) as scn from dual; 

7597430601

YUM repositories installation in RHEL and CENTOS

Hello,

Every Linux administrator should know how to install additional repositories for yum. So today I will tell to you how to do it.

1. Adding the RPMForge Repository

To Install Sourceforge repository use below download links.

CentOS/RHEL 6, 32 Bit (i686):
# rpm -Uvh http://packages.sw.be/rpmforge-release/rpmforge-release-0.5.3-1.el6.rf.i686.rpm

CentOS/RHEL 6, 64 Bit (x86_64):
# rpm -Uvh http://packages.sw.be/rpmforge-release/rpmforge-release-0.5.3-1.el6.rf.x86_64.rpm

CentOS/RHEL 5, 32 Bit (i386):
# rpm -Uvh http://packages.sw.be/rpmforge-release/rpmforge-release-0.5.3-1.el5.rf.i386.rpm

CentOS/RHEL 5, 64 Bit (x86_64):
# rpm -Uvh http://packages.sw.be/rpmforge-release/rpmforge-release-0.5.3-1.el5.rf.x86_64.rpm

2.Adding the EPEL Repository

To Install EPEL repository use below download links.

CentOS/RHEL 6, 32 Bit (i386):
# rpm -Uvh http://download.fedoraproject.org/pub/epel/6/i386/epel-release-6-8.noarch.rpm

CentOS/RHEL 6, 64 Bit x86_64):
# rpm -Uvh http://download.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm

CentOS/RHEL 5, 32 Bit (i386):
# rpm -Uvh http://dl.fedoraproject.org/pub/epel/5/i386/epel-release-5-4.noarch.rpm

CentOS/RHEL 5, 64 Bit (x86_64):
# rpm -Uvh http://dl.fedoraproject.org/pub/epel/5/x86_64/epel-release-5-4.noarch.rpm

3. Adding the REMI Repository

To Install REMI repository use below download links.

CentOS/RHEL 6, 32 Bit (i386):
# rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm 

CentOS/RHEL 6, 64 Bit (x86_64):
# rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm 

CentOS/RHEL 5, 32 Bit (i386):
# rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-5.rpm
 
CentOS/RHEL 5, 64 Bit (x86_64):
# rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-5.rpm

4.Addingthe Webtatic Repository

To Install webtatic repository use below download links.

CentOS/RHEL 6:
# rpm -Uvh http://repo.webtatic.com/yum/el6/latest.rpm

CentOS/RHEL 5:
# rpm -Uvh http://repo.webtatic.com/yum/centos/5/latest.rpm