DBA Blogs

How to setup passwordless ssh in Exadata using dcli

Alejandro Vargas - Sun, 2014-10-05 03:57

 




Normal
0




false
false
false

EN-US
X-NONE
HE













MicrosoftInternetExplorer4















DefSemiHidden="true" DefQFormat="false" DefPriority="99"
LatentStyleCount="267">
UnhideWhenUsed="false" QFormat="true" Name="Normal"/>
UnhideWhenUsed="false" QFormat="true" Name="heading 1"/>


















UnhideWhenUsed="false" QFormat="true" Name="Title"/>

UnhideWhenUsed="false" QFormat="true" Name="Subtitle"/>
UnhideWhenUsed="false" QFormat="true" Name="Strong"/>
UnhideWhenUsed="false" QFormat="true" Name="Emphasis"/>
UnhideWhenUsed="false" Name="Table Grid"/>

UnhideWhenUsed="false" QFormat="true" Name="No Spacing"/>
UnhideWhenUsed="false" Name="Light Shading"/>
UnhideWhenUsed="false" Name="Light List"/>
UnhideWhenUsed="false" Name="Light Grid"/>
UnhideWhenUsed="false" Name="Medium Shading 1"/>
UnhideWhenUsed="false" Name="Medium Shading 2"/>
UnhideWhenUsed="false" Name="Medium List 1"/>
UnhideWhenUsed="false" Name="Medium List 2"/>
UnhideWhenUsed="false" Name="Medium Grid 1"/>
UnhideWhenUsed="false" Name="Medium Grid 2"/>
UnhideWhenUsed="false" Name="Medium Grid 3"/>
UnhideWhenUsed="false" Name="Dark List"/>
UnhideWhenUsed="false" Name="Colorful Shading"/>
UnhideWhenUsed="false" Name="Colorful List"/>
UnhideWhenUsed="false" Name="Colorful Grid"/>
UnhideWhenUsed="false" Name="Light Shading Accent 1"/>
UnhideWhenUsed="false" Name="Light List Accent 1"/>
UnhideWhenUsed="false" Name="Light Grid Accent 1"/>
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 1"/>
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 1"/>
UnhideWhenUsed="false" Name="Medium List 1 Accent 1"/>

