Skip navigation.

Surachart Opun

Syndicate content
This page contains my experiences and my thoughts about Oracle and etc... about IT. Perhaps With another way in my life.
Updated: 5 hours 48 min ago

How Linux Works, 2nd Edition What Every Superuser Should Know by Brian Ward; No Starch Press

Sun, 2014-11-30 08:23
Everyone knows about Linux. It's a popular operating system that is the software on a computer that enables applications and the computer operator to access the devices on the computer to perform desired functions.
You can read more on link what I pointed to it. For me, Linux is a great operating system that I can use it as Desktop and Server. I have used it over ten years. It's very interesting operation system. I have used/worked it with many Open Source Software such as Apache HTTP, Bind, Sendmail, Postfix, Cyrus Imap, Samba and etc. It's operating system that I can play with programming languages as C, PHP, JAVA, Python, Perl and etc. I don't wanna say "too much".
Today, I have a chance to pick up some... a book that was written about Linux - How Linux Works, 2nd Edition What Every Superuser Should Know by Brian Ward. It's a cool book that you can learn about Linux as Starter and Linux Administrator. You could learn some things you have never used, but find in this book. It's fun to learn. However, A book, it's not support every skills in Linux. You will learn
  • How Linux boots, from boot loaders to init implementations (systemd, Upstart, and System V)
  • How the kernel manages devices, device drivers, and processes
  • How networking, interfaces, firewalls, and servers work
  • How development tools work and relate to shared libraries
  • How to write effective shell scripts 
It might not be something too much for learning as you are expecting. However, It 's a good book that you can enjoy to read a book about Linux. There's easy to read and understanding in a book. It's for some people who are starting with Linux and Linux Administrators who are enjoying to learn and want to get something new that can use in their fields.

Written By: Surachart Opun http://surachartopun.com
Categories: DBA Blogs

Oracle Database 12C Certified Professional SQL Foundations by Steve Ries; Infinite Skills

Wed, 2014-11-19 01:36
How to become Become an Oracle Certified Associate? That's a good question for some people who want to start working on Oracle Database and get first Oracle Certification for their work life. Step 1 - Pass one SQL Exam: Oracle Database 12c: SQL Fundamentals 1Z0-061 or Oracle Database 11g: SQL Fundamentals I 1Z0-051 or Oracle Database SQL Expert 1Z0-047. Step 2 - Pass Exam Oracle Database 12c: Installation and Administration 1Z0-062.
With Step 1 -  Oracle Database 12c: SQL Fundamentals 1Z0-061 exam that you should have skills SQL SELECT statement, subqueries, data manipulation, and data definition language. I was not encouraging to learn SQL SELECT statement, subqueries, data manipulation, data definition language and things like that, but in the real-world for working with Oracle Database you have to know them. You can read about them in Oracle Documents, Oracle Learning Library, Oracle University and the Internet. If you are looking for some video training that instruct you for Oracle Database SQL Foundations such as  sql-select, dml, ddl and etc. I mention Oracle Database - 12C Certified Professional SQL Foundations by Steve Ries. I watched it on O'reilly,that is very fast for streaming and downloading. The "Oracle Database - 12C Certified Professional SQL Foundations" video training, that helps learning Oracle Foundations looks easier (watch and do by own) and instructor spoke each topic very clear and easy for listening.

FYI, You can watch some free video.

Video Training: Oracle Database - 12C Certified Professional SQL Foundation
Instructor: Steve RiesWritten By: Surachart Opun http://surachartopun.com
Categories: DBA Blogs

Think Stats, 2nd Edition Exploratory Data Analysis By Allen B. Downey; O'Reilly Media

Mon, 2014-11-17 08:15
Lots of Python with data analysis books. This might be a good one that is able to help readers perform statistical analysis with programs written in Python. Think Stats, 2nd Edition Exploratory Data Analysis by Allen B. Downey(@allendowney).
This second edition of Think Stats includes the chapters from the first edition, many of them substantially revised, and new chapters on regression, time series analysis, survival analysis, and analytic methods. Additional, It uses uses pandas, SciPy, or StatsModels in Python. Author developed this book using Anaconda from Continuum Analytics. Readers should use it, that will easy from them. Anyway, I tested on Ubuntu and installed pandas, NumPy, SciPy, StatsModels, and matplotlib packages. This book has 14 chapters relate with processes that author works with a dataset. It's for intermediate reader. So, Readers should know how to program (In a book uses Python), and skill in mathematical + statistical.
Each chapter includes exercises that readers can practice and get more understood. Free Sampler
  • Develop an understanding of probability and statistics by writing and testing code.
  • Run experiments to test statistical behavior, such as generating samples from several distributions.
  • Use simulations to understand concepts that are hard to grasp mathematically.
  • Import data from most sources with Python, rather than rely on data that’s cleaned and formatted for statistics tools.
  • Use statistical inference to answer questions about real-world data.
surachart@surachart:~/ThinkStats2/code$ pwd
/home/surachart/ThinkStats2/code
surachart@surachart:~/ThinkStats2/code$ ipython notebook  --ip=0.0.0.0 --pylab=inline &
[1] 11324
surachart@surachart:~/ThinkStats2/code$ 2014-11-17 19:39:43.201 [NotebookApp] Using existing profile dir: u'/home/surachart/.config/ipython/profile_default'
2014-11-17 19:39:43.210 [NotebookApp] Using system MathJax
2014-11-17 19:39:43.234 [NotebookApp] Serving notebooks from local directory: /home/surachart/ThinkStats2/code
2014-11-17 19:39:43.235 [NotebookApp] The IPython Notebook is running at: http://0.0.0.0:8888/
2014-11-17 19:39:43.236 [NotebookApp] Use Control-C to stop this server and shut down all kernels (twice to skip confirmation).
2014-11-17 19:39:43.236 [NotebookApp] WARNING | No web browser found: could not locate runnable browser.
2014-11-17 19:39:56.120 [NotebookApp] Connecting to: tcp://127.0.0.1:38872
2014-11-17 19:39:56.127 [NotebookApp] Kernel started: f24554a8-539f-426e-9010-cb3aa3386613
2014-11-17 19:39:56.506 [NotebookApp] Connecting to: tcp://127.0.0.1:43369
2014-11-17 19:39:56.512 [NotebookApp] Connecting to: tcp://127.0.0.1:33239
2014-11-17 19:39:56.516 [NotebookApp] Connecting to: tcp://127.0.0.1:54395
Book: Think Stats, 2nd Edition Exploratory Data Analysis
Author: Allen B. Downey(@allendowney)Written By: Surachart Opun http://surachartopun.com
Categories: DBA Blogs

Getting Started with Impala Interactive SQL for Apache Hadoop by John Russell; O'Reilly Media

Sat, 2014-10-25 11:52
Impala is open source and a query engine that runs on Apache Hadoop. With Impala, you can query data, whether stored in HDFS or Apache HBase – including SELECT, JOIN, and aggregate functions – in real time. If you are looking for a book getting start with it - Getting Started with Impala Interactive SQL for Apache Hadoop by John Russell (@max_webster). Assist readers to write, tune, and port SQL queries and other statements for a Big Data environment, using Impala. The SQL examples in this book start from a simple base for easy comprehension, then build toward best practices that demonstrate high performance and scalability. For readers, you can download QuickStart VMs and install. After that, you can use it with examples in a book.
In a book, it doesn't assist readers to install Impala or how to solve the issue from installation or configuration. It has 5 chapters and not much for the number of pages, but enough to guide how to use Impala (Interactive SQL) and has good examples. With chapter 5 - Tutorials and Deep Dives, that it's highlight in a book and the example in a chapter that is very useful.
Free Sampler.

This book assists readers.
  • Learn how Impala integrates with a wide range of Hadoop components
  • Attain high performance and scalability for huge data sets on production clusters
  • Explore common developer tasks, such as porting code to Impala and optimizing performance
  • Use tutorials for working with billion-row tables, date- and time-based values, and other techniques
  • Learn how to transition from rigid schemas to a flexible model that evolves as needs change
  • Take a deep dive into joins and the roles of statistics
[test01:21000] > select "Surachart Opun" Name,  NOW() ;
Query: select "Surachart Opun" Name,  NOW()
+----------------+-------------------------------+
| name           | now()                         |
+----------------+-------------------------------+
| Surachart Opun | 2014-10-25 23:34:03.217635000 |
+----------------+-------------------------------+
Returned 1 row(s) in 0.14sBook: Getting Started with Impala Interactive SQL for Apache HadoopAuthor: John Russell (@max_webster)Written By: Surachart Opun http://surachartopun.com
Categories: DBA Blogs

