Switch CentOS to Oracle Linux – centos2ol.sh

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. (more...)

Oracle OpenWorld 2014 – XML and JSON presentations, meetings and Hands-On Labs

Oracle OpenWorld is about to start and I am looking forward to it. This year I will be able to learn and enjoy it a...

Read More

Larry Ellison Stepping Down as Chief of Oracle

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. […]

The post Larry Ellison Stepping Down as Chief of Oracle appeared first on VitalSoftTech.

Oracle Open World Schedule

I will be in San Francisco a little early this year and as I’m not longer an ACE Director, it’s to attend the IOUC, (International Oracle User Conference) at Redwood Shores on Sept. 25th and 26th.  I’ll be representing RMOUG for the two day event that has representatives from user groups from all over the world.  Our lovely host, Mary Lou Dopart and her team, will ensure we have another great (more...)

Private Cloud and Lifecycle Management with EM12c at OOW14

Yet again the monster that is Oracle Open World is about to take over San Francisco. I won’t be making it this year, but considering we had something like 60,000 attendees last year I’d hate to see what the numbers are gonna be this year! :)

To try and make it a little easier for you to find all the Private Cloud and Lifecycle Management with EM12c material, here are the ones I know about. If (more...)

Datafile space reclaimable report.

These script will help you find the space reclaimable in your datafiles, it finds the High Water Mark of all your datafiles (the minimum size) and then report the following information: Datafile Size Datafile HWM Percentage of space reclaimable Command to resize the datafile Total space reclaimable in your datafiles Percentage of space reclaimable in your datafiles Find space reclaimable [...]

The post Datafile space reclaimable report. appeared first on Oracle DBA Scripts and Articles (Montreal).

Enterprise User Security – Presentation Material available

On the presentations page you can find the my presentation material from DOAG regional meeting September 2014 in Munich about “Enterprise User Security”.

ORA-01123

I was reading through an old book recently and it said that you could not put a tablespace into hot backup mode if the database was in NOARCHIVELOG mode. This seemed reasonable to me but I wondered what might happen if you tried to do this so I ran the following SQL in an Oracle 11.2 database:  

SQL> l
  1* alter tablespace users begin backup
SQL> /
alter tablespace users (more...)

No Write Permission on ACFS Mount Point



Last night, I managed to create the ACFS Mount Point after resolving the issue "ACFS-9459: ASVM/ACFS is not supported on this os version". But, after creating the ACFS Mount Point, I'm unable to create or touch any files under this ACFS Mount Point.

Though, I tried to touch a file to create files under this ACFS Mount Point using OS User Oracle and Root, it's failing with the following error:

"touch: cannot touch `x': (more...)

ASM Diskgroup shows USABLE_FILE_MB value in Negative

Today while working on ASM diskgroup i noticed Negative value for USABLE_FILE_MB. I was little surprised as it has been pretty long that i worked on ASM. So i started looking around for blogs and mos docs and found few really nice one around. A negative value for USABLE_FILE_MB means that you do not have [&hellip

Understanding Flash: The Flash Translation Layer

electronics

A couple of posts ago in this series, I explained how a NAND flash die is comprised of planes, which contain blocks, which contain pages… which contain individual cells of data. Read operations take place at the page level, as do write operations (although we call them program operations in the flash world). But crucially, erase operations take place at the block level and so affect multiple pages.

Erases are also (more...)

Blog articles at Toad World


I just wanted to point you to the blog articles I've been posting over at Toad World in case you're wondering why there aren't many articles showing up here.

So, go take a look!

Karen's Toad World Blog

About index range scans, disk re-reads and how your new car can go 600 miles per hour!

Despite the title, this is actually a technical post about Oracle, disk I/O and Exadata & Oracle In-Memory Database Option performance. Read on :)

If a car dealer tells you that this fancy new car on display goes 10 times (or 100 or 1000) faster than any of your previous ones, then either the salesman is lying or this new car is doing something radically different from all the old ones. You don’t just get orders of magnitude (more...)

12c In-Memory on RAC

I started looking into In-Memory on RAC this week. Data can be distributed across RAC nodes in a couple of different ways. The default is to spread it across the available nodes in the cluster. So if you had a 2 node cluster, roughly 50% of the data in your table or partition would be loaded into the column store in each of the 2 instances.

SYS@dw1> alter table kso.skew inmemory;
 (more...)

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

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 […]

The post Oracle Database 10g Certifications to Expire in March 01, 2015 appeared first on VitalSoftTech.

Migrating to ASM

On the Maximum Availability Architecture website, there’s a paper on <awful term alert>Best Practices</awful term alert> for Database Consolidation. It’s a great paper, as you’d expect from the MAA guys (well, apart from that awful term alert I had to add! :) ). Since database consolidation is an area I work in a lot, I thought I’d start looking at implementing as much of their recommendations as I could in Enterprise Manager, which of course is (more...)

ps and top differences with HugePages

The Unix utilities ps and top report memory differently with HugePages than without.

Without HugePages ps seems to include the SGA memory under the SZ column:

UID        PID  PPID  C    SZ   RSS PSR STIME TTY          TIME CMD
... 
oracle    1822     1  0 846155 16232  0 07:19 ?        00:00:00 ora_d000_orcl
oracle    1824     1  0 846155 16228  0 07:19 ?        00:00:00 ora_d001_orcl
oracle    1826     1  0 846155 16236  0 07:19 ?        00:00:00 ora_d002_orcl
oracle    1828     1  0 846155  (more...)

ACFS-9459: ASVM/ACFS is not supported on this os version


After installing the Grid Infrastructure (GI) home on two Node RAC 11gR2 (11.2.0.4) on Linux 6.5 servers, I tried to create the ACFS filesystem using ASMCA tool to have Oracle (RDBMS) Home. But, the option tabs "Volumes" and "ASM Cluster File Systems" in ASMCA toll were disabled, due to this we were unable to create volume and cluster filesystem and got the following error:

"ACFS-9459: ASVM/ACFS is not supported on this (more...)

Oracle DBA Certification Upgrades its Upgrade!

In a recent post on Oracle Certifications, Matthew Morris  discussed the new DBA OCA to OCP Upgrade exams in his post on Release Jumping.  His post is thorough in explaining the benefits of jumping from Oracle 9i, or 10g or 11g OCA to 12c OCP, or from 9i OCA or 10g OCA to 11g OCP in […]

Book Review: Expert Consolidation in Oracle Database 12c

It's fair to declare up front that the author of this book, Martin Bach, is one of my best friends in the Oracle community (even though I haven't known him for that long really) and someone who I truly respect for all sorts of reasons, both professionally and personally. One of the personality traits I think we share is that, if we thought something was truly awful, we might not call it out as (more...)