UnhideWhenUsed="false" QFormat="true" Name="List Paragraph"/>
UnhideWhenUsed="false" QFormat="true" Name="Quote"/>
UnhideWhenUsed="false" QFormat="true" Name="Intense Quote"/>
UnhideWhenUsed="false" Name="Medium List 2 Accent 1"/>
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 1"/>
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 1"/>
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 1"/>
UnhideWhenUsed="false" Name="Dark List Accent 1"/>
UnhideWhenUsed="false" Name="Colorful Shading Accent 1"/>
UnhideWhenUsed="false" Name="Colorful List Accent 1"/>
UnhideWhenUsed="false" Name="Colorful Grid Accent 1"/>
UnhideWhenUsed="false" Name="Light Shading Accent 2"/>
UnhideWhenUsed="false" Name="Light List Accent 2"/>
UnhideWhenUsed="false" Name="Light Grid Accent 2"/>
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 2"/>
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 2"/>
UnhideWhenUsed="false" Name="Medium List 1 Accent 2"/>
UnhideWhenUsed="false" Name="Medium List 2 Accent 2"/>
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 2"/>
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 2"/>
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 2"/>
UnhideWhenUsed="false" Name="Dark List Accent 2"/>
UnhideWhenUsed="false" Name="Colorful Shading Accent 2"/>
UnhideWhenUsed="false" Name="Colorful List Accent 2"/>
UnhideWhenUsed="false" Name="Colorful Grid Accent 2"/>
UnhideWhenUsed="false" Name="Light Shading Accent 3"/>
UnhideWhenUsed="false" Name="Light List Accent 3"/>
UnhideWhenUsed="false" Name="Light Grid Accent 3"/>
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 3"/>
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 3"/>
UnhideWhenUsed="false" Name="Medium List 1 Accent 3"/>
UnhideWhenUsed="false" Name="Medium List 2 Accent 3"/>
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 3"/>
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 3"/>
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 3"/>
UnhideWhenUsed="false" Name="Dark List Accent 3"/>
UnhideWhenUsed="false" Name="Colorful Shading Accent 3"/>
UnhideWhenUsed="false" Name="Colorful List Accent 3"/>
UnhideWhenUsed="false" Name="Colorful Grid Accent 3"/>
UnhideWhenUsed="false" Name="Light Shading Accent 4"/>
UnhideWhenUsed="false" Name="Light List Accent 4"/>
UnhideWhenUsed="false" Name="Light Grid Accent 4"/>
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 4"/>
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 4"/>
UnhideWhenUsed="false" Name="Medium List 1 Accent 4"/>
UnhideWhenUsed="false" Name="Medium List 2 Accent 4"/>
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 4"/>
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 4"/>
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 4"/>
UnhideWhenUsed="false" Name="Dark List Accent 4"/>
UnhideWhenUsed="false" Name="Colorful Shading Accent 4"/>
UnhideWhenUsed="false" Name="Colorful List Accent 4"/>
UnhideWhenUsed="false" Name="Colorful Grid Accent 4"/>
UnhideWhenUsed="false" Name="Light Shading Accent 5"/>
UnhideWhenUsed="false" Name="Light List Accent 5"/>
UnhideWhenUsed="false" Name="Light Grid Accent 5"/>
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 5"/>
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 5"/>
UnhideWhenUsed="false" Name="Medium List 1 Accent 5"/>
UnhideWhenUsed="false" Name="Medium List 2 Accent 5"/>
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 5"/>
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 5"/>
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 5"/>
UnhideWhenUsed="false" Name="Dark List Accent 5"/>
UnhideWhenUsed="false" Name="Colorful Shading Accent 5"/>
UnhideWhenUsed="false" Name="Colorful List Accent 5"/>
UnhideWhenUsed="false" Name="Colorful Grid Accent 5"/>
UnhideWhenUsed="false" Name="Light Shading Accent 6"/>
UnhideWhenUsed="false" Name="Light List Accent 6"/>
UnhideWhenUsed="false" Name="Light Grid Accent 6"/>
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 6"/>
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 6"/>
UnhideWhenUsed="false" Name="Medium List 1 Accent 6"/>
UnhideWhenUsed="false" Name="Medium List 2 Accent 6"/>
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 6"/>
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 6"/>
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 6"/>
UnhideWhenUsed="false" Name="Dark List Accent 6"/>
UnhideWhenUsed="false" Name="Colorful Shading Accent 6"/>
UnhideWhenUsed="false" Name="Colorful List Accent 6"/>
UnhideWhenUsed="false" Name="Colorful Grid Accent 6"/>
UnhideWhenUsed="false" QFormat="true" Name="Subtle Emphasis"/>
UnhideWhenUsed="false" QFormat="true" Name="Intense Emphasis"/>
UnhideWhenUsed="false" QFormat="true" Name="Subtle Reference"/>
UnhideWhenUsed="false" QFormat="true" Name="Intense Reference"/>
UnhideWhenUsed="false" QFormat="true" Name="Book Title"/>





/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-qformat:yes;
mso-style-parent:"";
mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
mso-para-margin:0cm;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:"Times New Roman";
mso-fareast-theme-font:minor-fareast;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:Arial;
mso-bidi-theme-font:minor-bidi;}


Setting passwordless ssh root connection using dcli is fast and simple and will easy later to execute commands on all servers using this utility.


In order to do that you should have either:


DNS resolution to all Database and Storage nodes OR have them registered in /etc/hosts