Learning Spark Lightning-Fast Big Data Analytics by Holden Karau, Andy Konwinski, Patrick Wendell, Matei Zaharia; O'Reilly Media

Sat, 2014-10-18 12:45
Apache Spark started as a research project at UC Berkeley in the AMPLab, which focuses on big data analytics. Spark is an open source cluster computing platform designed to be fast and general-purpose for data analytics - It's both fast to run and write. Spark provides primitives for in-memory cluster computing: your job can load data into memory and query it repeatedly much quicker than with disk-based systems like Hadoop MapReduce. Users can write applications quickly in Java, Scala or Python. In additional, it's easy to run standalone or on EC2 or Mesos. It can read data from HDFS, HBase, Cassandra, and any Hadoop data source.
If you would like a book about Spark - Learning Spark Lightning-Fast Big Data Analytics by Holden Karau, Andy Konwinski, Patrick Wendell, Matei Zaharia. It's a great book for who is interested in Spark development and starting with it. Readers will learn how to express MapReduce jobs with just a few simple lines of Spark code and more...
  • Quickly dive into Spark capabilities such as collect, count, reduce, and save
  • Use one programming paradigm instead of mixing and matching tools such as Hive, Hadoop, Mahout, and S4/Storm
  • Learn how to run interactive, iterative, and incremental analyses
  • Integrate with Scala to manipulate distributed datasets like local collections
  • Tackle partitioning issues, data locality, default hash partitioning, user-defined partitioners, and custom serialization
  • Use other languages by means of pipe() to achieve the equivalent of Hadoop streaming
With Early Release - 7 chapters. Explained Apache Spark overview, downloading and commands that should know, programming with RDDS (+ more advance) as well as working with Key-Value Pairs, etc. Easy to read and Good examples in a book. For people who want to learn Apache Spark or use Spark for Data Analytic. It's a book, that should keep in shelf.

Book: Learning Spark Lightning-Fast Big Data Analytics
Authors: Holden KarauAndy KonwinskiPatrick WendellMatei ZahariaWritten By: Surachart Opun http://surachartopun.com
Categories: DBA Blogs

Using Flume - Flexible, Scalable, and Reliable Data Streaming by Hari Shreedharan; O'Reilly Media

Thu, 2014-10-09 02:37
Hadoop is an open-source software framework for storage and large-scale processing of data-sets on clusters of commodity hardware. How to deliver log to Hadoop HDFS. Apache Flume is open source to integrate with HDFS, HBASE and it's a good choice to implement for log data real-time collection from front end or log data system.
Apache Flume is a distributed, reliable, and available service for efficiently collecting, aggregating, and moving large amounts of log data.It uses a simple data model. Source => Channel => Sink
It's a good time to introduce a good book about Flume - Using Flume - Flexible, Scalable, and Reliable Data Streaming by Hari Shreedharan (@harisr1234). It was written with 8 Chapters: giving basic about Apache Hadoop and Apache HBase, idea for Streaming Data Using Apache Flume, about Flume Model (Sources, Channels, Sinks), and some moew for Interceptors, Channel Selectors, Sink Groups, and Sink Processors. Additional, Getting Data into Flume* and Planning, Deploying, and Monitoring Flume.

This book was written about how to use Flume. It's very good to guide about Apache Hadoop and Apache HBase before starting about Flume Data flow model. Readers should know about java code, because they will find java code example in a book and easy to understand. It's a good book for some people who want to deploy Apache Flume and custom components.
Author separated each Chapter for Flume Data flow model. So, Readers can choose each chapter to read for part of Data flow model: reader would like to know about Sink, then read Chapter 5 only until get idea. In addition, Flume has a lot of features, Readers will find example for them in a book. Each chapter has references topic, that readers can use it to find out more and very easy + quick to use in Ebook.
With Illustration in a book that is helpful with readers to see Big Picture using Flume and giving idea to develop it more in each System or Project.
So, Readers will be able to learn about operation and how to configure, deploy, and monitor a Flume cluster, and customize examples to develop Flume plugins and custom components for their specific use-cases.
  • Learn how Flume provides a steady rate of flow by acting as a buffer between data producers and consumers
  • Dive into key Flume components, including sources that accept data and sinks that write and deliver it
  • Write custom plugins to customize the way Flume receives, modifies, formats, and writes data
  • Explore APIs for sending data to Flume agents from your own applications
  • Plan and deploy Flume in a scalable and flexible way—and monitor your cluster once it’s running
Book: Using Flume - Flexible, Scalable, and Reliable Data Streaming
Author: Hari ShreedharanWritten By: Surachart Opun http://surachartopun.com
Categories: DBA Blogs

rsyslog: Send logs to Flume

Mon, 2014-10-06 04:12
Good day for learning something new. After read Flume book, that something popped up in my head. Wanted to test "rsyslog" => Flume => HDFS. As we know, forwarding log to other systems. We can set rsyslog:
*.* @YOURSERVERADDRESS:YOURSERVERPORT ## for UDP
*.* @@YOURSERVERADDRESS:YOURSERVERPORT ## for TCPFor rsyslog:
[root@centos01 ~]# grep centos /etc/rsyslog.conf
*.* @centos01:7777Came back to Flume, I used Simple Example for reference and changed a bit. Because I wanted it write to HDFS.
[root@centos01 ~]# grep "^FLUME_AGENT_NAME\="  /etc/default/flume-agent
FLUME_AGENT_NAME=a1
[root@centos01 ~]# cat /etc/flume/conf/flume.conf
# example.conf: A single-node Flume configuration
# Name the components on this agent
a1.sources = r1
a1.sinks = k1
a1.channels = c1
# Describe/configure the source
#a1.sources.r1.type = netcat
a1.sources.r1.type = syslogudp
a1.sources.r1.bind = 0.0.0.0
a1.sources.r1.port = 7777
# Describe the sink
#a1.sinks.k1.type = logger
a1.sinks.k1.type = hdfs
a1.sinks.k1.hdfs.path = hdfs://localhost:8020/user/flume/syslog/%Y/%m/%d/%H/
a1.sinks.k1.hdfs.fileType = DataStream
a1.sinks.k1.hdfs.writeFormat = Text
a1.sinks.k1.hdfs.batchSize = 10000
a1.sinks.k1.hdfs.rollSize = 0
a1.sinks.k1.hdfs.rollCount = 10000
a1.sinks.k1.hdfs.filePrefix = syslog
a1.sinks.k1.hdfs.round = true


# Use a channel which buffers events in memory
a1.channels.c1.type = memory
a1.channels.c1.capacity = 1000
a1.channels.c1.transactionCapacity = 100
# Bind the source and sink to the channel
a1.sources.r1.channels = c1
a1.sinks.k1.channel = c1
[root@centos01 ~]# /etc/init.d/flume-agent start
Flume NG agent is not running                              [FAILED]
Starting Flume NG agent daemon (flume-agent):              [  OK  ]Tested to login by ssh.
[root@centos01 ~]#  tail -0f  /var/log/flume/flume.log
06 Oct 2014 16:35:40,601 INFO  [hdfs-k1-call-runner-0] (org.apache.flume.sink.hdfs.BucketWriter.doOpen:208)  - Creating hdfs://localhost:8020/user/flume/syslog/2014/10/06/16//syslog.1412588139067.tmp
06 Oct 2014 16:36:10,957 INFO  [hdfs-k1-roll-timer-0] (org.apache.flume.sink.hdfs.BucketWriter.renameBucket:427)  - Renaming hdfs://localhost:8020/user/flume/syslog/2014/10/06/16/syslog.1412588139067.tmp to hdfs://localhost:8020/user/flume/syslog/2014/10/06/16/syslog.1412588139067
[root@centos01 ~]# hadoop fs -ls hdfs://localhost:8020/user/flume/syslog/2014/10/06/16/syslog.1412588139067
14/10/06 16:37:31 WARN util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable
Found 1 items
-rw-r--r--   1 flume supergroup        299 2014-10-06 16:36 hdfs://localhost:8020/user/flume/syslog/2014/10/06/16/syslog.1412588139067
[root@centos01 ~]#
[root@centos01 ~]#
[root@centos01 ~]# hadoop fs -cat hdfs://localhost:8020/user/flume/syslog/2014/10/06/16/syslog.1412588139067
14/10/06 16:37:40 WARN util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable
sshd[20235]: Accepted password for surachart from 192.168.111.16 port 65068 ssh2
sshd[20235]: pam_unix(sshd:session): session opened for user surachart by (uid=0)
su: pam_unix(su-l:session): session opened for user root by surachart(uid=500)
su: pam_unix(su-l:session): session closed for user rootLook good... Anyway, It needs to adapt more...



Written By: Surachart Opun http://surachartopun.com
Categories: DBA Blogs