1) Create a parameter file that contains all the server names you want to reach via dcli, tipically we have a cell_group for storage cells, a dbs_group for database servers and an all_group for both of them.


The parameter files will have only the server name, in short format


ie: all_group will have on an Exadata quarter rack:


dbnode1
dbnode2
cell1
cell2
cell3


2) As root user create ssh equivalence:


ssh-keygen   -t    rsa


3) Distribute the key to all servers


dcli -g ./all_group -l root -k -s '-o StrictHostKeyChecking=no'


4) check 


dcli -g all_group -l root hostname 



 

Categories: DBA Blogs

Bash security fix made available for Exadata

Alejandro Vargas - Sun, 2014-10-05 03:29

Complete information about the security fix availability should be reviewed, before applying the fix, in MOS DOC:

 Responses to common Exadata security scan findings (Doc ID 1405320.1)

The security fix is available for download from:

http://public-yum.oracle.com/repo/OracleLinux/OL5/latest/x86_64/getPackage/bash-3.2-33.el5_11.4.x86_64.rpm

The summary installation instructions are as follows:

1) Download getPackage/bash-3.2-33.el5_11.4.x86_64.rpm

2) Copy bash-3.2-33.el5_11.4.x86_64.rpm into /tmp at both database and storage nodes.

3) Remove rpm  exadata-sun-computenode-exact

rpm -e exadata-sun-computenode-exact

4) On compute nodes install bash-3.2-33.el5_11.4.x86_64.rpm using this command:

 rpm -Uvh /tmp/bash-3.2-33.el5_11.4.x86_64.rpm

5) On storage nodes  install bash-3.2-33.el5_11.4.x86_64.rpm using this command:

rpm -Uvh --nodeps /tmp/bash-3.2-33.el5_11.4.x86_64.rpm

6) Remove /tmp/bash-3.2-33.el5_11.4.x86_64.rpm from all nodes

As a side effect of applyin this fix,  during future upgrades on the database nodes, a warning will appear informing:

The "exact package" was not found and it will use minimal instead.

That's a normal and expected message and will not interfere with the upgrade. 


Categories: DBA Blogs

Bash security fix made available for Exadata

Alejandro Vargas - Sun, 2014-10-05 03:29

Complete information about the security fix availability should be reviewed, before applying the fix, in MOS DOC:


 Responses to common Exadata security scan findings (Doc ID 1405320.1)


The security fix is available for download from:


http://public-yum.oracle.com/repo/OracleLinux/OL5/latest/x86_64/getPackage/bash-3.2-33.el5_11.4.x86_64.rpm


The summary installation instructions are as follows:


1) Download getPackage/bash-3.2-33.el5_11.4.x86_64.rpm


2) Copy bash-3.2-33.el5_11.4.x86_64.rpm into /tmp at both database and storage nodes.


3) Remove rpm  exadata-sun-computenode-exact



rpm -e exadata-sun-computenode-exact



4) On compute nodes install bash-3.2-33.el5_11.4.x86_64.rpm using this command:



 rpm -Uvh /tmp/bash-3.2-33.el5_11.4.x86_64.rpm



5) On storage nodes  install bash-3.2-33.el5_11.4.x86_64.rpm using this command:




rpm -Uvh --nodeps /tmp/bash-3.2-33.el5_11.4.x86_64.rpm


6) Remove /tmp/bash-3.2-33.el5_11.4.x86_64.rpm from all nodes


As a side effect of applyin this fix,  during future upgrades on the database nodes, a warning will appear informing:



The "exact package" was not found and it will use minimal instead.


That's a normal and expected message and will not interfere with the upgrade. 







Categories: DBA Blogs

Advanced Queue Quickie: Errors and Privileges

Don Seiler - Wed, 2014-10-01 23:07
File this one under the misleading-errors department. One of my developers was working with a new queue. He pinged me when he got this error trying to create a job that used the queue:

ERROR at line 1:
ORA-27373: unknown or illegal event source queue
ORA-06512: at "SYS.DBMS_ISCHED", line 124
ORA-06512: at "SYS.DBMS_SCHEDULER", line 314
ORA-06512: at line 2

The CREATE_JOB statement was:

BEGIN
DBMS_SCHEDULER.CREATE_JOB(
job_name => 'foo.bar_q_job',
job_type => 'PLSQL_BLOCK',
job_action => 'begin foo.bar_pkg.consume_bar_queue(); end;',
queue_spec => 'BAR.BAR_Q, FOO_BAR_AGENT',
enabled => true,
comments => 'This is a job to consume the bar.bar_q entries that affect foo.');
END;
/

After a few minutes of banging our heads, it became obvious that this was a permissions problem. The queue was owned by BAR, the job was being created as FOO. The ORA error message could/should have made this more obvious, in my opinion.

Anyway, the fix was simply to grant access to FOO:

DBMS_AQADM.GRANT_QUEUE_PRIVILEGE(
        privilege  => 'ALL',
        queue_name => 'bar.bar_q',
        grantee    => 'foo' );

Hope this saves some banged heads for others.
Categories: DBA Blogs

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

Surachart Opun - Tue, 2014-09-30 11: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


Categories: DBA Blogs

The Hitchhiker’s Guide to the EXPLAIN PLAN: The story so far (Part 11–22)

Iggy Fernandez - Sat, 2014-09-27 18:20
On the Toad World site, I’m writing a series of blog posts and Wiki articles on the subject of EXPLAIN PLAN. I’m using EXPLAIN PLAN as a motif to teach not just SQL tuning but also relational theory, logical database design, and physical database design. In a year’s time, I hope to have enough material for […]
Categories: DBA Blogs

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

Surachart Opun - Sat, 2014-09-27 00: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 Kreps
Categories: DBA Blogs

Top 7 Reasons Why Oracle Conferences Rock!

This page has been permanently moved. Please CLICK HERE to be redirected.

Thanks, Craig.Top 7 Reasons Why Oracle Conferences Rock!
Why take the time and make the effort to attend an Oracle database conference or Oracle user group meeting? We're all busy, so there had better be some super good reasons to make the effort! For me, the benefits definitely exceed the cost.

There are many different conferences to choose from. There are professional conferences, leadership conferences, scientific conferences and business focused conferences. So why an Oracle Database conference? What's the big deal?

This is difficult for me to explain, so I've summarized why I love Oracle conferences into a "Top 7" list.

Number 7. Get free stuff from vendors
I suspect 50% of Oracle DBAs attend conferences because they love getting free stuff. If you want to maximize the good stuff, timing is everything. Get to the booth when the exhibition hall first opens, because vendors have tons of stuff to give away and they are full of energy. Also, just before the exhibition hall closes on the final day show up again. Vendors are tired and want to get rid of as much stuff as possible... and you just happen to be there!

Number 6. Become known in your industryIf you want to focus and excel in your career in a particular area, then pass on what you know. If you hold on to what you learn, no one will know you're an expert but you... and that's lonely. One of the best ways to become known and enjoy conferences is to speak at them. If this is something you want to do, please email me. I'll mentor you. I'm serious.

Number 5. Talk to others, if you want toWant to talk with people who care about Oracle technology as much as you do? Conferences are a great way to break out of your rut and think... and if you want to talk. One of the reasons I like conferences is it gives me a chance to meet with past students.

Number 4. Learn, if you want to
There are always opportunities to learn at conferences. How many times have I heard someone say they were in a lame session. But when I ask if they read the abstract first, they say no. If you want to increase your chances of attending great sessions, read the abstract. Second, look for speakers you like. Third, sit next to the door just in case you need to make a quick exit! The worst you can do is look at the agenda and pick the sessions you want to attend. Do a little research and you'll be surprised how many good sessions there are.