Packt Publishing - ALL eBooks and Videos are just $10 each or less until the 2nd of October

Tue, 2014-09-30 10:36
Just spread good campaign from Packt Publishing - It's a good news for people who love to learn something new - ALL eBooks and Videos are just $10 or less -- the more you choose to learn, the more you save:
  • Any 1 or 2 eBooks/Videos -- $10 each
  • Any 3-5 eBooks/Videos -- $8 each
  • Any 6 or more eBooks/Videos -- $6 each


Written By: Surachart Opun http://surachartopun.com
Categories: DBA Blogs

I Heart Logs - Event Data, Stream Processing, and Data Integration by Jay Kreps; O'Reilly Media

Fri, 2014-09-26 23:01
As I have worked in server-side a long time as System Administrator. I must spend with logs. To use it for checking and investigation in issue. As some policies in some Companies, they want to keep logs over year or over ten years. So, it is not unusual to find out idea to store, integrate logs and do something.
A book tittle "I Heart Logs - Event Data, Stream Processing, and Data Integration" by Jay Kreps. It's very interesting. I'd like to know what I can learn from it, how logs work in distributed systems and learn from author who works at LinkedIn. A book! Not much for the number of pages. However, it gives much more for data flow idea, how logs work and author still shows readers why logs are worthy of reader's attention. In a book, that has only 4 chapters, but readers will get concept and idea about Data integration (Making all of an organization’s data easily available in all its storage and processing systems), Real-time data processing (Computing derived data streams) and Distributed system design (How practical systems can by simplified with a log-centric design). In addition, I like it. because author wrote from his experience at LinkedIn.