Number 3. Be inspired!How many places can you go to receive inspiration? Not many, is my answer! Because I can chill for a bit at conferences, observe what's going on in our industry and interact with a wide variety of people associated with Oracle technology, I tend to leave with a fresher and more refined view... or better said, "A Wider View." That in itself is worth the cost of any conference.

Number 2. Network with vendors, speakers, colleagues
I take it one step at a time. I always cruise the exhibition halls looking for new products and touching base with the vendors I know. Personally, I like to encourage the new vendors because it is a massive investment for them to exhibit. When I'm cruising, that's where I typically reconnect with students and other DBAs. It's a more comfortable and relaxing environment for me. If you want to speak with an expert face-to-face, a conference is a natural place to do this. If someone walks up to me with an AWR report, I'll make time for them. If they email me the week before, I'll do whatever I can to schedule some time with them.

Number 1. Be with friends
This one is personal. When I'm teaching or consulting, it's very intense and compressed. But at conferences, I get a chance to unwind, sit back, have a beer, and talk. I'm really involved with the IOUG conference and each year I look forward to reconnecting with this small group of friends. It's such a good feeling to be with "Oracle friends" without having to talk... about Oracle. I can just sit and listen without anyone wondering... What's wrong with Craig? You can do the same thing. Find an Oracle user group and volunteer.

Why Attend? Because Oracle conferences rock!There you have it. Seven reasons why Oracle conferences and Oracle User Groups rock! If you're not planning to attend any, you're missing a great way to connect, advance your career, and have a lot of fun. See you there!!

All the best in your Oracle performance work!

Craig.




Categories: DBA Blogs

My Data Model Checklist book is now available in Spanish – Just in time for #OOW14!

Galo Balda's Blog - Wed, 2014-09-24 10:34

The Data Warrior

Exciting news!

I just got this email from Amazon:

Congratulations, your book “UNA LISTA DE VERIFICACIÓN PARA REALIZAR REVISIONES A LOS DISEÑOS DE MODELOS DE DATOS” is live in the Kindle Store and is currently enrolled in KDP Select. It is available for readers to purchase here.

If you are in Mexico, you can get the book here.

If you are in Spain, you can get it here.

Now, truth is I do NOT speak, read or write Spanish. But my good friend, and Oracle expert, Galo Balda does!

I am very grateful to Galo for putting in the effort to translate my little book so other data professionals around the world could read it in their native language.

You can (and should) follow Galo on Twitter, and on his personal blog in either English or Spanish.

BTW – Galo is speaking at OOW14 too…

View original post 36 more words


Filed under: Uncategorized
Categories: DBA Blogs

Where is my space on Linux filesystem?

Surachart Opun - Mon, 2014-09-22 06: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.
If 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.
- Ted
Example: 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

Categories: DBA Blogs

Extend linux partition on vmware

Surachart Opun - Mon, 2014-09-22 03: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.
Checked 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-b5jUlW
I thought I should be able to extend (resize) /dev/sda2 - Found out on the Internet, get some example.

- 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-b5jUlW
Note: 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% /u02

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. 
Categories: DBA Blogs

Switch CentOS to Oracle Linux - centos2ol.sh

Surachart Opun - Fri, 2014-09-19 05: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... 
Categories: DBA Blogs

Larry Ellison Stepping Down as Chief of Oracle

VitalSoftTech - Thu, 2014-09-18 19:44
Larry Ellison, CEO of Oracle is finally stepping down! He’s not leaving Oracle but as part of succession planning will be moving into the Executive Chairman role. He is one of the co-founders of Oracle and started the enterprise in 1977. The CEO responsibility will be shared between Mark V. Hurd and Safra A. Catz. […]
Categories: DBA Blogs

Oracle Database 10g Certifications to Expire in March 01, 2015

VitalSoftTech - Tue, 2014-09-16 20:01
Oracle Database is one of the leading relational database management system and is used all over the world. It has various training’s, exams and certifications for its Database and other products. However due to regular update in Database, they have to redesign their trainings, certification and exams to add new features and to remove old […]
Categories: DBA Blogs

Top 7 Reasons Why Oracle Conferences Are A Waste Of Time

This page has been permanently moved. Please CLICK HERE to be redirected.

Thanks, Craig.Top 7 Reasons Why Oracle Conferences Are A Waste Of Time
Want to turn a lame Oracle Database conference experience into a great one? You may not believe this, but I think Oracle conferences are a waste of time. That is, unless I take action. I've been to hundreds of Oracle conferences, so I'm kind of an expert in this field.

Here is my "Top 7" list about why Oracle conferences are time suckers AND how you can turn them into a GREAT educational, social and networking experience.

Number 7. Sleeper Presentations. You forgot to read that session abstract before you sat down? You're not alone! Here my secret: Sit by the door. But when you walk out, remember that the speaker probably
knows how you feel but is doing they best they can. Out of respect for them and the poor souls who are actually enjoying the session, be quiet when you leave.

Number 6. My System Is Bigger Than Your System. How many times have we all heard someone talking about their, "50 node RAC global system with 5 million active users." Really? Is that even possible? Here are four proven options. Option 1 is to ask a question to shut them up. For example, "So how do you deal with the enqueue contention?" Another option is to simply walk away. If you feel that's rude, then Option 3 is to suddenly grab your phone to answer "that" call and walk away...never to return. If you're feeling feisty then combining Option 2 and 3 is wonderful. Ask the question "So how do you deal with upgrading 50 nodes?" AND THEN suddenly grab your phone and walk away.

Number 5. Not Another New Feature Presentation! Oracle Corporation and their marketing minions love to talk about futures. If you're depressed from hearing about new features you won't get to touch for the next five years, here's what to do. First, remember that Oracle Corporation user group sponsorship is important to user group conferences. Without the help from Oracle, most conferences would not occur. Second, the more Oracle sponsors an event, the more they influence the content. The money source always drives the content. The solution is to look at number of presentations given by non-Oracle employees versus Oracle employees... before you register.

Number 4. Can't Afford It Unless Oracle Sales Pays. Yes you can! I know training and traveling budgets have been cut. What you need is a free pass, right? I figured this one out while still working for Oracle. Submit an abstract to speak. If speaking freaks you out, click HERE. If you won't speak, then volunteer. Believe me when I say, EVERY CONFERENCE NEEDS VOLUNTEERS.

Number 3. Boring Conference. I totally get that. Want to know the secret about boring conferences? Avoid them...unless you take action. My conference of choice is Collaborate/IOUG. I love that conference... because I'm really involved, have been for years and look forward to working with the conference team and seeing them each year. It's kind of like family to me.

Number 2. I Feel Like A Dork. Because I speak a lot, people don't realize that much of the time I feel like a social idiot. Strange, but put me on stage or in a mentoring situation and I'm fine. It's taken me 20 years of conferences to figure this one out. Here's what to do: Go with a colleague or volunteer so you'll always have someone to hang out with. If that doesn't work and you're a guy, look for the stupid games because that's where you'll find DBAs just like you (and me).

Number 1. Stupid Drunks. I get so tired of drunk people yelling in my face! Especially when I can feel the spit from their mouths poke me in the eye. It only took a few years to figure this one out. The solution? Step back a couple of feet. And if that doesn't work, then walk away. Don't worry about offending them, because they won't remember you anyways.

Make It A Great Conference!

There you have it, my "Top 7" list about why Oracle conferences are time suckers AND how you can turn them into a GREAT educational, social and networking experience.

See you at IOUG this April in Las Vegas!

All the best in your Oracle performance work,

Craig.
Categories: DBA Blogs

NOFILENAMECHECK Parameter Causes DUPLICATE DATABASE To Ignore DB_CREATE_FILE_DEST?