After reviewing: A book refers a lot of information(It's easy on ebook to click links) that's useful. Readers can use them and find out more on the Internet and use. For Data integration, It's focused to Kafka software that is a distributed, partitioned, replicated commit log service. It provides the functionality of a messaging system. Additional, It gave why the Big Data Lambda Architecture is good for batch system and a stream processing system and point about things a log can do.

So, Readers will be able to learn:
  • Learn how logs are used for programmatic access in databases and distributed systems
  • Discover solutions to the huge data integration problem when more data of more varieties meet more systems
  • Understand why logs are at the heart of real-time stream processing
  • Learn the role of a log in the internals of online data systems
  • Explore how Jay Kreps applies these ideas to his own work on data infrastructure systems at LinkedIn
Book - I Heart Logs - Event Data, Stream Processing, and Data Integration
Author: Jay KrepsWritten By: Surachart Opun http://surachartopun.com
Categories: DBA Blogs

Where is my space on Linux filesystem?

Mon, 2014-09-22 05:06
Not Often, I checked about my space after made filesystem on Linux. Today, I have made Ext4 filesystem around 460GB, I found it 437GB only. Some path should be 50GB, but it was available only 47GB.
Thank You @OracleAlchemist and @gokhanatil for good information about it.
Filesystem                   Size  Used Avail Use% Mounted on
/dev/mapper/VolGroup0-U01LV   50G   52M   47G   1% /u01
Reference  - It's for specify the percentage of the filesystem blocks reserved for the super-user. This avoids fragmentation, and allows root-owned daemons, such as syslogd(8), to continue to function correctly after non-privileged processes are prevented from writing to the  filesystem. The default percentage is 5%.After I found out more information. Look like we can set it to zero, but we should not set it to zero for /,/var,/tmp or which path has lots of file creates and deletes.Reference on RedHatIf you set the reserved block count to zero, it won't affect
performance much except if you run for long periods of time (with lots
of file creates and deletes) while the filesystem is almost full
(i.e., say above 95%), at which point you'll be subject to
fragmentation problems.  Ext4's multi-block allocator is much more
fragmentation resistant, because it tries much harder to find
contiguous blocks, so even if you don't enable the other ext4
features, you'll see better results simply mounting an ext3 filesystem
using ext4 before the filesystem gets completely full.
If you are just using the filesystem for long-term archive, where
files aren't changing very often (i.e., a huge mp3 or video store), it
obviously won't matter.
- TedExample: Changed reserved-blocks-percentage [root@mytest01 u01]# df -h /u01
Filesystem                   Size  Used Avail Use% Mounted on
/dev/mapper/VolGroup0-U01LV   50G   52M   47G   1% /u01
[root@mytest01 u01]# tune2fs -m 1 /dev/mapper/VolGroup0-U01LV
tune2fs 1.43-WIP (20-Jun-2013)
Setting reserved blocks percentage to 1% (131072 blocks)
[root@mytest01 u01]# df -h /u01
Filesystem                   Size  Used Avail Use% Mounted on
/dev/mapper/VolGroup0-U01LV   50G   52M   49G   1% /u01
[root@mytest01 u01]# tune2fs -m 5 /dev/mapper/VolGroup0-U01LV
tune2fs 1.43-WIP (20-Jun-2013)
Setting reserved blocks percentage to 5% (655360 blocks)
[root@mytest01 u01]# df -h /u01
Filesystem                   Size  Used Avail Use% Mounted on
/dev/mapper/VolGroup0-U01LV   50G   52M   47G   1% /u01Finally, I knew it was reserved for super-user. Checked more for calculation.
[root@ottuatdb01 ~]# df -m /u01
Filesystem                  1M-blocks  Used Available Use% Mounted on
/dev/mapper/VolGroup0-U01LV     50269    52     47657   1% /u01
[root@ottuatdb01 ~]#  tune2fs -l /dev/mapper/VolGroup0-U01LV |egrep  'Block size|Reserved block count'
Reserved block count:     655360
Block size:               4096

Available = 47657MB
Used = 52M
Reserved Space = (655360 x 4096) / 1024 /1024 = 2560MB 
Total = 47657 + 2560 + 52 = 50269 

OK.. I felt good after it cleared for me. Somehow, I believe On Hug space, 5% of the filesystem blocks reserved that's too much. We can reduce it.

Other Links:
https://www.redhat.com/archives/ext3-users/2009-January/msg00026.html
http://unix.stackexchange.com/questions/7950/reserved-space-for-root-on-a-filesystem-why
http://linux.die.net/man/8/tune2fs
https://wiki.archlinux.org/index.php/ext4#Remove_reserved_blocks

Written By: Surachart Opun http://surachartopun.com
Categories: DBA Blogs

Extend linux partition on vmware

Mon, 2014-09-22 02:24
It was a quiet day, I worked as System Administrator and installed Oracle Linux on Virtual Machine guest. After installed Operating System, I wanted to extend disk on guest. So, I extended disk on guest. Anyway, I came back in my head what I was supposed to do on Linux then ? - Create new disk (and Physical Volume) and then add in Volume Group.http://surachartopun.com/2012/01/just-add-disk-to-volume-group-linux.htmlChecked my partition:[root@mytest01 ~]# fdisk -l /dev/sda
Disk /dev/sda: 697.9 GB, 697932185600 bytes
255 heads, 63 sectors/track, 84852 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x00061d87
   Device Boot      Start         End      Blocks   Id  System
/dev/sda1   *           1         131     1048576   83  Linux
Partition 1 does not end on cylinder boundary.
/dev/sda2             131       78326   628096000   8e  Linux LVM
[root@mytest01 ~]# pvdisplay
  --- Physical volume ---
  PV Name               /dev/sda2
  VG Name               VolGroup0
  PV Size               599.00 GiB / not usable 3.00 MiB
  Allocatable           yes (but full)
  PE Size               4.00 MiB
  Total PE              153343
  Free PE               0
  Allocated PE          153343
  PV UUID               AcujnG-5XVc-TWWl-O4Oe-Nv03-rJtc-b5jUlWI thought I should be able to extend (resize) /dev/sda2 - Found out on the Internet, get some example.http://unix.stackexchange.com/questions/42857/how-to-extend-centos-5-partition-on-vmware
- Extend Physical Volume (Chose this idea)
Started to do it: Idea is Deleting/Recreating/run "pvresize".[root@mytest01 ~]# fdisk /dev/sda
WARNING: DOS-compatible mode is deprecated. It's strongly recommended to
         switch off the mode (command 'c') and change display units to
         sectors (command 'u').
Command (m for help): p
Disk /dev/sda: 697.9 GB, 697932185600 bytes
255 heads, 63 sectors/track, 84852 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x00061d87
   Device Boot      Start         End      Blocks   Id  System
/dev/sda1   *           1         131     1048576   83  Linux
Partition 1 does not end on cylinder boundary.
/dev/sda2             131       78326   628096000   8e  Linux LVM
Command (m for help): d
Partition number (1-4): 2
Command (m for help): p
Disk /dev/sda: 697.9 GB, 697932185600 bytes
255 heads, 63 sectors/track, 84852 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x00061d87
   Device Boot      Start         End      Blocks   Id  System
/dev/sda1   *           1         131     1048576   83  Linux
Partition 1 does not end on cylinder boundary.
Command (m for help): n
Command action
   e   extended
   p   primary partition (1-4)
p
Partition number (1-4): 2
First cylinder (131-84852, default 131):
Using default value 131
Last cylinder, +cylinders or +size{K,M,G} (131-84852, default 84852):
Using default value 84852
Command (m for help): p
Disk /dev/sda: 697.9 GB, 697932185600 bytes
255 heads, 63 sectors/track, 84852 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x00061d87
   Device Boot      Start         End      Blocks   Id  System
/dev/sda1   *           1         131     1048576   83  Linux
Partition 1 does not end on cylinder boundary.
/dev/sda2             131       84852   680524090   83  Linux
Command (m for help): t
Partition number (1-4): 2
Hex code (type L to list codes): L
 0  Empty           24  NEC DOS         81  Minix / old Lin bf  Solaris
 1  FAT12           39  Plan 9          82  Linux swap / So c1  DRDOS/sec (FAT-
 2  XENIX root      3c  PartitionMagic  83  Linux           c4  DRDOS/sec (FAT-
 3  XENIX usr       40  Venix 80286     84  OS/2 hidden C:  c6  DRDOS/sec (FAT-
 4  FAT16 <32m 85="" boot="" br="" c7="" extended="" inux="" nbsp="" prep="" yrinx=""> 5  Extended        42  SFS             86  NTFS volume set da  Non-FS data
 6  FAT16           4d  QNX4.x          87  NTFS volume set db  CP/M / CTOS / .
 7  HPFS/NTFS       4e  QNX4.x 2nd part 88  Linux plaintext de  Dell Utility
 8  AIX             4f  QNX4.x 3rd part 8e  Linux LVM       df  BootIt
 9  AIX bootable    50  OnTrack DM      93  Amoeba          e1  DOS access
 a  OS/2 Boot Manag 51  OnTrack DM6 Aux 94  Amoeba BBT      e3  DOS R/O
 b  W95 FAT32       52  CP/M            9f  BSD/OS          e4  SpeedStor
 c  W95 FAT32 (LBA) 53  OnTrack DM6 Aux a0  IBM Thinkpad hi eb  BeOS fs
 e  W95 FAT16 (LBA) 54  OnTrackDM6      a5  FreeBSD         ee  GPT
 f  W95 Ext'd (LBA) 55  EZ-Drive        a6  OpenBSD         ef  EFI (FAT-12/16/
10  OPUS            56  Golden Bow      a7  NeXTSTEP        f0  Linux/PA-RISC b
11  Hidden FAT12    5c  Priam Edisk     a8  Darwin UFS      f1  SpeedStor
12  Compaq diagnost 61  SpeedStor       a9  NetBSD          f4  SpeedStor
14  Hidden FAT16 <3 63="" ab="" arwin="" boot="" br="" f2="" hurd="" nbsp="" or="" secondary="" sys="">16  Hidden FAT16    64  Novell Netware  af  HFS / HFS+      fb  VMware VMFS
17  Hidden HPFS/NTF 65  Novell Netware  b7  BSDI fs         fc  VMware VMKCORE
18  AST SmartSleep  70  DiskSecure Mult b8  BSDI swap       fd  Linux raid auto
1b  Hidden W95 FAT3 75  PC/IX           bb  Boot Wizard hid fe  LANstep
1c  Hidden W95 FAT3 80  Old Minix       be  Solaris boot    ff  BBT
1e  Hidden W95 FAT1
Hex code (type L to list codes): 8e
Changed system type of partition 2 to 8e (Linux LVM)
Command (m for help): p
Disk /dev/sda: 697.9 GB, 697932185600 bytes
255 heads, 63 sectors/track, 84852 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x00061d87
   Device Boot      Start         End      Blocks   Id  System
/dev/sda1   *           1         131     1048576   83  Linux
Partition 1 does not end on cylinder boundary.
/dev/sda2             131       84852   680524090   8e  Linux LVM
Command (m for help): w
The partition table has been altered!
Calling ioctl() to re-read partition table.
WARNING: Re-reading the partition table failed with error 16: Device or resource busy.
The kernel still uses the old table. The new table will be used at
the next reboot or after you run partprobe(8) or kpartx(8)
Syncing disks. -- I chose to "Reboot" :-) --[root@mytest01 ~]# pvdisplay
  --- Physical volume ---
  PV Name               /dev/sda2
  VG Name               VolGroup0
  PV Size               599.00 GiB / not usable 3.00 MiB
  Allocatable           yes (but full)
  PE Size               4.00 MiB
  Total PE              153343
  Free PE               0
  Allocated PE          153343
  PV UUID               AcujnG-5XVc-TWWl-O4Oe-Nv03-rJtc-b5jUlW
[root@mytest01 ~]# pvresize /dev/sda2
  Physical volume "/dev/sda2" changed
  1 physical volume(s) resized / 0 physical volume(s) not resized
[root@mytest01 ~]# pvdisplay
  --- Physical volume ---
  PV Name               /dev/sda2
  VG Name               VolGroup0
  PV Size               599.00 GiB / not usable 2.00 MiB
  Allocatable           yes (but full)
  PE Size               4.00 MiB
  Total PE              153343
  Free PE               0
  Allocated PE          153343
  PV UUID               AcujnG-5XVc-TWWl-O4Oe-Nv03-rJtc-b5jUlW
[root@mytest01 ~]#
[root@mytest01 ~]# reboot
.
.
.
[root@mytest01 ~]# pvdisplay
  --- Physical volume ---
  PV Name               /dev/sda2
  VG Name               VolGroup0
  PV Size               599.00 GiB / not usable 2.00 MiB
  Allocatable           yes (but full)
  PE Size               4.00 MiB
  Total PE              153343
  Free PE               0
  Allocated PE          153343
  PV UUID               AcujnG-5XVc-TWWl-O4Oe-Nv03-rJtc-b5jUlW
[root@mytest01 ~]# pvresize  /dev/sda2
  Physical volume "/dev/sda2" changed
  1 physical volume(s) resized / 0 physical volume(s) not resized
[root@mytest01 ~]# pvdisplay
  --- Physical volume ---
  PV Name               /dev/sda2
  VG Name               VolGroup0
  PV Size               649.00 GiB / not usable 1.31 MiB
  Allocatable           yes
  PE Size               4.00 MiB
  Total PE              166143
  Free PE               12800
  Allocated PE          153343
  PV UUID               AcujnG-5XVc-TWWl-O4Oe-Nv03-rJtc-b5jUlWNote: This case I had 2 partitions (/dev/sda1, /dev/sda2). So, it was a good idea extending Physical Disk. However, I thought creating physical volume and adding in Volume Group, that might be safer. 
Finally, I had VolGroup0 with new size, then extended Logical Volume.[root@mytest01 ~]# df -h /u02
Filesystem                   Size  Used Avail Use% Mounted on
/dev/mapper/VolGroup0-U02LV  460G   70M  437G   1% /u02
[root@mytest01 ~]# lvdisplay /dev/mapper/VolGroup0-U02LV
  --- Logical volume ---
  LV Path                /dev/VolGroup0/U02LV
  LV Name                U02LV
  VG Name                VolGroup0
  LV UUID                8Gdt6C-ZXQe-dPYi-21yj-Fs0i-6uvE-vzrCbc
  LV Write Access        read/write
  LV Creation host, time mytest01.pythian.com, 2014-09-21 16:43:50 -0400
  LV Status              available
  # open                 1
  LV Size                467.00 GiB
  Current LE             119551
  Segments               1
  Allocation             inherit
  Read ahead sectors     auto
  - currently set to     256
  Block device           252:2

[root@mytest01 ~]#
[root@mytest01 ~]# vgdisplay
  --- Volume group ---
  VG Name               VolGroup0
  System ID
  Format                lvm2
  Metadata Areas        1
  Metadata Sequence No  7
  VG Access             read/write
  VG Status             resizable
  MAX LV                0
  Cur LV                4
  Open LV               3
  Max PV                0
  Cur PV                1
  Act PV                1
  VG Size               649.00 GiB
  PE Size               4.00 MiB
  Total PE              166143
  Alloc PE / Size       153343 / 599.00 GiB
  Free  PE / Size       12800 / 50.00 GiB
  VG UUID               thGxdJ-pCi2-18S0-mrZc-cCJM-2SH2-JRpfQ5
[root@mytest01 ~]#
[root@mytest01 ~]# -- Should use "e2fsck" in case resize (shrink). This case no need.
[root@mytest01 ~]# e2fsck -f  /dev/mapper/VolGroup0-U02LV 
e2fsck 1.43-WIP (20-Jun-2013)
Pass 1: Checking inodes, blocks, and sizes
Pass 2: Checking directory structure
Pass 3: Checking directory connectivity
Pass 4: Checking reference counts
Pass 5: Checking group summary information
/dev/mapper/VolGroup0-U02LV: 11/30605312 files (0.0% non-contiguous), 1971528/122420224 blocks
[root@mytest01 ~]#
[root@mytest01 ~]# pvscan
  PV /dev/sda2   VG VolGroup0   lvm2 [649.00 GiB / 50.00 GiB free]
  Total: 1 [649.00 GiB] / in use: 1 [649.00 GiB] / in no VG: 0 [0   ]
[root@mytest01 ~]#
[root@mytest01 ~]#
[root@mytest01 ~]# lvextend -L +50G /dev/mapper/VolGroup0-U02LV
  Extending logical volume U02LV to 517.00 GiB
  Logical volume U02LV successfully resized
[root@mytest01 ~]#
[root@mytest01 ~]#  resize2fs /dev/mapper/VolGroup0-U02LV
resize2fs 1.43-WIP (20-Jun-2013)
Resizing the filesystem on /dev/mapper/VolGroup0-U02LV to 135527424 (4k) blocks.
The filesystem on /dev/mapper/VolGroup0-U02LV is now 135527424 blocks long.
[root@mytest01 ~]#
[root@mytest01 ~]#
[root@mytest01 ~]# lvdisplay /dev/mapper/VolGroup0-U02LV
  --- Logical volume ---
  LV Path                /dev/VolGroup0/U02LV
  LV Name                U02LV
  VG Name                VolGroup0
  LV UUID                8Gdt6C-ZXQe-dPYi-21yj-Fs0i-6uvE-vzrCbc
  LV Write Access        read/write
  LV Creation host, time mytest01.pythian.com, 2014-09-21 16:43:50 -0400
  LV Status              available
  # open                 0
  LV Size                517.00 GiB
  Current LE             132351
  Segments               2
  Allocation             inherit
  Read ahead sectors     auto
  - currently set to     256
  Block device           252:2
[root@mytest01 ~]#

[root@mytest01 ~]# df -h /u02
Filesystem                   Size  Used Avail Use% Mounted on
/dev/mapper/VolGroup0-U02LV  509G   70M  483G   1% /u02https://access.redhat.com/documentation/en-US/Red_Hat_Enterprise_Linux/6/html/Storage_Administration_Guide/ext4grow.html
Note: resize2fs can use online, If the filesystem is mounted, it  can  be  used  to expand  the size of the mounted filesystem, assuming the kernel supports on-line resizing.  (As of this writing, the Linux 2.6 kernel supports on-line resize for filesystems mounted using ext3 and ext4.).
Look like today, I learned too much about linux partitioning. Written By: Surachart Opun http://surachartopun.com
Categories: DBA Blogs

Switch CentOS to Oracle Linux - centos2ol.sh

Fri, 2014-09-19 04:15
My time has used much with Linux. Some people asked to move from CentOS to Oracle Linux somehow. I used to believe it easy to do like that. Anyway, It'd better to test. I focused on 2 links.
https://linux.oracle.com/switch/centos/
http://docs.oracle.com/cd/E37670_01/E37355/html/ol_switch_yum.html

Oracle introduces centos2ol.sh script that can convert CentOS 5 and 6 systems to Oracle Linux. After that run "yum upgrade" again.
[root@test-centos ~]# uname -r
2.6.32-431.29.2.el6.x86_64
[root@test-centos ~]# cat /etc/centos-release
CentOS release 6.5 (Final)
[root@test-centos ~]# curl -O https://linux.oracle.com/switch/centos2ol.sh
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
100  6523  100  6523    0     0   3453      0  0:00:01  0:00:01 --:--:-- 17534
[root@test-centos ~]# sh centos2ol.sh
Checking for required packages...
Checking your distribution...
Looking for yumdownloader...
Finding your repository directory...
Downloading Oracle Linux yum repository file...
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
100  4233  100  4233    0     0   3507      0  0:00:01  0:00:01 --:--:--  4724
Removing unsupported packages...
Loaded plugins: fastestmirror, security
Setting up Remove Process
Resolving Dependencies
--> Running transaction check
---> Package libreport-plugin-rhtsupport.x86_64 0:2.0.9-19.el6.centos will be erased
--> Processing Dependency: libreport-plugin-rhtsupport = 2.0.9-19.el6.centos for package: libreport-compat-2.0.9-19.el6.centos.x86_64
--> Processing Dependency: libreport-plugin-rhtsupport for package: abrt-cli-2.0.8-21.el6.centos.x86_64
--> Processing Dependency: libreport-plugin-rhtsupport = 2.0.9-19.el6.centos for package: libreport-python-2.0.9-19.el6.centos.x86_64
--> Running transaction check
---> Package abrt-cli.x86_64 0:2.0.8-21.el6.centos will be erased
---> Package libreport-compat.x86_64 0:2.0.9-19.el6.centos will be erased
--> Processing Dependency: libreport-compat = 2.0.9-19.el6.centos for package: libreport-2.0.9-19.el6.centos.x86_64
---> Package libreport-python.x86_64 0:2.0.9-19.el6.centos will be erased
--> Running transaction check
---> Package libreport.x86_64 0:2.0.9-19.el6.centos will be erased
--> Processing Dependency: libabrt_dbus.so.0()(64bit) for package: abrt-2.0.8-21.el6.centos.x86_64
--> Processing Dependency: libabrt_web.so.0()(64bit) for package: libreport-plugin-kerneloops-2.0.9-19.el6.centos.x86_64
--> Processing Dependency: libabrt_web.so.0()(64bit) for package: libreport-plugin-reportuploader-2.0.9-19.el6.centos.x86_64
--> Processing Dependency: libreport.so.0()(64bit) for package: libreport-plugin-logger-2.0.9-19.el6.centos.x86_64
--> Processing Dependency: libreport.so.0()(64bit) for package: libreport-plugin-kerneloops-2.0.9-19.el6.centos.x86_64
--> Processing Dependency: libreport.so.0()(64bit) for package: abrt-libs-2.0.8-21.el6.centos.x86_64
--> Processing Dependency: libreport.so.0()(64bit) for package: abrt-addon-python-2.0.8-21.el6.centos.x86_64
--> Processing Dependency: libreport.so.0()(64bit) for package: libreport-cli-2.0.9-19.el6.centos.x86_64
--> Processing Dependency: libreport.so.0()(64bit) for package: abrt-2.0.8-21.el6.centos.x86_64
--> Processing Dependency: libreport.so.0()(64bit) for package: abrt-tui-2.0.8-21.el6.centos.x86_64
--> Processing Dependency: libreport.so.0()(64bit) for package: abrt-addon-ccpp-2.0.8-21.el6.centos.x86_64
--> Processing Dependency: libreport.so.0()(64bit) for package: libreport-plugin-mailx-2.0.9-19.el6.centos.x86_64
--> Processing Dependency: libreport.so.0()(64bit) for package: libreport-plugin-reportuploader-2.0.9-19.el6.centos.x86_64
--> Processing Dependency: libreport.so.0()(64bit) for package: abrt-addon-kerneloops-2.0.8-21.el6.centos.x86_64
--> Processing Dependency: libreport = 2.0.9-19.el6.centos for package: libreport-plugin-logger-2.0.9-19.el6.centos.x86_64
--> Processing Dependency: libreport = 2.0.9-19.el6.centos for package: libreport-plugin-kerneloops-2.0.9-19.el6.centos.x86_64
--> Processing Dependency: libreport = 2.0.9-19.el6.centos for package: libreport-cli-2.0.9-19.el6.centos.x86_64
--> Processing Dependency: libreport >= 2.0.9-16 for package: abrt-2.0.8-21.el6.centos.x86_64
--> Processing Dependency: libreport = 2.0.9-19.el6.centos for package: libreport-plugin-mailx-2.0.9-19.el6.centos.x86_64
--> Processing Dependency: libreport = 2.0.9-19.el6.centos for package: libreport-plugin-reportuploader-2.0.9-19.el6.centos.x86_64
--> Running transaction check
---> Package abrt.x86_64 0:2.0.8-21.el6.centos will be erased
---> Package abrt-addon-ccpp.x86_64 0:2.0.8-21.el6.centos will be erased
---> Package abrt-addon-kerneloops.x86_64 0:2.0.8-21.el6.centos will be erased
---> Package abrt-addon-python.x86_64 0:2.0.8-21.el6.centos will be erased
---> Package abrt-libs.x86_64 0:2.0.8-21.el6.centos will be erased
---> Package abrt-tui.x86_64 0:2.0.8-21.el6.centos will be erased
---> Package libreport-cli.x86_64 0:2.0.9-19.el6.centos will be erased
---> Package libreport-plugin-kerneloops.x86_64 0:2.0.9-19.el6.centos will be erased
---> Package libreport-plugin-logger.x86_64 0:2.0.9-19.el6.centos will be erased
---> Package libreport-plugin-mailx.x86_64 0:2.0.9-19.el6.centos will be erased
---> Package libreport-plugin-reportuploader.x86_64 0:2.0.9-19.el6.centos will be erased
--> Finished Dependency Resolution
ol6_UEK_latest                                                                                                                                   | 1.2 kB     00:00
ol6_UEK_latest/primary                                                                                                                           |  16 MB     00:08
ol6_latest                                                                                                                                       | 1.4 kB     00:00
ol6_latest/primary                                                                                                                               |  41 MB     00:21
Dependencies Resolved
========================================================================================================================================================================
 Package                                        Arch                  Version                             Repository                                               Size
========================================================================================================================================================================
Removing:
 libreport-plugin-rhtsupport                    x86_64                2.0.9-19.el6.centos                 @anaconda-CentOS-201311272149.x86_64/6.5                 74 k
Removing for dependencies:
 abrt                                           x86_64                2.0.8-21.el6.centos                 @anaconda-CentOS-201311272149.x86_64/6.5                706 k
 abrt-addon-ccpp                                x86_64                2.0.8-21.el6.centos                 @anaconda-CentOS-201311272149.x86_64/6.5                189 k
 abrt-addon-kerneloops                          x86_64                2.0.8-21.el6.centos                 @anaconda-CentOS-201311272149.x86_64/6.5                 25 k
 abrt-addon-python                              x86_64                2.0.8-21.el6.centos                 @anaconda-CentOS-201311272149.x86_64/6.5                 20 k
 abrt-cli                                       x86_64                2.0.8-21.el6.centos                 @anaconda-CentOS-201311272149.x86_64/6.5                0.0
 abrt-libs                                      x86_64                2.0.8-21.el6.centos                 @anaconda-CentOS-201311272149.x86_64/6.5                 24 k
 abrt-tui                                       x86_64                2.0.8-21.el6.centos                 @anaconda-CentOS-201311272149.x86_64/6.5                 15 k
 libreport                                      x86_64                2.0.9-19.el6.centos                 @anaconda-CentOS-201311272149.x86_64/6.5                1.2 M
 libreport-cli                                  x86_64                2.0.9-19.el6.centos                 @anaconda-CentOS-201311272149.x86_64/6.5                 26 k
 libreport-compat                               x86_64                2.0.9-19.el6.centos                 @anaconda-CentOS-201311272149.x86_64/6.5                7.4 k
 libreport-plugin-kerneloops                    x86_64                2.0.9-19.el6.centos                 @anaconda-CentOS-201311272149.x86_64/6.5                 18 k
 libreport-plugin-logger                        x86_64                2.0.9-19.el6.centos                 @anaconda-CentOS-201311272149.x86_64/6.5                 23 k
 libreport-plugin-mailx                         x86_64                2.0.9-19.el6.centos                 @anaconda-CentOS-201311272149.x86_64/6.5                 32 k
 libreport-plugin-reportuploader                x86_64                2.0.9-19.el6.centos                 @anaconda-CentOS-201311272149.x86_64/6.5                 32 k
 libreport-python                               x86_64                2.0.9-19.el6.centos                 @anaconda-CentOS-201311272149.x86_64/6.5                 72 k
Transaction Summary
========================================================================================================================================================================
Remove       16 Package(s)
Installed size: 2.4 M
Is this ok [y/N]: y
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Erasing    : abrt-cli-2.0.8-21.el6.centos.x86_64                                                                                                                 1/16
  Erasing    : abrt-addon-kerneloops-2.0.8-21.el6.centos.x86_64                                                                                                    2/16
  Erasing    : abrt-addon-ccpp-2.0.8-21.el6.centos.x86_64                                                                                                          3/16
  Erasing    : abrt-tui-2.0.8-21.el6.centos.x86_64                                                                                                                 4/16
  Erasing    : abrt-addon-python-2.0.8-21.el6.centos.x86_64                                                                                                        5/16
  Erasing    : abrt-2.0.8-21.el6.centos.x86_64                                                                                                                     6/16
  Erasing    : abrt-libs-2.0.8-21.el6.centos.x86_64                                                                                                                7/16
  Erasing    : libreport-plugin-kerneloops-2.0.9-19.el6.centos.x86_64                                                                                              8/16
  Erasing    : libreport-cli-2.0.9-19.el6.centos.x86_64                                                                                                            9/16
  Erasing    : libreport-plugin-logger-2.0.9-19.el6.centos.x86_64                                                                                                 10/16
  Erasing    : libreport-plugin-mailx-2.0.9-19.el6.centos.x86_64                                                                                                  11/16
  Erasing    : libreport-compat-2.0.9-19.el6.centos.x86_64                                                                                                        12/16
  Erasing    : libreport-plugin-reportuploader-2.0.9-19.el6.centos.x86_64                                                                                         13/16
  Erasing    : libreport-plugin-rhtsupport-2.0.9-19.el6.centos.x86_64                                                                                             14/16
  Erasing    : libreport-python-2.0.9-19.el6.centos.x86_64                                                                                                        15/16
  Erasing    : libreport-2.0.9-19.el6.centos.x86_64                                                                                                               16/16
  Verifying  : libreport-plugin-mailx-2.0.9-19.el6.centos.x86_64                                                                                                   1/16
  Verifying  : libreport-2.0.9-19.el6.centos.x86_64                                                                                                                2/16
  Verifying  : libreport-plugin-logger-2.0.9-19.el6.centos.x86_64                                                                                                  3/16
  Verifying  : abrt-tui-2.0.8-21.el6.centos.x86_64                                                                                                                 4/16
  Verifying  : libreport-plugin-kerneloops-2.0.9-19.el6.centos.x86_64                                                                                              5/16
  Verifying  : libreport-plugin-rhtsupport-2.0.9-19.el6.centos.x86_64                                                                                              6/16
  Verifying  : abrt-addon-kerneloops-2.0.8-21.el6.centos.x86_64                                                                                                    7/16
  Verifying  : libreport-compat-2.0.9-19.el6.centos.x86_64                                                                                                         8/16
  Verifying  : abrt-2.0.8-21.el6.centos.x86_64                                                                                                                     9/16
  Verifying  : abrt-libs-2.0.8-21.el6.centos.x86_64                                                                                                               10/16
  Verifying  : libreport-python-2.0.9-19.el6.centos.x86_64                                                                                                        11/16
  Verifying  : abrt-addon-python-2.0.8-21.el6.centos.x86_64                                                                                                       12/16
  Verifying  : libreport-plugin-reportuploader-2.0.9-19.el6.centos.x86_64                                                                                         13/16
  Verifying  : abrt-cli-2.0.8-21.el6.centos.x86_64                                                                                                                14/16
  Verifying  : libreport-cli-2.0.9-19.el6.centos.x86_64                                                                                                           15/16
  Verifying  : abrt-addon-ccpp-2.0.8-21.el6.centos.x86_64                                                                                                         16/16
Removed:
  libreport-plugin-rhtsupport.x86_64 0:2.0.9-19.el6.centos
Dependency Removed:
  abrt.x86_64 0:2.0.8-21.el6.centos                   abrt-addon-ccpp.x86_64 0:2.0.8-21.el6.centos                 abrt-addon-kerneloops.x86_64 0:2.0.8-21.el6.centos
  abrt-addon-python.x86_64 0:2.0.8-21.el6.centos      abrt-cli.x86_64 0:2.0.8-21.el6.centos                        abrt-libs.x86_64 0:2.0.8-21.el6.centos
  abrt-tui.x86_64 0:2.0.8-21.el6.centos               libreport.x86_64 0:2.0.9-19.el6.centos                       libreport-cli.x86_64 0:2.0.9-19.el6.centos
  libreport-compat.x86_64 0:2.0.9-19.el6.centos       libreport-plugin-kerneloops.x86_64 0:2.0.9-19.el6.centos     libreport-plugin-logger.x86_64 0:2.0.9-19.el6.centos
  libreport-plugin-mailx.x86_64 0:2.0.9-19.el6.centos libreport-plugin-reportuploader.x86_64 0:2.0.9-19.el6.centos libreport-python.x86_64 0:2.0.9-19.el6.centos
Complete!
Backing up and removing old repository files...
Downloading Oracle Linux release package...
Loaded plugins: fastestmirror
Determining fastest mirrors
ol6_UEK_latest                                                                                                                                                  351/351
ol6_latest                                                                                                                                                  26103/26103
oraclelinux-release-6Server-5.0.2.x86_64.rpm                                                                                                     |  22 kB     00:00
redhat-release-server-6Server-6.5.0.1.0.1.el6.x86_64.rpm                                                                                         | 2.6 kB     00:00
Switching old release package with Oracle Linux...
warning: oraclelinux-release-6Server-5.0.2.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Installing base packages for Oracle Linux...
Loaded plugins: fastestmirror, security
Determining fastest mirrors
ol6_UEK_latest                                                                                                                                   | 1.2 kB     00:00
ol6_UEK_latest/primary                                                                                                                           |  16 MB     00:09
ol6_UEK_latest                                                                                                                                                  351/351
ol6_latest                                                                                                                                       | 1.4 kB     00:00
ol6_latest/primary                                                                                                                               |  41 MB     00:21
ol6_latest                                                                                                                                                  26103/26103
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package basesystem.noarch 0:10.0-4.el6 will be updated
---> Package basesystem.noarch 0:10.0-4.0.1.el6 will be an update
---> Package grub.x86_64 1:0.97-84.el6_5 will be updated
---> Package grub.x86_64 1:0.97-84.0.1.el6_5 will be an update
---> Package grubby.x86_64 0:7.0.15-5.el6 will be updated
---> Package grubby.x86_64 0:7.0.15-5.0.4.el6 will be an update
---> Package initscripts.x86_64 0:9.03.40-2.el6.centos.4 will be updated
---> Package initscripts.x86_64 0:9.03.40-2.0.1.el6_5.4 will be an update
---> Package oracle-logos.noarch 0:60.0.14-1.0.1.el6 will be obsoleting
---> Package oraclelinux-release-notes.x86_64 0:6Server-11 will be installed
---> Package plymouth.x86_64 0:0.8.3-27.el6.centos.1 will be updated
---> Package plymouth.x86_64 0:0.8.3-27.0.1.el6_5.1 will be an update
--> Processing Dependency: plymouth-core-libs = 0.8.3-27.0.1.el6_5.1 for package: plymouth-0.8.3-27.0.1.el6_5.1.x86_64
---> Package redhat-logos.noarch 0:60.0.14-12.el6.centos will be obsoleted
--> Running transaction check
---> Package plymouth-core-libs.x86_64 0:0.8.3-27.el6.centos.1 will be updated
---> Package plymouth-core-libs.x86_64 0:0.8.3-27.0.1.el6_5.1 will be an update
--> Finished Dependency Resolution
Dependencies Resolved
========================================================================================================================================================================
 Package                                          Arch                          Version                                         Repository                         Size
========================================================================================================================================================================
Installing:
 oracle-logos                                     noarch                        60.0.14-1.0.1.el6                               ol6_latest                         12 M
     replacing  redhat-logos.noarch 60.0.14-12.el6.centos
 oraclelinux-release-notes                        x86_64                        6Server-11                                      ol6_latest                         77 k
Updating:
 basesystem                                       noarch                        10.0-4.0.1.el6                                  ol6_latest                        4.3 k
 grub                                             x86_64                        1:0.97-84.0.1.el6_5                             ol6_latest                        932 k
 grubby                                           x86_64                        7.0.15-5.0.4.el6                                ol6_latest                         43 k
 initscripts                                      x86_64                        9.03.40-2.0.1.el6_5.4                           ol6_latest                        940 k
 plymouth                                         x86_64                        0.8.3-27.0.1.el6_5.1                            ol6_latest                         89 k
Updating for dependencies:
 plymouth-core-libs                               x86_64                        0.8.3-27.0.1.el6_5.1                            ol6_latest                         88 k
Transaction Summary
========================================================================================================================================================================
Install       2 Package(s)
Upgrade       6 Package(s)
Total download size: 14 M
Downloading Packages:
(1/8): basesystem-10.0-4.0.1.el6.noarch.rpm                                                                                                      | 4.3 kB     00:00
(2/8): grub-0.97-84.0.1.el6_5.x86_64.rpm                                                                                                         | 932 kB     00:00
(3/8): grubby-7.0.15-5.0.4.el6.x86_64.rpm                                                                                                        |  43 kB     00:00
(4/8): initscripts-9.03.40-2.0.1.el6_5.4.x86_64.rpm                                                                                              | 940 kB     00:00
(5/8): oracle-logos-60.0.14-1.0.1.el6.noarch.rpm                                                                                                 |  12 MB     00:06
(6/8): oraclelinux-release-notes-6Server-11.x86_64.rpm                                                                                           |  77 kB     00:00
(7/8): plymouth-0.8.3-27.0.1.el6_5.1.x86_64.rpm                                                                                                  |  89 kB     00:00
(8/8): plymouth-core-libs-0.8.3-27.0.1.el6_5.1.x86_64.rpm                                                                                        |  88 kB     00:00
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                                                   1.5 MB/s |  14 MB     00:09
warning: rpmts_HdrFromFdno: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
Importing GPG key 0xEC551F03:
 Userid : Oracle OSS group (Open Source Software group) <build@oss.oracle.com>
 Package: 6:oraclelinux-release-6Server-5.0.2.x86_64 (installed)
 From   : /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Warning: RPMDB altered outside of yum.
  Installing : oracle-logos-60.0.14-1.0.1.el6.noarch                                                                                                               1/15
  Updating   : initscripts-9.03.40-2.0.1.el6_5.4.x86_64                                                                                                            2/15
  Updating   : plymouth-core-libs-0.8.3-27.0.1.el6_5.1.x86_64                                                                                                      3/15
  Updating   : plymouth-0.8.3-27.0.1.el6_5.1.x86_64                                                                                                                4/15
  Updating   : 1:grub-0.97-84.0.1.el6_5.x86_64                                                                                                                     5/15
  Updating   : basesystem-10.0-4.0.1.el6.noarch                                                                                                                    6/15
  Installing : oraclelinux-release-notes-6Server-11.x86_64                                                                                                         7/15
  Updating   : grubby-7.0.15-5.0.4.el6.x86_64                                                                                                                      8/15
  Cleanup    : 1:grub-0.97-84.el6_5.x86_64                                                                                                                         9/15
  Cleanup    : plymouth-0.8.3-27.el6.centos.1.x86_64                                                                                                              10/15
  Erasing    : redhat-logos-60.0.14-12.el6.centos.noarch                                                                                                          11/15
  Cleanup    : basesystem-10.0-4.el6.noarch                                                                                                                       12/15
  Cleanup    : initscripts-9.03.40-2.el6.centos.4.x86_64                                                                                                          13/15
  Cleanup    : plymouth-core-libs-0.8.3-27.el6.centos.1.x86_64                                                                                                    14/15
  Cleanup    : grubby-7.0.15-5.el6.x86_64                                                                                                                         15/15
  Verifying  : grubby-7.0.15-5.0.4.el6.x86_64                                                                                                                      1/15
  Verifying  : 1:grub-0.97-84.0.1.el6_5.x86_64                                                                                                                     2/15
  Verifying  : plymouth-0.8.3-27.0.1.el6_5.1.x86_64                                                                                                                3/15
  Verifying  : initscripts-9.03.40-2.0.1.el6_5.4.x86_64                                                                                                            4/15
  Verifying  : oracle-logos-60.0.14-1.0.1.el6.noarch                                                                                                               5/15
  Verifying  : oraclelinux-release-notes-6Server-11.x86_64                                                                                                         6/15
  Verifying  : basesystem-10.0-4.0.1.el6.noarch                                                                                                                    7/15
  Verifying  : plymouth-core-libs-0.8.3-27.0.1.el6_5.1.x86_64                                                                                                      8/15
  Verifying  : plymouth-0.8.3-27.el6.centos.1.x86_64                                                                                                               9/15
  Verifying  : initscripts-9.03.40-2.el6.centos.4.x86_64                                                                                                          10/15
  Verifying  : plymouth-core-libs-0.8.3-27.el6.centos.1.x86_64                                                                                                    11/15
  Verifying  : grubby-7.0.15-5.el6.x86_64                                                                                                                         12/15
  Verifying  : redhat-logos-60.0.14-12.el6.centos.noarch                                                                                                          13/15
  Verifying  : 1:grub-0.97-84.el6_5.x86_64                                                                                                                        14/15
  Verifying  : basesystem-10.0-4.el6.noarch                                                                                                                       15/15
Installed:
  oracle-logos.noarch 0:60.0.14-1.0.1.el6                                         oraclelinux-release-notes.x86_64 0:6Server-11
Updated:
  basesystem.noarch 0:10.0-4.0.1.el6          grub.x86_64 1:0.97-84.0.1.el6_5      grubby.x86_64 0:7.0.15-5.0.4.el6      initscripts.x86_64 0:9.03.40-2.0.1.el6_5.4
  plymouth.x86_64 0:0.8.3-27.0.1.el6_5.1
Dependency Updated:
  plymouth-core-libs.x86_64 0:0.8.3-27.0.1.el6_5.1
Replaced:
  redhat-logos.noarch 0:60.0.14-12.el6.centos
Complete!
Updating initrd...
Installation successful!
Run 'yum upgrade' to synchronize your installed packages
with the Oracle Linux repository.
[root@test-centos ~]# yum upgrade
.
.
.
Installed:
  kernel-uek-headers.x86_64 0:2.6.32-400.36.8.el6uek
Updated:
  autofs.x86_64 1:5.0.5-89.0.1.el6_5.2                     bfa-firmware.noarch 0:3.2.23.0-1.0.1.el6          certmonger.x86_64 0:0.61-3.0.1.el6
  coreutils.x86_64 0:8.4-31.0.1.el6_5.2                    coreutils-libs.x86_64 0:8.4-31.0.1.el6_5.2        cpuspeed.x86_64 1:1.5-20.0.1.el6_4
  crash.x86_64 0:6.1.0-5.0.1.el6                           dbus.x86_64 1:1.2.24-7.0.1.el6_3                  dbus-glib.x86_64 0:0.86-6.el6_4
  dbus-libs.x86_64 1:1.2.24-7.0.1.el6_3                    dhclient.x86_64 12:4.1.1-38.P1.0.1.el6            dhcp-common.x86_64 12:4.1.1-38.P1.0.1.el6
  dracut.noarch 0:004-336.0.1.el6_5.2                      dracut-kernel.noarch 0:004-336.0.1.el6_5.2        e2fsprogs.x86_64 0:1.42.8-1.0.1.el6
  e2fsprogs-libs.x86_64 0:1.42.8-1.0.1.el6                 gstreamer.x86_64 0:0.10.29-1.0.1.el6              gstreamer-tools.x86_64 0:0.10.29-1.0.1.el6
  iptables.x86_64 0:1.4.7-11.0.1.el6                       iptables-ipv6.x86_64 0:1.4.7-11.0.1.el6           irqbalance.x86_64 2:1.0.4-9.0.1.el6_5
  java-1.7.0-openjdk.x86_64 1:1.7.0.65-2.5.1.2.0.1.el6_5   kexec-tools.x86_64 0:2.0.3-3.0.10.el6             kpartx.x86_64 0:0.4.9-72.0.1.el6_5.3
  libcom_err.x86_64 0:1.42.8-1.0.1.el6                     libgudev1.x86_64 0:147-2.51.0.3.el6               libss.x86_64 0:1.42.8-1.0.1.el6
  libudev.x86_64 0:147-2.51.0.3.el6                        libxml2.x86_64 0:2.7.6-14.0.1.el6_5.2             libxml2-python.x86_64 0:2.7.6-14.0.1.el6_5.2
  libxslt.x86_64 0:1.1.26-2.0.2.el6_3.1                    module-init-tools.x86_64 0:3.9-21.0.1.el6_4       nss.x86_64 0:3.16.1-4.0.1.el6_5
  nss-sysinit.x86_64 0:3.16.1-4.0.1.el6_5                  nss-tools.x86_64 0:3.16.1-4.0.1.el6_5             oprofile.x86_64 0:0.9.7-1.0.1.el6
  pango.x86_64 0:1.28.1-7.0.1.el6_3                        plymouth-scripts.x86_64 0:0.8.3-27.0.1.el6_5.1    policycoreutils.x86_64 0:2.0.83-19.39.0.1.el6
  ql2400-firmware.noarch 0:7.03.00-1.0.1.el6               ql2500-firmware.noarch 0:7.03.00-1.0.1.el6        redhat-lsb.x86_64 0:4.0-7.0.1.el6
  redhat-lsb-compat.x86_64 0:4.0-7.0.1.el6                 redhat-lsb-core.x86_64 0:4.0-7.0.1.el6            redhat-lsb-graphics.x86_64 0:4.0-7.0.1.el6
  redhat-lsb-printing.x86_64 0:4.0-7.0.1.el6               rsyslog.x86_64 0:5.8.10-8.0.1.el6                 selinux-policy.noarch 0:3.7.19-231.0.1.el6_5.3
  selinux-policy-targeted.noarch 0:3.7.19-231.0.1.el6_5.3  sos.noarch 0:2.2-47.0.1.el6_5.7                   system-config-network-tui.noarch 0:1.6.0.el6.3-1.0.1.el6
  systemtap-runtime.x86_64 0:2.3-4.0.1.el6_5               udev.x86_64 0:147-2.51.0.3.el6                    yum.noarch 0:3.2.29-43.0.1.el6_5
  yum-plugin-fastestmirror.noarch 0:1.1.30-17.0.1.el6_5    yum-plugin-security.noarch 0:1.1.30-17.0.1.el6_5  yum-utils.noarch 0:1.1.30-17.0.1.el6_5
Replaced:
  kernel-headers.x86_64 0:2.6.32-431.29.2.el6
Complete!

[root@test-centos ~]# cat /etc/oracle-release
Oracle Linux Server release 6.5
[root@test-centos ~]# rpm -qi --info "oraclelinux-release"
Name        : oraclelinux-release          Relocations: (not relocatable)
Version     : 6Server                           Vendor: Oracle America
Release     : 5.0.2                         Build Date: Sat 23 Nov 2013 02:14:50 AM ICT
Install Date: Fri 19 Sep 2014 03:54:33 PM ICT      Build Host: ca-build44.us.oracle.com
Group       : System Environment/Base       Source RPM: oraclelinux-release-6Server-5.0.2.src.rpm
Size        : 49559                            License: GPL
Signature   : RSA/8, Sat 23 Nov 2013 02:14:56 AM ICT, Key ID 72f97b74ec551f03
Summary     : Oracle Linux 6 release file
Description :
System release and information files
Name        : oraclelinux-release          Relocations: (not relocatable)
Version     : 6Server                           Vendor: Oracle America
Release     : 5.0.2                         Build Date: Sat 23 Nov 2013 02:14:50 AM ICT
Install Date: Fri 19 Sep 2014 03:54:33 PM ICT      Build Host: ca-build44.us.oracle.com
Group       : System Environment/Base       Source RPM: oraclelinux-release-6Server-5.0.2.src.rpm
Size        : 49559                            License: GPL
Signature   : RSA/8, Sat 23 Nov 2013 02:14:56 AM ICT, Key ID 72f97b74ec551f03
Summary     : Oracle Linux 6 release file
Description :
System release and information files
[root@test-centos ~]#It's very fast... Written By: Surachart Opun http://surachartopun.com
Categories: DBA Blogs

Getting Started with Windows VDI by Andrew Fryer

Wed, 2014-09-10 05:55
Virtual desktop infrastructure (VDI) is the practice of hosting a desktop operating system within a virtual machine (VM) running on a centralized server. VDI is a variation on the client/server computing model, sometimes referred to as server-based computing.
VDI is the new technology that gives lots of benefits.
• Efficient use of CPU and memory resources
• Reduced desktop downtime and increased availability
• Patches and upgrades performed in data center
• New users can be up and running quickly
• Data and applications reside in secure data centers
• Centralized management reduces operational expenses
Reference
Additional, VDI can be deployed with Microsoft Windows and suggest to learn What’s New in VDI for Windows Server 2012 R2 and 8.1
Anyway, I explained much more before starting to mention a book that was written by Andrew FryerGetting Started with Windows VDI - This book guides readers to build VDI by using Windows Server 2012 R2 and 8.1 quickly and easy to follow each chapter.

What Readers Will Learn:
  • Explore the various server roles and features that provide Microsoft's VDI solution
  • Virtualize desktops and the other infrastructure servers required for VDI using server virtualization in Windows Server Hyper-V
  • Build high availability clusters for VDI with techniques such as failover clustering and load balancing
  • Provide secure VDI to remote users over the Internet
  • Use Microsoft's Deployment Toolkit and Windows Server Update Services to automate the creation and maintenance of virtual desktops
  • Carry out performance tuning and monitoring
  • Understand the complexities of VDI licensing irrespective of the VDI solution you have opted for
  • Deploy PowerShell to automate all of the above techniques

Written By: Surachart Opun http://surachartopun.com
Categories: DBA Blogs