Don Seiler - Wed, 2014-09-10 23:06
Last week I was creating a new testing database from a backup of our demo database, both under Oracle 11.2.0.3. I grabbed one of my old scripts to handle the duplicate function, which looked similar to this:

connect auxiliary /;
run {

        duplicate database to testdb
                backup location '$BACKUPDIR'
                nofilenamecheck;

}

One important difference between the demo database and this new test database is that the original demo database lives on a filesystem and the new database was to go onto ASM on a different host. I had copied the syntax from the old script and kicked it off. I made sure that the db_create_file_dest was set to the ASM diskgroup. However the restore would fail as RMAN tried to write to the filesystem path used by the original demo database, which didn't exist on this host, instead of the ASM diskgroup.



Definitely puzzling to me. I double-checked the documentation for NOFILENAMECHECK, which only suggested that it did a check for matching filenames, but didn't state that it would cause the issue I was seeing. The summary saying that it would prevent RMAN from checking for a name collision, which it does to prevent from overwriting existing files on the same host.

However what I found is that having NOFILENAMECHECK in my command resulted in RMAN restoring the files to the original path, ignoring my db_create_file_dest specifications. When I removed the NOFILENAMECHECK specification from the RMAN command, the files were restored to the ASM diskgroup as intended.

MOS Support documents 1375864.1 and 874352.1 suggest using the DB_FILE_NAME_CONVERT parameter but I found this was not necessary when I set the DB_FILE_CREATE_DEST parameter, as long as I didn't use NOFILENAMECHECK. I couldn't find anything in MOS about NOFILENAMECHECK forcing the restore to use a certain location though.
Categories: DBA Blogs

Getting Started with Windows VDI by Andrew Fryer

Surachart Opun - Wed, 2014-09-10 06: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

Categories: DBA Blogs

API Integration with Zapier (Gmail to Salesforce)

Kubilay Çilkara - Sun, 2014-09-07 12:42
Recently I attended a training session with +General Assembly  in London titled, What and Why of APIs. It was a training session focusing on usage of APIs and it was not technical at all. I find these type of training sessions very useful as they describe concepts and controlling ideas behind technologies rather than the hands-on, involved implementation details.

What grabbed my attention from the many different and very useful public and private API tools, 'thingies', introduced in this training session was Zapier. - www.zapier.com

Zapier looked to me as a platform for integrating APIs with clicks rather than code, with declarative programming. Is a way of automating the internet. What you get when you sign up with them is the ability to use 'Zaps', or create your own zaps. Zaps are integration of endpoints, like connecting Foursquare to Facebook or Gmail to Salesforce and syncing them. One of the Zaps available does that, connects your Gmail emails to Salesforce using the Gmail and Salesforce APIs and lets you sync between them. Not only that, but Zapier Zaps also put triggers on the endpoints which allow you to sync only when certain conditions are true. For example the Gmail to Salesforce Zap can push your email into a Salesforce Lead only when an email with a certain subject arrives to your gmail inbox. This is what a Zapier platform looks like:


An individual Zap looks like this and is nothing more than a mapping of the Endpoints with some trigger actions and filters.


The environment is self-documenting and very easy to use. All you do is drag and drop gmail fields and match them with the Lead, or other custom object Salesforce fields. Then you configure the sync to happen only under certain conditions/filters. Really easy to set-up. The free version runs the sync every 5 hours, well good enough for me. The paid version runs the sync every 5 minutes. 

There is even capability to track historical runs and trigger a manual run via the Zap menu. See below the 'Run' command to run a Zap whenever you like. 


In my case I used the tool to create a Zap to do exactly what I just described. My Zap creates a Salesforce Lead automatically in my Salesforce org whenever a 'special' email is sent to me. Great automation!

This is a taste of the 'platform cloud' tools out there to do API to API and App to App integrations with clicks and not code. With tools like Zapier all you really need is, imagination!

More links:

Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator - DBA Blogs